Sales Reports
      Back to home
      1. OrderMate Help Guides
      2. Reporting
      3. Sales Reports

      Daily Summary By Category & Account Type Reports

      Summary of the Reports

      The Daily Summary by Category or Daily Summary by Account Type reports show high level activity that are usually given to or accessed by the accounts team to be used for weekly accounting purposes. These are the most commonly used end of day or end of week reports. These reports are also often used by senior management to make sure the venue is on track to hit is targets for the week. 

      Note: To find these reports search 'Daily Summary' in OfficeMate


      Available Filters in the Report

      • Week Ending
      • Summary or Location
      • Category or Account Type

       

      The Information in the Report

      Filters

      • This report is a week ending report
      • The following parameters can be set by searching;
        • Daily Summary by Category - Summary
        • Daily Summary by Category - By Location
        • Daily Summary by Account Type - Summary
        • Daily Summary by Account Type - By Location

      Day Parts

      • Each day part is shown in a separate table of the reports
      • Each field in the table below is repeated per day part
      • To create new day parts search 'Day Part' in OfficeMate

      Category

      • To view sales by category select the 'Daily Summary by Category' reports
      • Sales will then be separated per category

      Account Type

      • To view sales by account type select the 'Daily Summary by Category' reports
      • Sales will then be separated per account type

      Locations

      • Each field in the table below is grouped by location in the 'Summary' reports
      • Each field in the table below is shown in a separate table of the reports in the 'By Location' reports
      • To create new locations search 'Locations' in OfficeMate

       

      Day Part per Location Tables

      Day Part

      • The name of the day part is shown on the far left on the header of each report section
      • All day parts will be combined into daily totals if day parts are not configured

      Week Days

      • Each day of the week is displayed left to right on the header of each report section

      Total

      • The totals for the week are displayed on the far right on the header of each report section

      Sales*^ (per category or per account type)

      • The total $ sale value for this category or account type
      • * indicates sales are EX tax
      • ^ indicates sales are after discounts & surcharges
      • This field is repeated for all categories or account type

      Percentage % (per category or per account type)

      • The % of total sales for this category or account type
      • This field is repeated for all categories or account type

      Disc (per category or per account type 

      • The $ value of discounts for this category or account type
      • Represented as a (+) positive value to indicate that the price was lower than the usual price (a + cost to the business)
      • This field is repeated for all categories or account type

      Sur (per category or per account type)

      • The $ value of surcharges for this category or account type
      • Represented as a (-) negative value to indicate that the price was higher than the usual price (a - cost to the business)
      • This field is repeated for all categories or account type

      Ref (per category or per account type)

      • The $ value of refunds for this category or account type
      • This field is repeated for all categories or account type

      Volume (per category or per account type)

      • The number of items sold for this category or account type
      • This field is repeated for all categories or account type

      Volume

      • The total number of items sold for all categories or account type

      Sales Ex Tax^

      • The total $ sales value Ex Tax for all categories or account types
      • ^ indicates sales are after discounts & surcharges

      Discounts

      • The $ value of discounts for all categories or account types
      • Represented as a (+) positive value to indicate that the price was lower than the usual price (a + cost to the business)

      Surcharges

      • The $ value of surcharges for all categories or account types
      • Represented as a (-) negative value to indicate that the price was higher than the usual price (a - cost to the business)

      Tax

      • The total tax collected for all categories or account types

      Sales Inc Tax^

      • The total $ sales value Inc Tax for all categories or account types
      • ^ indicates sales are after discounts & surcharges

      Covers

      • The amount of covers entered in the table terminal mode

      $/Head

      • The average spend per cover for all categories or account types using the table terminal mode
      • This sales figure is EX tax
      • This sales figures is after discounts & surcharges

      Total for all locations 

      • The total for all locations, for all day parts, is shown

       

      Note: * indicates sales are excluding tax. ^ indicates sales are discount and surcharges. However, this configuration can be adjusted in Advanced Config - Report Properties in OfficeMate. 

      Daily Debtor Activity Table

      Nett Cust Account Added

      • The total sale value of items added to debtors
      • Minus (-) any refunds made to debtors (a reverse sale)
      • Sales figures are Inc GST
      • Sales figures are including discount or surcharges applied prior to being added to the debtor

      Nett Cust Account Paid

      • All payments or adjustments that have been made to debtors
        • (+) Cash or Card
        • (+) Discounts (debtor adjustments)
        • (-) Surcharges (debtor adjustments)

      Cust Account Discount 

      • The total discounts applied to debtor accounts (debtor adjustments)
      • Represented as a (+) positive value to indicate that the price was lower than the usual price (a + cost to the business)

      Cust Account Surcharge

      • The total surcharges applied to debtor accounts (debtor adjustments)
      • Represented as a (-) negative value to indicate that the price was higher than the usual price (a - cost to the business)

      Account paid Ex Adj

      • The total payments made to a debtor
      • Minus (-) any refunds made to debtors (a reverse sale)
      • Excluding discounts or surcharges (debtor adjustments)

       

       

      Daily Voucher Activity Table 

      Topups

      • Payments made to vouchers

      Topup Reversals

      • Refunds of payments made to vouchers

      Redeems

      • Vouchers redeemed (used for purchases)

      Redeem Reversals

      • Refunds of vouchers redeemed

      Total

      • Total voucher activity
      • The sum of;
        • (+) topups
        • (-) topup reversals
        • (-) redeems
        • (+) redeem reversals

       

      Reconciliation Summary Table

      Shifts

      • Each shift will be reported separately for each day
      • Shifts can be configured by searching for 'Shifts' in OfficeMate

      Cash Draw

      • Each cashdrawer will be reported individually 
      • Then a sum of ALL cashdrawers will be reported below

      Type

      • Expected tender types are system totals
      • Actual tender types are totals that have been manually entered into reconciliation 

      Expected Cash

      • The expected/system cash total

      Actual Cash

      • The sum of all cash that has been manually entered

      Expected Cash Out

      • The expected/system cash out total

      Actual Cash Out

      • The sum of all cash out that has been manually entered
      • Cash out is processed on the eftpos terminal, where the customer is given cash (usually as part of a sale) as part of the transaction
      • This total is usually found on the eftpos summary

      Expected Card

      • The expected/system card total

      Actual Card

      • The sum of all card tender types that have manually been entered

      Expected Web

      • The expected/system WEB total

      Actual Web

      • The sum of all WEB types that have manually been entered

      Petty Cash

      • The sum of all petty cash that has been manually entered
      • Petty cash is a way to record cash that was removed from the cashdrawer to make purchases during a shift

      Tips

      • The sum of all tips that have been manually entered

      Overring

      • The sum of all overrings that have been manually entered
      • Over rings are a way to correct or adjust the takings for accidental payments made. Processing a refunds is the preferable method to amend mistakes

      Variance

      • The difference between the system/expected total and the actual total entered into reconciliation
      • Can be positive (+) or negative (-) variance
      • This is your total variance
        • Per cashdrawer and;
        • For ALL cashdrawers 

       Note: This is a takings report, so GST, discounts/surcharges, etc. are not itemised 

       

      Daily Productivity Table

      Labour Hours

      • The total amount of hours of all timesheets
      • Includes users still currently clocked on

      Average Cost

      • The average cost for timesheets
      • Pay rates are required for users to populate this field
      • Pay rates can be assigned in the user set up screen in officemate
      • Includes users still currently clocked on

      Labour Cost

      • The total cost for all timesheets 
      • Sum of total hours multiplied by the hourly rate (per user)
      • Includes users still currently clocked on

      Labour %

      • The labour % percentage of the total sales
      • Total sales (Inc GST) divided by labour cost
      • Includes users still currently clocked on

      Service Count

      • The volume of accounts (ie. table, quicksale, phone order)

      Total Covers

      • The amount of covers (using the table terminal mode)

      Covers/Service

      • The total covers divided by the service count

      Sales/Labour

      • The total sales divided by the total labour hours
      • Includes users still currently clocked on

      Covers/Labour Hour

      • The total covers divided by the total labour hours
      • Includes users still currently clocked on