Skip to main content
November 18, 2023
Question

Different op. cash balance from PY t2 and bank statement.client connected the bankexistence of op. balance equity.how to fix?

  • November 18, 2023
  • 1 reply
  • 0 views
new client set up on QBO. 

client connected bank account before we could input op cash balance ( from prior year T2) into Chart of accounts.

result - different cash balance from PY T2 and bank statement. 

Purpose - same op balance sheet figures in QBO as in PY T2. 

need to fix before we proceed with bookkeeping.

1 reply

November 20, 2023

Hi haider-palmuplif,

 

Welcome to Community!  When you connect a new account in QuickBooks Online, you'll have the option to select a date to start tracking transactions, and enter the balance for your real-life account for that date.  When this step has been skipped or missed, don't worry, you can create a journal entry to record the opening balance, so you're back to business in no time.  I'd be glad to assist!

 

Let's start by ensuring there isn't an opening balance, by following these steps;

 

1. Open your Settings ⚙ and select Chart of accounts

2. Locate the account and select Account history from the Action column

3. Search for an opening balance entry. In the Payee Account column, it should say Opening Balance Equity, and in the Memo column, it should say Opening Balance.

 

Here's how to create a journal entry for the opening balance;

 

1. From the left menu select +New, then Journal entry

2. Enter a Date that comes before the oldest transaction in the account. This will be the opening balance date.

3. In the first row under the Account column, use the drop-down menu to choose the account you want to enter the opening balance for

4. Enter a note in the Description field so you know what the journal entry is for (optional)

5. In the second row under the Account column, use the drop-down menu and choose Opening Balance Equity

6. Use your bank statements to enter the opening balance. Enter the balance of your real-life account for the date you picked as the opening balance. You'll need to enter both a debit and a credit to keep things accurate. Enter the debits and credits based on the type of account you entered on the first line
7. When you're satisfied, hit Save and close.

 

If you have any other questions, please don't hesitate to reach out again.  We would be glad to happy to help!