# How to Match Bank Deposits to Invoices

- Author: PreciseBankFlow (https://www.precisebankflow.com)
- Published: 2025-01-26
- Updated: 2025-01-26
- Category: Payment and deposit reconciliations
- Canonical: https://www.precisebankflow.com/blog/match-bank-deposits-to-invoices

> How to match bank deposits to invoices when one deposit pays several invoices, short-pays one or arrives with no remittance, step by step.
To match bank deposits to invoices, start from each deposit on the bank statement, identify the customer, then find the open invoice or set of invoices whose total equals the amount. Apply partial amounts and record any shortfall. A deposit you cannot place after a set search goes to unapplied cash, never to the oldest invoice by default.

## What do you need before matching bank deposits to invoices?

Before matching bank deposits to invoices, gather three things for the same period: the bank statement lines that are customer receipts, the open invoice list by customer, and any remittance advice that arrived with the payments. Without the open invoice list as of the right date, a correct match can look wrong.

The bank statement is the starting point because it is the evidence the money arrived. Pull every credit for the period and remove the ones that are not customer payments, such as transfers between your own accounts, loan proceeds, processor payouts and refunds from vendors. What is left are the deposits to match.

### The working set

- **Bank credits** with date, amount and the full description the bank printed, including any company ID or reference.
- **Open invoices** with customer, invoice number, date, amount and any credit already applied.
- **Remittance advice**, which may arrive by email, in an ACH addenda record, in a lockbox file or on a check stub.
- **Customer contacts** for the accounts that often pay without remittance.

A remittance tells you which invoices the customer meant to pay, which settles most questions before they start. [Remittance advice reconciliation to payments](/blog/remittance-advice-reconciliation) covers reading remittances and recording the deductions customers list on them.

## Matching one bank deposit to several invoices, step by step

A combined deposit pays more than one invoice in one transfer. To match it, identify the customer, list that customer's open invoices, and find the combination whose total equals the deposit. If a remittance lists the invoices, check that their total agrees with the bank amount before you apply anything.

Follow these steps for each combined deposit:

1. Read the bank description for the payer's name, company ID or reference number.
2. Pull that customer's open invoices, oldest to newest.
3. If a remittance exists, total the invoices it names and compare the total with the deposit.
4. If no remittance exists, look for a run of invoices that adds up to the deposit, starting with invoices from the same billing cycle.
5. If more than one combination fits, stop and ask the customer rather than choosing.
6. Apply the deposit to the invoices found and note how the match was made.

Step 5 matters more than it looks. A customer with ten invoices of similar size can have several combinations that hit the same total. Applying the wrong set leaves the right invoices open and creates collection calls about bills that were paid.

## How do you match a deposit that short-pays an invoice?

A deposit that short-pays an invoice is applied for the amount received, and the invoice stays open for the rest. The difference is then sorted by cause: a customer deduction for a dispute, an early-payment discount taken, a bank fee on a wire, or a simple error. Each cause gets a different entry.

Do not close a short-paid invoice by writing off the difference unless someone with authority approves it. A small shortfall written off quietly every month can hide a pricing dispute or a customer who has learned that partial payments are accepted. The detailed handling of an amount received against a still-open bill is covered in [partial payment reconciliation for open invoices](/blog/partial-payment-reconciliation).

Overpayment is the opposite problem. A customer pays more than the invoice, perhaps paying a bill twice or rounding up. Apply the invoice in full and hold the excess as a customer credit; [customer overpayment reconciliation and refunds](/blog/customer-overpayment-reconciliation) explains when to refund it and when to apply it to the next bill.

## Deposits with no remittance: finding the invoices they pay

A deposit with no remittance can usually be placed from three clues: the payer name or ID in the bank description, the exact amount, and timing against when invoices were due. An amount that equals one open invoice to the cent is strong evidence. An amount that matches nothing needs a call to the likely payer.

### Clues in the bank description

ACH credits often carry the originating company's name, an ID and sometimes a short reference. Wires can show the sender's name and a free-text field. Mobile check deposits show nothing about the payer, so the check image is the evidence. Write the clue into the match note so the next person can see why the deposit was applied.

### Clues in the amount

- **One invoice to the cent**: likely, but confirm the payer name fits.
- **A sum of invoices for one customer**: likely a combined payment.
- **An invoice less a round figure**: a discount or a deduction.
- **An invoice less a small odd amount**: often a bank or wire fee taken in transit.
- **A round number matching nothing**: often a deposit on account, a payment plan, or the wrong customer.

## Fees, discounts and rounding inside invoice payments

Small differences between deposits and invoices usually have ordinary causes. Wire and foreign payments can arrive less an intermediary bank's charge. Customers may take an early-payment discount your terms offer. Card payments arrive net of processing fees. Each is a known cost, recorded to its own expense or discount account.

Set a written tolerance for these differences, such as a small dollar amount below which a difference is booked straight to a fee or discount account. Anything above it is investigated. The tolerance belongs in your procedures, not in each bookkeeper's head, and it should be low enough that a reviewer would not be surprised by any single write-off.

Card and processor payments should not be matched to invoices from the bank line at all. A processor payout holds many customers' payments, so match each charge in the processor report to its invoice, then match the payout to the bank. Mixing the two levels is how invoices get marked paid twice.

## Worked example: a week of deposits matched to open invoices

The example uses an invented company with six open invoices and five customer deposits in one week. All names and figures are illustrative.

### Open invoices at the start of the week

| Customer (example) | Invoice | Amount |
| --- | --- | --- |
| Harbor Dental | INV-301 | 1,200.00 |
| Harbor Dental | INV-307 | 850.00 |
| Harbor Dental | INV-312 | 430.00 |
| Ridge Cafe | INV-305 | 2,400.00 |
| Pine Logistics | INV-309 | 3,150.00 |
| Pine Logistics | INV-310 | 975.00 |

### Deposits and match decisions

| Date | Bank description (example) | Amount | Match | Entry |
| --- | --- | --- | --- | --- |
| Mar 3 | ACH CREDIT HARBOR DENTAL | 2,050.00 | INV-301 + INV-307, per emailed remittance | Apply both in full |
| Mar 4 | DEPOSIT (check) | 2,350.00 | INV-305, stub notes 50.00 for a damaged item | Apply 2,350.00, leave 50.00 open as a disputed deduction |
| Mar 5 | ACH CREDIT PINE LOG | 4,125.00 | INV-309 + INV-310, no remittance, only combination that fits | Apply both, note "sum match" |
| Mar 6 | WIRE IN REF 88213 | 430.00 | INV-312 equals the amount; sender name confirmed with Harbor Dental | Apply in full |
| Mar 7 | ACH CREDIT ORIG 4471 | 1,000.00 | No open invoice or combination fits | Post to unapplied cash, email likely payers |

At the end of the week, four deposits are matched, one invoice has a 50.00 deduction to resolve with Ridge Cafe, and 1,000.00 sits in unapplied cash with a dated note. Each line has a reason a reviewer can check. The Mar 6 wire shows why the amount alone is not enough: the match was confirmed with the customer before it was applied.

## Mistake: applying every deposit to the oldest open invoice

Applying each deposit to the customer's oldest open invoice is the default in many systems, and it is the most common matching mistake. It feels safe, because the total customer balance is right. But the wrong invoices are marked paid, so the aging report is wrong, disputes are lost, and the customer's statement no longer agrees with their own records.

Here is how it goes wrong. A customer disputes an old invoice and pays the three newer ones. Oldest-first application pays the disputed invoice and leaves the newest one open. Now your collections team chases an invoice the customer paid, and the dispute has disappeared from view. When the customer finally sends their ledger, nothing lines up.

The same discipline runs the other way when you pay suppliers. If your payments are applied to the wrong bills on their side, their statements will disagree with yours; [an accounts payable reconciliation template](/blog/accounts-payable-reconciliation-template) helps line up the vendor's statement against your bills and find the misapplied payment.

## When should an unmatched deposit go to unapplied cash?

An unmatched deposit should go to unapplied cash once a set search fails, typically after the payer has been contacted and no invoice or combination fits. Parking it there keeps the bank reconciliation complete without guessing. Unapplied cash is a holding account, so every item in it needs an owner and a date.

### Keeping unapplied cash from growing

- Record the date, amount, bank description and who is following up.
- Review the list every week, and clear items as remittances arrive.
- Escalate anything older than your set limit to the controller.
- Never let the account net positive and negative items into one tidy balance.

The bank side has to be complete before any of this means much. PreciseBankFlow foots each statement and matches statement lines against your ledger or register, so customer deposits that cleared nothing are listed as exceptions rather than missed. [Get started with PreciseBankFlow](/get-started) to try it on a month of statements.