Table of Contents

Top level directory of the LeasePak Reference Guide.

 

Reference Documents
Accruals Calculations Depreciation General Ledger Keys Status Codes Taxes Additional

• LeasePak 6.1a Release Notes
• LeasePak Release Notes Table of Contents: Previous LeasePak Versions

• Documentation Help
• Documentation Search

 

LeasePak Accrual

• Lease/Loan Accrual Methods
  • Precomputed Accrual Methods
    • Level Yield
    • Rule of 12/78ths
    • Rule of 12/78ths Half-Month Convention
    • Straight Line
  • Simple Accrual Methods
    • Precomputed Simple Interest
    • Floating Simple Interest
    • Interest Bearing Loans
  • Residual Methods
  • Operating Accrual Methods
    • Straight Line
    • Payments
    • Variable Rate

• Non-Lease Accruals
  • ITC Accrual
  • Notes Payable Accrual
    • Day Calculations
    • Interest Accrual
    • Principal and Interest (P&I)
    • Principal plus Interest (P+I)
    • Interest Only

 

LeasePak Calculations

• Late Charges

• Payoff Methods

• Initial Direct Costs/Revenues
• Net Present Value
• Internal Rate of Return
• Yield
• IRR with Residual
• IRR without Residual
• Check Digit

• Miscellaneous Calculations
  • Bad Debt
  • Net Investment
  • Unearned Income
  • Capitalized Cost
  • Monthly Rental Income
  • Monthly Rental Depreciation
  • Contract Rate
  • Starting Accrued Principal

 

Depreciation Methods

• LeasePak Depreciation Methods
  • Accelerated Cost Recovery System (ACRS)
  • ADR 150% Declining Balance
  • ADR 200% (Double) Declining Balance
  • ADR Straight Line
  • ADR Sum of the Years' Digits (SOYD)
  • Bypass
  • Declining Balance 125%
  • Declining Balance 150%
  • Declining Balance 175%
  • (Double) Declining Balance 200%
  • DVA1 and DVA2 (Australian)
  • Modified Accelerated Cost Recovery System (MACRS)
  • Straight Line
  • Straight Line Half Year Convention
  • Straight Line Mid-Month Convention
  • Sum of the Years' Digits (SOYD)

• Prorate Income, IDC, and Book Depreciation

 

General Ledger Accounting

• LeasePak Accounting
• Chart of Accounts
• Transaction Processing
• Reconciliation Procedures

 

LeasePak Key Structure

• LeasePak Key Structure
• Accounting Unit Hierarchy
• Client Relationships

 

LeasePak Status Codes

• LeasePak Status Codes
  • Lease Status Codes
  • Asset Status Codes
  • User Defined Statuses

 

Tax Considerations

• Tax Considerations
  • Investment Tax Credit (ITC)
  • Alternative Minimum Tax (AMT)
  • Adjusted Current Earnings (ACE)

 

Additional Reference Documents

• Documentation Suite Installation Guide
• LeasePak Utilities
• Maximum Array Sizes
• LeasePak Client Menu Structure (PDF format)
• LeasePak Module Listing

 

 

LeasePak Updates
U01 U02 U03 U04 U06 U07 U08 U09 U10 U11 U12 U13 U14 U16 U17

 

Daily Work [U01]

• New Lease [U0101]
  • Add Asset
  • Batch Applications
  • Book Lease
  • Delete Asset
  • Disburse Check
  • Quick Add Asset
  • Quick Book Lease
  • Remove Lease
  • Reverse Check

• Payments [U0102]
  • Batch Number Payment Reversal
  • Enhanced Payments
  • Payment Reversal
  • Payment/Principal Interest Waiver
  • Payments
  • Reverse Payment Reversal
  • Reverse Payments to Effective Date

• Payoff [U0103]
  • Partial Asset Payoff
  • Partial Asset Payoff Reversal
  • Payoff
  • Payoff Reversal
  • Sale of Asset in Inventory
  • Sale of Asset in Inv Reversal
  • Termination
  • Termination Reversal

• Payment Reschedule [U0104]

• Assessment [U0105]
  • Assessment
  • Assessment Waiver

• Group Property Tax Assessment [U0106]

• Payment Extension [U0107]
  • Payment Extension
  • Payment Extension Reversal

