Skip to main content
November 5, 2022
Question

Csv upload is not working. I use this to add cash transactions. The file is the exact same format that worked previously. Has something changed in csv upload?

  • November 5, 2022
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

November 5, 2022

Hi there, amit_tanwar. Let's make sure you can import those transactions into QuickBooks Self-Employed.

 

To avoid errors when importing CSV files, only use the 3-column or 4-column formats. These are the only columns QuickBooks can handle and this order. I've attached a sample screenshot in CSV format below:

 

 

You should also keep the following things in mind:

 

  • Any transactions with numbers in the Description column should be corrected.
  • Remove any (0) zeros from the file. Leave those cells empty.
  • They should only say "Credit" and "Debit," with no word "amount". If the word "amount" appears in the Credit or Debit column header, remove it.
  • Make sure the dates are all in the same format. We recommend using: dd/mm/yyyy.
  • Some financial institutions include the day of the week in the Date column (for example, 20/11/2018 TUE). the day of the week must be removed.
     

Furthermore, the transactions in the CSV files for credit card accounts might appear in reverse. For instance, deposits may appear as negative amounts because paying your credit card balance reduces your balance. Also, be sure to choose the appropriate credit card account (not a bank account) when uploading the file.

 

I've included this article so you can review the transactions you imported and ensure there are no duplicates: Add older transactions to QuickBooks Self-Employed. Go directly to Step 4: Review what you imported for the detailed steps.

 

Keep in touch if you have any further questions about uploading your bank transactions into QuickBooks. I'd be delighted to assist. Thank you for joining the Community and have a wonderful day.

November 12, 2022

I tried today with the same files as before and it worked. Looks like something was broken on the backend. 

Fiat Lux - ASIA
November 13, 2022

@amit_tanwar 

Utilize the trial version for csv2qbo converter tool to isolate the problem.

https://www.moneythumb.com/?ref=110