U04 End of Period

U0460 Master General Ledger Reconciliation

For more information about End of Period,
refer to U04 End of Period Overview.

U0460 Master General Ledger Reconciliation is part of the End of Period process. The 1995 JULE fund must be purchased in order to have access to this module.

Journaling is automatically turned off for this update. The update is structured so that the database is not corrupted if this update should terminate abnormally in any part of its processing.

The purpose of the Master G/L Reconciliation module is to reconcile as many G/L accounts as possible within LeasePak and, when an out-of- balance condition is found, provide available detailed information to aid in researching the account.

The module creates two reports. The U0460A reports out-of- balance transactions while the U0460B lists the accounts that caused the out- of-balance. The U0460B will show the out of balance transactions during the first two days of the report run unless G/L related activities have occurred.

This update also supports the assessed fees account (1011). It will compare the value of the account Assessed Fees (1011) to the R0607 Assessments Receivable Aging. This comparison will be for all the assessments which are on cash basis (Accounting Basis 'C') and all recurring charges that are not escrow (Recurring charges type 'E'). If user attempts to change the accounting basis of assessment types or the type of recurring charges after the assessment or recurring charges has been used to invoice an amount in the given portfolio, this can cause data corruption.

For maximum benefit, this module should be run on a daily basis as part of the End of Period process for each portfolio.

The portfolio setting that governs the execution of the Master G/L Reconciliation update is found in End of Period Customizations option of the U0212 Portfolio→Assessment Customizations.On first screen under the column Accounting, assessments show either 'C' to account for the assessment on cash basis, or 'A' to account for the assessment on an accrual basis. On the second screen under the column type, recurring charges shows 'E' to indicate this recurring charge uses the special general ledger accounts for escrow.

The Master G/L Reconciliation update reconciles IDC/IDR information entered in the lease. The 11 IDC/IDR unearned amounts as well as three payables are reconciled in this report.

Any imbalance of R0403 report can be found on this report, and it helps the user to determine that what causing this imbalance. R0460B report displays the detail information to determine the cause of imbalance.

The G/L Accounts reconciled by this module are as follows:

• Contract Receivable
• Lease Payment Receivable
• Residual Precomputed
• Lease Income Receivable
• Unearned Residual
• Lessor Unearned income
• Unearned ITC
• Vendor Participation Unearned
• Assessments
• Principal Outstanding
• Residual - Simple
• Unbilled Operating Lease Receivable
• Inventory
• Unamortized IDC Income Cost
• Vendor Receivable
• Principal Receivable
• Recurring Charges 1-15 Receivables
• Suspended Income Receivable
• Suspended Principal Receivable
• Suspended Income Receivable (unbilled)
• Loan Principal Receivable
• Loan Interest Receivable
• Suspended IDC Accrued
• Accounts Payable
• Commission Fee Payable
• Dealer Participation
• Investor Participation
• Use Tax Payable
• Security Deposit
• Property Tax Payable
• FHUT Payable
• Deferred Operating Lease Revenue
• Deferred Extension Income
• Deferred Residual Reduction
• Unrecognized Operating Lease Income
• Suspended Income Accrued
• Accumulated Depreciation
• Assessed Fees
• IDRD - D/L SUBVENTION1
• IDRE - D/L SUBVENTION2
• IDRF - D/L SUBVENTION3
• IDRG - D/L SUBVENTION4
• IDRG - D/L SUBVENTION5
• IDRD - SUSP D/L SUBVENTION1 INC
• IDRE - SUSP D/L SUBVENTION2 INC
• IDRF - SUSP D/L SUBVENTION3 INC
• IDRG - SUSP D/L SUBVENTION4 INC
• IDRH - SUSP D/L SUBVENTION5 INC
• IDRD - RETAIL SUBVENTION1
• IDRE - RETAIL SUBVENTION2
• IDRF - RETAIL SUBVENTION3
• IDRG - RETAIL SUBVENTION4
• IDRH - RETAIL SUBVENTION5
• IDRD - SUSP RETAIL SUBVENTION1 INC
• IDRE - SUSP RETAIL SUBVENTION2 INC
• IDRF - SUSP RETAIL SUBVENTION3 INC
• IDRG - SUSP RETAIL SUBVENTION4 INC
• IDRH - SUSP RETAIL SUBVENTION5 INC

Following are the general ledger accounts for an interest bearing loan transaction:

• IDRD - RETAIL SUBVENTION1
• IDRE - RETAIL SUBVENTION2
• IDRF - RETAIL SUBVENTION3
• IDRG - RETAIL SUBVENTION4
• IDRH - RETAIL SUBVENTION5
• IDRD - SUSP RETAIL SUBVENTION1 INC
• IDRE - SUSP RETAIL SUBVENTION2 INC
• IDRF - SUSP RETAIL SUBVENTION3 INC
• IDRG - SUSP RETAIL SUBVENTION4 INC
• IDRH - SUSP RETAIL SUBVENTION5 INC

Following are the general ledger accounts for an interest bearing loan transaction:

• IDC6 - UNAMORT DEALER BONUS
• IDC6 - DEALER BONUS PAYABLE
• IDC6 - SUSP DEALER BONUS

Following are the general ledger accounts for a pre-computed lease:

• IDC6 - UNAMORT O/L DEALER BONUS
• IDC6 - D/L DEALER BONUS PAYABLE
• IDC6 - D/L SUSP DEALER BONUS

