Reconciling your accounts in QuickBooks Online helps ensure that your bookkeeping records match your bank statements. However, you may sometimes discover that the beginning balance does not match the ending balance from your previous reconciliation. When that happens, QuickBooks Online may prevent you from completing the reconciliation until you identify and resolve the difference.
A beginning balance discrepancy usually means that something changed after a previous reconciliation. The good news is that QuickBooks Online provides tools that can help you identify those changes and determine what needs to be corrected.
If you need additional assistance, you can also work with a bookkeeping professional who can review your account and help keep your reconciliations accurate.
What is a Beginning Balance Discrepancy in QuickBooks Online?
Every time you reconcile an account, QuickBooks Online uses the ending balance from your previous reconciliation as the beginning balance for the next one.
For example, if your last reconciliation ended with a balance of $10,000, your next reconciliation should begin with $10,000. If QuickBooks shows a different amount, something has changed in the account since the previous reconciliation.
These discrepancies can occur because a previously reconciled transaction was edited, deleted, voided, or otherwise changed. An incorrect opening balance can also create a problem, particularly if you have never reconciled the account before.
QuickBooks Online's Reconcile Discrepancy Report is one of the most useful tools for investigating these issues. It can show what changed, when the change occurred, how it affected the account, and where you may need to make a correction.
What Causes Beginning Balance Issues in QuickBooks Online?
Several types of changes can cause your beginning balance to become incorrect.
1. Incorrect Opening Balance
If this is the first time you've reconciled the account, the problem may be the original opening balance rather than a transaction that changed later.
Compare the opening balance recorded in QuickBooks Online with your bank statement from the day before you began tracking the account in QuickBooks. If the amounts do not match, the opening balance may need to be corrected.
If you're uncertain about changing an opening balance, consult your accountant before making an adjustment.
2. Changes to Reconciled Transactions
A transaction that was already reconciled can affect your beginning balance if someone later edits, deletes, voids, moves, or unreconciles it.
Because the transaction was included in your previous reconciliation, changing it can alter the ending balance of that reconciliation. That altered ending balance then becomes the beginning balance for your next reconciliation.
3. Undone Bank Feed Transactions
A categorized transaction downloaded through bank feeds can also cause a discrepancy if the transaction is undone and returned to a pending state.
When investigating a beginning balance issue, review your bank feed activity as well as your account register.
4. Transactions Reconciled Outside a Reconciliation
You may also have a problem if someone manually marked a transaction as reconciled after the previous reconciliation had already been completed.
This can affect the beginning balance even though the transaction was not included in the original reconciliation process.
How to Fix Beginning Balance Issues in QuickBooks Online?
Before you begin troubleshooting a beginning balance discrepancy, gather your bank statements and make sure you have access to the correct QuickBooks Online account. Write down the exact amount of the difference so you can compare it with the changes you find during the process.
Before You Start
- Gather the bank statements for the account and reconciliation period you're reviewing.
- Make sure you have the necessary administrator access to review and edit reconciliations.
- Note the exact amount by which the beginning balance is incorrect.
- Review your bank transactions and make sure they are properly matched, categorized, posted, or excluded.
- If your account is connected to online banking, make sure downloaded transactions have been reviewed and categorized or matched correctly.
- Have your previous reconciliation's ending balance available for comparison.
- If you are unsure about changing an opening balance or a previously reconciled transaction, consult your accountant before making adjustments.
Step 1: Prepare Your Account for Reconciliation
Before investigating the discrepancy, gather the bank statements covering the period you're reviewing. You should also have the appropriate administrative access to review and edit reconciliations.
In QuickBooks Online, open All apps, go to Accounting, and select Bank transactions.
Review the transactions for the period and make sure they have been properly matched, categorized, posted, or excluded. If the account is connected to online banking, ensure that downloaded transactions have been reviewed and matched or categorized correctly.
Before making any corrections, write down the exact amount of the beginning balance difference.
For example, if QuickBooks says the beginning balance is off by $425, keep that figure available while you investigate. The changes you identify should ultimately account for the entire $425 difference.
Step 2: Open the Reconcile Discrepancy Report
Next, open All apps, select Accounting, and then choose Reconcile.
Select the account you're trying to reconcile from the account dropdown.
Be particularly careful if you have multiple accounts at the same financial institution or several accounts of the same type. Selecting the wrong account can lead you to investigate the wrong transactions.
If QuickBooks Online detects a discrepancy, you'll see a message indicating that the account isn't ready to reconcile because the beginning balance is incorrect.
Select We can help you fix it to open the Reconcile Discrepancy Report.
Step 3: Review and Correct Each Change
Work through the discrepancy report one transaction at a time.
The What happened column can help you determine what changed, when the change occurred, and who made it.
Select Review in tray to examine the details of a particular transaction. For a more complete record, open the dropdown beside Review in tray and select View History.
QuickBooks may recommend a correction based on the change it identifies. You can follow that recommendation when appropriate, or make a different correction based on your accounting records.
A. Don't Automatically Reverse Every Change
A discrepancy report identifies changes, but not every change is necessarily an error.
Some transactions may have been intentionally modified. Before correcting anything, confirm that the change was actually made by mistake.
Take extra care when a proposed correction affects a previously reconciled period or the account's opening balance. If you are unsure whether an adjustment is appropriate, ask your accountant before changing the records.
B. Correcting an Individual Reconciled Transaction
If QuickBooks recommends reconciling an individual transaction, you have two options.
You can mark the transaction as R for reconciled directly in the account register. Alternatively, you can reconcile the account again using the same ending date and ending balance from your previous reconciliation.
Both approaches can correct the beginning balance. However, reconciling the account again creates a record of the change on a reconciliation report, which may be useful for maintaining a clear audit trail.
Step 4: Investigate Changes Not Shown in the Report
Sometimes the Reconcile Discrepancy Report does not identify everything responsible for the difference. If the report appears clear but the beginning balance remains incorrect, investigate deleted, voided, and manually reconciled transactions.
A. Check for Deleted or Voided Transactions
Open Settings and select Audit log.
Filter the audit log for the account and the period beginning after your last completed reconciliation. Look for transactions that were deleted or voided.
Review the details carefully to determine whether one of these changes explains the discrepancy.
B. Look for Transactions Reconciled Manually
You should also check whether transactions were marked as reconciled outside the normal reconciliation process.
Go to All apps, select Accounting, and open the Chart of accounts.
Find the account you're reviewing and select View register.
Use the reconciliation-status filter to identify transactions marked R. Pay particular attention to transactions dated after your last completed reconciliation.
If you find a transaction that was incorrectly reconciled, you may need to change its reconciliation status back to uncleared before reconciling the account correctly.
How to Fix Beginning Balance Issues During Your First Reconciliation?
If you're reconciling an account for the first time, the troubleshooting process is different. In most cases, the problem involves the account's opening balance rather than a previously reconciled transaction.
Step 1: Find the Opening Balance
- Open All apps in QuickBooks Online.
- Select Accounting.
- Choose Chart of Accounts.
- Find the bank or credit card account you want to reconcile.
- Select View Register.
- Look through the register for the opening balance transaction.
- Check the Account column. The entry will typically be associated with Opening Balance Equity.
- Take note of the opening balance date and amount.
Review these details carefully. You need to compare the QuickBooks balance with the actual balance from your financial institution for the same date.
Step 2: Compare It With Your Bank Statement
After locating the opening balance, compare it with your real-world account balance.
- Open your bank's website or locate the appropriate bank statement.
- Find the balance for the exact date used for the opening balance in QuickBooks Online.
- Compare that amount with the opening balance recorded in QuickBooks.
- Determine whether the two amounts match.
A. If the Opening Balances Match
If the QuickBooks opening balance is identical to the balance shown by your bank or credit card company, the opening balance is likely correct.
You can move to the next step and review the account register for incorrectly reconciled transactions.
B. If the Opening Balances Do Not Match
If the figures are different, you need to correct the opening balance so it reflects your actual financial records.
In QuickBooks Online:
- Select the Opening Balance Equity transaction in the register.
- Expand the transaction details.
- Update the amount in the Deposit column so it agrees with your bank records.
- Select Save.
Always use your actual bank or credit card statement as the source of truth rather than adjusting the number based solely on what you expect QuickBooks to show.
Step 3: Review the Account Register
Correcting the opening balance may not resolve the problem if another transaction has already been marked as reconciled.
During a first-time account reconciliation, the opening balance should generally be the only transaction already marked as reconciled. Other transactions should not have an R status unless they were intentionally reconciled as part of an earlier reconciliation.
To review the register:
- Go to All apps.
- Select Accounting.
- Open Chart of Accounts.
- Find the account you are reconciling.
- Select View Register.
- Locate the opening balance transaction.
- Confirm that the opening balance is associated with Opening Balance Equity.
- Check the reconciliation status column.
The opening balance should have an R in the reconciliation status column.
Review the remaining transactions carefully. Their status should generally be blank or show C, depending on the transaction and your accounting workflow.
How to Confirm the Beginning Balance Is Fixed?
Once you've reviewed and corrected the relevant changes, return to the reconciliation screen.
The Total discrepancy difference should now show $0.00.
The changes you identified should also add up to the original discrepancy you recorded before starting your investigation. For example, if the beginning balance was initially off by $425, your corrections should collectively explain that $425 difference.
When the discrepancy reaches zero, your beginning balance should match the expected balance from the previous reconciliation, allowing you to continue reconciling the account.
Preventing Future QuickBooks Reconciliation Problems
The best way to avoid recurring beginning balance issues is to protect completed reconciliations from unnecessary changes.
After completing a reconciliation, keep your bank statements and reconciliation reports with your accounting records. Be cautious when editing transactions from previously reconciled periods, and review changes carefully before saving them.
Regularly reviewing your audit log can also help you identify unexpected changes early. Keeping bank feed transactions properly matched and categorized reduces the chance of discrepancies caused by incorrectly handled downloaded transactions.
For businesses with complicated accounts or frequent transaction activity, having a bookkeeping professional review reconciliations regularly can provide additional peace of mind.
What to Do If Your Beginning Balance Still Doesn't Match?
A beginning balance discrepancy can be frustrating, especially when the source of the difference isn't immediately obvious. Start with the Reconcile Discrepancy Report, then check the audit log and account register for changes that may not appear in the report.
If you've followed these steps and the balance still doesn't match, avoid making an arbitrary adjustment just to force the reconciliation to balance. An unexplained adjustment can create larger accounting problems later.
Instead, consider asking your accountant or a qualified QuickBooks bookkeeping professional 1-888-487-1720 to review the account. They can help determine what caused the discrepancy and make an appropriate correction while preserving the accuracy of your financial records.
Final Thoughts
Fixing a beginning balance issue in QuickBooks Online usually requires tracing changes back to the last completed reconciliation. By reviewing the discrepancy report, checking transaction histories, examining the audit log, and verifying manually reconciled transactions, you can usually identify the source of the problem.
The key is to correct only genuine errors and document the changes you make. Once the discrepancy reaches $0.00, your beginning balance is ready for reconciliation and you can continue with greater confidence.
Frequently Asked Questions
Q. Why is my beginning balance wrong in QuickBooks Online even though I didn't change anything?
QuickBooks Online may show an incorrect beginning balance if a previously reconciled transaction was edited, deleted, voided, or unreconciled. A bank-feed transaction may also have been undone or moved back to pending status. Check the Reconcile Discrepancy Report and Audit Log to identify recent changes.
Q. Why does QuickBooks say “Your account isn't ready to reconcile yet”?
This message usually appears when the beginning balance doesn't match the ending balance of your previous reconciliation. QuickBooks detects a difference and requires you to investigate it before continuing. Select the “We can help you fix it” option to review the discrepancy.
Q. How do I fix a beginning balance that is off by a few cents in QuickBooks Online?
Even a small difference, such as $0.01, can prevent reconciliation. Review recently changed transactions, rounding differences, manually reconciled entries, and deleted or voided transactions. Use the Reconcile Discrepancy Report to determine what caused the exact difference rather than entering an unexplained adjustment.
Q. Why is QuickBooks showing a beginning balance discrepancy after a recent bank-feed update?
A bank-feed transaction may have been changed from categorized or matched to another status. For example, undoing a categorized transaction can return it to pending transactions. This change can affect your account balance and may create a beginning balance discrepancy.
Q. Can a deleted transaction cause my QuickBooks beginning balance to be incorrect?
Yes. Deleting a transaction that was included in a previous reconciliation can change the historical ending balance.
Q. How can I find the opening balance in QuickBooks Online?
Open All apps > Accounting > Chart of accounts, find the account, and select View register. Look for the opening balance entry, which is generally associated with Opening Balance Equity. Review its date and amount and compare them with your financial statement.
Q. Why is my QuickBooks reconciliation beginning balance negative?
A negative beginning balance isn't necessarily an error. It can be legitimate for certain accounts, such as credit cards or accounts with overdrafts. However, if the negative amount doesn't agree with your previous reconciliation or bank statement, investigate the account history for changed transactions.
Q. Why does QuickBooks Online show a different beginning balance than my bank statement?
QuickBooks and your bank statement may differ because of transactions that were edited, deleted, voided, duplicated, incorrectly dated, or manually reconciled. Compare the reconciliation beginning balance with the ending balance from your previous bank reconciliation before making any adjustments.
Q. What happens if I accidentally unreconciled a transaction in QuickBooks Online?
Unreconciling a previously reconciled transaction can change the account's historical balance and create a beginning balance discrepancy. Review the transaction and its history before changing its reconciliation status again. If you are unsure about the correct status, consult your accountant.
Q. Can manually reconciling an old transaction cause a beginning balance problem?
Yes. If a transaction dated before your previous reconciliation is manually marked as reconciled afterward, it can affect the beginning balance. Review the account register and filter transactions by reconciliation status to find entries that were marked R outside the normal reconciliation process.
Q. Should I enter a journal entry to fix a QuickBooks beginning balance discrepancy?
Not automatically. A journal entry may hide the real cause instead of correcting it. First determine whether the discrepancy came from a changed transaction, incorrect opening balance, deleted transaction, or reconciliation-status issue. If the correction affects a previously reconciled period, speak with your accountant before making an adjustment.
Q. Why won't QuickBooks let me reconcile even though my ending balance matches the bank statement?
Your current ending balance can match the bank statement while the beginning balance is still incorrect. QuickBooks compares your current beginning balance with the previous reconciliation's ending balance. You need to resolve the historical discrepancy before completing the new reconciliation.
Q. What does a $0.00 total discrepancy mean in QuickBooks Online?
A $0.00 total discrepancy means QuickBooks has identified no remaining difference between the expected beginning balance and the corrected account balance. Once the discrepancy reaches zero and your statement details are correct, you can proceed with the reconciliation.
Q. Why is my QuickBooks reconciliation off after someone edited an old transaction?
Editing a transaction that was already included in a completed reconciliation can change the historical balance. This is one of the most common reasons users suddenly discover a beginning balance problem even though their current transactions appear correct.
Q. How do I fix a QuickBooks beginning balance discrepancy without undoing my entire reconciliation?
You may not need to undo the entire reconciliation. First use the Reconcile Discrepancy Report to identify the specific change. Depending on the situation, correcting the transaction or reconciliation status may resolve the discrepancy without requiring you to redo multiple months of reconciliations.