Results: ContributionReport-20317496034.csv
19170 contribution rows processed
Entity Totals
| Entity | NGP Total | Mapped | Excluded | Unmapped |
|---|---|---|---|---|
| 401 | $900.0000 | $900.0000 | $0 | $0 |
| 403 | $39476.8300 | $39476.8300 | $0 | $0 |
Sage / NGP Cross-Check
| Entity | NGP Classified Total | Sage Total | Status |
|---|---|---|---|
| 401 | $900.00 | $900.00 | Match |
| 403 | $39476.83 | $39576.83 | MISMATCH |
Error Log
| Severity | Category | Source Code | Amount | Rows | Detail |
|---|---|---|---|---|---|
| WARNING | unrouted_slate | 100.0000 | 1 | 1 Impact Slate contribution(s) ($100.0000) could not be routed: bank account empty or not matching any prefix in slate_bank_mapping.csv. | |
| WARNING | sage_ngp_mismatch | Entity 403: Sage total (NEEDS DETAILS $24904.00 + already coded $14672.83 = $39576.83) != NGP classified total ($39476.83). Difference: $100.00. JE uses Sage debit amount; investigate before importing. | |||
| INFO | entity_not_selected | 464307.9900 | 17791 | Entity 314 Action Fund - Hard Dollar not selected for this run — 17791 rows, $464307.9900 skipped. | |
| INFO | entity_not_selected | 300841.5500 | 495 | Entity 314 Action not selected for this run — 495 rows, $300841.5500 skipped. | |
| INFO | entity_not_selected | 24500.0000 | 2 | Entity 314 Action Victory Fund not selected for this run — 2 rows, $24500.0000 skipped. |
JE Preview
REV-ACCR-2025-05-IS-HD (3 lines, Debits: $900.00, Credits: $900.00)
| Line | Entity | GL | Dept | Memo | Debit | Credit | Function | Project | ClassID |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 401 | 40000 | 9998 | MAY 26 Source Code Allocation - IS-HD | 900.00 | FR | 9999 | 9999998 | |
| 2 | 401 | 40000 | 2300 | Direct Mail (Grassroots) - Appeals | 500.00 | FR | 9999 | 1117033 | |
| 3 | 401 | 40000 | 2100 | Website | 400.00 | FR | 9999 | 1052772 |
REV-ACCR-2025-05-IS-JF (8 lines, Debits: $39476.83, Credits: $39476.83)
| Line | Entity | GL | Dept | Memo | Debit | Credit | Function | Project | ClassID |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 403 | 40500 | 2300 | Reversal - prior allocation (1117033) | 14672.83 | PRO-JF | JF-2025-Q2-PRIORITY | 1117033 | |
| 2 | 403 | 40500 | 9998 | MAY 26 Source Code Allocation - IS-JF (JF-2025-Q2-PRIORITY) | 24804.00 | PRO-JF | JF-2025-Q2-PRIORITY | 9999998 | |
| 3 | 403 | 40500 | 2200 | Calltime/Major Donor | 657.00 | PRO-JF | JF-2025-Q2-PRIORITY | 1052799 | |
| 4 | 403 | 40500 | 2300 | Direct Mail (Grassroots) - Appeals | 18140.83 | PRO-JF | JF-2025-Q2-PRIORITY | 1117033 | |
| 5 | 403 | 40500 | 2100 | 12609.00 | PRO-JF | JF-2025-Q2-PRIORITY | 1052620 | ||
| 6 | 403 | 40500 | 2100 | Recurring | 448.00 | PRO-JF | JF-2025-Q2-PRIORITY | 1052774 | |
| 7 | 403 | 40500 | 2100 | Texting | 2737.00 | PRO-JF | JF-2025-Q2-PRIORITY | 1052650 | |
| 8 | 403 | 40500 | 2100 | Website | 4885.00 | PRO-JF | JF-2025-Q2-PRIORITY | 1052772 |
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.