Need a monthly report that shows daily CASH sales totals
As a bookkeeper I have a request for an additional report that shows a monthly report with daily cash sales totals. My restaurant client makes daily bank deposits of the CASH they receive. I need to check if what they deposit matches with the cash sales according to Clover. If they deposited more or less than the actual cash sales then I need to record that in the books as cash over or short. Right now no such report exists so I have to look at each day, scroll down, write down the amount on a spreadsheet. Then the next day, and so on. Can you make a report that could be exported as an excel file? Make one column with the every date that month, one column with the cash sales according to Clover, and leave one column blank so I can use it to record the actual cash deposited. Maybe you could even make another column that then automatically calculates the cash over or short.
-
vinay kadari commented
This seems very basic requirement for any business collecting the cash, they would like to see how much cash collected vs deposited in the bank account. Very helpful for monthly cash recon with the bank account. they have a report for card deposits (per day $xyz amount getting deposited) which can be reconciled with monthly bank statements. need similar one for cash deposits. Card deposits report is under Finance -> deposits (just add a cash component to it)