Revenue Reconciliation
| Month / Entity | Sage Net Revenue | NGP Contributions | Difference | Status |
|---|---|---|---|---|
| ▶ Jan 2025 (5 entities) | $448,852.93 | $638,871.45 | -$190,018.52 | ✗ Mismatch |
| 314 Action (101) |
$76,928.33
$152,843.98 CR − $75,915.65 DR |
$267,396.63
622 contributions |
-$190,468.30 | ✗ |
| 314 Action Fund (201) |
$362,347.08
$724,681.01 CR − $362,333.93 DR |
$371,321.82
13715 contributions |
-$8,974.74 | ≈ |
|
314 Action Fund — Non-Contribution (202)
Cross-entity reclass — no direct NGP match. |
$9,294.52
$9,294.52 CR |
$0.00 | $9,294.52 | ✗ |
|
Impact Slate — HD + JF (401 + 403)
NGP export can't split HD vs JF — compared combined. |
$153.00
$153.00 CR |
$153.00
2 contributions |
$0.00 | ✓ |
|
Fund 501 (unmapped)
No configured NGP mapping — add it to RECONCILIATION_GROUPS in revenue_allocation_v2.config. |
$130.00
$130.00 CR |
$0.00 | $130.00 | ✗ |
| ▶ Feb 2025 (5 entities) | $472,862.19 | $658,042.39 | -$185,180.20 | ✗ Mismatch |
| 314 Action (101) |
$101,391.12
$202,027.96 CR − $100,636.84 DR |
$288,991.32
599 contributions |
-$187,600.20 | ✗ |
| 314 Action Fund (201) |
$323,657.14
$690,876.69 CR − $367,219.55 DR |
$368,946.07
13978 contributions |
-$45,288.93 | ✗ |
|
314 Action Fund — Non-Contribution (202)
Cross-entity reclass — no direct NGP match. |
$45,288.93
$45,288.93 CR |
$0.00 | $45,288.93 | ✗ |
|
Impact Slate — HD + JF (401 + 403)
NGP export can't split HD vs JF — compared combined. |
$0.00 |
$105.00
1 contribution |
-$105.00 | ✗ |
|
Fund 501 (unmapped)
No configured NGP mapping — add it to RECONCILIATION_GROUPS in revenue_allocation_v2.config. |
$2,525.00
$2,525.00 CR |
$0.00 | $2,525.00 | ✗ |
| ▶ Mar 2025 (5 entities) | $705,087.30 | $781,211.20 | -$76,123.90 | ✗ Mismatch |
| 314 Action (101) |
$154,617.49
$308,642.08 CR − $154,024.59 DR |
$240,951.39
472 contributions |
-$86,333.90 | ✗ |
| 314 Action Fund (201) |
$539,707.98
$1,075,101.24 CR − $535,393.26 DR |
$540,049.69
18334 contributions |
-$341.71 | ≈ |
|
314 Action Fund — Non-Contribution (202)
Cross-entity reclass — no direct NGP match. |
$341.71
$341.71 CR |
$0.00 | $341.71 | ✗ |
|
Impact Slate — HD + JF (401 + 403)
NGP export can't split HD vs JF — compared combined. |
$210.12
$210.12 CR |
$210.12
2 contributions |
$0.00 | ✓ |
|
Fund 501 (unmapped)
No configured NGP mapping — add it to RECONCILIATION_GROUPS in revenue_allocation_v2.config. |
$10,210.00
$10,210.00 CR |
$0.00 | $10,210.00 | ✗ |
| ▶ Apr 2025 (6 entities) | $781,288.42 | $946,576.64 | -$165,288.22 | ✗ Mismatch |
| 314 Action (101) |
$57,804.43
$114,570.87 CR − $56,766.44 DR |
$228,577.65
592 contributions |
-$170,773.22 | ✗ |
| 314 Action Fund (201) |
$717,937.09
$1,434,029.19 CR − $716,092.10 DR |
$717,963.87
33225 contributions |
-$26.78 | ≈ |
|
314 Action Fund — Non-Contribution (202)
Cross-entity reclass — no direct NGP match. |
$1.78
$1.78 CR |
$0.00 | $1.78 | ✗ |
| 314 Action Victory Fund (301) |
$25.00
$25.00 CR |
$25.00
2 contributions |
$0.00 | ✓ |
|
Impact Slate — HD + JF (401 + 403)
NGP export can't split HD vs JF — compared combined. |
$10.12
$10.12 CR |
$10.12
1 contribution |
$0.00 | ✓ |
|
Fund 501 (unmapped)
No configured NGP mapping — add it to RECONCILIATION_GROUPS in revenue_allocation_v2.config. |
$5,510.00
$5,510.00 CR |
$0.00 | $5,510.00 | ✗ |
| ▶ May 2025 (5 entities) | $428,350.20 | $595,521.53 | -$167,171.33 | ✗ Mismatch |
| 314 Action (101) |
$66,925.51
$132,824.40 CR − $65,898.89 DR |
$234,092.65
505 contributions |
-$167,167.14 | ✗ |
| 314 Action Fund (201) |
$324,932.98
$647,914.27 CR − $322,981.29 DR |
$324,959.02
16708 contributions |
-$26.04 | ≈ |
|
314 Action Fund — Non-Contribution (202)
Cross-entity reclass — no direct NGP match. |
$1.85
$1.85 CR |
$0.00 | $1.85 | ✗ |
|
Impact Slate — HD + JF (401 + 403)
NGP export can't split HD vs JF — compared combined. |
$36,469.86
$72,929.72 CR − $36,459.86 DR |
$36,469.86
940 contributions |
$0.00 | ✓ |
|
Fund 501 (unmapped)
No configured NGP mapping — add it to RECONCILIATION_GROUPS in revenue_allocation_v2.config. |
$20.00
$20.00 CR |
$0.00 | $20.00 | ✗ |
| ▶ Jun 2025 (6 entities) | $571,992.05 | $830,126.37 | -$258,134.32 | ✗ Mismatch |
| 314 Action (101) |
$81,265.18
$161,571.80 CR − $80,306.62 DR |
$300,841.55
495 contributions |
-$219,576.37 | ✗ |
| 314 Action Fund (201) |
$449,748.25
$897,012.91 CR − $447,264.66 DR |
$464,307.99
17791 contributions |
-$14,559.74 | ≈ |
|
314 Action Fund — Non-Contribution (202)
Cross-entity reclass — no direct NGP match. |
$1.79
$1.79 CR |
$0.00 | $1.79 | ✗ |
| 314 Action Victory Fund (301) | $0.00 |
$24,500.00
2 contributions |
-$24,500.00 | ✗ |
|
Impact Slate — HD + JF (401 + 403)
NGP export can't split HD vs JF — compared combined. |
$40,476.83
$40,476.83 CR |
$40,476.83
882 contributions |
$0.00 | ✓ |
|
Fund 501 (unmapped)
No configured NGP mapping — add it to RECONCILIATION_GROUPS in revenue_allocation_v2.config. |
$500.00
$500.00 CR |
$0.00 | $500.00 | ✗ |
| ▶ Jul 2025 (5 entities) | $761,963.22 | $879,693.65 | -$117,730.43 | ✗ Mismatch |
| 314 Action (101) |
$399,065.75
$797,530.51 CR − $398,464.76 DR |
$515,926.18
500 contributions |
-$116,860.43 | ✗ |
| 314 Action Fund (201) |
$292,944.61
$580,817.39 CR − $287,872.78 DR |
$315,946.47
12658 contributions |
-$23,001.86 | ✗ |
|
314 Action Fund — Non-Contribution (202)
Cross-entity reclass — no direct NGP match. |
$1.86
$1.86 CR |
$0.00 | $1.86 | ✗ |
|
Impact Slate — HD + JF (401 + 403)
NGP export can't split HD vs JF — compared combined. |
$47,821.00
$47,821.00 CR |
$47,821.00
961 contributions |
$0.00 | ✓ |
|
Fund 501 (unmapped)
No configured NGP mapping — add it to RECONCILIATION_GROUPS in revenue_allocation_v2.config. |
$22,130.00
$22,130.00 CR |
$0.00 | $22,130.00 | ✗ |
| ▶ Aug 2025 (5 entities) | $553,118.23 | $648,461.67 | -$95,343.44 | ✗ Mismatch |
| 314 Action (101) |
$120,486.12
$240,398.26 CR − $119,912.14 DR |
$213,898.84
530 contributions |
-$93,412.72 | ✗ |
| 314 Action Fund (201) |
$372,779.72
$742,584.14 CR − $369,804.42 DR |
$375,826.30
15161 contributions |
-$3,046.58 | ≈ |
|
314 Action Fund — Non-Contribution (202)
Cross-entity reclass — no direct NGP match. |
$1.86
$1.86 CR |
$0.00 | $1.86 | ✗ |
|
Impact Slate — HD + JF (401 + 403)
NGP export can't split HD vs JF — compared combined. |
$58,736.53
$58,736.53 CR |
$58,736.53
1494 contributions |
$0.00 | ✓ |
|
Fund 501 (unmapped)
No configured NGP mapping — add it to RECONCILIATION_GROUPS in revenue_allocation_v2.config. |
$1,114.00
$1,114.00 CR |
$0.00 | $1,114.00 | ✗ |
| ▶ Sep 2025 (5 entities) | $692,575.03 | $883,043.31 | -$190,468.28 | ✗ Mismatch |
| 314 Action (101) |
$155,877.83
$309,057.23 CR − $153,179.40 DR |
$275,669.83
537 contributions |
-$119,792.00 | ✗ |
| 314 Action Fund (201) |
$471,859.70
$934,742.76 CR − $462,883.06 DR |
$514,183.97
19011 contributions |
-$42,324.27 | ✗ |
| 314 Action Victory Fund (301) | $0.00 |
$31,500.00
3 contributions |
-$31,500.00 | ✗ |
|
Impact Slate — HD + JF (401 + 403)
NGP export can't split HD vs JF — compared combined. |
$61,689.51
$61,689.51 CR |
$61,689.51
839 contributions |
$0.00 | ✓ |
|
Fund 501 (unmapped)
No configured NGP mapping — add it to RECONCILIATION_GROUPS in revenue_allocation_v2.config. |
$3,147.99
$3,147.99 CR |
$0.00 | $3,147.99 | ✗ |
| ▶ Oct 2025 (5 entities) | $549,335.26 | $731,775.29 | -$182,440.03 | ✗ Mismatch |
| 314 Action (101) |
$162,098.07
$323,969.46 CR − $161,871.39 DR |
$284,282.10
568 contributions |
-$122,184.03 | ✗ |
| 314 Action Fund (201) |
$340,845.89
$763,990.87 CR − $423,144.98 DR |
$426,118.11
14602 contributions |
-$85,272.22 | ✗ |
|
314 Action Fund — Non-Contribution (202)
Cross-entity reclass — no direct NGP match. |
$1.22
$25,001.22 CR − $25,000.00 DR |
$0.00 | $1.22 | ✗ |
|
Impact Slate — HD + JF (401 + 403)
NGP export can't split HD vs JF — compared combined. |
$21,375.08
$21,375.08 CR |
$21,375.08
609 contributions |
$0.00 | ✓ |
|
Fund 501 (unmapped)
No configured NGP mapping — add it to RECONCILIATION_GROUPS in revenue_allocation_v2.config. |
$25,015.00
$25,015.00 CR |
$0.00 | $25,015.00 | ✗ |
| ▶ Nov 2025 (5 entities) | $332,962.30 | $344,615.49 | -$11,653.19 | ✓ Close |
| 314 Action (101) |
$67,950.90
$136,595.13 CR − $68,644.23 DR |
$67,624.09
550 contributions |
$326.81 | ≈ |
| 314 Action Fund (201) |
$247,168.34
$491,198.30 CR − $244,029.96 DR |
$250,169.40
10216 contributions |
-$3,001.06 | ≈ |
|
314 Action Fund — Non-Contribution (202)
Cross-entity reclass — no direct NGP match. |
$1.06
$7,501.06 CR − $7,500.00 DR |
$0.00 | $1.06 | ✗ |
|
Impact Slate — HD + JF (401 + 403)
NGP export can't split HD vs JF — compared combined. |
$16,822.00
$16,822.00 CR |
$26,822.00
183 contributions |
-$10,000.00 | ✗ |
|
Fund 501 (unmapped)
No configured NGP mapping — add it to RECONCILIATION_GROUPS in revenue_allocation_v2.config. |
$1,020.00
$1,020.00 CR |
$0.00 | $1,020.00 | ✗ |
| ▶ Dec 2025 (7 entities) | $484,951.29 | $738,653.85 | -$253,702.56 | ✗ Mismatch |
| 314 Action (101) |
$99,361.44
$214,358.80 CR − $114,997.36 DR |
$315,857.88
706 contributions |
-$216,496.44 | ✗ |
| 314 Action Fund (201) |
$332,327.57
$638,885.19 CR − $306,557.62 DR |
$369,770.87
9905 contributions |
-$37,443.30 | ✗ |
|
314 Action Fund — Non-Contribution (202)
Cross-entity reclass — no direct NGP match. |
$57.18
$58,557.18 CR − $58,500.00 DR |
$0.00 | $57.18 | ✗ |
|
Impact Slate — HD + JF (401 + 403)
NGP export can't split HD vs JF — compared combined. |
$53,025.10
$53,025.10 CR |
$53,025.10
718 contributions |
$0.00 | ✓ |
|
Fund 501 (unmapped)
No configured NGP mapping — add it to RECONCILIATION_GROUPS in revenue_allocation_v2.config. |
$180.00
$180.00 CR |
$0.00 | $180.00 | ✗ |
|
Fund E100 (unmapped)
No configured NGP mapping — add it to RECONCILIATION_GROUPS in revenue_allocation_v2.config. |
$0.00
$660.28 CR − $660.28 DR |
$0.00 | $0.00 | ✓ |
|
Fund E200 (unmapped)
No configured NGP mapping — add it to RECONCILIATION_GROUPS in revenue_allocation_v2.config. |
$0.00
$353.86 CR − $353.86 DR |
$0.00 | $0.00 | ✓ |
| ▶ Jan 2026 (6 entities) | $998,447.40 | $1,098,736.81 | -$100,289.41 | ✗ Mismatch |
| 314 Action (101) |
$292,723.08
$585,289.38 CR − $292,566.30 DR |
$393,277.49
369 contributions |
-$100,554.41 | ✗ |
| 314 Action Fund (201) |
$688,779.09
$1,466,485.36 CR − $777,706.27 DR |
$688,877.70
22653 contributions |
-$98.61 | ≈ |
|
314 Action Fund — Non-Contribution (202)
Cross-entity reclass — no direct NGP match. |
$98.61
$92,798.61 CR − $92,700.00 DR |
$0.00 | $98.61 | ✗ |
| 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 | ✓ |
|
Fund 501 (unmapped)
No configured NGP mapping — add it to RECONCILIATION_GROUPS in revenue_allocation_v2.config. |
$265.00
$265.00 CR |
$0.00 | $265.00 | ✗ |
| ▶ Feb 2026 (5 entities) | $866,789.32 | $989,017.08 | -$122,227.76 | ✗ Mismatch |
| 314 Action (101) |
$302,640.74
$611,242.93 CR − $308,602.19 DR |
$419,044.93
976 contributions |
-$116,404.19 | ✗ |
| 314 Action Fund (201) |
$451,197.03
$896,253.13 CR − $445,056.10 DR |
$544,432.03
18149 contributions |
-$93,235.00 | ✗ |
|
314 Action Fund — Non-Contribution (202)
Cross-entity reclass — no direct NGP match. |
$86,121.43
$337,242.43 CR − $251,121.00 DR |
$0.00 | $86,121.43 | ✗ |
|
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 | ✓ |
|
Fund 501 (unmapped)
No configured NGP mapping — add it to RECONCILIATION_GROUPS in revenue_allocation_v2.config. |
$1,290.00
$1,290.00 CR |
$0.00 | $1,290.00 | ✗ |
| ▶ Mar 2026 (6 entities) | $4,244,717.03 | $6,388,272.16 | -$2,143,555.13 | ✗ Mismatch |
| 314 Action (101) |
$2,845,848.89
$2,845,848.89 CR |
$2,941,964.12
1540 contributions |
-$96,115.23 | ≈ |
| 314 Action Fund (201) |
$489,979.64
$489,979.64 CR |
$3,315,960.72
14881 contributions |
-$2,825,981.08 | ✗ |
|
314 Action Fund — Non-Contribution (202)
Cross-entity reclass — no direct NGP match. |
$805,541.18
$805,541.18 CR |
$0.00 | $805,541.18 | ✗ |
| 314 Action Victory Fund (301) |
$100.00
$100.00 CR |
$26,100.00
2 contributions |
-$26,000.00 | ✗ |
| 314 Action Victory Fund — Maine (310-ME) |
$60,000.00
$60,000.00 CR |
$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 | ≈ |
Note: a gap within 5% is expected per entity (interest, list rental, non-NGP transfers). The 401 + 403 row is compared combined because the NGP export can't split Impact Slate HD from JF.
Need to compare against a specific historical NGP export? Backfill it via the NGP Sync page and reload — this view reads everything from the local store.