Experimental Report - May 2020

This workbook tab shows sales, transactions, and commission impact for month-do-date and year-to-date Acehardware.com pickup and ship-to transactions. Because these online sales transactions are outside of your regular daily sales metrics, this report attempts to quantify pickup sales as if they were rung through your cash register. This way, you can quickly see the impact of online sales and transactions for your business.

This report is not meant for financial purposes, instead, use your Eagle VIEWAHCM viewer and Ace's best practices for reconciling your Ace statement.

• MTD = Month-to-date (activity last month).

  YTD = Year-to-date (rolled up activity since January 1st).

  ISPU = In-Store Pickup.

  
  A - Store: Eagle Store ID.

  B/K: Transactions: The number of in-store pickup (ISPU) transactions for the period.

  C/L - Units: The net sales units for ISPU for the period.

  D/M - Eagle Equivalent Sales: New ISPU sales dollars for the period on an "equivalent" sales basis. Meaning, this is what the customer paid for the product, as if it was rung through your cash register. This will differ from the amount due from Ace due to processing fees.

  E/N - Cost of Sales: The net cost of inventory (at average cost) sold via ISPU.

  F/O - Margin: An "equivalent" sales margin based on columns D & E.

  G/P - % of Total Sales: The percentage of ISPU sales relative to total sales volume for the period. Example: 4.2% means 4.2% of total sales for the period was made up of ISPU sales dollars.

  H/Q - Ship to Transactions: The number of Ship to Store or Ship to Customer transactions for the period.

  I/R - Ship To Units: The net number of sales units for Ship to Store or Ship to Customer for the period.

  J/S - Ship to Commission: Net commissions made on Ship to Store or Ship to Customer transactions.