A good close is not just fast; the numbers are proven before sign-off. These guides cover close checklists and calendars, accruals and prepayments, journals, cut-off, flux analysis and reporting, so the close finishes with every balance supported and every open item owned.
Use a month-on-month flux analysis to catch posting errors in balance sheet accounts before sign-off, with thresholds, an Excel layout and what to look for.
Practical month-end cut-off procedures: what to test either side of the period end, how to spot errors, and the documents that prove the right period.
A practical checklist for reviewing the trial balance at month end: what to check, the errors it catches and an Excel layout that makes the review fast.
A journal entry template in Excel with the fields auditors expect, built-in checks that stop unbalanced or incomplete journals, and a simple approval record.
When to use recurring journal entries, how to set them up with owners and end dates, and the monthly review that stops them running long after they should stop.
Build a month-end close checklist template in Excel: tasks, owners, reviewers, working-day deadlines, status tracking and overdue flags.
The month-end close KPIs worth tracking, from days to close to post-close adjustments and reconciliation timeliness, with Excel formulas.
Set out who does what in the month-end close with a RACI matrix, an Excel layout and formula checks that catch gaps and overlaps.
What reversing journal entries are, when to use them, worked examples and Excel checks that make sure every reversal posts once and only once.
Accrued revenue vs deferred revenue: the month-end journals for each, an Excel release schedule for deferred income and the checks that keep both right.
What goes in a month-end management reporting pack: summary, profit and loss vs budget, balance sheet, cash, KPIs and commentary, plus checks before issue.
How finance teams use SUMIFS to total a general ledger export by account, period, cost centre or entity, with date ranges, wildcards and the mistakes to avoid.
Fix dates that Excel treats as text after a system export: how to spot them, convert them with DATEVALUE, DATE or Text to Columns, and handle day-month order.
Use Excel data validation to stop wrong entries in finance templates: dropdown lists, date and amount limits, unique IDs and preparer versus reviewer checks.
Excel formulas for budget versus actual variances and percentage change that handle zero and negative bases, favourable or adverse signs and threshold flags.
A simple structure for monthly management accounts commentary: headline, variances that matter, causes, actions and outlook, with examples.
Practical spreadsheet controls for finance: structure, locked formulas, check cells, version control, review evidence and how to find hard-coded numbers.
How to use pivot tables at month-end: trial balance summaries, month-on-month movements, variance reviews, GETPIVOTDATA links and refresh checks.
What makes an Excel workbook a control system rather than a template, and which controls a financial controller should put in place first.
Close the books faster by moving work out of close week: a dated close calendar, early reconciliations, set cut-offs, journal templates and materiality.
How to calculate and post accruals and prepayments at month end, with journal entries, worked examples, reversals and the schedules that support each balance.
Build a month-end close calendar in Excel that dates every task by working day, skips weekends and holidays, and flags late tasks automatically.
The controls that stop manual journals becoming a route for error or fraud: approval by someone else, support for every entry and review of late entries.
A year-end audit preparation checklist: the reconciliations, schedules and evidence auditors ask for, and how to prepare them before fieldwork starts.
Build a prepaid expenses schedule in Excel that releases each prepayment month by month, agrees to the ledger and flags items that have already expired.
Compare actuals with budget each month, set thresholds for which variances to explain, and write commentary that management can act on rather than just read.
12 questions on how strong your close controls are. Free to use online.
The Month-End Close & Controls System tests the trial balance against the sum of reconciled balances, keeps every open item on one exception dashboard and blocks sign-off while exceptions remain open. Excel, no macros, one-time price.
The Balance Sheet Reconciliation Library covers the balance sheet with nine working papers: a known error blocks sign-off, every supported balance needs an evidence reference and every aged item needs an owner and a next action. Excel, no macros, one-time price.
Accounts Payable · Payment Fraud · Reconciliations · Cash & Credit · Fixed Assets · Expenses · Comparisons · Glossary
Last updated 15 November 2026. General guidance for finance teams; check it against your own policies, systems and local rules.