Revenue Allocation v1 is retained during v2 validation. New closes run on v2.

Results: ContributionReport-8317018443.csv

14759 contribution rows processed

Entity Totals

EntityNGP TotalMappedExcludedUnmapped
101 $783464.6600 $150807.7300 $632656.9300 $0

Sage / NGP Cross-Check

EntityNGP Classified TotalSage TotalStatus
101 $150807.73 $458702.23 MISMATCH

Error Log

SeverityCategorySource CodeAmountRowsDetail
WARNING sage_ngp_mismatch Entity 101: Sage total (NEEDS DETAILS $248947.25 + already coded $209754.98 = $458702.23) != NGP classified total ($150807.73). Difference: $307894.50. JE uses Sage debit amount; investigate before importing.
WARNING je_imbalance JE REV-ACCR-2026-05-C4 does not balance. Debits: $458702.23, Credits: $150807.73, Difference: $307894.50. Sage debit differs from NGP credits; investigate before importing.
INFO excluded_rows 1105018 Payroll Allocation 108773.9500 2 2 rows ($108773.9500) excluded: 1105018 (Payroll Allocation) — Not fundraising revenue.
INFO excluded_rows 1123742 Insurance Allocation 3750.7900 1 1 rows ($3750.7900) excluded: 1123742 (Insurance Allocation) — Not fundraising revenue.
INFO excluded_rows 1123741 Overhead Allocations 48947.2500 1 1 rows ($48947.2500) excluded: 1123741 (Overhead Allocations) — Allocation not fundraising revenue (excluded; was direct/9999999).
INFO excluded_rows 1123744 Consultant Allocations 10000.0000 1 1 rows ($10000.0000) excluded: 1123744 (Consultant Allocations) — Allocation not fundraising revenue (excluded; was direct/9999999).
INFO excluded_rows 1066202 Interest 2184.9400 2 2 rows ($2184.9400) excluded: 1066202 (Interest) — Separate GL (41000) already coded.
INFO excluded_rows 1105016 Digital Consulting Allocation 9000.0000 1 1 rows ($9000.0000) excluded: 1105016 (Digital Consulting Allocation) — .
INFO excluded_rows 1052693 314 Transfer 450000.0000 1 1 rows ($450000.0000) excluded: 1052693 (314 Transfer) — Inter-entity transfer.
INFO entity_not_selected 3464926.6200 13462 Entity 314 Action Fund - Hard Dollar not selected for this run — 13462 rows, $3464926.6200 skipped.
INFO entity_not_selected 21564.3600 337 Entity 314 Action Impact Slate - JF not selected for this run — 337 rows, $21564.3600 skipped.
INFO entity_not_selected 75.0000 2 Entity 314 Action Impact Slate - HD not selected for this run — 2 rows, $75.0000 skipped.
INFO entity_not_selected 415100.0000 3 Entity 314 Action Victory Fund not selected for this run — 3 rows, $415100.0000 skipped.

JE Preview

REV-ACCR-2026-05-C4 (20 lines, Debits: $458702.23, Credits: $150807.73)

LineEntityGLDeptMemoDebitCreditFunctionProjectClassID
1 101 40000 9998 MAY 26 Source Code Allocation - C4 248947.25 FR 9999 9999998
2 101 40000 2100 Reversal - prior allocation (1052620) 145.00 FR 9999 1052620
3 101 40000 2100 Reversal - prior allocation (1052774) 5290.82 FR 9999 1052774
4 101 40000 2100 Reversal - prior allocation (1123306) 26205.15 FR 9999 1123306
5 101 40000 2200 Reversal - prior allocation (1052799) 110143.76 FR 9999 1052799
6 101 40000 2300 Reversal - prior allocation (1052794) 235.00 FR 9999 1052794
7 101 40000 2300 Reversal - prior allocation (1117034) 8275.00 FR 9999 1117034
8 101 40000 9999 Reversal - prior allocation (1052621) 15.00 FR 9999 1052621
9 101 40000 9999 Reversal - prior allocation (9999999) 58947.25 FR 9999 9999999
10 101 40000 2100 Reversal - prior allocation (1052773) 498.00 FR-ACQ 9999 1052773
11 101 40000 2100 Email 145.00 FR 9999 1052620
12 101 40000 9999 Refunded 15.00 FR 9999 1052621
13 101 40000 2200 Middollar Email 250.00 FR 9999 1052768
14 101 40000 2100 Ads 498.00 FR-ACQ 9999 1052773
15 101 40000 2100 Recurring 5290.82 FR 9999 1052774
16 101 40000 2300 Misc Checks 235.00 FR 9999 1052794
17 101 40000 2200 Calltime/Major Donor 110143.76 FR 9999 1052799
18 101 40000 2300 HD Direct Mail 8275.00 FR 9999 1117034
19 101 40000 2100 Middollar Texting Digital 12005.75 FR 9999 1123306
20 101 40000 2100 Middollar Email Digital 13949.40 FR 9999 1123308

Downloads

Download JE CSV Download Error Log

Re-process