Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceFinancial Statements & ReportingSmall Business Profit and Loss Statement

SpreadsheetFinancial Statements & ReportingFree

Small Business Profit and Loss Statement

Monthly P&L against budget and last month, with gross and net margin and a six-month trend.

Shown with sample data

Colour

Small Business Profit and Loss Statement

Monthly P&L against budget and last month, with gross and net margin and a six-month trend.

Revenue
$54,650
Gross margin
64%
Net profit
$7,460
Net margin
14%
Net profit vs budget
$505
Net profit by month
  • Jun 2026$1,650
  • Jul 2026$3,080
  • Aug 2026-$300
  • Sep 2026$3,620
  • Oct 2026$6,365
  • Nov 2026$7,460
Operating expenses by line
  • Salaries and wages$16,200
  • Rent$3,200
  • Marketing and advertising$2,850
  • Software and subscriptions$720
  • Professional fees$600
  • Travel$540
  • Depreciation$450
  • Insurance$410

How to use it

  1. 1Enter each income and expense line on the P&L sheet with its section, this month, last month and budget.
  2. 2Read the Statement sheet for gross profit, operating profit, net profit and margins.
  3. 3Check the vs budget column: positive is good for revenue, negative is good for costs.
  4. 4Each month, add the finished month to the Trend sheet and roll the columns forward.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

A monthly profit and loss statement the way an accountant lays it out. Enter each line once with this month, last month and budget; the statement builds revenue, cost of sales, gross profit, operating expenses, operating profit and net profit with margins, and shows how each line moved against last month and against budget. A six-month trend shows where profit is heading.

Who it’s for

  • Monthly management accounts for a small business
  • Comparing results with budget
  • Explaining the numbers to a partner, lender or investor

What’s included

  • P&L sheet: Every income and expense line with this month, last month and budget.
  • Statement sheet: The profit and loss statement, built from the P&L sheet.
  • Trend sheet: Six months of results, with the current month read from the P&L sheet.

How to use it

  1. 1Enter each income and expense line on the P&L sheet with its section, this month, last month and budget.
  2. 2Read the Statement sheet for gross profit, operating profit, net profit and margins.
  3. 3Check the vs budget column: positive is good for revenue, negative is good for costs.
  4. 4Each month, add the finished month to the Trend sheet and roll the columns forward.

Tips

  • Keep cost of sales (materials, fulfilment, payment fees) separate from overheads so gross margin is meaningful.
  • Investigate any line more than 10% off budget.
  • Gross margin falling while revenue grows usually means pricing or supplier costs need attention.

Questions

What goes in cost of sales?

Costs that rise directly with each sale: materials, stock, shipping, payment fees and direct labour.

Is this the same as cash flow?

No. Profit is earned when you invoice; cash arrives when customers pay. Use the 13-Week Cash Flow Forecast for cash.

Related searchesprofit and lossp&l templateincome statementsmall business accountingbudget vs actualgross margin

Details

Format
Spreadsheet
Category
Financial Statements & Reporting
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetFinancial Statements & ReportingFree

Small Business Profit and Loss Statement

Monthly P&L against budget and last month, with gross and net margin and a six-month trend.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Financial Statements & Reporting
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More financial statements & reporting templates

View all
Monthly Financial Dashboard2 sheets

Revenue this month

$655,000

Revenue, last 12 months

$7,013,000

EBITDA margin this month

16%

EBITDA by month
$57k
$38k
$62k
$79k
$78k
Dec 2025Jan 2026Feb 2026Mar 2026Apr 2026
SpreadsheetFinancial Statements & Reporting

Monthly Financial Dashboard

One page that answers how the business did this month: revenue, margins, EBITDA, cash, DSO and customers against target, with 12-month trends.

10 min setupPreview
Trial Balance2 sheets

Adjusted debits

$57,150

Adjusted credits

$57,150

Difference

$0

ABCD
1AccountTypeDebitCredit
2BankAsset$18,400$0.00
3Accounts receivableAsset$6,200$0.00
4Prepaid insuranceAsset$1,200$0.00
5EquipmentAsset$9,000$0.00
Trial balance
SpreadsheetGeneral Ledger & Trial Balance

Trial Balance

Closing balances by account in debit and credit columns with a balance check and totals by statement section.

10 min setupPreview
Balance Sheet2 sheets

Total assets

$240,700

Difference

$0

Working capital

$80,700

ABCD
1LineSectionThis yearLast year
2Cash at bankCurrent assets$64,200$41,800
3Accounts receivableCurrent assets$38,500$31,200
4InventoryCurrent assets$27,400$24,900
5PrepaymentsCurrent assets$3,600$3,100
Balance sheet
SpreadsheetBalance Sheet & Financial Position

Balance Sheet

Assets, liabilities and equity for this year and last, with the balance check and key ratios.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