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

> Retained reddit record from reddit:Accounting.

Canonical: https://highsignal.app/data/records/cff68365aa3197ec

[← sources](https://highsignal.app/data)


source: [reddit](https://highsignal.app/data/reddit) (reddit:Accounting)  published 2026-11-17 07:18 ingested 2026-11-18 02:36

[original source ↗](https://www.reddit.com/r/Accounting/comments/1xye1rg/is_everyone_seriously_still_matching_lumpsum/)

## 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
