Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
March 31, 2026
Question

I am uploading a file for bank transactions . I get an error Your file does not contain the three required columns: transaction date, memo and amount.

  • March 31, 2026
  • 1 reply
  • 4 views
No text available

1 reply

QuickBooks Team
March 31, 2026

Hello David, when you upload your bank transactions, which file format do you use? QuickBooks supports files in CSV, QBO, and QFX formats. The error you encountered is due to QuickBooks not recognizing the column headers in your CSV file. Ensure it has the required columns for transaction date, memo, and amount.

 

To resolve this issue, change the headers in the first row to Date, Memo, and Description. Additionally, consider using a different browser, as stored data in your current browser may interfere with the upload process. Alternatively, you can import the transactions into QuickBooks by clicking the Gear icon in the upper right corner and selecting Import data from the Tools menu.

 

If you have successfully uploaded your transactions to QBO, they will appear in the Bank transactions page under the Pending tab.


Let us know in the comment section below if you have any additional questions.