State quarterly payroll report

State quarterly payroll reports, also known as employer wage reports, quarterly contribution or wage detail reports, are the reports filed by an employer on a quarterly basis with each state, district and territory in which the borrower pays employees in order to stay compliant with paying State Unemployment Insurance (SUTA). They usually contain information such as:

  • Per employee report detailing gross pay for the quarter
  • Other payroll information such as group health benefits, retirement benefits, state taxes and local taxes from the applying entity

The form_type parameter STATE_QUARTERLY_PAYROLL_REPORT for the Upload PDF endpoint is required for this form type.

Optional fields captured

📘

Configuration-driven output

All fields below are optionally captured, depending on your order form. To adjust fields captured, please speak with your Ocrolus Account Manager.

JSON attribute

Data type

Description

state_quarterly_payroll_report-part1:employerName

Text

Name of the employer

state_quarterly_payroll_report-part1:employerAddress:addressLine1

Text

Address of the employer

state_quarterly_payroll_report-part1:employerAddress:addressLine2

Text

Address 2 of the employer.

state_quarterly_payroll_report-part1:employerAddress:city

Text

City of the employer.

state_quarterly_payroll_report-part1:employerAddress:state

Text

State of the employer.
Formatted 2 character state code.

state_quarterly_payroll_report-part1:employerAddress:zip

Text

ZIP code of the employer. Formatted 5 digit ZIP code.

state_quarterly_payroll_report-part1:employerTin/Fein

Text

Federal Tax Identification Number (TIN) of the employer. This federal TIN/EIN is issued by the IRS.

state_quarterly_payroll_report-part1:employerStateAccountNumber

Text

Employer's state employment commission account number. This differs from the IRS-issued FEIN/TIN.

state_quarterly_payroll_report-part2:year

Text

Year of the payroll report.

state_quarterly_payroll_report-part2:quarterEnding

Date

Last day of the quarter for which the report was filed.

For example, a Q1 2020 report would be 03/31/2020.

state_quarterly_payroll_report-part2:totalEmployeeWages

Money

Total collective wages paid to all employees

state_quarterly_payroll_report-part2:numberOfEmployeesMonth1

Text

Employee count for month 1

state_quarterly_payroll_report-part2:numberOfEmployeesMonth2

Text

Employee count for month 2

state_quarterly_payroll_report-part2:numberOfEmployeesMonth3

Text

Employee count for month 3

Optional line item fields captured

📘

Form-driven output

column_ids associated with the table object will be a subset of the following list that matches the line item headers as they appear on the specific form.

Column ID

Data type

Description

employeeTaxId

Text

Tax Identification Number/Social Security Number of the employee.

firstName

Text

First name of the employee.

middleInitial

Text

Middle initial of the employee.

lastName

Text

Last name of the employee.

perEmployeeWage

Money

Employee’s wages for the quarter

Sample form

Sample JSON result

