Contents
- Index
Reports: Special Reports - Fleet 56 File
Purpose
Used to create a file (spreadsheet) of the status of active leases as of the end date provided for Fleet 56.
How To
To run this, set the locations and set the date range to the date through which you want balances calculated. Then, click the Fleet 56 File menu entry.
Only those ALMSys customers who are marked as active for Fleet 56 will be included. This is done on the Accounts - Account Overall screen.
The resulting spreadsheet will be placed into your Users folder, under a temporary file name. The spreadsheet will also be displayed. From there, you can "save as" the file to the desired location.
The contents of the spreadsheet are mostly self-explanatory. Columns which may not are as follows:
Other Tax: Any tax that is not marked as GST or PST.
Other: Any Monthly payment add-on amount that is not tax.
Next Due: The date (from the date range's end date) that the next payment is due. If there is a recurring payment set up, then this is from the Recurring screen. Otherwise, it is from the amortization schedule.
How Paid: For those recurring payments tied to a bank account or credit card, this is the chosen method of payment.
Prin. Balance: This is the amortization end balance as of the end date of the date range.
Amt. Owed: This is the outstanding payments owed that have been billed.
Unbilled: (Rare) This is the outstanding payments owed for those amortization lines that have not yet been billed, but were supposed to be billed before the end date provided.
Adjustments: Sum of all type "X" and "Z" principal payment adjustments.
Buyout B4 Tax: The sum of Prin. Balance, Amt. Owed, Unbilled, and Adjustments. The Amt. Owed and Unbilled columns include tax. If you need to apply tax for a buyout, you would tax the Prin. Balance plus the Adjustments columns.