You want to know whether your business is actually making money, and a profit and loss statement is how you find out. For a lot of online service owners, the fastest way to start is a simple template in Google Sheets you can update each month.
Below, you get the exact line items a profit and loss statement needs, a step-by-step way to build one in Google Sheets, and the choice between cash and accrual so your numbers mean what you think they mean.
No inventory math and no jargon. Just a working statement you can read at a glance and hand to a lender or your CPA when they ask.
TL;DR: How Do You Make a Profit and Loss Template in Google Sheets?
Start a blank Google Sheet, add a column for each month plus a year-to-date total, then stack your line items in order: revenue, cost of services, gross profit, operating expenses, and net profit. Use SUM formulas for the totals and a subtraction for profit, and you have a template you can reuse every month. Keep it on the same accounting method each period so the numbers stay comparable.
- ●The five blocks. Revenue, cost of services, gross profit, operating expenses, net profit.
- ●Two formulas. SUM your totals, then subtract to get gross profit and net profit.
- ●Stay consistent. Pick cash or accrual, confirm it with your CPA, and use it the same way every month.
Why a Profit and Loss Statement Matters
A profit and loss statement shows your revenue and expenses over a set period, usually a month, a quarter, or a year. Read a few in a row and you can spot trends, compare against last year, and see which months carried the business. Getting comfortable with what a profit and loss statement is makes every other report easier to read, and since bankers, investors, and buyers all ask for it first, keeping a clean one current pays off.
For a growing service business, the statement answers the question that matters before you hire or expand: are you profitable, and where is the money actually going? The IRS treats it as core too. Sole proprietors report the same revenue-minus-expenses math on Schedule C, Profit or Loss From Business, and you are expected to keep records of your income and expenses either way.
What Goes on a Profit and Loss Statement
Every profit and loss statement follows the same order, top to bottom. Build your template with these blocks and you can drop in numbers from any month.
| Section | What Goes in It |
|---|---|
| Revenue | Money you earned: retainers, project fees, and subscriptions. |
| Cost of services | Direct costs of delivering the work, such as contractor pay and project software. |
| Gross profit | Revenue minus cost of services. |
| Operating expenses | Everything else it takes to run: payroll, rent, marketing, tools, and admin. |
| Net profit | Gross profit minus operating expenses. |
Revenue sits at the top because everything else is measured against it. Cost of services covers only what it takes to deliver the work, so your gross profit shows how much each dollar of sales actually leaves behind. Operating expenses are the ongoing costs of running the business, and what survives after those is your net profit, the number that tells you whether the month worked.
Two lines are worth watching closely. Gross margin, your gross profit as a share of revenue, tells you how efficiently you deliver the work, while net margin, net profit over revenue, tells you what the whole business keeps after everything is paid. Track both month over month and a slow slide shows up long before it drains your bank account.
How to Build a P and L in Google Sheets
You can build a working template in a few minutes. Here is the order that keeps the formulas simple. Do it once and you reuse the same sheet every month by copying the latest column across.
- 1Set up your columns. Put line items down the first column, then add one column per month and a final column that totals the year to date. A year-to-date profit and loss view is the one most owners check first.
- 2List your revenue. Give each income stream its own row, such as retainers, projects, and subscriptions, then add a Total Revenue row with a SUM formula across them.
- 3Add your cost of services. List the direct costs of delivering the work below revenue, total them, and subtract from revenue to get Gross Profit.
- 4Enter operating expenses. Payroll, rent, software, marketing, and admin each get a row, with a Total Operating Expenses line at the bottom.
- 5Calculate net profit. Subtract total operating expenses from gross profit, format the row as currency, and your template is done. For a fuller walkthrough, see how to make a profit and loss statement.
Cash Basis or Accrual for Your Template
Before you fill in a single number, decide which method your template follows, because it changes when revenue and expenses land.
- ●Cash basis. You count income the day it hits your bank and costs the day they leave it. Simpler to run, and the method we use for most online service businesses.
- ●Accrual. You record income when it is earned and expenses when they are incurred, even if the cash moves later. Lenders and investors often prefer this view.
Pick one and apply it the same way every period, or your months will stop comparing cleanly. Which method you use for taxes is a decision for your CPA, and the IRS rules on accounting methods spell out the difference.
Frequently Asked Questions
Below are the questions owners ask most when they start a profit and loss template.
Keep Your P and L Current Every Month
A profit and loss template is only useful if you keep it up to date. A blank Google Sheet with the five blocks above gets you started, and a few minutes each month keeps the numbers honest as the business grows.
Once the statement is current, use it. Compare months, watch your gross profit, and let the trend guide your next hire or investment. If you want to see what a finished set of reports looks like, our sample financial report shows the format we deliver.
For a lot of founders, the sheet slips the moment work gets busy. That is when our team steps in, with monthly bookkeeping for agencies and online service businesses and your profit and loss statement, balance sheet, and cash flow delivered by the 15th. You can start with a free month and see what current, reliable books feel like.
Clean books. On time. Every month.
