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 16
Unassigned slate batches
$29,018.29 across 16 batch(es) 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
▶ Jul 2026 (4 entities)	$121,690.53	$497,601.39	-$375,910.86	✗ Mismatch	Build JEs →
314 Action (101)	$31,361.14 $31,361.14 CR	$246,472.92 496 contributions	-$215,111.78	✗
Running checks… Diagnostics log →
Acknowledge -$215,111.78 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).	$85,426.10 $85,426.10 CR	$219,992.18 7177 contributions	-$134,566.08	✗
Running checks… Diagnostics log →
Acknowledge -$134,566.08 gap — reason (required)
314 Action Victory Fund (301)	$0.00	$100.00 1 contribution	-$100.00	✗
Running checks… Diagnostics log →
Acknowledge -$100.00 gap — reason (required)
Impact Slate — HD + JF (401 + 403) NGP export can't split HD vs JF — compared combined.	$4,903.29 $4,903.29 CR	$31,036.29 362 contributions	-$26,133.00	✗
Running checks… Diagnostics log →
Acknowledge -$26,133.00 gap — reason (required)
Unassigned slate batch: IS CASH 07092026	—	$6.00 1 row	—		…
This batch only Create rule (batches named like this) Exclude Entity (fund) Project Batch name Pattern (trim to the stable part) Entity (fund) Project Future batches whose name matches will route automatically. Reason
Unassigned slate batch: IS CDC 07092026	—	$484.29 16 rows	—		…
This batch only Create rule (batches named like this) Exclude Entity (fund) Project Batch name Pattern (trim to the stable part) Entity (fund) Project Future batches whose name matches will route automatically. Reason
Unassigned slate batch: IS Q2 CDC 07092026 A	—	$955.00 7 rows	—		…
This batch only Create rule (batches named like this) Exclude Entity (fund) Project Batch name Pattern (trim to the stable part) Entity (fund) Project Future batches whose name matches will route automatically. Reason
Unassigned slate batch: IS Q2 CDC 07092026 B	—	$605.00 4 rows	—		…
This batch only Create rule (batches named like this) Exclude Entity (fund) Project Batch name Pattern (trim to the stable part) Entity (fund) Project Future batches whose name matches will route automatically. Reason
Unassigned slate batch: Slate P26June AB 07122026	—	$5,089.00 43 rows	—		…
This batch only Create rule (batches named like this) Exclude Entity (fund) Project Batch name Pattern (trim to the stable part) Entity (fund) Project Future batches whose name matches will route automatically. Reason
Unassigned slate batch: Slate P26June AB 07052026	—	$1,687.00 62 rows	—		…
This batch only Create rule (batches named like this) Exclude Entity (fund) Project Batch name Pattern (trim to the stable part) Entity (fund) Project Future batches whose name matches will route automatically. Reason
Unassigned slate batch: IS CDC 07202026 A	—	$1,690.00 20 rows	—		…
This batch only Create rule (batches named like this) Exclude Entity (fund) Project Batch name Pattern (trim to the stable part) Entity (fund) Project Future batches whose name matches will route automatically. Reason
Unassigned slate batch: IS CDC 07202026 B	—	$3,215.00 23 rows	—		…
This batch only Create rule (batches named like this) Exclude Entity (fund) Project Batch name Pattern (trim to the stable part) Entity (fund) Project Future batches whose name matches will route automatically. Reason
Unassigned slate batch: IS CDC 07202026 C	—	$2,650.00 20 rows	—		…
This batch only Create rule (batches named like this) Exclude Entity (fund) Project Batch name Pattern (trim to the stable part) Entity (fund) Project Future batches whose name matches will route automatically. Reason
Unassigned slate batch: IS CDC 07202026 D	—	$2,460.00 20 rows	—		…
This batch only Create rule (batches named like this) Exclude Entity (fund) Project Batch name Pattern (trim to the stable part) Entity (fund) Project Future batches whose name matches will route automatically. Reason
Unassigned slate batch: IS CDC 07202026 E	—	$1,395.00 20 rows	—		…
This batch only Create rule (batches named like this) Exclude Entity (fund) Project Batch name Pattern (trim to the stable part) Entity (fund) Project Future batches whose name matches will route automatically. Reason
Unassigned slate batch: IS CDC 07202026 F	—	$5,192.00 20 rows	—		…
This batch only Create rule (batches named like this) Exclude Entity (fund) Project Batch name Pattern (trim to the stable part) Entity (fund) Project Future batches whose name matches will route automatically. Reason
Unassigned slate batch: IS CDC 07202026 G	—	$250.00 6 rows	—		…
This batch only Create rule (batches named like this) Exclude Entity (fund) Project Batch name Pattern (trim to the stable part) Entity (fund) Project Future batches whose name matches will route automatically. Reason
Unassigned slate batch: IS CDC 07202026 H	—	$1,860.00 16 rows	—		…
This batch only Create rule (batches named like this) Exclude Entity (fund) Project Batch name Pattern (trim to the stable part) Entity (fund) Project Future batches whose name matches will route automatically. Reason
Unassigned slate batch: IS CASH 07202026	—	$64.00 7 rows	—		…
This batch only Create rule (batches named like this) Exclude Entity (fund) Project Batch name Pattern (trim to the stable part) Entity (fund) Project Future batches whose name matches will route automatically. Reason
Unassigned slate batch: Slate P26June AB 07192026	—	$1,416.00 29 rows	—		…
This batch only Create rule (batches named like this) Exclude Entity (fund) Project Batch name Pattern (trim to the stable part) Entity (fund) Project Future batches whose name matches will route automatically. Reason
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.	—	−$1,096.05 1 contribution	—		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.	$2,392.84 3 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.