Skip to main content

Mixed Frequency Leases

There are times when a lease payment structure does not have consistent payment periods, and therefore the timing of payments and the overall payment structure of a lease does not have a single frequency. In these scenarios of mixed frequency, there are specific steps to follow to enter the lease into LeaseAccelerator.

For most of the scenarios in this guide there are two methods to enter lease data into LeaseAccelerator.

Download a PDF version of the guide.

User Interface (UI)

One method is using the user interface (UI). It is important to remember that when you enter a lease through the user interface, the process isn’t complete until you book and classify the deal manually.

Bulk Import

The second method of lease entry is using a Portfolio Intake Workbook (PIW). When a lease is imported in this manner, it will be booked and classified automatically in most situations, if indicated in the Bulk Import workspace. Please note that while you cannot import a lease with a PIW that has one frequency for the original term and a different frequency for the renewal option listed on the EOT Options tab, there are workarounds for such situations, as outlined below.

Step Payment Leases with Mixed Frequencies

There may be several different scenarios where the payment schedule of a lease is inconsistent and is not paid at the same frequency during the life of the lease. For these scenarios, the Payment Calculator may be used to enter the accurate payment schedule. Please see below for different scenarios and the steps to take to enter these leases in LeaseAccelerator.

Scenario: Lease has one payment for the first year, due in the first month, and the remaining payments are monthly, starting in year two.

Step

Action: Enter using mixed frequency step payments in the UI

1

Click Enter Schedule from the Left NavBar.

2

Enter the appropriate Participants on the Participants tile, ensuring you populate all required fields.

3

On the Details tile, enter the lease details, including the assets on the lease.

4

On the Terms tile, enter appropriate Payment Based On, Lease Type and leave the Payment Frequency at Monthly. Input the appropriate lease term in months in the # of Monthly Payments field.

5

Click the Payment Calculator button to bring up the Step Payment Calculator.

6

In the first frequency drop-down, indicate the appropriate frequency for the first payment then tab to next field.

  • In this example, pick Annual.

7

Enter the payment amount of the first payment and tab to next field.

8

Enter the number of payments at this payment amount and tab to next field.

  • In this example, enter 1 for number of payments.

9

When you tab into the ending month field, the system will auto-populate. Tab out of this field and the system will automatically create another line for the next step and you can tab three times or click on the frequency drop-down for the second line.

10

Select the appropriate frequency for the next payment and tab to next field.

  • In this example, select Monthly.

11

Enter the payment amount for the second step and tab to next field.

12

Enter the number of payments at this payment amount and tab to next field.

  • In this example, keep the 24 that is auto-populated.

13

When all payments have been entered, click the Submit button.

14

You should see your mixed frequency step payment schedule on the Terms tile.

15

Finish populating the necessary fields on the Terms tile, including the addition of your EOT Options.

16

When you have finished entering all details for the lease, click Save.

17

On the Next Steps tile of Deal History, click Book Deal.

18

In the Book Deal workspace, change the Commencement Date to reflect the Lease Start Date.

19

Verify the correct Ledger Date. This drop-down is driven by your Commencement Date and open periods.

20

Choose the appropriate ledgers to book the new deal to.

21

Verify the correct option is selected for Expected Disposition, change as necessary.

22

Verify the correct Expected Holding Period is entered, change as necessary.

23

Click the Book button.

24

You will be taken to Deal Summary. Once the booking is complete, you should click Deal Summary on the Left NavBar again to refresh/reload the page.

25

Scroll to the bottom of the Deal Summary, Summary tile and click the Generate Classification button.

26

You will be taken to the Accounting Classification workspace. It is best practice to check the boxes for all of the standards and classify the lease according to all four standards.

27

In the Reclassify Effective drop-down, select the Commencement Date and click the Refresh Classification button.

28

Verify all information is correct. You may expand the Analysis by Category and Deal Characteristics sections for more information.

29

Click Save Account Classification.

30

You may now go back to Deal Summary and the Summary tile to see that your deal has been booked and is classified. If you scroll down, you will see the payment structure, indicating the mixed frequencies of your payments. Please note that all payment schedules in the UI reflect monthly installments. If you have a non-monthly lease, you will see 0.00 as a payment amount for months not requiring a payment.

