Arcoro Payroll offers a variety of reports to help you better visualize and review your organization's payroll and payroll-related data, such as job costing, deductions, and more.

Some columns for reports will differ depending on your organization's regions (i.e., State, City, etc.) and benefits. 

We currently offer the following reports for Payroll.

• Payroll Journal
• Payroll Summary
• Tax Liabilities
• Contractor Payments
• W-2 Preview
• W-4 Exempt Status
• Pay Schedule
• Payroll Register
• Deduction Register
• Job Costing
• Payroll Compare
• Audit History
• Certified Payroll
• General Ledger
• Invalid SSN
• Contractor Validation Issues
• Contractor Payments

Payroll Journal

View employees' past earnings, deductions, and taxes by payroll. General Ledger Mapping can also be used with the Payroll Journal report to customize the metadata for payroll line items. The columns in the report will be the same whether using the general ledger mapping or not.

The report offers the following options:

• Starting Payday - (Required) Return payrolls with a payday on or after this date.
• Ending Payday - (Required) Return payrolls with a payday before or on this date.
• Include Contractors - Enable to include information for any 1099 contractors paid through payroll.
• Include Taxable Wages - Enable to include taxable wage columns in the report.

Columns

The columns presented may differ between organizations depending on the taxes for the respective region and benefit elections.

• Employee ID
• Last Name
• First Name
• Department
• Period Start
• Period End
• Payday
• Payment Method
• Gross Total
• Net Pay
• Reimbursements
• Hourly (Regular) Amt
• Hourly (Regular) Hrs
• Salaried Amt
• Salaried Hrs
• Overtime Amt
• Overtime Hrs
• Paid Holiday Amt
• Paid Holiday Hrs
• Social Security Tax (EE)
• Federal Income Tax (EE)
• Medicare (EE)
• Additional Medicare (EE)
• Columns for Various Regional (i.e., State, City, etc.) taxes that Will Differ Between Organizations.
• Employer Social Security Tax (ER)
• Federal Unemployment Tax (ER)
• Employer Medicare Tax (ER)
• Columns for Various Unemployment Taxes that Will Differ Between Organizations.
• Columns for Various Benefits and Deductions that Will Differ Between Organizations.

Payroll Summary

View employees' past earnings, deductions, and taxes aggregated over a period.

The report offers the following options:

• Starting Payday - (Required) Return payrolls with a payday on or after this date.
• Ending Payday - Return payrolls with a payday before or on this date.
• Include Contractors - Enable to include payments made to contractors on payrolls.

Columns

The columns presented may differ between organizations depending on the taxes for the respective region, benefit elections, and deductions.

• Last Name
• First Name
• Contractor ID
• Contractor Business Name
• Gross Total
• Net Pay
• Reimbursements
• Hourly (Regular) Amt
• Hourly (Regular) Hrs
• Salaried Amt
• Salaried Hrs
• Overtime Amt
• Overtime Hrs
• Paid Holiday Amt
• Paid Holiday Hrs
• Social Security Tax (EE)
• Federal Income Tax (EE)
• Medicare (EE)
• Additional Medicare (EE)
• Columns for Various Regional (i.e., State, City, etc.) taxes that Will Differ Between Organizations.
• Employer Social Security Tax (ER)
• Federal Unemployment Tax (ER)
• Employer Medicare Tax (ER)
• Columns for Various Unemployment Taxes that Will Differ Between Organizations.
• Columns for Various Benefits and Deductions that Will Differ Between Organizations.

Tax Liabilities

View liabilities for taxes by payroll.

The report offers the following options:

• Starting Payday - Return tax liabilities from payrolls with a payday on or after this date.
• Ending Payday - Return tax liabilities from payrolls with a payday before or on this date.

Columns

The columns presented may differ between organizations depending on the taxes for the respective region, benefit elections, and deductions.

