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 |
|---|---|---|---|---|---|
| ▶ Jan 2026 (5 entities) | $994,554.19 | $994,554.19 | $0.00 | ✓ Match | Build JEs → |
| 314 Action (101) |
$292,566.30
$585,132.60 CR − $292,566.30 DR |
$292,566.30
365 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). |
$685,406.27
$1,555,812.54 CR − $870,406.27 DR |
$685,406.27
22647 contributions |
$0.00 | ✓ | |
| 314 Action Victory Fund (301) |
$25.00
$25.00 CR |
$25.00
1 contribution |
$0.00 | ✓ | |
|
Impact Slate — HD + JF (401 + 403)
NGP export can't split HD vs JF — compared combined. |
$16,556.62
$33,113.24 CR − $16,556.62 DR |
$16,556.62
345 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. |
$265.00
$265.00 CR |
$0.00 | — | ℹ | |
| 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. | — |
−$104,182.62
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,628.21
7 lines |
— | — | ||
| ▶ Feb 2026 (4 entities) | $859,216.16 | $859,198.41 | $17.75 | ✗ Mismatch | Build JEs → |
| 314 Action (101) |
$302,498.94
$611,101.13 CR − $308,602.19 DR |
$302,481.19
971 contributions |
$17.75 | ✗ | |
|
314 Action Fund + Non-Contribution (201 + 202)
PAC pair — the accrual JE reclasses between 201 and 202; compared combined (they net across the pair). |
$531,177.10
$1,227,354.20 CR − $696,177.10 DR |
$531,177.10
18149 contributions |
$0.00 | ✓ | |
|
Impact Slate — HD + JF (401 + 403)
NGP export can't split HD vs JF — compared combined. |
$25,540.12
$51,080.24 CR − $25,540.12 DR |
$25,540.12
578 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. |
$1,290.00
$1,290.00 CR |
$0.00 | — | ℹ | |
| 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,818.67
16 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. |
$6,283.16
8 lines |
— | — | ||
| ▶ Mar 2026 (6 entities) | $4,238,671.89 |
$4,238,671.89
($4,239,671.89 − excluded batches $1,000.00) |
$0.00 | ✓ Match |
Open Run →
last run |
| 314 Action (101) |
$2,845,680.78
$5,691,436.56 CR − $2,845,755.78 DR |
$2,845,680.78
1537 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,289,643.79
$4,579,287.58 CR − $3,289,643.79 DR |
$1,289,643.79
14874 contributions |
$0.00 | ✓ | |
| 314 Action Victory Fund (301) |
$100.00
$200.00 CR − $100.00 DR |
$100.00
1 contribution |
$0.00 | ✓ | |
| 314 Action Victory Fund — Maine (310-ME) |
$60,000.00
$120,000.00 CR − $60,000.00 DR |
$60,000.00
3 contributions |
$0.00 | ✓ | |
|
Impact Slate — HD + JF (401 + 403)
NGP export can't split HD vs JF — compared combined. |
$43,247.32
$58,017.49 CR − $14,770.17 DR |
$43,247.32
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. |
$60.00
$60.00 CR |
$0.00 | — | ℹ | |
| Post-run NGP edits: $6,388,272.16 across 16927 rows modified after this period's last run | — | $6,388,272.16 | — | Re-run → | |
|
Excluded batches (ledger): duplicates, transfers,
conduit, refunds — subtracted from the NGP column.
Slate Transfer In 03232026 ($1,000.00) |
— |
−$1,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. | — |
−$2,148,600.27
14 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. |
$6,045.14
8 lines |
— | — | ||
| ▶ Apr 2026 (5 entities) | $2,060,529.17 |
$2,048,871.41
($2,054,121.41 − excluded batches $5,250.00) |
$11,657.76 | ✗ Mismatch |
Open Run →
last run |
| 314 Action (101) |
$1,127,868.79
$2,255,737.58 CR − $1,127,868.79 DR |
$1,116,211.03
1356 contributions |
$11,657.76 | ✗ | |
|
314 Action Fund + Non-Contribution (201 + 202)
PAC pair — the accrual JE reclasses between 201 and 202; compared combined (they net across the pair). |
$717,396.07
$2,509,792.14 CR − $1,792,396.07 DR |
$717,396.07
11499 contributions |
$0.00 | ✓ | |
| 314 Action Victory Fund — Maine (310-ME) |
$170,000.00
$340,000.00 CR − $170,000.00 DR |
$170,000.00
1 contribution |
$0.00 | ✓ | |
|
Impact Slate — HD + JF (401 + 403)
NGP export can't split HD vs JF — compared combined. |
$45,264.31
$45,264.31 CR |
$45,264.31
700 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. |
$280.00
$280.00 CR |
$0.00 | — | ℹ | |
| Post-run NGP edits: $260,186.00 across 1803 rows modified after this period's last run | — | $260,186.00 | — | Re-run → | |
|
Excluded batches (ledger): duplicates, transfers,
conduit, refunds — subtracted from the NGP column.
Slate Transfer In 04012026 ($5,250.00) |
— |
−$5,250.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. | — |
−$1,131,833.75
11 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. |
$4,730.71
7 lines |
— | — | ||
| ▶ May 2026 (6 entities) | $3,757,856.46 | $3,947,856.46 | -$190,000.00 | ✗ Mismatch |
Open Run →
last run |
| 314 Action (101) |
$150,807.73
$301,615.46 CR − $150,807.73 DR |
$150,807.73
946 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). |
$3,360,309.37
$6,721,018.74 CR − $3,360,709.37 DR |
$3,360,309.37
13459 contributions |
$0.00 | ✓ | |
| 314 Action Victory Fund (301) |
$100.00
$100.00 CR |
$100.00
1 contribution |
$0.00 | ✓ | |
|
314 Action Victory Fund — Maine (310-ME)
Acknowledged reconciling item: $190k of May Maine receipts reclassed to a transfer in Sage (not contribution revenue); NGP still counts it as contributions — permanent reconciling item |
$225,000.00
$640,000.00 CR − $415,000.00 DR |
$415,000.00
2 contributions |
-$190,000.00 | ✓ Ack | |
|
Impact Slate — HD + JF (401 + 403)
NGP export can't split HD vs JF — compared combined. |
$21,639.36
$24,630.79 CR − $2,991.43 DR |
$21,639.36
339 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. |
$10.00
$10.00 CR |
$0.00 | — | ℹ | |
| Post-run NGP edits: $563,188.79 across 240 rows modified after this period's last run | — | $563,188.79 | — | 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,292,661.40
27 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. |
$5,715.08
7 lines |
— | — | ||
| ▶ 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.