Billing Lines Tab

Modules > Property lease management > Leases > All Leases > [select a lease] > [select charge line] > Billing lines button > Billing lines tab

Use this page to specify details for the billing lines of a charge, such as escalation and abatement. You can also review the billing lines for the periods.

The Billing lines page has two main tabs, Billing and Lease accounting standard (ASC 842/IFRS 16) which you can select. The FastTabs and fields that are visible depend on which main tab you select. For example, the Amortization schedule FastTab is only available when the Lease accounting standard is selected. In this topic, you can find information about the Billing Tab.

See Lease Accounting Standard Tab for information about the Lease accounting standard tab.

Default Date Values

The default dates that are applied to the charge details are based on the dates of the lowest level (e.g., unit) or the lease terms. Remember, you can change these dates as needed, but the default values serve as the basis from which you can work. The following scenarios provide more information.

• Scenario 1

If start and end dates for the lowest level are provided, the charge lines use the start and end dates from the lowest level. In this scenario, it doesn't matter if lease terms exist or not.

• Scenario 2

If only the start date for the lowest level is provided, and the start and end dates for the lease term are provided, the charge lines use the start and end dates from the lease term.

• Scenario 3

If only the start date for the lowest level is provided, and no lease terms are attached to the lease, the charge lines use the start date of the lowest level, and the end date is determined by the billing frequency (e.g., monthly) of the lease.

Escalation (Billing tab)

Use this FastTab to specify the details for escalating a charge. The escalation lines are automatically created based on the start and end dates of a term for the selected charge. This FastTab is not available for meter (or consumption) charges.

The escalation term dates cannot overlap. However, a date gap can occur between term dates. For example, one line has a term start date of January 1 and an end date January 15. The following term start date cannot be on or before January 15. However, it can gave a term start date on January 16 or later. When a gap occurs between escalation terms, the settings of the previous term are used until the next term begins.

Example: Escalation date within term dates

In this example, the two terms have escalations where the date is within the specified term dates: 

Term line	Term start date	Term end date	Escalation date	Escalation Amount
1	January 01, 2018	December 31, 2018	December 31, 2018	100
2	January 01, 2019	December 31, 2019	August 01, 2019	200

In the first term, the escalation starts on the last date of the term (31 December 2018). In the second term, the escalation starts on 01 August 2019.

Example: Escalation date of second term earlier than second start term date

In this example, the escalation date of the second term is in the first term: 

Term line	Term start date	Term end date	Escalation date	Escalation Amount
1	January 01, 2018	December 31, 2018	December 31, 2018	100
2	January 01, 2019	December 31, 2019	August 01, 2018	200

In the first term, the escalation starts on the last date of the term (31 December 2018). For the second term, the escalation starts on 01 January 2019. Since the start of the second term is later than the escalation date, the escalation cannot start until the term has started.

Example: Rate schedules and escalations

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.

For example, the following rate schedule is created:

Rate Escalation Table

Rate schedule:	Rate1
Description:	Rate schedule 1
Cost driver:	None
Effective date	Frequency	Rate
March 01, 2020	Monthly	50.00

The escalation line for a charge is as follows is as follows: 

Rate Escalation Details Table

Escalation date	Term start date	Term end date	Billing frequency	Type	Rate schedule
March 01, 2020	March 01, 2020	April 15, 2020	Weekly	Lesser of	Rate1

When the rate schedule is applied to the charge, the rate amount is applied on a weekly basis (i.e., four weeks in a month). As a result the escalation is calculated as follows: 

• Monthly rate/Weekly frequency = 50/4 = 12.50.

A weekly escalation of 12.50 is applied to the lease.

Add an escalation charge

To add an escalation to a charge, follow these steps: 

1. Select New.
2. Specify the escalation and term start dates and the term end date. The term end date must be later than the term start date.
3. Select the Escalation frequency and Type of escalation.
4. Specify the escalation to use, Percent, Amount, CPI schedule, and Rate Schedule.
   You can specify one or more of these escalation methods.
5. Repeat these steps to add more escalation lines.

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

Fields

The following field boxes are available: 

Escalation FastTab fields

Field	Description
Escalation date	Specify the price adjustment (or escalation) start date. The default date for the first line is the term start date as specified on the Lease Details 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 outside the term start and end date range, no escalation occurs for the line.
Term start/end date	Displays the start and end dates for the term that is selected term on the Lease Details window. The term end date can be changed as needed.
Escalation frequency	Select a default billing frequency for lease charges. The options are: Monthly, Weekly, Quarterly, Annually, and One Time. If you change this value, the frequency must be a longer frequency period than the billing frequency of the lease. For example, if the billing frequency of a lease is Monthly, the frequency can be changed to Quarterly or Annually.
Type	Select an increase option on which to base escalations: Greater Of: Of the escalation methods entered, uses the method that has the largest value for the escalation. Lesser Of: Of the escalation methods entered, uses the method that has the smallest value for the escalation.
Percent	Specify a percent value to be used as the escalation.
Amount	Specify a flat amount for the escalation.
CPI schedule	Select a CPI schedule to attach to the escalation. If the CPI schedule you want does not exist, select CPI schedules to open the CPI Schedule page to create a CPI schedule.
Rate schedule	Select a rate schedule to attach to the escalation. If the rate schedule you want does not exist, select Rate schedules to open the Rate Schedules page to create a rate schedule.

Buttons

This following buttons are available: 

Escalation FastTab buttons

Field	Description
Rate schedules	Opens the Rate Schedules page where you can create a rate schedule or edit the rate schedule for the selected line.
CPI schedules	Opens the CPI Schedule page where you can create a CPI schedule or edit the CPI schedule for the selected line.

Back to top ▲

