Month-end, payroll and reporting

Month-end report example

A nine-page fictional management pack, from the executive overview to the figures, follow-up actions and basis of preparation.

What should a month-end report tell a business owner?

It should explain what the business earned and why its cash moved. In this fictional August example, sales were £50,000 and profit before tax was £6,000, but bank cash fell by £3,000.

Scroll across the table to read every column.

From profit to bank cash · fictional August 2026 · GBP
MovementCash effect
Profit before tax£6,000
Increase in stock−£9,000
Increase in receivables−£3,000
Increase in payables and accruals+£3,000
Movement in bank cash−£3,000

Working capital absorbed £9,000 net, more than the month's profit. The pack therefore directs attention to stock and unpaid invoices, rather than treating profit as money available to spend.

The example assumes no other cash movements. It remains a draft: a £600 platform fee is accrued while its invoice is awaited, and the cause of the gross-margin shortfall is unconfirmed. The basis of preparation explains the limits.

For the checks before preparing a report, use the month-end checklist. The complete example follows below and is also available as a PDF.

August 2026 · Fictional example · 9 pages

Download PDF

Page 1: Month-end management pack

Page 1 of 9: Month-end management pack
Read page 1 as text
In Good Order
                          MONTHLY MANAGEMENT ACCOUNTS

FICTIONAL EXAMPLE
Month-end
management pack

A small trading business

PERIOD                                               REPORT STATUS
August 2026                                          Draft 1
                                                     £600 fee estimate awaiting invoice

AUGUST 2026
£50,000                                 £20,000                               £6,000

Sales                                   Gross profit                          Profit before tax

CONTENTS

02   Executive overview                                  06    Profit and cash

03   Trading performance                                 07    Stock and payment timing

04   Profitability                                       08    Outstanding items

05   Financial position                                  09    Basis of preparation

ALL FIGURES ARE INVENTED

This is a fictional management report, not a client result, statutory accounts, a forecast or an assurance report.

ingoodorder.co.uk                                                                                        01 / 09
Open in PDF

Page 2: Executive overview

Page 2 of 9: Executive overview
Read page 2 as text
In Good Order                                                                                        01 / OVERVIEW
                 MONTH-END / AUGUST 2026

Executive overview

Sales met budget. Profit was £1,000 below budget. Bank cash fell by £3,000.

   SALES                                        GROSS PROFIT                                  PROFIT BEFORE TAX
   £50,000                                      £20,000                                       £6,000

   +£4,000 vs July                              40% gross margin                              £1,000 below budget

   CLOSING BANK                                 CLOSING STOCK                                 EQUITY
   £17,000                                      £27,000                                       £44,000

   £3,000 lower in August                       £9,000 higher in August                       £6,000 higher in August

August against budget                                                   Working-capital movement

   Actual           Budget                                              Increase in closing balances

Sales                                              £50k / £50k          Stock                                               +£9,000

Gross profit                                       £20k / £21k          Receivables                                         +£3,000

Profit before tax                                     £6k / £7k         Payables and accruals                               +£3,000

0                                                          £50k         Net cash absorbed                              £9,000

   MONTH-END ITEMS
   £4,000 of receivables is overdue. £2,000 of supplier payables needs a payment date. The £600 platform fee is
   accrued pending its invoice.

Gross margin was 40%, against a 42% budget. The cause of the shortfall remains unconfirmed.

In Good Order             Fictional example | All figures invented | Draft 1                                                  02 / 09
Open in PDF

Page 3: Trading performance

Page 3 of 9: Trading performance
Read page 3 as text
In Good Order                                                                                                02 / TRADING
                   MONTH-END / AUGUST 2026

Trading performance

July actual, August actual and August budget.

Monthly performance                                                                             July      August        Budget

£000
   60

                           £50k       £50k
   50            £46k

   40

   30
                                                             £19k       £20k      £21k
   20

   10                                                                                                     £5.5k      £6k       £7k

     0

                           Sales                                    Gross profit                              Profit before tax

  £                                                          July actual            Aug actual            Aug budget               Variance

  Sales                                                         46,000                50,000                  50,000                      0

  Cost of goods sold                                            27,000                30,000                  29,000                +1,000

  Gross profit                                                  19,000                20,000                  21,000                (1,000)

  Fees and delivery costs                                        5,500                  6,000                  6,000                      0

  Staff costs                                                    6,000                  6,000                  6,000                      0

  Other operating costs                                          2,000                  2,000                  2,000                      0

  Profit before tax                                              5,500                  6,000                  7,000                (1,000)

