1. Help Center
  2. Tips & Tricks
  3. Balance Sheet Planning Tips & Tricks

Simple Deferred Revenue with Jirav Pro

Leverage Jirav Pro to recognize deferred revenue and subscriptions bookings

This article will walk through an example of using the Jirav Pro product to record deferred revenue with associated billing and recognize revenue from the deferral.

This is a good way to simplify your three way financials forecast while leveraging other systems to manage your subscription revenue.

Step 1:

The first thing is to set up a custom table by going to ⚙️-> Custom tables

To learn about custom tables refer to this help article

We will ant a custom table that has a line for New Billings and Recognized Revenue; see the screen shot below for the setup.

Now that we have defined the custom lines we can then go to Drivers___2019_Budget___Plans___Webinar-Demo___Jirav-9->Custom Lines

As noted in the screen shot above we will enter the amounts into the table directly or alternatively you can create drivers if you find that to be simpler.

Step 2:

Next step is to set up the balance sheet drivers to record the billings to the deferred revenue liability account as well as the offsetting recognition of revenue.

Learn how to create drivers in this help article

A

 

The output of the drivers created are both to the Deferred Revenue Account, one is increasing the account and the other is decreasing the account. The increase is for the billings that we will enter into the custom line we created in step 1 and the decrease is the amount of revenue recognized that is also driven by the amount we will enter into the custom line we created in step 1.
B

 

The driver of the formula in both instances is the custom lines we created in step 1 - one driver is for the billings and the second is for the recognized revenue.
C

 

The amount that we entered into the custom line is then simply multiplied by 1 to calculate the the exact amount we enter into the custom line
D

 

This is a driver that we would like to have evaluated for the entire time the model is forecasted so we choose to start at cutover date (Plan Start Date) through the Maximum time of the model - learn more about this in our Plans Management help article

Step 3:

Set up a driver to recognize the revenue to the income statement.

A

 

The output of the driver is to the Sales revenue account
B

 

The driver of the formula is the custom line we created for the recognized revenue
C

 

The amount that we entered into the custom line is then simply multiplied by 1 to calculate the the exact amount we enter into the custom line
D

 

This is a driver that we would like to have evaluated for the entire time the model is forecasted so we choose to start at cutover date (Plan Start Date) through the Maximum time of the model - learn more about this in our Plans Management help article

Step 4:

Now that we have all the financial model depencies created lets enter in amounts to the custom line and trace the amounts through plans and reports; lets start with entering in values for the custom lines for the new billings which will result in a deferred revenue balance as well as the recognized revenue that will decrease the liability and also flow through the income statement as revenue.

Go to ⚙️->Custom and enter in the amounts

Next lets go look at the balance sheet section by going to ⚙️->Liabilities

A - This is the row in the table that is the account "Deferred Revenue" which is what was selected as the Output when the drivers were created.  Note that the balance in the row for the forecasted months is additive of all the rows beneath it; in other words - Jirav is giving you all the detail of the increase and decrease to the account that is rolling up into the balance.

B & C - These are the drivers we created to increase the liability for billings and decrease the liability for recognized revenue. Note you can also edit the driver from the table by double clicking in the row.

Here is the report of the balance sheet as well - you can see cash goes up by the amount of the billed revenue since the liabilities increase results in an increase in cash in the financial model.

Go to and navigate to a balance sheet report.

The example I have below has been set up in a manner to show that the cash changes based on the deferred changing; you will see cash variance is based on the change in the deferred revenue balance.

The last area to look at is the revenue that is recognized and that is much more straightforward - the revenue has been booked directly as part of step 3 and can be seen in the report below:

This revenue will then flow through to Net Income which closes out to Retained Earnings thus offsetting the balance sheet deferred revenue that has been recognized - Jirav does all the heavy lifting for you and the three way financials tie out for you.