Why can a customer balance differ from money collected?
A customer or supplier record identifies who a transaction belongs to. Its open items reflect eligible invoices, credits and allocations; a Treasury movement records money received or paid. Compare the source documents and allocations for the same period instead of treating the party record as a second cash balance. A party can have both customer and supplier roles without creating duplicate identities.