Sarbanes-Oxley (SOX) - Pivot

This diagram is a pivot diagram showing the data from an audit.

SOX audit Pivot - Excel File - Down load

SOX audit Pivot - Excel file download

Diagram Flow

Create a excel file with following data headers

• Control Number – Unique ID for the data table

• Control Name – The unique name for each control

• Component – The What the control does

• Department – Department name

• Business Unit – The name of the department

• Risks

• Risk Level – The level of risk, 1 to 5

• Process Complexity – Complexity level, 1 to 5

• Maturity Level – Maturity, 1 to 5

How to create a Pivot chart
Step 1 : Create data in an Excel file or Database
Step 2 : Use the data to create a PivotDiagram via the Insert Pivot Diagram menu
Step 3: Expand the Pivot Node to show various levels of sub-nodes that correspond to the data you want to analyze

A Pivot Diagram is a collection of shapes arranged in a tree structure that helps you to analyze and summarize data in a visual, easy-to-understand format. It starts out as a single shape, called a top node (the “Total” shape in the diagram), that contains information imported from the Excel worksheet. You can break the top node into a level of sub nodes to view your data in various ways.

The PivotDiagram enables users to create data linked dynamic drawings faster & easier than ever before

Data Graphics are made up of elements that give the user a more complete view of their system

Data Graphic - Pivot

•  Title – Text element

•  Control Number – Text element

•  Risk Level – Data bar

•  Maturity Level – Data bar

•  Risk Level(Avg) – Icon set

•  Maturity Level(Avg) – Icon set

How do I find duplicate payment vouchers made for a invoice

My friend problem is :

My friend Team Leader has to supervise the indexing work for the invoices received and create payment vouchers in the ERP by his team members.  He can drill down the indexed vouchers for the day / week.  Every voucher has multiple line items indexed on the basis of a invoice.

My Solutions is;

Step 1 : Drill down the dump from your ERP

Step 2 : Use the Pivot table and sum the value of amount on the basis of invoice and voucher.

Step 3 : It will clearly show the duplicate vouchers if any indexed.  See the picture.

Also we can use the Report filter function in the Pivot table to filter the invoice in the dump and clear the duplicate payment.