Skip to content
The first pages of the Small Business Monthly Finance Report template

Small Business Monthly Finance Report

Document template for Google Docs and Word

Make a copy in Google Docs
Price
Free
Style
Minimal
Difficulty
Beginner
Updated
November 12, 2026

Every page (7)

Overview

Owners without a finance team often see profit on a statement but not the cash in the bank, and variances go unexplained until the year ends. This monthly report puts profit against budget and last year, reconciles it to cash, and sets out the balance sheet and debtors. It runs from money in and money out, through profit and cash, to the things to watch.

The sample belongs to Lowmoor Advisory, a fictional firm with March revenue of $736K and a 10 percent EBITDA margin. Every number agrees across the pages, and each variance over the 5 percent threshold has a cause and an action. Replace the trial balance totals and the headline figures with your own, then write commentary only for lines that breach the threshold.

Useful for

  • A month-end review where the owner asks why profit is up but the bank is flat
  • A lender update that needs cash, debtor days and overdue invoices in one place
  • A board meeting where each variance over the threshold needs a cause and an action

What's included

  • Money in table with budget, forecast and actual revenue and a cause for each breach
  • Money out summary with a cost table, a weekly cost chart and a contractor callout
  • Profit page with a margin trend, a revenue mix donut and a key figures table
  • Cash in bank statement that reconciles profit to the cash movement each month
  • Things to watch scorecard with status, trend and a comment for each measure
  • Definitions page and a make-it-yours guide with five numbered steps

How to use it

  1. 1

    Click Make a copy in Google Docs, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Set the period end and replace the headline figures with your revenue, margin, EBITDA, cash and debtor days.

  3. 3

    Paste your trial balance totals into the income, balance sheet and cash flow tables, keeping the budget columns.

  4. 4

    Write commentary only for lines that breach the 5 percent or $5K threshold, giving a cause and an action.

  5. 5

    Delete the guide page, then share the report with the managing director or present it at the close meeting.

What you need

Requirements

  • A Google account with access to Google Drive

Works with

  • Google Docs
  • Microsoft Word (download the .docx)

Questions

Are the company and the figures real?

No. Lowmoor Advisory, its people and every figure in the sample are fictional. Replace them with your own ledger totals before you share the report with anyone outside your team.

Does it work for a restaurant or a charity?

Yes. The sector lines can be swapped for food cost and labor percentages for a restaurant, or fund balances and reserve months for a charity, while the profit, cash and variance pages stay the same.

Why does the cash page matter if profit is shown?

Profit includes accruals and costs not yet paid, so it can be positive while the bank balance falls. The cash page reconciles the two, so you can see how much profit is actually in the bank.

  • #management-accounts
  • #monthly-finance-report
  • #google-docs
  • #cash-flow
  • #variance-analysis
  • #small-business-finance
  • #profit-and-loss

More management accounts report templates

See all 11

Also in Finance

All finance templates
Get this template

Preparing your template…