Aapplication
ARBUTUS ANALYZER
Data Analysis in Retail...
A Few of the Ways You can Put Arbutus Analytics to Work in Retail
- Inventory
Control - Loss
Prevention - Purchase Order
Management - Policy and
Administration - General
Ledger - Cash
Disbursement
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 and 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
Material de Referencia
Note 1: Some of the content (images and texts) used in this page are property of Arbutus Software