{
  "form_type": "STATE_QUARTERLY_PAYROLL_REPORT",
  "pk": 7590105,
  "form_config_pk": 2131,
  "raw_fields": {
    "state_quarterly_payroll_report-part1:employerAddress:addressLine1": {
      "alias_used": null,
      "is_empty": false,
      "page_doc_pk": 71815621,
      "source_filename": "Sample 5 - Quarterly Payroll.pdf",
      "value": "901 ROUTE 110"
    },
    "state_quarterly_payroll_report-part1:employerAddress:addressLine2": {
      "alias_used": null,
      "is_empty": true,
      "page_doc_pk": 71815621,
      "source_filename": "Sample 5 - Quarterly Payroll.pdf",
      "value": ""
    },
    "state_quarterly_payroll_report-part1:employerAddress:city": {
      "alias_used": null,
      "is_empty": false,
      "page_doc_pk": 71815621,
      "source_filename": "Sample 5 - Quarterly Payroll.pdf",
      "value": "FARMINGDALE"
    },
    "state_quarterly_payroll_report-part1:employerAddress:state": {
      "alias_used": null,
      "is_empty": false,
      "page_doc_pk": 71815621,
      "source_filename": "Sample 5 - Quarterly Payroll.pdf",
      "value": "NY"
    },
    "state_quarterly_payroll_report-part1:employerAddress:zip": {
      "alias_used": null,
      "is_empty": false,
      "page_doc_pk": 71815621,
      "source_filename": "Sample 5 - Quarterly Payroll.pdf",
      "value": "11735"
    },
    "state_quarterly_payroll_report-part1:employerName": {
      "alias_used": null,
      "is_empty": false,
      "page_doc_pk": 71815621,
      "source_filename": "Sample 5 - Quarterly Payroll.pdf",
      "value": "AMIGO ENERGY"
    },
    "state_quarterly_payroll_report-part1:employerStateAccountNumber": {
      "alias_used": null,
      "is_empty": false,
      "page_doc_pk": 71815621,
      "source_filename": "Sample 5 - Quarterly Payroll.pdf",
      "value": "568000123"
    },
    "state_quarterly_payroll_report-part1:employerTin/Fein": {
      "alias_used": null,
      "is_empty": false,
      "page_doc_pk": 71815621,
      "source_filename": "Sample 5 - Quarterly Payroll.pdf",
      "value": "46-5684522"
    },
    "state_quarterly_payroll_report-part2:numberOfEmployeesMonth1": {
      "alias_used": null,
      "is_empty": false,
      "page_doc_pk": 71815621,
      "source_filename": "Sample 5 - Quarterly Payroll.pdf",
      "value": "17"
    },
    "state_quarterly_payroll_report-part2:numberOfEmployeesMonth2": {
      "alias_used": null,
      "is_empty": false,
      "page_doc_pk": 71815621,
      "source_filename": "Sample 5 - Quarterly Payroll.pdf",
      "value": "16"
    },
    "state_quarterly_payroll_report-part2:numberOfEmployeesMonth3": {
      "alias_used": null,
      "is_empty": false,
      "page_doc_pk": 71815621,
      "source_filename": "Sample 5 - Quarterly Payroll.pdf",
      "value": "19"
    },
    "state_quarterly_payroll_report-part2:quarterEnding": {
      "alias_used": null,
      "is_empty": false,
      "page_doc_pk": 71815621,
      "source_filename": "Sample 5 - Quarterly Payroll.pdf",
      "value": "06/30/2011"
    },
    "state_quarterly_payroll_report-part2:totalEmployeeWages": {
      "alias_used": null,
      "is_empty": false,
      "page_doc_pk": 71815621,
      "source_filename": "Sample 5 - Quarterly Payroll.pdf",
      "value": "24000"
    },
    "state_quarterly_payroll_report-part2:year": {
      "alias_used": null,
      "is_empty": false,
      "page_doc_pk": 71815621,
      "source_filename": "Sample 5 - Quarterly Payroll.pdf",
      "value": "2011"
    }
  },
  "tables": [
    {
      "columns": [
        {
          "alias_used": "Employee Tax ID",
          "column_id": "employeeTaxId"
        },
        {
          "alias_used": "First Name",
          "column_id": "firstName"
        },
        {
          "alias_used": "Middle Initial ",
          "column_id": "middleInitial"
        },
        {
          "alias_used": "Last Name",
          "column_id": "lastName"
        },
        {
          "alias_used": "Per Employee Wage",
          "column_id": "perEmployeeWage"
        }
      ],
      "pk": 10994,
      "rows": [
        {
          "cells": {
            "employeeTaxId": {
              "value": "456584116"
            },
            "firstName": {
              "value": "RONNY"
            },
            "lastName": {
              "value": "THOR"
            },
            "middleInitial": {
              "value": "M"
            },
            "perEmployeeWage": {
              "value": "6000"
            }
          },
          "page_doc_pk": 71815621,
          "page_idx": 0
        },
        {
          "cells": {
            "employeeTaxId": {
              "value": "456194511"
            },
            "firstName": {
              "value": "ENJALA"
            },
            "lastName": {
              "value": "LOOM"
            },
            "middleInitial": {
              "value": "D"
            },
            "perEmployeeWage": {
              "value": "6000"
            }
          },
          "page_doc_pk": 71815621,
          "page_idx": 0
        },
        {
          "cells": {
            "employeeTaxId": {
              "value": "659848466"
            },
            "firstName": {
              "value": "HARRY"
            },
            "lastName": {
              "value": "PORTER"
            },
            "middleInitial": {
              "value": "G"
            },
            "perEmployeeWage": {
              "value": "6000"
            }
          },
          "page_doc_pk": 71815621,
          "page_idx": 0
        },
        {
          "cells": {
            "employeeTaxId": {
              "value": "325642566"
            },
            "firstName": {
              "value": "MIKKY"
            },
            "lastName": {
              "value": "BRANDOM"
            },
            "middleInitial": {
              "value": "S"
            },
            "perEmployeeWage": {
              "value": "6000"
            }
          },
          "page_doc_pk": 71815621,
          "page_idx": 0
        }
      ]
    }
  ]
}

Did this page help you?