Reconciling Receivables When Payments Come Through Multiple Channels

A client pays your invoice. The money leaves their account. But somewhere between their bank, your payment portal, and your books, the payment disappears. You follow up for a payment that was already made. They're annoyed. You're embarrassed. And the root cause is a process problem that has nothing to do with either of you.

Why Multi-Channel Payments Break AR

Ten years ago, most small businesses got paid one way: cheque or direct deposit. Today a single business might collect via credit card through Stripe, e-transfer to their bank account, payments through a client portal like Bill.com, and occasionally an old-school wire. Each of those channels hits your bank statement differently, and none of them automatically talk to your AR ledger.

The result is an accounts receivable balance that's always slightly wrong. Invoices that were paid show as outstanding. Cash that arrived hasn't been applied. Your aging report becomes unreliable, and chasing collections gets harder because you can't tell which overdue invoices are actually overdue.

What Owners Get Wrong

The most common mistake is treating AR reconciliation as a bank reconciliation problem. They're related but different. Bank reconciliation confirms that your books match your bank statement. AR reconciliation confirms that payments have been matched to the right invoices in the right amounts.

A payment can clear your bank reconciliation perfectly and still leave an invoice open in AR if no one applied it. This happens constantly with e-transfers, which arrive as a lump deposit with a memo that may or may not match the invoice number. The bookkeeper records the deposit but doesn't clear the invoice. The invoice ages. The client gets a collection call.

The second common mistake is letting unapplied payments sit. Most accounting systems have an "undeposited funds" or "unapplied payments" bucket. Check yours. If there's money sitting there, it means payments came in but no one matched them to invoices. That bucket should be empty at the end of every month.

The CFO Perspective

A service business with clients paying across three different channels was carrying about $40,000 in "outstanding" AR that was actually paid. The payments had cleared the bank but never been applied to invoices. When the owner followed up with those clients, half of them had email confirmations of payment. It was a process failure, not a collections problem.

The fix required two things: a monthly discipline of clearing the unapplied payments bucket before the close, and a naming convention for e-transfers so the bookkeeper could match deposits to invoices without guessing. Within 90 days, the AR aging report was reliable enough to actually use for collections decisions.

Building a Multi-Channel AR Process

The goal is a single source of truth for what's owed and what's paid, regardless of how the payment arrived.

Map your payment channels

List every way a client can pay you. For each channel, write down: where does the payment show up in your bank? Does the system automatically apply it to an invoice, or does someone have to do it manually? This mapping exercise usually surfaces the gaps immediately.

Standardize payment references

E-transfers are the biggest problem because the client controls the memo field. Ask clients to put the invoice number in the memo. Put that instruction on every invoice you send. It sounds trivial but it eliminates most of the matching guesswork.

Clear unapplied payments weekly

Do not let the unapplied payments bucket accumulate. Set a recurring task: every Friday, anything sitting unmatched gets investigated and applied. If you can't figure out what an unmatched payment is for, call the client that week, not six weeks later.

Reconcile AR aging monthly before you chase anyone

Before sending a single collections email, pull your AR aging report and compare it against your bank deposits for the month. Any client showing overdue should have a payment you can verify actually didn't arrive. If you can't confirm that, check the unapplied bucket first.

What to Do About It

1. Pull your unapplied payments report today. In QuickBooks, it's under Reports. In Xero, check unreconciled items. If there's a balance, that's your first reconciliation project.
2. Add invoice numbers to your e-transfer instructions. Update your invoice template to include a payment reference line that asks clients to use the invoice number as the memo.
3. Connect payment portals to your accounting software. If you use a portal like Bill.com or Plooto, confirm the integration is pushing payment data through automatically. Don't assume it is.
4. Set a weekly unapplied-payments clearing habit. Fifteen minutes every Friday prevents a half-day reconciliation problem at month-end.
5. Make your AR aging report a monthly checkpoint. Before the close, your AR balance should reconcile to your open invoices. If it doesn't, find the gap before you send statements.

AR You Can Actually Use

An accurate AR report is the foundation of good cash flow management. When you can trust the aging, you know who actually owes you money and can prioritize collections intelligently. When you can't trust it, you're either chasing ghosts or missing real overdue accounts.

If multi-channel payments are creating AR chaos in your business, it's a solvable process problem. Book a free call at peterxiacpa.com/book.

Next step: run your numbers through the free CFO scorecard.