Reconcile
0d ago
Pipeline sync
Nov 22, 2026, 10:06 AM ET (pipeline_incremental) 0d ago
Sage GL delivery
Nov 22, 2026, 12:23 AM ET — window through Nov 18, 2026 14
Unassigned slate batches
$199,602.44 across 14 batch(es) 2
Unmapped in-use codes
$565.00 in the displayed range
Pipeline sync
Nov 22, 2026, 10:06 AM ET (pipeline_incremental) 0d ago
Sage GL delivery
Nov 22, 2026, 12:23 AM ET — window through Nov 18, 2026 14
Unassigned slate batches
$199,602.44 across 14 batch(es) 2
Unmapped in-use codes
$565.00 in the displayed range
All entities
| Month / Entity | Sage Net Revenue | NGP Contributions | Difference | Status | Run |
|---|---|---|---|---|---|
| ▶ Sep 2026 (5 entities) | $3,025,986.45 | $3,025,886.45 | $100.00 | ✗ Mismatch |
Open Run →
last run |
| 314 Action (101) |
$1,202,327.45
$2,404,654.90 CR − $1,202,327.45 DR |
$1,202,327.45
1269 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). |
$1,724,418.61
$4,427,405.22 CR − $2,702,986.61 DR |
$1,724,318.61
12589 contributions |
$100.00 | ✗ | |
| 314 Action Victory Fund (301) |
$350.00
$350.00 CR |
$350.00
2 contributions |
$0.00 | ✓ | |
|
Impact Slate — HD + JF (401 + 403)
NGP export can't split HD vs JF — compared combined. |
$98,890.39
$197,780.78 CR − $98,890.39 DR |
$98,890.39
997 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. |
$31,510.00
$31,510.00 CR |
$0.00 | — | ℹ | |
| Post-run NGP edits: $16,587.50 across 55 rows modified after this period's last run | — | $16,587.50 | — | 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. | — |
−$1,914,044.65
19 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,456.89
3 lines |
— | — | ||
| ▶ Oct 2026 (6 entities) | $6,388,512.84 | $6,359,887.12 | $28,625.72 | ✗ Mismatch | Build JEs → |
| 314 Action (101) |
$2,730,364.19
$2,730,364.19 CR |
$2,730,164.19
1959 contributions |
$200.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). |
$3,453,768.39
$3,454,003.39 CR − $235.00 DR |
$3,434,117.39
21152 contributions |
$19,651.00 | ✗ | |
| 314 Action Victory Fund (301) |
$200.00
$200.00 CR |
$200.00
1 contribution |
$0.00 | ✓ | |
|
Impact Slate — HD + JF (401 + 403)
NGP export can't split HD vs JF — compared combined. |
$191,817.76
$191,817.76 CR |
$194,840.54
3842 contributions |
-$3,022.78 | ✗ | |
|
402 — 314 Action Impact Slate - Non Contrib
In the fund dimension registry but not in a reconciliation group yet — shown as its own row so nothing is dropped. Add it to a group in revenue_allocation_v2/config.py to pair it with its NGP designation. |
$12,362.50
$12,362.50 CR |
$0.00 | $12,362.50 | ✗ | |
|
NGP contributions not mapped to a Sage fund
Source code / designation the classifier can't place. Add a mapping — or an exclusion, for internal allocations that aren't contribution revenue — on the Source Code Mapping page (Data → Source Code Mapping). |
$0.00 |
$565.00
6 contributions |
-$565.00 | ✗ | |
| Unmapped in-use code: 1125856 DMHDQH26A | — | $200.00
1 row |
— | … | |
| Unmapped in-use code: 1126119 | — | $365.00
5 rows |
— | … | |
| Unassigned slate batch: Slate FS26 AB 10142026 | — | $1,874.00
53 rows |
— | … | |
| Unassigned slate batch: Slate Conduit CDC 10082026 | — | $80.00
4 rows |
— | … | |
| Unassigned slate batch: Slate Misdeposit 10142026 | — | $35.00
1 row |
— | … | |
| Unassigned slate batch: Slate FS26 AB 10182026 | — | $6,110.50
126 rows |
— | … | |
| Unassigned slate batch: Slate FS26 AB 10252026 | — | $23,970.50
166 rows |
— | … | |
| Unassigned slate batch: Slate FS26 AB 10312026 | — | $129,311.45
3115 rows |
— | … | |
| Unassigned slate batch: Slate GPH AB 10312026 | — | $1,463.00
40 rows |
— | … | |
| 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. | — |
−$925,829.74
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. |
$3,348.18
3 lines |
— | — | ||
| ▶ Nov 2026 (3 entities) | $148,897.20 | $151,021.20 | -$2,124.00 | ✗ Mismatch | Build JEs → |
| 314 Action (101) |
$6,740.89
$6,740.89 CR |
$19,590.89
181 contributions |
-$12,850.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). |
$99,278.32
$99,278.32 CR |
$93,792.32
3992 contributions |
$5,486.00 | ✗ | |
|
Impact Slate — HD + JF (401 + 403)
NGP export can't split HD vs JF — compared combined. |
$42,877.99
$42,877.99 CR |
$37,637.99
718 contributions |
$5,240.00 | ✗ | |
| Unassigned slate batch: Slate FS26 AB 11012026 | — | $13,111.00
316 rows |
— | … | |
| Unassigned slate batch: Slate FS26 AB 11032026 | — | $10,081.49
268 rows |
— | … | |
| Unassigned slate batch: Slate FS26 AB 11082026 | — | $188.00
14 rows |
— | … | |
| Unassigned slate batch: Slate GPH AB 11032026 | — | $5.00
1 row |
— | … | |
| Unassigned slate batch: Slate FS26 AB 11152026 | — | $422.50
16 rows |
— | … | |
| Unassigned slate batch: IS FS26 CDC 11162026 | — | $11,065.00
78 rows |
— | … | |
| Unassigned slate batch: IS FS26 CDC 11202026 | — | $1,885.00
15 rows |
— | … | |
| 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,006.10
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. |
$1,352.17
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.