Showing results for 
Search instead for 
Did you mean: 
Sheen Solutions
Level 2

How do I post bank manually to quick books

How do I post  bank amount manually in quick books as I am unable to upload . My bank account has several columns.

Kristine Mae
QuickBooks Team

How do I post bank manually to quick books

Let me help you get around with it, Sheen Solutions.


In QuickBooks Online, you can import bank transactions through WebConnect or Excel CSV files. Then, we only use the 3-column and 4-column formats. Since you've mentioned that your bank provides several columns, you can reformat it and take out the ones that aren't necessary.


If you select the 3-columns format, you only need to have the DatesDescription, and Amount columns. While the 4-columns format, you need the DateDescriptionCredit, and Debit columns.


Although, if you're unable to take out the excess columns, you can enter the transactions manually, and ensure you use the bank account. Create either an expense, cheque, or bill for the money-out transactions. Then, create an invoice, sales receipts, or deposit for the money-ins.


If there's anything else that you need, please get back to this thread. We're just a comment away.

Sheen Solutions
Level 2

How do I post bank manually to quick books

I need the  four columns. How do I  get this as I am seeing  three  row when I export it.  I need  to have  debit and credit shown  differently, so  I need date description debit and credit.

QuickBooks Team

How do I post bank manually to quick books

You'll have to reformat your Excel CSV template to a 4-columns to have the debit and credit column, @Sheen Solutions.


This way, you can upload your bank transactions in your QuickBooks Online (QBO) account. Let me guide you how:

  1. Sign in to your bank or credit card's website and follow the instruction on how to download your transactions.
  2. Ensure to download the file as a CSV file.
  3. Open the downloaded file and add a debit and credit column.
  4. Then save the changes made to the file.

Once done, you can now upload the CSV file in your QuickBooks Online (QBO) account. To do so, you can refer to the steps below:

  1. Go to the Baking or Transactions menu.
  2. Select the Banking tab.
  3. Choose the account you want to upload the transactions into.
  4. Select the Update drop-down menu and then File upload.
  5. If your account is not connected to online banking, select Upload transactions.
  6. Click Browse and select the file you downloaded from your bank and select Next.
  7. Choose an account from the QuickBooks account drop-down menu.
  8. Map the columns on the file with the banking fields in QuickBooks and click Next1.JPG
  9. Then click Let's go when ready.

You can also read through this article for more detailed steps on manually uploading transactions into QBO.


Now that you've imported your bank transactions in your QBO account, you can now categorise them and reconcile your accounts.


In case you have other questions regarding your bank feeds in QBO, you can always tag me in. I'm more than happy to be of help. Keep safe!