Arbutus Analytics I Applications in Retail

Inventory Control
- Reconciliation of unmatched pay and remittances to freight invoices
- Analysis of department or item file margins below standard
- Price compliance
- Select items from perpetual stock for test reconciliation
- Use sampling command for physical reconciliation testing
- Reconcile selected physical counts to computed amounts
- Compare the value of physical counts to general ledger value
- Report on items with high value balances and age
- Summarize and stratify turnover by stock item in any order
- Test for duplicate item numbers, prices or descriptions
- Identify surplus obsolete inventory
- Identify items with yearly volume under/above quantity ordered
- Isolate and analyze high value transactions by value, group, buyer
- Calculate current inventory items based on LIFO value or pool
- Analyze the difference between standard costs and actual costs
Loss Prevention
- Identify checks paid to more than one payee with a similar or same address
- Comparison of credit card payments
- Test credit card balances versus credit limits
- Comparison of year-to-date allowances to net sales
- Dollar ranked invoice tracking by unit
- Identify stores with significant allowances
- High risk transaction tracking by associate
- Identification of duplicate return transactions
- Identification of incomplete exchange transactions
- Inventory protection — comparison of clearance sales of returned merchandise by markdowns, markups and sales without receipts.
- Summarize price adjustments on returned merchandise by division
- Annual Inventory — Inventory Day sales by store
- Voided transactions followed by “No Sale”
- Check purchase and refund within 15 days
- Credit card purchase and refund to different credit card (same day)
  Cash purchase, cash refund (same day)
- Identification of potential fraudulent or improper transactions
  through selling price differences between stores
Purchase Order Management
- Reconciliation of orders received, but not ordered
- Extract pricing and receipt quantity variations by vendor and purchase order
- Track schedule receipt dates versus actual receipt dates, summary, and detail
- Isolate purchase order types (blanket, release, drop-ship) for audit tracking
- Identify duplicate purchase orders or receipts without purchase orders
Policy & Administration
- Test for fuzzy match on employee name and/or address to identify conflicts of interest where managers have relatives working for them
- Download employee data to analyze pay adjustments, overtime, etc.
- Travel expense ranking by category and associate
- Installed services — permit installation compliance and review; verify sales tax not collected or charged on installed sales
General Ledger
- Calculate financial ratios (and changes) for sales/assets, debt/equity, etc.
- Select any journal entry for test and audit purposes from any period
- Track the year-to-date activity for large operating accounts (rent, taxes)
- Prepare trial balances by tax groups and calculate various tax provisions
Cash Disbursement
- Monitor cash disbursements for stores
- Track corporate cash disbursements for contractor and vendor services
- Summarize cash disbursements by account, bank, group, vendor, etc.
- Identify check requests, by bank, that exceed set or selected dollar amounts

Customer Success Story

Building Value in Operations

Increasing Efficiencies, Lowering Costs, Expanding Risk Coverage

One of the largest foodservice distributors in the USA with $20B+ in annual revenue. The Company provides approximately 400,000 fresh, frozen, and dry food stock-keeping units (SKUs), as well as nonfood items, sourced from 4,000+ suppliers. It maintains 65+ primary operating facilities, consisting of its 50+ distribution centers and other supporting facilities. It also owns a fleet of 5,000+ trucks that supply over 200,000 customer locations across the nation.

Success Story - Read now

Products

What's New

Global Partners

By Industry

By Business Processes

By Popularity

Resources

Webinars

Arbutus Services

Data Analytics in Retail

A Few of the Ways You can Put Arbutus Analytics to Work in Retail

Inventory Control

Loss Prevention

Purchase Order Management

Policy & Administration

General Ledger

Cash Disbursement

Inventory Control

Loss Prevention

Purchase Order Management

Policy and Administration

General Ledger

Cash Disbursement

Full List of Applications in Retail

Retail Applications

Download Application Sheet

Building Value in Operations

Increasing Efficiencies, Lowering Costs, Expanding Risk Coverage

Analytics by Industry

Analytics By Business Process

Analytics By Business Process

Help & Documentation

Resources

Training & Consulting