A simple profit and loss spreadsheet for Excel and Google Sheets: see whether the month made money, then whether the bank balance survives the year.
Get it on Payhip →In short: This monthly P&L template takes one month of revenue and costs and returns gross profit, net profit, both margins and the break-even revenue your expenses need. Its Cash Flow tab then runs 12 months of opening cash, cash in, cash out and closing cash, starting from the P&L figures, and flags any month that ends overdrawn.
20-second demo — real numbers, with audio 🔊
Works in Microsoft Excel and in Google Sheets (File, Open, Upload). Inputs are the yellow cells; everything else is a live formula you can click and read.
The file ships with this example month. These are the workbook's own results:
| Line | Result |
|---|---|
| Revenue: $18,000 products + $9,000 services + $1,000 other | $28,000 |
| Less cost of goods sold | $7,000 |
| Gross profit / gross margin | $21,000 / 75.0% |
| Operating expenses: rent, payroll, marketing, software, utilities, insurance, other | $15,000 |
| Net profit / net margin | $6,000 / 21.4% |
| Break-even revenue ($15,000 / 0.75) | $20,000 |
| Cash Flow tab: $5,000 opening cash, $4,000 a month owner drawings, $8,000 purchase in month 2, $4,500 tax each quarter | lowest balance -$1,500 in month 3, $3,000 after 12 months |
Break-even revenue is the line most simple P&L templates leave out. Here each sales dollar keeps 75 cents after cost of goods, so $15,000 of expenses needs $20,000 of sales before any profit appears. This month cleared it by $8,000. The Cash Flow tab shows why profit is not cash: every month of the demo year makes $6,000 of profit, yet after drawings, an equipment purchase in month 2 and a quarterly tax bill the bank goes $1,500 overdrawn in month 3. For forecasting method see the cash flow forecast guide.
Owners of small product or service businesses who want a plain monthly profit check without accounting software. Save a copy per month to compare. The profit and loss template guide walks through the layout line by line, and the break-even guide explains the break-even formula.
An honest comparison. A free template is the right choice if you only need a form to fill in, and software is the right choice if you need scheduling, invoicing or bank feeds. This file is for getting the number right.
| This spreadsheet | Free blank template | Accounting software | |
|---|---|---|---|
| Gross and net profit with both margins | Yes | Only if you build it | Yes |
| Break-even revenue | Yes | Rarely | Varies |
| Month-by-month cash position | Yes, a 12-month cash flow tab | Rarely | Usually |
| Bank feeds, invoices, tax reports | No | No | Usually |
| Where it runs | Your own Excel or Google Sheets file | A spreadsheet | The vendor's app and account |
| Cost | $14.99 once | Free | Monthly subscription |
Get the free 50/30/20 Budget Starter and see exactly how the live formulas work — no risk, no card.
Record your revenue and every expense category monthly, then subtract costs from income to get gross and net profit. The P&L + Cash Flow Tracker does this live: enter one month's numbers and it shows gross and net profit, both margins and break-even revenue, and its Cash Flow tab carries opening cash, cash in, cash out and closing cash across 12 months.
Profit is income minus expenses on paper; cash flow is the actual money moving in and out each month. A business can be profitable and still run out of cash. The tracker shows both: the P&L tab gives the month's profit and the Cash Flow tab shows the bank balance month by month, flagging any month that ends overdrawn. In the demo, every month makes a profit and the bank still goes $1,500 overdrawn in month 3.
Yes, both — it's a spreadsheet with live formulas, nothing to install.
Yes, $14.99 one-time, no subscription. Also included in the 7-tool bundle for $49.
List revenue lines, subtract cost of goods sold for gross profit, subtract operating expenses for net profit, and divide each by revenue for the margins. Add break-even revenue as operating expenses divided by gross margin. This template has all of it built; the example month is $28,000 revenue, $6,000 net profit and $20,000 break-even.
Yes. This one is a .xlsx file that also opens in Google Sheets, with yellow input cells and the results calculated below them. It is a one-time $14.99 purchase.
Yes. The Cash Flow tab runs 12 months of opening cash, cash in, cash out and closing cash. Month 1 starts from the P&L tab, recurring lines carry forward until you type over them, and it reports the lowest balance and any month that ends overdrawn.
