Credit comes in as debit in Microsoft Money

Issue summary: 

See attached CSV file. Debits from my credit card download come into Money perfectly but credits come in as debits. In the below example I changed mapping to TYPE but this does not work.

I'm very happy with this tool however currently I'm having to manually check for credits and cut and paste them them manually in Money from the charge column to the Credit column.

Component: 
Miscellaneous
Reporter: 
Stefan
Created: 
Mon, 07/16/2018 - 12:46
Updated: 
Sun, 10/14/2018 - 01:06

Comments

I see, the entry is 'CR' but type only detects 'C' or 'D' for Credit and Debit respectively.

As an workaround, you can change the columns that contain 'CR' to 'C' for now. I will update the code to accept 'CR' too.

PS: I assume you are ticking the box on Step 3 that says "This is a Credit Card statement"

I re-tested your CSV again.

I noticed that it has a column that defines the Type of transaction i.e CR for credit

I mapped the file as seen below and it worked

Also, on the Step 3 you need to specify its a credit card