Allocation Run #66 — 2026-04

13558 contribution rows processed (2026-05-18 13:09:46.137085+00:00) · Re-run this month

Entity Totals

EntityNGP TotalMappedExcludedUnmapped
101 $1244535.7200 $1116211.0300 $128324.6900 $0
201 $1424905.1300 $421396.0700 $1003509.0600 $0
202 $296000.0000 $296000.0000 $0 $0
310-ME $170000.0000 $170000.0000 $0 $0

Sage / NGP Cross-Check

EntityNGP Classified TotalSage TotalStatus
101 $1116211.03 $1116211.03 Match
201 $421396.07 $361396.07 INFO — pair
202 $296000.00 $356000.00 INFO — pair
310-ME $170000.00 $170000.00 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 -60,000.00, 202 60,000.00. They net to zero across the pair — nothing to adjust.

Error Log

SeverityCategorySource Code / BatchAmountRowsDetail
WARNING unrouted slate 5250.0000 1 1 Impact Slate contribution(s) ($5250.0000) could not be routed: bank account empty or not matching any prefix in slate_bank_mapping.csv.
WARNING Sage / NGP mismatch Entity 201: Sage total (NEEDS DETAILS $361396.07 + already coded $0 = $361396.07) != NGP classified total ($421396.07). Difference: $-60000.00. JE uses Sage debit amount; investigate before importing.
WARNING Sage / NGP mismatch Entity 202: Sage total (NEEDS DETAILS $356000.00 + already coded $0 = $356000.00) != NGP classified total ($296000.00). Difference: $60000.00. JE uses Sage debit amount; investigate before importing.
INFO Entity not in this run 43814.3100 689 Entity 314 Action Impact Slate - JF not selected for this run — 689 rows, $43814.3100 skipped.
INFO Entity not in this run 1450.0000 11 Entity 314 Action Impact Slate - HD not selected for this run — 11 rows, $1450.0000 skipped.
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 4730.7100 7 7 rows ($4730.7100) excluded: 1066202 (Interest) — Separate GL (41000) already coded.
1105018 Payroll Allocation 109103.0400 2 2 rows ($109103.0400) excluded: 1105018 (Payroll Allocation) — Not fundraising revenue.
1105016 Digital Consulting Allocation 18000.0000 1 1 rows ($18000.0000) excluded: 1105016 (Digital Consulting Allocation) — .
1052693 314 Transfer 1000000.0000 1 1 rows ($1000000.0000) excluded: 1052693 (314 Transfer) — Inter-entity transfer.

Impact Slate Contributions That Couldn't Be Routed

1 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)

REV-ACCR-2026-04-C4 (10 lines, Debits: $1116211.03, Credits: $1116211.03)

exported ⚠ Export REV-ACCR-2026-04-C4
LineEntityGLDeptMemoDebitCreditFunctionProjectClassID
1 101 40000 9998 APR 26 Source Code Allocation - C4 1116211.03 FR 9999 9999998
2 101 40000 2200 Calltime/Major Donor 33980.00 FR 9999 1052799
3 101 40000 2300 Direct Mail (Grassroots) - Appeals 314.00 FR 9999 1117033
4 101 40000 2100 Email 3245.00 FR 9999 1052620
5 101 40000 2200 Middollar Email 27325.39 FR 9999 1052768
6 101 40000 2300 Misc Checks 75.00 FR 9999 1052794
7 101 40000 2200 National Travel 45000.00 FR 9999 1052795
8 101 40000 2100 Recurring 5248.64 FR 9999 1052774
9 101 40000 3100 Strategic Support Contributions 1000000.00 FR 9999 1052788
10 101 40000 2100 Texting 1023.00 FR 9999 1052650

REV-ACCR-2026-04-PAC (16 lines, Debits: $717396.07, Credits: $717396.07)

posted Export REV-ACCR-2026-04-PAC
LineEntityGLDeptMemoDebitCreditFunctionProjectClassID
1 201 40000 9998 APR 26 Source Code Allocation - PAC 361396.07 FR 9999 9999998
2 202 40000 9998 APR 26 Source Code Allocation - PAC 356000.00 FR 9999 9999998
3 201 40000 2100 Ads 65653.88 FR-ACQ 9999 1052773
4 201 40000 2200 Calltime/Major Donor 112104.00 FR 9999 1052799
5 201 40000 2300 Direct Mail (Acquisition) 18744.41 FR-ACQ 9999 1118169
6 201 40000 2300 Direct Mail (Grassroots) - Appeals 43646.52 FR 9999 1117033
7 201 40000 2100 Email 71776.62 FR 9999 1052620
8 201 40000 2300 HD Direct Mail 50.00 FR 9999 1117034
9 201 40000 2200 Middollar Email 214.25 FR 9999 1052768
10 201 40000 2300 Misc Checks 4340.00 FR 9999 1052794
11 201 40000 2200 National Travel 5000.00 FR 9999 1052795
12 201 40000 2100 Recurring 65765.54 FR 9999 1052774
13 201 40000 2100 Texting 21556.70 FR 9999 1052650
14 201 40000 2100 Website 12544.15 FR 9999 1052772
15 202 40000 3100 Strategic Support Contributions (IL-09) 5000.00 PRO-IE 2026-HC-IL09 1052788
16 202 40000 3100 Strategic Support Contributions (PA-03) 291000.00 PRO-IE 2026-HC-PA03 1052788

REV-ACCR-2026-04-PAC-NC (2 lines, Debits: $1000000.00, Credits: $1000000.00)

posted Export REV-ACCR-2026-04-PAC-NC
LineEntityGLDeptMemoDebitCreditFunctionProjectClassID
1 202 40000 3100 Strategic Support Contributions 1000000.00 FR 9999 1052788
2 202 40000 3100 Strategic Support Contributions (PA-03) 1000000.00 PRO-IE 2026-HC-PA03 1052788

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-04 — or head back to the Close dashboard for the rest of the month-end checklist.