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
201 $465355.39 $463088.33 $2267.06 $0

Sage / NGP Cross-Check

EntityNGP Classified TotalSage TotalStatus
201 $463088.33 $418088.33 MISMATCH

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.
INFO excluded_rows 1066202 Interest 681.64 3 3 rows ($681.64) 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 1585.42 2 2 rows ($1585.42) excluded: 1059026 (Offset) — Separate GL (41200) already coded.
INFO entity_not_selected 47177.08 485 Entity 314 Action Impact Slate - JF not selected for this run — 485 rows, $47177.08 skipped.
INFO entity_not_selected 225345.80 1062 Entity 314 Action not selected for this run — 1062 rows, $225345.80 skipped.
INFO entity_not_selected 1143.12 13 Entity 314 Action Impact Slate - HD not selected for this run — 13 rows, $1143.12 skipped.
INFO entity_not_selected 225.00 3 Entity 314 Action Victory Fund not selected for this run — 3 rows, $225.00 skipped.

JE Preview

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

Downloads

Download JE CSV Download Error Log

Re-process