FROM OUR BLOG

FROM OUR BLOG

FROM OUR BLOG

Gusto + Cap

Sep 25, 2024

Gusto + CostAllocation Pro can be a great combination to track and allocate payroll cost by customer/class. These instructions will provide guidance on which Gusto reports work best with CostAllocation Pro.

This workflow uses a Payroll Cost Pool Class. The Payroll Cost Pool will need to be added to your QBO class list if you do not already have that account set up.

To properly configure the GUSTO General Ledger:

  • Go to “App directory”

  • Click QuickBooks Online

  • Map the GUSTO categories to the appropriate accounts in QBO.

Each month, when running the allocation you’ll need to pull a couple reports from Gusto to use in CAP for the allocations.

First, let’s pull the report needed for employee cost reporting.

Log into Gusto

  • In the ”Reports” section, run the “Payroll Journal” report

Choose “Summary Only” in the dropdown selection for “Report Sections”

  • Check the boxes for the following

    • Employee earnings breakdown

    • Employer tax breakdown

    • Deductions and contributions

    • Reimbursements

  • Set the Date Range for “Monthly”, or the appropriate date range for your allocation.

  • Select the appropriate month.

  • Select “All Employees” option

  • In the “Group by” section, select Employee

  • Export the report to csv

Log into CAP

  • Create the pay period

    • The pay period should match the beginning and ending dates of the payroll reports. See the image from a Gusto report showing the pay period beginning and ending date.

    • Upload employee costs. The Gusto Payroll Journal report provides the information needed. You may also have 3rd party paid fringe benefits that you will need to use the invoice from the 3rd party.

  • Review time logs and apply Custom Time Rules (If applicable)

  • Create Timesheet

  • Review Cost Allocation

  • Publish journal entry into QBO

Gusto + CostAllocation Pro can be a great combination to track and allocate payroll cost by customer/class. These instructions will provide guidance on which Gusto reports work best with CostAllocation Pro.

This workflow uses a Payroll Cost Pool Class. The Payroll Cost Pool will need to be added to your QBO class list if you do not already have that account set up.

To properly configure the GUSTO General Ledger:

  • Go to “App directory”

  • Click QuickBooks Online

  • Map the GUSTO categories to the appropriate accounts in QBO.

Each month, when running the allocation you’ll need to pull a couple reports from Gusto to use in CAP for the allocations.

First, let’s pull the report needed for employee cost reporting.

Log into Gusto

  • In the ”Reports” section, run the “Payroll Journal” report

Choose “Summary Only” in the dropdown selection for “Report Sections”

  • Check the boxes for the following

    • Employee earnings breakdown

    • Employer tax breakdown

    • Deductions and contributions

    • Reimbursements

  • Set the Date Range for “Monthly”, or the appropriate date range for your allocation.

  • Select the appropriate month.

  • Select “All Employees” option

  • In the “Group by” section, select Employee

  • Export the report to csv

Log into CAP

  • Create the pay period

    • The pay period should match the beginning and ending dates of the payroll reports. See the image from a Gusto report showing the pay period beginning and ending date.

    • Upload employee costs. The Gusto Payroll Journal report provides the information needed. You may also have 3rd party paid fringe benefits that you will need to use the invoice from the 3rd party.

  • Review time logs and apply Custom Time Rules (If applicable)

  • Create Timesheet

  • Review Cost Allocation

  • Publish journal entry into QBO

Subscribe to our newsletter

Stay up to date on all of our latest updates and enhancements.

Subscribe to our newsletter

Stay up to date on all of our latest updates and enhancements.

Subscribe to our newsletter

Stay up to date on all of our latest updates and enhancements.