Skip to content
Faisal Mahmud TusherDigital marketing, SEO & analytics
with Faisal Tusher

Templates

Marketing P&L Template

A marketing profit and loss template: attributed revenue, gross margin, media, people, agency and tools, contribution after marketing, and variance notes.
Templateadvanced8 min readUpdated

What this template is for

Use the template when marketing needs to report to a board, an investor or a finance partner in terms of profit: a quarterly board pack, an annual budget defence, a review of whether a channel or a programme pays for itself. It also works as a standing monthly or quarterly view once finance has agreed the bases, at which point it becomes the one marketing statement both teams trust.

The template has close neighbours. The marketing P&L guide explains cost of sales versus operating expense, cost centres and accruals; the contribution margin guide explains the margin line; the monthly marketing report reads KPIs against targets. The swimwear profit and scale capstone practises a profit plan as an exercise. None of them is the blank statement with its lines, bases and variance notes, which is what this page provides.

The statement is only as useful as its agreement with finance. Build it from the ledger and the spend tracker, not from ad platforms, agree each basis once, and write the basis on the statement so nobody has to ask. A beautifully laid out view that does not reconcile will be set aside at the first question.

The template

Copy the table into a spreadsheet with a column for actual, budget and variance per line. The first row governs everything below it; write it before entering a number.

FieldWhat to write
Period and basisPeriod, currency, accrual or cash basis, and the revenue attribution basis used
Revenue linesRevenue from new and from existing customers, after returns and discounts, attributed on the stated basis; unattributed revenue shown, not hidden
Gross marginCost of goods and the variable costs of each sale taken off revenue to reach gross margin, with the rate used
Media costWorking media by channel, matched to invoices and accruals rather than platform spend where they differ
Non-media costPeople, agency fees, production and tools, with the cost centre each sits in
Contribution after marketingGross margin minus total marketing cost, in total and for new customers alone
Unit economicsAcquisition cost, payback period and a lifetime value view beside the period figures
Variance notesVariance to budget and forecast by line, with accruals, timing differences and reallocations explained

Keep a memo line for costs that relate to marketing but sit elsewhere in the accounts, such as affiliate commission in cost of sales or software in a technology cost centre. Showing them once, labelled, prevents both understatement and double counting.

How to fill each section

Period and basis

State the period, the currency, whether figures are on an accrual or a cash basis, and the attribution basis for revenue. The marketing P&L guide explains why accruals matter: costs are recorded when the service is delivered, so a cash view and an accrual view of the same quarter differ. The attribution basis is the most argued line of the statement, so write it in one sentence: which revenue counts as marketing-driven, on which model, and what is left out.

Revenue lines

Split revenue from new customers and revenue from existing customers, and state both after returns and discounts. Promotional discounts often reduce revenue rather than appearing as marketing cost, so revenue before discounts would overstate what marketing produced. Show the gap between attributed revenue and the company's total revenue as its own line; the marketing P&L guide recommends showing that gap rather than hiding it, because hiding it is the first thing finance will notice.

Gross margin

Take off the cost of goods and the variable costs that come with each sale — fulfilment, postage, payment fees, returns handling — to reach Gross Margin. The contribution margin and break-even guide explains which costs belong here and how the margin turns into break-even targets. Use the rate agreed with finance and state it; a marketing team that uses a different margin from finance produces a different profit.

Media cost

List working media by channel at the invoiced or accrued amount for the period. The guide to tracking spend against budget explains the three numbers — committed, spent and invoiced — and why platform spend, invoiced cost and the ledger can differ by tax, currency and timing. Where a line includes an accrual for work delivered but not yet invoiced, mark it so the next period's reversal does not look like a saving.

Non-media cost

List people, agency fees, production and tools, each with its cost centre. The marketing P&L guide notes that people costs and centrally held software change how large marketing looks, and that agency invoices combining media and fee hide the agency's cost. Follow the company's convention for people and say which convention it is, so the statement compares with earlier periods and other teams. If the ledger cannot yet report these lines by cost type and cost centre, the tutorial on mapping marketing spend to finance codes sets up the coding with finance first.

Contribution after marketing

Subtract total marketing cost from gross margin, and show the result in total and for new customers alone. The total answers whether marketing paid for itself in the period; the new-customer line shows what acquisition cost against the margin new customers produced in the same period, which for a subscription or repeat-purchase business is often negative by design. That is the point of showing it beside the unit economics. Contribution Margin is the concept; the line is its application to marketing.

