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?
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.
There were two checks dated January 1, 2019. I changed to dates and it fixed the problem.
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?
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.
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?
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.
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.
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.
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:
I want to know how this goes, so please leave a comment below. The Community is here to help. Wishing you the best!
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!!!!
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:
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:
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:
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!
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.
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.
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.
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.
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.
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:
To change your fiscal year on the company file:
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.
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.
Thanks for checking, lm-1290.
Bank reconciliation register balance not being match with the bank statement balance can be caused by the following:
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 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.
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.
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.