← sources

Is everyone seriously still matching lump-sum deposits to multiple invoices by hand, or am I missing a trick?

source: reddit (reddit:Accounting)published 2026-11-17 07:18ingested 2026-11-18 02:36

retained text

Currently dealing with a recurring headache during month-end close:

A customer sends a single lump-sum deposit of say $14,850 that covers 4 or 5 different invoices, sometimes with a credit memo thrown in, and the vendor names don't match our ERP 1:1.

Right now, the workflow is basically sitting in Excel, running lookups that fail, and manually colour-coding rows to figure out which combination of invoices ties out to the deposit. It eats up hours.

 Is your team actually handling these unmatched exceptions? Is there a native feature in QBO/NetSuite or an Excel macro you swear by, or is everyone quietly brute-forcing this by hand?

How

frame this

document fetched 2026-11-18 00:18 · canonical https://reddit.com/r/Accounting/comments/1xye1rg/is_everyone_seriously_still_matching_lumpsum