• Lease Extension [U0108]
  • Automatic Lease Extension
  • Lease Extension
  • Lease Extension Reversal

• Suspense [U0109]
  • Add Suspense
  • Change Suspense
  • Clear Suspense via Cashier's Check
  • Clear Suspense via G/L Account

• Cashier's Check [U0110]
  • Add Cashier's Check
  • Change Cashier's Check
  • Delete Cashier's Check

• Session [U0111]
  • Add/Change Session
  • Delete Session

• Split/Merge Qty Asset [U0112]
  • Transfer to New Asset
  • Transfer to Existing Asset

• Asset Add-On [U0113]

• Change Lease Key [U0114]

• Suspended Earnings [U0115]

• Rebook [U0116]

• Cashier's Check Disbursal [U0117]

• Payment Due Day Change [U0118]
  • Payment Due Day Change
  • Due Day Change Reversal

• Property Tax/FHUT Payable [U0119]

• Change Asset [U0120]
  • Adjust Original Cost
  • Change Depreciation
  • Change Key
  • Reverse Depreciation Accrual
  • Write Up/Write Down

• General Ledger Adjustment [U0121]

• Third Party Payable [U0122]

• Lease Discounting [U0123]

• Investor Settlement [U0124]

• IBL Principal Adjustment [U0125]
  • Principal Write-Down
  • Principal Write-Down Reversal
  • Principal Write-Up
  • Principal Write-Up Reversal

• Cash Control [U0126]

• Reversal Suspense [U0127]
  • Add Reversal Suspense
  • Change Reversal Suspense
  • Clear Reversal Suspense via Cashier's Check
  • Clear Reversal Suspense via G/L Account

• Salvage Value Write Down [U0128]

• Batch Payoff [U0129]

• Partial Charge Off [U0130]

• Assess Meter Charge [U0131]: Asset-Level Meters
• Assess Meter Charge [U0131]: Lease-Level Meters

• Reverse Meter Charge [U0132]: Asset-Level Meters
• Reverse Meter Charge [U0132]: Lease-Level Meters

• Ad Hoc ACH [U0134]

• Client Billing [U0135]

 

Maintenance [U02]

• Vendor [U0201]

• Master Financial [U0202]

• Lessee [U0203]

• Demographic [U0204]

• Customer [U0205]

• Office [U0206]
  • Add/Change Office
  • Delete Office

• Region [U0207]
  • Add/Change Region
  • Delete Region

• Company [U0208]
  • Add/Change Company
  • Delete Company

• Group [U0209]
  • Add/Change/Add a Lease to Group
  • Delete Group
  • Delete a Lease from Group

• Asset [U0210]

• Loan [U0211]
  • Add Loan
  • Change Loan
  • Delete Loan

• Portfolio [U0212]
  • Assessment Customizations
  • Calculation Customizations
  • End of Period Customizations
  • Field Customizations
  • Miscellaneous Customizations
  • Modules Customizations
  • New Lease Customizations
  • PAP/ACH Control File
  • Payoff Customizations
  • Predefined Cycles Customizations
  • User Defined Fields/Tables

• Payoff Quote [U0213]

• Split Asset [U0214]

• Change Accrual [U0215]

• Investor [U0216]

• Guarantor [U0217]

• Lessee/Customer [U0218]
  • Add a Lessee to a Customer
  • Remove a Lessee from a Customer

• Broker [U0219]

• Lender [U0220]

• Investor Group [U0221]
  • Add/Change Investor Group
  • Delete Investor Group

• IDC/IDR Adjustments [U0225]

• Dealer Statement Adjustments [U0226]

• Miscellaneous Billing Info [U0227]

• Load Leveraged Table [U0228]

• User Defined Client [U0229]

• Multi Asset Maintenance [U0230]

• Asset Meter Maintenance [U0231]

• Batch Assessment Maintenance [U0232]

• Lease Meter Maintenance [U0233]

• Multi Lease Ins Maintenance [U0234]

• UDF/UDT Maintenance [U0235]

• RCR Schedule [U0236]

• Like-Kind Exchange [U0237]

 

Predefined Cycle [U03]

• Cycle Accruals [U0301]
  • Accrual
  • Accrual Reversal

• Cycle Invoices [U0302]

