We have employees who have check-out cashier checks to take to auctions. Sometimes those checks are used to purchase things and sometimes they are returned. Sometimes we just need a way for them to record a deposit.
I've been tasked with creating an application to track these withdrawals and then if something is purchased they come back and enter what was purchased with which check and if the who amount was used. Or they bring it back and indicate they are putting the unused money back into the system. Other times they will simply need to record a deposit that is not related to a withdrawal.
Is something like this possible in Smartsheet? It should be a running balance sheet, but also a way to put checks back into the system and link it to the withdrawal. Other times they will need to enter the inventory data into the sheet wich is easy. The rest I'm not sure the best way to do it.
I appreciate any guidance and especially examples.