Example of mixed frequency Step Payment Calculator

Graphical user interface, text, application, email

Description automatically generated

Example of mixed frequency Terms tile

Graphical user interface, text, application

Description automatically generated

Example of mixed frequency payment schedule

Using a PIW and Bulk Import

Step

Action: Enter using PIW

1

Download the most recent version of the Portfolio Intake Workbook (PIW), available in Ask Alex and the Success Center.

Note: This is the standard PIW template, and does not include any user-defined participants or Product sub-categories. If you have those, you’ll need to update the current version to include those. If you need assistance, please reach out to your Implementation Team or your Client Success Manager.

2

Populate the PIW with all lease details, as per the lease agreement.

3

On the Schedule tab, select Monthly from the Frequency drop-down. Regardless of the mixed payment frequencies, this field on the Schedule tab must ALWAYS be Monthly.

4

Enter the appropriate Duration in months.

5

Enter the appropriate Reasonably Certain Holding Period in months. If your RCHP is the same as your Duration, best practice is to populate the field. Do not leave blank.

6

On the Step Payments tab, populate each field according to the actual payment structure, ensuring to indicate the correct number of payments according to the frequency indicated in the Payment Frequency column. See below for an example:


In this example, the lease has a duration of three years where the first year has one payment due in the first month. The remaining payments are monthly and start in year two.

As you can see the number of payments does reflect the actual number of payments made by the Lessee, but does not match the Duration indicated on the Schedule tab.

7

Complete the rest of the PIW, as necessary.

8

Log in to LeaseAccelerator and from the Left NavBar, go to the Bulk Import workspace.

9

On the Portfolio tile, click Select File and choose your saved PIW.

10

Click Validate.

11

Address any Validation errors or warnings, remembering that red errors prevent import, but yellow warnings do not.

12

Once all validation messages have been addressed, ensure the boxes are checked next to the leases you want to import and click Import.

13

When the import is complete, you should see your leases listed with a green dot next to them. If you click on the blue Schedule Number, you’ll be taken to the Deal History of that lease. From here you can go to Deal Summary and view the payment schedule to verify it was entered correctly.

Scenario: Lease starts with a payment in the first month, then has quarterly payments starting in month three, and ending with a payment in the last month of the term, all payable in advance.

There are two ways to enter this lease into LeaseAccelerator: Through the user interface (UI) or using a Portfolio Intake Workbook (PIW). See below for steps for each method:

Step

Action: Enter using mixed frequency step payments in the UI

1

Go to Enter Schedule from the Left NavBar.

2

Enter the appropriate Participants on the Participants tile, ensuring you populate all required fields.

3

On the Details tile, enter the lease details, including the assets on the lease.

4

On the Terms tile, enter appropriate Payment Based On, Lease Type and leave the Payment Frequency at Monthly. Input the appropriate lease term in months in the # of Monthly Payments field.

5

Click the Payment Calculator button to bring up the Step Payment Calculator.

6

In the first frequency drop-down, indicate the appropriate frequency for the first payment then tab to next field.

  • In this example, pick Monthly.

7

Enter the payment amount of the first payment and tab to next field.

8

Enter the number of payments at this payment amount and tab to next field.

  • In this example, pick 1.

9

When you tab into the ending month field, the system will auto-populate. Tab out of this field and the system will automatically create another line for the next step, and you can tab three times or click on the frequency drop-down for the second line.

10

Select the appropriate frequency for the next payment and tab to next field.

  • In this example, select Monthly.

11

Enter the payment amount for the second step and tab to next field.

  • In this example, the second month doesn’t have a payment, so enter 0.00.

12

Enter the number of payments at this payment amount and tab to next field.

  • Since there is only one month of no payments, enter 1.

13

When you tab into the ending month field, the system will auto-populate. Tab out of this field and the system will automatically create another line for the next step and you can tab three times or click on the frequency drop-down for the third line.

14

Repeat steps 10-13 as necessary for as many steps as you have, ensuring that you are indicating the right frequency for the payments at the specified amount. See screenshot below for exact schedule for this example.

15

When all payments have been entered, click Submit.

16

You should see your mixed frequency step payment schedule on the Terms tile.

