cancel
Showing results for 
Search instead for 
Did you mean: 
Level 2

Bank reconciliation register balance doesn't match Balance Sheet

Hello,

 

I completed our December bank reconciliation and the ending Bank Statement balance matched the Cleared Balance correctly. However, the Register Balance on the reconciliation report as of 12/31/18 is $12,000 less than the Balance Sheet statement ending 12/31/18. The register balance on the reconciliation report is $50,811.58 and the balance sheet is $62,811.58.

 

Any suggestions on how this different can come about or how to fix this?

 

Thank you!

20 Comments
QuickBooks Team

Re: Bank reconciliation register balance doesn't match Balance doesn't match

Hello there, GrHospitality.

 

I'm here to help you match your bank reconciliation register balance with your bank statement.

 

To better isolate what's causing the bank reconciliation register balance not being match with the bank statement balance, we'll have to make sure the dates for each report are the same.

 

Otherwise, you'll need to check the dates on the individual checks and deposits. The Register Balance on the reconciliation report refers to the ending balance of the Bank register at the time of reconciliation. The Balance Sheet on the other hand, shows the Bank Balance as of the date specified.

 

For additional help, feel free to reach them out through this link: QuickBooks Desktop Support​. They have the tools that can help you get this resolved in no time.

 

Let me how it goes and if you have further questions while working with reports in QuickBooks Desktop. I'm always glad to help.

Level 2

Re: Bank reconciliation register balance doesn't match Balance doesn't match

There were two checks dated January 1, 2019. I changed to dates and it fixed the problem.

 

Thank you!

 

 

Level 1

Re: Bank reconciliation register balance doesn't match Balance doesn't match

I am having a similar issue.  The register balance at the end of September, 2019 does not balance with the balance sheet bank balance.  This is because the category of Uncleared Checks is not showing all of the uncleared checks - 40 checks written on the last day of the month are on the register, but are not showing up as Uncleared Checks on the reconciliation report.  I have no way of troubleshooting the issue.  How can I get help?

 

QuickBooks Team

Re: Bank reconciliation register balance doesn't match Balance doesn't match

Hi RuthieG9999,

 

Let me provide you some information and help you with your report and register balances.

 

QuickBooks will report checks regardless if they are cleared or uncleared. Thus, your balance sheet doesn't have to be the same as your bank register's balance. You'll want to consult with your accountant with regards to your uncleared checks. This way, you can decide whether to edit your check date or not.

 

You can refer to these handy articles for more information about:

You can also visit our page about banking and bank feeds for tips and recommendations if you need some future reference. 

 

Always swing by if you have other concerns. We're always here for you.

Level 1

Re: Bank reconciliation register balance doesn't match Balance doesn't match

This is not answering my question.  For the month of September, 2019 I have Uncleared checks in the amount of $55,806.85.  On the Bank Reconciliation report for 9/30/19, the Uncleared checks and payments total $41,446.31.  The difference between the actual uncleared checks and what is on the Bank reconciliation is $14,360.54.  Why don't both reports contain the same information?

QuickBooks Team

Re: Bank reconciliation register balance doesn't match Balance doesn't match

 

Hello there, RuthieG9999. 

 

The balance sheet report shows the balance within the report period you’ve selected. While, the register as of balance 09/30/2019 in your reconciliation report, is the bank’s balance when you reconciled it. Any changes made to the transactions within the reconciliation period won’t affect the reconciliation report but will affect your balance sheet.

 

You can check this report to on how to manage your reconciliation report

 

Keep me posted if you need anything else. 

Level 1

Re: Bank reconciliation register balance doesn't match Balance doesn't match

It really appears that nobody is understanding or acknowledging my problem.  After an update was done, in August, 2019, when we did the bank reconciliation, 5 checks that were "uncleared" did not appear on the bank reconciliation report for the "Uncleared checks and payments" portion of the report.  This is the first time we have experienced this.  In September, 2019, 40 uncleared checks did not appear on the bank reconciliation for the Uncleared checks and payments.  If a check is indeed uncleared, why doesn't it appear on the bank reconciliation report that should include ALL UNCLEARED CHECKS.  WHY ARE CHECKS MISSING FROM THIS REPORT.  My QB Bank Register balance at the end of the reconciliation period always balanced with the QB balance on the balance sheet - now it doesn't because of the uncleared checks not appearing on the report like they should.  I feel I have lost integrity in the QB product.

QuickBooks Team

Re: Bank reconciliation register balance doesn't match Balance doesn't match

I understand your frustration, @RuthieG9999.

 

Data damage is likely the reason why those uncleared checks aren't showing in the Checks and Payments section of the Reconciliation window. If the transactions are in the register, it should show on your report as well. 

 

