Allocation Run #27 — 2026-03
16422 contribution rows processed
(2026-04-17 16:26:05.354027+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-03-C4 does not balance. Debits: $2845680.78, Credits: $2845755.78, Difference: $-75.00. Sage debit differs from NGP credits; investigate before importing.
- JE REV-ACCR-2026-03-PAC does not balance. Debits: $1289643.79, Credits: $1279643.79, Difference: $10000.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 |
$2942039.1200 |
$2845755.7800 |
$96283.3400 |
$0 |
| 201 |
$2503460.7200 |
$477143.7900 |
$2026316.9300 |
$0 |
| 202 |
$802500.0000 |
$802500.0000 |
$0 |
$0 |
| 301 |
$26100.0000 |
$100.0000 |
$26000.0000 |
$0 |
| 310-ME |
$60000.0000 |
$60000.0000 |
$0 |
$0 |
Sage / NGP Cross-Check
| Entity | NGP Classified Total | Sage Total | Status |
|---|
| 101 |
$2845755.78 |
$2845680.78 |
MISMATCH
|
| 201 |
$477143.79 |
$484643.79 |
INFO — pair
|
| 202 |
$802500.00 |
$805000.00 |
INFO — pair
|
| 301 |
$100.00 |
$100.00 |
Match
|
| 310-ME |
$60000.00 |
$0.00 |
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 7,500.00, 202 2,500.00.
Suggested overage adjustment: the pair nets to
$10,000.00 — review the 202 overage/reclass line for that
amount before importing.
Error Log
| Severity | Category | Source Code / Batch | Amount | Rows | Detail | |
|---|
| WARNING |
Sage / NGP mismatch |
|
|
|
Entity 101: Sage total (NEEDS DETAILS $2845680.78 + already coded $0 = $2845680.78) != NGP classified total ($2845755.78). Difference: $-75.00. JE uses Sage debit amount; investigate before importing. |
|
| WARNING |
Sage / NGP mismatch |
|
|
|
Entity 201: Sage total (NEEDS DETAILS $484643.79 + already coded $0 = $484643.79) != NGP classified total ($477143.79). Difference: $7500.00. JE uses Sage debit amount; investigate before importing. |
|
| WARNING |
Sage / NGP mismatch |
|
|
|
Entity 202: Sage total (NEEDS DETAILS $805000.00 + already coded $0 = $805000.00) != NGP classified total ($802500.00). Difference: $2500.00. JE uses Sage debit amount; investigate before importing. |
|
| WARNING |
Sage / NGP mismatch |
|
|
|
Entity 310-ME: Sage total (NEEDS DETAILS $0.00 + already coded $0 = $0.00) != NGP classified total ($60000.00). Difference: $-60000.00. JE uses Sage debit amount; investigate before importing. |
|
| WARNING |
JE does not balance |
|
|
|
JE REV-ACCR-2026-03-C4 does not balance. Debits: $2845680.78, Credits: $2845755.78, Difference: $-75.00. Sage debit differs from NGP credits; investigate before importing. |
|
| WARNING |
JE does not balance |
|
|
|
JE REV-ACCR-2026-03-PAC does not balance. Debits: $1289643.79, Credits: $1279643.79, Difference: $10000.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 |
|---|
| 1059026 Offset |
2165.9000 |
2 |
2 rows ($2165.9000) excluded: 1059026 (Offset) — Separate GL (41200) already coded. |
| 1052693 314 Transfer |
2046439.9000 |
5 |
5 rows ($2046439.9000) excluded: 1052693 (314 Transfer) — Inter-entity transfer. |
| 1066202 Interest |
3879.2400 |
5 |
5 rows ($3879.2400) excluded: 1066202 (Interest) — Separate GL (41000) already coded. |
| 1105018 Payroll Allocation |
96115.2300 |
2 |
2 rows ($96115.2300) excluded: 1105018 (Payroll Allocation) — Not fundraising revenue. |
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 |
MAR 26 Source Code Allocation - C4 |
2845680.78 |
|
FR |
9999 |
9999998 |
| 2 |
101 |
40000 |
2200 |
Calltime/Major Donor |
|
25575.00 |
FR |
9999 |
1052799 |
| 3 |
101 |
40000 |
2100 |
Email |
|
60.00 |
FR |
9999 |
1052620 |
| 4 |
101 |
40400 |
2200 |
Event |
|
1650.00 |
FR |
9999 |
1052665 |
| 5 |
101 |
40000 |
2300 |
HD Direct Mail |
|
4550.00 |
FR |
9999 |
1117034 |
| 6 |
101 |
40000 |
2200 |
Middollar Email |
|
41604.91 |
FR |
9999 |
1052768 |
| 7 |
101 |
40000 |
2300 |
Misc Checks |
|
1825.00 |
FR |
9999 |
1052794 |
| 8 |
101 |
40000 |
2200 |
National Travel |
|
765000.00 |
FR |
9999 |
1052795 |
| 9 |
101 |
40000 |
2100 |
Recurring |
|
5490.87 |
FR |
9999 |
1052774 |
| 10 |
101 |
40000 |
3100 |
Strategic Support Contributions |
|
2000000.00 |
FR |
9999 |
1052788 |
| Line | Entity | GL | Dept | Memo | Debit | Credit | Function | Project | ClassID |
|---|
| 1 |
201 |
40000 |
9998 |
MAR 26 Source Code Allocation - PAC |
484643.79 |
|
FR |
9999 |
9999998 |
| 2 |
202 |
40000 |
9998 |
MAR 26 Source Code Allocation - PAC |
805000.00 |
|
FR |
9999 |
9999998 |
| 3 |
201 |
40000 |
2100 |
Ads |
|
120211.66 |
FR-ACQ |
9999 |
1052773 |
| 4 |
201 |
40000 |
2200 |
Calltime/Major Donor |
|
90104.00 |
FR |
9999 |
1052799 |
| 5 |
201 |
40000 |
2300 |
Direct Mail (Acquisition) |
|
1718.00 |
FR-ACQ |
9999 |
1118169 |
| 6 |
201 |
40000 |
2300 |
Direct Mail (Grassroots) - Appeals |
|
37648.00 |
FR |
9999 |
1117033 |
| 7 |
201 |
40000 |
2100 |
Email |
|
100753.10 |
FR |
9999 |
1052620 |
| 8 |
201 |
40400 |
2200 |
Event |
|
1375.00 |
FR |
9999 |
1052665 |
| 9 |
201 |
40000 |
2300 |
HD Direct Mail |
|
500.00 |
FR |
9999 |
1117034 |
| 10 |
201 |
40000 |
2100 |
Merchandise |
|
20.01 |
FR |
9999 |
1052844 |
| 11 |
201 |
40000 |
2200 |
Middollar Email |
|
164.25 |
FR |
9999 |
1052768 |
| 12 |
201 |
40000 |
2300 |
Misc Checks |
|
1065.00 |
FR |
9999 |
1052794 |
| 13 |
201 |
40000 |
2200 |
National Travel |
|
25000.00 |
FR |
9999 |
1052795 |
| 14 |
201 |
40000 |
2100 |
Recurring |
|
66428.32 |
FR |
9999 |
1052774 |
| 15 |
201 |
40000 |
2100 |
Texting |
|
24545.29 |
FR |
9999 |
1052650 |
| 16 |
201 |
40000 |
2100 |
Website |
|
7611.16 |
FR |
9999 |
1052772 |
| 17 |
202 |
40000 |
3100 |
Strategic Support Contributions (IL-07) |
|
7500.00 |
PRO-IE |
2026-HC-IL07 |
1052788 |
| 18 |
202 |
40000 |
3100 |
Strategic Support Contributions (IL-09) |
|
30000.00 |
PRO-IE |
2026-HC-IL09 |
1052788 |
| 19 |
202 |
40000 |
3100 |
Strategic Support Contributions (ME-GOV) |
|
15000.00 |
PRO-IE |
2026-ME-GOV |
1052788 |
| 20 |
202 |
40000 |
3100 |
Strategic Support Contributions (PA-03) |
|
750000.00 |
PRO-IE |
2026-HC-PA03 |
1052788 |
| Line | Entity | GL | Dept | Memo | Debit | Credit | Function | Project | ClassID |
|---|
| 1 |
202 |
40000 |
3100 |
Strategic Support Contributions |
2000000.00 |
|
FR |
9999 |
1052788 |
| 2 |
202 |
40000 |
3100 |
Strategic Support Contributions (PA-03) |
|
2000000.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-03
— or head back to the
Close dashboard
for the rest of the month-end checklist.