Allocation Run #9 — 2025-05
19170 contribution rows processed
(2026-04-07 18:29:11.807405+00:00)
· Re-run this month
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 / Batch | 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 in this run |
|
464307.9900 |
17791 |
Entity 314 Action Fund - Hard Dollar not selected for this run — 17791 rows, $464307.9900 skipped. |
|
| INFO |
Entity not in this run |
|
300841.5500 |
495 |
Entity 314 Action not selected for this run — 495 rows, $300841.5500 skipped. |
|
| INFO |
Entity not in this run |
|
24500.0000 |
2 |
Entity 314 Action Victory Fund not selected for this run — 2 rows, $24500.0000 skipped. |
|
Impact Slate Contributions That Couldn't Be Routed
1 row(s) with no financial batch id and
no matching bank prefix (older rows synced before batch ids existed).
Fix the batch on the
Slate Batches tab and
re-run.
Journal Entries
Badge meanings —
exported CSV downloaded, not yet seen posted in Sage ·
posted found posted in Sage ·
superseded replaced by a newer export ·
error needs attention ·
⚠ Sage totals mismatch (see JE Registry)
| 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 |
| 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 |
Email |
|
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 |
Downloads
Next steps: import the exported CSV(s) into Sage Intacct, then
re-check the reconciliation for 2025-05
— or head back to the
Close dashboard
for the rest of the month-end checklist.