You can run the Verify and Rebuild Utility Tool to check and fix any issues in the company file. Before doing so, make sure to create a backup to avoid any accidental data loss.

 

Here's how:

  1. From the File menu, select Utilities, then Rebuild Data.
    Utilities.PNG
  2. Click OK on the QuickBooks Information window. 
  3. Follow the prompt to save a backup.
  4. Hit OK when you see Rebuild has completed.

Once done, follow the steps above, except choose verify instead of rebuild. Take a look at this article for reference: Resolve data damage. In the same link, you’ll find other data damage troubleshooting steps for Windows.

 

If you continue to get the same result after performing the solution, I recommend reaching out to our Customer Care Team for further assistance. They can initiate a screen-sharing session in a secure environment, which we're unable to do so here in the Community for security reasons.

 

Here's how to contact support:

  1. On your QuickBooks Homepage, go to the Help menu.
  2. Choose QuickBooks Desktop Help.
  3. Tap the Contact us button.

I want to know how this goes, so please leave a comment below. The Community is here to help. Wishing you the best!

 

Level 1

Re: Bank reconciliation register balance doesn't match Balance doesn't match

I agree with your diagnosis of the problem.  However, I do not have the capability of rebuilding data on my system.  I do not have the choices given in the instructions.  I have reached out to customer care and they shared my screen and could not find where I would have the option to resolve any data damage.  What is my choice now being that I can't rebuild or repair any data damage?  Help!!!!

 

QuickBooks Team

Re: Bank reconciliation register balance doesn't match Balance doesn't match

Good day, @RuthieG9999,

 

Can you tell me what version of QuickBooks are you using? This will help me check for similar issues reported by other users.

 

In the meantime, let's use a test file and see if it has the Verify/Rebuild option. I need to know if the issue is caused by a corrupted component of the software. Here's how:

 

  1. Open QuickBooks and go to the File menu.
  2. From there, select Close Company.
  3. On the No Company Open box, click the Open a sample file drop-down.
  4. Select the sample business that most closely matches your own.
    blog-img-quickbooks-open-sample-company

 

If you can see this option in the sample file, I suggest running the Repair tool. This fixes corruption issues on the data file. Perform these steps:

 

  1. Reboot your computer and close all programs before repairing QuickBooks.
  2. Tap the Windows Start Menu button at the bottom left corner of the computer's screen.
  3. Go to the Control Panel and select Programs and Features.
  4. Click on Uninstall a program.
  5. Pick QuickBooks from the list and press Uninstall/Change.
  6. Hit Continue, then Next.
  7. Mark the Repair radio button, then Next.
  8. Once the Repair is complete, click Finish.
  9. Restart your computer when prompted.

 

If all else fails, please contact our Phone Support again. I know you already called them. However, software issues requires pulling up your account, which I am unable to do in this public forum.

 

They can review previous case tickets, so you don't have to restate the concern. They can also escalate this incident to the Data Services Team who handles data corrections in QuickBooks. Here's how to get support:

 

  1. Go to the Help menu.
  2. Choose QuickBooks Desktop Help.
  3. Tap the Contact us button.



contact.png

 

Please don't forget to update me on how things goes. I'll be around if you need further help, as I want to make sure you're all set. Have a great day!

Level 1

Re: Bank reconciliation register balance doesn't match Balance doesn't match

The version of Quick Books we are currently using is Quick Books Online.  Under the File option, I do not have the choice to Close Company.  I would be more than wiling to try all of these steps.  Unfortunately, I have no intentions of contacting the Phone Support center again.  I referred to the case tickets on all 4 phone conversations and they state they are unable to repair data and keep stating  that the checks were entered after the account was reconciled and suggest that we undo the reconciliation.  I have already done that.  If I am unable to repair the data myself and they tell me that they can't help, I don't know where I can go from here.  I don't have any of the options that Quick Books Community is showing me, but this site has been helpful with suggestions.  

QuickBooks Team

Re: Bank reconciliation register balance doesn't match Balance doesn't match

Thanks for letting me know that you're using QuickBooks Online (QBO), @RuthieG9999

 

I understand how you feel when you're unable to finish your task as soon as possible. Rest assured I'm here to share with you some steps so your register balance will match your Balance Sheet totals. 

 

I've checked your conversation above. It could be there's a data damage, that's why your bank reconciliation register balance doesn't match with the report. Also, the Balance Sheet report runs on a calendar year. If your company's fiscal year is different than the calendar year, this could also be a possible cause why there are discrepancies. 

 

To help fix this, you can change your fiscal year in the settings to match the calendar year. Let me guide you how. 

  1. Go to the Settings (Gear) icon at the upper right.
  2. Select Account and Settings.
  3. Go to Advanced from the left menu. 
  4. Click the Accounting section. 
  5. Choose January from the First month of income tax year drop-down menu.
  6. Select Save.
  7. Click Done.

 

