You can use a converter tool as a workaround. What file format does your bank provide? *.csv, *.pdf, or else?
A
Anonymous
June 15, 2024
Let me help add your bank transactions manually in QuickBooks Online, @Sami.
To import information into QBO, you need to use a CSV (Comma Separated Values) file. Each bank formats CSV files differently, so ensure it meets QuickBooks requirements to avoid issues.
You can upload CSVs with either a 3-column or 4-column format. QuickBooks can only handle these specific columns in this order. The 3-column format should include Date, Description, and Amount columns. The 4-column format should include Date, Description, Credit, and Debit columns.
When the file is formatted correctly, you can manually upload the transactions. Here's how:
Sign in to your QuickBooks Online account.
Hover your mouse to Transactions, then click on Bank Transactions.
In the Link account drop-down, select Upload from file.
Select the Drag and drop or select files button and then choose the file you downloaded from your bank. Then hit on Continue.
In the QuickBooks account dropdown, select the account you want to upload the transactions into. Then click on Continue.
Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks, then click on Continue.
Once everything's set, make sure to check out these articles that'll walk you through the steps to categorize your transactions and reconcile your account seamlessly: