Home → Problems →

This won't Import

• Edit

agabhart36

12 Feb, 2026 09:55 PM

I have this transaction in a csv file that won't import
Here's the line

8/10/2024,ONLINE CREDIT CARD PMT 08/10 XXXX4861,100.00

It has the correct commas.

1. 1 Posted by dwg on 12 Feb, 2026 09:57 PM

   

   The field "XXXX4861,100.00" looks problematic, it is alphanumeric, whereas it looks as if it should just be a numeric.

   • Edit

2. 2 Posted by dwg on 12 Feb, 2026 10:03 PM

   

   Also you cannot have commas between fields then have commas embedded in the number so would suggest it does not have the correct commas.

   • Edit

3. 3 Posted by agabhart36 on 12 Feb, 2026 10:13 PM

   

   When I do a search with MS Notepad for commas, it doesn't find any uhm hidden commas.
   I put a space in after 4861, and tried a couple of other things, and it still won't import. The line after that imports easily, and merges

   • Edit

4. 4 Posted by dwg on 12 Feb, 2026 10:18 PM

   

   Show us the actual lines as they appear in the CSV file. Not edited lines.

   • Edit

5. 5 Posted by agabhart36 on 12 Feb, 2026 10:22 PM

   

   10/4/2024,ONLINE CREDIT CARD PMT 10/04XXXX ,150
   10/15/2024,Interest charged,-4.09

   I eliminated the 4861 with no change.

   I have another line where the date's year is changed to 2025, and it's the only line in the file
   12/11/24,AMAZON MKTPL*ZX9ZJ3K32 Amzn.com/bill WA,-50.83

   • Edit

6. 6 Posted by dwg on 12 Feb, 2026 10:49 PM

   

   I had no issue importing the two transactions

   • CC_-_test_001.png 40 KB
   • Edit

7. 7 Posted by -Kevin N. on 12 Feb, 2026 10:50 PM

   

   Hi agabhart36,

   Can you confirm that you are selecting the following fields during the import process.
   Date
   Description
   Debit Amount

   Make sure to use the 'Fewer Fields' button so that there are only the 3 requisite fields displayed in the importer.

   -Kevin N. (not a member of Moneydance suppport)

   • Image1.jpg 30.9 KB
   • Edit

8. 8 Posted by agabhart36 on 12 Feb, 2026 10:53 PM

   

   almost. I use amount.
   I'll try debit for the Amazon

   Nope it didn't change anything, and the funny thing is it offers for the Amazon transactions Year, month, day. I changed the year from 24 to 2024 and it still offers d'base style.

   • Edit

9. 9 Posted by agabhart36 on 12 Feb, 2026 11:04 PM

   

   I eliminated the extra fields and it didn't change anything. Maybe if I reboot Windows

   • Edit