Unit economics

Put acquisition cost, payback and a lifetime value view beside the period figures. The LTV and CAC guide explains blended versus channel CAC, why lifetime value should be measured in margin rather than revenue, and how Payback Period connects the two to cash. The break-even calculator helps check the point at which a customer's margin covers what it cost to acquire them.

Variance notes

For each line that differs materially from budget or forecast, write the variance and the reason: timing, accrual, an approved reallocation, a price change, a coding error. The spend tracking guide covers explaining variances and when they become a reforecast. Permanent variances belong in next period's forecast; timing variances reverse and should be labelled so nobody plans on them.

Filled example

Below, the statement is completed for an invented business. The figures, bases and names are illustrative.

Illustrative example — not a real result

Tollerdine Tea Company: marketing P&L for the July to September board meeting

FieldTollerdine's statement
Period and basisJuly to September, GBP, accrual basis, agreed with the finance manager. Attribution: all revenue from subscribers whose first order fell in the period counts as new-customer revenue; existing-subscriber revenue is shown separately and not attributed to any channel. Gift shop one-off orders shown as a third line
Revenue linesNew subscribers (2,400): £62,000 after the 50% first-box discount. Existing subscribers: £410,000. Gift shop: £38,000. Total £510,000 after refunds, reconciled to the ledger. Discounts of £31,000 on first boxes reduce revenue and are noted here rather than counted as marketing cost
Gross marginTea and packaging £150,000, fulfilment and postage £56,000, payment fees £10,200. Gross margin £293,800, a rate of 57.6%, matching finance's management accounts
Media costMeta £48,000 (invoiced). Google Ads £21,000 (invoiced). Creator posts £12,000, of which £4,000 accrued for September posts not yet invoiced. Total media £81,000. Memo: affiliate commission £6,500, held in cost of sales and already inside gross margin
Non-media costMarketing team salaries £36,000 (marketing cost centre). Paid social agency fee £9,000 (marketing, invoiced separately from media). Photography £5,000 (marketing). Email platform £3,600 (technology cost centre; included here by agreement). Total non-media £53,600. Total marketing cost £134,600
Contribution after marketing£293,800 − £134,600 = £159,200 for the quarter. New-customer view: margin on new subscribers' orders £35,700 less acquisition cost (media, agency fee and photography) £95,000 = −£59,300, or about −£25 per new subscriber in the quarter of acquisition
Unit economicsAcquisition cost about £40 per new subscriber. Margin per active subscriber about £8 a month. Payback at observed retention: month 6. Twelve-month margin per new subscriber at observed retention: about £61, so the cohort recovers its acquisition cost and roughly half again within a year
Variance notesMeta £6,000 over budget: approved reallocation from search in August, memo ref BR-07. Creator posts include a £4,000 accrual that reverses in October. Revenue £18,000 under budget: the price rise moved from August to October. Tools £1,400 under budget: email platform renewal discount

The board's first question was the new-customer contribution line. Because the unit economics sat beside it, the conversation moved from "marketing loses money on new customers" to whether month-six payback was acceptable for the cash the business had, which was the decision the board actually needed to take.

Common mistakes

  • Platform spend instead of invoices. Platform figures differ from the ledger by tax, currency and timing. Build from the spend tracker and invoices so the statement reconciles.
  • No stated attribution basis. Revenue attributed on an unstated model invites an argument about the model rather than the result. Write the basis in the first row.
  • Revenue before discounts. Promotional discounts are often booked as a reduction of revenue. Counting revenue before them overstates what marketing produced.
  • Leaving out people, fees or tools. A statement of media only makes marketing look cheaper than it is, and finance will add the rest. Include them, with their cost centres.
  • Double counting commission. Affiliate commission held in cost of sales is already inside gross margin. Show it as a memo line, not as a second marketing cost.
  • Judging acquisition in one period. New customers acquired at a loss in the quarter can be the best investment of the year. Put payback and lifetime value beside the period view.
  • Variances without reasons. An unexplained variance looks like a control failure. Label timing, accruals and approved reallocations separately from permanent changes.

The monthly report that tracks KPIs between statements and the budget reallocation memo behind approved moves are in the templates library.

Terms used on this page

Tools to try

Where this page is used

Also related

Sources

  1. Chartered Institute of Marketing — CIM

Related