cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want an expert to help you set up your QuickBooks Online? Find out how: Click here
sami-expand-ksa-
Level 1

How to enter bank account information manually

My country does not allow automatic connection to bank. how can I enter this information manually
2 Comments 2
4Gal
Level 11

How to enter bank account information manually

You can use a converter tool as a workaround. What file format does your bank provide? *.csv, *.pdf, or else?

 

Eman_E
QuickBooks Team

How to enter bank account information manually

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:

 

  1. Sign in to your QuickBooks Online account.
  2. Hover your mouse to Transactions, then click on Bank Transactions.
  3. In the Link account drop-down, select Upload from file.
  4. Select the Drag and drop or select files button and then choose the file you downloaded from your bank. Then hit on Continue.
  5. In the QuickBooks account dropdown, select the account you want to upload the transactions into. Then click on Continue.
  6. Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks, then click on Continue.
  7. Choose the transactions you want to import.
  8. Tap Yes.
  9. Once okay, click on Done.

 

You can read this article for more details about uploading your transactions: Manually upload transactions into QuickBooks Online.

 

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:

 

 

I'm all ears if you have other queries about importing transactions in QuickBooks Online. Don't hesitate to reach out. Stay safe always.