Sales to Takings Report

Summary

In OrderMate, the term ‘Sales’ represents the menu items that have been ordered and ‘Takings’ represents the payments that have been received. 

These two figures are not always identical for the same shift as they can be affected by a range of things that happen to accounts. Some of these things a perfectly normal, but sometimes there are some events that happen that do not follow best practice. 

The ‘Sales to Takings’ report is a troubleshooting report that is used to highlight or identify what has cause the two figures to be different. 

Note: To find the report search 'Sales to Takings' in OfficeMate

 

Available Filters in the Report

  • Day

The Information in the Report

Filters

  • This is a single date report
  • Each shift will be shown separately and then a daily totals will be shown on the last page
  • To create new shifts search 'Shifts' in OfficeMate
  • At the beginning of each line, there is a (+) or (-) symbol to indicate the direction each line will effect the previous 'Running Total' figure

Sales

  • The total sale value of all items ordered in this shift AND;
  • Minus (-) any refunds made in this shift (except to stale accounts)
  • Minus (-) any deleted items in this shift (except to stale accounts)
  • Sales figures are including discount or surcharges
  • Sales figures are Inc GST

(+) Sales Inc Discounts and Refunds

  • This field is a repeated field from above to begin the running total

(+) Sales Allocated Previous

  • The total value of items ordered in this shift, to accounts that were opened in a previous shift (a stale account)

For further investigation:

  • Search for "Trading Day Discrepancy" events in the Transaction Journal

(-) Refunds from previous Day

  • The total value of items refunded in this shift, for accounts that were opened in a previous shift (from closed accounts)

For further investigation:

  • View the refund report in OfficeMate
  • Search for "Refund" events in the Transaction Journal.

(+) Payments to Stale Accounts

  • The total value of payments in this shift, for accounts that were opened in a previous shift (a stale account)

For further investigation:

  • Search for "Trading Day Discrepancy" events in the Transaction Journal

(-) Nett Debtor Sales

  • The total sale value of items added to debtors in this shift AND;
  • Minus (-) any refunds made to debtors (a reverse sale)

For further investigation:

  • View the "Debtor Transactions" report in OfficeMate

(+) Net Debtor Payments

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

For further investigation:

  • View the "Debtor Transactions" report in OfficeMate

(-) Net Debtor Adjustments

  • The total value of discounts and surcharges made to debtors in this shift
  • Discounts calculated as a (+) positive value to indicate that the price was lower than the usual price (a + cost to the business)
  • Surcharges calculated as a (-) negative value to indicate that the price was higher than the usual price (a - cost to the business)

(+) Voucher Topups

  • The total value of payments made to vouchers in this shift

(-) Voucher Topups Reversals 

  • The total value of payments removed from vouchers in this shift

(-) Voucher Redeems 

  • The total value of vouchers redeemed in this shift

(+) Voucher Redeem Reversals

  • The total value of vouchers redeemed and then cancelled in this shift

(-) Applied Previous Transaction

  • The total value of payments that were moved from a debtor to an account using 'Applied Previous Transactions' in this shift

(-) Sales from Future

  • The total sale value of items added on a future date to accounts that were opened in this shift (a stale account) AND;
  • Minus (-) any items that were removed on a future date to accounts that were opened in this shift (a reverse sale)

For further investigation:

  • Search for "Trading Day Discrepancy" events in the Transaction Journal

(-) Payments from the Past

  • Payments made on a previous shift to an account that was opened during this shift
  • This is only caused when two or more terminals are in different trading days (contact technical support)

(+) Payments to the Future

  • Payments made during this shift to an account that was opened in a future shift
  • This is only caused when two or more terminals are in different trading days (contact technical support)

(-) This Day's Open Accounts

  • The total sale value of all items ordered in this shift, that have not yet been paid off

For further investigation:

  • Search for "Open Orders" report in OfficeMate

(-) Tables that were open at the end of the day that have since been paid 

  • The total value of items ordered in this shift, that had a payment applied to them on a future date (a stale account)

For further investigation:

  • Search for "Trading Day Discrepancy" events in the Transaction Journal

(-) Sales Rounding Adjustment

  • The difference of rounding calculations
    • ie. the rounding of individual items v's rounding of total sales for the shift (could be slightly different)
  • This would be (+) or (-) 1 cent per occurrence and so is usually only a small amount per shift

(-) Unbalanced Accounts

  • This means that there was one or more closed accounts that have a balance that is not $0
  • This is uncommon and is usually operator error eg;
    • A user went into the refund screen, cancelled a payment and then then restarted WaiterMate instead of processing the payment
    • An integrated @table eftpos transaction was manually paid off in WaiterMate as well as on the eftpos terminal

(-) Unaccounted Balance

  • Events in the system that have effected the difference between sales and takings, that do not belong in any of the above fields
  • Figures in this field are uncommon (contact technical support)

Takings

  • The total value of all payments made in this shift

 

Note: A 'Stale Account' is an account that was created in one shift or trading day, that was not closed in the same shift or trading day. Best practice would be to make sure that at the end of every day, all accounts are either paid off, or added to a debtor.