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 1
Unassigned slate batches
$100.00 across 1 batch(es) 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 1
Unassigned slate batches
$100.00 across 1 batch(es) 0
Unmapped in-use codes
every in-use code maps
All entities
| Month / Entity | Sage Net Revenue | NGP Contributions | Difference | Status | Run |
|---|---|---|---|---|---|
| ▶ Jun 2025 (3 entities) | $433,071.49 | $439,260.52 | -$6,189.03 | ✗ Mismatch |
Open Run →
last run |
| 314 Action (101) |
$54,117.33
$54,117.33 CR |
$59,767.33
246 contributions |
-$5,650.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). |
$346,051.33
$346,051.33 CR |
$346,590.36
12755 contributions |
-$539.03 | ✗ | |
|
Impact Slate — HD + JF (401 + 403)
NGP export can't split HD vs JF — compared combined. |
$32,902.83
$73,379.66 CR − $40,476.83 DR |
$32,902.83
688 contributions |
$0.00 | ✓ | |
| Unassigned slate batch: Slate GPH AB 06152025 | — | $100.00
1 row |
— | … | |
| Post-run NGP edits: $668,571.15 across 13696 rows modified after this period's last run | — | $668,571.15 | — | 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. | — |
−$229,310.63
7 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. |
$2,164.32
2 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.