Problem uploading CSV files - only part of file being read

  • 2
  • Problem
  • Updated 3 years ago
  • In Progress
I'm having problems uploading transactions to good budget from CSV files i've downloaded from my bank account - every time i try it it only reads a few, or sometimes none of the transactions e.g. the one i've just attempted has 77 transactions in the CSV file but good budget tells me it has read only 12 when i uploaded. The same thing happened last month and i had to do it in small batches to get it to work which took about three times as long as it should have. Also it doesn't seem to follow any pattern - it picks different transactions nearly every time even with the same file. Can you please let me know what the problem might be as this makes good budget totally unusable for me. Thanks
Photo of Paul Braithwaite

Paul Braithwaite

  • 2 Posts
  • 0 Reply Likes
  • frustrated

Posted 3 years ago

  • 2
Photo of Sandra L. Milo

Sandra L. Milo

  • 87 Posts
  • 26 Reply Likes
YES! This happened to me too. I tried exporting files from my bank with varying date ranges, but it didn't help. There were always transactions that were not read.
Photo of Sandra L. Milo

Sandra L. Milo

  • 87 Posts
  • 26 Reply Likes
Retraction! First, I use the OFX file to import, not CSV.

I more carefully reviewed the transactions that 'weren't matching or finding the transaction in GoodBudget' In each case, they were duplicate entries (both myself and my husband entered the same purchase). One entry was cleared but the duplicate, not, so they appeared as unmatched when importing bank transactions.

Operator error. :/
Photo of Karisa Russell

Karisa Russell, Official Rep

  • 1752 Posts
  • 233 Reply Likes
Hi Sandra, 

No worries! Thanks for clarifying!
Photo of Karisa Russell

Karisa Russell, Official Rep

  • 1752 Posts
  • 233 Reply Likes
Hi Paul, 

Sorry for the troubles! Have you imported a similar date range before? If so, it sounds like you've already imported those transactions, so they should not appear again on the import screen. 

When you import a CSV file, Goodbudget gives each transaction an identifying number, called a FITID, so that it can track which transactions have been imported before so you don't create duplicates. 

If that's not what you're experiencing, can you email us at support@goodbudget.com and send us two CSV files with some overlap in date ranges? That way, we can test the files and see if Goodbudget is reading them incorrectly. 

Just be sure to remove any account information before sending it to us. 

Thanks!
Photo of Paul Braithwaite

Paul Braithwaite

  • 2 Posts
  • 0 Reply Likes
Thanks but these are definitely new transactions, i haven't imported any of them before and they haven't been entered manually via the app either. In any case wouldn't they show up in the number of matched transactions. My latest attempt said 12 transactions read and 0 matched even thought there were 77 transactions in the sheet, none of which had been imported previously.

I will send the CSV file to the support address