SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends June 27

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
amit_tanwar
Level 1

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?

 
3 Comments 3
Archie_B
QuickBooks Team

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?

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.

amit_tanwar
Level 1

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?

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

Fiat Lux - ASIA
Level 15

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?

@amit_tanwar 

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

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

 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us