cancel
Showing results for 
Search instead for 
Did you mean: 
mich5428
Level 3

Customer overpaid on invoice and I sent them an ACH transaction rather than give them a credit

Customer overpaid on invoice and I sent them an ACH transaction to their bank account rather than give them a credit. Of course, the amount they overpaid is showing up as a bank deposit in uncategorized income. How do I match the ACH payment transaction in my checking account bank feed to clear out the uncategorized income?

2 Comments 2
jenop2
QuickBooks Team

Customer overpaid on invoice and I sent them an ACH transaction rather than give them a credit

QuickBooks will search for an existing transaction with the same dollar amount when trying to find a match for the downloaded transaction, mich5428.
 
You mentioned that you sent an ACH transaction for the refund instead of a credit. Due to this, the system won't be able to automatically match the downloaded transaction. This is because there's no corresponding transaction in your register with the same dollar amount.

 

In addition, the ACH transaction you sent to the customer would be recorded as an expense/money out, whereas the overpayment received would be shown as income/money in. 

 

For the system to recognize them as a match, both elements must be booked to the same side of the accounting equation (inflows matching inflows, outflows matching outflows). 

 

To remove the amount from your Uncategorized income, you have the option to exclude it from being counted as a deposit. Let me walk you through the process:

 

  1. Go back to the For review tab.
  2. Look for the deposit and check the box before it.
  3. Select Exclude.

 

Here's an article about this process for more details: Exclude A Bank Transaction You Downloaded Into QuickBooks Online.

 

Alternatively, you can also manually create a corresponding transaction to both the ACH (expense transaction) and downloaded transactions (deposit) so you can match them together.

 

You can also check out this article as a guide on how to handle customer overpayments: Handle A Customer Credit Or Overpayment In QuickBooks Online.

 

Lastly, check out these additional resources to help you make the most of the online banking feature:

 

 

Feel free to come back to the Community whenever you have other inquiries about downloading banking data, categorizing transactions, or using QuickBooks for your bookkeeping. We're always available to address any other concerns you have.

mich5428
Level 3

Customer overpaid on invoice and I sent them an ACH transaction rather than give them a credit

Thank you, I don't really want to exclude it as it was income to our company. I would like to be able to have the uncategorized income amount somehow point to the ACH transaction we paid to the customer that is showing up in my checking account bank feed.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us