Results: ContributionReport-5693504855.csv

13558 contribution rows processed

Entity Totals

EntityNGP TotalMappedExcludedUnmapped
101 $1244535.7200 $1116211.0300 $128324.6900 $0
201 $1424905.1300 $421396.0700 $1003509.0600 $0
202 $296000.0000 $296000.0000 $0 $0
310-ME $170000.0000 $170000.0000 $0 $0

Sage / NGP Cross-Check

EntityNGP Classified TotalSage TotalStatus
101 $1116211.03 $1116211.03 Match
201 $421396.07 $361396.07 MISMATCH
202 $296000.00 $356000.00 MISMATCH
310-ME $170000.00 $170000.00 Match

Error Log

SeverityCategorySource CodeAmountRowsDetail
WARNING unrouted_slate 6775.0000 8 8 Impact Slate contribution(s) ($6775.0000) could not be routed: bank account empty or not matching any prefix in slate_bank_mapping.csv.
WARNING sage_ngp_mismatch Entity 201: Sage total (NEEDS DETAILS $361396.07 + already coded $0 = $361396.07) != NGP classified total ($421396.07). Difference: $-60000.00. JE uses Sage debit amount; investigate before importing.
WARNING sage_ngp_mismatch Entity 202: Sage total (NEEDS DETAILS $356000.00 + already coded $0 = $356000.00) != NGP classified total ($296000.00). Difference: $60000.00. JE uses Sage debit amount; investigate before importing.
INFO excluded_rows 1066202 Interest 4730.7100 7 7 rows ($4730.7100) excluded: 1066202 (Interest) — Separate GL (41000) already coded.
INFO excluded_rows 1105018 Payroll Allocation 109103.0400 2 2 rows ($109103.0400) excluded: 1105018 (Payroll Allocation) — Not fundraising revenue.
INFO excluded_rows 1105016 Digital Consulting Allocation 18000.0000 1 1 rows ($18000.0000) excluded: 1105016 (Digital Consulting Allocation) — .
INFO excluded_rows 1052693 314 Transfer 1000000.0000 1 1 rows ($1000000.0000) excluded: 1052693 (314 Transfer) — Inter-entity transfer.
INFO entity_not_selected 42289.3100 682 Entity 314 Action Impact Slate - JF not selected for this run — 682 rows, $42289.3100 skipped.
INFO entity_not_selected 1450.0000 11 Entity 314 Action Impact Slate - HD not selected for this run — 11 rows, $1450.0000 skipped.

JE Preview

REV-ACCR-2026-04-C4 (10 lines, Debits: $1116211.03, Credits: $1116211.03)

LineEntityGLDeptMemoDebitCreditFunctionProjectClassID
1 101 40000 9998 APR 26 Source Code Allocation - C4 1116211.03 FR 9999 9999998
2 101 40000 2200 Calltime/Major Donor 33980.00 FR 9999 1052799
3 101 40000 2300 Direct Mail (Grassroots) - Appeals 314.00 FR 9999 1117033
4 101 40000 2100 Email 3245.00 FR 9999 1052620
5 101 40000 2200 Middollar Email 27325.39 FR 9999 1052768
6 101 40000 2300 Misc Checks 75.00 FR 9999 1052794
7 101 40000 2200 National Travel 45000.00 FR 9999 1052795
8 101 40000 2100 Recurring 5248.64 FR 9999 1052774
9 101 40000 3100 Strategic Support Contributions 1000000.00 FR 9999 1052788
10 101 40000 2100 Texting 1023.00 FR 9999 1052650

REV-ACCR-2026-04-PAC (16 lines, Debits: $717396.07, Credits: $717396.07)

LineEntityGLDeptMemoDebitCreditFunctionProjectClassID
1 201 40000 9998 APR 26 Source Code Allocation - PAC 361396.07 FR 9999 9999998
2 202 40000 9998 APR 26 Source Code Allocation - PAC 356000.00 FR 9999 9999998
3 201 40000 2100 Ads 65653.88 FR-ACQ 9999 1052773
4 201 40000 2200 Calltime/Major Donor 112104.00 FR 9999 1052799
5 201 40000 2300 Direct Mail (Acquisition) 18744.41 FR-ACQ 9999 1118169
6 201 40000 2300 Direct Mail (Grassroots) - Appeals 43646.52 FR 9999 1117033
7 201 40000 2100 Email 71776.62 FR 9999 1052620
8 201 40000 2300 HD Direct Mail 50.00 FR 9999 1117034
9 201 40000 2200 Middollar Email 214.25 FR 9999 1052768
10 201 40000 2300 Misc Checks 4340.00 FR 9999 1052794
11 201 40000 2200 National Travel 5000.00 FR 9999 1052795
12 201 40000 2100 Recurring 65765.54 FR 9999 1052774
13 201 40000 2100 Texting 21556.70 FR 9999 1052650
14 201 40000 2100 Website 12544.15 FR 9999 1052772
15 202 40000 3100 Strategic Support Contributions (IL-09) 5000.00 PRO-IE 2026-HC-IL09 1052788
16 202 40000 3100 Strategic Support Contributions (PA-03) 291000.00 PRO-IE 2026-HC-PA03 1052788

REV-ACCR-2026-04-PAC-NC (2 lines, Debits: $1000000.00, Credits: $1000000.00)

LineEntityGLDeptMemoDebitCreditFunctionProjectClassID
1 202 40000 3100 Strategic Support Contributions 1000000.00 FR 9999 1052788
2 202 40000 3100 Strategic Support Contributions (PA-03) 1000000.00 PRO-IE 2026-HC-PA03 1052788

Unrouted Impact Slate Contributions

8 Impact Slate contribution(s) could not be routed because the bank account was empty or didn't match any prefix in slate_bank_mapping.csv.

IDNameAmountSource CodeBank AccountAssign To
20734407 Finch, Peter $25.0000 DM2026ImpactSlateQ1 (empty)
20790568 314 Action Fund $5250.0000 314 Transfer (empty)
20734404 Holst, Peter $100.0000 DM2026ImpactSlateQ1 (empty)
20734402 Kuroda, Mitzi $1000.0000 DM2026ImpactSlateQ1 (empty)
20734403 Olsen, George $250.0000 DM2026ImpactSlateQ1 (empty)
20734405 Moss, Anthony $10.0000 DM2026ImpactSlateQ1 (empty)
20734408 Sabet, Abdollah $100.0000 DM2026ImpactSlateQ1 (empty)
20734406 Driscoll, Patricia $40.0000 DM2026ImpactSlateQ1 (empty)

Downloads

Download JE CSV Download Error Log

Re-process