U04 End of Period
U0450 Zero Monthly General Ledger Accounts
EOP Only |
Yes |
Frequency |
Monthly |
Sequential Updates |
No |
Skip Notes |
See comments below |
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