Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I have a deposit that's already been reconciled, but whoever matched it manually entered funds into the deposit instead of matching it to the corresponding payment. This is creating a duplicate amount which is causing a negative customer balance, the payment I'd still in the bank deposit area, and the duplicate that was manually added shows as unapplied.
I'm here to help you resolve this matter, @RockhoundingRanger98.
To rectify an incorrect transaction match, go to your bank register, and from there you can delete the transaction. This action will eliminate the mistakenly added deposit transaction and return the bank transaction to the For Review tab. You can follow these steps:
You can click Yes when you're prompted twice that deleting the transaction will throw off the balance the next time you reconcile and will place the transaction back under for review.
Afterward, return to your Bank Transaction's page where you can either directly match the transaction to the payment or create a new deposit for the payment and then associate it with the bank transaction.
Here's how:
After the matching process, let's re-reconcile the recently matched transaction. To do this, here's how:
You can also refer to Step 4 of this article for the detailed steps: Fix issues for accounts you've reconciled in the past in QuickBooks Online.
Moreover, I am adding this article to help you properly categorize your transactions: Categorize online bank transactions in QuickBooks Online.
Feel free to post a reply if you have further questions regarding your bank reconciliation process in QuickBooks Online.
You have a couple options:
1) Delete the payment that was applied to the invoice. That will reopen the invoice. Then, apply the manually-entered deposit to the invoice.
2) Reverse the payment that was applied to the invoice by creating a journal entry (JE) by going to New > Journal entry. The JE should debit A/R (select the customer's name under 'Name') and credit Undeposited Funds. Then, go to New > Receive payment and apply the credit created by manually-entered deposit to the A/R balance created by the journal entry. Then, make a $0 bank deposit to clear the duplicate payment to the negative deposit created by the journal entry.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here