Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks.Explore Intuit QuickBooks Workforce
jwilde8298
Level 1

Why do I keep getting an error message when attempting to upload a CSV of my bank transactions. They only have Date Description and amount and no other data or columns.

How do I upload a csv successfully? Other info: CSV creating in google sheets. Verified filename ends in csv. File size very small.

1 Comment 1
ElykaJen_A
QuickBooks Team

Why do I keep getting an error message when attempting to upload a CSV of my bank transactions. They only have Date Description and amount and no other data or columns.

Welcome to the Community, jwilde. Could you please provide the exact error message you receive? Any details you can share will help us better understand and resolve the issue.

 

QuickBooks requires specific formatting rules to follow via CSV or Excel file, and each bank may export files with different column labels and arrangements. If the columns in your CSV don't match what QuickBooks expects, or if there are any formatting inconsistencies, you may encounter an error during upload.
 

For a successful CSV upload, refer to this article to learn how to format your CSV files properly before uploading them to QuickBooks: Format CSV files in Excel to get bank transactions into QuickBooks.
 

Please note that these instructions apply to both QuickBooks Online (QBO) and QuickBooks Self-Employed (QBSE).

Feel free to reply to this if you have additional questions. We’re here to assist you. 

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

Need to get in touch?

Contact us