Remittance advice reconciliation is matching a customer's payment to the invoices it covers using the remittance advice, the note the customer sends listing which invoices they paid and any amounts they held back. You apply the receipt invoice by invoice, record each deduction against its reason, and chase the customer when a payment arrives with no advice.
What does a remittance advice tell you that the bank line does not?
A remittance advice tells you which invoices a payment covers, how much was paid on each, and why any amount was short. The bank statement shows only the payer's name, a date and one total. Without the advice, a single receipt covering ten invoices is a guess.
A remittance can arrive as an email, a PDF from the customer's payables system, a stub attached to a check, or text in the payment's reference field. Whatever the form, the useful fields are:
- Payer name and customer number, to find the right account.
- Payment date, method and total, to find the bank line.
- Invoice numbers and amounts paid on each.
- Deductions with a code or reason: pricing, short shipment, damage, early-pay discount, rebate.
- The customer's own reference, such as their payment run number, which helps when you ask questions.
Keep the advice with the receipt. If an auditor or the customer later disputes how a payment was applied, the remittance is the evidence.
Applying a payment to invoices from the remittance advice
Apply a payment from the remittance advice by splitting the bank receipt across the invoices it lists, in the amounts it lists. Each invoice either closes or keeps a balance. The sum of the amounts applied plus the deductions must equal the invoices' open total, and the amounts applied must equal the bank receipt.
Here is an example. The figures are made up.
A customer sends 11,274.00 by ACH. The remittance lists:
| Invoice | Invoice amount | Paid | Deduction | Reason on advice |
|---|---|---|---|---|
| 4101 | 3,200.00 | 3,200.00 | 0.00 | |
| 4108 | 2,850.00 | 2,793.00 | 57.00 | 2% early-pay discount |
| 4112 | 4,100.00 | 3,881.00 | 219.00 | Price difference, PO 7731 |
| 4117 | 1,400.00 | 1,400.00 | 0.00 | |
| Total | 11,550.00 | 11,274.00 | 276.00 |
Apply 11,274.00 across the four invoices as shown. Invoices 4101 and 4117 close. Invoice 4108 closes once the 57.00 discount is booked, if your terms offered that discount. Invoice 4112 keeps 219.00 open until the price question is settled.
Check the arithmetic before you post: 11,274.00 paid plus 276.00 deducted equals 11,550.00 invoiced. If the paid column does not add to the bank amount, stop and ask the customer before applying anything.
Recording deductions shown on a remittance advice
A deduction on a remittance advice is an amount the customer chose not to pay on an invoice, with a stated reason. Valid deductions are booked to the matching account. Disputed ones stay open on the invoice and go to whoever owns the customer relationship. Never write them off just to close the invoice.
Sort deductions into three groups:
- Allowed by the terms. An early-pay discount the customer earned, or a rebate in the contract. Book it to sales discounts or the rebate account.
- Valid after checking. A short shipment confirmed by the warehouse, or a price the sales team agrees was wrong. Issue a credit memo and apply it to the invoice.
- Not supported. A discount taken after the discount date, or a price the contract does not back. Leave the balance open and send the customer a short note with the invoice copy.
Track deductions by customer and reason. One customer taking late discounts every month is a pattern worth raising. If a deduction leaves the customer with money owed back to them instead, that is a different problem, covered in reconciling a customer overpayment.
What if the remittance advice never arrives?
When the remittance advice never arrives, apply the payment provisionally and ask for the advice. The safest default is to match an amount that equals one open invoice or an exact group of invoices. If nothing matches, hold the receipt as unapplied cash on the customer's account and contact them the same day.
Missing advice is most common with payment apps and bank transfers, where the customer types a short note or nothing. Payments through apps such as Zelle often carry only a name and a memo; matching those is covered in reconciling Zelle payments.
Do not apply a large receipt to the oldest invoices just because they are oldest. If the customer meant to pay newer invoices and disputes the old ones, you have closed the wrong items and the aging report is now misleading. Unapplied cash with a follow-up note is better than a confident wrong application.
When the remittance advice and the deposit disagree
When the remittance advice and the deposit disagree, trust the bank for the amount and the advice for the allocation, then find out why they differ. A bank fee on a wire, a payment split into two transfers, or a remittance sent for a payment not yet made are the usual causes.
Common mismatches and what to do:
- The deposit is a little lower than the advice. Often an incoming wire fee or an intermediary bank charge. Book it to bank charges if it is small and expected.
- The deposit is half the advice. The customer may have paid in two runs. Wait for the second before applying the whole remittance.
- No deposit at all. The advice may have been sent ahead of the payment. Do not apply it until the money posts.
- A different payer name. A parent company or a payroll-style payment service may pay on the customer's behalf. Confirm before applying.
One more case needs care. A remittance advice that asks you to note new bank details, or that comes from an unfamiliar email address, can be part of a payment fraud. Confirm any such change through a known contact, following the business's cash handling procedures.
The bank statement is the side that cannot be argued with. PreciseBankFlow checks each statement foots and lines its credits up against your ledger, so a receipt with no matching application is listed rather than lost.