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

Results: pipeline-store 2026-09

14876 contribution rows processed

Entity Totals

EntityNGP TotalMappedExcludedUnmapped
101 $1343186.78 $1202327.45 $140859.33 $0
201 $2471901.93 $702816.61 $1769085.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

EntityNGP Classified TotalSage TotalStatus
101 $1202327.45 $1202327.45 Match
201 $702816.61 $547716.61 MISMATCH
202 $1021602.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

SeverityCategorySource CodeAmountRowsDetail
ERROR je_imbalance JE REV-ACCR-2026-09-PAC does not balance. Debits: $1702716.61, Credits: $1724418.61, Difference: $-21702.00. Sage rejects an unbalanced JE on import. This usually means a MISCODING IN SAGE — a line booked to the wrong source code or dimension, so the NEEDS DETAILS balance the debit reverses doesn't match NGP. Fix it in Sage and re-pull the GL.
WARNING sage_ngp_mismatch Entity 201: Sage total (NEEDS DETAILS $547716.61 + already coded $0.00 = $547716.61) != NGP classified total ($702816.61). Difference: $-155100.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 ($1021602.00). Difference: $133398.00. JE uses Sage debit amount; investigate before importing.
WARNING je_imbalance JE REV-ACCR-2026-09-IS-JF does not balance. Debits: $105529.02, Credits: $96693.92, Difference: $8835.10. Sage debit differs from NGP credits; 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.

Downloads

Download Error Log

Re-process