Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowHello,
We use QBO for our restaurant. We receive goods from several vendors multiple times a week, but frequently our vendors issue credit to us when items do not ship / arrive damaged / when we return beer kegs for keg deposits, etc. We pay these vendors with ACH transactions that group multiple invoices and credit memos on a weekly basis. For example, from a food vendor in a 7 day period we would have three invoices totalling say $4000, and two credit memos totalling -$200. The single ACH transaction a week later would come in as $3800 dollars.
When I attempt to match the ACH payment from the banking screen, I only see the invoices totalling $4000, and cannot include the credit memos to bring it down to $3800. I know that you can make a deposit for the credit memo and add that as a resolving transaction, but we never actually received any funds back to us, we simply weren't charged for the missing items from the vendor. They never gave us any money, they just deduct the amount from the bill before charging us, so why should it appear in the register as a deposit that never actually existed and won't be there on my bank statement?
I also have read on here that you can use the pay bills screen to apply vendor credits to specific bills, but after I do so, it marks the bills as paid, preventing them from being matched in the banking screen.
At this point it seems like it would be easier to just delete the vendor credits and manually add negative line items into each invoice, then match in the banking screen. Seeing as how we receive dozens of these transactions a month, I want to be sure that there's no streamlined way that QBO can do this for me before adding these additional steps to my bookkeeping work.
My apologies if I'm missing out on some fundamental accounting principle here or something, Quickbooks is not my strength.
Thanks
Hi there, RR_Will.
I appreciate you providing a detailed information on how transactions are made in QuickBooks. To help match the ACH payment from the Banking page, you'll first need to apply the credit to your invoices.
Here's how to apply the credit to bills.
Once done, go to the Banking page and match the ACH payment to the remaining invoice balance of the vendor. Check out this article as your guide: Categorize and match online bank transactions in QuickBooks Online.
Let me know if you have additional questions by commenting below. I'll be right here to help manage your vendor's transactions.
What if the invoice the credit memo should be applied to has already been paid in a previous month? So now I have an ACH payment for invoices plus one credit memo that QB will not allow me to match the CM to. I can't post the payment as it would be incorrect.
Thank you for joining this thread, texastj.
I want to ensure that your transactions are properly recorded in QuickBooks Online (QBO). I need more information about what you're experiencing so that I can provide the best answer.
Did you encounter any error codes or messages while matching the payment to the invoice? What happens when you match the invoices to the credit memo?
While waiting for your response, feel free to browse following links for further information on how to manage refunds, credits, and other customer-related tasks:
I appreciate any additional information you can share. I'm looking forward to working with you again.
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.