M tryin to load my bank statements manually with CSV file but i keep getting "Your file does not contain the three required columns: transaction date, memo and amount."

lbsconsultant003 · ‎March 31, 2025

ClaireSamanthaS

To successfully upload your bank statements to QuickBooks Online (QBO), you have to follow the correct CSV format. Let me provide further information on this below.

Before uploading, please check if the data is formatted properly. Banks use different formats for .CSV files, which may not align with QuickBooks requirements, preventing some imports.

You can upload CSVs in either a 3-column or 4-column format. QuickBooks only accepts these specific column arrangements.

The 3-column format: This format has a Date, Description, and Amount column:

The 4-column format: This format has a Date, Description, Credit, and Debit column:

After using the correct formats, you can now successfully upload your bank statements to QBO. I'll provide the article that serves as the reference above: Format CSV files in Excel to get bank transactions into QuickBooks.

Once done, refer to these guides for easy steps on how to categorise transactions and reconcile your account:

As always, our Community Forum is available if you have any inquiries or questions about managing and uploading your transactions. You can circle us back by clicking the Reply button below, and I will assist promptly.

Topics

Training

Community

Resources

M tryin to load my bank statements manually with CSV file but i keep getting "Your file does not contain the three required columns: transaction date, memo and amount."

M tryin to load my bank statements manually with CSV file but i keep getting "Your file does not contain the three required columns: transaction date, memo and amount."