Skip to main content

Gusto Payroll: Data Extraction Guide

Guide users to grant Gusto payroll access or extract required data for setup.

This guide walks you through how to grant access to Gusto, OR extract the required data so we can complete your setup successfully.
​

When migrating to Salaris Payroll, there are two options to migrate data. You may choose to:

  • Grant access to our payroll administrators or

  • Pull the required reports yourself

Option #1: Granting Access to Gusto

Only the Account Owner (Primary Admin) can add an external collaborator. If you are not the Account Owner, please ask them to complete these steps.

  1. Log in to Gusto as the Primary Admin.

  2. Go to People.

  3. Next to Add person, select the dropdown arrow and choose Add collaborator.

  4. Under Relationship to your organization, select Accountant.

  5. Enter the following information:

    • First Name: Payroll

    • Last Name: Setup

    • Email: [Insert Salaris Payroll email]

  6. Under Access level, select All access.

  7. Select Save collaborator.

Our team will accept the invitation and take it from there.

Option #2: Gusto Data Extraction

Pull the following reports from Gusto:

  • Employee and Contractor Demographics

  • Employee Deductions

  • Direct Deposit Information

  • Historical Payrolls (open and closed quarters)

  • Subject Wages

  • Company Tax Information

  • Tax Returns

Employee and Contractor Demographics

Employee Demographics

💡 The Employee Summary report includes employee information, compensation, tax withholdings, and earning rates.

  1. Go to Reports → Employee Summary.

  2. Set Employee Status to All, if available.

  3. Select CSV as the report format.

  4. Select Generate Report.

  5. Download the report.

Note: Include all employees paid during the current year, including terminated employees.

Contractor Demographics

  1. Go to Reports → Contractor Information (or Contractor Details, if shown).

  2. Generate and download the report.

Note: This report is only needed if you have contractors. Contractor SSNs and banking details may not be included.

Employee Deductions

  1. Go to Reports → Benefits Template.

  2. Select all active benefits.

  3. Select Continue, if prompted.

  4. Apply the following settings where available:

    • Zero Values: Hide rows and columns with zero values

    • Columns: Uncheck columns containing "Total"

    • Time Period: Custom Date

  5. Select the last payroll check date processed.

  6. If Custom Date is unavailable, select Payroll Pay Date as the time period basis.

  7. Generate and download the report in CSV format.
    Historical Payrolls: Payrolls for the Open Quarter

The open quarter is the current quarter that has not yet ended.

Payroll Journal

  1. Go to Reports → Payroll Journal.

  2. Select Summary and Individual Payroll Details, if using the legacy report.

  3. Include the following:

    • Employee earnings breakdown

    • Employer tax breakdown

    • Employee tax breakdown

    • Deductions and contributions

    • Detailed totals

    • Reimbursements

  4. Set Date Range to the current open quarter.

  5. Select All Employees.

  6. Set Group By to Employee.

  7. Generate and download the report in CSV format.

Note: Gusto's updated Payroll Journal may display different report settings. Ensure the downloaded report includes earnings, taxes, deductions, contributions, and reimbursements by employee.

Contractor Payments

If you have paid contractors during the current year:

  1. Go to Reports → Contractor Payments.

  2. Select the current year's applicable payroll dates.

  3. Generate and download the report.

Historical Payrolls: Payrolls for Closed Quarters

🚨 Download a separate Payroll Journal report for each closed quarter in the current year.

  1. Go to Reports → Payroll Journal.

  2. Use the same report settings as the open-quarter report.

  3. Set the date range for each closed quarter:

    • Q1: January 1 – March 31

    • Q2: April 1 – June 30

    • Q3: July 1 – September 30

  4. Generate and download each report in CSV format.

  5. Repeat for every closed quarter.

Important: Do not combine multiple quarters into one report.

Subject Wages

  1. Go to Reports → Subject Wages.

  2. Select the current year.

  3. Generate the report.

  4. Download in CSV format, if available.

📝 If you have employees in Minnesota, this report is needed to verify tax amounts for the Minnesota Workforce Development Fee.

Company Tax Information

To locate your company's tax IDs and rates:

  1. Go to Taxes & Compliance → Tax Setup.

  2. Locate your federal and state tax account information.

  3. Take screenshots showing the applicable tax IDs and rates.

Tax Returns

  1. Go to Taxes & Compliance → Tax Documents.

  2. Select the Federal tab.

  3. Download the available federal tax returns for each closed quarter.

  4. Select the State tab.

  5. Download the available state tax returns for each closed quarter.

  • If starting in Q1: Download the prior year's Q4 tax returns to confirm tax information.

  • If starting mid-year: Download each closed quarter's tax returns from the current year.

🚨 Obtaining closed-quarter tax filings is required. These documents allow Salaris Payroll to verify historical payroll and tax information for your migration.

Tax documents serve two purposes:

  • Verify payroll and tax totals for each closed quarter.

  • Provide the required information to complete your company tax setup.

What is this?

Final verification notes: The collaborator access steps, existence of the core Gusto reports, and tax document navigation are supported by current Gusto documentation. The exact Benefits Template filters, direct deposit export fields, and Subject Wages export format still need account-level verification.

Gusto Help Center+2

I would confirm those three items before publishing rather than risk directing customers to controls they may not have.

Did this answer your question?