U0450 Zero Monthly General Ledger Accounts
LeasePak Documentation Suite NETSOL website
U0450 Zero Monthly General Ledger Accounts

End of Period symbol U04 End of Period

U0450 Zero Monthly General Ledger Accounts

EOP Only Yes
Frequency Monthly
Sequential Updates No
Skip Notes See comments below

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

 

This module zeroes out monthly debits and credits for all General Ledger accounts for each office. It also clears balances in all income and expense accounts (except reserve accounts) on LeasePak's General Ledger. If this module is not executed monthly, the month-to-date debit and credit amounts reflect an accumulation of months' work. Regardless of whether it is executed monthly, this module automatically executes at the end of the year. This provides the ability to store year-to-date totals, instead of month-to-date totals, by suppressing this module on a monthly basis.

A switch on the U0712 Custom General may be set to 'Y' so that before sales tax records are zeroed out, they are stored in a separate DTR.SEQ file which is never manually deleted. This may be used for interfacing with tax subsystems.

Skip Notes: If this module is skipped, monthly debits and credits are not cleared for the current month. If a monthly interface to an outside General Ledger system is completed, then next month's General Ledger numbers include the current month's information, effectively double-counting the current month's information.

 

Additional Information

Following are the general ledger accounts to zero out month to date debits and credits for subvention. It will also clear the balances in the income and expense accounts:

  • AR - Subvention1
  • AR - Subvention2
  • AR - Subvention3
  • AR - Subvention4
  • AR - Subvention5
  • IDRD - D/L SUBVENTION1
  • IDRD - D/L SUBVENTION2
  • IDRD - D/L SUBVENTION3
  • IDRD - D/L SUBVENTION4
  • IDRD - D/L SUBVENTION5
  • IDRD - RETAIL SUBVENTION1
  • IDRD - RETAIL SUBVENTION2
  • IDRD - RETAIL SUBVENTION3
  • IDRD - RETAIL SUBVENTION4
  • IDRD - RETAIL SUBVENTION5
  • IDRD - D/L SUBVENTION1 INCOME
  • IDRD - D/L SUBVENTION2 INCOME
  • IDRD - D/L SUBVENTION3 INCOME
  • IDRD - D/L SUBVENTION4 INCOME
  • IDRD - D/L SUBVENTION5 INCOME
  • IDRD - RETAIL SUBVENTION1 INC
  • IDRD - RETAIL SUBVENTION2 INC
  • IDRD - RETAIL SUBVENTION3 INC
  • IDRD - RETAIL SUBVENTION4 INC
  • IDRD - RETAIL SUBVENTION5 INC
  • IDRD - SUSP D/L SUBVENTION1 INC
  • IDRD - SUSP D/L SUBVENTION2 INC
  • IDRD - SUSP D/L SUBVENTION3 INC
  • IDRD - SUSP D/L SUBVENTION4 INC
  • IDRD - SUSP D/L SUBVENTION5 INC
  • IDRD - SUSP RETAIL SUBVENTION1 INC
  • IDRD - SUSP RETAIL SUBVENTION2 INC
  • IDRD - SUSP RETAIL SUBVENTION3 INC
  • IDRD - SUSP RETAIL SUBVENTION4 INC
  • IDRD - SUSP RETAIL SUBVENTION5 INC

In addition to the general ledger accounts that have been added, the U0450 Zero Monthly General Ledger Accounts also specifies that which income and expense general ledger account balances will be zero out by this update. The following income general ledger account balances will be zeroed out by this update:

  • IDRD - D/L SUBVENTION1 INCOME
  • IDRD - D/L SUBVENTION2 INCOME
  • IDRD - D/L SUBVENTION3 INCOME
  • IDRD - D/L SUBVENTION4 INCOME
  • IDRD - D/L SUBVENTION5 INCOME
  • IDRD - RETAIL SUBVENTION1 INC
  • IDRD - RETAIL SUBVENTION2 INC
  • IDRD - RETAIL SUBVENTION3 INC
  • IDRD - RETAIL SUBVENTION4 INC
  • IDRD - RETAIL SUBVENTION5 INC
  • IDC7 - AMORT D/L DEALER RESERVE
  • IDC7 - AMORT O/L DEALER RESERVE
  • IDC7 - AMORT DEALER RESERVE

