U04 End of Period

U0482 Clear Year To Date Fields

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

This update should be skipped if U0481 Year End File Build failed to complete successfully. If this update is skipped and End of Year completes, the information detailed in the lists below must be cleared manually (for example, by using an SQL stored procedure). If the information is not cleared, R0301 Taxable Income will erroneously count receipts twice for the following year.

This module zeroes out all year-to-date information on the rls Lease and req Asset tables.

Additionally, this will allow the ability to track prior year-to-date data at the lease level. The EOY process will move the year-to-date data from the lease table to the new table Year to Date History, just before all fields are cleared. The Y-T-D data will be stored per lease per year on the rhy Lease Year to Date History table. Assets or Notes payable Y-T-D information will not be saved. All Y-T-D History will be deleted when U0419 Closed Lease Cleanup is run.

The year-to-date information cleared is:

• Master Financial file (RLS)
• year-to-date rental income
• year-to-date net receipts
• year-to-date other income receipts
• year-to-date lessor income accrued
• year-to-date vendor income accrued
• year-to-date investor income accrued
• year-to-date IDC/IDR accrued
• year-to-date ITC income accrued
• year-to-date escrow received

• Asset file (REQ)
• year-to-date book depreciation
• year-to-date federal depreciation
• year-to-date state depreciation
• year-to-date ITC
• year-to-date ETC
• year-to-date net receipts
• year-to-date other income receipts
• year-to-date loss

The year-to-date information cleared for IDC8, IDC9, and IDCA-IDCH is:

• Year to date IDC8
• Alternate year to date IDC8
• Year to date IDC9
• Alternate year to date IDC9
• Year to date IDCA
• Alternate year to date IDCA
• Year to date IDCB
• Alternate year to date IDCB
• Year to date IDCC
• Alternate year to date IDCC
• Year to date IDCD
• Alternate year to date IDCD
• Year to date IDCE
• Alternate year to date IDCE
• Year to date IDCF
• Alternate year to date IDCF
• Year to date IDCG
• Alternate year to date IDCG
• Year to date IDCH
• Alternate year to date IDCH

The year-to-date information cleared for IDC ASC 842 is:

• IDC Y-T-D amount - book

Dealer Reserve: LeasePak clears the dealer bonus and dealer reserve field to historical table. This update also zero outs all the year-to-date information on the lease and moves the amounts to the year-to-date history table for dealer bonus and dealer reserve fields.