Multi-Vendor Marketplace Payments: Ledgers & Payouts

Most first-version marketplaces I review track money with a vendor_balance column and UPDATE ... SET balance = balance + ?. It works until a partial refund lands after a payout, a chargeback arrives w