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 4
Unassigned slate batches
$51,150.60 across 4 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 4
Unassigned slate batches
$51,150.60 across 4 batch(es) 0
Unmapped in-use codes
every in-use code maps
All entities
| Month / Entity | Sage Net Revenue | NGP Contributions | Difference | Status | Run |
|---|---|---|---|---|---|
| ▶ Dec 2025 (6 entities) | $531,176.92 | $535,048.90 | -$3,871.98 | ✗ Mismatch |
Open Run →
last run |
| 314 Action (101) |
$155,657.64
$270,655.00 CR − $114,997.36 DR |
$154,997.36
698 contributions |
$660.28 | ✗ | |
|
314 Action Fund + Non-Contribution (201 + 202)
PAC pair — the accrual JE reclasses between 201 and 202; compared combined (they net across the pair). |
$322,494.18
$679,520.62 CR − $357,026.44 DR |
$327,026.44
9895 contributions |
-$4,532.26 | ✗ | |
|
Impact Slate — HD + JF (401 + 403)
NGP export can't split HD vs JF — compared combined. |
$53,025.10
$106,050.20 CR − $53,025.10 DR |
$53,025.10
718 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. |
$180.00
$180.00 CR |
$0.00 | — | ℹ | |
|
Fund E100 (unmapped)
No configured NGP mapping — add it to RECONCILIATION_GROUPS in revenue_allocation_v2.config. |
$0.00
$660.28 CR − $660.28 DR |
$0.00 | $0.00 | ✓ | |
|
Fund E200 (unmapped)
No configured NGP mapping — add it to RECONCILIATION_GROUPS in revenue_allocation_v2.config. |
$0.00
$353.86 CR − $353.86 DR |
$0.00 | $0.00 | ✓ | |
| Unassigned slate batch: IS CDC 12092025 A | — | $1,290.00
3 rows |
— | … | |
| Unassigned slate batch: IS CDC 12092025 B | — | $70.00
2 rows |
— | … | |
| Unassigned slate batch: AB Wire 12092025 | — | $196.35
1 row |
— | … | |
| Post-run NGP edits: $738,653.85 across 11329 rows modified after this period's last run | — | $738,653.85 | — | 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. | — |
−$203,604.95
18 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. |
$10,094.37
9 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.