- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Matching multiple invoices and vendor credits in banking from a single ACH transaction
Hello,
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