Charge Details

Import Meter Data

Meter reading or consumption data that is imported for a charge can overwrite or be added to the existing data for a billing period. The Accumulate on Import option on the PLM Meters Setup page determines how meter reading or consumption data is imported.

To import meter data for a specific charge, follow these steps: 

1. If you do not currently have a correctly formatted file, select PLM Import/Export > CSV File > Export > Meter Usage. Use the exported file as a template and update it with the data you want to import. For information on the file format, see CSV Format: Meter Reading Data.
2. After the import file is ready, select PLM Import/Export > CSV File > Import > Meter Usage.

Tip: To import or export the data for several meters, use the action from the PLM menu from the home page: PLM > PLM > Import/Export > CSV File > Export > Meter Usage.

The Billing Details Lines are updated with the imported data. For details about how data is overwritten or accumulated, review the following examples: 

Price Adjustment Lines

Specify the details for escalating a regular charge. Price adjustment lines are not available for meter (or consumption) charges.

When working with price adjustment lines for a lowest level line, remember the following information: 

• The dates of the initial price adjustment line are based on the dates of the selected lowest level line. In the case where the lease category has no required levels, the dates are based on the lease terms.
• The dates of the price adjustment lines cannot overlap. However, a date gap can occur between dates. When a gap occurs between price adjustment lines, the settings of the previous line are used until the next line.
• The end date of the last price adjustment line cannot be later than the end date of the lowest level line.
• When editing or deleting a price adjustment line, the Billing Details Lines are automatically updated after you select the next line.

Price Adjustment Dates within Lowest Level Dates

A lease has one lowest level line that starts on January 01, 2020 and an end date on December 31, 2022. Price adjustments are applied to the line as follows: 

Price Adjustment Dates Table

Price Adjustment Line	Start Date	End Date	Price Adjustment Amount
1	January 01, 2020	January 15, 2020	50.00
2	January 16, 2020	July 31, 2020	50.00
3	September 01, 2020	December 31, 2020	50.00
4	January 01, 2021	December 31, 2021	200.00
5	January 01, 2022	October 31, 2022	200.00

• The first price adjustment line has a start date of January 01 and an end date of January 15.
• The start date of the next price adjustment line cannot be on or before January 15. The second line has a start date of January 16 and an end date of July 31.
• A gap for the price adjustment occurs. The third line has a start date of September 01 and an end date of December 31.
• The end date of the last price adjustment line is October 31, 2022, which is earlier than the end date of the lowest level line.

Rate Schedules and Price Adjustments

If the escalation uses a rate schedule, the escalation amount that is applied to the charge is based both on the escalation frequency and the frequency of the rate schedule selected.

On the PLM Rate Schedules page, the following rate schedule is created: 

Escalation Rate Schedule Table

No:	Rate1
Description:	Rate schedule 1
Cost Driver:	None
Effective Date	Frequency	Rate
6/1/2024	Monthly	80.00
6/1/2025	Monthly	81.88
6/1/2026	Monthly	83.51
6/1/2027	Monthly	85.18

These rate schedule lines will apply to a charge on a monthly basis, increasing every year on June 1 until June 1, 2027.

When you apply this rate schedule to a charge of $1000, then the billing lines will have the following values:

Rate Schedules Actions Table

Next Invoice Date	Extended Amount
5/1/2024	$1000.00
6/1/2024	$1080.27
5/1/2025	$1080.27
6/1/2025	$1081.88
5/1/2026	$1081.88
6/1/2026	$1083.51
5/1/2027	$1083.51
6/1/2027	$1085.18

Add a Price Adjustment Charge

To add a price adjustment to a charge, follow these steps: 

1. Select Price Adjustment > New Line.
2. Specify the price adjustment, start, and the end dates. The end date must be later than the start date.
3. Select the Frequency and Price Adjustment Type.
4. Specify the price adjustment to use, Flat Percent, Flat Amount, CPI schedule, and Rate Schedule.
   You can specify one or more of these price adjustment methods.
5. Repeat these steps to add more price adjustment lines.

When the price adjustment is calculated, it uses the Price Adjustment Type selected, to determine how much the price adjustment is. For example, Price Adjustment Type is set to Greater of and price adjustment values are specified for Flat Percent, Flat Amount, CPI schedule, and Rate Schedule. The price adjustment used is the one that has the greatest calculated price adjustment amount.

Price Adjustment Lines

The following columns appear for the price adjustment lines: 

Price Adjustment Lines Table

