Allocation Run #135 — 2026-09

14876 contribution rows processed (2026-10-14 21:17:10.425841+00:00) · Re-run this month

Blocked: this run has blocking errors — no JE export until they're resolved (see the error log below).
⚠ 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.

Open the reconcile screen for this month and use Diagnose on the off row →

Entity Totals

EntityNGP TotalMappedExcludedUnmapped
101 $1343186.78 $1202327.45 $140859.33 $0
201 $2471901.93 $702816.61 $1769085.32 $0
202 $1021602.00 $1021602.00 $0 $0
301 $4350.00 $350.00 $4000.00 $0
401 $2196.47 $2196.47 $0 $0
403 $96693.92 $96693.92 $0 $0

NEEDS DETAILS total: $3035784.45 (101: $1202327.45 · 201: $547716.61 · 202: $1155000.00 · 301: $350.00 · 401: $2196.47 · 403: $96693.92 · 501: $31500.00) — Sage balances from the scheduled GL ingest, reclass journal excluded.

Sage / NGP Cross-Check

EntityNGP Classified TotalSage TotalStatus
101 $1202327.45 $1202327.45 Match
201 $702816.61 $547716.61 INFO — pair
202 $1021602.00 $1155000.00 INFO — pair
301 $350.00 $350.00 Match
401 $2196.47 $2196.47 Match
403 $96693.92 $96693.92 Match
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 -155,100.00, 202 133,398.00.
Suggested overage adjustment: the pair nets to $-21,702.00 — review the 202 overage/reclass line for that amount before importing.

Organization Revenue — $21602.00 across 1 gift(s) from 1 contact(s)

Organization gifts book to 40300 Grants & Institutional Funding instead of 40000 Individual Contributions. Source codes mapped to their own account by nature of the revenue (event, list rental, joint fundraising) are left alone. Change any of it below, then re-run the month.

GL accountAmountGifts
40600$21602.001
Review contacts — 1 shown. Set an exception for a donor NGP flagged wrong, or send one donor to a different account.
ContactAmountGiftsEntity GLSource code(s)Decided byChange
HMP $21602.00 1 202 40600 IE Contact override

Per-source-code exceptions (all org gifts on one code to a specific account) live on the Source Codes tab as Org GL.

Error Log — 4 open in exception queue

SeverityCategorySource Code / BatchAmountRowsDetail
ERROR JE does not balance JE REV-ACCR-2026-09-PAC does not balance. Debits: $1702716.61, Credits: $1724418.61, Difference: $-21702.00. Sage rejects an unbalanced JE on import. This usually means a MISCODING IN SAGE — a line booked to the wrong source code or dimension, so the NEEDS DETAILS balance the debit reverses doesn't match NGP. Fix it in Sage and re-pull the GL.
WARNING Sage / NGP mismatch Entity 201: Sage total (NEEDS DETAILS $547716.61 + already coded $0.00 = $547716.61) != NGP classified total ($702816.61). Difference: $-155100.00. JE uses Sage debit amount; investigate before importing.
WARNING Sage / NGP mismatch Entity 202: Sage total (NEEDS DETAILS $1155000.00 + already coded $0.00 = $1155000.00) != NGP classified total ($1021602.00). Difference: $133398.00. JE uses Sage debit amount; investigate before importing.
WARNING JE does not balance JE REV-ACCR-2026-09-IS-JF does not balance. Debits: $105529.02, Credits: $96693.92, Difference: $8835.10. 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 / BatchAmountRowsDetail
1066202 Interest 1930.91 2 2 rows ($1930.91) excluded: 1066202 (Interest) — Separate GL (41000) already coded.
1052693 314 Transfer 1771929.68 12 12 rows ($1771929.68) excluded: 1052693 (314 Transfer) — Inter-entity transfer.
1105018 Payroll Allocation 139558.08 2 2 rows ($139558.08) excluded: 1105018 (Payroll Allocation) — Not fundraising revenue.
1059026 Offset 525.98 1 1 rows ($525.98) excluded: 1059026 (Offset) — Separate GL (41200) already coded.

Downloads

Download Error Log

Next steps: import the exported CSV(s) into Sage Intacct, then re-check the reconciliation for 2026-09 — or head back to the Close dashboard for the rest of the month-end checklist.