Variance = August actual less budget. A positive cost variance is an overspend.

   BUDGET VARIANCE
   Sales were on budget. Cost of goods sold was £1,000 over budget; all other cost lines matched budget.

In Good Order              Fictional example | All figures invented | Draft 1                                                          03 / 09
Open in PDF

Page 4: Profitability

Page 4 of 9: Profitability
Read page 4 as text
In Good Order                                                                                          03 / PROFITABILITY
                   MONTH-END / AUGUST 2026

Profitability

August 2026 | Sales £50,000; profit before tax £6,000.

Sales to profit                                                                     Sales        Profit       Costs

£000

   60
              £50k              (£30k)
   50

   40

   30
                                                    £20k               (£6k)
   20                                                                                     (£6k)

   10                                                                                                        (£2k)               £6k

    0

               Sales             Goods              Gross              Fees /              Staff             Other               Profit
                                  sold              profit            delivery             costs              costs           before tax

Sales allocation

                                                                Cost of goods sold                                        £30,000        60%

                                                                Fees and delivery                                          £6,000        12%

                                                                Staff costs                                                £6,000        12%
                  £50k
                   August sales                                 Other operating costs                                      £2,000          4%

                                                                Profit before tax                                          £6,000        12%

Fees and delivery costs include a £600 platform-fee accrual.

   GROSS MARGIN                                                              PROFIT-BEFORE-TAX MARGIN
   40%              actual                        42% budget                 12%              actual                        14% budget

In Good Order              Fictional example | All figures invented | Draft 1                                                          04 / 09
Open in PDF

Page 5: Financial position

Page 5 of 9: Financial position
Read page 5 as text
In Good Order                                                                                  04 / BALANCE SHEET
                 MONTH-END / AUGUST 2026

Financial position

31 August 2026, with the movement from 31 July.

Assets                                                          £59,000        Liabilities and equity

Stock                                                            £27k

Bank                                                             £17k                             £59k

                                                                                                       total

Customer receivables                                             £15k

                                                                                      Equity                                £44k

0                                                                 £30k                Liabilities                           £15k

  £                                                                       31 July             31 August                Movement

  Bank                                                                  20,000                  17,000                    (3,000)

  Customer receivables                                                  12,000                  15,000                    +3,000

  Stock                                                                 18,000                  27,000                    +9,000

  Total assets                                                          50,000                  59,000                    +9,000

  Supplier payables                                                     10,000                  12,000                    +2,000

  Accrued costs                                                           2,000                  3,000                    +1,000

  Equity                                                                38,000                  44,000                    +6,000

  Total liabilities and equity                                          50,000                  59,000                    +9,000

Equity movement

   £38,000                              +         £6,000                                =         £44,000
   Opening equity                                 Profit before tax                               Closing equity

In Good Order            Fictional example | All figures invented | Draft 1                                                  05 / 09
Open in PDF

Page 6: Profit and cash

Page 6 of 9: Profit and cash
Read page 6 as text
In Good Order                                                                                                 05 / CASH
                  MONTH-END / AUGUST 2026

Profit and cash

The £6,000 profit was offset by £9,000 of working-capital outflow.

Bank movement                                                              Bank        Increase       Decrease

£000

   30
                                +£6k               (£3k)

   25                                                                (£9k)
              £20k
   20                                                                                                     +£1k               £17k
                                                                                        +£2k

   15

   10

    5

    0

            Opening             Profit           Customer            Stock             Supplier          Accrued            Closing
              bank            before tax        receivables                           payables             costs             bank

Reconciliation of profit to cash

  Movement                                                                                                                 Cash effect £

  Profit before tax                                                                                                             +6,000

  Increase in customer receivables                                                                                              (3,000)

  Increase in stock                                                                                                             (9,000)

  Increase in supplier payables                                                                                                 +2,000

  Increase in accrued costs                                                                                                     +1,000

  Net movement in cash                                                                                                          (3,000)

  Opening bank balance                                                                                                          20,000

  Closing bank balance                                                                                                          17,000

   £6,000                                 −          £9,000                                 =          (£3,000)
   Profit                                            Working-capital outflow                           Bank movement

In Good Order              Fictional example | All figures invented | Draft 1                                                      06 / 09
Open in PDF

Page 7: Stock and payment timing

Page 7 of 9: Stock and payment timing
Read page 7 as text
In Good Order                                                                              06 / WORKING CAPITAL
                 MONTH-END / AUGUST 2026

Stock and payment timing

Closing balances and unresolved collection or payment dates.

Stock movement