Field	Description
Price Adjustment Date	Specify the price adjustment start date. The default date for the first line is the term start date as specified on the PLM Lease page. The default date for subsequent lines is the day after the term end date of the previous line. You can change this date to any date between the term start and end date. If the date is earlier than the term start date, the price adjustment starts on the term start date. If the date is after the end date of the term, no price adjustment occurs for the line.
Start/End Date	Displays the start and end dates for the term that is selected term on the Lease Terms FastTab of the PLM Lease page. The term end date can be changed as needed. For information about the dates, review the overview of this page.
Frequency	Select a frequency for the price adjustment. The options are: Monthly, Weekly, Bi-weekly, Quarterly, Annually, and One Time. The frequency must be the same or longer frequency than the billing frequency of the lease. For example, if the billing frequency of a lease is Monthly, the price adjustment frequency can be Monthly, Quarterly, or Annually.
Price Adjustment Type	Select an increase option on which to base escalations: Greater Of: Of the price adjustment methods entered, uses the method that has the largest value for the price adjustment. Lesser Of: Of the price adjustment methods entered, uses the method that has the smallest value for the price adjustment. The price adjustment methods are flat percent or amount, CPI schedule, or rate schedule. Empty or zero value (0) price adjustment methods are not considered as options.
Flat Percent	Specify a percent value to be used as the escalation.
Flat Amount	Specify a flat amount for the price adjustment.
CPI Schedule	Select a CPI schedule to attach to the price adjustment. If the CPI schedule you want does not exist, create one in the PLM CPI Schedules page.
Rate Schedule	Select a rate schedule to attach to the price adjustment. If the rate schedule you want does not exist, create one in the PLM Rate Schedules page.

Abatements Lines

Specify the details for abatement discount for a charge. You can use abatement discounts for all types of expense and revenue leases and charges. Abatement lines are not available for meter (or consumption) charges.

An abatement can be one of the following: 

• A recurring fixed discount amount that occurs during the start and end dates.
  If the charge is less than the fixed price adjustment amount, the abatement amount is deducted from the charge amount.
• A lump sum discount amount that begins on the start date and is applied until the lump sum is reduced to zero.
  Lump sum amounts are never prorated. If the lump sum amount is greater than the amount of the charge, the remaining abatement amount is carried over to the next billing period.

When a customer moves out or a lease is terminated, the abatement discounts are forfeited. For example, for the final billing period only the set lump sum or recurring abatement amounts are applied. Any unused abatement amounts are not applied, and are therefore lost. When working with abatement, remember the following: 

• An abatement line cannot be deleted from, insert to, or modified for a charge that is terminated.
• When editing or deleting an abatement line, the Billing Details Lines are automatically updated after you select the next line.

Invoices

Abatement amounts appear in invoices as follows: 

• For lines that use the Separate Invoice option, the abatement appears on the same invoice as the item.
• The abatement line appears as a separate for all sales orders, free text invoices, vendor invoices, and invoice journals.

Add an Abatement Discount to a Charge

To add an abatement discount to a charge, follow these steps: 

1. Select Abatements > New Line.
2. Select the Lease Liability Account.
3. Select the Option for applying the abatement discount.
4. Specify the abatement start and end dates.
   1. For a lump-sum abatement, only the start date can be specified because the amount is applied for the billing period that includes the start date.
   2. For a recurring abatement, both the start and end dates can be specified.
5. Specify the Abatement Amount.
6. Repeat these steps to add more abatement discount lines.

If multiple abatement lines exist, the recurring abatement amounts are applied before the lump sum abatement amounts: Net amount = (Amount - recurring abatement) - lump sum abatement

Abatements Lines

Each line has the following columns: 

Abatements Lines Table

Field	Description
Lease Liability Account	Select the lease liability account. Required.
Option	Select how the abatement discount is applied: Lump Sum or Recurring.
Start Date	Specify the start date for the abatement discount. Required. The default date is the term date. For a recurring lease, this date must be the same or earlier than the end date.
End Date	Displays the end date of the abatement discount. Read-only. The end date is required for a recurring abatement discount.
Abatement Amount	Specify a non-zero abatement discount amount to be applied to the charge. For a lump sum abatement, the discount is applied on the start date and is applied until the lump sum runs out. f abatement is greater than billing amount, then the remaining abatement amount is applied to the next billing line amount. For a recurring abatement, the ongoing fixed discount amount is applied between the start and end date.
Remaining Amount	Displays the remaining amount of the lump sum abatement discount. Read-only. For a recurring abatement, this amount is the same as the abatement amount.