We have currently 3 bank accounts - Main Operating Account and 2 sub-bank accounts. The Main Operating account is set up in QuickBooks and linked with the bank. Transactions are imported from the bank and are then categorized.
We wanted the remaining 2 bank accounts also set up in QuickBooks and then linked with the bank. For this purpose, we created a new bank account in QuickBooks chart of accounts and tried linking the same with the bank through the Banking tab in QuickBooks. While the connection was successful and transactions were imported, we noted that transactions from the main bank account where also brought in again to QuickBooks leading to duplication. In order to resolve this, we deleted connection with the bank for the new account. However, we note that in the Balance Sheet, the new account has a carrying opening balance. Could you assist with the following query :
1. How do we rectify the carrying opening balance appearing under the new bank account in the Balance Sheet?
2. How do we set up the additional 2 bank accounts in QuickBooks, link both with the bank and import transactions only that pertain to these accounts?
I'd be glad to help and share some information regarding linking multiple bank accounts in QuickBooks Online, savita-clearnexu.
To rectify the carrying opening balance under the new bank account, you can edit Opening Balance Equity from the Chart of Accounts. Here's how:
Click Accounting in the left panel, and choose Chart of Accounts.
Find the new bank account and select View register from the Action column.
Search your register for an opening balance. It should have Opening Balance Equity in the Payee/Account column and Opening Balance in the Memo column.
You can enter and change the opening balance from there.
However, if there's no opening balance, you can delete it to rectify the amount. On another hand, before setting up additional 2 bank accounts, check with your bank first and see how they send the downloaded transactions.
If the statements are downloaded to one account, connect only the parent account. If they are imported to the individual accounts, you can add the 2 as sub-accounts under the parent account and link them. Here's how to add a sub-account:
Click Accounting in the left panel and choose Chart of Accounts.
From the Chart of Accounts screen, click New.
Choose the Account and Detail Type.
Enter the name of the account in the Name field.
Mark the box for Is sub-account.
Click on Save and Close.
To learn more about setting up parent, sub-accounts and connecting them into online banking, see the recommended articles below:
Thanks for the detailed note. I have already created one sub-account in our chart of account in QuickBooks. However, it was not defined as sub-account. Is there anyway I can edit the account set up to reflect this?