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."

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:

• Categorise online bank transactions in QuickBooks Online
• Reconcile an account in QuickBooks Online

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.