17

Finish populating the necessary fields on the Terms tile, including the addition of your EOT Options.

18

When you have finished entering all details for the lease, click Save.

19

On the Next Steps tile in Deal History, click Book Deal.

20

In the Book Deal workspace, change the Commencement Date to reflect the Lease Start Date.

21

Verify the correct Ledger Date. This drop-down is driven by your Commencement Date and open periods.

22

Choose the appropriate ledgers to book the new deal to.

23

Verify the correct option is selected for Expected Disposition, change as necessary.

24

Verify the correct Expected Holding Period is entered, change as necessary.

25

Click Book.

26

You will be taken to Deal Summary. Once the booking is complete, you should click Deal Summary on the Left NavBar again to refresh/reload the page.

27

Scroll to the bottom of the Deal Summary, Summary tile and click Generate Classification.

28

You will be taken to the Accounting Classification workspace. It is best practice to check the boxes for all of the standards and classify the lease according to all four standards.

29

In the Reclassify Effective drop-down, select the Commencement Date and click Refresh Classification.

30

Verify all information is correct. You may expand the Analysis by Category and Deal Characteristics sections for more information.

31

Click Save Account Classification.

32

You may now go back to Deal Summary and the Summary tile to see that your deal has been booked and is classified. If you scroll down, you will see the payment structure, indicating the mixed frequencies of your payments.

Note: ALL payment schedules in the UI reflect monthly installments. If you have a non-monthly lease, you will see 0.00 as a payment amount for months not requiring a payment.

Example of mixed frequency Step Payment Calculator

Table

Description automatically generated

Example of mixed frequency Terms tile

Graphical user interface, text, application

Description automatically generated

Example of mixed frequency payment schedule

Using a PIW and Bulk Import

Step

Action: Enter using PIW

1

Download the most recent version of the Portfolio Intake Workbook (PIW), available in Ask Alex and the Success Center.

Note: This is the standard PIW template, and does not include any user-defined participants or Product sub-categories. If you have those, you’ll need to update the current version to include those. If you need assistance, please reach out to your Implementation Team or your Client Success Manager.

2

Populate the PIW with all lease details, as per the lease agreement.

3

On the Schedule tab, select Monthly from the Frequency drop-down. Regardless of the mixed payment frequencies, this field on the Schedule tab must ALWAYS be Monthly.

4

Enter the appropriate Duration in months.

5

Enter the appropriate Reasonably Certain Holding Period in months. If your RCHP is the same as your

Duration, best practice is to populate the field. Do not leave blank.

6

On the Step Payments tab, populate each field according to the actual payment structure, ensuring to indicate the correct number of payments according to the frequency indicated in the Payment Frequency column. See below for an example:

In this example, the lease has a duration of six years but includes an unusual payment structure where there is a partial quarter at the beginning of the lease and a partial quarter at the end of lease. As a result, this lease cannot be entered as straight quarterly payments. Instead, the first payment is Monthly and covers the first two months of the term. The second monthly payment is 0.00 as there isn’t a payment due. The true quarterly payments start in the third month and continue for most of the rest of the duration of the term, ending with a final payment in the last month.

7

Complete the rest of the PIW, as necessary.

8

Log in to LeaseAccelerator and from the Left NavBar, go to the Bulk Import workspace.

9

On the Portfolio tile, click Select File and choose your saved PIW.

10

Click Validate.

11

Address any Validation errors or warnings, remembering that red errors prevent import, but yellow warnings do not.

12

Once all validation messages have been addressed, ensure the boxes are checked next to the leases you want to import and click Import.

13

When the import is complete, you should see your leases listed with a green dot next to them. If you click on the blue Schedule Number, you’ll be taken to the Deal History of that lease. From here you can go to Deal Summary and view the payment schedule to verify it was entered correctly.

Step Payment Leases with Mixed Frequency Renewal Options


Scenario: Lease has a mixed frequency renewal option that is not reasonably certain.

There are two ways to enter this lease into LeaseAccelerator: Through the user interface (UI) or using a Portfolio Intake Workbook (PIW). See below for steps for each method:

Step

Action: Enter through the UI using multiple renewal options

1

Go to Enter Schedule from the Left NavBar.

2

