I manage rooms in a building where we rent for events. I would like to create a spreadsheet that will allow me to post deposits that are collected for rooms as well as the rental fees for that event. I want the spreadsheet to highlight or somehow standout when a deposit has not been refunded. Also I would like it to total the money received from each customer. Sometimes the event is cancelled and we do a refund so I also want to be able post all money that comes in and all money that is returned to that customer. I don’t need to separate by rooms or anything like that. Nothing fancy just a total by customer with the date or dates paid and whether the deposit was refunded. Any help would certainly be appreciated! Something maybe like a ledger entry, etc? I’m not very creative lol.