1 / 10

Agenda

Agenda. Case Study Electronic Point of Sale Transactional Analysis. Electronic Point of Sale (EPoS) systems are increasingly common in all areas of business, most notably the retail sector Systems in use range from basic Electronic Cash Register to sophisticated high end packages

josephine-phelps
Download Presentation

Agenda

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Agenda Case Study Electronic Point of Sale Transactional Analysis Prepared by: Graham Bell

  2. Electronic Point of Sale (EPoS) systems are increasingly common in all areas of business, most notably the retail sector • Systems in use range from basic Electronic Cash Register to sophisticated high end packages • One common feature, they use electronic data and some form of computing power Prepared by: Graham Bell

  3. Electronic Point of SaleA Risky Business • Electronic Point of Sales data forms part of the business records used to create VAT and Direct taxes returns • There are a range of risks attached to the use of electronic data systems as data may be manipulated by the user • HMRC requires assurance that traders’ systems and processes are operating correctly • Systems normally create hard copy reports e.g. Sales Receipts requiring manual audit. Electronic data provides scope for a more comprehensive alternative E Audit Prepared by: Graham Bell

  4. Sample of systems in use Prepared by: Graham Bell

  5. Reports Typically reports might include: • Sales Transactions Z1 – Daily Sales Transactions • Ordering – Orders and Customer Accounts • Delivery – Delivery Control Input/Recall Orders • Electronic Funds Transfer – Card Payments • Stock Monitoring– Measures Stock Usage • Accounting Interface – Discounts, Tax, Media Prepared by: Graham Bell

  6. Data Acquisition and Analysis • Generically most EPoS systems will use front end software sitting on a Data Base Management system such as SQL or Microsoft Access • Reports can normally be generated but may be cumbersome and can lead to system down time • An alternative is to acquire the underlying raw data • IDEA supports Open Data Base Connectivity (ODBC) and data can normally be imported from suitable sources by this method Prepared by: Graham Bell

  7. Data Acquisition and Analysis:The Case Study • HMRC have an expanding field of expertise in the area of data analysis from EPoS sources • The case study you are about to see is an example of our work Prepared by: Graham Bell

  8. Tools and Techniques • IDEA (Interactive Data Extraction & Analysis) Tool • Tool of choice to import and analyse data • Most type of reports can readily imported using the Import Assistant capabilities Prepared by: Graham Bell

  9. Any Questions ? Prepared by: Graham Bell

  10. Thank You Graham Bell | Data Handling Specialist | Scottish Data Handling Specialist Team | HM Revenue & Customs | Local Compliance Scotland |Tel 03000 551174 Prepared by: Graham Bell

More Related