Question

How do you fix a beginning balance reconciliation after a check from a prior month was voided? Beg balance is off by voided check amount and Help suggestions don't work.

Forum|Forum|3 years ago
March 4, 2023
1 reply
0 views

Original commenter did not share additional details

QuickBooks Online

I'm delighted to have you here today, @katurn. Let's get you out of this situation and fix your beginning balance to finish reconciling an account in QuickBooks Online (QBO).

Since there's a voided or deleted check involved, what you'll want to do is to recreate the transaction, so it'll show on your discrepancy report. I'll input the process below to get you started. These are the steps:

Access your QuickBooks Online company.
On the left navigational bar, click + New.
Select the correct form (invoice, sales receipt, expense, etc).
Fill out the form and select Save and close.
Go to Bookkeeping or Accounting, then select Chart of accounts.
Find the account that you put the transaction into and select View register.
Find the transaction and select it to expand the view.
Select the box in the checkmark column until you see an R. This manually reconciles the transaction.
Click 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 $0.00. It won't affect your reconciliation.

After reviewing everything on the discrepancy report, the Total Discrepancy difference on your data should be U.S. $0.00. You'll want to double-check the beginning balance again in QuickBooks, and this time, it should match the beginning balance on your statement. Lastly, click the Resume reconciling button to finish reconciling the account.

For further guidelines on how to fix a beginning balance that's off in QBO, please see this handy article: Fix issues for accounts you've reconciled in the past in QuickBooks Online.

Additionally, I've got you this article to help you ensure your data inside QuickBooks is accurate: Run reports in QuickBooks Online.

Thanks for dropping by here today, @katurn. Don't hesitate to let me know in the comments below if you got any additional QuickBooks-related concerns. I'll be happy to help you out again. Take care, and have a nice day

M

MKlein1

How about the Desktop version? The check was voided, but already cleared from prior month's reconciliation. Thanks!

D

DebSheenD

Thanks for getting back to us, @MKlein1.

I'm here to assist you every step of the way to fix your beginning balance in QuickBooks Desktop (QBDT).

We can recreate the check that was void and do the mini-reconciliation to include the unreconciled transaction in your account.

Here's how:

Go to the Banking menu, then choose Reconcile.
Pick the exact Statement date in the box.
In the Ending Balance field, enter the balance of your last successful reconciliation.
Complete the required details and click Continue.
Check off the transactions you are fixing and re-reconciling.
You can also click the Modify button on the bottom part to correct the balance.
Tap Reconcile Now.