cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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!

29 Comments 29
Highlighted
Moderator

Bank reconciliation register balance doesn't match Balance Sheet

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.

Highlighted
Level 2

Bank reconciliation register balance doesn't match Balance Sheet

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

 

Thank you!

 

 

Highlighted
Level 2

Bank reconciliation register balance doesn't match Balance Sheet

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?

 

Highlighted
QuickBooks Team

Bank reconciliation register balance doesn't match Balance Sheet

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.

Highlighted
Level 2

Bank reconciliation register balance doesn't match Balance Sheet

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?

Highlighted
QuickBooks Team

Bank reconciliation register balance doesn't match Balance Sheet

 

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. 

Highlighted
Level 2

Bank reconciliation register balance doesn't match Balance Sheet

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.

Highlighted
QuickBooks Team

Bank reconciliation register balance doesn't match Balance Sheet

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!

 

Highlighted
Level 2

Bank reconciliation register balance doesn't match Balance Sheet

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!!!!

 

Highlighted
Moderator

Bank reconciliation register balance doesn't match Balance Sheet

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!

Highlighted
Level 2

Bank reconciliation register balance doesn't match Balance Sheet

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.  

Highlighted
Moderator

Bank reconciliation register balance doesn't match Balance Sheet

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

Highlighted
Level 2

Bank reconciliation register balance doesn't match Balance Sheet

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.

Highlighted
Moderator

Bank reconciliation register balance doesn't match Balance Sheet

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 2

Bank reconciliation register balance doesn't match Balance Sheet

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.

 

Highlighted
Level 2

Bank reconciliation register balance doesn't match Balance Sheet

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

Highlighted
Level 1

Bank reconciliation register balance doesn't match Balance Sheet

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

Highlighted
Level 1

Bank reconciliation register balance doesn't match Balance Sheet

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

Highlighted
Moderator

Bank reconciliation register balance doesn't match Balance Sheet

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.

Highlighted
Level 1

Bank reconciliation register balance doesn't match Balance Sheet

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!

Highlighted
Level 2

Bank reconciliation register balance doesn't match Balance Sheet

Has anyone received any ACCURATE resolution to this?  We have seen scores of posts from frustrated QBO users.  This problem seems to be persistent.

Highlighted
QuickBooks Team

Bank reconciliation register balance doesn't match Balance Sheet

Thanks for joining this thread, @lizlaz.

 

As mentioned by my colleague above, there are possible reasons why this doesn't match. One reason is because your bank or the transaction uses a different currency.

 

As the bank register will show the currency's balance while balance sheet report will give you the converted home currency balance.

 

For additional information about each of the possible reasons why your balances don't match and for the recommended fix or action, you can check these articles: 

 

 

Also, if you need further assistance, you may get in touch with our QuickBooks Online Support Team. They can pull up your account securely and can create an investigation if the issue persists.

 

Don't hesitate to add comment/post if you have any other concerns, I'll be glad to help you. Have a good one.

 

 

Highlighted
Level 2

Bank reconciliation register balance doesn't match Balance Sheet

I'm a long-time CPA and long-time user of QB so this "ain't my first rodeo"!  I, too, am having this problem with QBO.  This problem never happens with the desktop version.  Ever.  I spent an hour and a half on the phone with support on Friday.  And, we got nowhere!  The simple fact is that the "register balance" on the reconciliation report should match the balance sheet.  Intuit keeps pushing us to recommend QBO for our clients.  Hard to do that when something like this keeps happening.

Highlighted
QuickBooks Team

Bank reconciliation register balance doesn't match Balance Sheet

Hello, Mom_and_CPA.

 

We always value long time customers like you. I am a customer, too. I feel where you are coming from. It's a let-down whenever I spend that much time with support, only to end up nowhere. To make it up to you, I'd like to give out steps that can help resolve the issue here. 

 

The dates play an important role when displaying the data showed on the Balance Sheet. Let's make sure the Report period matches with your reconciliation. 

 

Another thing to look out for is the transaction. There could be one that isn't supposed to be reconciled, or there is an uncleared transaction that was reconciled. I'd recommend reviewing your reconciliation history to see if there's one. Here's how:

 

  1. Go to Accounting, then head over to the Reconcile tab. 
  2. Click the History by account link. 
  3. Select the reconciled bank account under the Account drop-down menu. 
  4. Choose the statement ending date where the amounts don't match with the Balance Sheet. 
  5. Click View report.

If there is an incorrect reconciled or unreconciled transaction, you can fix it by going to your Chart of Accounts. You'll want to open the bank's register and unreconcile or reconcile the transaction. Here's how: 

 

  1. In your Chart of Accounts, click the View register link for the bank. 
  2. Find and select the transaction in question. 
  3. Under the Check mark column, change the status to R or blank
  4. Click Save

 

ReconChange1.PNG

 

If you need more help undoing a transaction, you can check these articles: 

 

You can also try other solutions outlined in this article: FAQ: Basic troubleshooting for balance sheets.

 

Though, you might have already tried these during your call with support. I'd appreciate if you can provide more details about the issue. That way, I can narrow down the problem and provide the best possible solution. 

 

If you've tried all the possible steps here, I'd recommend giving our phone support another chance to help you. You can provide the previous case number (if the last agent provided it to you), so the next agent can continue where you left off.

 

You can use the same phone number, or you can contact us directly from your company file. Here's how:

 

  1. Click the Help icon.
  2. Hit the Contact us button. 
  3. Enter something like "Balance sheet doesn't match with reconciliation report" or similar.
  4. Proceed with the Continue button.
  5. Choose how you want to reach us. 

If you need help with other tasks, you can always visit our general support page with articles

 

I'm always here to listen to your concerns regarding QuickBooks Online. You can also include other follow-up questions you might have regarding the reconciliation process. I'm here to help. 

Need to get in touch?

Contact us