#Powerapps audit app manual#

#Powerapps audit app manual#

Leveraging many of Power Platform’s robust features – including Power Apps, Power Automate, Microsoft Dataverse, Power BI, as well as Azure SQL – the CCE team built a secure, compliant, and scalable solution that digitally transformed the SOX scope evaluation process to automate manual efforts and simplify time-intensive, repetitive tasks. Slowdowns in the SOX evaluation process also negatively impacted other downstream activities, and a lack of role-based access for Excel files presented data security and integrity risks as the files moved between users. This not only created delays in sending timely and targeted reminders, but required project managers (PMs) to constantly switch between Outlook and Excel to monitor alerts and make changes. SOX scope evaluations traditionally relied on time-consuming processes that required significant cost and manual effort – including data input, data collection, de-duplication, maintenance of Excel files, as well manual generation and tracking of status reports through Outlook. Improved agility and increased productivity.92% reduction in manually generated reminder emails.

53% reduction in effort despite a 36% increase in scope.50% cost savings with process automation, totaling ~$500K annual savings versus FY19.

Leveraging Microsoft Power Platform, the CCE team was able to move from a time-consuming, manual SOX scope evaluation process to a streamlined and automated workflow that reduced both time-to-value and costs. These evaluations – which drive the design, deployment, and execution of controls for reliable and accurate financial reporting – can take significant time, effort, and cost to complete.

Each quarter, the Microsoft Commerce Compliance Engineering (CCE) team performs hundreds of Sarbanes-Oxley (SOX) evaluations to ensure compliance on all Microsoft services that facilitate transactions with Microsoft partners and customers.