Payment Methods, Deposits and Reconciliation: Closing the Month Faster

Most of the time lost at month end goes to 1 problem: what left the customer and what arrived in the bank are not the same number or the same shape. 3 habits close that gap, and none of them is about working faster.

The short version

A service business collects money in more ways than most small businesses: cards taken on site, cards taken over the phone, checks in the mail, bank transfers, and portal payments arriving in batches weeks after the work.

Each of those reaches the bank differently. A card payment arrives net of a fee, sometimes days later, sometimes grouped with other payments. A check arrives when somebody banks it, in a batch with others. A transfer arrives as itself.

Reconciliation is the exercise of matching those bank lines back to invoices, and it is slow for structural reasons rather than because anybody is being careless.

The 3 gaps that make it slow

Gap	What it looks like on the bank statement
Timing	A payment taken Friday appears Tuesday, in a different month
Amount	A card payment arrives net of fees, so it never matches the invoice
Grouping	One bank line covers eleven payments, and the office has to unpick it

The third is the largest and the most fixable. A bank deposit representing many payments has to be broken back down to invoices, and that job is either done at the moment of banking or reconstructed later from a paying-in slip.

Habit 1: record the payment where it happened, once

The most common cause of a broken reconciliation is the same payment entered twice.

A technician takes a card payment on site and it is recorded in the field system. The bookkeeper sees the money arrive and records it in the books. Now one payment exists twice, one invoice appears overpaid, and the bank line matches neither.

The rule is a decision rather than a feature: one system is where payments are entered, and every route feeds into it. Roopairs syncs payments and payment methods to QuickBooks, with payment methods moving bi-directionally, so the reference data stays consistent while the payment itself has one origin.

Which system depends on where the people who handle money actually work. What matters is that it is one of them and that everybody knows which.

Habit 2: bank in batches that match a record

The difference between a fast month end and a slow one is usually here.

Where checks and cash are banked, group them deliberately and record what was in each deposit at the time. One bank line then matches one recorded batch, and the batch lists its invoices.

The alternative, banking whatever is in the drawer and reconstructing it afterwards, means somebody sitting with a paying-in slip trying to work out which six invoices add up to a figure. That is an hour that did not need to exist.

Same principle for card settlements. Where the processor groups transactions, the settlement report is the batch record, and reconciliation becomes matching a settlement to a group of invoices rather than hunting individually.

Habit 3: put the fees where they belong

Card fees are the reason amounts do not match, and they should be a cost line rather than a mystery.

An invoice for a round amount that arrives slightly short is not a short payment. Recording it as one leaves a small residual balance on the customer's account, and a year of those produces an aging report full of amounts too small to chase and too numerous to ignore.

The correct treatment is that the invoice is paid in full and the fee is a cost. Where the processor reports gross and fee separately, that is straightforward. Where it reports net only, the fee has to be derived, which is worth setting up once.

The by-product is a number worth having: what card acceptance costs you annually. Most service companies have never calculated it, and it is occasionally large enough to change how they ask for payment.

Deposits and advances need a home

Money received before an invoice exists is the transaction that confuses everybody.

A deposit on an installation is not revenue and it is not a payment against anything. It is money held, and it sits as a credit on the customer's account until there is an invoice to apply it to.

Two things prevent it becoming a problem. Record what it relates to on the transaction itself, so the person applying it in three months knows what it was for. And apply it as soon as the first invoice exists rather than leaving it.

Unapplied deposits are the most common single cause of a customer showing overdue invoices while holding a credit that covers them.

What a fast month end actually looks like

Not a heroic three days. A short weekly rhythm that leaves little to do at the end.

Reconcile weekly rather than monthly. A week of bank lines is a manageable exercise and the transactions are recent enough that somebody can still explain them. A month of bank lines is a project.

Then the month end becomes checking that the reconciliation is complete, that unapplied credits and deposits are cleared, and that nothing is sitting in a holding account.

The other half of a fast close is on the payables side, where supplier bills matched against their purchase orders as they arrive leave nothing to reconstruct. A month end spent working out which parts bills relate to which jobs is the same problem in the opposite direction.

Service companies that close in a morning are not faster at the work. They did most of it in four short sessions during the month, and the difference compounds because each session deals with transactions people can still explain.

Roopairs runs a product tour where you can see invoices and payments syncing to QuickBooks Online or Desktop.

What service companies in the trade say

“Intuitive/easy to learn. There's room for improvement, but would definitely recommend for any trade company looking to simplify their invoicing process.” — Steven Cramer

Also worth reading

• Returns, Cores and Restocking Fees in Service
• Payment Options in the Field and What They Cost
• The rise of the ghost kitchen unlocking a new frontier of customers

Frequently asked questions

Why is bank reconciliation slow in a service business?

Three structural gaps. Timing, where a payment taken on Friday appears on Tuesday in a different month. Amount, where card payments arrive net of fees. And grouping, where one bank line covers many payments that have to be unpicked.

How do you stop payments being recorded twice?

Decide which system is where payments are entered and make every route feed into it. A card taken on site recorded in the field system and again by the bookkeeper produces an overpaid invoice and a bank line matching neither.

What should you do about card processing fees?

Treat the invoice as paid in full and the fee as a cost, rather than recording a short payment. Short payments leave residual balances too small to chase and too numerous to ignore, and a year of them clutters the aging report.

How should checks and cash be banked?

In deliberate batches with a record of what each deposit contained, made at the time. One bank line then matches one recorded batch. Reconstructing a deposit afterwards from a paying-in slip is an hour that did not need to exist.

Where do deposits and advances belong?

As a credit on the customer's account with a note of what they relate to, applied as soon as the first invoice exists. Unapplied deposits are the most common reason a customer shows overdue invoices while holding a credit that covers them.

How do service companies close the month in a morning?

By reconciling weekly. A week of bank lines is manageable and recent enough that somebody can still explain each one. The month end then becomes a check rather than the work itself.