B2B SaaS Revenue Recognition Excel Template
Originally published: 21/12/2018 08:46
Last version published: 23/07/2021 09:47
Publication number: ELQ-39644-6
View all versions & Certificate

B2B SaaS Revenue Recognition Excel Template

A simple tool for managing supporting revenue recognition for SaaS businesses.

Provide leaders at businesses that sell annual SaaS or software subscriptions with a simple tool for managing their revenue recognition needs.

This template is intended to be very straightforward with reasonable flexibility for various common billing frequencies.

To recognize subscription revenue properly, it is important to track four key amounts:

1. New Deferred, Unbilled - While it is up to you to decide whether or not you want to track this in your ledger (the decision depends on the nature of your contracts), this is the amount of money under contract with a new customer but has yet to be billed.

2. New Deferred, Billed - As you bill a customer against a given sales order, this is the amount that moves from Unbilled Deferred Revenue to Billed Deferred Revenue

3. Recognized Revenue - Once a subscription has commenced and is recognizable revenue, this is the amount of revenue you debit from Deferred, Billed and credit to Revenue Recognized (and appears on your Income Statement).

4. Ending Deferred Billed - This is your check to make sure your revenue is correctly flowing from your Balance Sheet to the Income Statement. It is the ending balance that has been billed but not yet recognized.

Good luck!

And with all accounting, please seek the advice of a certified accounting professional should you have any questions. This template is intended to be a guilde for those who already have some familiarity with recognizing software revenue.

This Best Practice includes
1 Excel template

Brian Weisberg offers you this Best Practice for free!

download for free

Add to bookmarks


Further information

Enterprise SaaS businesses with annual customer agreements

Businesses with complicated billing terms/frequencies

4.5 / 5 (15 votes)

please wait...