Beginning balance issue from 6 months ago

I’ve got you covered, Marileysis.

Let me help and guide you on how to resolve the beginning balance issue in your account. We’ll have to find the transaction that’s causing the discrepancy. Then, enter it and reconcile your account.

To locate the payment, run the Reconcile Discrepancy report, Audit Trail, or Previous Reconciliation report. I’ll show the steps on how to build the previous one.

Here’s how:

1. Go to the Reports menu at the top bar to select Banking and then Reconciliation Discrepancy.
2. From there Specify Account drop-down, choose the account you’re working on, and click OK.
3. This will show a list of transactions that were changed since the last reconciliation.
4. Use this report to identify the transaction/s causing the issue.
5. Once you find the discrepancy, note the transaction date and the Entered/Last Modified (tell you when the change occurred).

Next, reenter the payment again. For detailed instructions, follow the steps in this article: Receive and process payments in QuickBooks Desktop. Proceed directly to the Process payments for open invoices section.

Once done, you can now resolve the incorrect balance. You can browse through this link for the complete steps: Fix beginning balance issues in QuickBooks Desktop. From there, go to the Undo a previous reconciliation and redo it section.

For additional resources, the following topics contain information about balancing your bank or credit card account. You’ll also see the step-by-step process on how to resolve when your account in QuickBooks Desktop doesn't match your bank statements at the end of reconciliation.

• Reconcile an account in QuickBooks Desktop
• Fix issues when you're reconciling in QuickBooks Desktop

Keep in touch if you have additional questions about correcting your beginning balance. I’m always ready to answer them for you. Have a great rest of the day.

Thank you for the reply! 

Now.. I still am a bit lost. In the steps where I am told to enter the statement date and ending balance.. am I supposed to enter the statement date that the deleted amount is supposed to be in? And the ending balance for that month as well? Or this month? And after that do I hit continue? Because on the "begin reconciliation pop up window I have the following options to click: 1. locate discrepancies. 2. undo last reconciliation. 3. continue. 4. cancel. 5. help. I do not have a "undo A previous reconciliation option. Just the last reconciliation. 

Many thanks.

Welcome back to the Community, Marileysis.

I appreciate you for following the steps I shared and letting us know the result. Let me help make sure you reconcile the account in no time.

You’re already on the right track. Before you undo the previously reconciled transactions, create a backup of the company file to keep a copy of your information. Once done, follow these steps to unreconcile the account.

1. Press the Banking menu at the top bar to choose Reconcile.
2. This will open the Begin Reconciliation window.
3. Key in the date for the deleted amount in the Statement Date field.
4. Next, input the ending balance amount for that month (deleted payment).
5. Then select the Undo Last Reconciliation button to correct your records.
6. Follow the on-screen instructions to complete the process.

For detailed information, you can read through the article I previously shared: the Fix beginning balance issues in QuickBooks Desktop. Additionally, this resource will guide you on how to build a report for your previous reconciliation: Get reports for previous reconciliations in QuickBooks Desktop. It contains screenshots to visually guide you.

Keep in touch if you have any clarifications about reconciling accounts in QuickBooks. I’m always ready to help and make sure you’re taken care of. Wishing your business continued success.

I can't believe it....but this actually worked!  thank you!!

Thanks for joining this thread, ManSol.

I'm delighted to know the solution shared on this thread helped fixed your beginning balance concern. This drives us to continue working hard and provide the best QuickBooks experience to our customers.

For resources to help your business thrive and accomplish any accounting tasks, feel free to visit the Community page.

Fill me in if you have other QuickBooks concerns. I'll get back to make sure you're taken care of.