Allocation Run #64 — 2026-04
13558 contribution rows processed
(2026-05-18 13:07:47.221166+00:00)
· Re-run this month
⚠ Journal entry does not balance — Sage will reject it on import.
Debits must equal credits. A gap here
almost always means a miscoding in Sage — a line booked
to the wrong source code or dimension (e.g. source 9999999
"not applicable" instead of 9999998 "needs details"), so the
balance the debit reverses doesn't match NGP. Fix it in Sage, re-pull the
GL, and re-run.
- JE REV-ACCR-2026-04-IS-JF does not balance. Debits: $44517.31, Credits: $42289.31, Difference: $2228.00. Sage debit differs from NGP credits; investigate before importing.
Open the reconcile screen for this month and use Diagnose
on the off row →
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 |
| 401 |
$1450.0000 |
$1450.0000 |
$0 |
$0 |
| 403 |
$42289.3100 |
$42289.3100 |
$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 |
INFO — pair
|
| 202 |
$296000.00 |
$356000.00 |
INFO — pair
|
| 310-ME |
$170000.00 |
$170000.00 |
Match
|
| 401 |
$1450.00 |
$1450.00 |
Match
|
| 403 |
$42289.31 |
$43814.31 |
MISMATCH
|
201/202 fund delta (INFO) — funds 201 and 202 are two
halves of the same PAC, and money moves between them on the books each
month, so compare them as a pair, not one at a time. The
fundraising-accrual JE reclasses between the pair; their individual
deltas are expected: 201 -60,000.00, 202 60,000.00.
They net to zero across the pair — nothing to adjust.
Error Log
| Severity | Category | Source Code / Batch | Amount | Rows | Detail | |
|---|
| 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. |
|
| WARNING |
Sage / NGP mismatch |
|
|
|
Entity 403: Sage total (NEEDS DETAILS $43814.31 + already coded $0 = $43814.31) != NGP classified total ($42289.31). Difference: $1525.00. JE uses Sage debit amount; investigate before importing. |
|
| WARNING |
JE does not balance |
|
|
|
JE REV-ACCR-2026-04-IS-JF does not balance. Debits: $44517.31, Credits: $42289.31, Difference: $2228.00. Sage debit differs from NGP credits; investigate before importing. |
|
Excluded by mapping — 4 line(s),
not contribution revenue (transfers, offsets, refunds, grants, payroll,
conduit). Already subtracted; here for the audit trail.
| Source Code / Batch | Amount | Rows | Detail |
|---|
| 1066202 Interest |
4730.7100 |
7 |
7 rows ($4730.7100) excluded: 1066202 (Interest) — Separate GL (41000) already coded. |
| 1105018 Payroll Allocation |
109103.0400 |
2 |
2 rows ($109103.0400) excluded: 1105018 (Payroll Allocation) — Not fundraising revenue. |
| 1105016 Digital Consulting Allocation |
18000.0000 |
1 |
1 rows ($18000.0000) excluded: 1105016 (Digital Consulting Allocation) — . |
| 1052693 314 Transfer |
1000000.0000 |
1 |
1 rows ($1000000.0000) excluded: 1052693 (314 Transfer) — Inter-entity transfer. |
Impact Slate Contributions That Couldn't Be Routed
8 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 |
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 |
| 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 |
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 |
| Line | Entity | GL | Dept | Memo | Debit | Credit | Function | Project | ClassID |
|---|
| 1 |
401 |
40000 |
9998 |
APR 26 Source Code Allocation - IS-HD |
1450.00 |
|
FR |
9999 |
9999998 |
| 2 |
401 |
40000 |
2300 |
Direct Mail (Grassroots) - Appeals |
|
1415.00 |
FR |
9999 |
1117033 |
| 3 |
401 |
40000 |
2100 |
Email |
|
35.00 |
FR |
9999 |
1052620 |
| Line | Entity | GL | Dept | Memo | Debit | Credit | Function | Project | ClassID |
|---|
| 1 |
403 |
40500 |
9998 |
APR 26 Source Code Allocation - IS-JF (JF-2025-Q4-PRIORITY) |
703.00 |
|
PRO-JF |
JF-2025-Q4-PRIORITY |
9999998 |
| 2 |
403 |
40500 |
2300 |
Direct Mail (Grassroots) - Appeals |
|
500.00 |
PRO-JF |
JF-2025-Q4-PRIORITY |
1117033 |
| 3 |
403 |
40500 |
2100 |
Recurring |
|
203.00 |
PRO-JF |
JF-2025-Q4-PRIORITY |
1052774 |
| 4 |
403 |
40500 |
9998 |
APR 26 Source Code Allocation - IS-JF (JF-2026-Q1-PRIORITY) |
9324.12 |
|
PRO-JF |
JF-2026-Q1-PRIORITY |
9999998 |
| 5 |
403 |
40500 |
2300 |
Direct Mail (Grassroots) - Appeals |
|
6752.12 |
PRO-JF |
JF-2026-Q1-PRIORITY |
1117033 |
| 6 |
403 |
40500 |
2100 |
Recurring |
|
344.00 |
PRO-JF |
JF-2026-Q1-PRIORITY |
1052774 |
| 7 |
403 |
40500 |
9998 |
APR 26 Source Code Allocation - IS-JF (JF-2026-Q2-PRIORITY) |
34490.19 |
|
PRO-JF |
JF-2026-Q2-PRIORITY |
9999998 |
| 8 |
403 |
40500 |
2300 |
Direct Mail (Grassroots) - Appeals |
|
214.00 |
PRO-JF |
JF-2026-Q2-PRIORITY |
1117033 |
| 9 |
403 |
40500 |
2100 |
Email |
|
22498.00 |
PRO-JF |
JF-2026-Q2-PRIORITY |
1052620 |
| 10 |
403 |
40500 |
2200 |
Middollar Email |
|
11674.93 |
PRO-JF |
JF-2026-Q2-PRIORITY |
1052768 |
| 11 |
403 |
40500 |
2100 |
Texting |
|
103.26 |
PRO-JF |
JF-2026-Q2-PRIORITY |
1052650 |
| 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 |
Downloads
Next steps: import the exported CSV(s) into Sage Intacct, then
re-check the reconciliation for 2026-04
— or head back to the
Close dashboard
for the rest of the month-end checklist.