Reconcile
0d ago
Pipeline sync
Aug 21, 2026, 3:44 AM ET (pipeline_incremental) 0d ago
Sage GL delivery
Aug 21, 2026, 1:19 AM ET — window through Aug 19, 2026 6
Unassigned slate batches
$12,646.08 across 6 batch(es) 0
Unmapped in-use codes
every in-use code maps
Pipeline sync
Aug 21, 2026, 3:44 AM ET (pipeline_incremental) 0d ago
Sage GL delivery
Aug 21, 2026, 1:19 AM ET — window through Aug 19, 2026 6
Unassigned slate batches
$12,646.08 across 6 batch(es) 0
Unmapped in-use codes
every in-use code maps
All entities
| Month / Entity | Sage Net Revenue | NGP Contributions | Difference | Status | Run |
|---|---|---|---|---|---|
| ▶ 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: $67,676.96 across 277 rows modified after this period's last run | — | $67,676.96 | — | 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) | $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
$7,891,683.10 CR − $4,995,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 | ✓ | |
| Post-run NGP edits: $112,877.48 across 514 rows modified after this period's last run | — | $112,877.48 | — | 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 (3 entities) | $323,756.74 | $298,256.74 | $25,500.00 | ✗ Mismatch | Build JEs → |
| 314 Action (101) |
$35,165.22
$35,165.22 CR |
$34,665.22
468 contributions |
$500.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). |
$262,409.32
$262,409.32 CR |
$237,409.32
7949 contributions |
$25,000.00 | ✗ | |
|
Impact Slate — HD + JF (401 + 403)
NGP export can't split HD vs JF — compared combined. |
$26,182.20
$26,182.20 CR |
$26,182.20
249 contributions |
$0.00 | ✓ | |
| Unassigned slate batch: Slate P26June AB 08022026 | — | $10.00
1 row |
— | … | |
| Unassigned slate batch: Slate P26June AB 08092026 | — | $635.00
16 rows |
— | … | |
| Unassigned slate batch: Slate P26Aug AB 08092026 | — | $5,972.00
108 rows |
— | … | |
| Unassigned slate batch: Slate P26Aug AB 08162026 | — | $4,563.00
83 rows |
— | … | |
| Unassigned slate batch: Slate P26June AB 08162026 | — | $136.00
6 rows |
— | … | |
| Unassigned slate batch: IS P26June CDC 08192026 | — | $1,330.08
5 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,585.42
2 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,498.48
4 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.