cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
info761
Level 1

I do not want to connect to the bank via QuickBooks. How do I enter bank account, make entries and reconcile manually?

 
1 Comment 1
Jen_D
Moderator

I do not want to connect to the bank via QuickBooks. How do I enter bank account, make entries and reconcile manually?

It's great to see you here, @info761,

 

You can add your bank transactions in QBO without connecting them through online banking. First, set up the Bank in the Chart of Accounts.

 

Here's how:

  1. Go to theSettings ⚙ icon and select Chart of Accounts.
  2. Press New, then pick an account type (Bank).
  3. Locate the detail type that fits your account or the transactions you want to track.
  4. Add the Account Name.
  5. Complete the account details and hit Save and Close when done.

Next, download the data from the bank, then map the transactions in the following supported file types:

Once the bank file is ready, start importing the file to your QuickBooks Online company. Follow these steps:

 

  1. Click Banking from the left navigation panel.
  2. Pick File Upload from the Update drop-down menu or Upload transactions manually if there isn’t any bank connected to QBO.
  3. Select Browse and choose the file you downloaded.
  4. Choose an account from the list, then Next.
  5. Follow the on-screen instructions to map the fields.
  6. Select the transactions to import.
  7. Click Yes.
  8. Hit Let’s go.

For the information and steps on importing these files, see this article: Manually upload transactions into QuickBooks Online.

 

Once you have the transactions brought into the program, you can now start the reconciliation process. See this article for the steps: Reconcile an account in QuickBooks Online.

 

 

You can also refer to the video tutorials in this link: Video tutorials for QuickBooks Online.

 

If you have additional questions about this or need help with anything in QuickBooks, let me know in the comment. I'll be right here to help. Have a nice day!