Solved

Reconciliation cleared balance is correct but negative.

9 replies
0 views

Starting balance, ending balance, transactions and payments are all correct as well as the number deposit and payments - but the cleared balance is showing as negative. If it were positive, the difference would be zero. How is this possible?

QuickBooks Online

RainflurryAnswer

@h1landr

If your bank statement shows a beginning balance of $16,661.16, $22,624.01 in payments/withdrawals, and $5,520.17 in deposits, then it too must show an ending balance of -$442.68. It's just simple arithmetic:

$16,661.16

-$22,624.01

+$5,520.17

= -$442.68

What are the amounts on your bank statement?

Tori B

Good morning, @h1landr.

Thanks for taking the time to reach out to the QuickBooks Community.

To clarify, have you checked for any duplicate transactions that could be throwing off the balance? If not, here's how you can:

Go to Bookkeeping, select Transactions, then select All Sales or Expenses.
Sort the lists by date, customer, vendor, or amount.
If you find obvious duplicates, you can safely delete them.

Important: Only delete transactions if you're absolutely certain they're a duplicate or error. If you aren't totally sure, please talk to your bookkeeper. If you don't have an accounting professional, don't sweat it. You can find one here in our Resource Center.

If duplicates aren't your issue, I highly recommend checking our help guide: Fix issues at the end of a reconciliation in QuickBooks Online to see if you may have an underlying problem in another way.

Please let me know if you have any additional questions or concerns. Have a good one!

H

h1landrAuthor

I have just fixed duplicates and gone through the suggestions to fix issues at the end of reconciliation. Neither has changed the negative cleared balance. What else can I do?