I have spent the past couple of weeks clearing up 20 years' worth of open vendor balances. It's been a complicated and time-consuming ordeal, but I've finally got our aging A/P report to accurately reflect our A/P liabilities! Hooray!!
During this time, a lot of what I did was simply apply credits to open balances on the "Pay Bills" screen, but I've also had to fix checks that had incorrect vendor names and similar changes.
Unfortunately, now that I'm all done with that, when I go to reconcile my primary checking account, it is giving me the dreaded message: "Your account isn't ready to reconcile yet. Your beginning balance is off by $39,927. We can help you fix it."
On the "Reconciliation Discrepancy Report," it's showing me several transactions, but these do not add up to the discrepancy difference. Further, I can't find anything wrong with them. They're saying that I marked them as "reconciled in register," but these were transactions that WERE originally reconciled - when I look at the audit log, the only thing I did to them was change the vendor name; the amounts of the checks were the same.
Quickbooks is saying the difference is $39,927.
But the numbers in the report, here, add up to $68,505.56.
If I mark them as unreconciled, they'll show up in my next reconciliation, which would be weird and annoying, because their dates span across two decades. AND I don't think that's going to make the register balance anyway.
Any ideas about how to solve this issue?
(@Rainflurry?? You were a life-saver on my last post! Thanks again! If you have any thoughts about this one, I'd love to hear them.)
