Allocation Run #55 — 2025-08

17185 contribution rows processed (2026-04-29 02:24:48.731906+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.

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

Entity Totals

EntityNGP TotalMappedExcludedUnmapped
403 $58736.5300 $58736.5300 $0 $0

Sage / NGP Cross-Check

EntityNGP Classified TotalSage TotalStatus
403 $58736.53 $58736.53 Match

Error Log

SeverityCategorySource Code / BatchAmountRowsDetail
WARNING JE does not balance JE REV-ACCR-2025-08-IS-JF does not balance. Debits: $89659.53, Credits: $58736.53, Difference: $30923.00. Sage debit differs from NGP credits; investigate before importing.
INFO Entity not in this run 375826.3000 15161 Entity 314 Action Fund - Hard Dollar not selected for this run — 15161 rows, $375826.3000 skipped.
INFO Entity not in this run 213898.8400 530 Entity 314 Action not selected for this run — 530 rows, $213898.8400 skipped.

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)

REV-ACCR-2025-08-IS-JF (16 lines, Debits: $89659.53, Credits: $58736.53)

exported Export REV-ACCR-2025-08-IS-JF
LineEntityGLDeptMemoDebitCreditFunctionProjectClassID
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 (GOPH) 31033.00 PRO-JF GOPH 9999998
3 403 40500 2200 Calltime/Major Donor 1000.00 PRO-JF GOPH 1052799
4 403 40500 2100 Email 2461.00 PRO-JF GOPH 1052620
5 403 40500 2100 Texting 27572.00 PRO-JF GOPH 1052650
6 403 40500 9998 AUG 26 Source Code Allocation - IS-JF (JF-2025-Q2-PRIORITY) 1209.00 PRO-JF JF-2025-Q2-PRIORITY 9999998
7 403 40500 2300 Direct Mail (Grassroots) - Appeals 2385.12 PRO-JF JF-2025-Q2-PRIORITY 1117033
8 403 40500 2100 Email 110.00 PRO-JF JF-2025-Q2-PRIORITY 1052620
9 403 40500 2100 Recurring 859.00 PRO-JF JF-2025-Q2-PRIORITY 1052774
10 403 40500 2100 Texting 15.00 PRO-JF JF-2025-Q2-PRIORITY 1052650
11 403 40500 9998 AUG 26 Source Code Allocation - IS-JF (JF-2025-Q3-PRIORITY) 55257.41 PRO-JF JF-2025-Q3-PRIORITY 9999998
12 403 40500 2200 Calltime/Major Donor 1000.00 PRO-JF JF-2025-Q3-PRIORITY 1052799
13 403 40500 2300 Direct Mail (Grassroots) - Appeals 1011.41 PRO-JF JF-2025-Q3-PRIORITY 1117033
14 403 40500 2100 Email 4500.00 PRO-JF JF-2025-Q3-PRIORITY 1052620
15 403 40500 2100 Recurring 277.00 PRO-JF JF-2025-Q3-PRIORITY 1052774
16 403 40500 2100 Texting 17546.00 PRO-JF JF-2025-Q3-PRIORITY 1052650

Downloads

Download full JE CSV Download Error Log

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.