Allocation Run #98 — 2026-06
13225 contribution rows processed
(2026-07-14 18:33:03.084981+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-06-C4 does not balance. Debits: $148197.79, Credits: $166742.79, Difference: $-18545.00. Sage debit differs from NGP credits; investigate before importing.
- JE REV-ACCR-2026-06-PAC does not balance. Debits: $703896.19, Credits: $707091.19, Difference: $-3195.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 |
$389436.4300 |
$166742.7900 |
$222693.6400 |
$0 |
| 201 |
$696620.2600 |
$682091.1900 |
$14529.0700 |
$0 |
| 202 |
$25000.0000 |
$25000.0000 |
$0 |
$0 |
| 310-ME |
$187000.0000 |
$0 |
$187000.0000 |
$0 |
Sage / NGP Cross-Check
| Entity | NGP Classified Total | Sage Total | Status |
|---|
| 101 |
$166742.79 |
$148197.79 |
MISMATCH
|
| 201 |
$682091.19 |
$358896.19 |
INFO — pair
|
| 202 |
$25000.00 |
$345000.00 |
INFO — pair
|
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 -323,195.00, 202 320,000.00.
Suggested overage adjustment: the pair nets to
$-3,195.00 — review the 202 overage/reclass line for that
amount before importing.
| Severity | Category | Source Code / Batch | Amount | Rows | Detail | |
|---|
| WARNING |
unrouted slate |
|
44289.7400 |
512 |
512 Impact Slate contribution(s) ($44289.7400) could not be routed: bank account empty or not matching any prefix in slate_bank_mapping.csv. |
|
| WARNING |
Sage / NGP mismatch |
|
|
|
Entity 101: Sage total (NEEDS DETAILS $148197.79 + already coded $0 = $148197.79) != NGP classified total ($166742.79). Difference: $-18545.00. JE uses Sage debit amount; investigate before importing. |
|
| WARNING |
Sage / NGP mismatch |
|
|
|
Entity 201: Sage total (NEEDS DETAILS $358896.19 + already coded $0 = $358896.19) != NGP classified total ($682091.19). Difference: $-323195.00. JE uses Sage debit amount; investigate before importing. |
|
| WARNING |
Sage / NGP mismatch |
|
|
|
Entity 202: Sage total (NEEDS DETAILS $345000.00 + already coded $0 = $345000.00) != NGP classified total ($25000.00). Difference: $320000.00. JE uses Sage debit amount; investigate before importing. |
|
| WARNING |
JE does not balance |
|
|
|
JE REV-ACCR-2026-06-C4 does not balance. Debits: $148197.79, Credits: $166742.79, Difference: $-18545.00. Sage debit differs from NGP credits; investigate before importing. |
|
| WARNING |
JE does not balance |
|
|
|
JE REV-ACCR-2026-06-PAC does not balance. Debits: $703896.19, Credits: $707091.19, Difference: $-3195.00. Sage debit differs from NGP credits; investigate before importing. |
|
| INFO |
Entity not in this run |
|
340.0000 |
4 |
Entity 314 Action Impact Slate - HD not selected for this run — 4 rows, $340.0000 skipped. |
|
| INFO |
Entity not in this run |
|
873.1200 |
34 |
Entity 314 Action Impact Slate - JF not selected for this run — 34 rows, $873.1200 skipped. |
|
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 |
|---|
| 1059026 Offset |
1553.9600 |
1 |
1 rows ($1553.9600) excluded: 1059026 (Offset) — Separate GL (41200) already coded. |
| 1052693 314 Transfer |
297898.6100 |
10 |
10 rows ($297898.6100) excluded: 1052693 (314 Transfer) — Inter-entity transfer. |
| 1105018 Payroll Allocation |
121321.3700 |
2 |
2 rows ($121321.3700) excluded: 1105018 (Payroll Allocation) — Not fundraising revenue. |
| 1066202 Interest |
3448.7700 |
7 |
7 rows ($3448.7700) excluded: 1066202 (Interest) — Separate GL (41000) already coded. |
Impact Slate Contributions That Couldn't Be Routed
512 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 |
JUN 26 Source Code Allocation - C4 |
148197.79 |
|
FR |
9999 |
9999998 |
| 2 |
101 |
40000 |
2100 |
Email |
|
432.50 |
FR |
9999 |
1052620 |
| 3 |
101 |
40000 |
2100 |
Recurring |
|
5539.54 |
FR |
9999 |
1052774 |
| 4 |
101 |
40000 |
3100 |
Strategic Support Contributions |
|
100000.00 |
FR |
9999 |
1052788 |
| 5 |
101 |
40000 |
2300 |
Misc Checks |
|
55.00 |
FR |
9999 |
1052794 |
| 6 |
101 |
40000 |
2200 |
National Travel |
|
10000.00 |
FR |
9999 |
1052795 |
| 7 |
101 |
40000 |
2200 |
Calltime/Major Donor |
|
11430.00 |
FR |
9999 |
1052799 |
| 8 |
101 |
40000 |
2300 |
HD Direct Mail |
|
26595.00 |
FR |
9999 |
1117034 |
| 9 |
101 |
40000 |
2100 |
Middollar Texting Digital |
|
5249.75 |
FR |
9999 |
1123306 |
| 10 |
101 |
40000 |
2100 |
Middollar Email Digital |
|
7441.00 |
FR |
9999 |
1123308 |
| Line | Entity | GL | Dept | Memo | Debit | Credit | Function | Project | ClassID |
|---|
| 1 |
201 |
40000 |
9998 |
JUN 26 Source Code Allocation - PAC |
358896.19 |
|
FR |
9999 |
9999998 |
| 2 |
202 |
40000 |
9998 |
JUN 26 Source Code Allocation - PAC |
345000.00 |
|
FR |
9999 |
9999998 |
| 3 |
201 |
40000 |
2100 |
Email |
|
82295.72 |
FR |
9999 |
1052620 |
| 4 |
201 |
40000 |
9999 |
Refunded |
|
302.00 |
FR |
9999 |
1052621 |
| 5 |
201 |
40000 |
2100 |
Texting |
|
36372.13 |
FR |
9999 |
1052650 |
| 6 |
201 |
40000 |
2100 |
Website |
|
12523.54 |
FR |
9999 |
1052772 |
| 7 |
201 |
40000 |
2100 |
Ads |
|
59824.73 |
FR-ACQ |
9999 |
1052773 |
| 8 |
201 |
40000 |
2100 |
Recurring |
|
66449.27 |
FR |
9999 |
1052774 |
| 9 |
201 |
40000 |
3100 |
Strategic Support Contributions |
|
500.00 |
FR |
9999 |
1052788 |
| 10 |
201 |
40000 |
2300 |
Misc Checks |
|
9471.40 |
FR |
9999 |
1052794 |
| 11 |
201 |
40000 |
2200 |
Calltime/Major Donor |
|
363500.00 |
FR |
9999 |
1052799 |
| 12 |
201 |
40000 |
2300 |
Direct Mail (Grassroots) |
|
40294.15 |
FR |
9999 |
1117033 |
| 13 |
201 |
40000 |
2300 |
HD Direct Mail |
|
300.00 |
FR |
9999 |
1117034 |
| 14 |
201 |
40000 |
2300 |
Direct Mail - Acquisition |
|
8812.00 |
FR-ACQ |
9999 |
1118169 |
| 15 |
201 |
40000 |
2100 |
Middollar Texting Digital |
|
45.00 |
FR |
9999 |
1123306 |
| 16 |
201 |
40000 |
2100 |
Middollar Email Digital |
|
901.25 |
FR |
9999 |
1123308 |
| 17 |
201 |
40000 |
9999 |
Not Applicable |
|
500.00 |
FR |
9999 |
9999999 |
| 18 |
202 |
40000 |
3100 |
Strategic Support Contributions (MT-01) |
|
20000.00 |
PRO |
2026-HC-MT01 |
1052788 |
| 19 |
202 |
40000 |
3100 |
Strategic Support Contributions (NH-GOV) |
|
5000.00 |
PRO-IE |
9999 |
1052788 |
| Line | Entity | GL | Dept | Memo | Debit | Credit | Function | Project | ClassID |
|---|
| 1 |
202 |
40000 |
3100 |
Strategic Support Contributions |
100000.00 |
|
FR |
9999 |
1052788 |
| 2 |
202 |
40000 |
3100 |
Strategic Support Contributions (ME-GOV) |
|
100000.00 |
PRO-IE |
2026-ME-GOV |
1052788 |
Downloads
Next steps: import the exported CSV(s) into Sage Intacct, then
re-check the reconciliation for 2026-06
— or head back to the
Close dashboard
for the rest of the month-end checklist.