Export a Lease Accounting Schedule into Excel - Common Procedure
If you follow the View Rent Schedule Values in a Different Currency procedures before following these procedures, your converted currency values will appear in your exported spreadsheet.
To export a lease accounting schedule to Excel:
-
Navigate to one of the following nine pages.
Use the links in the Navigation Pane on the leftmost side of the page.
-
Contract > Accounting Info > ASC 842 Rent Schedule
-
Contract > Accounting Info > IFRS 16 Rent Schedule
-
Contract > Accounting Info > GASB 87 Rent Schedule
-
Equipment Contract > Accounting Info > ASC 842 Rent Schedule
-
Equipment Contract > Accounting Info > ASC 842 Rent Schedule >ASC 842 Equipment Schedules Page
-
Equipment Contract > Accounting Info > GASB 87 Rent Schedule
-
Equipment Contract > Accounting Info > GASB 87 Rent Schedule >GASB 87 Equipment Schedules Page
-
Equipment Contract > Accounting Info > IFRS 16 Rent Schedule
-
Equipment Contract > Accounting Info > IFRS 16 Rent Schedule >IFRS 16 Equipment Schedules Page
-
-
Select the schedule you want to export from the Rent Schedule List.
The schedule data appears on the page.
-
Select one of three options:
Note:This selection will determine which view is displayed in your spreadsheet.
-
Calendar Year
-
Fiscal Year
-
Fiscal Details
-
-
Click Download into Excel
.
A download dialog box opens, asking whether you want to open or download the file.
-
Do one of the following:
-
Download the file.
-
Open the file in your spreadsheet editor.
-