MENU
    Cash Sheet Report
    • 15 Aug 2024
    • 2 Minutes to read
    • Dark
    • PDF

    Cash Sheet Report

    • Dark
    • PDF

    Article summary

    The Cash Sheet Report provides a high-level overview of gross and net sales for a selected location in a given time frame. This report is useful for franchise owners who want to check up on the performance of one or more locations.

    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.


    1. In the Reports section of the left navigation pane, select My Reports.
      The My Reports screen appears.

    2. At the top of the My Reports screen, select Op.Analysis.
      The screen generates a list of reports in alphabetical order.

    3. Locate the Cash Sheet Report.

    4. Select Customize to adjust the report parameters and run the report.


    Report Parameters

    Field

    Description

    1

    Location

    Select the location for which to run the report.

    2

    Start

    First date for which to pull data for the report. The 'Start' and 'End' parameters create the date range for which data is generated. The report then displays data for all dates within the date range, including the start and end dates.

    3

    End

    Last date for which to pull data for the report. The 'Start' and 'End' parameters create the date range for which data is generated. The report then displays data for all dates within the date range, including the start and end dates.

    4

    Report Format

    Choose whether to generate the report in an expanded or collapsed view.

    5

    Display Totals Only

    If set to Yes, the report only displays columns containing totals.

    6

    View controls

    This section provides options to select, save, edit, or delete a report view.

    7

    Run

    Generates the report. Click the down arrow to the right of the Run button to export, email, or print the report.


    Report Rows

    Row

    Description

    Cash Reconciliation

    Gross and net sales for each day of the week as well as weekly totals.

    DSS

    Sales data from the Daily Sales Summary for each day of the week as well as weekly totals.

    Tax

    Sales tax amounts for each day of the week as well as the weekly total.

    Payment Types

    Amounts for each payment type, including cash, comps, credit cards, discounts, and voided transactions.

    Service Type

    Amounts for services, such as Dine In, Take Out, or Drive Thru. 

    Sales Accounts

    Amounts for each sales account, including all items assigned to the sales category. This section also includes a separate Tip row which can be expanded to show tip data.


    Email, Export, or Print the Report

    This report can be emailed, exported, or printed in custom formatting directly from the reporting window. 


    Was this article helpful?