Monthly reconcilliation Beginning Balance issues
Hey guys, just an office manager here of a small business that needs all the help I can get!
a little backstory, I started with this company Aug 31st and they had just moved to QBO from desktop. As a result of that, someone had set up our account that the owner had hired, and I was tasked with entering all data from 2026- invoices, expense receipts, payments- the entire 2026 backlog up to that point. As you can imagine it took a couple of weeks, and some things are still being found and added. I reconciled each month based on the bank statements, or so I believed they were all reconciled. I have used QBO in other offices previously. I was attempting to reconcile September when I saw that the beg balance was roughly 136k dollars off. It took two days of tracing transactions, but I am glad to say that the bulk of it is handled- that being said, I got down to 715 and some change yesterday being the only amount of difference- most of it coming from matching/attaching I had done incorrectly on outgoing checks. I fixed a ton of things yesterday, to the pint that the “we can help you fix it” link wont even generate anything- it simply says “ review monthly history summary” which we all know does not update or make the corrected transactions “fall off”. When investigating, i began playing with a payment that we received in an amount only 3 cents off from the beg balance difference. My boss and I got it down to 3 cents difference (negative). By plugging in a transaction that was only three cents off. It made perfect sense and we were going to just make the 3 cent adjustment. However, upon looking into the payment we received that was so close, it was showing deposited with another payment in one lump some to our physical bank statement and both were credit card payments. I thought, aha I need to make certain that it is showing as the lump sum of both in our bank register- yeah- that total lump sum was 3950.72 - the second transaction in that lump sum was for the amount of 3234.81- I have no unmatched, rematched, logged out, reconciled, unreconciled, marked clear- everything I can possibly think of but our beg bal for reconciling is STILL showing -3234.81- Somehow I have affected a link in the chain with this payment and I have been researching for HOURS. SEND HELP!