Abatement (Billing tab)

Use this FastTab to specify the details for abatement discount for a charge. 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 escalation 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.

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 New.
2. Select the Abatement account and select the Option for applying the abatement discount.
3. Specify the abatement Start date, and for a recurring abatement, specify the End date.
4. Specify the Abatement amount.
5. Repeat these steps to add more abatement discount lines.
6. Select Process to review the abatement discount in the Billing Lines (Billing tab) FastTab.

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

Fields

The following field boxes are available: 

Abatement FastTab fields

Field	Description
Abatement account	Select the account to use for abatement discounts.
Option	Select how the abatement discount is applied: Lump sum or Recurring.
Start date	Specify the start date for the abatement discount. The default date is the term date.
End date	Displays the end date of the abatement discount. The end date is required for a recurring abatement discount.
Abatement amount	Specify the abatement discount amount to be applied to the charge.
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.

Back to top ▲

Billing Lines (Billing tab)

This FastTab shows the billing lines for each period for the charge. Selecting Process updates all billing lines with the changes to the escalation or abatement. Also, the billing lines are updated when the frequency of the charge on the Lease Details is changed.

Remove a meter charge

The Remove button is available for meter charges only. To remove lines for a regular charge, edit the lines in the Escalation (Billing tab).

To remove a meter charge, follow these steps:

1. To be able to see billing lines for a meter charge, process the lines using the Mass Meter Reading Entry or Meter Readings pages.
2. In the list select any line that you do not want to process, and select Remove.

Fields

The following field boxes are available: 

Billing lines FastTab fields

Field	Description
General
Start/End date	Displays the start and end dates of the billing period for the charge.
Amount	Displays the total amount after the escalation is applied.
Abatement amount	Displays the abatement amount. This amount must be less than or equal to the Amount.
Net amount	Displays the net amount to appear on the invoice. The net amount is calculated as follows: Amount - Abatement amount. If the calculated net amount is less than zero, this value appears as 0.00 .
Projected invoice date	Displays the projected invoice date of the charge line based on the values you set up in your Billing class in your Charge Details.
Billed	Indicates whether the invoice for the period has been created on the Invoice Creator. Selected: The invoice has been created and sent to the customer. Cleared: The invoice has not been created.
Free text	Displays the free text invoice number for the charge. This value is updated if the invoice has been created for the charge. Select the invoice number to view the details. If the sales document was created in error, it can be deleted. However, the billing line becomes unbilled, and must be billed again.
Invoice	Displays the invoice number for the charge. This value is updated if the invoice has been created for the charge. Select the invoice number to view the details. If the invoice was created in error, it cannot be deleted.
Due date	Displays the date on which the invoice is due.
Invoice line amount	Displays the invoice line amount for the charge, which is calculated as the charge amount minus abatement.
Settled currency	Displays the payment amount applied to the invoice line amount.
Remaining amount	Displays the remaining invoice line amount, which is calculated as follows: invoice line amount - settled currency.
Settlement status	Displays whether payment has been made to the invoice:  Yes: Full payment has been to the invoice line amount. Partially paid: A partial payment has been made to the invoice line amount. No: No payment has been made to the invoice line amount.
Fee note	Displays the fee note number and can be selected. When you select the fee note, the Fee note form opens.
Fee amount	Displays the fee amount number.
Fee adjustment	Displays the status of the fee note attached to a specific billing line: None: The fee note has either not changed, not been applied, or has been reinstated. Waived: The fee note is waived and is not due.
Settlements
Displays the settlement information for the line that is selected on the General tab.
Offset voucher	Displays the voucher number for the settlement transaction.
Date of settlement	Displays the date on which payment was received.
Description	Displays the description of the line.
Settled currency	Displays the invoice line amount or the abatement amount. Charge amounts are aligned to the left in the column. Abatement amounts are aligned to the right in the column.
Amount settled	Displays the amount paid that is applied to the invoice amount.
Offset currency	Displays the currency type in which the payment is made.
Exchange rate adjustment	If the payment for the invoice line is not in the same currency as the invoice, displays the exchange rate used for the payment.
Created by	Displays the ID of the user who processed the settlement.
Company accounts	Displays the account used for the settlement.
Invoice
Invoice	Displays invoice number for billing line.
Invoice account	Displays the account for which invoice is created.
Date	Displays the date when invoice is created.
Voucher	Displays the voucher for the invoice.
Currency	Displays currency used by the sales order / free text invoice.
Sales subtotal amount	Displays subtotal of invoiced amount.
Invoice amount	Displays invoice amount for billing line.
Audit
Sales Order/Free text	Displays original sales order and credit applied against the billing line.
Status	Displays status for the billing line e.g. "rebill"
Date	Displays transaction date for sales orders / free text created

Buttons

This following buttons are available: 

Billing FastTab fields

Button	Description
Remove	Available for meter charges only. Removes the selected line. This action can be useful to correct errors before creating the invoice. If you select to remove the last line in the list, only the one line is removed. If you select to remove a line at the top or middle of the list, all lines after the line you selected are removed. The reason for removing all subsequent lines is because those lines are dependent on the selected line. It is expected that the subsequent lines are added in sequential order. After removing lines for a meter charge, you can make any corrections on the Mass Meter Reading Entry or Meter Readings page. When you review the lines, the Processed check box is cleared for all lines that appeared in this billing lines list.
Fee note	Changes the status of a fee note. To change the status of a fee note, the fee note must be posted. Waive: Waive the fee note for a specific billing period. Reinstate: Reinstate the fee note for a specific billing period. Reverse: Reverse the fee note for a specific billing period.
Fee history	Opens the Fee Note Adjustment History page where you can see the history of adjustments of a specific fee note.

Back to top ▲