Results: pipeline-store 2026-09
14876 contribution rows processed
Entity Totals
| Entity | NGP Total | Mapped | Excluded | Unmapped |
|---|---|---|---|---|
| 101 | $1343186.78 | $1202327.45 | $140859.33 | $0 |
| 201 | $2471901.93 | $702716.61 | $1769185.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 |
Sage / NGP Cross-Check
| Entity | NGP Classified Total | Sage Total | Status |
|---|---|---|---|
| 101 | $1202327.45 | $1202327.45 | Match |
| 201 | $702716.61 | $547716.61 | MISMATCH |
| 202 | $1000000.00 | $1155000.00 | MISMATCH |
| 301 | $350.00 | $350.00 | Match |
| 401 | $2196.47 | $2196.47 | Match |
| 403 | $96693.92 | $96693.92 | Match |
Error Log — 4 open in exception queue
| Severity | Category | Source Code | Amount | Rows | Detail |
|---|---|---|---|---|---|
| WARNING | sage_ngp_mismatch | Entity 201: Sage total (NEEDS DETAILS $547716.61 + already coded $0.00 = $547716.61) != NGP classified total ($702716.61). Difference: $-155000.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 ($1000000.00). Difference: $155000.00. JE uses Sage debit amount; investigate before importing. | |||
| INFO | excluded_rows | 1066202 Interest | 1930.91 | 2 | 2 rows ($1930.91) excluded: 1066202 (Interest) — Separate GL (41000) already coded. |
| INFO | excluded_rows | 1052693 314 Transfer | 1771929.68 | 12 | 12 rows ($1771929.68) excluded: 1052693 (314 Transfer) — Inter-entity transfer. |
| INFO | excluded_rows | 1105018 Payroll Allocation | 139558.08 | 2 | 2 rows ($139558.08) excluded: 1105018 (Payroll Allocation) — Not fundraising revenue. |
| INFO | excluded_rows | 1059026 Offset | 525.98 | 1 | 1 rows ($525.98) excluded: 1059026 (Offset) — Separate GL (41200) already coded. |
| INFO | excluded_rows | 1052577 Earmark - Conduit | 100.00 | 2 | 2 rows ($100.00) excluded: 1052577 (Earmark - Conduit) — Earmark conduit. |
| INFO | in_kind | 21602.00 | 1 | 1 in-kind gift(s) ($21,602.00) in entity 202 left off the accrual JE — non-cash, never deposited, so not in NEEDS DETAILS. Book by hand in Sage: debit the expense/asset received, credit 40600 In-Kind. Gifts: HMP $21,602.00 (contribution 21588997). |
JE Preview
REV-ACCR-2026-09-C4 (12 lines, Debits: $1202327.45, Credits: $1202327.45)
| Line | Entity | GL | Dept | Memo | Debit | Credit | Function | Project | ClassID |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 101 | 40000 | 9998 | SEP 26 Source Code Allocation - C4 | 1202327.45 | FR | 9999 | 9999998 | |
| 2 | 101 | 40000 | 2100 | 418.00 | FR | 9999 | 1052620 | ||
| 3 | 101 | 40000 | 2100 | Texting | 230.00 | FR | 9999 | 1052650 | |
| 4 | 101 | 40000 | 2100 | Recurring | 6739.58 | FR | 9999 | 1052774 | |
| 5 | 101 | 40000 | 3100 | Strategic Support Contributions | 1000000.00 | FR | 9999 | 1052788 | |
| 6 | 101 | 40000 | 2300 | Misc Checks | 50.00 | FR | 9999 | 1052794 | |
| 7 | 101 | 40000 | 2200 | National Travel | 5000.00 | FR | 9999 | 1052795 | |
| 8 | 101 | 40000 | 2200 | Calltime/Major Donor | 137805.00 | FR | 9999 | 1052799 | |
| 9 | 101 | 40000 | 2300 | Direct Mail (Grassroots) | 1200.00 | FR | 9999 | 1117033 | |
| 10 | 101 | 40000 | 2300 | HD Direct Mail | 7560.00 | FR | 9999 | 1117034 | |
| 11 | 101 | 40000 | 2100 | Middollar Texting Digital | 33942.87 | FR | 9999 | 1123306 | |
| 12 | 101 | 40000 | 2100 | Middollar Email Digital | 9382.00 | FR | 9999 | 1123308 |
REV-ACCR-2026-09-PAC (15 lines, Debits: $1702716.61, Credits: $1702716.61)
| Line | Entity | GL | Dept | Memo | Debit | Credit | Function | Project | ClassID |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 201 | 40000 | 9998 | SEP 26 Source Code Allocation - PAC | 547716.61 | FR | 9999 | 9999998 | |
| 2 | 202 | 40000 | 9998 | SEP 26 Source Code Allocation - PAC | 1155000.00 | FR | 9999 | 9999998 | |
| 3 | 201 | 40000 | 2100 | 109847.43 | FR | 9999 | 1052620 | ||
| 4 | 201 | 40000 | 2100 | Texting | 35256.97 | FR | 9999 | 1052650 | |
| 5 | 201 | 40000 | 2100 | Website | 18030.23 | FR | 9999 | 1052772 | |
| 6 | 201 | 40000 | 2100 | Ads | 111142.16 | FR-ACQ | 9999 | 1052773 | |
| 7 | 201 | 40000 | 2100 | Recurring | 72713.06 | FR | 9999 | 1052774 | |
| 8 | 201 | 40000 | 2300 | Misc Checks | 10840.51 | FR | 9999 | 1052794 | |
| 9 | 201 | 40000 | 2200 | Calltime/Major Donor | 282629.00 | FR | 9999 | 1052799 | |
| 10 | 201 | 40000 | 2300 | Direct Mail (Grassroots) | 53488.14 | FR | 9999 | 1117033 | |
| 11 | 201 | 40000 | 2300 | HD Direct Mail | 5.00 | FR | 9999 | 1117034 | |
| 12 | 201 | 40000 | 2300 | Direct Mail - Acquisition | 6703.00 | FR-ACQ | 9999 | 1118169 | |
| 13 | 201 | 40000 | 2100 | Middollar Texting Digital | 632.00 | FR | 9999 | 1123306 | |
| 14 | 201 | 40000 | 2100 | Middollar Email Digital | 1429.11 | FR | 9999 | 1123308 | |
| 15 | 202 | 40000 | 3100 | Strategic Support Contributions | 1000000.00 | FR | 9999 | 1052788 |
REV-ACCR-2026-09-IS-HD (4 lines, Debits: $2196.47, Credits: $2196.47)
| Line | Entity | GL | Dept | Memo | Debit | Credit | Function | Project | ClassID |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 401 | 40000 | 9998 | SEP 26 Source Code Allocation - IS-HD | 2196.47 | FR | 9999 | 9999998 | |
| 2 | 401 | 40000 | 2100 | 186.47 | FR | 9999 | 1052620 | ||
| 3 | 401 | 40000 | 2300 | Misc Checks | 25.00 | FR | 9999 | 1052794 | |
| 4 | 401 | 40000 | 2300 | Direct Mail (Grassroots) | 1985.00 | FR | 9999 | 1117033 |
REV-ACCR-2026-09-IS-JF (15 lines, Debits: $96693.92, Credits: $96693.92)
| Line | Entity | GL | Dept | Memo | Debit | Credit | Function | Project | ClassID |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 403 | 40500 | 9998 | SEP 26 Source Code Allocation - IS-JF (JF-2026-AUG-PRIORITY) | 33251.92 | PRO-JF | JF-2026-AUG-PRIORITY | 9999998 | |
| 2 | 403 | 40500 | 2100 | 778.00 | PRO-JF | JF-2026-AUG-PRIORITY | 1052620 | ||
| 3 | 403 | 40500 | 2100 | Texting | 317.00 | PRO-JF | JF-2026-AUG-PRIORITY | 1052650 | |
| 4 | 403 | 40500 | 2100 | Recurring | 316.00 | PRO-JF | JF-2026-AUG-PRIORITY | 1052774 | |
| 5 | 403 | 40500 | 2300 | Direct Mail (Grassroots) | 31772.92 | PRO-JF | JF-2026-AUG-PRIORITY | 1117033 | |
| 6 | 403 | 40500 | 2100 | Middollar Texting Digital | 50.00 | PRO-JF | JF-2026-AUG-PRIORITY | 1123306 | |
| 7 | 403 | 40500 | 2100 | Middollar Email Digital | 18.00 | PRO-JF | JF-2026-AUG-PRIORITY | 1123308 | |
| 8 | 403 | 40500 | 9998 | SEP 26 Source Code Allocation - IS-JF (JF-2026-FINALSTRETCH) | 63442.00 | PRO-JF | JF-2026-FINALSTRETCH | 9999998 | |
| 9 | 403 | 40500 | 2100 | 50861.00 | PRO-JF | JF-2026-FINALSTRETCH | 1052620 | ||
| 10 | 403 | 40500 | 2100 | Texting | 5903.00 | PRO-JF | JF-2026-FINALSTRETCH | 1052650 | |
| 11 | 403 | 40500 | 2100 | Website | 100.00 | PRO-JF | JF-2026-FINALSTRETCH | 1052772 | |
| 12 | 403 | 40500 | 2200 | Calltime/Major Donor | 1000.00 | PRO-JF | JF-2026-FINALSTRETCH | 1052799 | |
| 13 | 403 | 40500 | 2300 | Direct Mail (Grassroots) | 1235.00 | PRO-JF | JF-2026-FINALSTRETCH | 1117033 | |
| 14 | 403 | 40500 | 2100 | Middollar Texting Digital | 2443.00 | PRO-JF | JF-2026-FINALSTRETCH | 1123306 | |
| 15 | 403 | 40500 | 2100 | Middollar Email Digital | 1900.00 | PRO-JF | JF-2026-FINALSTRETCH | 1123308 |