Results — ContributionReport-5693504855.csv

Results: ContributionReport-5693504855.csv

13558 contribution rows processed

Entity Totals

Entity	NGP Total	Mapped	Excluded	Unmapped
101	$1244535.7200	$1116211.0300	$128324.6900	$0
201	$1424905.1300	$421396.0700	$1003509.0600	$0
202	$296000.0000	$296000.0000	$0	$0
401	$1450.0000	$1450.0000	$0	$0
403	$42289.3100	$42289.3100	$0	$0
310-ME	$170000.0000	$170000.0000	$0	$0

Sage / NGP Cross-Check

Entity	NGP Classified Total	Sage Total	Status
101	$1116211.03	$1116211.03	Match
201	$421396.07	$361396.07	MISMATCH
202	$296000.00	$356000.00	MISMATCH
310-ME	$170000.00	$170000.00	Match
401	$1450.00	$1450.00	Match
403	$42289.31	$43814.31	MISMATCH

Error Log

Severity	Category	Source Code	Amount	Rows	Detail
WARNING	unrouted_slate		6775.0000	8	8 Impact Slate contribution(s) ($6775.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.
WARNING	sage_ngp_mismatch				Entity 403: Sage total (NEEDS DETAILS $43814.31 + already coded $0 = $43814.31) != NGP classified total ($42289.31). Difference: $1525.00. JE uses Sage debit amount; investigate before importing.
WARNING	je_imbalance				JE REV-ACCR-2026-04-IS-JF does not balance. Debits: $44517.31, Credits: $42289.31, Difference: $2228.00. Sage debit differs from NGP credits; investigate before importing.
INFO	excluded_rows	1066202 Interest	4730.7100	7	7 rows ($4730.7100) excluded: 1066202 (Interest) — Separate GL (41000) already coded.
INFO	excluded_rows	1105018 Payroll Allocation	109103.0400	2	2 rows ($109103.0400) excluded: 1105018 (Payroll Allocation) — Not fundraising revenue.
INFO	excluded_rows	1105016 Digital Consulting Allocation	18000.0000	1	1 rows ($18000.0000) excluded: 1105016 (Digital Consulting Allocation) — .
INFO	excluded_rows	1052693 314 Transfer	1000000.0000	1	1 rows ($1000000.0000) excluded: 1052693 (314 Transfer) — Inter-entity transfer.

JE Preview

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

Line	Entity	GL	Dept	Memo	Debit	Credit	Function	Project	ClassID
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)

Line	Entity	GL	Dept	Memo	Debit	Credit	Function	Project	ClassID
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-IS-HD (3 lines, Debits: $1450.00, Credits: $1450.00)

Line	Entity	GL	Dept	Memo	Debit	Credit	Function	Project	ClassID
1	401	40000	9998	APR 26 Source Code Allocation - IS-HD	1450.00		FR	9999	9999998
2	401	40000	2300	Direct Mail (Grassroots) - Appeals		1415.00	FR	9999	1117033
3	401	40000	2100	Email		35.00	FR	9999	1052620

REV-ACCR-2026-04-IS-JF (11 lines, Debits: $44517.31, Credits: $42289.31)

Line	Entity	GL	Dept	Memo	Debit	Credit	Function	Project	ClassID
1	403	40500	9998	APR 26 Source Code Allocation - IS-JF (JF-2025-Q4-PRIORITY)	703.00		PRO-JF	JF-2025-Q4-PRIORITY	9999998
2	403	40500	2300	Direct Mail (Grassroots) - Appeals		500.00	PRO-JF	JF-2025-Q4-PRIORITY	1117033
3	403	40500	2100	Recurring		203.00	PRO-JF	JF-2025-Q4-PRIORITY	1052774
4	403	40500	9998	APR 26 Source Code Allocation - IS-JF (JF-2026-Q1-PRIORITY)	9324.12		PRO-JF	JF-2026-Q1-PRIORITY	9999998
5	403	40500	2300	Direct Mail (Grassroots) - Appeals		6752.12	PRO-JF	JF-2026-Q1-PRIORITY	1117033
6	403	40500	2100	Recurring		344.00	PRO-JF	JF-2026-Q1-PRIORITY	1052774
7	403	40500	9998	APR 26 Source Code Allocation - IS-JF (JF-2026-Q2-PRIORITY)	34490.19		PRO-JF	JF-2026-Q2-PRIORITY	9999998
8	403	40500	2300	Direct Mail (Grassroots) - Appeals		214.00	PRO-JF	JF-2026-Q2-PRIORITY	1117033
9	403	40500	2100	Email		22498.00	PRO-JF	JF-2026-Q2-PRIORITY	1052620
10	403	40500	2200	Middollar Email		11674.93	PRO-JF	JF-2026-Q2-PRIORITY	1052768
11	403	40500	2100	Texting		103.26	PRO-JF	JF-2026-Q2-PRIORITY	1052650

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

Line	Entity	GL	Dept	Memo	Debit	Credit	Function	Project	ClassID
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

Unrouted Impact Slate Contributions

8 Impact Slate contribution(s) could not be routed because the bank account was empty or didn't match any prefix in slate_bank_mapping.csv.

ID	Name	Amount	Source Code	Bank Account	Assign To
20734407	Finch, Peter	$25.0000	DM2026ImpactSlateQ1	(empty)
20790568	314 Action Fund	$5250.0000	314 Transfer	(empty)
20734404	Holst, Peter	$100.0000	DM2026ImpactSlateQ1	(empty)
20734402	Kuroda, Mitzi	$1000.0000	DM2026ImpactSlateQ1	(empty)
20734403	Olsen, George	$250.0000	DM2026ImpactSlateQ1	(empty)
20734405	Moss, Anthony	$10.0000	DM2026ImpactSlateQ1	(empty)
20734408	Sabet, Abdollah	$100.0000	DM2026ImpactSlateQ1	(empty)
20734406	Driscoll, Patricia	$40.0000	DM2026ImpactSlateQ1	(empty)

Downloads

Download JE CSV Download Error Log

Re-process