USPS Reports Guide –
USPS Reports by Number –
Report 961 Agency Accounting Control Totals
This report displays totals of the nightly payroll which are also contained in the accounting extract file. It can be used to validate and analyze the payroll data included in the extract.
Report Criteria
| Category | Payroll Administration |
|---|---|
| Distribution | Agency |
| Frequency | Runs each night. |
| Form | |
| Sort Sequence | |
| Page Break | |
| Parameters | HNK61 |
| Databases Used | H0A, H0B, H0C, H0I, HID, HMT, HN1, HNH, HNK, HNM, HNP, HNY |
| Selection Criteria | All employees on the payroll. |
| Produce Output? | Yes – Electronic Interface and Report |
| Request Screen | HNK61 – Set up selection criteria. |
| Posting Report? | |
| Additional Notes | This report prints for each document on the payroll, the document number and if there are multiple documents, a total for each item. (All values are derived from the current payroll.) |
Report Headings
- FLAG SETTINGS HNK61
- Displays the settings for the accounting extract as defined by the agency.
PD Payment Deduction Record PF Payment Federal Tax Record P Payment level information is desired L Labor level information is desired PS Payment State/Local Tax Record DC Defined Contribution Record I Insurance Record Y Produce with extract N Do not produce - DESCRIPTION DERIVED FROM CURRENT PAYROLL
- Displays the totals from the payroll processed.
- DOCUMENT DERIVED
- Displays the USAS number assigned to the payroll.
- GROSS
- Displays the gross amount of the payroll. All pays are included in the gross amount.
- NET
- Displays the net amount of the payroll. It is the sum of all warrants, checking and savings deposits.
- SAVINGS
- Displays the total of all savings deductions.
- CHECKING
- Displays the total of all checking deductions.
- WARRANT
- Displays the total of all employee warrants.
- OASDI TAXABLE WAGES
- Displays the total OASDI taxable wages paid on the payroll.
- OASDI TAX
- Displays the total OASDI tax withheld on the payroll.
- STATE PAID OASDI TAX
- Displays the state-paid OASDI tax for the payroll.
- HI TAXABLE WAGES
- Displays the total HI taxable wages paid on the payroll.
- HI TAX
- Displays the total HI tax withheld on the payroll.
- STATE PAID HI TAX
- Displays the state paid HI tax for the payroll.
- FIT TAXABLE WAGES
- Displays the total FIT taxable wages paid on the payroll.
- FIT NON-TAXABLE WAGES
- Displays the total FIT non-taxable wages paid on the payroll.
- FIT WITHHELD
- Displays the total FIT withheld on the payroll.
- EMPLOYEE RETIREMENT
- Displays the total Employee retirement withheld on the payroll.
- EMPLOYER RETIREMENT
- Displays the total Employer state paid match for retirement paid on the payroll.
- PAYROLL RETIREMENT CONTRIBUTION
- Displays the total agency paid retirement contribution paid on the payroll.
- EMPLOYEE INSURANCE
- Displays the total employee insurance withheld on the payroll.
- STATE PAID INSURANCE
- Displays the total employer state-paid match for insurance and state-paid health savings account paid on the payroll.
- ST PD PAYROLL HLTH INS CONT
- Displays the total agency paid payroll health insurance contribution paid on the payroll.
- STATE PAID SKIP INSURANCE
- Displays the total Employer SKIP contribution for health insurance paid on the payroll.
- STATE PAID OPT OUT
- Displays the total credit paid by the state for the employee paid on the payroll.
- TOTAL HOURS PAID
- Displays the total of all hours paid on the payroll. This total includes regular, overtime, compensatory time, shift time, lump sum and all other special pay hours.
- PAYMENT (P) RECORDS WRITTEN
- Displays the number of records written in the P segment of the extract file.
- LABOR (PL) RECORDS WRITTEN
- Displays the number of records written in the PL segment of the extract file.
- DEDUCTION (PD) RECORDS WRITTEN
- Displays the number of records written in the PD segment of the extract file.
- FEDERAL TAX (PF) RECORDS WRITTEN
- Displays the number of records written in the FP segment of the extract file.
- STATE/LOCAL TAX (PS) RECORDS WRITTEN
- Displays the number of records written in the PS segment of the extract file.
- DEFINED CONTRIB (DC) RECORDS WRITTEN
- Displays the number of records written in the DC segment of the extract file.
- INSURANCE (I) RECORDS WRITTEN
- Displays the number of records written in the I segment of the extract file.
- TOTAL DOCUMENT RECORDS WRITTEN
- Displays the total number of records written for the document. This includes all segment records and the two records for the header and trailer.
- TOTAL AGENCY RECORDS WRITTEN
- Displays the total number of records written for the payroll. This includes all segment records, the document records and the two records for the agency header and trailer.
Sample Report
REPORT: 961 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 1
AGENCY: XXX XXXXXXXXXXXXXXXXXXXXXXXX RUN DATE: XX/XX/20XX
AGENCY ACCOUNTING CONTROL TOTALS RUN TIME: 13:29:00
FLAG SETTINGS: PD = L PF = L PS = Y DC = Y I = Y
DOCUMENT
DESCRIPTION XXXXXXXX
----------------- ------------
GROSS 2,842,536.86
NET 2,133,547.71
SAVINGS 31,072.82
CHECKING 1,598,737.07
WARRANT 503,737.82
OASDI TAXABLE WAGES 2,734,936.74
OASDI TAX 114,890.31
STATE PAID OASDI TAX 169,604.74
HI TAXABLE WAGES 2,734,936.74
HI TAX 39,656.52
STATE PAID HI TAX 39,656.52
FIT TAXABLE WAGES 2,565,239.31
FIT NON-TAXABLE WAGES 277,297.55
FIT WITHHELD 264,838.05
EMPLOYEE RETIREMENT 138,843.32
EMPLOYER RETIREMENT 146,666.73
PAYROLL RETIREMENT CONTRIBUTION 0.00
EMPLOYEE INSURANCE 87,601.68
STATE PAID INSURANCE 338,026.99
ST PD PAYROLL HLTH INS CONT 145.41
STATE PAID SKIP INSURANCE 276.52
STATE PAID OPT OUT 90.00
TOTAL HOURS PAID 167,663.64
PAYMENT (P) RECORDS WRITTEN 1,191
LABOR (PL) RECORDS WRITTEN 1,875
DEDUCTION (PD) RECORDS WRITTEN 1,565
FEDERAL TAX (PF) RECORDS WRITTEN 1,875
STATE/LOCAL TAX (PS) RECORDS WRITTEN 0
DEFINED CONTRIB (DC) RECORDS WRITTEN 376
INSURANCE (I) RECORDS WRITTEN 1,080
TOTAL DOCUMENT RECORDS WRITTEN 7,964
TOTAL AGENCY RECORDS WRITTEN 7,966