Workflow · Reconcile · Opening soon

Reconcile the AR subledger to the general ledger

Use exported QuickBooks files to compare your AR aging by customer with the AR balance in the general ledger. See which customers agree and which ones need review.

Book a demo

Someone typed

“match quickbooks ar aging to the ar gl at each month end, show customer difference and status Agrees when they tie, otherwise Difference”

The agent read it as

match QuickBooks AR Aging Summary by Customer to the QuickBooks General Ledger - Accounts Receivable at each month end, show customer difference and status Agrees when they tie, otherwise Difference

What the agent built

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

File

QuickBooks AR Aging Summary by Customer

CSV export · 16 rows

File

QuickBooks General Ledger - Accounts Receivable

CSV export · 18 rows

Step

Make aging customer key

Step 1

Step

Keep AR entries and make customer key

Step 2

Join

Bring in AR ledger entries

16 of 16 paired

Step

Compare customer balances

Step 4

Result

AR Aging Reconciliation

16 rows · 5 flagged

Schedule

Runs at each month end

Proposed

File
QuickBooks AR Aging Summary by Customer
CSV export · 16 rows
File
QuickBooks General Ledger - Accounts Receivable
CSV export · 18 rows
Step
Make aging customer key
Step 1
Step
Keep AR entries and make customer key
Step 2
Join
Bring in AR ledger entries
16 of 16 paired
Step
Compare customer balances
Step 4
Result
AR Aging Reconciliation
16 rows · 5 flagged
Schedule
Runs at each month end
Proposed

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

Download QuickBooks AR Aging Summary by Customer sample (16 rows)QuickBooks: Reports > A/R Aging Summary > Customize > As of each month end > Export
Download QuickBooks General Ledger - Accounts Receivable sample (18 rows)QuickBooks: Reports > General Ledger > Customize > Filter Account = Accounts Receivable > Export

What you get back

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

AR Aging ReconciliationSample data16 rows

11 agrees5 difference

Customer	Report date	Difference	Status	Aging total	GL balance
Aster & Moss Co	2026-10-31	1,240	Difference	1,240	0
Driftline Goods	2026-10-31	-735	Difference	735	1,470
Evergreen Atelier	2026-10-31	-980	Difference	980	1,960
Harbor Peak Labs	2026-10-31	-840	Difference	840	1,680
Northstar Outfitters	2026-10-31	960	Difference	1,605	645
Aster & Moss Co	2026-09-30	0	Agrees	1,240	1,240
Bluebird Studio	2026-09-30	0	Agrees	860	860
Cobalt Ridge LLC	2026-09-30	0	Agrees	410	410
Driftline Goods	2026-09-30	0	Agrees	735	735
Evergreen Atelier	2026-09-30	0	Agrees	980	980
Harbor Peak Labs	2026-09-30	0	Agrees	1,680	1,680
Northstar Outfitters	2026-09-30	0	Agrees	1,125	1,125

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

How do you reconcile accounts receivable by customer to the general ledger?

Export the QuickBooks AR Aging Summary by Customer and the QuickBooks General Ledger for Accounts Receivable. Mammoth matches the customer balances, compares them at each month end, and shows Agrees when they tie or Difference when they do not. It also shows the customer difference for each row.

How it works

How to use the AR Aging 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.

AR Aging Reconciliation: questions

What export should I use?

Use the AR Aging Summary by Customer and the General Ledger for Accounts Receivable from QuickBooks. Export both for the same month end so the balances line up.

What happens to rows that do not match?

They stay in the result with a Difference status and the amount that does not tie. You can then review the customer and the month end balance.

How do I change the rules?

You change the rules by editing the workflow steps in plain words. For example, you can change how the customer key is made, which rows are kept, or how the balances are compared.