• Unbilled Receivables [U0303]

• Preauthorized Payments [U0304]

• Batch Payments [U0305]

• Batch Payment Reversal [U0306]

 

End of Period [U04]

• Overview

• Interactive Updates
  • Submit [U0401]
  • Status Review [U0402]
  • Status Listing [U0403]
  • Halt/Restart/Skip [U0404]
  • Restart [U0405]
  • Print/View Reports [U0406]

• Non-Updating Reports

• High Volume/Split EOP

End of Period Modules
(in Alphabetical Order)

• ALI Insurance Data Export [U0438]
• Application/RAP Clean-Up [U0453]
• Assumed Payments [U0414]
• Auto Apply Suspense for IBL [U0420]
• Auto Payoff CSA NMAT Leases [U0429] (daily Sequential Updates module--documentation coming soon)
• Auto Security Deposit Suspense Disbursal [U0436]
• Automatic Charge Off [U0440]
• Automatic Desecuritization [U0435]
• Automatic Lease Extension [U0430]
• Automatic Suspended Earnings [U0439]

• Batch Assessments [U0418]
• Batch Escrow Disbursement [U0409]
• Batch Meter [U0448]
• Batch Payment Reversal [U0470]
• Batch Payments [U0415]
• Batch Payoff [U0427]

• Cashier's Check Disbursal [U0117]
• Clear Year-To-Date Fields [U0482]
• Closed Lease Clean-Up [U0419]
• Collateral Tracking Initialization [U0432]
• Credit Bureau Extract Metro2 Format [U0462]
• Credit Bureau Extract Metro2 Format [U0463]
• Customer/Group Batch Payment [U0458]
• Cycle Accruals [U0301]
• Cycle Invoices [U0302]

• Dealer Statement [U0426]
• Depreciation [U0443]
• End of Period End [U0499]
• End of Period Start [U0410]
• General Ledger Interface [U1003]
• General Ledger Lessor Income [U0446]

• Historical Payment/RTX Clean-Up [U0451]
• Insurance Risk Fee [U0428]
• Insurance Status Update [U0421]
• Insurance Tracking [U1002]
• Insurance Tracking Initialization [U0434]
• Investor Income Participation [R0701]
• Investor Settlement [U0124]
• ITC Accrual [U0444]

• Late Charges Calculation and Assessment [U0433]
• Loan Accrual [U0455]
• Master General Ledger Reconciliation Report [U0460]
• Maturing Lease Tracking Initialization [U0431]
• Missing Auxiliary File Elements [U0445]

• Notes Payable Accrual [U0905]
• Portfolio Status [U0442]
• Preauthorized Payments [U0304]
• Sequential Updates [U0411]
• Sequential Updates Post-Merge [U0413]
• Sequential Updates Post-Processor [U0412]
• Suspense Review [R0203]

• Use Tax Disbursal [U0449]
• Vendor ACH [U0424]
• Vendor File Clean-Up [U0423]
• Vendor Income Participation [R0801]
• Vendor Payment Participation [R0805]
• Vendor Totals [U0441]
• Vertex Interface [U0437]

• Year-End File Build [U0481]
• Zero Daily General Ledger Accounts [U0422]
• Zero Monthly General Ledger Accounts [U0450]
• Zero Monthly General Ledger Accounts (EOY) [U0450]

 

End of Year Tax Model [U06]

• Introduction
  • Propose Depreciation Methods [U0601]
  • Submit Batch Job For Proposal [U0602]
  • Gross Bookings By Quarter [U0603]
  • Depreciation EOY [U0604]
  • Gain/Loss EOY [U0606]
  • Gross Profit Recalculation [U0607]
  • Gross Profit Deferral [U0608]

 

Auxiliary Table Maintenance [U07]

• Location [U0701]
  • Add Location
  • Change Location
  • Delete Location

• Salesperson [U0702]
  • Add Salesperson
  • Change Salesperson
  • Delete Salesperson

• Auxiliary Address [U0704]
  • Add/Change
    • Collection Agency
    • Credit Bureau
    • Legal Firm
    • Remittance Address
    • Regional Codes
  • Delete Auxiliary Address

• Base Rates [U0705]
  • Add Financial Institution Base Rates
  • Change/Update All Base Rates For Financial Institution(s)
  • Delete Financial Institution Base Rates

