Skip to main content
B
brookr1
December 25, 2022
Question

Unreconciling to match a previous customer payment

  • December 25, 2022
  • 1 reply
  • 0 views

Hello experts. 

I have a large number (but not all) customer invoices that have been paid and have a matching online banking transaction that are still showing in A/R. When I click on the invoice it shows the payment, and that same amount had been reconciled but I did not realize until now that they are not actually matched up, as they are still showing in unreconciled. They appear to be duplicates but when I click on them, the check number that the customer paid with is showing correctly. I dont understand what is happening. I enter the invoice and send to the customer. The customer pays via the quickbooks link. The transaction shows on my accounts. I match the transaction as it seems is the correct way. I have just reconciled for the past year - all with $0 difference but these invoices seem to be counting double in my quickbooks balance, i.e. My quickbooks balance vs my bank balance is overly inflated. Please help! Can I unreconcile all of the past year's statements so that I can fix each individual transaction. I tried deleting one customer payment but then it showed the invoice as unpaid even though their check seems to have cleared in a separate transaction. Ugh!

1 reply

DHeraV
DHeraV
December 25, 2022

Welcome aboard here in the Community, @brookr1,

Let me share some possible reasons why your balance was overstated even after being reconciled in QuickBooks Online (QBO).

You may have created a separate deposit from an invoice paid directly through the bank or deposited through Undeposited Funds and then matched it with the bank transaction. 

It is also feasible that you have added bank transactions to the register, which is why your balance shows as overstated.

Nonetheless, let me guide you on some workarounds to correct it. 

You can choose to undo the reconciliation and the bank transaction on the Banking page and match invoice payments.

Or you can also follow these steps:

The first is to undo reconciliation, here's how:

1. On your QBO account, go to the Accounting page, then select Chart of accounts (Take me there).
2. Locate the account that has the reconciled transaction, then select the View register.
3. Find the transaction. You'll see an "R" in the checkmark ✔ column if the transaction is reconciled.
4. Click the transaction to expand the view.
5. In the checkmark ✔ column, select the box with the “R” until the box is blank. This removes the transaction from the reconciliation.
6. Once done, click Save.
7. Then close the account register.

Second, delete the unreconciled deposit, and then undo matched/added transactions.

Lastly, match the correct transactions again and then reconcile.

Additionally, I'll share this article you may use for future reference if you want to learn how to review and edit your opening balance if you recently added older transactions to your account: Reconcile transactions that are older than your opening balance in QuickBooks Online.


Feel free to leave a reply if you need further assistance fixing your reconciled bank transactions. The Community team is here to help anytime. Happy holidays!

Terms & ConditionsAccessibility statement