Bank Rec starting balance

Welcome to the Community, @MDI. I understand the importance of correcting the beginning balance amount on your QuickBooks Desktop account. Let me help you fix this. 

To do this, you need to change the transaction status from asterisk (*) to check (✔) to reflect the balance correctly. Here are the steps you can follow:

1. On the top navigation bar, click Company and choose Chart of Accounts.
2. Select the bank account you want to edit. 
3. Under the Checkmark column, click the clear box until it shows the check (✔) mark.
4. Click Yes.  

Also, please consult your accountant for guidance on reviewing the reconciliation of your accounts.

After completing the process, you can consider closing your books to prevent unwanted or accidental changes affecting your financial reports.

Feel free to hit the reply button if you need help reconciling your account. The Community forum is always here to assist you.

I am using Quickbooks Premier Non-Profit 2021 Desktop edition. What would the process be for that version? I didn't see the options you said. Thank you for your help.

Sorry, I just saw the desktop version answer. I did that but it's still off by that amount. These amount are showing up on the bank rec as deposits also. When I clear them, the account is reconciled but I'm still off by the original deleted amounts.

Thanks for coming back here, @MDiBella.

My colleague @SheandL already updated her answer so you can reconcile your transactions in QuickBooks Desktop (QBDT) Premier and fix your beginning balance.

To reiterate her answer, you'll need to go to the Company field and change the transaction status in the Chart of Accounts from Asterisk (*) to checkmark (✔). Here's how:

1. From the Company tab above, select Chart of Accounts.
2. Look for the bank account you'll need to edit.
3. Below the Checkmark column, tap the clear box to show the (✔). Then, Yes to save.

For more information about fixing balances, check out this article: Fix beginning balance issues in QuickBooks Desktop.

If the balance is still off, you might need to perform a mini-reconciliation. Feel free to follow these steps: 

1. From the Banking menu, select Reconcile.
2. Select the bank account with the transactions you need to reconcile.
3. In the Date of Statement field, enter the date for an "off-cycle reconciliation." This date can be any date between your last reconciliation and the next scheduled one.
4. In the Ending Balance field, enter the balance of your last successful reconciliation. Then select Continue.
5. In the Reconcile window, check off the transactions you are fixing and re-reconciling.
6. Ensure the Difference field shows $0.00.
7. When everything looks good, select Reconcile Now.

You can also refer to this article for more details: Reconcile previously deleted and re-entered checking or credit card transactions.

On top of that, it was also advised to reach out to your accountant to avoid reconciliation discrepancies. 

If you want to end this fiscal year with your book balanced, feel free to read this article: Close your books in QuickBooks Desktop.

We're just one reply away if you have additional reconciliation concerns. We'll be willing to assist you. Have a good one.

I did that. The beginning balance didn't change.

Hi MDiBella,

I want to make sure that we fix your problem.

To make sure we're on the same page, can you tell me the date when you re-entered the payments into your QuickBooks Desktop account? Please also send a picture of the transaction that is causing the issue, the period you're trying to fix, and the incorrect starting balance. Please remember to hide any personal information before you send it.

I'd also like to ask for additional information on what you're referring to. Is it the opening balance of the account or the beginning balance when reconciling an account for November 2023?

Thank you, and I look forward to hearing back from you soon. Have a great day!

I entered the new "payments" on the same day they were originally created (see attached). I did this on November 14th. It looks like the only beginning bank rec balance off is this November's. They are saying the beginning balance is $3,651.14 and it should be $4,576.14 which is the difference of the deleted payments. I really appreciate the community's help.

I forgot to add this attachment. It shows the payments as cleared...

Thanks for the additional information and attachment, @MDiBella. Let me chime in and help you sort this out.

Since your beginning balance is still showing off even though the transactions are now created and cleared, you can generate a Reconciliation Discrepancy report to identify the issue further. There might be other entries making your balance off.

Here’s how you do it:

1. Go to the Reports menu.
2. Search Reconciliation report.
3. Select your account, and then hit OK. You'll see a list of events that changed since your last reconciliation. Use this statement to identify the transaction(s) causing the issue.

Please note the transaction date and the Entered/Last Modified, which will tell you when the change happened if you find a discrepancy.

If there are no other entries that trigger discrepancies, you may use the Verify and Rebuild Data tools to rectify data damage in the company file.

Once settled, you can close your books to finalize your financial records for a particular period. Closing the books is an important measure to guarantee the precision of your reports and to prepare for the upcoming accounting period. Additionally, it'll help you detect any inconsistencies, inaccuracies, or anomalies in your company data.

I want to ensure everything is covered for you. If you need further assistance or have other concerns besides your beginning balance, feel free to add comments below. We’ll be here, @MDiBella.

I've attached the discrepancy report. I can only see those deleted payments as being the only thing affecting the starting balance and it looks like it's not affecting any other balance.

Thanks for the prompt response, @MDiBella.

I appreciate you doing the discrepancy report suggested by my colleague above. Also, have you tried performing the verify rebuild mentioned? If you haven't, you can perform this tool since the verify tool finds the most common issues in a company file, and the rebuild tool fixes them. For more details, see this link: Verify and Rebuild Data in QuickBooks Desktop.

If you have finished the troubleshooting, I recommend contacting our Customer Support Team. They have the tools to examine your account securely and suggest other troubleshooting actions.

To proceed, here's how:

1. Open your QuickBooks file.
2. Go to the Help menu, then choose QuickBooks Desktop Help.
3. Click Contact Us.
4. Enter your concern, then select Continue.
5. Choose Start messaging or Get a callback from an expert.

To check their support hours, open this link: Contact QuickBooks Desktop support.

Additionally, I'll be sharing these resources that will guide you in reconciling your account and fix other issues you might encounter when performing the steps:

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

Feel free to post any of your questions related to reconciliation or any other QuickBooks issues here. I'm always available to assist. Take care.

I ran a rebuild also. It's still off by that amount. I'm at a loss at this point....

Hi there, MDiBella.

I appreciate you getting back and providing updates when following the steps above. I understand the urgency of getting this issue resolved, but since the problem still persists, I recommend contacting our Customer Care Support Team. They have the tools to pull up your account in a secure environment and perform a screen-sharing session so they can take a closer look and come up with a fix.

To reach them, here's how:

1. On your QuickBooks account, go to the Help menu at the top.
2. Select QuickBooks Desktop Help. 
3. Choose Contact Us. 
4. Enter the issue or topic in the field box. 
5. Follow the onscreen instructions.

You can also check out this link for more information on contacting them: Contact QuickBooks Desktop support. Ensure to review their support hours to know when agents are available.

If you need other helpful articles in the future, you can always visit our site: Help articles for QuickBooks Desktop.

Keep me posted if you need further assistance while working in QuickBooks. I’ll be right here to help. Have a great day.