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 |
|---|---|---|---|---|---|
| ▶ Jun 2026 (3 entities) | $831,422.04 |
$841,922.04
($847,422.04 − excluded batches $5,500.00) |
-$10,500.00 | ✗ Mismatch |
Open Run →
last run |
| 314 Action (101) |
$144,601.99
$144,601.99 CR |
$144,601.99
531 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). |
$657,688.19
$657,688.19 CR |
$658,188.19
10835 contributions |
-$500.00 | ✗ | |
|
Impact Slate — HD + JF (401 + 403)
NGP export can't split HD vs JF — compared combined. |
$29,131.86
$39,131.86 CR − $10,000.00 DR |
$39,131.86
529 contributions |
-$10,000.00 | ✗ | |
| Post-run NGP edits: $47,367.66 across 101 rows modified after this period's last run | — | $47,367.66 | — | Re-run → | |
|
Excluded batches (ledger): duplicates, transfers,
conduit, refunds — subtracted from the NGP column.
Slate Transfer In 06032026 ($5,500.00) |
— |
−$5,500.00
1 contribution |
— | Ledger → | |
| 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. | — |
−$376,934.11
17 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. |
$13,877.78
10 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.