Workflow · People · Opening soon

Reconcile ADP payroll to the GL

Export the ADP payroll register and the payroll GL postings. Mammoth groups both by pay date, compares regular wages and payroll taxes, and shows where they agree or differ.

Book a demo

Someone typed

“tie the adp payroll register to the gl by pay date, show regular wages and payroll taxes totals with a status column: Agrees when they match, Missing when the gl is short, Extra when the gl is high”

The agent read it as

tie the ADP Payroll Register to the ADP Payroll GL Postings by pay date, show regular wages and payroll taxes totals with a status column: Agrees when they match, Missing when the gl is short, Extra when the gl is high

What the agent built

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

File

ADP Payroll Register

CSV export · 20 rows

File

ADP Payroll GL Postings

CSV export · 16 rows

Step

Sum by pay date

Step 1

Step

Sum GL by pay date

Step 2

Join

Join GL totals

14 of 14 paired

Step

Set status

Step 4

Result

Payroll GL reconciliation

14 rows · 5 flagged

Schedule

Runs when you say

Proposed

File
ADP Payroll Register
CSV export · 20 rows
File
ADP Payroll GL Postings
CSV export · 16 rows
Step
Sum by pay date
Step 1
Step
Sum GL by pay date
Step 2
Join
Join GL totals
14 of 14 paired
Step
Set status
Step 4
Result
Payroll GL reconciliation
14 rows · 5 flagged
Schedule
Runs when you say
Proposed

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

Download ADP Payroll Register sample (20 rows)ADP: Reports > Payroll > Payroll Register > Export
Download ADP Payroll GL Postings sample (16 rows)ADP: Payroll > General Ledger > Payroll Journal Export

What you get back

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

Payroll GL reconciliationSample data14 rows

9 agrees4 extra1 missing

Pay date	Account name	Register amount	GL amount	Status
2026-10-01	Regular wages	4,680.50	6,680.50	Extra
2026-10-15	Regular wages	7,545.25	15,090.50	Extra
2026-09-10	Payroll taxes	492.46	491.46	Missing
2026-10-01	Payroll taxes	358.31	511.31	Extra
2026-10-22	Payroll taxes	593.80	1,187.60	Extra
2026-09-10	Regular wages	6,435.50	6,435.50	Agrees
2026-09-17	Regular wages	6,600.75	6,600.75	Agrees
2026-09-24	Regular wages	7,075.25	7,075.25	Agrees
2026-10-08	Regular wages	7,313.75	7,313.75	Agrees
2026-10-22	Regular wages	7,760.50	7,760.50	Agrees
2026-09-17	Payroll taxes	505.18	505.18	Agrees
2026-09-24	Payroll taxes	541.38	541.38	Agrees

14 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How do you reconcile ADP payroll to the GL?

Export the ADP payroll register and the GL payroll postings from ADP. Mammoth sums both by pay date, joins the totals, and shows a status for each date. You get Agrees when the totals match, Missing when the GL is short, and Extra when the GL is high.

How it works

How to use the Payroll GL reconciliation 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 GL reconciliation: questions

Which export should you use from ADP?

Use the payroll register export for the payroll detail, and the GL postings export for the expense entries. If your file names differ, use the exports that contain pay date and the amounts you want to compare.

What happens to rows that do not match?

Rows are kept in the result, with a status that shows the difference. If one side has no matching pay date, that row is still shown so you can see whether it is missing or extra.

How do you change the reconciliation rules?

You change the rules in words by saying what to group by, what to sum, and what to compare. For example, you can change the date field, add or remove amount columns, or compare a different set of payroll totals.