Scope
How to provide Expense Input Data in RevRec?
How to create a Contract Cost Rule in RevRec?
How to create the Other Cost rules in RevRec?
What are the fields optional and mandatory in Expense rules?
How to bulk upload Expense rules in RevRec?
Can I direct integrate the source system to pull the expense data?
Summary
You can provide contact and other cost-related data in RevRec using the following ways:
- Manual input of data using the Sale Order UI.
- Bulk upload of data using the Sync UI.
Direct integration with source systems to pull expense data is not yet supportedSolution
Manual Input of Expense Data
You can enter the expense data directly in RevRec via the application UI. Follow the steps below to add new expense data on your RevRec site:
Click the Expense menu item on the left panel.
The Expense page displays two tabs - Contract Cost and Other Cost.
You can navigate to either of these tabs to view data already added.
To add a new Contract Cost,
Click Sales Order on the left panel and open a sales order record to which you are adding the expense.
Click the Lock icon to edit the sales order record, and navigate to the Expense section to add a new expense.
Click Save Changes.
To add a new Other Cost,
Click Expense on the left panel and navigate to the Other Costs tab.
By default, you can only view existing other costs. Click the Lock icon to add or update other costs. Once the screen is unlocked, click +Add New Other Cost and specify details as displayed in the screenshot.
You can add additional items by clicking +Add New Expense Item.
Bulk Upload of Expense Data
You can create a spreadsheet using the below fields, and upload the same spreadsheet into RevRec using the Sync Job. Once the file is ready to be uploaded, follow the steps below to carry out a bulk upload:
Login to your RevRec environment and click Sync.
Click the Import Data icon, specify a Job Name for the upload job, and drag and drop your file.
Click Import for RevRec to process your file.
| Fields | Required/Optional | Description |
|---|---|---|
| Order Number | Optional | A number is used to identify the sale order or contract. |
| Product Code | Optional | A code is used in RevRec to identify the product. |
| Reference Number | Optional | This is a unique identifier for the record. |
| Expense Code | Required | A code is used in RevRec to identify a certain cost. |
| Expense Date | Required | The date when the expense occurred or was recorded in the user system of record. |
| Amortization Start Date | Optional | The date on which the expense amortization schedule will start. If provided, this field overrides the date type defined in the rules. |
| Amortization End Date | Optional | The date on which the expense amortization schedule will end. If provided, this field overrides the date type defined in the rules. |
| Expense Amount | Required | An amount paid for the expense incurred. |
| 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. If a term is provided, an end date is not required. This field overrides the term defined in the rules. |
| Class | Optional | Class of the expense. |
| Department | Optional | Department to which expense relates. |
| Location | Optional | Office location to which expense belongs. |
| Sales Person | Optional | Person to whom this expense is paid. |
After Upload, the file is processed and analyzed for any errors. Once the processing is complete, the status column on the page will show Success.
You can view expenses from the Sale Order UI or the Expense UI.
Note: You can also provide additional data related to the expense as a custom field. Contact revrec-support@chargebee.com to avail this feature. Once set up, you can use these custom fields on the reports.Related Article and Documentation