Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I am using Desktop Mac 2021 Version 20.0.12 R13.2
I am trying o reconcile a bank statement with a beginning balance of $2,492.23 and an ending balance of $2,653.17. When I enter the ending balance and click "Go" I see that the "Cleared Balance" field is filled in with the "Beginning Balance" amount.
I tried to reconcile anyway, thinking that the end result would be a discrepancy equal to the beginning balance and that I could enter an adjustment. (Yes, I know that's not preferred, but . . .)
Instead, after clearing the credits and debits I see a discrepancy of $2967.84
What's going on? How can I correct the problem?
RE: When I enter the ending balance and click "Go" I see that the "Cleared Balance" field is filled in with the "Beginning Balance" amount.
Yes, that's normal. The Cleared Balance when you start a reconcile, if nothing is checked off in the two columns of data, is the same as the Beginning Balances, which in turn is the sum of all of the cleared transactions in the account. As you start marking things that are cleared on the bank statement, the Cleared Balance will change.
RE: I tried to reconcile anyway, thinking that the end result would be a discrepancy equal to the beginning balance and that I could enter an adjustment.
You should never need to enter an adjustment. Instead, make the things you're clearing the same as the things on the statement, and then the reconcile will balance. Ever, single, time. That's basically the point of reconciling.
RE: How can I correct the problem?
Make the things in your bank register match the things on the bank statement. Then the reconcile will balance.
Thanks for this, but why when I clear all the items (after double checking that everything on the statement is included in the reconcile window) do I wind up with
Cleared balance -314.67
Difference 2,967.84
Well, the formula is:
Starting balance + cleared deposits - cleared checks/payments = ending balance.
So, if the starting balance matches your bank statement, then if the cleared things also match, then the ending balance will be right on.
Most business bank statements include a total of payment and one of deposits, as does the reconcile window, so that may help.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here