Overview
Line Items allow administrators to make manual adjustments to residuals by adding income or expenses that were not included in the original imported residual data. These adjustments help ensure that residual reports and payouts accurately reflect any additional credits or deductions.
There are two types of line items:
- Additions: Additional income that increases the residual amount credited for a reporting period.
- Deductions: Expenses or adjustments that reduce the residual amount for a reporting period.
Line items can be applied in two ways:
- One-time line items: Apply an individual addition or deduction to a specific residual period.
- Repeating line items: Automatically apply the same addition or deduction across multiple residual periods.
You can create, view, edit, and manage line items from the Residuals and Residuals Line Items pages, provided you have the required permissions.
Prerequisites
Before managing line items, ensure that the Manage Line Items permission is enabled for your user class under Site Management.
View Line Items
You can view and manage line items from either the Residuals page or the Residuals Line Items page.
View Line Items on the Residuals Page
- Open the Residuals page from the navigation panel.
- Select the Line Items tab.
The Line Items tab displays two tables:
- Additions: Displays additional income applied to residuals.
- Deductions: Displays expenses and other amounts deducted from residuals.
To narrow the results, click Filters in the upper-right corner of the report. Select the relevant month, user, or group, and apply the filters to display matching line items.
View Line Items on the Residuals Line Items Page
The Residuals Line Items page provides a chronological view of your line items, including recurring adjustments.
- Expand Residuals in the navigation panel.
- Select Residuals Line Items.
- Switch between the line items and recurring line items tabs to view the corresponding records.
Use the shortcuts in the Options column to view the details of a line item, edit it, or delete it.
You can also create a new line item by clicking Add Line Item.
To organise the results, click a column heading to sort the table. You can also use the filters at the bottom of the table to narrow the displayed records.
Add a Line Item
You can manually create an addition or deduction from the Residuals page or the Residuals Line Items page.
To add a line item from the Residuals page:
- Open the Residuals page and select the Line Items tab.
- Locate the appropriate Additions or Deductions table.
- Click Add Line Item.
- Enter the required line item details.
- Save the line item.
Alternatively, open the Residuals Line Items page and click Add Line Item to create a new adjustment.
Schedule a Repeating Line Item
If the same addition or deduction needs to be applied across multiple residual periods, you can schedule it as a repeating line item.
- Begin creating a line item using the steps in Add a Line Item.
- Enter the line item details.
- Select Schedule Repeating Item.
- Complete the scheduling options to define when the adjustment should repeat.
- Save the repeating line item.
You can view and manage scheduled adjustments from the Recurring Line Items tab on the Residuals Line Items page.
Import Line Items
To create multiple line items at once, use the Line Item Importer to upload a completed import template.
- Expand Residuals in the navigation panel and select Residuals Line Items.
- Click Line Item Importer.
-
In the import popup, download the Line Item Import Template and open it in Excel.
-
Enter the line item information in the template and save the completed file.
- Return to the import popup and upload the completed file.
- Click Start Import to begin importing the line items.
- Once the import is complete, a confirmation message appears.
If the uploaded template contains errors, the importer displays the issues in the popup and stops the import. Review the error messages, correct the affected entries in the template, and upload the updated file to try again.