• Payroll ID
• Period Start
• Period End
• Payday
• EE Tax - Additional Medicare
• EE Tax - Medicare
• Columns for Various Regional (i.e., State, City, etc.) taxes that Will Differ Between Organizations.
• Columns for Various Unemployment Taxes that Will Differ Between Organizations.

Contractor Payments

View payments to contractors by payroll.

The report offers the following options:

• Starting Payday - (Required) Filter payrolls with a payday on or after this date.
• Ending Payday - Filter payrolls with a payday before or on this date.
• Include Drafts - Enable to include the report for contractor payments on draft payrolls.

Columns

• Payroll
• Period Start
• Period End
• Payday
• First Name
• Last Name
• Business
• Payment Method
• Amount
• Reimbursement
• Net Pay

W-2 Preview

Preview employee's W-2 data as of the current date for a specified year.

The report offers the following options:

• Year - (Required) Returns employee W-2 data related to this year.

Columns

• Employee Name
• Employee SSN - The SSN will be masked and not fully shown (e.g., XXX-XX-0000)
• Created At
• Employee Address
• Employer Address
• Employer FEIN
• Box 1 (Federal Taxable Wages)
• Box 2 (Federal Income Tax Withheld)
• Box 3 (Social Security Wages)
• Box 4 (Social Security Tax Withheld)
• Box 5 (Medicare wages and tips)
• Box 6 (Medicare tax withheld)
• Box 7 (Social security tips)
• Box 10 (Dependent Care Benefits)
• Box 12
• Box 14
• Box 15, 16, 17 (State Tax)
• Box 18, 19, 20 (Local Tax)

W-4 Exempt Status

View employee's Federal and State withholding exemption status as of the current date for a specified year.

The report offers the following options:

• Year - (Required) Returns exemptions for the given year. 

Columns

• Company ID
• Employee ID
• Employee Name
• Document Type
• Submission Date
• Exempt
• Signer Name

Pay Schedule

View Paydays for a specified date range.

The report offers the following options:

• Pay Schedule - (Required) The type of pay schedule.
• Start Year - (Required) Return pay schedule starting with the year entered.
• End Year - Return pay schedule ending with the year entered.

Columns

• Payday
• Period Start
• Period End
• Approval Deadline
• Impacted By Weekend Or Holiday

Payroll Register

Summarizes each employee's gross pay, benefits, deductions, taxes, and net pay for a specified date range.

The report offers the following options:

• Employee ID - Return payroll information related to this employee.
• Starting Payday - (Required) Return payrolls with a payday on or after this date.
• Ending Payday - Return payrolls with a payday before or on this date.

Columns

• Payroll Name
• Payroll Pay Day
• Payroll Start Date
• Payroll End Date
• Payroll Status
• Last Name
• First Name
• Employee ID
• Payment Method
• Earnings
• Additional Earnings
• Total Reimbursements
• PTO/Sick Leave
• Gross Pay
• Net Pay
• Regular HRS
• Overtime HRS
• Double Overtime HRS
• PTO HRS
• Sick HRS
• Other HRS
• Total HRS
• PTO Balance
• Sick Balance
• Reimbursements
• Reimbursements Amount
• Tax - Federal Income Tax
• Tax - Medicare
• Tax - Social Security Tax
• Organization Specific Columns - There may be various organization-specific columns that denote taxes, benefits, deductions, etc., such as, but not limited to:
  • Columns for Employee Taxes - The latter half of the header will denote the tax the employee is paying (e.g., “Tax Paid By Employee - Arizona State Tax”).
  • Columns for Employer Taxes - The latter half of the header will denote the tax the employer is paying (e.g., “Tax Paid By Company - Alabama State Unemployment Tax”).
  • Columns for Various Employee Benefits - The last three letters in the field title represent the benefit code (e.g., Benefit Paid By Company – DEN).
  • Columns for Various Deductions - The text after the "Deductions" will denote the name of the deduction (e.g., Deduction - Child Support).
• Warnings

Deduction Register

View employee deductions for a specified date range.

The report offers the following options:

