Sage 300 Audit Program

Sage 300 ERP Audit Program v1.0
Categories: Audit Program; IT & Cyber Audit; Financial & Operational Audit

An Excel audit workbook for reviewing Sage 300 (formerly Sage Accpac), built for internal auditors, IT auditors and finance teams. It contains 173 test procedures across 22 sections. Each procedure sets out the control objective, the risk, the Sage 300 screen, report or table to use, and the evidence to collect.

The workbook also includes:

• An Engagement Setup sheet that switches procedures in or out of scope by module
• Result and risk-rating drop-downs
• A live dashboard of results by section
• A findings register with recommendations, owners and due dates
• A segregation of duties matrix and an information request list

What’s covered

• IT Audit (75 procedures): Governance, User Access, Privileged Access, Roles & SoD, Passwords, Change Management, Configuration, Database Security, Backup & Recovery, Interfaces, Audit Logging, Hosting
• Business Process (83 procedures): GL & Period Close, Procure-to-Pay, Order-to-Cash, Inventory, Fixed Assets, Cash & Bank, Payroll Interface, Tax & Multi-Currency, Financial Reporting
• Data Analytics (15 tests): duplicate payments, vendor–employee matches, journal entry testing, Benford’s Law and more