Revenue Allocation v1 is retained during v2 validation. New closes run on v2.

Results: pipeline-store 2026-08

15241 contribution rows processed

Entity Totals

EntityNGP TotalMappedExcludedUnmapped
101 $225345.80 $99022.54 $126323.26 $0
201 $465355.39 $463088.33 $2267.06 $0
301 $225.00 $225.00 $0 $0
401 $1143.12 $1143.12 $0 $0
403 $47177.08 $46127.08 $1050.00 $0

Sage / NGP Cross-Check

EntityNGP Classified TotalSage TotalStatus
101 $99022.54 $99022.54 Match
201 $463088.33 $418088.33 MISMATCH
202 $0.00 $45000.00 MISMATCH
301 $225.00 $225.00 Match
401 $1143.12 $1143.12 Match
403 $46127.08 $46127.08 Match

Error Log — 3 open in exception queue

SeverityCategorySource CodeAmountRowsDetail
WARNING sage_ngp_mismatch Entity 201: Sage total (NEEDS DETAILS $418088.33 + already coded $0 = $418088.33) != NGP classified total ($463088.33). Difference: $-45000.00. JE uses Sage debit amount; investigate before importing.
WARNING sage_ngp_mismatch Entity 202: Sage total (NEEDS DETAILS $45000.00 + already coded $0 = $45000.00) != NGP classified total ($0.00). Difference: $45000.00. JE uses Sage debit amount; investigate before importing.
INFO excluded_rows 1066202 Interest 1971.06 5 5 rows ($1971.06) excluded: 1066202 (Interest) — Separate GL (41000) already coded.
INFO excluded_rows batch:324675 Slate Transfer In 08042026 5000.00 1 1 rows ($5000.00) excluded: batch:324675 (Slate Transfer In 08042026) — Transfer in.
INFO excluded_rows 1059026 Offset 2635.42 3 3 rows ($2635.42) excluded: 1059026 (Offset) — Separate GL (41200) already coded.
INFO excluded_rows 1105018 Payroll Allocation 125033.84 2 2 rows ($125033.84) excluded: 1105018 (Payroll Allocation) — Not fundraising revenue.

JE Preview

REV-ACCR-2026-08-C4 (8 lines, Debits: $99022.54, Credits: $99022.54)

LineEntityGLDeptMemoDebitCreditFunctionProjectClassID
1 101 40000 9998 AUG 26 Source Code Allocation - C4 99022.54 FR 9999 9999998
2 101 40000 2100 Email 257.00 FR 9999 1052620
3 101 40000 2100 Recurring 6567.76 FR 9999 1052774
4 101 40000 2300 Misc Checks 150.00 FR 9999 1052794
5 101 40000 2200 Calltime/Major Donor 63463.29 FR 9999 1052799
6 101 40000 2300 HD Direct Mail 3350.00 FR 9999 1117034
7 101 40000 2100 Middollar Texting Digital 16946.35 FR 9999 1123306
8 101 40000 2100 Middollar Email Digital 8288.14 FR 9999 1123308

REV-ACCR-2026-08-PAC (15 lines, Debits: $463088.33, Credits: $463088.33)

LineEntityGLDeptMemoDebitCreditFunctionProjectClassID
1 201 40000 9998 AUG 26 Source Code Allocation - PAC 418088.33 FR 9999 9999998
2 202 40000 9998 AUG 26 Source Code Allocation - PAC 45000.00 FR 9999 9999998
3 201 40000 2100 Email 110201.00 FR 9999 1052620
4 201 40000 9999 Refunded 10.00 FR 9999 1052621
5 201 40000 2100 Texting 35615.79 FR 9999 1052650
6 201 40000 2100 Website 24749.02 FR 9999 1052772
7 201 40000 2100 Ads 76341.87 FR-ACQ 9999 1052773
8 201 40000 2100 Recurring 68400.06 FR 9999 1052774
9 201 40000 2300 Misc Checks 893.89 FR 9999 1052794
10 201 40000 2200 National Travel 11500.00 FR 9999 1052795
11 201 40000 2200 Calltime/Major Donor 89629.00 FR 9999 1052799
12 201 40000 2300 Direct Mail (Grassroots) 35241.98 FR 9999 1117033
13 201 40000 2300 Direct Mail - Acquisition 7995.00 FR-ACQ 9999 1118169
14 201 40000 2100 Middollar Texting Digital 1475.22 FR 9999 1123306
15 201 40000 2100 Middollar Email Digital 1035.50 FR 9999 1123308

REV-ACCR-2026-08-IS-HD (3 lines, Debits: $1143.12, Credits: $1143.12)

LineEntityGLDeptMemoDebitCreditFunctionProjectClassID
1 401 40000 9998 AUG 26 Source Code Allocation - IS-HD 1143.12 FR 9999 9999998
2 401 40000 2300 Misc Checks 121.00 FR 9999 1052794
3 401 40000 2300 Direct Mail (Grassroots) 1022.12 FR 9999 1117033

REV-ACCR-2026-08-IS-JF (12 lines, Debits: $46127.08, Credits: $46127.08)

LineEntityGLDeptMemoDebitCreditFunctionProjectClassID
1 403 40500 9998 AUG 26 Source Code Allocation - IS-JF (JF-2026-AUG-PRIORITY) 31118.00 PRO-JF JF-2026-AUG-PRIORITY 9999998
2 403 40500 2100 Email 23624.00 PRO-JF JF-2026-AUG-PRIORITY 1052620
3 403 40500 2100 Texting 4501.00 PRO-JF JF-2026-AUG-PRIORITY 1052650
4 403 40500 2100 Website 395.00 PRO-JF JF-2026-AUG-PRIORITY 1052772
5 403 40500 2300 Direct Mail (Grassroots) 2052.00 PRO-JF JF-2026-AUG-PRIORITY 1117033
6 403 40500 2100 Middollar Texting Digital 511.00 PRO-JF JF-2026-AUG-PRIORITY 1123306
7 403 40500 2100 Middollar Email Digital 35.00 PRO-JF JF-2026-AUG-PRIORITY 1123308
8 403 40500 9998 AUG 26 Source Code Allocation - IS-JF (JF-2026-JUN-PRIORITY) 15009.08 PRO-JF JF-2026-JUN-PRIORITY 9999998
9 403 40500 2100 Email 3.00 PRO-JF JF-2026-JUN-PRIORITY 1052620
10 403 40500 2100 Texting 6.00 PRO-JF JF-2026-JUN-PRIORITY 1052650
11 403 40500 2100 Recurring 391.00 PRO-JF JF-2026-JUN-PRIORITY 1052774
12 403 40500 2300 Direct Mail (Grassroots) 14609.08 PRO-JF JF-2026-JUN-PRIORITY 1117033

Downloads

Download JE CSV Download Error Log

Re-process