Reconcile

0d ago
Pipeline sync
Jul 25, 2026, 5:01 AM ET (pipeline_incremental) 0d ago
Sage GL delivery
Jul 25, 2026, 2:18 AM ET — window through Jul 22, 2026 0
Unassigned slate batches
all batches route 0
Unmapped in-use codes
every in-use code maps

Current month Last month Last 3 months Trailing 6 months Year to date

Only rows that are off Clear filters

Month / Entity	Sage Net Revenue	NGP Contributions	Difference	Status	Run
▶ Sep 2025 (4 entities)	$685,833.48	$677,751.97	$8,081.51	✗ Mismatch	Open Run → last run
314 Action (101)	$155,337.74 $308,517.14 CR − $153,179.40 DR	$153,179.40 531 contributions	$2,158.34	✗
Running checks… Diagnostics log →
Acknowledge $2,158.34 gap — reason (required)
314 Action Fund + Non-Contribution (201 + 202) PAC pair — the accrual JE reclasses between 201 and 202; compared combined (they net across the pair).	$468,806.23 $931,689.29 CR − $462,883.06 DR	$462,883.06 19004 contributions	$5,923.17	✗
Running checks… Diagnostics log →
Acknowledge $5,923.17 gap — reason (required)
Impact Slate — HD + JF (401 + 403) NGP export can't split HD vs JF — compared combined.	$61,689.51 $122,839.02 CR − $61,149.51 DR	$61,689.51 839 contributions	$0.00	✓
314 Action Education Fund (501) — C3 C3 revenue is processed outside the NGP committee (see the C3 JE Builder) — no NGP side exists. Informational.	$3,147.99 $3,147.99 CR	$0.00	—	ℹ
Post-run NGP edits: $883,043.31 across 20390 rows modified after this period's last run	—	$883,043.31	—		Re-run →
Excluded source codes & designations (transfers, offsets, refunds, grants, payroll allocations, and NGP funds with no Sage counterpart) — not contribution revenue, subtracted from the NGP column.	—	−$205,291.34 16 contributions	—		Mappings →
Non-NGP revenue (interest, list rental, invoices) Books to the revenue range in Sage but never corresponds to an NGP contribution — removed from the Sage total above.	$3,593.56 4 lines	—	—

Note: reconciliation is penny-exact — any non-zero gap is a Mismatch. Reconciling items that legitimately have no NGP counterpart (interest, list rental, non-NGP transfers, exclusions, unassigned slate) are carved into their own rows and removed from the compared totals, so what remains should net to zero. A known gap you can't clear yet (e.g. a Sage-side reclass still pending) can be Acknowledged so it stops blocking the close; if that gap later changes, the acknowledgement goes stale and the row re-surfaces. The 401 + 403 row is compared combined because the NGP export can't split Impact Slate HD from JF.