You may also want to run the Total Pay report to help you see the cash tips. Since the report shows the total pay by pay type, you can export it to excel, then customize it to show only the cash tips total.
On the left pane, select the Reports menu.
In the Find report by name field, enter and select Total Pay.
Filter the report to show your desired date range and work location, then hit Run Report.
Drop me a reply if I can help you with anything else. Hope you have a good one.