Sales to Takings 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

(+) Nett 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

(-) Nett 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 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