• Security [U0706]
  • Add/Change Security
  • Delete Security

• Approval Officer [U0707]

• Financial Institution Name [U0708]

• Activity/Bankruptcy Status [U0709]

• Asset Description [U0710]
  • Add Manufacturer
  • Change/Delete Manufacturer
  • Add Model
  • Change/Delete Model

• Custom General [U0712]
  • Account Customizations
  • Device and Printer Customizations
  • End of Period Customizations
  • Field Customizations
  • Miscellaneous Customizations

• State [U0713]
  • Add/Change State
  • Delete State

• Federal Highway Use Tax (FHUT) [U0714]
  • Add/Change FHUT
  • Delete FHUT

• Office G/L Change [U0716]

• Weekend and Holiday Assignment [U0720]

• Lease Form [U0721]
  • Add/Change Lease Form
  • Delete Lease Form

• Custom Code [U0722]
  • Add Custom Code Category
  • Custom Code Category Listing
  • Add Custom Code
  • Change Custom Code
  • Delete Custom Code

• Transfer Price Rate [U0723]

• Team [U0724]

• Sales Tax On Assessments [U0725]
  • Add/Change Sales Tax on Assessments
  • Delete Sales Tax on Assessments

• Time Zone [U0726]
  • Add/Change Time Zone
  • Delete Time Zone Information

• Custom Edit Check Codes [U0727]
  • Add Edit Check Codes
  • Change Edit Check Codes
  • Delete Edit Check Codes

• Queue [U0728]
  • Add/Change Queue
  • Delete Queue

• Agency [U0729]
  • Add/Change Agency
  • Delete Agency

• Depreciation [U0730]
  • Add/Change Depreciation
  • Delete Depreciation

• Metro2 Setup [U0733]

 

Application [U08]

• Application Tracking [U08]
  • Introduction
  • Application Menu
  • New Application
  • Change/View Application
  • Delete Application
  • Application Assets
  • Asset Meter Maintenance
  • Application Meter Maintenance
  • Document List
  • Enhanced IDC/IDR
  • Insurance (Application)
  • Status Transfer
  • Book Requirements
  • Data Entry Requirements
  • Client Exposure
  • Single Application Selection
  • Application Work Schedule

• Application Tabs
• Application Asset Tabs

• Batch Book Requirements

• Applciation Pricing

• Application Setup [U08]
  • Status [U0811]
  • Flow [U0812]
  • Field Security [U0814]
  • Document List [U0815]
  • Rate Plan [U0816]
  • Rate Plan Group [U0817]
  • Reason/Condition [U0818]
  • Custom General [U0821MO]
  • Portfolio [U0822]
  • Application User Profile [U0831]

 

Notes Payable [U09]

• Introduction

• New Notes Payable [U0901]
  • Book Note
  • Remove Note

• Notes Payable Payment [U0902]
  • Payment
  • Payment Reversal

• Notes Payable Payoff [U0903]
  • Payoff
  • Payoff Reversal

• Principal and Schedule Adjustment [U0904]

• Notes Payable Accrual [U0905]
  • Accrual
  • Accrual Reversal

 

Updates: External Data Sets [U10]

• Insurance Tracking [U1002]

• General Ledger Interface [U1003]

 

Collection [U11]

• Collection Tracking [U11]
  • Introduction
  • Collection Account Assignment
  • Collection Tracking Menu
  • Lessee Summary
  • Lease Selection
  • Lease Summary
  • Alternate Lease Summary
  • Work Schedule
  • Repo Request

• Collection Setup [U11]
  • User Reassignment [U1111]
  • Module Customizations [U1121MO]
  • Portfolio Customizations [U1122]
  • Collection User Profile [U1131]
  • Weight Table [U1141]
  • Collection Status Defaults [U1151]

 

Collateral [U12]

• Collateral Tracking [U12]
  • Collateral Tracking
  • Collateral Menu
  • Work Schedule
  • Asset Summary

• Collateral Setup [U12]
  • Reassignment [U1211]
  • Module Customizations [U1221MO]
  • Portfolio Customizations [U1222]
  • Collateral User Profile [U1231]

 

Insurance [U13]

