Allocation Run #118 — 2026-08

15241 contribution rows processed (2026-09-16 20:30:39.697682+00:00) · Re-run this month

Entity Totals

EntityNGP TotalMappedExcludedUnmapped
101 $225345.80 $99022.54 $126323.26 $0
201 $465355.39 $463088.33 $2267.06 $0
301 $225.00 $225.00 $0 $0
401 $1143.12 $1143.12 $0 $0
403 $47177.08 $46127.08 $1050.00 $0

NEEDS DETAILS total: $609606.07 (101: $99022.54 · 201: $418088.33 · 202: $45000.00 · 301: $225.00 · 401: $1143.12 · 403: $46127.08) — Sage balances from the scheduled GL ingest, reclass journal excluded.

Sage / NGP Cross-Check

EntityNGP Classified TotalSage TotalStatus
101 $99022.54 $99022.54 Match
201 $463088.33 $418088.33 INFO — pair
202 $0.00 $45000.00 INFO — pair
301 $225.00 $225.00 Match
401 $1143.12 $1143.12 Match
403 $46127.08 $46127.08 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 -45,000.00, 202 45,000.00. They net to zero across the pair — nothing to adjust.

Error Log — 3 open in exception queue

SeverityCategorySource Code / BatchAmountRowsDetail
WARNING Sage / NGP mismatch Entity 201: Sage total (NEEDS DETAILS $418088.33 + already coded $0 = $418088.33) != NGP classified total ($463088.33). Difference: $-45000.00. JE uses Sage debit amount; investigate before importing.
WARNING Sage / NGP mismatch Entity 202: Sage total (NEEDS DETAILS $45000.00 + already coded $0 = $45000.00) != NGP classified total ($0.00). Difference: $45000.00. JE uses Sage debit amount; 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 1971.06 5 5 rows ($1971.06) excluded: 1066202 (Interest) — Separate GL (41000) already coded.
batch:324675 Slate Transfer In 08042026 5000.00 1 1 rows ($5000.00) excluded: batch:324675 (Slate Transfer In 08042026) — Transfer in.
1059026 Offset 2635.42 3 3 rows ($2635.42) excluded: 1059026 (Offset) — Separate GL (41200) already coded.
1105018 Payroll Allocation 125033.84 2 2 rows ($125033.84) 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)

REV-ACCR-2026-08-C4 (8 lines, Debits: $99022.54, Credits: $99022.54)

exported Export REV-ACCR-2026-08-C4
LineEntityGLDeptMemoDebitCreditFunctionProjectClassID
1 101 40000 9998 AUG 26 Source Code Allocation - C4 99022.54 FR 9999 9999998
2 101 40000 2100 Email 257.00 FR 9999 1052620
3 101 40000 2100 Recurring 6567.76 FR 9999 1052774
4 101 40000 2300 Misc Checks 150.00 FR 9999 1052794
5 101 40000 2200 Calltime/Major Donor 63463.29 FR 9999 1052799
6 101 40000 2300 HD Direct Mail 3350.00 FR 9999 1117034
7 101 40000 2100 Middollar Texting Digital 16946.35 FR 9999 1123306
8 101 40000 2100 Middollar Email Digital 8288.14 FR 9999 1123308

REV-ACCR-2026-08-PAC (15 lines, Debits: $463088.33, Credits: $463088.33)

superseded Export REV-ACCR-2026-08-PAC
LineEntityGLDeptMemoDebitCreditFunctionProjectClassID
1 201 40000 9998 AUG 26 Source Code Allocation - PAC 418088.33 FR 9999 9999998
2 202 40000 9998 AUG 26 Source Code Allocation - PAC 45000.00 FR 9999 9999998
3 201 40000 2100 Email 110201.00 FR 9999 1052620
4 201 40000 9999 Refunded 10.00 FR 9999 1052621
5 201 40000 2100 Texting 35615.79 FR 9999 1052650
6 201 40000 2100 Website 24749.02 FR 9999 1052772
7 201 40000 2100 Ads 76341.87 FR-ACQ 9999 1052773
8 201 40000 2100 Recurring 68400.06 FR 9999 1052774
9 201 40000 2300 Misc Checks 893.89 FR 9999 1052794
10 201 40000 2200 National Travel 11500.00 FR 9999 1052795
11 201 40000 2200 Calltime/Major Donor 89629.00 FR 9999 1052799
12 201 40000 2300 Direct Mail (Grassroots) 35241.98 FR 9999 1117033
13 201 40000 2300 Direct Mail - Acquisition 7995.00 FR-ACQ 9999 1118169
14 201 40000 2100 Middollar Texting Digital 1475.22 FR 9999 1123306
15 201 40000 2100 Middollar Email Digital 1035.50 FR 9999 1123308

REV-ACCR-2026-08-IS-HD (3 lines, Debits: $1143.12, Credits: $1143.12)

exported Export REV-ACCR-2026-08-IS-HD
LineEntityGLDeptMemoDebitCreditFunctionProjectClassID
1 401 40000 9998 AUG 26 Source Code Allocation - IS-HD 1143.12 FR 9999 9999998
2 401 40000 2300 Misc Checks 121.00 FR 9999 1052794
3 401 40000 2300 Direct Mail (Grassroots) 1022.12 FR 9999 1117033

REV-ACCR-2026-08-IS-JF (12 lines, Debits: $46127.08, Credits: $46127.08)

exported Export REV-ACCR-2026-08-IS-JF
LineEntityGLDeptMemoDebitCreditFunctionProjectClassID
1 403 40500 9998 AUG 26 Source Code Allocation - IS-JF (JF-2026-AUG-PRIORITY) 31118.00 PRO-JF JF-2026-AUG-PRIORITY 9999998
2 403 40500 2100 Email 23624.00 PRO-JF JF-2026-AUG-PRIORITY 1052620
3 403 40500 2100 Texting 4501.00 PRO-JF JF-2026-AUG-PRIORITY 1052650
4 403 40500 2100 Website 395.00 PRO-JF JF-2026-AUG-PRIORITY 1052772
5 403 40500 2300 Direct Mail (Grassroots) 2052.00 PRO-JF JF-2026-AUG-PRIORITY 1117033
6 403 40500 2100 Middollar Texting Digital 511.00 PRO-JF JF-2026-AUG-PRIORITY 1123306
7 403 40500 2100 Middollar Email Digital 35.00 PRO-JF JF-2026-AUG-PRIORITY 1123308
8 403 40500 9998 AUG 26 Source Code Allocation - IS-JF (JF-2026-JUN-PRIORITY) 15009.08 PRO-JF JF-2026-JUN-PRIORITY 9999998
9 403 40500 2100 Email 3.00 PRO-JF JF-2026-JUN-PRIORITY 1052620
10 403 40500 2100 Texting 6.00 PRO-JF JF-2026-JUN-PRIORITY 1052650
11 403 40500 2100 Recurring 391.00 PRO-JF JF-2026-JUN-PRIORITY 1052774
12 403 40500 2300 Direct Mail (Grassroots) 14609.08 PRO-JF JF-2026-JUN-PRIORITY 1117033

Downloads

Download full JE CSV Download Error Log

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