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.
sabar374
Level 1

import csv transaction

format for csv files

2 Comments 2
Chrea
Level 8

import csv transaction

What transaction type? bank statement or else?

 

KimberlyS
QuickBooks Team

import csv transaction

There are only two types of CSV file formats QuickBooks can handle, sabar374. Allow me to furnish you with the key information required to ensure you can upload your transactions seamlessly.

 

In QuickBooks Self-Employed, following the appropriate format when importing transactions is essential. These formats are the 3-column or 4-column.

 

The 3-column format includes the Date, Description, and Amount columns. Here's what it should look like:



 

On the other hand, the 4-column format contains Date, Description, Credit, and Debit columns. Refer to this image for guidance:



 

For more information, please visit this article: Format CSV files in Excel to get bank transactions into QuickBooks.

 

Once your file is prepared, follow this complete guide to upload your income and expenses: Manually import transactions into QuickBooks Self-Employed.

 

Moreover, take the time to properly categorize and organize all your financial activities. This method not only aids in assessing the progress of various business segments but also secures accuracy in your Schedule C reporting.

 

If you find yourself with any questions or concerns about importing and managing your transactions, feel free to jot them down in your reply. We’ll jump on it and get back to you promptly.

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

Need to get in touch?

Contact us