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

Results: pipeline-store 2026-09

14876 contribution rows processed

Entity Totals

EntityNGP TotalMappedExcludedUnmapped
101 $1343186.78 $1202327.45 $140859.33 $0
201 $2471901.93 $702716.61 $1769185.32 $0
202 $1021602.00 $1021602.00 $0 $0
301 $4350.00 $350.00 $4000.00 $0
401 $2196.47 $2196.47 $0 $0
403 $96693.92 $96693.92 $0 $0

Sage / NGP Cross-Check

EntityNGP Classified TotalSage TotalStatus
101 $1202327.45 $1202327.45 Match
201 $702716.61 $547716.61 MISMATCH
202 $1000000.00 $1155000.00 MISMATCH
301 $350.00 $350.00 Match
401 $2196.47 $2196.47 Match
403 $96693.92 $96693.92 Match

Error Log — 4 open in exception queue

SeverityCategorySource CodeAmountRowsDetail
WARNING sage_ngp_mismatch Entity 201: Sage total (NEEDS DETAILS $547716.61 + already coded $0.00 = $547716.61) != NGP classified total ($702716.61). Difference: $-155000.00. JE uses Sage debit amount; investigate before importing.
WARNING sage_ngp_mismatch Entity 202: Sage total (NEEDS DETAILS $1155000.00 + already coded $0.00 = $1155000.00) != NGP classified total ($1000000.00). Difference: $155000.00. JE uses Sage debit amount; investigate before importing.
INFO excluded_rows 1066202 Interest 1930.91 2 2 rows ($1930.91) excluded: 1066202 (Interest) — Separate GL (41000) already coded.
INFO excluded_rows 1052693 314 Transfer 1771929.68 12 12 rows ($1771929.68) excluded: 1052693 (314 Transfer) — Inter-entity transfer.
INFO excluded_rows 1105018 Payroll Allocation 139558.08 2 2 rows ($139558.08) excluded: 1105018 (Payroll Allocation) — Not fundraising revenue.
INFO excluded_rows 1059026 Offset 525.98 1 1 rows ($525.98) excluded: 1059026 (Offset) — Separate GL (41200) already coded.
INFO excluded_rows 1052577 Earmark - Conduit 100.00 2 2 rows ($100.00) excluded: 1052577 (Earmark - Conduit) — Earmark conduit.
INFO in_kind 21602.00 1 1 in-kind gift(s) ($21,602.00) in entity 202 left off the accrual JE — non-cash, never deposited, so not in NEEDS DETAILS. Book by hand in Sage: debit the expense/asset received, credit 40600 In-Kind. Gifts: HMP $21,602.00 (contribution 21588997).

JE Preview

REV-ACCR-2026-09-C4 (12 lines, Debits: $1202327.45, Credits: $1202327.45)

LineEntityGLDeptMemoDebitCreditFunctionProjectClassID
1 101 40000 9998 SEP 26 Source Code Allocation - C4 1202327.45 FR 9999 9999998
2 101 40000 2100 Email 418.00 FR 9999 1052620
3 101 40000 2100 Texting 230.00 FR 9999 1052650
4 101 40000 2100 Recurring 6739.58 FR 9999 1052774
5 101 40000 3100 Strategic Support Contributions 1000000.00 FR 9999 1052788
6 101 40000 2300 Misc Checks 50.00 FR 9999 1052794
7 101 40000 2200 National Travel 5000.00 FR 9999 1052795
8 101 40000 2200 Calltime/Major Donor 137805.00 FR 9999 1052799
9 101 40000 2300 Direct Mail (Grassroots) 1200.00 FR 9999 1117033
10 101 40000 2300 HD Direct Mail 7560.00 FR 9999 1117034
11 101 40000 2100 Middollar Texting Digital 33942.87 FR 9999 1123306
12 101 40000 2100 Middollar Email Digital 9382.00 FR 9999 1123308

REV-ACCR-2026-09-PAC (15 lines, Debits: $1702716.61, Credits: $1702716.61)

