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
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
All entities
| Month / Entity | Sage Net Revenue | NGP Contributions | Difference | Status | Run |
|---|---|---|---|---|---|
| ▶ Jul 2025 (4 entities) | $734,158.54 | $748,158.54 | -$14,000.00 | ✗ Mismatch |
Open Run →
last run |
| 314 Action (101) |
$398,464.76
$796,929.52 CR − $398,464.76 DR |
$398,464.76
492 contributions |
$0.00 | ✓ | |
|
314 Action Fund + Non-Contribution (201 + 202)
PAC pair — the accrual JE reclasses between 201 and 202; compared combined (they net across the pair). |
$287,872.78
$575,745.56 CR − $287,872.78 DR |
$301,872.78
12653 contributions |
-$14,000.00 | ✗ | |
|
Impact Slate — HD + JF (401 + 403)
NGP export can't split HD vs JF — compared combined. |
$47,821.00
$95,642.00 CR − $47,821.00 DR |
$47,821.00
961 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. |
$22,130.00
$22,130.00 CR |
$0.00 | — | ℹ | |
| Post-run NGP edits: $879,693.65 across 14119 rows modified after this period's last run | — | $879,693.65 | — | 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. | — |
−$131,535.11
13 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. |
$5,674.68
6 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.