Integrating Gusto with QuickBooks Online for Use with CostAllocation Pro

This guide explains a recommended setup for syncing payroll from Gusto into QuickBooks Online (QBO), then allocating payroll costs by grant and program using CostAllocation Pro.

Many nonprofit organizations process payroll through Gusto while maintaining their accounting records in QuickBooks Online. When preparing payroll data for allocation with CostAllocation Pro, a practical workflow is to let Gusto post a summarized journal entry into QBO, then use CostAllocation Pro to allocate those payroll costs by employee, grant (customer), program (class), and expense category.

At a glance
  1. Gusto posts a summarized payroll journal entry to QBO.
  2. Expense lines are typically left unclassified (no class/customer).
  3. Cash credits line up with payroll withdrawals, which helps bank reconciliations.
  4. CostAllocation Pro allocates payroll expenses by employee and assigns the correct customer/class coding.
  5. Before allocating, use CostAllocation Pro’s Expense Allocation tool to batch-assign the Payroll Cost Pool class.

Overview of the Recommended Workflow

  1. Gusto posts a summarized payroll journal entry into QBO.
  2. The payroll expense debits are generally unclassified in QBO.
  3. Cash or bank credit lines align with actual payroll withdrawals, which supports clean bank reconciliations.
  4. CostAllocation Pro allocates payroll expenses by employee, customer (grant), class (program), and expense category.
  5. The allocation journal entry posted by CostAllocation Pro reclassifies expenses to the appropriate grants and programs.

How Gusto Payroll Sync Works with QuickBooks Online

When Gusto syncs payroll to QBO, it typically posts one summarized journal entry per payroll run. That journal entry generally includes:

Debits (Expenses)

  • Salary and wage expense accounts
  • Employer payroll tax expense accounts
  • Employee benefit expense accounts

Credits

  • Cash or bank account used for payroll
  • Payroll liability accounts (when applicable)

Why this works well with CostAllocation Pro: Gusto’s sync is clean and reconciles well, and CostAllocation Pro can later distribute those expenses to the correct grants/programs while preserving expense categories for reporting.

Step 1: Connect Gusto to QuickBooks Online

  1. Log in to your Gusto account.
  2. In the bottom left corner, click App Directory.
  3. Search for QuickBooks Online.
  4. Click Manage to open the integration settings.
Gusto → QuickBooks Online integration: Manage settings

Step 2: Configure Detailed Account Mapping

In the QuickBooks Online integration settings inside Gusto, select Detailed Mapping. Detailed mappings allow each payroll component to map to a specific account in QBO.

Common categories to map
  • Wages and Salaries
  • Employer Taxes
  • Benefit Expenses
  • Benefit Liabilities
  • Deductions
  • Reimbursements
  • Tax Adjustments

If you’re missing an account from QBO, use Refresh chart of accounts in the mapping screen.

Use Detailed Mapping to map each payroll category to the appropriate QBO account

Step 3: Enable Automatic Journal Entry Sync

In the integration Manage settings, confirm the following:

  • Auto Sync: Enabled
  • Journal Entry Consolidation: Default

With these settings, Gusto will automatically post payroll journal entries into QBO after each payroll run.

Step 4: Understand the Payroll Cost Pool Requirement

CostAllocation Pro typically uses a Payroll Cost Pool class to temporarily hold payroll expenses before allocation. One common issue is that the Gusto-synced journal entry in QBO usually does not include a class on the expense lines, so those expense debits appear as unclassified.

Important: Before running payroll allocations in CostAllocation Pro, those unclassified payroll expenses generally need to be assigned to the Payroll Cost Pool class.

Step 5: Assign the Payroll Cost Pool Class Using CostAllocation Pro

To prepare payroll expenses for allocation:

  1. Open CostAllocation Pro.
  2. Go to the Expense Allocation feature.
  3. Filter for unclassified payroll expenses (the Gusto-synced expense lines).
  4. Select the relevant transactions.
  5. Use Batch Edit to assign the Payroll Cost Pool class.

After this step, payroll expenses should be staged in the payroll cost pool and ready for the payroll allocation workflow.

Step 6: Run Payroll Allocations in CostAllocation Pro

After the payroll cost pool class has been applied, run your normal payroll allocation workflow in CostAllocation Pro. CostAllocation Pro will typically:

  • Allocate payroll expenses by employee
  • Assign the correct customer (grant)
  • Assign the correct class (program)
  • Preserve expense categories such as wages, taxes, and benefits

The resulting journal entry synced back to QBO is typically a net zero reclassification entry that moves payroll costs out of the cost pool and into the correct grant/program coding.

Why This Method Works Well

  • Clean bank reconciliations: cash lines from Gusto align with actual payroll withdrawals.
  • Accurate grant reporting: payroll can be allocated to the correct grant and program.
  • Expense-category detail: wages, taxes, and benefits remain separated for reporting.
  • Simplified workflow: Gusto posts payroll, CostAllocation Pro allocates it.
 

Summary

When integrating Gusto with QuickBooks Online in preparation for using CostAllocation Pro:

  1. Connect Gusto to QuickBooks Online via the App Directory.
  2. Use Detailed Mapping to map payroll categories to QBO accounts.
  3. Enable Auto Sync.
  4. Set Journal Entry Consolidation to Default.
  5. Use CostAllocation Pro’s Expense Allocation tool to batch-assign the Payroll Cost Pool class to unclassified payroll expenses.
  6. Run payroll allocations in CostAllocation Pro to apply customer/class coding by employee and expense category.

For more resources, visit costallocationpro.com.