Allocation Run #79 — 2026-05
14759 contribution rows processed (2026-06-17 19:12:40.704708+00:00) · Re-run this month
Entity Totals
| Entity | NGP Total | Mapped | Excluded | Unmapped |
|---|---|---|---|---|
| 101 | $783464.6600 | $209754.9800 | $114709.6800 | $459000.0000 |
| 201 | $544926.6200 | $440309.3700 | $104417.2500 | $200.0000 |
| 202 | $2920000.0000 | $2920000.0000 | $0 | $0 |
| 301 | $100.0000 | $100.0000 | $0 | $0 |
| 310-ME | $415000.0000 | $415000.0000 | $0 | $0 |
Error Log
| Severity | Category | Source Code / Batch | Amount | Rows | Detail | |
|---|---|---|---|---|---|---|
| ERROR | Unmapped source code | 1123743 Digital Services Allocation | 9000.0000 | 1 | Source code 1123743 (Digital Services Allocation) not found in mapping file. 1 rows, $9000.0000. Path: Digital Services Allocation. Add to source_code_mapping.csv as direct or override. | Map → |
| ERROR | Unmapped source code | 1123745 AF IE Refund to C4 | 450000.0000 | 1 | Source code 1123745 (AF IE Refund to C4) not found in mapping file. 1 rows, $450000.0000. Path: AF IE Refund to C4. Add to source_code_mapping.csv as direct or override. | Map → |
| ERROR | Unmapped source code | 1052577 Earmark - Conduit | 200.0000 | 1 | Source code 1052577 (Earmark - Conduit) not found in mapping file. 1 rows, $200.0000. Path: Miscellaneous/Earmark - Conduit. Add to source_code_mapping.csv as direct or override. | Map → |
| INFO | Entity not in this run | 21564.3600 | 337 | Entity 314 Action Impact Slate - JF not selected for this run — 337 rows, $21564.3600 skipped. | ||
| INFO | Entity not in this run | 75.0000 | 2 | Entity 314 Action Impact Slate - HD not selected for this run — 2 rows, $75.0000 skipped. |
Excluded by mapping — 5 line(s), not contribution revenue (transfers, offsets, refunds, grants, payroll, conduit). Already subtracted; here for the audit trail.
| Source Code / Batch | Amount | Rows | Detail |
|---|---|---|---|
| 1059026 Offset | 96387.1100 | 1 | 1 rows ($96387.1100) excluded: 1059026 (Offset) — Separate GL (41200) already coded. |
| 1052693 314 Transfer | 4500.0000 | 1 | 1 rows ($4500.0000) excluded: 1052693 (314 Transfer) — Inter-entity transfer. |
| 1066202 Interest | 5715.0800 | 6 | 6 rows ($5715.0800) excluded: 1066202 (Interest) — Separate GL (41000) already coded. |
| 1105018 Payroll Allocation | 108773.9500 | 2 | 2 rows ($108773.9500) excluded: 1105018 (Payroll Allocation) — Not fundraising revenue. |
| 1123742 Insurance Allocation | 3750.7900 | 1 | 1 rows ($3750.7900) excluded: 1123742 (Insurance Allocation) — Not fundraising revenue. |
Downloads
Next steps: import the exported CSV(s) into Sage Intacct, then re-check the reconciliation for 2026-05 — or head back to the Close dashboard for the rest of the month-end checklist.