Results: ContributionReport-20317496034.csv
19170 contribution rows processed
Entity Totals
| Entity | NGP Total | Mapped | Excluded | Unmapped |
|---|---|---|---|---|
| 401 | $900.0000 | $900.0000 | $0 | $0 |
| 403 | $39576.8300 | $39576.8300 | $0 | $0 |
Sage / NGP Cross-Check
| Entity | NGP Classified Total | Sage Total | Status |
|---|---|---|---|
| 401 | $900.00 | $8900.00 | MISMATCH |
| 403 | $39576.83 | $47576.83 | MISMATCH |
Error Log
| Severity | Category | Source Code | Amount | Rows | Detail |
|---|---|---|---|---|---|
| WARNING | sage_ngp_mismatch | Entity 401: Sage total (NEEDS DETAILS $900.00 + already coded $8000.00 = $8900.00) != NGP classified total ($900.00). Difference: $8000.00. JE uses Sage debit amount; investigate before importing. | |||
| WARNING | sage_ngp_mismatch | Entity 403: Sage total (NEEDS DETAILS $24904.00 + already coded $22672.83 = $47576.83) != NGP classified total ($39576.83). Difference: $8000.00. JE uses Sage debit amount; investigate before importing. | |||
| WARNING | je_imbalance | JE REV-ACCR-2025-06-IS-HD does not balance. Debits: $8900.00, Credits: $900.00, Difference: $8000.00. Sage debit differs from NGP credits; investigate before importing. | |||
| WARNING | je_imbalance | JE REV-ACCR-2025-06-IS-JF does not balance. Debits: $47576.83, Credits: $39576.83, Difference: $8000.00. Sage debit differs from NGP credits; 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-06-IS-HD (4 lines, Debits: $8900.00, Credits: $900.00)
| Line | Entity | GL | Dept | Memo | Debit | Credit | Function | Project | ClassID |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 401 | 40000 | 9998 | JUN 26 Source Code Allocation - IS-HD | 900.00 | FR | 9999 | 9999998 | |
| 2 | 401 | 40510 | 9999 | Reversal - prior allocation (1117035) | 8000.00 | FR | 9999 | 1117035 | |
| 3 | 401 | 40000 | 2300 | Direct Mail (Grassroots) - Appeals | 500.00 | FR | 9999 | 1117033 | |
| 4 | 401 | 40000 | 2100 | Website | 400.00 | FR | 9999 | 1052772 |
REV-ACCR-2025-06-IS-JF (11 lines, Debits: $47576.83, Credits: $39576.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 | 40510 | 9999 | Reversal - prior allocation (9999999) | 8000.00 | PRO-JF | JF-2025-Q2-PRIORITY | 9999999 | |
| 3 | 403 | 40500 | 9998 | JUN 26 Source Code Allocation - IS-JF (JF-2025-Q2-PRIORITY) | 24804.00 | PRO-JF | JF-2025-Q2-PRIORITY | 9999998 | |
| 4 | 403 | 40500 | 2200 | Calltime/Major Donor | 657.00 | PRO-JF | JF-2025-Q2-PRIORITY | 1052799 | |
| 5 | 403 | 40500 | 2300 | Direct Mail (Grassroots) - Appeals | 18140.83 | PRO-JF | JF-2025-Q2-PRIORITY | 1117033 | |
| 6 | 403 | 40500 | 2100 | 12609.00 | PRO-JF | JF-2025-Q2-PRIORITY | 1052620 | ||
| 7 | 403 | 40500 | 2100 | Recurring | 448.00 | PRO-JF | JF-2025-Q2-PRIORITY | 1052774 | |
| 8 | 403 | 40500 | 2100 | Texting | 2737.00 | PRO-JF | JF-2025-Q2-PRIORITY | 1052650 | |
| 9 | 403 | 40500 | 2100 | Website | 4885.00 | PRO-JF | JF-2025-Q2-PRIORITY | 1052772 | |
| 10 | 403 | 40500 | 9998 | JUN 26 Source Code Allocation - IS-JF (JF-2026-MISC-GOPH-V2) | 100.00 | PRO-JF | JF-2026-MISC-GOPH-V2 | 9999998 | |
| 11 | 403 | 40500 | 2100 | Website | 100.00 | PRO-JF | JF-2026-MISC-GOPH-V2 | 1052772 |