Subscription Revenue Accounting

A deferred revenue ledger you can prove, written MRR, ARR and churn definitions, a monthly waterfall and MRR bridge, contract change rules and the audit and investor work that recurring revenue attracts.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Then open the Marketplace in the app, search for Subscription Revenue Accounting, and click Install. It goes into your own files, and works offline from then on.

Before you start: this plan is general information to help your team organise its work. It is not financial, investment, tax, accounting or legal advice, and it does not recommend any product, investment or deal. Rules differ between countries, so check decisions that matter with qualified, licensed advisers in the countries concerned. Investing can lose money, and raising or managing other people's money is regulated in most countries.

What it installs.

1

Pillar

1

Area

50

Projects

206

Starter tasks

🧾 Finance & Accounting

Subscription Revenue Accounting

Accounting for subscriptions and software: deferred revenue, monthly recurring revenue, churn and contract changes, for SaaS founders and finance teams.

  1. Subscription contract and plan inventory
  2. Written MRR and ARR definitions
  3. Deferred revenue account structure in the ledger
  4. Revenue treatment map for every price book item
  5. Billing system to ledger data flow map
  6. Opening deferred revenue balance rebuild
  7. Subscription customer data clean-up
  8. Churn and retention metric definitions
  9. Bookings, billings and revenue explained for the team
  10. Monthly deferred revenue waterfall
  11. Monthly MRR bridge from opening to closing
  12. Billing system to ledger revenue reconciliation
  13. Unbilled receivables and contract asset review
  14. Contract changes log for upgrades, downgrades and cancellations
  15. Monthly churn and retention metrics pack
  16. Renewals look-ahead and auto-renewal checks
  17. Credits, refunds and service credits register
  18. Monthly usage and overage accrual
  19. Quarterly recurring revenue pack for the board
  20. Failed payment and involuntary churn tracking
  21. Ratable recognition and daily proration
  22. Accounting for mid-term upgrades and contract modifications
  23. Multi-year prepaid contracts and the non-current split
  24. Setup, onboarding and implementation fees
  25. Discounts, free months and ramped pricing
  26. Usage, overage and hybrid pricing treatment
  27. Free trials, paused accounts and freemium conversions
  28. Spotting inflated ARR and MRR figures
  29. Subscription billing platform choice
  30. Revenue automation decision for the waterfall
  31. Moving the deferred revenue waterfall out of spreadsheets
  32. Billing in advance versus in arrears decision
  33. Annual prepayment discount policy
  34. Cancellation and refund terms that match the accounts
  35. Constant currency MRR for multi-currency subscriptions
  36. Shortening the subscription revenue close
  37. First external audit of deferred revenue
  38. Investor due diligence on recurring revenue
  39. Annual price increase rollout accounting
  40. Year-end deferred revenue cut-off
  41. Billing migration cutover and revenue parallel run
  42. Founder-run subscription accounts before a finance hire
  43. New finance lead taking over SaaS revenue reporting
  44. Revenue hand-offs between sales, billing and finance
  45. Moving from self-serve monthly plans to annual sales-led contracts
  46. Subscriptions sold through app stores and marketplaces
  47. Capitalised sales commissions and their amortisation
  48. Remaining performance obligations disclosure
  49. Cohort-based net revenue retention analysis
  50. Acquired deferred revenue in a customer book purchase

Where it starts.

Each project arrives with its purpose, milestones and first tasks written out. Here is how the first three read.

Subscription contract and plan inventory

Every number in subscription accounting starts from knowing exactly what each customer bought: the plan, the price, the term, the billing frequency and the start and end dates. Most young SaaS companies have this split across a billing tool, a CRM and a folder of signed order forms that disagree with each other.

First tasks

  • Export all active subscriptions from the billing system to a spreadsheet
  • Pull closed-won deals from the CRM for the same customers
  • Match each subscription to its signed order form or accepted online terms
  • List every mismatch in plan, price or dates and assign an owner to fix it
  • Flag free months, price locks and termination rights in a separate column

Written MRR and ARR definitions

Ask three people in a SaaS company what MRR is and you will often get three answers: one includes setup fees, one counts signed contracts that have not started, one divides annual contracts by twelve and another does not. A one-page definition, agreed by the founder and finance lead, stops board packs, investor updates and sales targets from quietly using different numbers.

First tasks

  • Collect every MRR or ARR figure reported in the last six months and how each was worked out
  • Write the in and out rules for setup fees, usage, credits, taxes and unstarted contracts
  • Agree the treatment of discounts, free months and foreign currency with the founder
  • Publish the signed definition in the finance folder and link it from the metrics dashboard
  • Review the MRR and ARR definitions against any new pricing or plan types @recurring(yearly)

Deferred revenue account structure in the ledger

Many subscription businesses post every invoice straight to revenue and fix it with one large journal at year end, which means management accounts are wrong eleven months out of twelve. Setting up the right balance sheet accounts for deferred revenue, unbilled receivables and customer credits lets each month show the revenue actually earned.

First tasks

  • List where subscription invoices currently post in the ledger
  • Create deferred revenue, unbilled receivables and revenue stream accounts
  • Remap billing system products so invoices post to deferred revenue
  • Post a test invoice and check where each line lands in the ledger

Make it yours.

Install Subscription Revenue Accounting, then tell Aurum the date you're aiming for. It checks whether the plan fits the weeks you actually have.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Blueprints are general information to help you organise your own work. They are not medical, financial, legal or other professional advice. See the Terms.