Audit Analyses
Using different account categories such as accounts payable, accounts receivable, and liquid assets, we explore useful audit analyses. We explain why these analyses are important and guide you through them step by step, making it easy for you to apply them yourself.
Supplier analysis for auditors
ACCOUNTS-PAYABLE
Use python to analayze product price trends, compare regions and flag anomalies in your acounts payable data.
Read More →
Supplier analysis for auditors
Use python to analayze product price trends, compare regions and flag anomalies in your acounts payable data.
Reconcile purchase invoices
In this article, we reconcile purchase invoices with the general ledger (auditfile). Are we complete, and do the amounts match correctly?
Purchase price analysis - trends, supplier comparison and price outliers
In this article, we develop a python script to analyse product prices and compare suppliers.
K-means clustering in auditing: clustering & outliers
Learn how K-means structure data. Group transactions, spot and understand when this machine-learning technique is appropriate in audit.
Inventory Aging Analysis (FIFO)
In this article, we analyze the age of inventory to identify obsolete goods. Using Python, we create an overview of slow-moving stock.
Inventory turnover analysis
Calculate product turnover using sales and turnover and average stock. Identify slow moving items and improve inventory management (incl. script)
Money–Goods movement (reconcile stock movements with general ledger)
In this article we verify whether inventory movements reconcile with the financial records using the formula: Opening Inventory + Purchases – Closing Inventory = Sales.
CAMT.053 | Explanation & Converter
In this article, we delve into CAMT files and share a Python script to convert them into Excel or CSV.
Duplicate IBAN-analysis with CAMT data
In this article, we use Python to find payees with multiple IBANS and IBANS linked to multiple payees in CAMT.053 data.
Payments to high-risk countries (analysis CAMT & FATF)
In this article, we use Python and a CAMT-053 file to analyze where bank transactions originate from or are sent to.
Split-payment analysis (detect split below approval)
In this article, we use Python and a CAMT-053 file to identify suspicious split payments. Discover patterns where transactions may be circumventing approval thresholds (incl. script).