Turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
- US QuickBooks Community
- :
- QuickBooks Q & A
- :
- Banking
- :
- Reconciled Balance vs Balance Sheet Balance
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
The reconciled balance for my bank account as of the end of the period shows a different amount than what is on my balance sheet for the same period end. What is the reason for the difference?
I thought maybe it could have to do with uncleared transactions, but I only had one outstanding transaction and the amount of the difference and the amount of the transaction do not match up.
Is there something wrong? The balance sheet shows the same balance as the what the register does, but that is not the same as what the reconciled balance shows for the same period end.
Labels:
18 Comments 18
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Reconciled Balance vs Balance Sheet Balance
Hello anwava,
Aside from outstanding transactions, here are other reasons why your QuickBooks and bank balances don't match:
- Duplicate transactions
- Edited or deleted transactions
- Transactions for a connected account
- Credit card (liability) account
Though, there are different ways to fix this depending on the what's causing the issue.
First, we can review the Audit Trailto see if there are reconciled transactions that were deleted or edited. Here's how:
- Click the Reports at the top menu and select Accountant & Taxes.
- Select Audit Trail and click the Customize Report button.
- Go to the Filters tab and set a date range.
- Click OK and look for the transaction.
- Take note the details of the transaction, and recreate it.
If you need more about how reconciliation work in QuickBooks, you can use these articles for reference:
- View Previous Bank Reconciliation Reports
- Resolve Common Issues on Previous Reconciliation Report
- Zero or Incorrect Beginning Balance in the Begin Reconciliation Window
Feel free to let me know if you need anything else.
For more information on taxes, forms, filings, payroll and other Year End activities, make sure to check out ourYear End Resources page.
Anonymous
Not applicable
December 20, 201807:36 AM
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Reconciled Balance vs Balance Sheet Balance
RE: The reconciled balance for my bank account as of the end of the period shows a different amount than what is on my balance sheet for the same period end. What is the reason for the difference?
The most common and normal cause is that there are uncleared transactions before the date of the balance sheet. Nothing needs to be done about this. You'll see the same balance in the bank register for the balance sheet date.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Reconciled Balance vs Balance Sheet Balance
The Reconciled Balance from the Reconciliation report should match the Bal Sheet and the Register running balance for that same Date you used when you reconciled. That does not need to match the bank's perspective.
Please see my attachment.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Reconciled Balance vs Balance Sheet Balance
@anwavawrote:The reconciled balance for my bank account as of the end of the period shows a different amount than what is on my balance sheet for the same period end. What is the reason for the difference?
I thought maybe it could have to do with uncleared transactions, but I only had one outstanding transaction and the amount of the difference and the amount of the transaction do not match up.
Is there something wrong? The balance sheet shows the same balance as the what the register does, but that is not the same as what the reconciled balance shows for the same period end.
The replies don't seem to be answering the question, and I may have a similar issue. The bank reconciliation has been completed. On the QBs reconciliation report the 12/31/2018 register balance is -4861.80. The register balance is, of course, after the uncleared transactions. The Balance Sheet balance for the same bank as of 12/31/2018 is -3,948.98. This is a difference of 912.82. There should be no difference between the register balance in the reconciliation report and the balance sheet, since the register balance takes the uncleared transactions into consideration. I've selected the bank reconciliation report that shows any changes since the original reconciliation, so it isn't a matter of the data having changed since it was reconciled. What causes this amounts to become out of sync and how do I fix it? I have run data integrity and a data rebuild, but the issue has not resolved. There were also no issues found.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Reconciled Balance vs Balance Sheet Balance
Hello there, @KristinaG.
Thank you for joining the Community. Allow me to help share additional ways to determine why the balance sheet report doesn't match your register.
If your company's fiscal year is different than the calendar year, the amounts on both the report and the register may not match because the Balance Sheet is run on a calendar year.
To fix this, I recommend changing the date of the report to match your fiscal year or the calendar year. Let me show you how:
- From the Reports menu, select Company & Financial.
- Choose Balance Sheet Standard.
- Select the appropriate report period.
- Select Refresh.
Otherwise,you'll need to check the dates on the individual checks and deposits to fix the discrepancy. For additional help, I recommend reaching out to our Customer Care Support. They can use the screen share tool todetermine what's causing the issue and help you get back to business in no time.
You may also want to visit our QuickBooks Resource Center for future reference while working with QuickBooks.
That should point you in the right direction today. Please know that I'm just a post away if you have any other questions about QuickBooks. I'll be happy to help you out. Have a great day ahead.
Anonymous
Not applicable
April 02, 201907:27 PM
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Reconciled Balance vs Balance Sheet Balance
There are 2 dates and 2 balances to keep separate in your mind:
Actual balance in Bank vs QB Register Balance
The reconciliation does not make these the same - it just explains the difference.
Also Reconciliation (bank statement) Date vs Report date - self explanitory.
QB financial reports always contain Register Balances as of Report Date.
Bank Balance (as of any past date) will not change.
But the register balances at any date can change after a reconciliation is done if new entries are made.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Reconciled Balance vs Balance Sheet Balance
Hi Kristina,
Did you resolve this? I have the same issue, but cannot resolve it. I expect the "register balance" on the bank rec to agree to the register (as at the same date) but they do not agree and I can't work out the difference.
Would be great if you had the answer.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Reconciled Balance vs Balance Sheet Balance
Let’s check out why the beginning balance of your reconciliation doesn’t agree with your register, Charley. I’ll also add information about the balance in the register and the Balance Sheet.
Before we start, we’ll have a little background to guide us through the process.
The reconciliation has two balances. The Ending Balance is from your bank statement, whereas Beginning Balance is from your register. The latter is from the last reconciled transaction in your register, as shown in the screenshot. It also reflects on the Balance Sheet.
If you delete, un-reconcile, add and reconcile a transaction, or edit a reconciled transaction, the beginning balance will change. This will cause a difference when you reconcile your account. The account balance in the Balance Sheet will change as well, except if you just un-reconcile a transaction.
To resolve this, you'll want to correct the Beginning Balance:
- Compare the transactions in you bank statement and your register, and make sure they are the same. If there are duplicates or missing ones, delete or recreate them. Then, mark them as reconciled.
- Check your Reconciliation Discrepancy Reports to see if there are reported changes. You can click on the transactions to correct them.
- Re-reconcile any unreconciled past transactions that shows on the report by placing a check mark in the field indicated. Please refer to the screenshots.
Please let me know if you're able to resolve the difference or if you still need more help.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Reconciled Balance vs Balance Sheet Balance
I just ran into this same issue and realized it is actually something simple and not so complicated. If the register balance on your bank reconciliation does not match the value on your balance sheet it is likely the cleared transaction from the next month. An example in my situation was we mailed out checks for bills that were due October 1st, those checks cleared our bank account in September so they are included in the bank reconciliation but not included on the balance sheet. I hope this helps.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Reconciled Balance vs Balance Sheet Balance
Thank you - that was incredibly helpful info -- that the balance of the account when the report was generated is included in the reconciliation report.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Reconciled Balance vs Balance Sheet Balance
That's it! It happened to me, too - super helpful, thanks!
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Reconciled Balance vs Balance Sheet Balance
Can you advise if you are on cash accounting or accrual, though it shouldn't matter. If the cash was actually removed from you're account, it should be removed from your balance sheet on the date of the removal and not the due date of the bill.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Reconciled Balance vs Balance Sheet Balance
Was this ever resolved? Each month, my beginning and ending balance matches the bank reconciliation and I have a completely cleared reconciliation that is in balance yet my register balance as of the end of the month (not the ending balance - the register balance) is never in sync with my balance sheet as of the end of the month. How can my reconciliation be in balance with the bank but not my balance sheet?
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Reconciled Balance vs Balance Sheet Balance
Nice to have you in the Community space, @sbasnett.
Incorrect dates affect the accuracy of your report, causing your bank balance not to match. To fix this, you’ll want to ensure you've entered the correct date so it matches the details of your reconciliation balance.
If the dates are accurate and the report is still not in sync with your bank balance, I recommend contacting our Support team. They have the tools to check your account and help you check why the report doesn't match your bank.
Here’s how to reach them in your QuickBooks Desktop (QBDT) software:
- Go to the Help menu.
- Select QuickBooks Desktop Help.
- Click Contact Us.
- Give a brief description of your issue, then proceed to Let's talk.
- Choose a way to connect with them.
Ensure to view their Support hours in this link to know when agents are available:Contact QuickBooks Desktop support.
Let me also add these articles that you can utilize to seamlessly manage your reports and accounts in the future:
You can always get back to me if you have other follow-up questions about your balance sheet report or with your account. It’s always my pleasure to help you. Have a great day ahead and stay safe!
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Reconciled Balance vs Balance Sheet Balance
Wish me luck... I am calling support. I have the same issue. I really hope that they DO have the tools to solve it.
Dates are correct
Everything is cleared.
Register balance on the bank recon does not agree with the balance sheet.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Reconciled Balance vs Balance Sheet Balance
In real world most of the time it will not match. Balance sheet cash balance come from Ledger and some trnx are in transit which hit one side only either bank or ledger like payment issued may not yet hit the bank and deposits(Ach or direct deposit) received is still not recorded in ledger. In reconciliation we only try to match with bank statement in actual Ledger it may vary because of the transactions which are not appear both side (or appeared only in one side) bank and Ledger.
Thanks - Kul
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Reconciled Balance vs Balance Sheet Balance
The balance sheet draws from the register and includes uncleared items. The reconciliations do NOT include uncleared items, that's the point of reconciliations, to find items that haven't cleared, for whatever reason. If your business is a dynamic environment, transactions of money in and out happening daily, it is highly unlikely all transactions will be cleared on any given day, so that balance sheets will not and should not match up with reconciliations.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Reconciled Balance vs Balance Sheet Balance
To get the Balance Sheet Balance to match the Reconciled Balance, Clear Payments of the uncleared transactions seen at the top of the reconciliation account page.
Featured
Benefits of Going Cashless for your Business: An Introduction to QuickBooks Payments
(view in My Videos) If you want to take payments on the go, check outQuick...
How do you think technology is changing the way we do business??
Join Emma & Sofia in their chat about how technology is revolutionizingthe...
QuickBooks Quick News: August 2024 Product Updates
Katelynne and Emma are back with the latest round of Quick News, wherethey...