Following are the general ledger accounts for an interest bearing loan transaction:

• IDC6 - UNAMORT O/L DEALER BONUS
• IDC6 - O/L DEALER BONUS PAYABLE
• IDC6 - O/L SUSP DEALER BONUS

The dealer reserve GL account are as follows:

Following are the general ledger accounts for a pre-computed lease:

• IDC7 - UNAMORT O/L DEALER RESERVE
• IDC7 - D/L DEALER RESERVE PAYABLE
• IDC7 - D/L SUSP DEALER RESERVE

Following are the general ledger accounts for an operating lease:

• IDC7 - UNAMORT O/L DEALER RESERVE
• IDC7 - O/L DEALER RESERVE PAYABLE
• IDC7 - O/L SUSP DEALER RESERVE
Following are the general ledger accounts for an interest-bearing loan:
• IDC7 - UNAMORT DEALER RESERVE
• IDC7 - DEALER RESERVE PAYABLE
• IDC7 - SUSP DEALER RESERVE

Following are the general ledger accounts for the supplemental depreciation:

• Accumulated Supplemental Depreciation

Following are the general ledger accounts for the IDC8, IDC9, and IDCA-IDCH additional IDC fields:

• IDC8-UNAMORTIZED RESERVES
• IDC8-UNAMORT D/L RESERVES
• IDC8-UNAMORT D/L-O/L RESERVES
• ALT:IDC8-UNAMORT RESERVES
• IDC9-UNAMORTIZED RESERVES
• IDC9-UNAMORT D/L RESERVES
• IDC9-UNAMORT D/L-O/L RESERVES
• ALT:IDC9-UNAMORT RESERVES
• IDCA-UNAMORTIZED RESERVES
• IDCA-UNAMORT D/L RESERVES
• IDCA-UNAMORT D/L-O/L RESERVES
• ALT:IDCA-UNAMORT RESERVES
• IDCB-UNAMORTIZED RESERVES
• IDCB-UNAMORT D/L RESERVES
• IDCB-UNAMORT D/L-O/L RESERVES
• ALT:IDCB-UNAMORT RESERVES
• IDCC-UNAMORTIZED RESERVES
• IDCC-UNAMORT D/L RESERVES
• IDCC-UNAMORT D/L-O/L RESERVES
• ALT:IDCC-UNAMORT RESERVES
• IDCD-UNAMORTIZED RESERVES
• IDCD-UNAMORT D/L RESERVES
• IDCD-UNAMORT D/L-O/L RESERVES
• ALT:IDCD-UNAMORT RESERVES
• IDCE-UNAMORTIZED RESERVES
• IDCE-UNAMORT D/L RESERVES
• IDCE-UNAMORT D/L-O/L RESERVES
• ALT:IDCE-UNAMORT RESERVES
• IDCF-UNAMORTIZED RESERVES
• IDCF-UNAMORT D/L RESERVES
• IDCF-UNAMORT D/L-O/L RESERVES
• ALT:IDCF-UNAMORT RESERVES
• IDCG-UNAMORTIZED RESERVES
• IDCG-UNAMORT D/L RESERVES
• IDCG-UNAMORT D/L-O/L RESERVES
• ALT:IDCG-UNAMORT RESERVES
• IDCH-UNAMORTIZED RESERVES
• IDCH-UNAMORT D/L RESERVES
• IDCH-UNAMORT D/L-O/L RESERVES
• ALT:IDCH-UNAMORT RESERVES

Following are the general ledger accounts for IDC ASC 842:

• UNAMORTIZED IDC COST - ASC 842
• SUSPENDED IDC ACCRUED - ASC 842
• DEFERED IDC AMORTIZATION - ASC 842
• DEFERED SUSP IDC ACCRUED - ASC 842

U0460A Master G/L Reconciliation Report

This report displays any out of balances that may have occurred in the G/L after End of Period has been run. The Report number and the User Id will be displayed on the screen.

• PORTFOLIO
  The Portfolio number is displayed.

• COMPANY
  The Company number is displayed.

• REGION
  The Region number is displayed.

• OFFICE
  The Office number is displayed.

• G/L NUMBER
  The General Ledger account number is displayed.

• G/L NAME
  The General Ledger account name is displayed.

• GENERAL LEDGER BALANCE
  If an out of balance exists, the General Ledger Balance out of balance is displayed in negative amounts.
  
  
• TRANSACTION TOTALS
  The Transaction Total for the General Ledger account is displayed.
  
  
• DIFFERENCE
  The difference amount for the out of balance is displayed for the G/L account.

U0460B Master G/L Reconciliation Imbalance Report

This screen lists the G/L out of balance by lease number. This will show all individual lease transactions that are out of balance.

• P/C/R/O
  The PCRO for the lease and G/L account are displayed.

• G/L NUMBER
  The G/L account number that is out of balance is displayed.

• LEASE
  The lease number in which the transaction was made that caused the out of balance is displayed.

• CURRENT TOTALS
  The actual current total for the transaction is displayed.
  
  
• PREVIOUS TOTALS
  The previous transaction total for the lease is displayed.
  
  
• DIFFERENCE
  The total difference for the lease transaction is displayed.

• RTX TOTALS
  The total difference in the RTX file is displayed.

• DIFFERENCE
  The total difference in the G/L pertaining to the lease transaction is displayed.