Category: Reports Author: DII Editorial Team

What Reports Matter in a Small Business?

Introduction

A small business does not need every report every day.

What it needs is a short set of reports that answer the most important questions clearly.

Many business owners avoid reports because they sound technical. They may think reports are only for accountants, tax returns, or year-end accounts. But good reports are not there to make accounting feel complicated. They are there to make the business easier to understand.

A useful report should answer a practical question.

For example:

Business question Useful report
Are we making a profit? Profit and loss
Do we have enough cash? Bank and cash flow view
Who owes us money? Aged receivables
Who do we need to pay? Aged payables
Is VAT building up? VAT report
Do our records match the bank? Reconciliation report
What does the business own and owe? Balance sheet

The owner does not need to stare at all reports all the time.

But the owner should know which report answers which question.

For the foundation behind cash and performance, read Cash vs Profit: Why They Are Not the Same Thing.


Reports are questions, not decorations

A report is useful only when it helps someone make a better decision.

A profit and loss report is not just a formal statement. It answers whether the business is earning more than it consumes.

A bank report is not just a balance. It answers whether cash is available.

An aged receivables report is not just a customer list. It answers who has not paid yet.

A VAT report is not just a tax summary. It helps show how VAT is moving through sales and purchases.

The best way to read reports is to ask:

What question is this report trying to answer?

If the owner does not know the question, the report feels like noise.

If the question is clear, the report becomes useful.


The core report set

A small business should usually understand these core reports:

Report Main purpose Main risk it helps reveal
Profit and loss Shows income, costs and profit over a period Business is busy but not profitable
Bank summary Shows cash movement and balance Cash is low or moving unexpectedly
Cash flow view Shows timing of money in and out Bills arrive before customer money
Aged receivables Shows unpaid customer invoices Customers are paying late
Aged payables Shows unpaid supplier bills Cash is already committed
VAT report Shows VAT on sales and purchases VAT money is treated as free cash
Reconciliation report Checks records against the bank Reports may not be trustworthy
Balance sheet Shows wider position at a point in time Assets, liabilities and debts are unclear

These reports work together.

One report rarely tells the whole story.


Profit and loss report

The profit and loss report is one of the most important reports in a small business.

It usually shows:

  • income,

  • cost of sales,

  • expenses,

  • profit or loss over a period.

A simple profit and loss might look like this:

Area Amount
Sales income £12,000
Direct costs -£4,000
Gross profit £8,000
Overheads -£5,500
Net profit £2,500

The profit and loss answers:

Did the business make money from its activity during this period?

It helps the owner see whether the business model is working.

It can reveal:

  • weak pricing,

  • rising costs,

  • too many overheads,

  • poor margins,

  • seasonal changes,

  • profitable and unprofitable periods,

  • whether growth is actually improving the result.

But the profit and loss does not always show immediate cash pressure.

A business can show profit while customers still have not paid.

For a deeper guide, read How to Read a Profit and Loss Statement.


Bank summary

The bank summary is usually the report owners understand first.

It shows the money moving in and out of the bank account.

A simple bank view might show:

Area Amount
Opening bank balance £3,000
Money received £8,500
Money paid out -£7,200
Closing bank balance £4,300

The bank summary answers:

What cash moved, and what is left now?

This matters because cash pays real commitments.

But the bank summary has a limit.

It does not automatically explain whether the business is profitable. It does not show unpaid invoices unless the system connects bank and invoice records. It does not show unpaid supplier bills unless they have been recorded. It may include VAT, tax reserves, loans, transfers or deposits.

The bank balance is useful, but it is not enough by itself.

Read Why Bank Balance Is Not Business Performance if you want the full explanation.


Cash flow view

Cash flow is about timing.

It shows whether money is arriving before money needs to leave.

A cash flow view might show:

Week Expected money in Expected money out Risk
Week 1 £2,000 £1,500 Stable
Week 2 £1,000 £3,200 Pressure
Week 3 £4,500 £1,800 Recovery
Week 4 £1,500 £2,000 Watch

The cash flow view answers:

Will we have enough money at the right time?

This is different from profit.

A business can be profitable over the month but still struggle in Week 2 if supplier bills arrive before customer payments.

