Costs and pricing
Part of A newsletter monetisation budget that keeps six money concepts apart
A newsletter budget template with fields for VAT, uncertainty and safe exit
Use a blank newsletter budget template for England with source, currency, VAT, unit, timing, uncertainty, approval, reforecast and safe-exit fields.
What to take away
- Build four tabsscope, cost ledger, revenue and reversal ledger, controls. Keep them apart so gross receipts are never read as cash.
- Fill every cell from a dated supplier document, an approved time record or written tax advice. A blank cell means unknown, not zero.
- Add VAT status and VAT treatment columns now, and date the rate and threshold you check.
- Give every cost a confidence value, a sensitivity range and an exit treatment before approval.
- Lock each forecast version, and reforecast only when a plan, fee, currency, audience or contract changes.
Four tabs the workbook needs
One sheet hides the difference between a commitment, an invoice and money in the bank. Split the file.
- Scopelegal entity, England establishment, revenue route, reporting currency and accounting basis.
- Cost ledgerone row per cost, carrying supplier, product, unit, VAT status and evidence link.
- Revenue and reversal ledgerone row per payable event, including refunds and chargebacks.
- Controlsassumptions, thresholds, approval limits and the safe-exit plan.
The owner and the next review date sit on the scope tab too. Keep paid access, sponsorship, advertising, affiliate and owned-service routes on separate rows.
Define the payable event for each route, then read the revenue strategy guide before merging routes onto one line.
Example: one filled row per ledger
Illustrative entries only. Replace each with your own evidence.
Cost field / Example entry
- Cost ID and category
- C-014, platform delivery
- Supplier and document
- Ghost(Pro) invoice dated 3 February
- Unit and quantity
- GBP per month, 12 months
- VAT status
- 20% standard rate, recoverable if your accountant confirms
- Cash date and confidence
- 1 March, high
- Exit treatment
- Export subscriber list, cancel billing at term end
Revenue row R-006: paid access; gross receipt £4.00; invoice date 4 March; settled 6 March; payment fee £0.26; no refund or chargeback; 30 days of access; named treatment owner; evidence is the payout report.
Ghost(Pro) prices per site while beehiiv publishes plan tiers in its own units. Stripe keeps a separate Billing page from its payments page, so hold each original unit before converting anything.
VAT fields and the dated review input
The VAT status column takes five values: standard rated, zero rated, exempt, outside the scope, not registered. The VAT treatment field names who decided, on what date and from which document.
The UK standard rate is 20%, and the registration threshold has been £90,000 since 1 April 2024. Store both figures with the date you checked them. Each is a review input rather than a fixed setting.
The latest HMRC VAT registration notice is a review input, not a finished VAT decision. Use your accountant's written advice for the actual England operator.
Self-employed records must show sales, income, expenses and proof, as HMRC sets out in its guidance on records to keep. Other legal forms follow different rules.
Confidence, sensitivity and two cost views
Every cost row carries high, medium or low confidence plus a sensitivity range for the assumption underneath it. Some rows also carry a retirement date, after which the assumption is re-checked.
period cash movement = cash settled minus refunds paid minus chargeback losses minus cash expenses paid
full economic cost = cash costs plus approved internal labour plus other consumed resources
The cash-timing view shows bank movements by expected date. The economic-cost view includes committed invoices and approved internal labour when resources are consumed. State the accounting policy, and never reconcile the two by deleting real timing differences.
If you are still choosing between routes, compare them on one grid using newsletter revenue models before the ledger hardens.
Safe-exit fields with concrete steps
The exit column starts at signature. The contract points that decide how a deal ends belong in the workbook before you sign, not after.
- Export the subscriber list, content archive and payment history into a portable file, and keep a copy off the platform.
- Preserve suppression and unsubscribe records so nobody is contacted again once the newsletter closes.
- Cancel every recurring billing line, then ask the payment provider to confirm in writing that no further charges will be taken.
- Confirm paid readers keep access until the agreed end date, and publish that date to them.
- Record the final reconciliation, tax filing and archive evidence in the control tab.
Common questions
What belongs in the scope tab?
Legal entity, England establishment, revenue route, reporting currency and accounting basis. The owner and review date sit here too.
Should the template record a VAT decision?
Only as a dated review input with a named decision maker. Whether to register is your accountant's call, not a template setting.
Why keep cash-timing and economic-cost views apart?
Cash timing shows when money moves through the bank. Economic cost shows resources consumed in the period, including committed invoices and internal labour. Merging them hides when a squeeze is coming.
