cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Need help with the 25/26 payroll year-end?Ask Us Anything
sarah210
Level 1

I have downloaded a csv file from my bank account and it will not upload to quickbooks?

 
1 REPLY 1
Jv_D
QuickBooks Team

I have downloaded a csv file from my bank account and it will not upload to quickbooks?

Hi there, sarah210.

 

Let's work together to successfully import your CSV file into QuickBooks Self-Employed (QBSE).

 

First off, may I know if you received any error when importing and which bank you’re using? If so, please share us the details so I can assist you effectively.

 

For now, if you received an error while importing, it means your CSV file's formatting is incorrect or doesn’t meet QuickBooks requirements. I recommend ensuring your CSV follows the correct format before uploading transactions. Here are the two formats you can use:

 

  • The first is where columns include the Date, Transaction name/description, and Amount. The date format should be DD/MM/YYYY, and the amount column should show the figures with a plus or minus symbol so the program can see if it's income or an expense.
  • The second is similar to the first. The CSV can have four columns: Date, Transaction name/description, Credit, and Debit. Again, the date format should be DD/MM/YYYY.

 

You can learn more about CSV formats by checking out this article: Format CSV files in Excel to get bank transactions into QuickBooks. While the guide is for QuickBooks Online, the same process applies to QBSE.

 

If you have further questions, please leave us a reply below.

Need to get in touch?

Contact us