• Insurance Tracking [U13]
  • Insurance Tracking
  • Insurance Menu
  • Work Schedule

• Insurance Setup [U13]
  • Reassignment [U1311]
  • Module Customizations [U1321MO]
  • Portfolio Customizations [U1322]
  • Insurance User Profile [U1331]

 

Maturing Lease [U14]

• Maturing Lease Tracking [U14]
  • Maturing Lease Tracking
  • Maturing Lease Menu
  • Work Schedule
  • Lease Summary

• Maturing Lease Setup [U14]
  • Reassignment [U1411]
  • Module Customizations [U1421MO]
  • Portfolio Customizations [U1422]
  • Maturing Lease User Profile [U1431]

 

Customer Service [U16]

• Customer Service Tracking [U16]
  • Introduction
  • Work Schedule
  • Lease Summary
    • Included Payoff Calculations
  • Alternate Lease Summary
  • Customer Summary

• Customer Service User Profile [U1631]

 

Recovery [U17]

• Recovery Tracking [U17]
  • Introduction
  • Recovery Tracking Menu
  • Customer Summary
  • Deficiency
  • Lease Summary
  • Legal/Agency Status
  • Repo Account Status
  • Repo Assignment
  • Vehicle
  • Work Schedule

• Recovery Setup [U17]
  • Module Customizations [U1721MO]
  • Recovery User Profile [U1731]

 

 

LeasePak Reports
R01 R02 R03 R04 R05 R06 R07 R08 R09 R10 R11 R12

 

Strategic Management [R01]

• New Lease Earnings [R0101]
• Account Balances [R0103]
• Portfolio Status [R0104]
• Book Gain/Loss [R0108]
• Model Amortization [R0109]
• Portfolio Profile [R0110]
• Funding Schedule [R0111]
• Forecasting [R0112]
• Lease Discounting Approval [R0113]
• PAP Projection [R0114]
• Book Gain/Loss Reconciliation [R0115]

 

Operational Management [R02]

• Operator's Status Review [R0202]
• Suspense Review [R0203]
• Salesperson Commission [R0204]
• Cashier's Check Listing [R0205]
• Investor Settlement Listing [R0206]
• Reversal Suspense Review [R0207]
• Suspense Item Report [R0208]

 

Controller's Tax [R03]

• Taxable Income [R0301]
• Investment Tax Credit Listing [R0302]
• Investment Tax Credit Review [R0303]
• Tax Depreciation [R0304]
• Property Tax Assessor [R0305]
• Federal Highway Use Tax [R0306]
• Energy Tax Credit Listing [R0307]
• Energy Tax Credit Review [R0308]
• Titling Tax [R0309]
• Tax Timing Differences [R0310]
• Tax Gain/Loss [R0311]
• Adjusted Current Earnings (ACE) [R0312]

 

Audit Control [R04]

• Session Balance [R0401]
• General Ledger Reconciliation [R0403]
• Accounts Receivable Balancing [R0404]
• Daily Transaction Journal [R0405]
• General Ledger Entries Listing [R0406]
• Income Receivable Balancing [R0407]
• Accounts Payable Balancing [R0408]
• Rental Income [R0409]
• Historical General Ledger [R0410]
• Cash Receipts Journal [R0411]
• Waiver Report [R0412]
• Non-Monetary Archive Report [R0413]
• Batch Payment Report Viewer [R0415]
• Batch Payoff Report Viewer [R0416]
• Client A/R Balancing [R0417]
• Client Payment History [R0418]
• Client Transaction Journal [R0419]

 

Application [R05]

• Application Activity [R0501]
• Application Inquiry [R0502]
• Turnaround Timing [R0503]
• Individual Turnaround [R0504]
• Expired Approvals [R0505]
• Credit Approval [R0506]
• Monthly Application Summary [R0507]

 

Collection/Delinquency [R06]

• Delinquency [R0601]
• Suspended/Non-Accrual Leases [R0602]
• Vendor Delinquency [R0603]
• Vendor Accounts Receivable Aging [R0604]
• Accounts Receivable Aging [R0606]
• Assessments Receivable Aging [R0607]
• Unexercised Purchase Options [R0608]
• Suspended Earnings [R0609]

 

Investor [R07]

• Investor Income Participation [R0701]

 

