QuickBooksHelpIntuit

Fix issues for accounts you've reconciled in the past in QuickBooks Online

by Intuit•50• Updated 4 days ago

Each time you start reconciling an account, you review the beginning balance in QuickBooks. It's the amount in the account at the beginning of the time period you're reviewing. Think of it as a checkpoint. It lets you know if you're starting with accurate numbers.

If the beginning balance doesn’t match, QuickBooks can help you find and fix the issues.

Learn what causes beginning balance issues

Entered an incorrect opening balance when they created the account in QuickBooks.
Added transactions that are older than the opening balance, but didn't edit the original opening balance entry to reflect the change.
Edited, deleted, moved, or unreconciled an already reconciled transaction. This changes the ending balance of your last reconciliation, which impacts the beginning balance of the next one.
Manually reconciled a transaction, so it didn't show up on the next reconciliation.

Troubleshooting Tips:

If you've never reconciled this account before, don't follow these steps. Here's what to do‌ the first time.

If you're new to the entire process, start with our guide.

The beginning balance amount should match what's on your bank statement for the same start day. If it doesn't, don’t worry. QuickBooks lets you know what changes you might need to make. Here's how to fix beginning balance issues so you can start reconciling.

Learn what causes beginning balance issues
Step 1: Review the original opening balance
Step 2: Check your bank statement
Step 3: Match and categorize downloaded transactions
Step 4: Review any discrepancy reports
Next steps: Start reconciling

Tip: If you've never reconciled this account before, don't follow these steps. Here's what to review for the first time you reconcile an account. Or, if you're new to the entire process, start with our reconciliation guide.

Learn what causes beginning balance issues

Someone entered an incorrect opening balance when they created the account in QuickBooks.
Someone added transactions that are older than the opening balance, but didn't edit the original opening balance entry to reflect the change.
Someone edited, deleted, moved, or unreconciled an already reconciled transaction. This changes the ending balance of your last reconciliation, which impacts the beginning balance of the next one.
Someone manually reconciled a transaction, so it didn't show up on the next reconciliation.

Prerequisites

Access to the account’s bank statements.
Admin rights to view and edit reconciliations in QuickBooks Online.
Awareness of any changes recently made to transactions (edits, deletions, manual reconciliations).

Find the Issues

Review the original opening balance. If it's incorrect, it affects all future reconciliations. .
Check your account statement to make sure you’re reconciling the correct account and the right month.
Follow this link to complete the steps in product
In QuickBooks, go to the account ▼ dropdown and select the right account.
- Note: If you have multiple accounts at the same bank, or more than one account of the same type, make sure you're reconciling the right one.
Match and categorize downloaded transactions to make sure QuickBooks has the right beginning balance. .
- Note: for accounts connected to online banking, match and categorize all downloaded transactions.
Select “We can help you fix it” to open and review the discrepancy report to decide if and how to make changes.
- Note: Before editing anything, talk with whoever made the changes —they may be intentional.

Make sure your opening balance is correct before checking your beginning balance. Then move on to Step 2.

Go to Transactions and select Reconcile (Take me there).
Select the account that you want to reconcile from the Account ▼ dropdown.

Select the We can help you fix it link to open your discrepancy report.
Review the discrepancy report. Use it to decide if and how to make changes.
Before editing anything, talk with whoever made the changes - they may be intentional.

Fix the Issue

Get a QuickBooks-certified bookkeeper to help you categorize transactions and reconcile your bank statements every month. Learn more about QuickBooks Live Bookkeeping.

Review each transaction in the report one at a time.

Select view to see the history of changes to the transaction.
Review the Change Type column. This tells you what has changed.
Make edits based on the message in the Change Type column.

Select View to see the history of changes to the transaction.
Review the Change Type column. This tells you what changed.
Make edits based on the message in the Change Type column:

Amount changed

This means someone edited a reconciled transaction or moved it to another account. To fix it:

Select the transaction to expand the view.
Select Edit to open the form.
Adjust the total or change the account as needed.
Select Save and close.

Unreconciled in register

This means someone unreconciled the transaction. To reconcile it again:

Go to Transactions, then select Bank transactions (Take me there).
Select the account you want to reconcile again, then select Go to bank register.
Select Reconcile.
Verify the Account you've selected and change it, if required.
Enter the info from your statement in the Ending balance field and Ending date field. Then, select Start reconciling.
Review the transactions and select those that match the transactions in your bank statement.
Once the Difference is CAD $0.00, select Finish now, then select Done.

Alternatively, to reconcile a transaction manually:

Go to Transactions and select Chart of Accounts (Take me there).
Select Account history in the Action column of your bank account.
Select the transaction that has been manually unreconciled.
Select the box in the ✔ column until you see an R. This reconciles the transaction manually.
Select Save.

Reconciled in error

This means someone has already reconciled the transaction by accident. To remove it and add it to your next reconciliation:

Select the transaction to expand the view.
Select the box in the ✔ column until it's blank or you see a C. This removes the transaction from the reconciliation.
Select Save.

Deleted

This means someone deleted the transaction. If this was an accident, recreate the transaction exactly as it appears on your discrepancy report:

Select + New.
Select the correct form (invoice, sales receipt, expense, etc.).
Fill out the form and select Save and close.
Go to Transactions and select Chart of Accounts (Take me there).
Find the account that you put the transaction into and select Account history.
Find the transaction and select it to expand the view.
Select the box in the ✔ column until you see an R. This manually reconciles the transaction.
Select Save. If you still see an alert the next time you reconcile, open the discrepancy report. The deleted transaction may still be on the list, but the difference should be CAD $0.00. It won't affect your reconciliation.

After you review everything on the discrepancy report, the Total Discrepancy Difference on the report should be CA $0.00. Check the beginning balance again in QuickBooks. It should match the beginning balance on your bank statement. Select resume reconciling to continue reconciling.

br>

Results

Once you know your beginning balance is correct, you can start reconciling. If you see issues in the middle of your reconciliation, here's what you should review.

Next steps

Once you know your beginning balance is correct, you can start reconciling. If you see issues in the middle, here's what you should review.
If you’ve followed everything in our guide but still have questions, connect with your accountant. They can help you get back on track.