Overview
EZLease allows users to make bulk updates to any descriptive fields on a lease record (e.g. Asset class, user-defined fields, account numbers, etc.). Any changes that are made via bulk update, will be shown for the entire life of the lease (i.e. the full lease term).
Note: Financial information [like interest rates, economic life, cannot be updated in bulk.
Bulk updating your leases
| Step | Action |
| 1 |
Download the EZLease lessee bulk import template: Bulk Import Templates |
| 2 |
From within EZLease, run a listing report in spreadsheet output, for all leases |
| 3 |
Copy and paste your lease numbers from the listing report to the bulk import template (column A, starting on row 2) |
| 4 |
On the bulk template, type "Yes" in column B ("Change") |
| 5 |
Starting in column AF (Lease description), add the correct descriptive value(s) (you can copy and paste from the listing report, if some values aren't changing) Notes: You only need to enter values into fields that need to be updated. Blank fields will not overwrite current descriptive information. If you're updating a User-defined field that is set up as a list, you'll need to make sure there are no blanks, and all values that you enter must first be in your UDF list, in System Options) |
| 6 |
Upload your template to My Files |
| 7 |
Click File > Lease Upload > select your file |
| 8 | Click Load |
Bulk updating lease numbers
| Step | Action |
|
1 |
Download the EZLease lessee bulk import template: Bulk Import Templates |
| 2 | Enter the original lease number into column A ("Lease number") |
| 3 | Enter "Lease" in column B ("Change") |
| 4 | Add the new lease number in column AF ("Lease description") |
| 5 | Upload your template to My Files |
| 6 | Click File > Lease Upload > select your file |
| 7 | Click Load |
Related links:
Video: Bulk import | Bulk update templates | Adding leases | Revisions (Modifications)