tx170 – PAYMENTS BALANCING REPORT

 

TX170 reports the breakdown of payments by a specified date range. The first section of the report includes the breakdown of: payments totals, refund, pretax and escrow amounts. The second section includes a further breakdown by taxes, penalty, interest and other by current and prior tax year. Specific titles of printouts include:

·        Payment Totals by a Range of Business Dates

·        Parcel Payment Totals by Business Date for Out of Balance Conditions

·        Payment Totals by Business Date for Out of Balance Conditions

·        Payment Distribution by Business Date for Special Assessment

·        Payment Totals by Business Date & Payment Source for Out of Balance Conditions

 

Skipping Special Assessment payment information will cause the total on the last report to be less than the PYMTS reports.

 

The payment sources tables, TAXADJ and PAYADJ, are IAS internal tables used in TX13(P-38); payment reversal will post the back-dated effective date payments.

 

See Tax Calculation and Rollover Flow Diagram for more information on this report.

NOTE:  The specific fields with permissible entries to be filled in or left blank are listed below. Ignore fields that are not in the list next to the screens.

Figure 1. SY41 (TOP)

Figure 2. SY 41 (BOTTOM)

 1.    Job: Report name should always appear here. For example, TX170.

 2.    Server Name: Keep the server name that first appears.

 3.    Printer_Name: Select a valid printer or keep the displayed printer if one is present.

 4.    Jurisdiction: Enter your jurisdiction.

 5.    Tax Year: Enter the current tax year.

 6.    Spool File Name: Enter TX170.LIS to create the file in text format.

 7.    Beginning Date: Enter the beginning business date.

 8.    Ending Date: Enter the ending business date.

 9.    ID1: Enter the minimum Parcel ID to include in the report or zero to include all parcels. Enter IDLIST to run the report on a specific list of parcels.

 10. ID2: If ID1 = minimum Parcel ID, enter the maximum Parcel ID associated with the parcels to include in the report. If ID1 = zero, enter ZZ for all parcels. If ID1 = IDLIST, enter the SETNAME of the IDLIST.

 13. FCU: Formatting code. Keep the default printer setting that is present when the screen appears. If blank, enter HPL180.

 17. PARAM1 ROLL TYPE: Enter any valid roll type.

 18. PARAM2 RPT TYPE(OA/OD/T/A/D/OBD/DB):

“OD”   = print out of balance parcels details.

“D”      = print all parcels details by payment sequence.

“OA”    = print out of balance parcels and totals.

“A”       = print all parcels details and totals.

“T”       = print totals.

“OBD” = prints out of balance parcels details by payment sequence only.

“DB”    = prints all parcels details.

Default is “A”.

 19. PARAM3 RUN BY: See table before Report Sample.

 20. PARAM4 PYMTS ONLY(Y/N): Enter “Y” to report payments only. Enter “N” to report all transactions that occurred on payments. For example, reversal and reposting of payments during adjustments (on TX13, “TAXADJ”) or posting payments with a backdated effective date (on RECO/SII/PY31, “PAYADJ”).

 21. PARAM5 INCL PROJNO(C/R/S):

         Enter ‘C’ to include all parcels.

         Enter ‘R’ to include only parcels where project number is null.

         Enter ‘S’ to include only parcels with a project number.

         This is used only in the last section of the output.

 

Press [Submit Job]. The system will notify you when the report is finished.

 

If PARAM3 is:

Produces:

Batch

BATCH information in column between BUSINESS DATE and WEN. Group totals do not print.

Batch, Print

BATCH information in column between BUSINESS DATE and WEN. Group totals are printed.

PYMTSRC

(Default)

PYMTSOURCE information in column between BUSINESS DATE and WEN. Group totals will not print.

PYMTSRC, PRINT

 

PYMTSOURCE information in column between BUSINESS DATE and WEN. Group totals are printed.

WHO

Produces a file with all records handled by the user or users whose initials were entered, placed in the WHO column between BUSINESS DATE and WEN. Group totals do not print.

WHO, PRINT

Produces a file with all records handled by the user or users whose initials were entered, placed in the WHO column between BUSINESS DATE and WEN. Group totals are printed.

REPORT SAMPLE


Payment Totals by a Range of Business Dates


Payment Totals by Business Date & Pymtsource for Out of Balance Conditions

 


Parcel Details By Payment Sequence For Out of Balance Conditions or Parcel Details


Payment Distribution by Business Date

 

 

 

Sample output showing no out of balance parcels for dates chosen.

Sample output showing no data existing.

Payment Totals by Business Date for Out of Balance Conditions

 

Updated 7/25/2006