Cash flow helps the owner see:

  • upcoming pressure,

  • expected customer receipts,

  • bills due soon,

  • VAT or tax payment timing,

  • payroll or subcontractor needs,

  • whether owner withdrawals are safe,

  • whether a quiet period is approaching.

A helpful related guide is How to Spot a Cash Flow Problem Early.


Aged receivables

Aged receivables show customers who owe money.

This report groups unpaid invoices by age.

Example:

Age group Amount unpaid Meaning
Not due yet £3,000 Normal customer credit period
1–30 days overdue £2,200 Needs reminder
31–60 days overdue £1,100 Collection risk increasing
61–90 days overdue £800 Stronger action may be needed
Over 90 days overdue £500 High risk

Aged receivables answer:

Who owes the business money, and how late is it?

This is one of the most important cash flow reports.

A business may look profitable because invoices have been issued, but if those invoices are unpaid, the cash is still missing.

Aged receivables help the owner decide:

  • who to chase first,

  • which customers pay slowly,

  • whether payment terms are too generous,

  • whether late payment is becoming normal,

  • whether one customer creates too much cash risk.

For more detail, read When to Look at Aged Receivables.


Aged payables

Aged payables show what the business owes to suppliers.

This report is the opposite side of aged receivables.

Example:

Payable age Amount owed Meaning
Not due yet £2,500 Normal payment cycle
Due this week £1,200 Needs cash planning
1–30 days overdue £900 Supplier pressure starting
31–60 days overdue £400 Relationship risk increasing

Aged payables answer:

Who does the business need to pay, and when?

This matters because the bank balance can look stronger than reality.

A business might have £5,000 in the bank, but if £3,800 of supplier bills are due soon, the business does not truly have £5,000 of free cash.

Aged payables help the owner:

  • plan payments,

  • avoid supplier surprises,

  • protect relationships,

  • avoid accidental missed bills,

  • understand cash already committed,

  • decide whether owner withdrawals are safe.

Aged receivables and aged payables should be read together.

One shows money waiting to come in.

The other shows money waiting to go out.


Invoice and payment reports

Invoice and payment reports help explain the difference between what has been charged and what has been paid.

A simple invoice report might show:

Invoice status Meaning
Draft Invoice prepared but not sent
Sent Customer has been charged
Due soon Payment date is approaching
Overdue Payment date has passed
Paid Customer payment received and matched
Part-paid Some cash received but balance remains
Disputed Customer has raised a problem

This report answers:

What have we charged, and what still needs attention?

It helps prevent a common mistake: treating invoices as cash.

An invoice is not cash until the customer pays.

A related guide is Invoice vs Payment: Why They Should Not Be Mixed Up.


VAT report

For VAT-registered businesses, a VAT report is essential.

It helps show VAT charged on sales and VAT paid on purchases.

A simple VAT summary might show:

VAT area Meaning
Output VAT VAT charged to customers on sales
Input VAT VAT paid on eligible business purchases
VAT adjustment Correction or special treatment
VAT payable or reclaimable Estimate before return review
VAT period Filing window the figures relate to
Evidence status Whether invoices and records support the numbers

The VAT report answers:

What VAT position is building for the period?

VAT should not be treated as extra profit.

When a VAT-registered business receives customer payments, some cash may represent VAT. That money may later need to be included in the VAT return calculation.

A VAT report helps the business avoid spending VAT as if it were ordinary profit.

For the beginner explanation, read What VAT Really Is.

A more specific guide is What Records Do You Need for VAT?.


Reconciliation report

Reconciliation is the report that checks whether accounting records agree with the bank.

It helps answer:

Can we trust the numbers?

A reconciliation report may show:

Reconciliation item What it means
Matched payments Bank payments connected to invoices, bills or expenses
Unmatched bank transactions Money moved but record is not clear yet
Missing receipts Expense exists but evidence is missing
Duplicate transactions Same item may have been entered twice
Timing differences Records and bank movement happen on different dates
Transfers Movement between accounts, not income or expense
Bank fees Charges that may need recording

This report matters because other reports depend on clean records.

If payments are unmatched, invoices may look unpaid when they were actually paid.

If bank charges are missing, expenses may be understated.

If personal spending is mixed in, reports may become unreliable.

Reconciliation is not admin for its own sake.

It is how the business checks whether records and cash reality agree.

Read Why Reconciliation Matters for the deeper guide.