Enter the appropriate Participants on the Participants tile, ensuring you populate all required fields.

3

On the Details tile, enter the lease details, including the assets on the lease.

4

On the Terms tile, enter appropriate payment information. If this lease has step payments, please see previous example.

5

To enter your end of term options, click Mid-Term/End-of-Term Options.

6

In the pop-up, click the plus sign to add a new option.

7

Select End of Term from the Type drop-down.

8

Select Renewal from the next drop-down.

9

Populate the At Month field. Typically, this is the month after the initial term.

  • For example, a 36-month lease would have a renewal at month 37.

10

Indicate any notice period (in days). The ‘at least’ field is required, even if populated with 0. Leaving this field blank will designate the renewal as automatic.

11

Provide the terms for the renewal including the renewal term in months, even if the renewal frequency is quarterly.

12

Since this renewal is not reasonably certain, we do not need to enter a payment amount. When the renewal is executed, the payment amount may be entered.

13

Once all options have been entered, click Submit.

14

Finish populating all necessary fields on all tiles for the lease.

15

Once all data is captured, click Save.

16

In Deal History, on the Next Steps tile, click Book Deal.

17

In the Book Deal workspace, change the Commencement Date to reflect the Lease Start Date.

18

Verify the correct Ledger Date. This drop-down is driven by your Commencement Date and open periods.

19

Choose the appropriate ledgers to book the new deal to.

20

Verify the correct option is selected for Expected Disposition, change as necessary.

21

Verify the correct Expected Holding Period is entered, change as necessary.

22

Click Book.

23

You will be taken to Deal Summary. Once the booking is complete, you should click Deal Summary on the Left NavBar again to refresh/reload the page.

24

Scroll to the bottom of the Deal Summary, Summary tile and click Generate Classification.

25

You will be taken to the Accounting Classification workspace. It is best practice to check the boxes for all of the standards and classify the lease according to all four standards.

26

In the Reclassify Effective drop-down, select the Commencement Date and click Refresh Classification.

27

Verify all information is correct. You may expand the Analysis by Category and Deal Characteristics sections for more information.

28

Click Save Account Classification.

29

If you go back to Deal Summary and the Summary tile, you’ll see your classified deal with the appropriate end of term options. See below for instructions on how to execute the renewal options.


Example of EOT Options entered in UI

Using a PIW and Bulk Import

Step

Action: Enter using PIW

1

Download the most recent version of the Portfolio Intake Workbook (PIW), available in Ask Alex and the Success Center.

Note: This is the standard PIW template, and does not include any user-defined participants or Product sub-categories. If you have those, you’ll need to update the current version to include those. If you need assistance, please reach out to your Implementation Team or your Client Success Manager.

2

Populate the PIW with all lease details as per the lease agreement. If the lease has step payments that are mixed frequency, please see previous examples for steps on populating the payment information for the lease.

3

On the EOT Options tab, enter a line for a renewal option. Timing should be EOT, Option Type is Renewal, Reasonably Certain EOT Option should be No. As with any renewal, the Effective Month should be the duration in months plus 1.


Example: For a 72-month lease, the Renewal option would be effective month is 73.

The first renewal option will cover the first two monthly payments and also the last monthly payment, while the second renewal option will cover the quarterly payments. The term is always indicated in months. We are not indicating a payment amount since this renewal isn’t reasonably certain and the amount can be indicated when executing the renewal.

4

Complete the rest of the PIW as necessary.

5

Log in to LeaseAccelerator and from the Left NavBar, go to the Bulk Import workspace.

6

On the Portfolio tile, click Select File and choose your saved PIW.

7

Click Validate.

8

Address any Validation errors or warnings, remembering that red errors prevent import but yellow warnings do not.

9

Once all validation messages have been addressed, ensure the boxes are checked next to the leases you want to import and click Import.

10

When the import is complete, you should see your leases listed with a green dot next to them. If you click on the blue Schedule Number, you’ll be taken to the Deal History of that lease. From here you can go to Deal Summary and view the end of term options.

Scenario: Lease has a mixed frequency renewal option that is reasonably certain. A lease has a renewal term that includes the first renewal payment of $20,000 followed by quarterly payments starting in month 3 of $30,000 and ends with a single monthly payment of $10,000.

