Templates

Month-end close report template for bookkeepers

The close your client reads in two minutes, and the one question that costs them money if it waits, at the top.

September close — Brambling Studio LLC

Prepared 1 Oct · 214 transactions · bank reconciled

Summary

September is closed and it balances. 214 transactions, all categorized, bank reconciled to the penny against the statement closing balance of $48,912.03. Three things need you; one costs money if it waits.

The numbers

SeptemberAugustChange
Revenue$31,400$24,900+$6,500
Cost of sales$8,240$7,980+$260
Operating expenses$11,105$10,890+$215
Net$12,055$6,030+$6,025
Cash at month end$48,912.03$39,180.44+$9,731.59

Reconciliation: statement $48,912.03, ledger $48,912.03, difference $0.00. Revenue jump is invoice 1102 landing in the month, not a trend.

What needs you

  1. $4,100 to J. Okonjo, 14 Aug — contractor, employee, reimbursement or owner draw? If contractor, it is already late to report. Not guessed.
  2. $1,899 laptop from Apex Computing — above your $1,000 capitalization threshold. Asset, or rebilled to a client project?
  3. Three meals, $284 — client entertainment, staff, or personal? Tell me the pattern once and I stop asking.

Decided without asking

  • 11 recurring vendors categorized as last month.
  • $6,200 applied to invoice 1102 — amount, reference and date matched.
  • Payroll for two staff, unchanged. $62.40 of bank and card fees.
Example drafted to Mycel's quality bar. The firm is fictional and every figure is invented.

Why it works

  • The reconciliation is a number, not a claim.
  • Questions are asked, never guessed, with the cost of each answer spelled out.
  • What was decided is listed so the owner can check judgement, not trust it.

How to use the template

  1. 01Reconcile firstPut the statement balance, ledger balance and difference on line one. Nothing else matters if that is not $0.00.
  2. 02Compare to last monthRevenue, cost of sales, opex, net, cash. Explain any move over 10% in one sentence.
  3. 03List what needs the ownerEach item with the amount, date and the options. Put the one with a deadline first.
  4. 04List what you decidedRecurring vendors, matched payments, payroll. This is what gets corrected next month.
Download the template (.md)

Try it on one of your own clients.

Bring last month's version. Mycel drafts this month's in your style; you approve it, they pay.