Free templates / SaaS chart of accounts
SaaS chart of accounts template (Excel)
A ready chart of accounts for a SaaS company, numbered and tagged by department so gross margin, CAC and burn come straight off the P&L.
SaaS chart of accounts template (Excel)
Excel (.xlsx). Opens in Excel, Google Sheets, Numbers and LibreOffice. No sign-up.
- 71 accounts numbered by range: assets, liabilities, equity, revenue, cost of revenue, expenses, other, tax
- Every expense tagged COGS, S&M, R&D or G&A, with a dropdown for new ones
- Stripe clearing, deferred revenue, deferred commissions and sales tax payable set up the SaaS way
- A note on each account saying what goes in it
- A how-to sheet with the gross margin, CAC payback and burn formulas
Good questions. Clear answers.
Common questions.
Need a little more detail? We are happy to help.
Talk to our teamAt minimum: subscription and services revenue kept separate, deferred revenue as a liability, cost of revenue accounts for hosting, payment processing and support, and operating expenses split into sales and marketing, research and development, and general and administrative. That split is what lets gross margin and CAC come straight off the profit and loss.
Hosting for the live product goes in cost of revenue, along with payment processing and customer support. Development and staging environments go in research and development.
Gross. Record the full charge as revenue, the Stripe fee as a cost of revenue expense, and the payout to your bank as a transfer from a Stripe clearing account. Booking only the net payout understates both revenue and cost.
It is a liability on the balance sheet. When a customer prepays for a year, the cash goes to deferred revenue and one twelfth moves to subscription revenue each month as the service is delivered.
More free tools
Small tools. Clearer decisions.
Practical calculators and templates to help you run your business.
- Invoice template
An invoice spreadsheet with totals that calculate themselves.
Download template - Income statement template
Profit and loss laid out the way an accountant expects.
Download template - Balance sheet template
Assets, liabilities and equity with the balance check built in.
Download template - Cash flow template
Operating, investing and financing flows on one sheet.
Download template - Runway calculator
See the month the cash runs out, or the month you break even.
Try calculator - Break-even calculator
Find the sales needed to cover your costs.
Try calculator