Skip to main content
June 23, 2021
Question

IMport from bank has incorrectly added items as Received instead of Spent.

  • June 23, 2021
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

June 23, 2021

Hi there, datc42.

 

Welcome back to the QuickBooks Community. I'll share details so you're able to get past these reversed transactions that show as Received instead of Spent so you can get back to business.

 

Based on your statement provided, it seems that you've manually imported your bank entries via CSV. With this, the file could be formatted incorrectly that's why entries from your bank have incorrectly added items as Received instead of Spent. I suggest checking the file setup or mapping of your Credit or Debit column. Also, make sure that your file doesn’t break the following formatting limitations:

 

  • Special characters are not allowed.
  • Zeros (0) are not allowed anywhere in the file.
  • Correct any transactions that display an amount in the Description column.
  • Remove the word amount if it appears in the name of the Credit or Debit column.
  • MAC  users must save the file as a Windows CSV file.
  • Correct and standardize the Date format to a single format (for example, dd/mm/yyyy).
  • Some banks provide the day of the week and include it in the Date column (for example, 20/11/2018 TUE in column A) which is not an acceptable format. To correct this, split the date and the day of the week in two separate columns.

 

For additional information, here’s an article that you can check on: Format CSV files in Excel to get bank transactions into QuickBooks.

 

Then, you'll need to exclude those transactions that were transmitted to QuickBooks to avoid double data. You can click this article to see the detailed steps on how to perform the process: Exclude a bank transaction you downloaded into QuickBooks Online.

 

Once done, you can open this link to view information on how you can get again the transactions from your bank or credit cards and manually re-import them into QuickBooks Online: Manually upload transactions into QuickBooks Online.

 

Please check this article to view different banking errors and how to fix them: Fix bank upload errors in QuickBooks Online.

 

As always, you can reach back out if you have further questions about importing transactions in QuickBooks Online. I’d be happy to answer it for you.