transfer Quicken data to QlikView ?

[mschreiber]

Hello,

do anyone use Quicken, the software solution for financial administration and bank account ?

I want to analyse my transactions from Quicken 2010 in QlikView. I found only a way to export to a QIF format, but this structure I can't import to QlikView.

Anyone a solution or an idea for this ?

Bye

Mathias

[#2 · Accepted solution]

Mathias,

Check this page: http://quicken.intuit.com/support/articles/data-file-management/import-and-export/5989.html

Under the notes section, there is information about exporting to Excel, which QlikView should have no problem with

[mschreiber]

Jason,

thanks for the link - I checked it. The idea is good: creating a report in Quicken and export this to a spreadsheet. It will solve my problem. I was looking for a way to export directly, but this is another possible way.

Thanks a lot - bye Mathias

[jlassell]

Mathias,

Here is a QVW that will read a QIF file. It is intended only for "Bank" accounts -- not "Investment" accounts. I use Quicken 2008 right now and don't know if the QIF format is different for 2010. I don't have a "format" for the QIF file. I just used trial and error to figure out what the records lines referred to.

The key for me to create this was QlikView's PEEK command. It allows the file to be read into memory and then use another table but reference back to the original read to help determine "where you are" in the file.

Below is a Sample QIF file.

-Jeff

!Option:AutoSwitch
!Account
NBofA - Savings
TBank
D#22203-04995
^
NBofA - Checking
TBank
D#23822-04643
^
!Clear:AutoSwitch
!Option:AutoSwitch
!Account
NBofA - Checking
D#23822-04643
TBank
^
!Type:Bank
D2/ 4' 9
U200.00
T200.00
CX
POpening Balance
L[BofA - Checking]
^
D5/24' 9
U-8.95
T-8.95
CX
PBankOfAmerica
Mchecks
LChecks
^
D5/24' 9
U-80.95
T-80.95
CX
PPower Company
MMay
LUtilities
^
D3/15' 9
U495.64
T495.64
C*
PJoe's Sandwich Shoppe
LSalary
SSalary
$576.92
STax:Fed
$-15.15
STax:State
$-22.00
STax:Soc Sec
$-44.13
^
!Account
NBofA - Savings
D#23803-04643
TBank
^
!Type:Bank
D2/ 4' 9
U1000.00
T1000.00
CX
POpening Balance
L[BofA - Savings]
^
D2/ 9'10
U350.00
T350.00
CX
PVacation
LVacation
^

[mschreiber]

Hello Jeff,

I downloaded your qvw and created one qif export file for an bank account with my Quicken 2011. The QlikView script works well. I changed some small things, like the format of date (it is in the german QIF export format with delimiter . and not /).

I study your script and I must admit, that I not understand all commands. But so on weekend I will learn some new QlikView commands with your script. Thank you very much.
Mathias

[jlassell]

Gern geschehen!

You can email me directly at jefflassell@yahoo.com if you have any questions.

[#7]

Hi Mathias,

can you share your last version of your file ?

Thanks

castrini@gmail.com

[mschreiber]

Hello, attached the qifreader.qvw modified by me, working with german version of Quicken 2011.