Following are the general ledger accounts to zero out month to date debits and credits for dealer bonus. It will also clear the balances in the income and expense accounts:

  • IDC6 - UNAMOR D/L DEALER BONUS
  • IDC6 - AMORT D/L DEALER BONUS
  • IDC6 - D/L DEALER BONUS PAYABLE
  • IDC6 - D/L SUSP DEALER BONUS
  • IDC6 - UNAMORT O/L DEALER BONUS
  • IDC6 - AMORT O/L DEALER BONUS
  • IDC6 - O/L DEALER BONUSP AYBLE
  • IDC6 - O/L SUSP DEALER BONUS
  • IDC6 - UNAMORT DEALER BONUS
  • IDC6 - AMORT DEALER BONUSv
  • IDC6 - DEALER BONUS PAYABLE
  • IDC6 - SUSP DEALER BONUS

In addition to the general ledger accounts that have been added, the U0450 Zero Monthly General Ledger Accounts also specifies that which income and expense general ledger account balances will be zero out by this update. The following income general ledger account balances will be zero out by this update:

  • IDC6 - AMORT D/L DEALER BONUS
  • IDC6 - AMORT O/L DEALER BONUS
  • IDC6 - AMORT DEALER BONUS

Following are the general ledger accounts to zero out month to date debits and credits for dealer reserve. It will also clear the balances in the income and expense GL accounts:

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

Following are the general ledger accounts for inventory and individual lease-level assessment charge-off general ledger credit accounts for Clearing Change Key and individual lease-level assessment charge-off general ledger accounts. The following GL account information will be stored in the rgl General Ledger and rzg General Ledger Account Name tables. U0450 clears the balance of these general ledger accounts each month during the execution of EOP and is same as other income and expense general ledger accounts works today.

    CLEARING-CHANGE KEY
  • EOT LEASE GROSS CHARGE-OFFS - ASSUMPTION FEES
  • EOT LEASE GROSS CHARGE-OFFS - COLLECTION FEES
  • EOT LEASE GROSS CHARGE-OFFS - ITC FEES
  • EOT LEASE GROSS CHARGE-OFFS - LEGAL FEES
  • EOT LEASE GROSS CHARGE-OFFS - LEASE EXTENSION FEES
  • EOT LEASE GROSS CHARGE-OFFS - LEASE RE-WRITE FEES
  • EOT LEASE GROSS CHARGE-OFFS - LATE CHARGES
  • EOT LEASE GROSS CHARGE-OFFS - OTHER FEES
  • EOT LEASE GROSS CHARGE-OFFS - PMT EXTENSION FEES
  • EOT LEASE GROSS CHARGE-OFFS - LEASE FEE 1
  • EOT LEASE GROSS CHARGE-OFFS - LEASE FEE 2
  • EOT LEASE GROSS CHARGE-OFFS - LEASE FEE 3
  • EOT LEASE GROSS CHARGE-OFFS - LEASE FEE 4
  • EOT LEASE GROSS CHARGE-OFFS - LEASE FEE 5
  • EOT LEASE GROSS CHARGE-OFFS - LEASE FEE 6
  • EOT LEASE GROSS CHARGE-OFFS - LEASE FEE 7
  • EOT LEASE GROSS CHARGE-OFFS - LEASE FEE 8
  • EOT LEASE GROSS CHARGE-OFFS - LEASE FEE 9
  • EOT LEASE GROSS CHARGE-OFFS - LEASE FEE 10
  • EOT LEASE GROSS CHARGE-OFFS - LEASE FEE 11
  • EOT LEASE GROSS CHARGE-OFFS - LEASE FEE 12
  • EOT LEASE GROSS CHARGE-OFFS - LEASE FEE 13
  • EOT LEASE GROSS CHARGE-OFFS - LEASE FEE 14
  • EOT LEASE GROSS CHARGE-OFFS - LEASE FEE 15
  • EOT LEASE GROSS CHARGE-OFFS - LEASE FEE 16
  • EOT LEASE GROSS CHARGE-OFFS - LEASE FEE 17
  • EOT LEASE GROSS CHARGE-OFFS - LEASE FEE 18
  • EOT LEASE GROSS CHARGE-OFFS - LEASE FEE 19
  • EOT LEASE GROSS CHARGE-OFFS - LEASE FEE 20