Balance sheet

The balance sheet shows the wider position of the business at a point in time.

It is not only a year-end document.

It helps answer:

What does the business own, what does it owe, and what is left?

A simple balance sheet view may include:

Area Examples
Assets Bank cash, unpaid customer invoices, stock, equipment
Liabilities Supplier bills, loans, VAT owed, tax owed
Equity or capital What remains after liabilities

A profit and loss report shows performance over time.

A balance sheet shows position at a point in time.

This matters because a business can make profit but still carry too much debt. Or it can have cash in the bank but also have large unpaid liabilities.

A balance sheet helps the owner understand:

  • unpaid customer balances,

  • unpaid supplier balances,

  • loans,

  • equipment,

  • stock,

  • VAT or tax liabilities,

  • director loan account for companies,

  • overall strength or weakness.

For more, read What a Balance Sheet Actually Tells You.


Expense category report

An expense category report shows where the business is spending money.

Example:

Category Amount Question to ask
Software £650 Are subscriptions controlled?
Travel £420 Is travel producing enough value?
Materials £1,800 Are job costs priced properly?
Professional fees £500 Is advice or support increasing?
Advertising £900 Is marketing creating sales?
Rent £1,200 Is fixed cost affordable?

This report answers:

Where is the money going?

It helps the owner identify cost patterns.

It can reveal:

  • too many subscriptions,

  • rising travel costs,

  • expensive suppliers,

  • weak gross margin,

  • costs that should be recharged to customers,

  • missing receipts,

  • unusual spending.

An expense report becomes much more useful when categories are consistent.

If the same type of cost is coded differently every month, the report becomes harder to trust.


Customer report

A customer report shows where revenue comes from.

Example:

Customer Sales Payment behaviour
Customer A £8,000 Pays on time
Customer B £5,500 Often late
Customer C £4,200 Good margin
Customer D £3,000 Frequent disputes

This report answers:

Which customers are helping or hurting the business?

It can reveal:

  • customer concentration risk,

  • slow-paying customers,

  • low-value customers who require too much work,

  • high-value reliable customers,

  • repeat business patterns,

  • customers with frequent disputes.

Revenue is not the only measure.

A customer who pays quickly and creates clean work may be more valuable than a larger customer who pays late and creates stress.


Supplier report

A supplier report shows who the business pays.

Example:

Supplier Spend Question
Supplier A £4,000 Is this cost still needed?
Supplier B £2,500 Are prices rising?
Supplier C £900 Is there a cheaper alternative?
Supplier D £650 Is this linked to customer work?

This report answers:

Who receives the business money?

It helps the owner understand:

  • key suppliers,

  • rising costs,

  • dependency on one supplier,

  • recurring subscriptions,

  • bills that need forecasting,

  • cost-cutting opportunities,

  • supplier payment pressure.

Supplier reports are useful when cash is tight because they show where money regularly leaves.


Which reports should be checked weekly?

Some reports are useful every week because they help prevent cash pressure.

Weekly reports:

Report Why weekly
Bank summary Cash survival is immediate
Aged receivables Late invoices need early action
Aged payables Bills due soon need planning
Cash flow view Timing pressure appears early
Overdue invoice list Chasing should not wait too long

A weekly check does not need to be long.

It should answer:

  • What cash do we have?

  • Who should pay us soon?

  • Who has not paid?

  • What do we need to pay?

  • What could create pressure next?

Weekly reports are about control.


Which reports should be checked monthly?

Monthly reports help the owner understand performance.

Monthly reports:

Report Why monthly
Profit and loss Shows whether business activity made profit
Expense category report Shows where costs are rising
Customer revenue report Shows where income comes from
Supplier spend report Shows regular cash outflows
Reconciliation report Checks record quality
VAT summary if registered Helps avoid quarter-end panic

A monthly review should not be only “Did we survive?”

It should ask:

  • Did we perform well?

  • Are costs controlled?

  • Are customers paying?

  • Are reports trustworthy?

  • Are we prepared for VAT or tax?

  • What should change next month?


Which reports matter at year end?

Year-end reports depend on business type.

For sole traders and partnerships, records of business income and expenses support Self Assessment.

For VAT-registered businesses, VAT records and VAT account information must be maintained.

