The short answer

Run the close in the same order every month over about five working days: cut-off and the last van and till closes, then cash and bank, then receivables, payables and goods received not invoiced, then stock, cost and VAT, then accruals and a review of the statements. Each step relies on the one before. Soft close while you review, close when done, and lock once signed off.

Key takeaways

  • Set a time on the last day after which new documents are dated next month, and tell reps and the warehouse beforehand.
  • Show van collections handed over on the last day but banked on the first as cash in transit.
  • Correct receivables, payables and inventory through their documents, never with manual journals to the control account.
  • Treat an old item in goods received not invoiced as either a lost bill or a wrong receipt.
  • Write a one-line explanation for every large income statement movement; if you cannot explain it, do not close yet.

What a closed month means

A month is closed when its figures are final: nobody can post into it, and the reports you send to the owner or the bank will read the same next month. Until then, every late invoice or forgotten receipt changes the profit after people have seen it.

A good close follows the same order every month, on the same working days, with one person owning each step. The order matters because each step relies on the one before it.

  1. Working day 1: cut-off, and the last van and till closes.
  2. Working day 2: cash and bank reconciliations.
  3. Working day 3: receivables, payables and goods received not invoiced.
  4. Working day 4: stock, cost of goods sold and the VAT review.
  5. Working day 5: accruals, a review of the statements, then the close.

Get the cut-off right

Cut-off means every event lands in the month it happened. Goods delivered on the 31st are a sale of that month, even if the invoice prints on the 1st. Goods received on the 31st are stock of that month, even if the vendor’s bill arrives next week.

For a distributor the risky edges are vans and late deliveries. Every van day up to the last day of the month must be closed, its cash handed over and its invoices synced before the month can be trusted.

  • Every delivery made by month end is invoiced in the month
  • Every receipt by month end is posted, billed or not
  • Every van day and till shift is closed and approved
  • Draft documents are posted or deleted, not left open

TipSet a time on the last day after which new documents are dated in the next month, and tell the reps and the warehouse in advance.

Reconcile cash and bank

Start with the money, because every other balance depends on payments being recorded. Match each bank account in the books to the bank statement at month end, and explain every difference: deposits in transit, cheques not yet cleared, bank charges not yet booked.

Cash collected by vans deserves its own line. Collections handed over on the last day but banked on the first should show as cash in transit, not vanish between the two months.

Tie receivables and payables to their records

The receivables account in the ledger should equal the open customer invoices, less unapplied payments and credits. The same goes for payables and open vendor bills. When they differ, the cause is usually a manual journal posted straight to the control account, or a document that never reached the ledger.

Then read the aging. Old invoices that will not be paid need a decision this month, not a note for later, and unapplied payments should be set against the invoices they pay.

TipDo not post manual journals to receivables, payables or inventory; correct them through the documents, so the ledger and its records cannot drift apart.

Stock, cost and goods received not invoiced

Compare the inventory account with the stock valuation as at the last day. When every movement posts its own cost, the two should agree exactly. Post any count adjustments found during the month before you compare.

Goods received not invoiced is the liability for stock you received but have not yet been billed for. Its balance should equal the value of receipts still waiting for a bill. An old item on that list is either a bill you lost or a receipt that was wrong.

VAT, accruals and a hard look at the statements

Review the VAT accounts against the month’s invoices and bills before any return is prepared. Check that every sales invoice carried the right tax code, and that input VAT is claimed only on bills you actually hold.

Accrue costs that belong to the month but are not yet billed, such as rent, utilities or freight, and post depreciation if you keep fixed assets. Then read the income statement against last month and the same month last year. A margin that jumped or fell sharply usually points to a cut-off or costing error, not to a good or bad month.

TipWrite a one-line explanation for every large movement in the income statement before you close; if you cannot explain it, do not close yet.

Close, then lock

Close in two stages. A soft close stops new postings while you review, and still lets you reopen if you find a mistake. The final close comes when the review is done. Lock the period for good only after the figures are signed off, for example after the audit at year end.

Close periods in order, and close the year only after its last month is final, so the year’s profit moves to retained earnings once.

Checklist: Month-end close checklist

  • Close and approve every van day and till shift
  • Post or delete every draft document
  • Reconcile every bank account to its statement
  • Tie receivables and payables to their aging
  • Compare inventory with the stock valuation
  • Clear old items from goods received not invoiced
  • Review VAT accounts against the month’s documents
  • Accrue costs that are not yet billed
  • Explain every large movement in the income statement
  • Soft close, review, then close the period

In Axon Suite

How Axon Suite handles it

Before you close, the close dashboard in Axon Suite sets six control accounts (receivables, payables, inventory, goods received not invoiced, tax and cost of goods sold) against the records behind them and says whether you are ready; a difference warns you but does not stop the close. Closing is refused while any journal is still a draft or debits and credits differ, an unreconciled bank account is flagged but does not stop you, and once a period is closed nothing posts into it from sales, purchasing, stock, the till or the van. Periods close in order, can be locked for good, and the year-end close posts one closing journal to retained earnings.

Feature

Ledger against subledger, before close

Before you close, Axon Suite sets each control account in the ledger against the records behind it. The close dashboard reads all six at once and says whether you are ready.

Open: Ledger against subledger, before close
Feature

Close and lock accounting periods

Close a period and nothing posts into it again, whether it comes from sales, purchasing, stock, the till or a rep’s van. Reopen it when you need to, in order, or lock it for good.

Open: Close and lock accounting periods
Feature

Trial balance, P&L and balance sheet

The trial balance, income statement and balance sheet read straight from the posted ledger. Each parent account totals the accounts beneath it, and the balance sheet tells you whether it balances.

Open: Trial balance, P&L and balance sheet
Feature

Aging and party statements

Aging buckets every open invoice and bill by its due date. A statement gives one customer or vendor their running balance with the same aging beneath it, printed in Arabic or English.

Open: Aging and party statements
Feature

Every journal names its source

Every automatic journal names the document that posted it, and every invoice, bill and credit note lists the stock movement and journals it raised. One click takes you from one to the other.

Open: Every journal names its source

Before you go

Questions owners ask

How long should a month-end close take?

A few working days once the routine is set. Most of the time goes into fixing errors found late, so a faster close comes from a cleaner month, not a faster team.

Can we reopen a closed month?

You should be able to, in order and with approval, until the month is locked. In Axon Suite a closed period steps back to soft closed and then to open, as long as the next period is not closed, and a locked one cannot reopen.

Should small differences stop the close?

Agree a tolerance in advance and record the reason for anything you carry forward. A difference you cannot explain, however small, often hides a larger one going the other way.

Glossary

Terms in this guide

Open the glossary

See your own van sale reach the ledger in 30 minutes.

Chat on WhatsApp