Skip to main content
B
Brian_L
March 2, 2022
Question

I made a mistake on a deposit. How do I fix the downloaded transactions and apply it to a customer invoice?

  • March 2, 2022
  • 1 reply
  • 0 views

My issue started when I accidently entered the wrong amount on a check deposit through our banks online banking app.

Basically I put a deposit for $340690.00 when it should have been $3406.90.

We download transactions from the bank into Quickbooks online.

The bank download transaction shows the incorrect amount and then a ATM/Mobile adjustment for $337,283.10. ($3406.90 difference) So now in the Bank for review it shows both of these amounts Deposit and the correcting entry.

 

Normally when I download the transactions and there is a matching deposit to a customers invoice I click match. 

This then creates the A/R entry and then the item moves from the For Review to the Categorized in the Banking register. So now how do I fix this? 

I spent 2 hours on the phone with Quickbooks to no avail. I need to be able to do something with both downloaded transactions and apply it to the Customer invoice.

I have researched other articles in the Community but none I found have the same scenario.

 

Thanks for any help so that I can correct this and that my Sales Tax and Bank Statement reconcils.

1 reply

T
Trish_T
March 2, 2022

Hi Brian_L,

 

Thanks for reaching out here.  QuickBooks Online has the versatility you need to add, match, edit or delete transactions to keep your accounts aligned.  I'll be happy to provide more information so you can get back to what you love!

 

In this situation, I recommend opening the original Deposit, make the necessary changes ensuring the Date and all other fields are accurate, Edit the amount and then hit Save and close.  By doing this, the transaction will show as a 'Match' rather than appearing as 'Add'.  You access the original transaction right from the banking module by clicking on the item to open it.  This would be the second line as indicated in the screenshot you've provided.  Once the transaction has been matched, there's no need for the adjustment and that can be deleted.  Again, you'll just click on it in the Review tab to open the item, at the bottom you'll see More, click on that and select Void/Delete.  

 

Here's a great guide for your reference to assist with editing transactions in QuickBooks Online.

 

Please feel free to reach back out if you have other questions.  We'd be glad to assist!

B
Brian_LAuthor
March 3, 2022

Thanks for your response.

Being as we download transactions from the bank as compared to manually entering deposits, I am not able to manually change the amount downloaded.

 

I could be perhaps overlooking the obvious on how to edit.

If I add the transaction as a deposit to our checking account, and then go in the register and edit, it mentions this can cause issues...

It then does not appear back so I can match it to a transaction.

 

Thanks again for your help.

 

Terms & ConditionsAccessibility statement