Following are the supplemental depreciation general ledger accounts to zero out on month to date debits and credits made by this update.

  • ACCUMULATED SUPPLEMENTAL DEPRECIATION
  • SUPPLEMENTAL DEPRECIATION EXPENSE
  • EOT SUPPLMENTL DEPRECIATION RELEASE

Following are the income general ledger account balances that will be zeroed out by this update.

  • SUPPLEMENTAL DEPRECIATION EXPENSE
  • EOT SUPPLMENTL DEPRECIATION RELEASE

Following are the IDCs general ledger accounts which will be zero out monthly credit and debit accounts for IDC8, IDC9, and IDCA – IDCH fields:

  • IDC8 - FASB91 INCOME ADJUSTMENT
  • IDC9 - FASB91 INCOME ADJUSTMENT
  • IDCA - FASB91 INCOME ADJUSTMENT
  • IDCB - FASB91 INCOME ADJUSTMENT
  • IDCC - FASB91 INCOME ADJUSTMENT
  • IDCD - FASB91 INCOME ADJUSTMENT
  • IDCE - FASB91 INCOME ADJUSTMENT
  • IDCF - FASB91 INCOME ADJUSTMENT
  • IDCG - FASB91 INCOME ADJUSTMENT
  • IDCH - FASB91 INCOME ADJUSTMENT
  • IDC8 - SUSP FASB91 INCOME ADJUSTMENT
  • IDC9 - SUSP FASB91 INCOME ADJUSTMENT
  • IDCA - SUSP FASB91 INCOME ADJUSTMENT
  • IDCB - SUSP FASB91 INCOME ADJUSTMENT
  • IDCC - SUSP FASB91 INCOME ADJUSTMENT
  • IDCD - SUSP FASB91 INCOME ADJUSTMENT
  • IDCE - SUSP FASB91 INCOME ADJUSTMENT
  • IDCF - SUSP FASB91 INCOME ADJUSTMENT
  • IDCG - SUSP FASB91 INCOME ADJUSTMENT
  • IDCH - SUSP FASB91 INCOME ADJUSTMENT
  • IDC8 AMORTIZATION
  • IDC9 AMORTIZATION
  • IDCA AMORTIZATION
  • IDCB AMORTIZATION
  • IDCC AMORTIZATION
  • IDCD AMORTIZATION
  • IDCE AMORTIZATION
  • IDCF AMORTIZATION
  • IDCG AMORTIZATION
  • IDCH AMORTIZATION
  • IDC8 - SUSPENDED AMORTIZATION
  • IDC9 - SUSPENDED AMORTIZATION
  • IDCA - SUSPENDED AMORTIZATION
  • IDCB - SUSPENDED AMORTIZATION
  • IDCC - SUSPENDED AMORTIZATION
  • IDCD - SUSPENDED AMORTIZATION
  • IDCE - SUSPENDED AMORTIZATION
  • IDCF - SUSPENDED AMORTIZATION
  • IDCG - SUSPENDED AMORTIZATION
  • IDCH - SUSPENDED AMORTIZATION
  • IDC8 - TOTAL RESERVES PAYABLE
  • IDC9 - TOTAL RESERVES PAYABLE
  • IDCA - TOTAL RESERVES PAYABLE
  • IDCB - TOTAL RESERVES PAYABLE
  • IDCC - TOTAL RESERVES PAYABLE
  • IDCD - TOTAL RESERVES PAYABLE
  • IDCE - TOTAL RESERVES PAYABLE
  • IDCF - TOTAL RESERVES PAYABLE
  • IDCG - TOTAL RESERVES PAYABLE
  • IDCH - TOTAL RESERVES PAYABLE
  • IDC8 - ALT: LEASE INCOME ADJUSTMENT
  • IDC9 - ALT: LEASE INCOME ADJUSTMENT
  • IDCA - ALT: LEASE INCOME ADJUSTMENT
  • IDCB - ALT: LEASE INCOME ADJUSTMENT
  • IDCC - ALT: LEASE INCOME ADJUSTMENT
  • IDCD - ALT: LEASE INCOME ADJUSTMENT
  • IDCE - ALT: LEASE INCOME ADJUSTMENT
  • IDCF - ALT: LEASE INCOME ADJUSTMENT
  • IDCG - ALT: LEASE INCOME ADJUSTMENT
  • IDCH - ALT: LEASE INCOME ADJUSTMENT

Following are the general ledger accounts for IDC ASC 842 balances that will be zeroed out for monthly credit and debit accounts:

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