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 attributeData typeDescription
state_quarterly_payroll_report-part1:employerNameTextName of the employer
state_quarterly_payroll_report-part1:employerAddress:addressLine1TextAddress of the employer
state_quarterly_payroll_report-part1:employerAddress:addressLine2TextAddress 2 of the employer.
state_quarterly_payroll_report-part1:employerAddress:cityTextCity of the employer.
state_quarterly_payroll_report-part1:employerAddress:stateTextState of the employer. Formatted 2 character state code.
state_quarterly_payroll_report-part1:employerAddress:zipTextZIP code of the employer. Formatted 5 digit ZIP code.
state_quarterly_payroll_report-part1:employerTin/FeinTextFederal Tax Identification Number (TIN) of the employer. This federal TIN/EIN is issued by the IRS.
state_quarterly_payroll_report-part1:employerStateAccountNumberTextEmployer's state employment commission account number. This differs from the IRS-issued FEIN/TIN.
state_quarterly_payroll_report-part2:yearTextYear of the payroll report.
state_quarterly_payroll_report-part2:quarterEndingDateLast 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:totalEmployeeWagesMoneyTotal collective wages paid to all employees
state_quarterly_payroll_report-part2:numberOfEmployeesMonth1TextEmployee count for month 1
state_quarterly_payroll_report-part2:numberOfEmployeesMonth2TextEmployee count for month 2
state_quarterly_payroll_report-part2:numberOfEmployeesMonth3TextEmployee count for month 3

Optional line item fields captured

📘

Form-driven output

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

Column IDData typeDescription
employeeTaxIdTextTax Identification Number/Social Security Number of the employee.
firstNameTextFirst name of the employee.
middleInitialTextMiddle initial of the employee.
lastNameTextLast name of the employee.
perEmployeeWageMoneyEmployee’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
        }
      ]
    }
  ]
}