In order to ensure accurate accounting for the reasonably certain renewal period, a user must enter this renewal option with monthly step payment structures, including months with zero rent. See below for steps and an example for entering lease with renewal options in the user interface as well as with a PIW:

Step

Action: Enter through the UI using multiple renewal options

1

Go to Enter Schedule from the Left NavBar.

2

Enter the appropriate Participants on the Participants tile, ensuring you populate all required fields.

3

On the Details tile, enter the lease details, including the assets on the lease.

4

On the Terms tile, enter appropriate payment information. If this lease has step payments, please see previous example.

5

To enter your end of term options, click Mid-Term/End-of-Term Options.

6

In the pop-up, click the plus sign to add a new option.

7

Select End of Term from the Type drop-down.

8

Select Renewal from the next drop-down.

9

Populate the At Month field. Typically, this is the month after the initial term.

  • For example, a 36-month lease would have a renewal at Month 37.

10

Indicate any notice period (in days). The ‘at least’ field is required, even if populated with 0. Leaving this field blank will designate the renewal as automatic.

11

Provide the terms for the renewal including the renewal term in months.

  • In this example, the first renewal period would be 1 month, so enter 1.

12

Enter the first payment amount.

  • In this example, enter $20,000.

13

Since this is a reasonably certain renewal, check the box ‘These terms constitute a Clear Economic Incentive and are Reasonably Certain to be exercised.’

14

Enter any relevant comments for this renewal. Best practice is to stipulate which step of the entire

renewal this option represents.

  • In this example: First payment of 12-month renewal.

15

Click Add.

16

Repeat steps 6-15 for the remaining steps, including any months that have 0.00 payment. For example, if month 2 of the renewal does not have a payment, you would enter 38 for the At Month and 1 for the term. The payment amount would be 0.00. Next you would enter the third step in the renewal, effective At Month 39 with 1 for the term. The payment in this example would be $30,000. Then you would enter the fourth step of the renewal At Month 40 with a term of 2 since you will have two months with 0.00 payment. Continue this pattern to account for the entire 12-month renewal term. All renewal options should be marked as Reasonably Certain.

17

Enter any other non-reasonably certain options available per the lease agreement, and then click Submit.

18

Finish populating all necessary fields on all tiles for the lease.

19

Once all details have been entered, click Save.

20

In Deal History, on the Next Steps tile, click Book Deal.

21

In the Book Deal workspace, change the Commencement Date to reflect the Lease Start Date.

22

Verify the correct Ledger Date. This drop-down is driven by the Commencement Date and open periods.

23

Choose the appropriate ledgers to book the new deal to.

24

Verify the correct option is selected for Expected Disposition, change as necessary.

25

Verify the correct Expected Holding Period is entered, change as necessary. This should include the entire renewal period of all the reasonably certain renewal option steps.

26

Click Book.

27

You will be taken to Deal Summary. Once the booking is complete, you should click Deal Summary on the Left NavBar again to refresh/reload the page.

28

Scroll to the bottom of the Deal Summary, Summary tile and click Generate Classification.

29

You will be taken to the Accounting Classification workspace. It is best practice to check the boxes for all of the standards and classify the lease according to all four standards.

30

In the Reclassify Effective drop-down, select the Commencement Date and click Refresh Classification.

31

Verify all information is correct. You may expand the Analysis by Category and Deal Characteristics sections for more information.

32

Click Save Account Classification.

33

If you go back to Deal Summary and the Summary tile, you’ll see your classified deal with the appropriate end of term options. See below for instructions on how to execute the renewal options.

Example of EOT Options entered in UI

Using a PIW and Bulk Import

Step

Action: Enter using PIW

1

Download the most recent version of the Portfolio Intake Workbook (PIW), available in Ask Alex and the Success Center.

Note: This is the standard PIW template, and does not include any user-defined participants or Product sub-categories. If you have those, you’ll need to update the current version to include those. If you need assistance, please reach out to your Implementation Team or your Client Success Manager.

2

Populate the PIW with all lease details as per the lease agreement. If the lease has step payments that are mixed frequency, please see previous examples for steps on populating the payment information for the lease.

3

