Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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?
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:
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.
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.
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