Unable to Reconcile

I'm having a problem with bank reconciliation. We went with QB at the beginning of our fiscal year, though our business existed before we went to QB. We had two checks written before FY end. Our accountant made a journal entry for the opening balance, which we later had to correct. At one point, the reconciliation went OK. However, we later discovered that we had written a check against an expense that should have been against a liability. Our only solution was to delete the bill and the check that we had generated and then re-do the same check against the liability. (The check was to pay Goods and Services Tax (GST), FWIW).

Anyway, we tried to re-do the reconciliation and the QB open balance is just plain wrong. We have even unchecked all of the bank statement entries for that month and re-checked through the reconciliation function. Its only solution is to make its own journal entry that makes the month end balance correct but the opening balance is wrong.

Any assistance will be greatly appreciated.

Reply to
Tom Moreau
Loading thread data ...

Of course your opening balance was wrong, if you deleted a reconciled transaction. The solution is in QB help, but the upshot is this

Open the reconcile window.. enter as the ending balance the CLOSING balance of the previous month (this is the balance you want as your opening balance). Find the check you had deleted and re-entered and clear it. Now you should be able to reconcile.

When you re-open the reconcile window the opening balance will be corrected.

Reply to
Lisa C

Many thanx for this. When I used QB's solution, it was creating an Open Bal Equity entry. Using the prvious month's closing balance as the current month's closing balance and then letting it force the correction did the trick.

Reply to
Tom Moreau

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.