- 08 Jul 2024
- 3 Minutes to read
- Print
- DarkLight
- PDF
Cash Sheet Export
- Updated on 08 Jul 2024
- 3 Minutes to read
- Print
- DarkLight
- PDF
The Cash Sheet Export provides a detailed look at credits and debits from all sales accounts for a selected location on a given date. This report provides insight into cash flow and highlights any areas where balances do not match up.
Gross sales refers to the total of all related sales transactions in a given time frame. Gross sales does not account for cost of sales or deductions, such as comps and discounts.
Net sales refers to the total of all related sales transactions in a given time frame minus the cost of sale and deductions, such as comps and discounts.
Navigation
In the Reports section of the left navigation pane, select My Reports.
The My Reports screen appears.At the top of the My Reports screen, select Op.Analysis.
The screen generates a list of reports in alphabetical order.Locate the Cash Sheet Report.
Select Customize to adjust the report parameters and run the report.
Report Parameters
Field | Description | |
---|---|---|
Filter By | Location reporting category by which to filter the report.
| |
Filter | Allows users to apply one or more filter options from the location reporting category that they selected in the Filter By menu. The selected filters determine which locations appear in the generated report.
| |
Start | Select the first date to include in the report. The selected Start and End dates create the date range for the report. | |
End | Select the last date to include in the report. The selected Start and End dates create the date range for the report. | |
Exclude Delivery Fees From Net Sales | If True is selected, then delivery fees do not impact calculations for Net Sales. | |
View controls | Select, save, edit, or delete a report view. | |
Run | Generate the report. |
Report Columns
Row | Description |
---|---|
Store # | Identification number for the store. |
Store Description | Name or short description of the store. |
Franchise Site # | Franchise identification number. |
Business Date | Date on which the location reported the sales amounts that are displayed in the row. |
Gross Food Sales | Total amount in gross sales of food items and the associated account number. |
Gross Non Food Sales | Total amount in gross sales of non-food items and the associated account number. |
Total Gross Sales | Total amount in gross sales for all items, including food items and non-food items, and the associated account number. |
Net Food Sales | Total amount in net sales of food items and the associated account number. |
Net Non Food Sales | Total amount in net sales of non-food items and the associated account number. |
Total Net Sales | Total amount in net sales for all items, including food items and non-food items, and the associated account number. |
Credit Cards | Amount in sales in which credit cards were used for purchase. |
Deposit | Amount deposited into the account. |
Gift Cards Redeemed | Amount in sales in which gift cards were redeemed for purchase. |
Guest Count | Number of guests at the location. |
Over/Short | Amount above or below the amount as calculated by the DSS. |
Paid Ins | Amount from Paid Ins. |
Paid Outs | Amount from Paid Outs. |
R365 Deposit | Amount to be deposited to the bank for the day. |
Total Expected Cash | Amount of cash that the restaurant manager expects the location to earn for the day. Compare this amount to the amount in the R365 Deposit column to gain an understanding of expected v. actual amounts and adjust future expectations based on actual data. |
Transaction Count | Number of transactions for the day. |
Sales Accounts | Additional columns provide account numbers and amounts for all configured sales accounts. |
Email, Export, or Print the Report
This report can be emailed, exported, or printed in custom formatting directly from the reporting window. Click here to learn how to send, export, or print this report.