On the EOT Options tab, enter a line for a renewal option. Timing should be EOT, Option Type is Renewal, Reasonably Certain EOT Option should be Yes. As with any renewal, the Effective Month should be the duration in months plus 1.

Example: For a 36-month lease, the Renewal option would be effective month is 37. See below, using the same lease with a 12-month mixed frequency renewal option that is Reasonably Certain.

See below for the steps on how to execute this renewal using a Bulk Record Asset Event Template.

4

Complete the rest of the PIW as necessary.

5

Log in to LeaseAccelerator and from the Left NavBar, go to the Bulk Import workspace.

6

On the Portfolio tile, click Select File and choose your saved PIW.

7

Click Validate.

8

Address any Validation errors or warnings, remembering that red errors prevent import, but yellow warnings do not.

9

Once all validation messages have been addressed, ensure the boxes are checked next to the leases you want to import and click Import.

10

When the import is complete, you should see your leases listed with a green dot next to them. If you click on the Schedule Number, you will be taken to the Deal History of that lease. From here you can go to Deal Summary and view the end of term options. The payment schedule on the Summary tile will indicate monthly payments for the renewal but once you exercise the renewal option, that payment schedule will update correctly.

Recording Asset Events

Scenario: Lease has renewal with a different payment frequency than the original payment frequency. A lease is paid quarterly during the original term but renews at a monthly payment frequency.

Renewals may be recorded two ways within LeaseAccelerator, using the Record Asset Event bulk import or through the user interface.

Step

Action: Exercise using Bulk Import

1

Download the most recent version of the Bulk Record Asset Event Import Template, available in Ask Alex and the Success Center.

2

Populate the Advanced tab of the import file. Start by entering the Schedule Number.

3

Next, enter the Asset ID. If you have multiple assets on a schedule, you must enter one line per asset.

Note: To obtain the Asset ID you can look in Asset Management in the UI or you can generate a BU Asset Report and scroll over to the Asset ID field.

4

In the EOT Event field, choose Renewal from the drop-down.

5

It is best practice to leave the Ledger Date fields blank, as LeaseAccelerator will use the first open period. Enter the appropriate Effective Date [Month,Day,Year].

6

Next indicate the renewal term in months, even if the renewal frequency is non-monthly.

7

Indicate the appropriate Renewal Frequency.

8

In the Renewal Payment field, input appropriate payment amount.

  • If any/all rows in the import file on the Advanced Form tab are the same, other than the Asset ID, Description, and Serial Number fields, then a single payment amount is applied to cover all the assets, and appears as one Event in the Deal Summary.

  • If any/all rows in the import file on the Advanced Form tab are different, not including the Asset ID, Description, and Serial Number fields, then the payment amount specified is applied to each individual asset.

  • If some rows in the import file on the Advanced Form tab are the same and some are different, not including the Asset ID, Description, and Serial Number fields, then the payment amount specified is applied to each group of assets with the same values.

9

Complete the rest of the import file as necessary.

10

Log in to LeaseAccelerator and from the Left NavBar, go to the Bulk Import workspace.

11

On the Record Asset Event tile, click Select File and choose your saved import file.

12

Click Validate.

13

Address any Validation errors or warnings, remembering that red errors prevent import but yellow warnings do not.

14

Once all validation messages have been addressed, ensure the boxes are checked next to the leases/options you want to import and exercise, then click Import.

15

When the import is complete, you should see your leases listed with a green dot next to them. You can go into your leases to Deal Summary, Summary tile and view the end of term events and updated payment schedule.

Example of mixed frequency payment schedule after renewal

Exercising the renewal options in the user interface:

Step

Action: Exercising within the UI

1

Search for deal using the Top Search Bar and Deal #.

2

Hover over Record Event in the Left NavBar. In the first menu layer, hover over Exercise lease extension/renewal and then hover over Record contractual renewal. Select the Renewal option and you’ll be taken to the Record Asset Event workspace.

3

By default, all assets are checked.

4

The first Renewal Option is pre-populated in the Asset Event drop-down. Ensure this is the first one in the series based on the Effective At Month.

5

Change First Day of Renewal to appropriate date. This should be the first day of the renewal period.

6

