U04 End of Period

U0409 Batch Escrow Disbursement

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

This module assesses all Escrow recurring charge fees to leases via an input file. This program will process General Ledger accounting and other LeasePak file updating.

Two reports are created by the program: the U0409A exception report and the U0409B audit report. Any problems found during processing are reported through the Batch Escrow Exception report. The assessments may be processed interactively through U0105 Assessment, if possible, or resubmitted in the next batch escrow process. The batch Escrow Audit report will report escrow recurring charges successfully processed. It should be verified as correct.

The input file is a normal ASCII text RMS sequential file, and may be created through a program or, more simply, by creating and editing a file. LeasePak will automatically delete the batch escrow file after it completes processing. It is advisable to retain a copy of this input file in a separate directory in case future reference is necessary.

Before creating the input file for the fist time, a logical name called batch_escrow_file should be established with the root name of the input file. This may be done by inserting the following line into the logical name command file, COM:SITELOG.COM,$com/leasepak_logicals.com, located in the command procedure directory for LeasePak:

$assign/group xx$disk:[xxLeasePak.DATA]btchescr.dat
BATCH_ESCROW_FILE

This example defines the name of the input file with the root name of "btchescr.dat" located in LeasePak's data directory. The root name is not the actual file name of the batch escrow input file. The lease number,date of disbursal, the dollar amount, (RCK record) check number , name, address 1, address 2, city, state, zip, reference, asset number and bank number makes up the input file for batch escrow. For example:

50, 890331, 7500, 123, WESTON, Address1, Address2, UNION CITY, CA, 12345, Ref, 78, 520

The input file is modified to handle the selected lease's escrow recurring charges. Each item and its ordering are as follows:

• LEASE NUMBER
  The LEASE NUMBER to which the escrow recurring charge is to be charged. LEASE NUMBER may be from 1 to a maximum of 10 characters or digits long. Followed by a comma (,).
  
  
• DISBURSAL DATE
  The DISBURSAL DATE in YYMMDD format in which the escrow was disbursed. Followed by a comma (,).
  
  
• DOLLAR AMOUNT
  The DOLLAR AMOUNT of the escrow recurring charge without a decimal place. Followed by a comma (,).

• CLIENT CHECK NUMBER
  The CLIENT CHECK NUMBER that was disbursed when the lease was booked. Followed by a comma (,).

• NAME
  The NAME of the lessee under which the lease is booked. Followed by a comma (,).

• ADDRESS 1
  The ADDRESS 1 of the lessee . Followed by a comma (,).

• ADDRESS 2
  The ADDRESS 2 of the lessee . Followed by a comma (,).

• CITY
  The CITY in which pertains to the lessee's address. Followed by a comma (,).

• STATE
  The state that pertains to the lessee's address. Followed by a comma (,).

• ZIP
  The ZIP code that pertains to the lessee's address. Followed by a comma (,).

• REFERENCE
  The REFERENCE description that appears in U0203 Lessee. Followed by a comma (,).

• ASSET NUMBER
  The ASSET NUMBER that is tied to the lease. Followed by a comma (,).

• BANK NUMBER
  The BANK NUMBER in which that pertains to the lease. Followed by a comma (,).

U0409A Batch Escrow Exceptions

U0409A Batch Escrow Exceptions reports at the lease or invoice level and includes the following information:

• LEASE
  The lease number, if applying payments by lease number, is displayed.

• DISBURSEMENT DATE
  The disbursement date of the escrow recurring charge, is displayed.

• AMOUNT
  The total amount of the escrow recurring charge, is displayed.

• EXCEPTION MESSAGE
  The informational, warning, or error message is displayed.

U0409B Batch Escrow Audit

U0409B Batch Escrow Audit reports at the lease and asset level and includes the following information:

• LEASE
  The lease number, is displayed.

• ASSET NUMBER
  The asset number, is displayed.

• DISBURSEMENT DATE
  The disbursement date, is displayed.

• AMOUNT
  The total amount of the escrow recurring charge, is displayed.

• CLIENT CHECK
  The client check number at time of disbursement, is displayed.

• BANK CODE
  The bank code that was selected when the lease was booked, is displayed.

• PAYEE NAME
  The name of the payee, is displayed.