Results: ContributionReport-5693504855.csv
13558 contribution rows processed
Entity Totals
| Entity | NGP Total | Mapped | Excluded | Unmapped |
|---|---|---|---|---|
| 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
| Entity | NGP Classified Total | Sage Total | Status |
|---|---|---|---|
| 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
| Severity | Category | Source Code | Amount | Rows | Detail |
|---|---|---|---|---|---|
| WARNING | unrouted_slate | 5250.0000 | 1 | 1 Impact Slate contribution(s) ($5250.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 | 43814.3100 | 689 | Entity 314 Action Impact Slate - JF not selected for this run — 689 rows, $43814.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)
| Line | Entity | GL | Dept | Memo | Debit | Credit | Function | Project | ClassID |
|---|---|---|---|---|---|---|---|---|---|
| 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 | 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)
| Line | Entity | GL | Dept | Memo | Debit | Credit | Function | Project | ClassID |
|---|---|---|---|---|---|---|---|---|---|
| 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 | 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)
| Line | Entity | GL | Dept | Memo | Debit | Credit | Function | Project | ClassID |
|---|---|---|---|---|---|---|---|---|---|
| 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
1 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.