How to run a monthly close in an afternoon
The TravelIQ team · 4 min read · Updated August 2026
Record the truth as it happens
Every hour of a painful close is the interest on a recording debt incurred weeks earlier. The booking whose expected commission was never written down. The split adjustment agreed in a hallway. The client payment noted "somewhere." Each was a thirty-second entry at the time; deferred to month-end, each becomes a fifteen-minute reconstruction involving two people's memories and an email search.
The rule that fixes it is unglamorous: the record is made when the event happens, by the person it happened to, or it doesn't count as having happened. Booking written — expected commission and split recorded then, by the advisor who knows them. Money arrives — logged that day. This isn't extra work; it's the same work relocated to the one moment it's easy. A month of it means month-end inherits a ledger instead of a mystery.
Reconcile exceptions, not everything
The weekend-long close checks every row because it trusts none of them — when records were assembled at month-end from memory, every line is a suspect. Once the record is made at the moment of truth, that logic inverts. Most rows are now right, and re-verifying them by hand is ritual, not control.
So close by exception. Lay expected against actual for the period and give your attention only to the rows that disagree: the statement short of the expected figure, the payment that should have arrived and didn't, the split that doesn't resolve. In a healthy month that's a handful of items, each an actual question worth a human's time — chase, correct, or document why the difference is real. Everything else gets confirmed at a glance, which is all a matching row ever deserved.
A fast close is a byproduct of good habits during the month, not heroics at the end.
Make the outstanding list live
The most valuable output of a close isn't the total earned — it's the list of who still owes you: every booking where the supplier's commission hasn't landed yet, and how overdue each is. In spreadsheet agencies this list is compiled at close, acted on for a week, and then goes stale until it's compiled again next month. Which means a missing payment gets noticed, on average, weeks after it went missing.
The list should be live — a standing view that updates when a booking is written and shrinks when money lands, consultable any Tuesday. That changes the follow-up rhythm from monthly archaeology to weekly housekeeping: scan it, nudge the two suppliers drifting past their window, done. And it quietly improves the close itself, because a receivables list you looked at all month contains no surprises on the day you total it.