Go to CAS --> Reports --> Transactions
Transactions tab contains reports that are based on transaction exceptions. It includes reports on Discount Transactions, Coupon Transactions, Refund Transactions, Cash Balances (including pickups and payouts), Attribute Analysis , Prepaid Activity, Transaction Activity, Fee Report, Tip Report & Cash Management Report.
Discount Transactions
Go to CAS --> Reports --> Transactions --> Discount Transactions
This report provides information about items that were discounted on an item level. Use it to monitor the percentage of items that are sold at a discount and the discount codes that were used. The Discount report also displays total discount amounts.
Check the Discounted Sales amount against Cost of Good Sold to make sure discounts are not costing you money. Review your discount ratios at similar type stores to see if an unusual discount activity is occurring, you can do this by running the report and consolidating by venue or store. The breakdown of the total discounts on the periodic sales is in this report.
Details
User provides criteria and generates a discount summary report. User specifies the report by the venue, store, group, or register, and then provides details such as department, size, consolidation by enterprise, venue, or store, and provides the dates between which the sales are to be reported. The user then can generate the report or download the CSV file. The user can generate a report that provides the venue, store, discount, the SKU, and the unit descriptions, units sold, retail price, retail sales, item cost, total discount on unit, units at the discount code, discounted retail sales, and the discounted cost of each item.
Venue/ Store- the location in which you would like to generate the report from
Discount- The Name of the discount
UPC- the UPC of the item sold with the discount
Description- Name of the item sold
Units Sold - the total number of units sold of the item during the reporting period (includes all items, not just discounted items)
Retail Price - retail price of the item
Retail Sales - number of sales of the item times prices, less returns
Disc Amt - dollar amount of discount applied
Item Cost - cost as per postransactionitemdetail table
Total Disc. Unit - number of units of this item sold with a discount (includes all discount codes)
Units at Disc Code - number of units of this item sold with the specific discount (less refunds)
Discounted Retail Sales - discounted sales amount of the item.
Discounted Cost - cost of the item with the discount.
This report utilizes a large amount of memory and can slow your system for other functions while running the report. It is recommended that this report be run in off business hours to minimize the impact.
Limitation : The report does not include manual refund import sales.
Access
Access to this function at an enterprise level is limited by default to the System Administrator and Financial users only. Accounting, store managers, warehouse general managers as well as zone managers may view discount transactions report at Venues or Store assigned to them.
Coupon Transactions
Go to CAS --> Reports --> Transactions --> Coupon Transactions
This report provides information on coupon transactions done at the item level, transaction level coupons are not reflected on this report. Use this report to monitor the percentage of items that are sold with coupons and the coupon codes that were used.
Review your coupon redemption rates at similar type stores to see if an unusual activity is occurring, you can do this by running the report and consolidating by venue or store.
Details
User provides details and generates a coupon sales report. User specifies the report by the venue, store, group, or register, and then provides details such as department, size, and the date range which the sales are to be reported.
The user then can generate the report or download the CSV file. The generated report provides the venue, store, coupon name, the UPC, description, total sold, retail price, retail sales, number sold at coupon code, and the discounted coupon retail sales.
Each coupon is listed, then all are totaled, so the user can see which coupons are being used by their customers.
Description of report headers:
Total Sold : Number of all sales of that item during the date range selected(coupons and without) less refunds.
Retail Price : Price of the item (before coupon discount taken)
Retail sales : Total sales * Retail price
Sold at Coupon Code : number of transactions with a item level coupon used. (Sales less refunds)
Coupon Amount : Total of all coupons at that coupon code (less refunds)
Discounted Coupon Retail Sales : Retail Sales minus Coupon Amount
Access
Access to this function at an enterprise level is limited by default to the System Administrator and Financial users only. Accounting, store managers, warehouse general managers as well as zone managers and human resource managers may view coupon transactions report at Venues or Store assigned to them.
Refund Transactions
Go to CAS --> Reports --> Transactions --> Refund Transactions
This report provides information about refund transactions by reason code. Use it to monitor the percentage of refunds.
Review your activity at similar type stores to see if an unusual refund activity is occurring, you can do this by running the report and consolidating by venue or store. You may want to review your refund policy if this number is excessive. Some customers elect to not offer cash refunds and only provide them on gift cards.
You may also elect to require that all transactions be verified against original sales receipts if you are concerned about the validity of refunds.
Details
User provides details and generates a refund sales report. User specifies the report by the venue, store, group, or register, and then provides details such as department, size, and the date range which the sales are to be reported.
The user then can generate the report or download the CSV file. The generated report provides the venue, store, refund reason, total transaction price, total sales, the number of refund transactions, the total refund amount, the percent refunds of all transactions, and percent refunds of sales amount.
Total Transactions- Total number of sales transactions with and without refunds associated with them
Total Sales- Dollar amount of all sales (net amount including tax) Sales (+ tax) - refunds (- tax)
Refund Transactions- Number of Refund Transactions
Refund Amount- The Amount of Refund Transactions (this includes sales tax)
% Transaction- The percent of Refund Transactions (Refund transactions/Total transactions)
% Amount- The percent of the Refund Amounts (Refund $/Total $)
Access
Access to this function at an enterprise level is limited by default to the System Administrator and Financial users only. Accounting, store managers, warehouse general managers as well as zone managers and human resource managers may view refund transactions report at Venues or Store assigned to them.
Cash Balances
Go to CAS --> Reports --> Transactions --> Cash Balances
This report provides details of cash balances by store and register. All cash activity is displayed including any deposit box activity. Deposits boxes are created when the closing amount exceeds the maximum bank amount on the Cashier Bank Settings User Interface .
Concerned about how much cash is sitting in a cash drawer? Activate email alerts every time cash balances exceed a preset amount.
Details
.webp?alt=media&token=a4038dde-eda7-46c1-b5a2-9eea7b8511a9)
User provides details and generates a cash balances report. User specifies the report by the venue or store and then provides the date range which the balances are to be reported.
The user then can generate the report or download the CSV file. The generated report provides the venue, store, register, date, the opening balance, the cash pickup amount, the cash payout amount, the cash sales, the closing balance, and the closing balance for each register.
Access
Access to this function at an enterprise level is limited by default to the System Administrator and Financial users only. Accounting, store managers, warehouse general managers as well as zone managers may view cash balances report at Venues or Store assigned to them.
Attribute Analysis
Go to CAS --> Reports --> Transactions --> Attribute Analysis
This reports the sales by department, category, sub category, vendor, style, color, and size. The user is able to see the consolidated sales for each attribute, select a date range for the data, and select how wide of a search criteria to analyze (venue level, store, group, or register).
This report can be utilized to review your inventory in terms of sales and stock on hand. Run the report at a high level consolidated by departments and see what the GMROI, the stock on days and the markdown % are at a department level. These are indicators of what your investment is returning at a department level, how well stocked you are on complimentary product and what is the impact of markdowns on your expected pricing models
Details
The user should Filter and Consolidate Report to target the classifications and attributes and dates that yields the data needed.
The user then can generate the report or download the CSV file. Once a report is generated, the user can see the Attribute, Item name, # Sold, #Trans, Sales, COGS, Margin %, Avg Retail, Markdown %, GMROI, Gross Margin, Stock Days, Inventory Turnover.
The Stock Days Data provides the User a financial tool, as well as the Inventory Turnover Data
Use with Other Reports to optimize usability : The Reorder Report indicated items that may need to be reordered. This report is helpful to use in conjunction with the attribute analysis report, to see if certain attributes within a category are poor performers (are hats hot sellers but blue hats have higher stock days. This can help you adjust the purchases from the vendor or adjust the placement within the store).
Attribute Analysis Report Use Cases
Access
Access to this function at an enterprise level is limited by default to the System Administrator and Financial users only. Accounting, store managers, warehouse general managers as well as zone managers may view Inventory Balance report at Venues or Store assigned to them.
Filter and Consolidate Report
CAS --> Reports --> Transactions --> Attribute Analysis
Depending on how broadly the data needed is, the criteria can be filtered to specific departments or attributes, by vendor, or for a set date range. The results can then be consolidated by classification or attribute to target areas of specific interest.
This allows a retailer to run a high level report and drill down further for more analysis by setting more filters, ultimately providing detailer item level info. This is a good drill down level report. Run the report at all levels, and then see how you can drill it down one filter at a time.
From this, you can see issues that may need to be addressed (or if you are interested in your strong performers you can analyze those) at multiple levels. Is it the entire attribute that doesn't work well for your store or as you hone in, is it a more specific subset that needs to be eliminated. By checking the item detail box, you can see if specific items are your stand out items.
Stock Days Info
CAS --> Reports --> Transactions --> Attribute Analysis
This calculation has various uses in financial management. If in reviewing the report, the user determines that the store is overstocked on the item (stock days are too high), discounts or promotional marketing should be considered. Should future reorder levels be reduced or discontinued? In conjunction with other indicators, does retail pricing reflect what a customer is willing to pay for the item?
The item is nearing the end of it's season and shelves are overstocked:
Determine the timing of discounting to clear out the shelves for the next seasons merchandise and reflect on future inventory levels for reordering to better manage inventory levels.
Was the item an efficient use of capital. Next time should fewer items be ordered. Considering the turnover rate, should the next reordering be adjusted.
Consider inventory placement, are some items hard to locate within the store and reflect higher stock days. Compare this to other items within the attribute (or department) to help determine if change is needed.
As you can see, none of the indicators alone answer all of the questions make the important management decisions, but together a picture is painted to clarify the weaknesses or strengths that should be addressed.
Inventory Turnover Data
CAS --> Reports --> Transactions --> Attribute Analysis
A low turnover rate may indicate overstocking, obsolescence, or deficiencies in the product line or marketing effort. However, sometimes a low rate may be appropriate, such as where higher inventory levels occur in anticipation of rapidly rising prices or expected market shortages.
Conversely a high turnover rate may indicate inadequate inventory levels, which may lead to a loss in business as the inventory is too low. This often can result in stock shortages.
An item whose inventory is sold (turns over) once a year has a higher holding cost than one that turns over twice, or three times, or more in that time. Inventory turnover also indicates the briskness of the business. The purpose of increasing inventory turnover is to reduce inventory for three reasons.
Items that turnover more quickly increase responsiveness to changes in customer requirements while allowing the replacement of obsolete items.
Increasing inventory turnover reduces holding cost. The store spends less money on rent, utilities, insurance, theft and other costs of maintaining a stock of items to be sold.
Reducing holding cost increases net income and profitability as long as the revenue from selling the item remains constant.
Attribute Analysis Use Cases
CAS --> Reports --> Transactions --> Attribute Analysis
This report can be utilized as a component of your overall category management. Category performance analysis provides insight into merchandise performance by department, category, subcategory and vendor. Product and store managers analyze sales performance to understand which products and categories are selling well and which are selling poorly, as well as to identify the attributes of high and low performers.
Ideally you should run the report at a high level consolidated by departments and review the GMROI, the stock on days and the markdown % are at a department level. These are indicators of what your investment is returning at a department level, how well stocked you are on complimentary product (presuming that your inventory hierarchy has been well planned) and what is the impact of markdowns on your expected pricing models. Just this basic level of knowledge allows managers to optimize their product mix, ensure inventory levels are appropriate, and offer specific product selections demanded locally by consumers.
Use this report in conjunction with your overstocked report to provide you with insight on the impact of certain items within a sub par classification (should you consider discounting or some other merchandising promotion), as low stock turns can impact margin opportunities in other areas. Markdown percent should be evaluated to determine if they are in line with pricing policies, this can be done simply by reviewing departments at category levels and then reviewing by consolidating non performing classifications at subcategory or attribute levels.
Financial managers can review vendor performance to utilize prepay discounts for top performers or negotiate extended terms or discounts for habitual non performers. The AAR can also be used in space planning (high margin items should be placed in high traffic areas, high demand items in low traffic areas, complementary items near each other, item needing frequent restocking placed near storerooms or cash registers, etc.)
Discounting can impact pricing plan if not considered carefully. For example say an item costs $10 and you want to achieve a gross margin equal to 100% of your costs so you price the product at $20. Subsequently the product for various reasons has to be discounted by 20% and now sells for $16, your gross margin is now reduced to 60% of your costs. If your business model plans on a margin of 100% of COGS, depending on the number of times you do this could be fairly impactful. If a review of the AAR shows that this classification historically is being marked down at 20%, it would be beneficial to consider that when establishing your original list price, assuming that the price elasticity is perfectly inelastic.
Transaction Activity
Go to CAS --> Reports --> Transactions --> Transaction Activity
Transaction Activity report helps the user to track all the POS transactions and view the receipts from the POS in CAS. Use this report to see detailed activity by transaction and also to reprint transactions from CAS.
Detail
To filter Report by Venue, Store, Register user selects the appropriate drop down.
To pull transactions by date range, enter transaction number and transaction amount range.
To pull transactions by ItemID or UPC, enter UPC or ItemID.
The report can also be generated by specific payment mode (All is for all payment modes, or select specific tendered mode Cash, check, coupon, credit, debit, gift, or split transaction). Note If the only tender was a coupon it would be in the coupon tender. As most/all coupons also involve another tender (cash,credit card,etc) those would pull under the split tender option.
The user then can generate the list of transactions and from there select a particular transaction and view it or print it. Transactions from terminated registers is also available, when criteria is set for those registers.
Access
Access to this function at an enterprise level is limited by default to the System Administrator and Financial users only. Accounting, store managers, warehouse general managers as well as zone managers may view Inventory Balance report at Venues or Store assigned to them.
Prepaid Activity
Go to CAS --> Reports --> Transactions --> Prepaid Activity
This is a report that is used to view layaway transactions that were performed on the POS. This report can be run by Venue, Store, Group, Zone or Customer
User can specify all or specific program name and all or specific status and it can be run at a transaction level or at an item detail level.
.webp?alt=media&token=e0a5a9dc-f3d2-44a4-9505-37ca7e2f8695)
Customer Name : Name of the Customer
Customer Number : Number of the Customer
Email Address : Email Address of the Customer
Prepaid Transaction number : Transaction number for the assigned to the original transaction.
STS Gift Card Number : The number of the gift card that the transactions for that customer are being saved to.
Program name : The name assigned to the program
Initial transaction date : The date when the transaction was created
Retail Amount : The amount of the Sale (not remaining balance)
COGS : Cost of goods sold
Last Payment Date : The last time a payment was made. (STS Enabled transactions only)
Number of Payments : The amount of payments that have been made. (STS Enabled transactions only)
Fee Report
Go to CAS --> Reports --> Transactions --> Fee Report
This report provides information about transactions that had fee added to them. It shows the register, date, fee reason, total transactions, total refund transactions, total discount transactions.
Details
User provides criteria and generates a Fee report. User specifies the report by date range. The user then can generate the report, download the CSV file, save to Dropbox or save it directly to the Google Drive.
Register - Register Fee was recorded on
Date - Date transaction was made
Fee Reason - Reason for the fees
Total Transactions - Total Transactions associated with fee
Total Refund Transactions - Total Refund Transactions associated with fee
Total Discount Transactions - Total Discount Transactions associated with fee
Tip Report
This report provides information about transactions that had Tip added to them. It shows the transaction number, transaction amount, tip amount and total per Transactions.
Details
.webp?alt=media&token=08fa9b08-c50b-455f-8eb6-caa4b70667df)
User provides criteria and generates a Tip report. User specifies the report by date range. The user then can generate the report, download the CSV file, save to Dropbox or save it directly to the Google Drive.
Date - Date transaction was made
Register - Register Tip was recorded on
Transaction Number - Transaction number associated with Tip
Server - If sales persons used Sales Person name will populate here
Trans Amount($) - The original amount before Tip added
Tip Amount($) - The Tip amount for Each server
Total($) - Total after Tip added to transaction amount
Grand Total - Sum up for each column Trans Amount, Tip Amount, and Totals.
By Server - Sum up of all Tips awarded by each server.
Cash Management Report
Go to CAS --> Reports --> Transactions --> Cash Management Report
Let’s look at this page in sections.
The top portion give the user the ability to set the filters by which they wish to see results displayed. The user can choose a date range, transaction type, specific venue, store or register. The user can also filter by transaction type. Once the desired filters have been selected, the user may select the search button to generate their results.
Once navigating to this page, the following page will display.
Once the search option is selected, the desired results will be displayed below the filters. The user has the option to export/print these results in addition to viewing them. The user can select the desired export from the buttons displayed.
The options are CSV, PDF and PRINT.
Articles in this section
- Central Administration System
- Configuration
- Company Details
- Company Information
- Payroll Settings
- Merchant Email Configuration
- Invoice Setup
- QSR
- Payment Settings
Comments
Please sign in to leave a comment.