How to configure Expense Rules in RevRec?
How to create accounting rules for Expenses via bulk upload?
What fields are mandatory and optional in Expense rules?
RevRec’s Expense feature can recognize the business or contract cost associated with a subscription, based on a set of rules defined. The accounting rules are a set of guidelines provided by you to the system. These guidelines help the system in deciding the correct treatment for each type of expense. You can configure the accounting rules either through the application UI or through bulk upload functionality. Click Settings > Configure Advanced > Configure Accounting Rules > +New Expense Rule.
Note: Expense feature is not enabled by default, reach out to our RevRec Support to enable this on your site.
Follow the steps below to create an accounting rule (expense rule) on your RevRec site:
|Expense Code||Required||A code is used in RevRec to identify a certain cost.|
|Product Code||Optional||A code is used in RevRec to identify the product.|
|Product||Optional||The product name to which you want to associate this rule.|
|Allocate Across all items in the Contract||Optional||If enabled, RevRec will allocate the cost to each line item of a contract.If disabled, RevRec allocates the entire cost to the associated product only.|
|Follow Revenue Recognition Rule||Optional||If enabled, Contract Cost will follow the revenue recognition method and terms defined for each order item in a contract.If disabled, the Contract Cost will follow what is configured in the following fields.|
|Recognition Method||Required||To amortize the expense over a certain term or recognize it as the expense incurred. You can select from the following options: Ratable, Point-in-time|
|Amortization Start Date||Optional||The date on which the expense amortization schedule will start.|
|Amortization Term||Required||Term in a month for which the expense will be provided. If a term is provided, an end date is not required.|
|Amortization End Date||Optional||The date on which the expense amortization schedule will end.|
If this option is enabled, the Contract Cost will follow the revenue recognition rules (both method and term) defined for each product in a contract.
For Example, a customer has signed up for an annual subscription that includes Product A with an annual contract value of $12,000. The revenue for this subscription is recognized in a ratable manner over 12 months. There is a contract cost of $1,200 associated with product A. RevRec will automatically use the revenue Ratable recognition method and 12 Months term for expense recognition. A $100 expense is recognized per month over 12 months.
If this option is disabled, you can specify the (Ratable or Point in time), , (Amortization Date or Expense Date), and .
If this option is enabled, the Contract Cost will be allocated to all products in the contract. The allocation ratio will be based on the sale price of the products and the total contract value. Assume, we have two products A and B. Product A has a sale price of $12,000 and Product B has a sale price of $6,000. Product A has an associated contract cost of $1,200.
If setting is enabled then RevRec allocates a contract cost of $1,200 between products A and B. The ratio for allocation is 66:33 based on their product sales price and the total contract value of the subscription. The allocated cost for product A will be $800 and product B will be $400.
|Expense Code||Required||This is the unique identifier for the expense. RevRec matches this code against the code provided for the expense to apply the accounting rule.|
|Recognition Method||Required||There are two expense recognition methods available in the system - Ratable or Point in Time|
|Amortization Term||Optional||The amortization term is the duration for which the user wants to amortize the expense. The term is defined in months in the system.|
Your Expense rule is successfully created.
You can do a bulk upload of multiple contract cost rules for your products and services in RevRec instead of configuring them individually. To do a bulk upload of your cost rules, follow these steps:
The SSP Type column defines the Contract Cost Rule or Other Cost Rule. Specify for the contract cost rule and for the other cost rule
|Invalid||RevRec displays invalid rules with a validation error. Click the ⓘ icon to see the validation error for each rule.|
|Duplicate||RevRec displays duplicate rules that exist in the uploaded file.|
|New||RevRec displays new rules that are added to the accounting rules.|
|Updated||RevRec displays rules that already exist and are updated.|
After confirmation, the uploaded rules are added to the accounting rule engine.
Related Article and Documentation