Vendor [R08]

• Vendor Income Participation [R0801]
• Vendor Advice of Maturing Leases [R0802]
• Vendor Mailing Labels [R0803]
• Vendor Inquiry [R0804]
• Vendor Payment Participation [R0805]

 

Operational [R09]

• Trial Balance [R0901]
• Lease Inventory [R0902]
• Certificate Of Ownership [R0903]
• Insurance Follow-Up [R0904]
• Lease Inquiry [R0905]
• Short Name Inquiry [R0906]
• Serial Number Inquiry [R0907]
• Account Payment History [R0909]
• License Number [R0910]
• Projected Maturing Leases [R0911]
• Paid Off Lease [R0912]
• Maturing Lease Mailing Labels [R0913]
• Customer/Group Inventory [R0914]
• Location Listing [R0915]
• Asset Description Listing [R0916]
• Chart of General Ledger Accounts [R0917]
• Names Listing [R0918]
• Auxiliary Address Listing [R0919]
• Lessee Address Listing/Labels [R0920]
• Month-to-Month Leases [R0921]
• Notebook Report [R0922]
• Automatic Lease Extension Listing [R0923]
• Security Access [R0924]
• Meter Transaction Journal [R0925]
• Cash Control Payment History [R0926]
• IBL Inquiry [R0927A]
• IBL Full History [R0927B]
• Billing Manager [R0928]
• Print/View User Reports [R0929]

 

Asset [R10]

• Off Lease Inventory [R1001]
• Asset Status Movement [R1002]
• Asset Movement History [R1003]
• Asset Location [R1005]
• Purchase Order Number [R1006]
• AFM General Ledger Entries Listing [R1007]
• AFM Income Transaction Journal [R1008]

 

Loan [R11]

• Loan Inventory [R1101]
• Cash Flow [R1102]
• Equity [R1103]
• Asset/Loan [R1104]
• Lender Settlement [R1105]

 

Notes Payable [R12]

• Notes Payable Inquiry [R1201]
• Lender Booking Rates [R1202]
• Net Investment [R1203]
• Net Income [R1204]
• Notes Transaction Journal [R1205]

 

 

LeasePak Menu Documents

• Fast Menu
• LaunchPad
• LeasePak Client Menu Structure
  • Quick-Reference PDF Document
• Menu Options
  • For use with Fast Menu, LaunchPad, and User Defined Toolbar
• Refresh Codes
• User Defined Toolbar

 

 

Overview Documents

• Additional Non-Vertex Rates (Vehicle Tax)

• Asset Focus Module Overview

• Asset Search

• Client Search

• Commercial Loan
  • Commercial Loan overview document in progress.

• Cost Per Use

• Drawdown Tracking

• Historical General Ledger Names/Numbers

• Interest Bearing Loans
  • IBL overview document in progress.

• LeasePak Basics
  • Signing On,
    Changing Your Password,
    Exiting LeasePak
  • Navigating LeasePak
  • Entering Data
  • Running Reports

• LeasePak Client [U02]
  • Add a LeasePak Client
  • Client Search
  • Change/Delete a LeasePak Client

• LeasePak Productivity Suite
  • Provides an overview and links to corresponding documentation for the applications included in the Productivity Suite: ChannelIT, DocIT, LinkIT, ServIT, and ViewIT.

• LeasePak Utilities

• Leveraged Leases

• Like-Kind Exchange

• Postal Code Formats

• Red Flag Warning

• XSLT Customizations: LaunchPad

• XSLT Customizations: Lease Summary

 

 

LeasePak Interfaces
to Third-Party Software

• Credit Scoring Interface (MicroBilt)

• Credit Bureau Export (Metro2)

• Document Generation

• dx Generation

• XML App/Pricing Interface (SuperTrump)

 

 

LeasePak 6.1a Documentation Suite

© 2008 by NetSol Technologies Inc. All rights reserved.

The information contained in this document is the property of NetSol Technologies Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. NetSol Technologies Inc. assumes no liability for any inaccuracy that may appear in this document; the contents of this document do not constitute a promise or warranty. The software described in this document is furnished under license and may be used or copied only in accordance with the terms of said license. Unauthorized use, alteration, or reproduction of this document without the written consent of NetSol Technologies Inc. is prohibited.