Workflow · People · Opening soon

Reconcile Gusto payroll to QuickBooks

Reconcile Gusto payroll runs against QuickBooks payroll journal entries. Compare wages, taxes, and benefits, then see which runs agree and which need attention.

Book a demo

Someone typed

“match each gusto payroll run to the quickbooks payroll journals, compare wages taxes and benefits, and show every run with a status of Agrees, Missing journal, Duplicate posting, or Amount off”

The agent read it as

match each Gusto payroll runs payroll run to the QuickBooks payroll journal entries, compare wages taxes and benefits, and show every run with a status of Agrees, Missing journal, Duplicate posting, or Amount off

What the agent built

3 steps, each one an ordinary Mammoth step you can open and change.

File

Gusto payroll runs

CSV export · 12 rows

File

QuickBooks payroll journal entries

CSV export · 44 rows

Step

Summarize by run

Step 1

Join

Add journal summary

10 of 12 paired

Step

Set status

Step 3

Result

Payroll journal flags

12 rows · 4 flagged

Schedule

Runs when you say

Proposed

File
Gusto payroll runs
CSV export · 12 rows
File
QuickBooks payroll journal entries
CSV export · 44 rows
Step
Summarize by run
Step 1
Join
Add journal summary
10 of 12 paired
Step
Set status
Step 3
Result
Payroll journal flags
12 rows · 4 flagged
Schedule
Runs when you say
Proposed

Checked on the sample files: every step ran, 12 rows came out, and the join paired 10 of 12 rows.

Download Gusto payroll runs sample (12 rows)Gusto: Payroll > Payroll history > Export CSV
Download QuickBooks payroll journal entries sample (44 rows)QuickBooks: Reports > Journal > Export

What you get back

The result of that run, the rows to look at first.

Payroll journal flagsSample data12 rows

8 agrees1 amount off1 duplicate posting2 missing journal

Payroll ID	Payroll date	Wages	Taxes	Benefits	Journal count	QB wages	QB taxes	QB benefits	Status
gusto_pr_2026_10_09_02	2026-10-09	17,380	3,605	604	·	·	·	·	Missing journal
gusto_pr_2026_10_23_02	2026-10-23	16,995	3,527	596	·	·	·	·	Missing journal
gusto_pr_2026_10_09_01	2026-10-09	20,760	4,307	690	2	41,520	8,614	1,380	Duplicate posting
gusto_pr_2026_10_16_01	2026-10-16	19,640	4,072	655	1	19,640	3,922	655	Amount off
gusto_pr_2026_09_04_01	2026-09-04	18,450	3,825	620	1	18,450	3,825	620	Agrees
gusto_pr_2026_09_11_01	2026-09-11	19,280	3,992	640	1	19,280	3,992	640	Agrees
gusto_pr_2026_09_18_01	2026-09-18	17,640	3,659	615	1	17,640	3,659	615	Agrees
gusto_pr_2026_09_25_01	2026-09-25	20,115	4,164	668	1	20,115	4,164	668	Agrees
gusto_pr_2026_10_02_01	2026-10-02	18,890	3,918	632	1	18,890	3,918	632	Agrees
gusto_pr_2026_10_02_02	2026-10-02	16,425	3,407	590	1	16,425	3,407	590	Agrees
gusto_pr_2026_10_16_02	2026-10-16	18,205	3,775	623	1	18,205	3,775	623	Agrees
gusto_pr_2026_10_23_01	2026-10-23	21,410	4,442	710	1	21,410	4,442	710	Agrees

12 rows in the result. Sample data: illustrative figures, not business results.

How do you reconcile Gusto payroll to QuickBooks?

Export payroll run totals from Gusto and payroll journal entries from QuickBooks. Load both files, then match each run, compare wages, taxes, and benefits, and set a status for each one. You can see Agrees, Missing journal, Duplicate posting, or Amount off.

How it works

How to use the Payroll journal flags workflow

1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Payroll journal flags: questions

Which export should you use from Gusto and QuickBooks?

Use the export that shows each payroll run from Gusto and the export that shows payroll journal entries from QuickBooks. The workflow needs one row per run or journal entry, with the amounts you want to compare.

What happens to runs that do not match a journal entry?

They are still shown in the result. A run can be marked Missing journal, Duplicate posting, or Amount off, so you can review the difference instead of losing the row.

How do you change the matching rules?

You change the rules by editing the steps in words. For example, you can change how runs are grouped, which amounts are compared, and which status is assigned when values do not line up.