A Client Wired One Payment Across Four Invoices: How to Apply It

1. The remittance is a proposal, not a posting instruction

A remittance advice is the client's statement of how they intend the money to be spread - prepared by their accounts payable person, from their purchase orders, sometimes weeks after you raised the invoices. It is not a description of your ledger, and it only becomes one once you have checked it against your ledger.

So the first read is not "how do I enter this", it is "what does this disagree with". Before touching the keyboard, compare three numbers: what the remittance says the invoices total, what your open-invoice list says, and what actually landed. Where they disagree is the whole job.

2. The five moves

Whatever the software, the same five moves do the job, and the order is the point: each one keeps a different number honest.

1. Deposit gross, then split. Allocate the money that landed line by line; do not book one anonymous payment and disaggregate it later.
2. One payment per invoice, at the payer's stated amount. Four invoices means four payment records off one wire. If they state $5,050, key $5,050 and let the rest be separate.
3. The wire fee is a bank-fee expense, on its own line. Not a discount, not a credit, not a reduction of any invoice.
4. Cash nobody named goes into a bucket with a name. Held, not guessed at.
5. A short-pay stays open, with the reason in writing. A separate open item, not a rounding you absorbed.

Move 3 is where people lose the plot, because the shortcut is tempting: the deposit form is $25.00 short, so you key $25.00 less against one invoice and everything balances. In my example that is INV-1041 at $6,175.00 against a total of $6,200.00 - a payment matching nothing. The invoice stays open at a $25.00 balance nobody can explain, or you plug it, or next month their statement says it was paid in full and your ledger says it was not. A $25.00 bank charge has become a permanent disagreement with a customer.

Moves 4 and 5 are one discipline pointed two ways: never invent an owner for money you cannot identify, and never absorb a disputed short-pay, because absorbing it concedes it.

3. The worked example, added up in the open

Here is the whole case in numbers. The four invoices are $6,200.00, $4,850.00, $5,400.00 and $2,800.00, which is $19,250.00 open. On the account sits a credit memo of $350.00 from an over-billed line I corrected months ago and never offset against anything. The remittance proposes: pay INV-1041 and INV-1042 in full, pay INV-1043 with the $350 credit against it, and pay $2,375.00 on INV-1044 because their PO dropped one line item. Their bank deducted $25.00 from the principal, so the wire that lands is $18,450.00.

The cash column sums to $18,475.00 - that is what goes on the deposit form, before the fee. The deposit form then reads:

INV-1041 cash application    6,200.00
INV-1042 cash application    4,850.00
INV-1043 cash application    5,050.00
INV-1044 cash application    2,375.00
Wire fee, bank charges         -25.00
                            ----------
Deposit to this bank account 18,450.00   <- equals the bank feed line, to the cent

Notice that the $350.00 credit is not on the deposit form at all: no cash moved, so it is an invoice-side application that takes $350.00 off what INV-1043 is owed. The fee is the only negative line, and it belongs to the bank, not to a customer. And INV-1044 is deliberately still open at $425.00 with the client's own sentence against it, which is a correct answer, not an unfinished one.

Then check it from both ends. Down the receivable: $19,250.00 open, less $18,475.00 of cash, less the $350.00 credit = $425.00 still open, which is INV-1044's row and nothing else. Up from the bank: $18,450.00 landed plus the $25.00 the bank kept = $18,475.00, exactly the cash column. If either sentence does not come out true, the application is wrong somewhere and you have not finished.

4. The daily tie-out: one line, or the day stays open

The rule is an identity, and it is worth writing on a card because it is the only thing in this guide that is pure arithmetic:

applied  +  fees  +  unapplied  =  deposit

On the example: 18,475.00 + (-25.00) + 0.00 = 18,450.00. That is all it ever takes to close a banking day - three numbers that must sum to the line the bank gave you. If you cannot state them, the day is not closed, and the gap costs far more to reconstruct in three weeks than to find tonight. And unapplied = 0.00 is the goal, not the default: if the only way to make the line sum is to invent an owner for some of the money, you have not closed the day, you have hidden it.

