Maintain a detailed record of any overdue accounts. Balance Owed category already includes a formula, so you simply input the original balance and payments, and find out how much a customer still owes.
Overdue Accounts
Fields: customer name, account #, tax ID/SSN, original balance, payments, balance owed