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 18
Unassigned slate batches
$35,268.29 across 18 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 18
Unassigned slate batches
$35,268.29 across 18 batch(es) 0
Unmapped in-use codes
every in-use code maps
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 (5 entities) | $4,238,671.89 | $4,239,671.89 | -$1,000.00 | ✗ Mismatch |
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
$43,247.32 CR |
$44,247.32
498 contributions |
-$1,000.00 | ✗ | |
| Unassigned slate batch: Slate Transfer In 03232026 | — | $1,000.00
1 row |
— | … | |
| 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 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 (4 entities) | $2,060,529.17 | $2,054,121.41 | $6,407.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 |
$50,514.31
701 contributions |
-$5,250.00 | ✗ | |
| Unassigned slate batch: Slate Transfer In 04012026 | — | $5,250.00
1 row |
— | … | |
| Post-run NGP edits: $229,052.95 across 741 rows modified after this period's last run | — | $229,052.95 | — | 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,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 (5 entities) | $3,757,856.46 | $3,948,056.46 | -$190,200.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,509.37
13460 contributions |
-$200.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
$21,639.36 CR |
$21,639.36
339 contributions |
$0.00 | ✓ | |
| Post-run NGP edits: $556,777.72 across 23 rows modified after this period's last run | — | $556,777.72 | — | 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,461.40
26 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 (4 entities) | $913,836.84 |
$913,836.84
($919,336.84 − excluded batches $5,500.00) |
$0.00 | ✓ Match |
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,413,682.38 CR − $706,591.19 DR |
$707,091.19
11994 contributions |
$0.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
$80,005.72 CR − $40,002.86 DR |
$40,002.86
549 contributions |
$0.00 | ✓ | |
| Post-run NGP edits: $47,617.66 across 102 rows modified after this period's last run | — | $47,617.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. | — |
−$775,576.04
25 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 (4 entities) | $121,690.53 | $497,601.39 | -$375,910.86 | ✗ Mismatch | Build JEs → |
| 314 Action (101) |
$31,361.14
$31,361.14 CR |
$246,472.92
496 contributions |
-$215,111.78 | ✗ | |
|
314 Action Fund + Non-Contribution (201 + 202)
PAC pair — the accrual JE reclasses between 201 and 202; compared combined (they net across the pair). |
$85,426.10
$85,426.10 CR |
$219,992.18
7177 contributions |
-$134,566.08 | ✗ | |
| 314 Action Victory Fund (301) | $0.00 |
$100.00
1 contribution |
-$100.00 | ✗ | |
|
Impact Slate — HD + JF (401 + 403)
NGP export can't split HD vs JF — compared combined. |
$4,903.29
$4,903.29 CR |
$31,036.29
362 contributions |
-$26,133.00 | ✗ | |
| Unassigned slate batch: IS CASH 07092026 | — | $6.00
1 row |
— | … | |
| Unassigned slate batch: IS CDC 07092026 | — | $484.29
16 rows |
— | … | |
| Unassigned slate batch: IS Q2 CDC 07092026 A | — | $955.00
7 rows |
— | … | |
| Unassigned slate batch: IS Q2 CDC 07092026 B | — | $605.00
4 rows |
— | … | |
| Unassigned slate batch: Slate P26June AB 07122026 | — | $5,089.00
43 rows |
— | … | |
| Unassigned slate batch: Slate P26June AB 07052026 | — | $1,687.00
62 rows |
— | … | |
| Unassigned slate batch: IS CDC 07202026 A | — | $1,690.00
20 rows |
— | … | |
| Unassigned slate batch: IS CDC 07202026 B | — | $3,215.00
23 rows |
— | … | |
| Unassigned slate batch: IS CDC 07202026 C | — | $2,650.00
20 rows |
— | … | |
| Unassigned slate batch: IS CDC 07202026 D | — | $2,460.00
20 rows |
— | … | |
| Unassigned slate batch: IS CDC 07202026 E | — | $1,395.00
20 rows |
— | … | |
| Unassigned slate batch: IS CDC 07202026 F | — | $5,192.00
20 rows |
— | … | |
| Unassigned slate batch: IS CDC 07202026 G | — | $250.00
6 rows |
— | … | |
| Unassigned slate batch: IS CDC 07202026 H | — | $1,860.00
16 rows |
— | … | |
| Unassigned slate batch: IS CASH 07202026 | — | $64.00
7 rows |
— | … | |
| Unassigned slate batch: Slate P26June AB 07192026 | — | $1,416.00
29 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,096.05
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. |
$2,392.84
3 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.