Where it usually breaks
And how to keep it from happening.
- Joining every charge directly to every payment multiplies the totals; aggregate each source by appointment first.
- A pending receipt looks like settlement because its amount matches the charges.
- A refunded payment is treated as a known partial refund without checking the external evidence.
- Appointment completion is used to bypass an unresolved balance or confirm a payment.