About this template
A profit and loss statement answers the most important question in any business: after everything you spent, did you make money? Reviewing one every month helps you spot rising costs, slow months and your most profitable work before tax season forces the issue.
Enter monthly revenue and costs in clearly marked input cells. The workbook calculates net revenue, cost of goods sold, gross profit, operating expenses, net operating income and net profit, then rolls everything into quarterly and annual summaries with margins and a month-by-month chart. It’s a practical management report, not a substitute for your accountant.
Who it's for
- Freelancers and solo business owners
- Small businesses without full accounting software
- Side hustles that need a clear view of profit
What's included
- Monthly January–December P&L with revenue categories, refunds and net revenue
- Cost of goods sold, gross profit and gross margin
- Twelve operating-expense categories, net operating income and operating margin
- Other income and expenses, plus net profit (before income tax) and net margin
- Quarterly and annual summary with a reconciliation check and a revenue/costs/profit chart
- Example data to replace, color-coded input cells, and a “How to Use” sheet
How to use it
- 1
Enter your business name and fiscal year on the Monthly P&L sheet.
- 2
Rename revenue, COGS and expense lines to match your business.
- 3
Each month, enter totals from your bank statements, invoices and receipts in the yellow cells.
- 4
Enter refunds and interest expense as positive numbers — the template subtracts them.
- 5
Review the Summary sheet for quarterly results, margins and the monthly trend.
