Free Agency P&L Template (Google Sheets) — and How to Actually Read It

The anatomy of an agency profit and loss statement: five sections

The template is a single sheet: months run across the columns, line items down the rows. Fill in one column a month and you get a year of dynamics for free. To make each section concrete — and show how to calculate every line — let’s walk through them on a small agency: three clients, a team of four, July 2026. All amounts are in the accounting currency, US dollars.

Here is the same agency across three months — exactly how the filled-in template looks (months in columns, line items in rows):

One quarter is enough to see what matters: revenue is growing, gross margin climbed from 39.7% to 44.4%, and net profit rose by more than a third in three months. Observations like these are the whole reason a P&L exists.

The 15-minute monthly ritual

A P&L does not require an accountant — it requires a habit. First day of the month (or the first working Monday), coffee, bank statements, four steps:

1. 1

   Revenue — by client

   ≈ 5 min

   Open last month’s statements and paid invoices. Enter each client’s revenue into their row. Convert non-USD amounts at the rate of the day the money arrived, and record those rates in the "Monthly rates" block.

2. 2

   Salaries — by person

   ≈ 4 min

   Fill in what each team member was paid for the month. If part of July’s salary is physically paid in early August, it still belongs to July: the P&L assigns costs to the month the work was done for.

3. 3

   OpEx — from the bank

   ≈ 4 min

   Walk through the remaining charges and sort them into the seven categories: software, contractors, fees, office, marketing, taxes, other. Check your personal card too — a couple of business subscriptions always hide there.

4. 4

   Check the margin

   ≈ 2 min

   The formulas have already computed gross and net margin. Compare with last month and ask two questions: why did gross margin move, and which OpEx line grew. If you can answer both, your agency’s finances are under control.

Five mistakes that break an agency P&L

1. 1

   Tracking cash-flow instead of P&L

   A client prepays three months in July — and the spreadsheet shows a "record July" followed by two "terrible" months, even though the team worked the same. Money movement and revenue are different things: a P&L assigns revenue to the month the services were delivered. Spread the prepayment across the months it covers, and the margin starts describing reality instead of your payment schedule.

2. 2

   Forgetting taxes in OpEx

   The entrepreneur’s single tax, social contributions, currency-exchange fees — these are business costs exactly like software or rent. Leave them out and your net margin is overstated by several percentage points, which you discover at payment time. The template has a dedicated tax row — fill it monthly even if you pay quarterly: divide the quarterly bill by three.

3. 3

   Not locking the exchange rate on the transaction date

   Converting a whole month of income "at today’s rate" means your P&L rewrites itself every time the currency market moves. Revenue received on the 3rd converts at the rate of the 3rd — and that rate is recorded for good. That is how monthly figures become final: once a month is closed, it never changes again.

4. 4

   Not allocating payroll to clients

   For a company-level P&L a total payroll figure is enough — but then you see whether the agency is profitable, not whether each client is. The next maturity level is allocating the team’s time across clients and computing per-client margin — which is where "our biggest client" regularly turns out to be the least profitable one. Start at the aggregate level, but plan the next one.

5. 5

   Counting yourself as free

   The most popular form of self-deception: the founder sells, manages and designs, but their salary is missing from the P&L — "the profit is mine anyway". As a result, an agency with a "35% margin" barely breaks even once the owner’s work is priced at market rate. Add yourself a row in the payroll section at the market salary for your role — and judge net profit after it.

When the spreadsheet stops being enough

This template honestly works up to a certain scale. The signs you have outgrown it: six or more clients, three currencies, a 15-minute ritual that became an hour of "why doesn’t this reconcile" — and, most telling, the key question shifting from "are we profitable" to "which clients are we profitable on", which an aggregate spreadsheet cannot answer.

CrewDriven builds this same P&L automatically — from the payments and invoices that already flow through the platform. Every payment is recorded in its original currency with the exchange rate locked on the transaction date and normalized to USD; monthly rollups assemble themselves; margin is visible per client. The logic is identical to the template — revenue, team, OpEx, margin — but the numbers fill themselves in during the month: tracked time becomes an invoice, the invoice becomes revenue, and revenue becomes a line in a multi-currency P&L.

The platform is free during the launch period — you can create your workspace and move your numbers over in an evening. Comparing finance tools for your agency? See our CrewDriven vs Finmap comparison. And if you just need to bill a client right now, there is a free invoice generator — no sign-up required.

Frequently asked questions

What is the difference between P&L and cash-flow?

A P&L (profit and loss statement) shows what the business earned: revenue is assigned to the month the services were delivered, costs to the month they were incurred for. Cash-flow shows money moving through accounts: when payments actually arrived and left. An agency needs both, but only the P&L answers "are we profitable" — a profitable business can still hit a cash gap, and a full bank account can hide a loss-making one if it is holding prepayments.

Which currency should be the accounting currency?

The one most of your revenue and your main costs are denominated in. For most agencies billing international clients that is USD: payments arrive in dollars, team rates and subscriptions are quoted in dollars. If all your clients and costs are local, use your local currency. What matters is one currency for the whole table — and locking each conversion at the rate of its transaction date.

How do I account for the owner’s salary?

As a separate row in the direct-labor section, at the market rate of the work you actually do. Half salesperson, half project manager? Enter half of each role’s market salary. Net profit after your salary is the profit of the business as a system; anything you pay yourself beyond that is profit distribution, not a cost.

Should VAT and taxes go into the P&L?

Business taxes — yes, as a dedicated OpEx line: for Ukrainian FOP entrepreneurs that means the single tax and social contribution; elsewhere, your self-employment or corporate equivalents. VAT — no: if you are a VAT payer, it is a pass-through tax you collect from the client and remit to the state, so revenue and costs are recorded net of VAT. The details depend on your setup — confirm them with your accountant.

How often should the P&L be updated?

Monthly is both the required minimum and a sufficient rhythm for management decisions: a month is the natural cycle of salaries, retainers and subscriptions. More often only makes sense before big decisions — a hire, a rate increase, dropping a client. Less often is dangerous: with a quarterly P&L, you notice a loss-making month only after two more just like it have already passed.