Banking
Thanks for joining the Community and getting involved with this thread, sugamo.
When you download CSV files of transactions from your financial institution, the data provided in them is coming from your bank. If debit transactions are for some reason listed as credits, I'd recommend getting in touch with them to identify why they're listed that way.
It's also recommended that you check the file's formatting prior to uploading it into your books. CSV files can be uploaded with 3-column or 4-column formatting.
These are the only columns QuickBooks can handle, and they have to be put together in the following order:
- 3-column format - This format has Date, Description, and Amount columns.
- 4-column format - This format has Date, Description, Credit, and Debit columns.
If you see an error message while uploading a CSV file, you may need to fine tune your formatting:
- If you use Mac, save the file as a Windows CSV file.
- Remove any zeros (0) from the file. Leave those cells blank.
- Correct any transactions that display numbers in their Description column.
- Confirm your dates are in one format. Intuit recommends using dd/mm/yyyy formatting.
- Remove the word "amount" if it appears in your Credit or Debit column headers. They should only read "Credit" and "Debit", without the word "amount".
- Some banks add the day of the week in your Date column. For example, "20/11/2018 TUE". You'll need to remove any days of the week ("TUE") from this column.
I've also included a detailed resource about formatting CSV files which may come in handy moving forward: Format CSV files in Excel to get transactions into your books
Please don't hesitate to send a reply if there's any questions. Have an awesome day!
