Allocation Run #44 — 2025-08
1494 contribution rows processed
(2026-04-22 20:01:23.378535+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-2025-08-IS-JF does not balance. Debits: $58626.53, Credits: $27703.53, Difference: $30923.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 |
|---|
| 403 |
$27703.5300 |
$27703.5300 |
$0 |
$0 |
Sage / NGP Cross-Check
| Entity | NGP Classified Total | Sage Total | Status |
|---|
| 403 |
$27703.53 |
$58736.53 |
MISMATCH
|
Error Log
| Severity | Category | Source Code / Batch | Amount | Rows | Detail | |
|---|
| WARNING |
unrouted slate |
|
31033.0000 |
758 |
758 Impact Slate contribution(s) ($31033.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 $56576.41 + already coded $2160.12 = $58736.53) != NGP classified total ($27703.53). Difference: $31033.00. JE uses Sage debit amount; investigate before importing. |
|
| WARNING |
JE does not balance |
|
|
|
JE REV-ACCR-2025-08-IS-JF does not balance. Debits: $58626.53, Credits: $27703.53, Difference: $30923.00. Sage debit differs from NGP credits; investigate before importing. |
|
Impact Slate Contributions That Couldn't Be Routed
758 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 |
403 |
40500 |
2300 |
Reversal - prior allocation (1117033) |
2160.12 |
|
PRO-JF |
JF-2025-Q2-PRIORITY |
1117033 |
| 2 |
403 |
40500 |
9998 |
AUG 26 Source Code Allocation - IS-JF (JF-2025-Q2-PRIORITY) |
1209.00 |
|
PRO-JF |
JF-2025-Q2-PRIORITY |
9999998 |
| 3 |
403 |
40500 |
2300 |
Direct Mail (Grassroots) - Appeals |
|
2385.12 |
PRO-JF |
JF-2025-Q2-PRIORITY |
1117033 |
| 4 |
403 |
40500 |
2100 |
Email |
|
110.00 |
PRO-JF |
JF-2025-Q2-PRIORITY |
1052620 |
| 5 |
403 |
40500 |
2100 |
Recurring |
|
859.00 |
PRO-JF |
JF-2025-Q2-PRIORITY |
1052774 |
| 6 |
403 |
40500 |
2100 |
Texting |
|
15.00 |
PRO-JF |
JF-2025-Q2-PRIORITY |
1052650 |
| 7 |
403 |
40500 |
9998 |
AUG 26 Source Code Allocation - IS-JF (JF-2025-Q3-PRIORITY) |
55257.41 |
|
PRO-JF |
JF-2025-Q3-PRIORITY |
9999998 |
| 8 |
403 |
40500 |
2200 |
Calltime/Major Donor |
|
1000.00 |
PRO-JF |
JF-2025-Q3-PRIORITY |
1052799 |
| 9 |
403 |
40500 |
2300 |
Direct Mail (Grassroots) - Appeals |
|
1011.41 |
PRO-JF |
JF-2025-Q3-PRIORITY |
1117033 |
| 10 |
403 |
40500 |
2100 |
Email |
|
4500.00 |
PRO-JF |
JF-2025-Q3-PRIORITY |
1052620 |
| 11 |
403 |
40500 |
2100 |
Recurring |
|
277.00 |
PRO-JF |
JF-2025-Q3-PRIORITY |
1052774 |
| 12 |
403 |
40500 |
2100 |
Texting |
|
17546.00 |
PRO-JF |
JF-2025-Q3-PRIORITY |
1052650 |
Downloads
Next steps: import the exported CSV(s) into Sage Intacct, then
re-check the reconciliation for 2025-08
— or head back to the
Close dashboard
for the rest of the month-end checklist.