Page History

...

•  7. Run QRTRPT selecting the demand option (N).
•  

  8.  In the "Totals" section of QRTRPT, the gross and adjusted gross should balance using a manual calculation

  
  

  Panel
  Gross   - Annuities Adjusted gross calculated

  
  

  Tip
  The Adjusted gross calculated should equal the adjusted gross amount from QRTRPT. This should be true for all adjusted gross figures in the "Totals" section

  
  

•  

  9. All deduction checks for the quarter should equal the total deductions showing on QRTRPT.  Be sure to verify all electronic payments as well.

  • CHKSTS can be run to generate a listing of deduction check totals.
    • Sort Option = C
    • Print Option = A
    • Check Type = D, E, G
    • Leave all other selection fields blank

•  10. The total gross showing on QRTRPT should equal the total of all payroll clearance checks created for the quarter.
  • CHEKPY can be run to generate a listing of all payroll clearance check.
    • Sort options = C
    • Sub-total by vendor = N
    • Print missing check numbers = N
    • Check types to select = P
    • Check statuses to select = leave blank
    • Print vendor from PO or check = P
    • Date Selection = first day in quarter to last day of quarter
    • Check Selection = leave blank
    • Summary or Detail report = S
    • Single or Double space summary report = S

•  
•  

  11. The total gross showing on QRTRPT should equal the total of all payroll clearance checks created during CHKUPD for the quarter.

  • CHEKPY can be run to generate a listing of all payroll clearance check.
    
    • Sort options = C
    • Sub-total by vendor = N
    • Print missing check numbers = N
    • Check types to select = P
    • Check statuses to select = leave blank
    • Print vendor from PO or check = P
    • Date Selection = first day in quarter to last day of quarter
    • Check Selection = leave blank
    • Summary or Detail report = S
    • Single or Double space summary report = S

   12. It is recommended that you balance the W2REPT quarterly to minimize problems at calendar year-end.

  •  Run W2PROC (saying "N" to Create Tape file prompt) to generate W2 reports.
    • Balance the deduction totals (taxes and annuities) on the W2REPT.TXT report with the totals from the PAYDED.TXT reports from the quarter.

    • Balance the gross amounts on the W2REPT.TXT report with BUDDIS.TXT reports for the quarter.

      
      

      Tip
      These amounts may not balance due to the way W2PROC handles certain amounts (e.g. Medicare pickup). If errors are discovered, check employees that had exception processing during the quarter such as voided checks, error adjustments, or manual changes in USPSCN.  The AUDPRT can be useful in identifying these problems.

      
      

  •  

    Complete and balance the W2REPT Reconciliation Worksheet for the quarter following the directions on the worksheet.

•  

  1312. Run PAYDED to generate a non-zero deduction listing.  This will assure all deductions have been paid to date.

  • Under Selection Criteria:

    • Payment option = A
    • Pay cycle = leave blank
    • Deduction codes = leave blank

  • Once the report is generated, view the DEDRPT.TXT and verify that there are no outstanding deduction amounts.

•  

  1413. The total of all board paid amounts (if tracked on the system) should equal the total of all warrant checks to the vendor or deduction company.

  • CHEKPY can be run to generate a listing of all board paid deduction checks.
    • Sort options = C
    • Sub-total by vendor = Y
    • Print missing check numbers = N
    • Check types to select = M,W
    • Check statuses to select = leave blank
    • Print vendor from PO or check = P
    • Date Selection = January 1, XXXX to last day of quarter
    • Check Selection = leave blank
    • Summary or Detail report = S
    • Single or Double space summary report = S
    • Include or Exclude the following vendors? = I
    • Vendors = enter the vendor numbers for all board paid deductions
•  

  1514. Complete and file any required quarter-end submission forms.

•  

  1615. For city withholding, take the total gross on W2REPT.TXT times the city tax percentage.  The calculated figure should equal the amount listed on the W2REPT.TXT.  This amount should also equal the total checks submitted. 

  • CHKSTS can be run to generate a report of all checks created.

    • Sort Option = C

    • Print Option = A

    • Check Type = A

    • Specific Deduction Codes = enter all city deduction codes

    • Check Selection = leave blank

    • Issue Date = 01/01/XXXX to last day in quarter

•  1716.  Process ODJFS report and submission file.
  • Run ODJFSRPT for verification purposes.
    • Create a submission file = N
    • Reporting Year = enter appropriate year
    • Reporting Quarter = enter appropriate quarter
    • Max number of weeks = number of Saturdays in the quarter
    • District name = should default
    • Street address = should default
    • City = should default
    • State = should default
    • Zip = should default
  • Review ODJFSRPT.TXT.  If adjustments are necessary, USPSCN/ATDSCN - AD/OB can be entered.
  • Run ODJFSRPT to create the tape file.
    • Create a submission file = Y
    • Reporting Year = enter appropriate year
    • Reporting Quarter = enter appropriate quarter
    • Max number of weeks = number of Saturdays in the quarter
    • District name = should default
    • Street address = should default
    • City = should default
    • State = should default
    • Zip = should default

•  17. Send an email to mail_staff_fis@nwoca.org and inform them that you have created the ODJFS tape file.

...

•  18. Only if hard copies of quarter end reports are desired, run the following:
  •  

     USRPT/EMPMST (all data)

  •  

     USPRPT/ERNSUM (all data for the quarter) – condensed version of ERNREG (170 column report)

  •  

     ERNREG – (all data for the quarter)

  •  

     QRTRPT – (all data –demand report)

...

...