Limited time. 50% OFF QuickBooks for 3 months.

Buy now & save
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.
erin82
Level 1

Can you help me import a .csv file?

It doesn't like my file for some reason. What is the perfect format it needs to be in?

2 Comments 2
Chrea
Level 8

Can you help me import a .csv file?

What data type do you need to import? Bank statement or else?

AntoniettaE
QuickBooks Team

Can you help me import a .csv file?

It’s a pleasure to have you here in the Community space, Erin. Please note that each bank configures CSV files differently. I’ll offer some insights on the correct file format to ensure your transactions are successfully imported.
 

QuickBooks Self-Employed supports uploading CSV files in either a 3-column or 4-column format. The 3-column format includes date, description, and amount.

image (28).png

On the other, the 4-column format comprises date, description, credit, and debit amounts.

image (29).png

For more detailed information, check out this article: Format CSV files in Excel to get bank transactions. While this is intended for QuickBooks Online, the same concepts can also be applied in QuickBooks Self-Employed.
  

Once you're ready, here's how to import your transactions:

  1. Go to the Profile icon and choose Imports.
  2. Select Import transactions.
  3. Follow the onscreen steps to upload the file.
  4. Hit Import.

    image (32).png

 

On the other hand, you can connect your bank account to QBSE to automatically download all your transactions.
 

Additionally, I'll add this article to maintain organized financial records and streamline your bookkeeping process for the future use: Categorize transactions in QuickBooks Self-Employed.
 

Consider this thread your go-to resource whenever you have questions about importing CSV file. You can also create a new discussion here in the Community space for assistance.

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

Need to get in touch?

Contact us