CSV download to Money import

[suj...@gmail.com]

I have switched to Capital One credit card. They only do CSV download of the statement. Anyway I can import this to Money (without manual entries)?

[Mark M]

I have a Capital One Credit Card and I download as QIF and MSMoney imports it fine. 

Mark

[S P]

Carl

The point is I do not get a QIF file - only CSV download option

On Wednesday, 11 October 2023 at 13:54:47 UTC+1 Cal Learner wrote:

I have not used a CSV file for downloading credit card transactions. Here is how I think it will go.
 
 Open Money, and File->Import->Downloaded Statement
 Select the QIF file, and choose Open in the "Import a File" window.
 
 Proceed from there. Tell us if there are any quirks that you run into. One thing is that if you have two identical transactions (as could happen if you bought the same thing twice on the same day), I think it will ignore the second one.
 
 Note that if you installed Microsoft Money since you installed software that also works with CSV files and associates with that file type during install, you could just double-click the CSV file to get started.

[S P]

Google did not come up with a good solution for Capital One card in UK. However, came across this video which helps a lot.

https://www.youtube.com/watch?v=B4aL7WYugC8

[Tom Roberts]

SP

You may need to select the modified version of xl2qif

Many people were having errors "Compile error in hidden module"

One of the users was able to crack the vba code and eliminate the error. 

He saved his cracked version in Dropbox and made it available to the public. 

See the comments section of the youtube link you posted for the dropbox link. 

--
You received this message because you are subscribed to the Google Groups "Microsoft Money" group.
To unsubscribe from this group and stop receiving emails from it, send an email to microsoft-mon...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/microsoft-money/3f4356b8-a75f-4575-8b4e-ddf05d9d8c9bn%40googlegroups.com.

[S P]

Tom

Thanks. Tried the "fixed" option as you mentioned and it works a treat!

[Chad Carlson]

Do you have to run it through this macro each time you import into MS Money?

Or is this a one-time fix for future imports?

What is the macro doing behind the scenes to fix the problem?

Is it a MS Money issue, or a change in how Chase or Capital are preparing the data?

Thanks a million for this help!

Chad

[Tom Roberts]

Yes, each downloaded statement would need to be converted. A few times doing it and you'd almost be able to do it eyes closed.

The macro runs within Excel so it works outside Money.

The only problem the macro fixes is to convert the csv file to qif. The qif file you import to Money as downloaded statement.

Then you're thankful that your 20 years of accounting data is still useful ! 

To view this discussion on the web visit https://groups.google.com/d/msgid/microsoft-money/a51652e0-1c70-4a33-bb35-efb4002028ecn%40googlegroups.com.