Now the variant a messy PDF actually produces. Same wire, no credit on the account: $18,450.00 lands, so $18,475.00 needs a home after the $25.00 fee - but the paper names only three invoices at face value, 6,200.00 + 4,850.00 + 5,400.00 = 16,450.00, because INV-1044 was written as "the March branding one" and got dropped. $2,025.00 has no invoice named under it. The trap: INV-1044 sits open at $2,800.00, so you shove the $2,025.00 onto it and the deposit balances. But $2,800.00 minus $2,025.00 is $775.00, so you have invented a short-pay the client never mentioned on an invoice they never listed: a $775.00 open balance that neither side's paperwork supports, which is precisely the argument you cannot win later. Hold the $2,025.00 in a named place with the payer, date and wire reference attached, leave INV-1044 open at its real $2,800.00, and ask. The tie-out still holds with the residue named: 16,450.00 + (-25.00) + 2,025.00 = 18,450.00.

Subject: Wire of [date], $18,450.00 - which invoices?

Hi [Name],

Received, thank you. Your remittance lists INV-1041, INV-1042 and
INV-1043, which come to $16,450.00. The wire net of the $25.00
bank charge is $18,450.00, so $2,025.00 has no invoice named
against it, and INV-1044 ($2,800.00) is still open on my side.

Can you confirm what you intended the $2,025.00 to cover? I have
it parked as unapplied for now rather than guessing, so nothing is
closed that shouldn't be. Once you confirm I'll apply it the same
day and re-send the statement.

5. What this looks like in each system

The moves are the same everywhere; only the vocabulary changes. QuickBooks Online is the one system I could check against its own help article while writing this: Intuit's "Record and make bank deposits in QuickBooks Online" says to put transactions you need to combine into Undeposited Funds, open Create Bank Deposit, tick each payment, and for the fee use Add funds to this deposit to "enter the fee as a line item", choosing Bank Charges & Fees from the account dropdown. That is move 3, button names verified.

I could not verify the equivalent click path in Xero or Wave - their help centres would not serve me the pages - so I will not describe screens I have not seen. What holds in both is the shape from section 2, which is vendor-independent. Search your vendor's own help for "multiple invoices", "bank charge" and "unapplied" before following anyone's click path, mine included.

A plain spreadsheet is a legitimate answer, not a fallback. Two tabs:

OPEN-INVOICES tab
  invoice | issued | due  | amount | cash applied | credit applied
          | fee charged | still open | reason for any short-pay

DEPOSITS tab, one row per deposit line
  date | payer | bank line | invoice | cash | credit | fee | unapplied
  fee goes in as a NEGATIVE number (-25.00), same as the deposit form
  per-day check: =SUM(cash) + SUM(fee) + SUM(unapplied)  must equal the bank line

The reason column is not decoration. Three months from now, the $425.00 on INV-1044 is either a sentence you can quote back or an argument you cannot win.

6. Two fixes that cost nothing

Everything above is downstream cleanup. The two changes that remove the problem are upstream, need no software, and can be in writing this week.

Put the invoice number in the wire reference, as a term of sale

Not as a favour to your bookkeeper: as a stated condition the client agreed to. Two sentences, and the mismatching wire stops being your problem:

Invoice footer:
  "For bank transfers, please quote this invoice number in the
   payment reference. For payments covering more than one
   invoice, quote every invoice number, or attach a remittance
   advice listing them. We apply payments to the invoices named
   in the reference or advice we receive."

Contract, payment section:
  "Client will include the invoice number in the payment
   reference. Where one payment covers several invoices, Client
   will list which invoices and how much against each, in
   writing, at the time of payment. Absent that list, Provider
   applies the payment to the oldest open invoice."