£000
   60                                            +£39k                          (£30k)

   50

   40

   30                                                                                                          £27k

   20              £18k

   10

    0

               Opening stock                    Purchases                     Goods sold                   Closing stock

Stock increased by £9,000 (50.0%). No write-downs or other stock adjustments are modelled.

Customer receivables                                                Supplier payables

                                    £4,000                                                               £2,000
           £15k                     Overdue                                     £12k                     Payment date
                                                                                                         unconfirmed
               total                                                                total

                                    £11,000 remainder                                                    £10,000 remainder

Receipt dates are unconfirmed.                                      No payment-date breakdown is given for the remaining
                                                                    £10,000.

Accrued costs                                                                                                               £3,000

£600 fee estimate                                                                                           £2,400 other accruals

In Good Order            Fictional example | All figures invented | Draft 1                                                 07 / 09
Open in PDF

Page 8: Outstanding items

Page 8 of 9: Outstanding items
Read page 8 as text
In Good Order                                                                                                07 / ACTIONS
                  MONTH-END / AUGUST 2026

Outstanding items

Four open items. Responsibilities shown are illustrative.

   Item                                                            Responsible role / next step

   01      Platform invoice                                        FINANCE

           £600 estimate                                           Obtain the invoice. Match it to the accrual and settlement
                                                                   entries. Post any difference.

   02      Overdue receivables                                     OWNER

           £4,000 overdue                                          Check disputes and confirm collection dates before
                                                                   including receipts in the cash plan.

   03      Stock review                                            STOCK LEAD

           £27,000 closing stock                                   Review ageing, quantities, demand and recoverable cost
                                                                   before the next order.

   04      Supplier payment                                        OWNER

           £2,000 awaiting a date                                  Confirm terms, payment authority and timing. Include the
                                                                   commitment in the cash plan.

Close sequence

01                          02                           03                           04                           05

  Retain records               Check invoice                Review changes               Issue revision               Carry items
                                                                                                                      forward

Retain Draft 1 when issuing a replacement. Carry unresolved items forward with their owner.

In Good Order              Fictional example | All figures invented | Draft 1                                                         08 / 09
Open in PDF

Page 9: Basis of preparation

Page 9 of 9: Basis of preparation
Read page 9 as text
In Good Order                                                                                                           08 / BASIS
                    MONTH-END / AUGUST 2026

Basis of preparation

All figures are invented. No underlying client records were used.

PERIOD                              August 2026, with July actual and August budget comparatives.

ACCOUNTING BASIS                    Accrual accounting. Stock is held at recoverable cost, with no write-downs, losses or other
                                    stock adjustments.

EXCLUSIONS                          VAT, tax, borrowing, fixed assets, depreciation, owner transactions and foreign currency. No
                                    other balance-sheet movements are modelled.

FEE ESTIMATE                        £600 is included in fees and delivery costs and accrued liabilities. The fictional estimate uses
                                    transaction data and agreed fees, pending its invoice. No input VAT is modelled.

PRESENTATION                        Variances, shares and ratios are calculated from the fictional figures. £k means £1,000.
                                    Percentages are rounded; parentheses indicate negative amounts or deductions.

USE                                 Illustrative management information only. Not statutory accounts, a forecast, audit or
                                    assurance. The report does not authorise payments or spending.

Records required for a live pack

  Record                                                             Use

  Ledger and agreed budget                                           P&L, comparatives and balance sheet

  Bank and payment statements                                        Cash balances and reconciliations

  Sales and customer records                                         Revenue, receivables and collection status

  Supplier and platform documents                                    Costs, payables, accruals and duplicates

  Stock records and count evidence                                   Quantities, cost, ageing and recoverability

  Close and adjustment schedules                                     Review decisions, changes and open items

SOURCE FIGURES

In Good Order, Month-end management pack, fictional August 2026 example (Draft 1), pages 2–7. No new trading periods or client figures
have been added.

In Good Order                Fictional example | All figures invented | Draft 1                                                                 09 / 09
Open in PDF

Monthly reporting support

Tell me about the reports you need. We can agree what they should cover and which records are needed to prepare them.

Opens a short enquiry form. Nothing is sent until you press Send enquiry.

Related service: Management accounts and cash reporting

Tell Andrew what you need

Send an enquiry to In Good Order. Pressing Send enquiry sends these details through this website to Andrew. Nothing is saved in your browser.

Tell us roughly what the work is and where the time goes. A sentence or two is plenty.

Please don’t include passwords, log-in details or account numbers.

This helps Andrew see where enquiries come from.

Prefer email? Write to andrew@ingoodorder.co.uk. How we use your details: privacy notice.