[Solved] Cashout Formula
Posted: Mon Dec 16, 2019 6:48 pm
Hello, I'm sure this exists but I am having trouble finding it. when I close my store at the end of the day I need to do a bit of math on scratch sheets and know I could do it easier with a spreadsheet.
At the end of the day I need to count all of my money. I need to leave $100 in the resister and put the rest into the bank deposit bag. So I would like a tally of the number of bills of each denomination that go in drawer and the number of each that go in the bank bag.
Say A:1 is my count of my 100s, A:2 is the count of my 50s, A:3 is my twenties, and so on. I would like two more columns to be output by the formula... For example B:1 is the number of 100s that go in the bank bag and C:1 is the number of 100s that stay in the cash drawer. B:2 is the number of 50s that go in the bank bag and C:2 is the number of 50s that stay in the cash drawer. And so on.
Obviously I'd like to get rid of the larger denominations and keep the smaller ones for the next day to make change, so the formula would have to take the total and then figure out subtracting the minimum number of pennies, then the minimum number of nickles and so on up the line until an even $100 is left in the cash drawer.
I would imagine that this is very common among nearly all retail stores so I imagine there is already a template for it, but I just don't seem to find it. If anyone knows of one that would be great, or I am perfectly willing to build it. I'm just not sure how to build the formula that takes the total cash and leaves behind the maximum number of small denominations, while depositing the maximum number of large bills.... while showing the quantities of each so I do a minimum of counting and stacking actual cash.
At the end of the day I need to count all of my money. I need to leave $100 in the resister and put the rest into the bank deposit bag. So I would like a tally of the number of bills of each denomination that go in drawer and the number of each that go in the bank bag.
Say A:1 is my count of my 100s, A:2 is the count of my 50s, A:3 is my twenties, and so on. I would like two more columns to be output by the formula... For example B:1 is the number of 100s that go in the bank bag and C:1 is the number of 100s that stay in the cash drawer. B:2 is the number of 50s that go in the bank bag and C:2 is the number of 50s that stay in the cash drawer. And so on.
Obviously I'd like to get rid of the larger denominations and keep the smaller ones for the next day to make change, so the formula would have to take the total and then figure out subtracting the minimum number of pennies, then the minimum number of nickles and so on up the line until an even $100 is left in the cash drawer.
I would imagine that this is very common among nearly all retail stores so I imagine there is already a template for it, but I just don't seem to find it. If anyone knows of one that would be great, or I am perfectly willing to build it. I'm just not sure how to build the formula that takes the total cash and leaves behind the maximum number of small denominations, while depositing the maximum number of large bills.... while showing the quantities of each so I do a minimum of counting and stacking actual cash.