The screenshot below shows you the last five steps. For more details, see the Why doesn't my Balance Sheet match my register? section through this article: Basic Troubleshooting for Balance Sheets

CheckFiscalYear.PNG

 

You can check out this link: Reconcile Workflow. In this article, you can learn more about starting the reconciliation process, fixing discrepancies and completing it. This ensures your accounts are accurate in the program. 

 

I'll be right here to help if you have other concerns. Have a great day, @RuthieG9999

Level 1

Re: Bank reconciliation register balance doesn't match Balance doesn't match

This isn't my issue but thank you for trying.  The previous posts were related to a data damage issue that I am sure is causing the missing information on my bank reconciliation report.  It doesn't appear that I have a way to fix this.  I never had this problem until a QuickBooks update happened in August.  The fiscal year setting , etc., has nothing to do with the missing information on the Bank reconciliation.

Moderator

Re: Bank reconciliation register balance doesn't match Balance doesn't match

Hello, RuthieG9999.

 

The amounts on the two reports may be overstated due to reasons like different date ranges and reporting basis. The Reconciled Balance from the Reconciliation report should match the Balance Sheet and the Register's running balance for that same Date you used when you reconciled. 

 

Also, one of the reasons why the balance sheet and register don't match is if your company's fiscal year is different than the calendar year. You have to options to resolve this, you can either change the date of the report to match your fiscal year or change your fiscal year to match the calendar year.

 

To change the date of the report. I'd be glad to share you the steps on how to do it:

 

  1. From the left menu, select Reports.
  2. In the search bar, search for and open the Balance Sheet report.
  3. Select Customize.
  4. Then choose the appropriate Report period.
  5. Select Run Report.

To change your fiscal year on the company file:

 

    1. Click the Gear icon on the Toolbar, then Account and Settings.
    2. From the left menu, select Advanced.
    3. In the Accounting section, select the edit (pencil) icon.
    4. From First month of income tax year drop-down, choose January.
    5. Select Save.

      z.PNG

The following articles are good references:

 

You can always get back to me if you still need help with matching your reports in QuickBooks. I'll stick around to help.

Highlighted
Level 1

Re: Bank reconciliation register balance doesn't match Balance doesn't match

The reason our Register Balance as of 9/30/19 does not equal the amount of the Balance Sheet is because there are 40 items missing on the Uncleared Checks/Payments section of the Bank reconciliation report - the exact amount of the difference between the two totals.  In our case, it has nothing to do with the report dates and fiscal year.  I will see what happens in October.

 

Level 2

Re: Bank reconciliation register balance doesn't match Balance Sheet

Thank you all for the help! The issue is fixed :)

Level 1

Re: Bank reconciliation register balance doesn't match Balance Sheet

what was the solution? We have a similar issue started 10/31

Level 1

Re: Bank reconciliation register balance doesn't match Balance doesn't match

did you ever resolve? We are having the same issue but with October

QuickBooks Team

Re: Bank reconciliation register balance doesn't match Balance doesn't match

Thanks for checking, lm-1290.

 

Bank reconciliation register balance not being match with the bank statement balance can be caused by the following:

  • Different dates used when running the report. 
  • There are duplicate transactions.
  • There are modified or deleted transactions.

We'll have to make sure the dates for each report are the same. Otherwise, you'll need to check the dates on the individual checks and deposits.

 

If you're using the QuickBooks Online (QBO) version, you can follow the recommended troubleshooting steps shared by my colleagues RaymondJayO and RoseMarjorieA.

 

If it's the QuickBooks Desktop version that you're using, reviewing the Audit Trail is the first step to check if there are reconciled transactions that were deleted or modified.

 

Here's how:

  1. Click the Reports at the top menu and select Accountant & Taxes.
  2. Select Audit Trail.
    QBDTaudittrail1.PNG
  3. Click the Customize Report button.
  4. Go to the Filters tab and set a date range.
  5. Click OK and look for the transaction. Take note the details of the transaction, and recreate it.
    QBDTaudittrail2.PNG

I've got some helpful resources for more information while working with reconciliation in QuickBooks Desktop:

Be sure to get back to me if you have additional questions. I'd be more than happy to answer them. You have a great day ahead.

Level 1

Re: Bank reconciliation register balance doesn't match Balance doesn't match

We're using QBO.

 

We've done all of that - looking for other user feedback since its seems like this is a QBO issue.. 

 

The register balance on the rec. report is controlled by QB, users cannot adjust that directly. The register balance on the rec report doesn't match the actual register balance on that same date. Dates match, there are no uncleared transactions, issues with fiscal year etc. 

 

Thank you!

Need to get in touch?

Contact us