Change Ledger Date to appropriate fiscal period. If the renewal is backdated, the first open fiscal period should be used; for all other renewals, the current fiscal period should be used.

7

Change the Frequency from Quarterly to Monthly.

8

Ensure the payment is accurate, change as necessary.

7

Enter any relevant comments related to the renewal and click Save.

Scenario: Lease has renewal with mixed frequencies.

The original lease term may or may not have included mixed frequencies, but the renewal consists of one or more payments at one frequency followed by one or more payments at a different frequency. Lease renews for one year with one payment in the first month followed by second payment in the third month of the renewal and then payments are quarterly until the last month when a final payment is due.

When exercising a step payment renewal within the UI, a separate event will be recorded for each change in payment and/or frequency.

Step

Action: Exercising within the UI

1

Search for deal using the Top Search Bar and Deal #.

2

Hover over Record Event in the Left NavBar. In the first menu layer, hover over Exercise lease extension/renewal and then hover over Record contractual renewal. Select the Renewal option and you’ll be taken to the Record Asset Event workspace.

3

By default, all assets are checked.

4

The first Renewal Option is pre-populated in the Asset Event drop-down. Ensure this is the first one in the series based on the Effective At Month.

5

Change First Day of Renewal to appropriate date. This should be the first day of the renewal period.

6

Change Ledger Date to appropriate fiscal period. If the renewal is backdated, the first open fiscal period should be used; for all other renewals, the current fiscal period should be used.

7

Change the Frequency from Quarterly to Monthly.

8

Ensure the payment is accurate, change as necessary.

7

Enter any relevant comments related to the renewal and click Save.

8

You’ll repeat steps 4-7 for each step of the renewal, ensuring the same fiscal period is selected for Ledger Date and the First Day of Renewal corresponds to the renewal option timing.

For any scenario with a step payment renewal, due to varying payments or frequencies, separate Bulk Record Asset Event imports must be done for each step. See the steps and examples below.

Step

Action: Exercise using Bulk Import

1

Download the most recent version of the Bulk Record Asset Event Import Template, available in Ask Alex and the Success Center.

2

Populate the Advanced tab of the import file. Start by entering the Schedule Number.

3

Next, enter the Asset ID. If you have multiple assets on a schedule, you must enter one line per asset.

Note: To obtain the Asset ID you can look in Asset Management in the UI or you can generate a BU Asset Report and scroll over to the Asset ID field.

4

In the EOT Event field, choose Renewal from the drop-down.

5

Input the appropriate Ledger Date [Month, Day and Year]. This Ledger Date will be the same for ALL renewal steps you will be recording.

6

Now indicate the appropriate Effective Date [Month, Day and Year] for the first step of the renewal.

7

Next indicate the renewal term in months, even if the renewal frequency is non-monthly.

In this example, we have one payment the first month but no payment due in the second month, so our first renewal term will be 1 month.

8

Indicate the appropriate Renewal Frequency.

9

In the Renewal Payment field, input appropriate payment amount.

  • If any/all rows in the import file on the Advanced Form tab are the same, other than the Asset ID, Description, and Serial Number fields, then a single payment amount is applied to cover all the assets and appears as one Event in the Deal Summary.

  • If any/all rows in the import file on the Advanced Form tab are different, not including the Asset ID, Description, and Serial Number fields, then the payment amount specified is applied to each individual asset.

  • If some rows in the import file on the Advanced Form tab are the same and some are different, not including the Asset ID, Description, and Serial Number fields, then the payment amount specified is applied to each group of assets with the same values.

10


You will populate a single import file with a line for each step.

11

Log in to LeaseAccelerator and from the Left NavBar, go to the Bulk Import workspace.

12

On the Record Asset Event tile, click Select File and choose the renewal import file.

13

Click Validate.

14

Address any Validation errors or warnings, remembering that red errors prevent import but yellow warnings do not.

15

Once all validation messages have been addressed, ensure the boxes are checked next to the leases/options you want to import and exercise, then click Import.

16

When the import is complete, go into Deal Summary, Summary tile. From here you can view the EOT Events and the updated payment schedule.

Example of mixed frequency end of term events

Example of mixed frequency payment schedule after mixed frequency renewal

Was this article helpful?

We're sorry to hear that.