Excel->Quicken conversion
Z Man
satisfactory answer. I maintain my bank account in an Excel spreadsheet.
Data is downloaded from Citibank. Each month, I convert my data to qif and
import into Quicken. I have been using this procedure since 1995 and it
works well for me. However, I started experiencing a problem in 2000, in
that my macro (developed by Microsoft for MS Money several years ago) would
import the dates in the format xx/xx/xx, which Quicken read as 1900 unless I
manually edited the qif file into xx/xx/20xx format. A pain, but I could
still do it.
Now, the situation has become far worse. Excel 2002 won't use this old
conversion macro at all. If I don't find a solution, I will be faced with
manually entering about 70 transactions per month that are already in an
Excel spreadsheet.
So, to make a short story long, does anyone have a good, modern macro to
convert Excel bank account data into qif format? If any of you using Quicken
2002 are reading this, does the new version help at all?
Han Broekman
I download Citibank data directly into Quicken, and have been doing this
for a LONG time with great success. I'm still using Q2001, and have had
99 and 2000 (I think I skipped 98). The direct download into Quicken
has delay between a half and 1 day compared with the availability of
data on Direct Access, and may cost $9.95/month if you can't get an
"Everything Counts" account, which requires 10K in combined balances.
You can also download Citibank data via Direct Access. Either one
account at a time, or for all your accounts at the same time. This can
be done in a big choice of formats: QIF for Quicken98, other qif, OFX,
QFX, or .csv. I presume you're using .csv. I suggest you try one of
the other formats as well, depending on your preferences and Quicken
version. The big advantage of the later versions of Quicken is the
ability to interpret qif files like OFX, and perform the matching
process, which I like (mostly).
HTH
--
Best regards
Han Broekman
(Please answer to the newsgroup only, I will not answer email)
Z Man
"Han Broekman" <j.bro...@verizon.net> wrote in message
news:3B7FC826...@verizon.net...
>
> I download Citibank data directly into Quicken, and have been doing this
> for a LONG time with great success. I'm still using Q2001, and have had
> 99 and 2000 (I think I skipped 98). The direct download into Quicken
> has delay between a half and 1 day compared with the availability of
> data on Direct Access, and may cost $9.95/month if you can't get an
> "Everything Counts" account, which requires 10K in combined balances.
>
> You can also download Citibank data via Direct Access. Either one
> account at a time, or for all your accounts at the same time. This can
> be done in a big choice of formats: QIF for Quicken98, other qif, OFX,
> QFX, or .csv. I presume you're using .csv. I suggest you try one of
> the other formats as well, depending on your preferences and Quicken
> version. The big advantage of the later versions of Quicken is the
> ability to interpret qif files like OFX, and perform the matching
> process, which I like (mostly).
I have been using Direct Access almost since its inception. I have never
paid for it, and I am the world's biggest fan of Citibank's online service.
It is second to none. However, I prefer to maintain my checking activity in
an Excel spreadsheet, and then import it into Quicken, rather than importing
it into Quicken. I frequently use Excel to do a quick search, or manipulate
the data for further analysis.
I don't mind the extra work of importing from Excel into Quicken if I don't
have to manually retype all the data. I suppose I could download into Excel
using the csv format, then re-download into Quicken using a format supported
by Quicken. However, that raises two problems: (1) I would have to manually
enter the payee on any hand written checks into Quicken, and even worse (2)
I would have to breakdown in Quicken all deposits that contain more than one
check.
One advantage I have by using Excel is that I do the deposit breakdowns, and
enter the check payee, in my Excel worksheet. I make certain it balances to
Citibank's balance prior to importing into Quicken. That way, all I have to
do in Quicken is the category for each check and deposit item.
So, I'm still looking for an updated macro...
Han Broekman
I quit using a spreadsheet for financial data when Appleworks templates
weren't sufficient for me anymore, back on my //e. I happily upgraded
to Dollars and $ense (or was that after the switch to MS? I really find
the possibilities of screwing up in a spreadsheet too easy (for me). I
never got the knack of protecting sheets/cells properly.
Sorry. I hope you can get your macro translated into VB, where I
believe macros are now maintained.
John Pollard
> So, to make a short story long, does anyone have a good, modern macro
to
> convert Excel bank account data into qif format? If any of you using
Quicken
> 2002 are reading this, does the new version help at all?
Why not try one of the Excel newsgroups? I have gotten several good
macros from one them and I can't believe that if what you want is
possible, they wouldn't know how. The group I have used is
"microsoft.public.excel.misc ".
Z Man
> Sorry. I hope you can get your macro translated into VB, where I
> believe macros are now maintained.
Yeah, me too :)
Z Man
"John Pollard" <j_po...@nixthespam.mindspring.com> wrote in message
news:9lpl62$7qu$1...@slb7.atl.mindspring.net...
That's the one I've tried, as well. This macro would be a piece of cake for
those guys. Although I've gotten a lot of excellent advice/assistance in
that venue, I've received no response to my requests for this macro.
However, I haven't tried for a while, so maybe I'll try again now.