For limited companies, company and accounting records matter because directors are responsible for company records and accounts.

Useful year-end reports include:

Report Why it matters
Full profit and loss Shows annual performance
Balance sheet Shows position at year end
Sales list Supports income records
Expense list Supports cost records
Receipt/document list Supports evidence
VAT reports Supports VAT review if registered
Aged receivables Shows money owed at year end
Aged payables Shows bills owed at year end
Reconciliation report Supports confidence in records

Year-end should not be a scramble.

If weekly and monthly reports are reviewed, year-end becomes much calmer.


Report priority by business situation

Different situations need different reports first.

Situation First reports to check
Cash feels tight Bank, cash flow, aged receivables, aged payables
Sales look strong but bank is low Profit and loss, aged receivables, bank summary
Bank looks good but owner is unsure Bank, aged payables, VAT/tax reserve, profit and loss
VAT return is approaching VAT report, reconciliation, purchase evidence, sales invoices
Customers are paying late Aged receivables, overdue invoice list, customer report
Suppliers are chasing Aged payables, bank, cash flow
Costs are rising Profit and loss, expense category report, supplier report
Preparing year end Profit and loss, balance sheet, receipts, reconciliation
Applying for finance Profit and loss, balance sheet, cash flow, aged receivables
Reviewing growth Profit and loss, cash flow, customer report, margin reports

This is the key point:

Do not open every report randomly. Open the report that answers the current question.


A simple owner dashboard

A useful small business dashboard can summarise the key report signals.

Example:

Area Signal
Cash Bank balance and expected cash movement
Profit Profit or loss for the month
Receivables Total unpaid and overdue invoices
Payables Bills due soon and overdue
VAT VAT estimate or next obligation if relevant
Reconciliation Unmatched transactions and missing receipts
Reports Last month-end review status

The dashboard should not replace reports.

It should point the owner to the report that needs attention.

For example:

  • “Three invoices are overdue.”

  • “Bank reconciliation has 12 unmatched transactions.”

  • “Supplier bills due this week exceed expected cash.”

  • “VAT evidence is missing on 4 expenses.”

  • “Profit is positive, but cash is falling.”

This is where reports become practical.

They guide the next action.


Common mistakes with reports

Mistake 1: Looking only at the bank

The bank balance matters, but it does not show profit, unpaid invoices, unpaid bills, VAT or tax reserves.

Mistake 2: Looking only at profit

Profit matters, but it does not prove customers have paid.

Mistake 3: Ignoring aged receivables

Unpaid invoices can quietly become a cash flow problem.

Mistake 4: Ignoring aged payables

Unpaid bills can make the bank balance look safer than it really is.

Mistake 5: Reading reports without reconciliation

If records do not match the bank, reports may be unreliable.

Mistake 6: Waiting until year end

Reports are most useful while there is still time to act.

Mistake 7: Treating VAT as profit

VAT needs its own records and review.

Mistake 8: Opening too many reports with no question

Reports become overwhelming when the owner does not know what they are trying to find.


Practical monthly report routine

A small business owner can use this simple routine.

Step Report Question
1 Bank summary What cash is available now?
2 Aged receivables Who owes us money?
3 Aged payables Who do we need to pay?
4 Profit and loss Did we make money this month?
5 Expense categories Which costs changed?
6 VAT report if registered Is VAT position under control?
7 Reconciliation Can we trust the records?
8 Balance sheet What is the wider position?

This routine can be done monthly.

The purpose is not to become an accountant.

The purpose is to stop running the business from guesswork.


Final summary

Small businesses do not need every report every day.

They need reports that answer clear questions.

The most useful reports usually include:

  • profit and loss,

  • bank summary,

  • cash flow view,

  • aged receivables,

  • aged payables,

  • invoice and payment reports,

  • VAT report if registered,

  • reconciliation report,

  • balance sheet,

  • expense category report,

  • customer and supplier reports.

Each report answers something different.

The bank shows cash.

The profit and loss shows performance.

Aged receivables show who owes money.

Aged payables show who needs paying.

VAT reports show VAT movement.

Reconciliation checks whether records match reality.

The balance sheet shows the wider position.

The main lesson is simple:

Reports are not there to impress accountants. They are there to help the owner understand what is happening.

When reports are read with the right questions, the business becomes easier to control.