• Pay Schedule - Return deductions for the selected pay schedule.
• Starting Payday - (Required) Return payrolls with a payday on or after this date.
• Ending Payday - Return payrolls with a payday before or on this date.
• Check Deductions to Include - Enable the appropriate check deductions to include in the report.

Columns

• PayGroup
• Payroll Pay Date
• Employee ID
• Last Name
• First Name
• Benefit/Deduction Name
• Amount

Job Costing

View labor costs, hours worked, and benefits grouped by payroll, workplace, and cost code. General Ledger Mapping can also be used with the Job Costing report to customize the metadata for payroll line items. The columns in the report will be the same whether using the general ledger mapping or not.

The report offers the following options:

• Starting Payday - (Required) Return payrolls with a payday on or after this date.
• Ending Payday - Return payrolls with a payday before or on this date.
• Work Location - Return costing based on the selected work location.

Columns

• Payroll
• Payroll Status
• Work Location
• Cost Code
• Hours Worked
• Labor Cost
• Fringe Benefits
• Total Labor Cost
• Date Range

Payroll Compare

Compare payroll metrics, such as employees paid, earnings, deductions, and hours, between two payrolls.

The report offers the following options:

• Pay Schedule - (Required) Select the Paygroup to find reports for.
• Payroll 1 - (Required) Select the first Payroll to be used for comparison.
• Payroll 2 - (Required) Select the second Payroll to be used for comparison.

Columns

• Payroll
• Payroll Status
• Work Location
• Cost Code
• Hours Worked
• Labor Cost
• Fringe Benefits
• Total Labor Cost
• Date Range

Audit History

View a detailed history of changes made within the system, including modifications to entities, user actions, and timestamps.

The report offers the following options:

• Start Date - Select the start date for audit data retrieval.
• End Date - Select the end date for audit data retrieval.

Columns

• Entity Key
• Descriptor
• Event
• Help
• Audited Entity
• Version
• Initiated By
• Change Date
• Changes

Certified Payroll

Certified allows you to create a CSV report in two formats: LCP Tracker and WH-347.

The following article goes into detail in how to generate the certified payroll report.

General Ledger

View payroll expenses as they are properly associated for financial reporting and reconciliation. This report will show all transactions by payroll for a given time frame.  Each of these transactions will be shown with the proper mapping information set up in the administrative mapping section.  This report will only show account mapping information for payrolls in a paid status.

The report offers the following options:

• Starting Payday - (Required) Return payrolls with a payday on or after this date.
• Ending Payday - Return payrolls with a payday before or on this date.
• Work Location - Return costing based on the selected work location.
• Journal Batch Name - Name to be used for this GL Report batch.

Columns

• Journal_Batch_Name
• Payroll_Name
• Pay_Date
• Employee_ID
• Employee_Name
• Item_Type
• Item_Name
• GL_Acct_Number
• Location
• Cost_Code
• Cost_Type
• Billable
• Debit_Amt
• Credit_Amt

Invalid SSN

The "Invalid SSN" report highlights employees whose SSN data is invalid, helping you fix issues that would otherwise prevent them from being paid.

The report can be generated as a CSV or PDF file.

Columns

• Employee ID
• Employee Name
• Termination Status

Contractor Validation Issues

The Contractor Validation Issues report lists contractors with validation issues (including identifier, name, error, and payroll ID) so you can quickly correct setup problems.

The report can be generated as a CSV or PDF file.

Columns

• Contractor Identifier
• Contractor Name
• Validation Error
• Payroll ID

Contractor Payments

Contractor Payments reports allow you to share and archive your data.

The report offers the following options:

• Starting Payday - (Required) Return payrolls with a payday on or after this date.
• Ending Payday - Return payrolls with a payday before or on this date.
• Include Drafts
• Format

Columns

• Payroll
• Period Start
• Period End
• Payday
• First Name
• Last Name
• Business
• Payment Method
• Amount
• Reimbursement
• Net Pay