LineEntityGLDeptMemoDebitCreditFunctionProjectClassID
1 201 40000 9998 SEP 26 Source Code Allocation - PAC 547716.61 FR 9999 9999998
2 202 40000 9998 SEP 26 Source Code Allocation - PAC 1155000.00 FR 9999 9999998
3 201 40000 2100 Email 109847.43 FR 9999 1052620
4 201 40000 2100 Texting 35256.97 FR 9999 1052650
5 201 40000 2100 Website 18030.23 FR 9999 1052772
6 201 40000 2100 Ads 111142.16 FR-ACQ 9999 1052773
7 201 40000 2100 Recurring 72713.06 FR 9999 1052774
8 201 40000 2300 Misc Checks 10840.51 FR 9999 1052794
9 201 40000 2200 Calltime/Major Donor 282629.00 FR 9999 1052799
10 201 40000 2300 Direct Mail (Grassroots) 53488.14 FR 9999 1117033
11 201 40000 2300 HD Direct Mail 5.00 FR 9999 1117034
12 201 40000 2300 Direct Mail - Acquisition 6703.00 FR-ACQ 9999 1118169
13 201 40000 2100 Middollar Texting Digital 632.00 FR 9999 1123306
14 201 40000 2100 Middollar Email Digital 1429.11 FR 9999 1123308
15 202 40000 3100 Strategic Support Contributions 1000000.00 FR 9999 1052788

REV-ACCR-2026-09-IS-HD (4 lines, Debits: $2196.47, Credits: $2196.47)

LineEntityGLDeptMemoDebitCreditFunctionProjectClassID
1 401 40000 9998 SEP 26 Source Code Allocation - IS-HD 2196.47 FR 9999 9999998
2 401 40000 2100 Email 186.47 FR 9999 1052620
3 401 40000 2300 Misc Checks 25.00 FR 9999 1052794
4 401 40000 2300 Direct Mail (Grassroots) 1985.00 FR 9999 1117033

REV-ACCR-2026-09-IS-JF (15 lines, Debits: $96693.92, Credits: $96693.92)

LineEntityGLDeptMemoDebitCreditFunctionProjectClassID
1 403 40500 9998 SEP 26 Source Code Allocation - IS-JF (JF-2026-AUG-PRIORITY) 33251.92 PRO-JF JF-2026-AUG-PRIORITY 9999998
2 403 40500 2100 Email 778.00 PRO-JF JF-2026-AUG-PRIORITY 1052620
3 403 40500 2100 Texting 317.00 PRO-JF JF-2026-AUG-PRIORITY 1052650
4 403 40500 2100 Recurring 316.00 PRO-JF JF-2026-AUG-PRIORITY 1052774
5 403 40500 2300 Direct Mail (Grassroots) 31772.92 PRO-JF JF-2026-AUG-PRIORITY 1117033
6 403 40500 2100 Middollar Texting Digital 50.00 PRO-JF JF-2026-AUG-PRIORITY 1123306
7 403 40500 2100 Middollar Email Digital 18.00 PRO-JF JF-2026-AUG-PRIORITY 1123308
8 403 40500 9998 SEP 26 Source Code Allocation - IS-JF (JF-2026-FINALSTRETCH) 63442.00 PRO-JF JF-2026-FINALSTRETCH 9999998
9 403 40500 2100 Email 50861.00 PRO-JF JF-2026-FINALSTRETCH 1052620
10 403 40500 2100 Texting 5903.00 PRO-JF JF-2026-FINALSTRETCH 1052650
11 403 40500 2100 Website 100.00 PRO-JF JF-2026-FINALSTRETCH 1052772
12 403 40500 2200 Calltime/Major Donor 1000.00 PRO-JF JF-2026-FINALSTRETCH 1052799
13 403 40500 2300 Direct Mail (Grassroots) 1235.00 PRO-JF JF-2026-FINALSTRETCH 1117033
14 403 40500 2100 Middollar Texting Digital 2443.00 PRO-JF JF-2026-FINALSTRETCH 1123306
15 403 40500 2100 Middollar Email Digital 1900.00 PRO-JF JF-2026-FINALSTRETCH 1123308

Downloads

Download JE CSV Download Error Log

Re-process