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 |
|---|---|---|---|---|---|
| ▶ Jun 2026 (5 entities) | $913,836.84 |
$903,336.84
($908,836.84 − excluded batches $5,500.00) |
$10,500.00 | ✗ Mismatch |
Open Run →
last run |
| 314 Action (101) |
$166,742.79
$333,485.58 CR − $166,742.79 DR |
$166,742.79
669 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). |
$707,091.19
$1,414,182.38 CR − $707,091.19 DR |
$706,591.19
11993 contributions |
$500.00 | ✗ | |
| 314 Action Victory Fund — Maine (310-ME) |
$0.00
$100,000.00 CR − $100,000.00 DR |
$0.00 | $0.00 | ✓ | |
|
Impact Slate — HD + JF (401 + 403)
NGP export can't split HD vs JF — compared combined. |
$40,002.86
$90,005.72 CR − $50,002.86 DR |
$30,002.86
545 contributions |
$10,000.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. |
$10.00
$10.00 CR |
$0.00 | — | ℹ | |
| Post-run NGP edits: $72,823.50 across 431 rows modified after this period's last run | — | $72,823.50 | — | 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. | — |
−$786,076.04
30 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. |
$14,186.38
14 lines |
— | — | ||
| ▶ Jul 2026 (5 entities) | $6,969,409.04 | $6,969,555.92 | -$146.88 | ✗ Mismatch |
Open Run →
last run |
| 314 Action (101) |
$4,028,731.08
$8,057,462.16 CR − $4,028,731.08 DR |
$4,028,731.08
897 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). |
$2,895,841.55
$8,901,683.10 CR − $6,005,841.55 DR |
$2,895,988.43
12898 contributions |
-$146.88 | ✗ | |
| 314 Action Victory Fund (301) |
$200.00
$400.00 CR − $200.00 DR |
$200.00
2 contributions |
$0.00 | ✓ | |
|
Impact Slate — HD + JF (401 + 403)
NGP export can't split HD vs JF — compared combined. |
$44,636.41
$89,272.82 CR − $44,636.41 DR |
$44,636.41
461 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. |
$2,130.00
$2,130.00 CR |
$0.00 | — | ℹ | |
| Post-run NGP edits: $121,218.98 across 659 rows modified after this period's last run | — | $121,218.98 | — | 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. | — |
−$190,736.75
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. |
$3,709.82
7 lines |
— | — | ||
| ▶ Aug 2026 (5 entities) | $609,606.07 |
$609,606.07
($614,606.07 − excluded batches $5,000.00) |
$0.00 | ✓ Match |
Open Run →
last run |
| 314 Action (101) |
$99,022.54
$198,045.08 CR − $99,022.54 DR |
$99,022.54
1058 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). |
$463,088.33
$926,176.66 CR − $463,088.33 DR |
$463,088.33
13672 contributions |
$0.00 | ✓ | |
| 314 Action Victory Fund (301) |
$225.00
$900.00 CR − $675.00 DR |
$225.00
3 contributions |
$0.00 | ✓ | |
|
Impact Slate — HD + JF (401 + 403)
NGP export can't split HD vs JF — compared combined. |
$47,270.20
$95,590.40 CR − $48,320.20 DR |
$47,270.20
497 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. |
$5,510.00
$5,510.00 CR |
$0.00 | — | ℹ | |
| Post-run NGP edits: $4,568.50 across 125 rows modified after this period's last run | — | $4,568.50 | — | Re-run → | |
|
Excluded batches (ledger): duplicates, transfers,
conduit, refunds — subtracted from the NGP column.
Slate Transfer In 08042026 ($5,000.00) |
— |
−$5,000.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. | — |
−$129,640.32
10 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,556.48
7 lines |
— | — | ||
| ▶ 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.