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.

Creating Expense Recognition Rules via UI

Follow the steps below to create an accounting rule (expense rule) on your RevRec site:
Click Settings > Configure.
Navigate to Advanced > Configure Accounting Rules, and click Configure > +New Expense Rule.



You can create two types of rules - Contract Cost Rule and Other Cost Rule.
To create a Contract Cost Rule, click +Contract Costs Rule. On the Create Contract Cost Rule window that appears, specify the following details:



FieldsRequired/OptionalDescription
Expense CodeRequiredA code is used in RevRec to identify a certain cost.
Product CodeOptionalA code is used in RevRec to identify the product.
ProductOptionalThe product name to which you want to associate this rule.
Allocate Across all items in ContractOptionalIf 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 RuleOptionalIf 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 MethodRequiredTo 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 DateOptionalThe date on which the expense amortization schedule will start.
Amortization TermRequiredTerm in a month for which the expense will be provided. If a term is provided, an end date is not required.
Amortization End DateOptionalThe date on which the expense amortization schedule will end.


Follow the Revenue Recognition Rule:
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. $100 expense is recognized per month over 12 months.

If this option is disabled, you can specify the Amortization Method (Ratable or Point in time), Amortization Start Date, Amortization End Date (Amortization Date or Expense Date), and Amortization Term.

Allocate across all items in the contract:
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 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 Allocate across all items in the contract 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 total contract value of the subscription. The allocated cost for product A will be $800 and product B will be $400.

To create the Other Cost Rule, click +New Other Cost Rule to add a new rule. On the Create Other Cost Rule window that appears, specify the following details:



FieldsRequired/OptionalDescription
Expense CodeRequiredThis is the unique identifier for the expense. RevRec matches this code against the code provided for the expense to apply the accounting rule.
Recognition MethodRequiredThere are two expense recognition methods available in the system - Ratable or Point in Time
Amortization TermOptionalThe amortization term is the duration for which the user wants to amortize the expense. The term is defined in months in the system.


Once you are done, click Save.
Your Expense rule is successfully created.

Creating Accounting Rules for Expense via Bulk Upload

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:

Click Settings > Configure.
Navigate to Advanced > Configure Accounting Rules, and click Configure.
Create a spreadsheet with fields mentioned in the above section

The SSP Type column defines the Contract Cost Rule or Other Cost Rule. Specify Direct for the contract cost rule and Indirect for the other cost rule.

Save the updated file.
Once your file is ready to be uploaded, click Upload on the Accounting Rules page and upload the saved file and click Done.
After upload, the file is processed and analyzed for any error. Once the processing is complete, you can view the status of the rules uploaded. The rules are broken down into four categories as follows:

CategoryDescription
InvalidRevRec displays invalid rules with a validation error. Click the ⓘ icon to see the validation error for each rule.
DuplicateRevRec displays duplicate rules that exist in the uploaded file.
NewRevRec dislays new rules that are added to the accounting rules.
UpdatedRevRec displays rules that already exist and are updated.


Fix the validation errors appearing for invalid rules and upload the entire file again.
Once all invalid rules are resolved, you can confirm the rules appearing in the list by clicking Confirm and Save.

After confirmation, the uploaded rules are added to the accounting rule engine.
Was this article helpful?
Cancel
Thank you!