Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
New Member
Oct 8, 2026 5:32 PM UTC
Question

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! 

14 replies

Moderator
Oct 8, 2026 8:56 PM UTC

Amazing job narrowing this down to a single discrepancy. The $3,234.81 transaction likely became disconnected from your records when you adjusted the previous balance difference, which threw off your beginning balance. I suggest running the Reconciliation Discrepancy report to see exactly what changed since your last reconciliation.
 

You can then follow these steps to track down and fix the difference:
 

  1. Go to Transactions, select Chart of accounts, and open your bank register.

  2. Locate the lump-sum deposit, open it, and verify that both payments are still included and total $3,950.72.

  3. If the $3,234.81 payment is missing, it likely returned to Undeposited Funds. To fix this, edit the deposit, reselect that payment, and save.

  4. Return to your bank register and ensure the deposit shows an R (reconciled) status. (If it shows C or blank, update it back to R).

 

Check out other details in this article: Fix beginning balance issues in QuickBooks Online.

 

Please reply if you need further assistance.

New Member
Oct 10, 2026 1:21 PM UTC

That sounds incredibly frustrating, especially after spending days tracing the transactions and getting the difference down from $136k. I'm building a tool called FeedFix that flags potential gaps, mismatches, and duplicate transactions between bank records and QuickBooks. I'm looking for feedback from people who work through these issues. Would you be open to taking a quick look at a short demo using sample data? No account connection needed.

Bookkeeper.Mohib
New Member
Oct 10, 2026 6:23 PM UTC

Hi, nice work getting from $136k down to a single number. One thing stands out: your $3,234.81 payment plus the other card payment in that $3,950.72 deposit leaves $715.91, which is close to the 715 and change you were chasing. I'd suspect that one deposit is behind both numbers.

 

Try this:

 

1. Go to Transactions > Bank transactions, open the bank register, and find the $3,950.72 deposit.

2. Check that the lines inside still total $3,950.72. If the $3,234.81 payment was removed from the deposit, it drops back into Undeposited Funds and your reconciled total falls by exactly that amount.

3. If it's sitting in Undeposited Funds, edit the deposit, select that payment again, save, and confirm the status still shows R.

4. Run the Reconciliation discrepancy report (search for it in Reports) to see what changed since your last reconciliation.

 

Why: a reconciled deposit is one lump sum. Removing, editing or deleting a payment inside it moves the next beginning balance, even when the bank feed match looks fine.

 

When you open that deposit, what do the lines add up to?

New Member
Oct 12, 2026 3:58 PM UTC

I am back- so - i tried all the steps, I’m definitely overwhelmed. There is someone who is assisting our company with a few things that aren’t QuickBooks related, however they mentioned they are a certified quick books pro- So I have been trying to pick their brain- however they basically keep telling me, just keep working on the reconciliation. I’m at a loss at this point- I have moved a few things around as far as reconciliation status, and have gotten the beg bal down to being over now by 447.40 - there are essentially no more transactions that the status can be changed on at this point- we do a cash forecast model that essentially needs our updated numbers after reconciliation, and the owner wishes to go ahead with the cash forecast model, while the quick books pro advisor told me to “continue to work on the reconciliation” and he will call this afternoon. I don't particularly want to touch it in fear of making it worse - any advice? 

Bookkeeper.Mohib
New Member
Oct 12, 2026 4:06 PM UTC

That's a stressful spot, but you haven't made it worse. Changing statuses doesn't change amounts, and none of this touches your real bank balance.

 

Two practical things:

 

1. For the forecast: the owner doesn't have to wait. Use the ending balance from your bank statement as the cash starting point, and note the $447.40 as an open reconciling item. The difference sits in the QuickBooks register, not at the bank.

2. To find the $447.40: run the Reconciliation discrepancy report for that account (search for it under Reports) and look for any reconciled transaction that was edited, deleted, or had its date changed. Also check whether $447.40 matches one transaction, or is exactly double one. If it's double, for example a $223.70 item, something was probably entered with the wrong sign, like a deposit that should be an expense.

 

I'd hold off on an adjusting entry to force it until you know the source. Save that report to show your advisor on the call this afternoon.

 

Does $447.40 match a single transaction, or a couple added together?

New Member
Oct 13, 2026 7:54 PM UTC

Tip : One common bank reconciliation issue that people forget about, especially if they are re-connected disconnected accounts or merging chart of accounts, is to check the open balance equity.

 

It is very common if you change a transaction or someone deletes, moves, you have to find it.  As many have mentioned, checking the history will save time.

 

Don’t forget also in transactions under “more” there is an audit history where you can track which user is doing so it can be resolved to get them to stop doing. 

New Member
Oct 24, 2026 7:14 AM UTC

You've done the hard part already (136k down to a few hundred). One low-risk check: export the bank register for the problem months to Excel and list the bank statement transactions for the same months next to it.

Sort both by amount and line them up. Anything that's on one side and not the other, or same amount but different date or sign, is your $447.40.

Boring, but it doesn't change anything in QuickBooks, so you can't make it worse while your advisor looks at it. Agree with the others: don't force an adjusting entry until you know which transaction it is.