Sales are recorded in the tracker when stock leaves a store. Here is the money from them: received, held, banked, owed.

Outstanding is what each customer still owes today, across every year.

Cash an agent collected for a sale and has not yet paid into the bank. Mark it banked with the date and the bank reference.