We use a daily spreadsheet to track daily sales revenue by each cashier. I am looking for a software program to be developed to record this data which should be pdf printable with the ability to pull custom dates ( day month year custom) currently we have spreadsheets using google docs. I have attached a copy of the current spreadsheet which includes formulas.
I have also included the report we receive from the casino/hotel which is generated by the POS system that the hotel installs in all casino vendor outlets. The reason we need the interface it assist with discrepancies between actual counts vs. generated system reports. I have attached the generated report for comparison to the actual accounts for the same day.
Currently, I am in an audit situation , which includes a variance. In order for me to balance actual cash against report cash, I need to view every individual day and manually calculate each line item for a 30 day period. In addition the spreadsheet is not in printable format.
- The interface will need to allow for the the addition/removal of cashiers
- Ability to add/adjust income or expense items ( note that the the spreadsheet version and the generated report itemize income or payment summary section; however, the categories related to the hotel are combine on the excel version; this needs to be corrected.)
QBO import from this interface is a future idea.
Please let me know if you are interested in this project.
Thank you,
Kathleen
... Show more