Two honest limits. Wire reference fields are short, and your bank is the authority on how short, so at four invoices deep the "attach a remittance advice" branch is the one that will get used. And the default rule at the end - oldest open invoice first - is what saves you when no list ever arrives: your application is defensible because it was disclosed in advance, not because you guessed well.

Send a monthly statement of open invoices, with due dates

One page, once a month, to every client with more than one invoice out: number, issue date, due date, amount, total. It costs two minutes and kills the class of problem, because it makes your open-invoice list the canonical list for both sides. When their AP person decides what to pay and how, the statement is the document in front of them, so their remittance gets built from your numbers instead of their purchase orders, and the mismatch surfaces before the money moves. Note the $18,900.00 below: $19,250.00 of invoices less the $350.00 credit, with the credit shown as its own line rather than quietly reducing an invoice.

Subject: Statement of open invoices - [Client], as of [date]

Hi [Name],

Open on your account as of [date]:

  INV-1041  issued [date]  due [date]   6,200.00
  INV-1042  issued [date]  due [date]   4,850.00
  INV-1043  issued [date]  due [date]   5,400.00
  INV-1044  issued [date]  due [date]   2,800.00
  Credit CR-2207 (unapplied)                        -350.00
  --------------------------------------------------
  Total outstanding                               18,900.00

If you're settling more than one of these in a single payment,
please list the invoice numbers and the amount against each so
I apply it the way you intend. Anything else on the account,
flag me and I'll fix it today.

7. When manual is the right answer

This is where I argue against buying something. The two time figures below are my estimates, not measurements - replace them with your own before trusting the conclusion:

assumption: about 3 minutes to key one payment against one invoice
            from a remittance, including opening the invoice and
            reading the client's note
assumption: about 15 minutes on each banking day you receive anything,
            to match the deposit lines to the bank lines and write
            the one-line tie-out

   invoices x 3 min        +  banking days x 15 min   =  the month
   10 x 3 =  30 min        +   6 days  =  90 min      =  120 min  =  2.0 h
   40 x 3 = 120 min        +   9 days  = 135 min      =  255 min  =  4.3 h
  150 x 3 = 450 min        +  15 days  = 225 min      =  675 min  = 11.3 h

The conclusion, stated plainly: below roughly 40 invoices a month, keying it manually from the remittance is the correct answer, and nothing you buy beats it. Read the table honestly, though, because it cuts against me - at 40 a month you are looking at roughly four hours, and that "40" is my judgment, not a number derived from the table. What the table does show is where the hours go at small volume, and it is not the keying: below about 40, most of the time is the fixed daily overhead, which an automated rule has to replace and would then silently fail on. Four hours of clerical work that ends with you having read the client's note is a position you can hold and improve. A rule set is not free either: it costs setup, and it costs an audit every time a payer changes how they send money. Above 40 invoices a month the keying term dominates and the argument genuinely changes.

Either way the payoff is upstream, which is why the free fixes came first: they do not make keying faster, they cut the number of payments that need a human. And be clear what automated matching is really selling - not speed, a promise that you never have to look. Refuse that part: a rule that closes an invoice unseen moves the moment of discovery from tonight, where it costs a minute, to the client's next statement, where it costs credibility.

What this guide does not decide

• Whether the short-pay is legitimate. Reading their PO against your scope is a contract question, not a cash-application one. Applying it does not concede it, which is why the open item and the reason have to exist. To price what $425.00 sitting costs you, the late-fee calculator does that arithmetic offline from a rate you type in; it will not say whether you are entitled to it.
• Which accounting standard or tax treatment applies. What account the $25.00 lands in, whether a credit reduces income, whether revenue is recognised gross or net: those belong to whoever signs your books. This guide separates the fee because separating it is what makes the invoices close, and stops there deliberately.
• Anything about your bank's charge arrangement. The $25.00 came from a bank deducting charges from the principal rather than adding them on top - on a SWIFT-type wire that designation is BEN, against OUR and SHA. Whether your client chose it is a conversation with two banks. The only claim here is mechanical: a charge of bank origin is not a reduction of an invoice.