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
certified

B2B SaaS Revenue Recognition Excel Template

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

Description
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

Discuss

Further information

Enterprise SaaS businesses with annual customer agreements

Businesses with complicated billing terms/frequencies

Reviews

keyboard_arrow_downShow all

People using this Best Practice also downloaded


keyboard_arrow_leftkeyboard_arrow_right

Discussion feed for B2B SaaS Revenue Recognition Excel Template

The user community and author are here to help. Go ahead!

  • Grant Hoover, CPA
    Many of the "Deferred, Billed" lines are not zeroing out. For example the deferred revenue goes on forever instead of ending when it would hit zero. Is there a solution for this?
    arrow_drop_uparrow_drop_downReply reply


    4.7 / 5 (13 votes)

    please wait...