ISA 520

Analytical Review
Tool

Import your trial balance, set materiality thresholds, and automatically flag significant fluctuations. Export ISA 520-compliant working papers in one click.

Based on ISA 520
Used by auditors in 40+ countries
20+ free audit tools
IAASB 2024 Handbook aligned
ISA 520 · LIVEv2026.04no data

Analytical procedures, documented.
Not just ticked off.

Session
0xE3DE
Fiscal Year
FY 2026
Accounts
inputs.conf
thresholds.conf
README.md
01// engagement— ISA 520.4
02entity_name=
03fiscal_year_end=
04currency=
05industry_sector=
08// materiality— ISA 320
09overall_materiality=€ · OM
10performance_mat_pct=
11investigation_threshold=
% change · dual-threshold (ISA 520.5(d))
14// trial_balance— ISA 520.5(b)
15accounts_loaded=
16// load_example=
awaiting input·3 sections · 1/5 fields·enter materiality + load accounts·manufacturing
previewwp-isa520-2026.pdf
🔒 LOCKED
ISA 520 analytical review preview
Enter overall materiality and click "Load example" to see your ISA 520 working paper render in real time.
Flagged items
Awaiting input
PRIMARY
Performance materiality
65% of overall materiality
Abs. threshold
Investigation threshold = PM
Accounts reviewed
Load accounts
ONE EMAIL · UNLOCKS EVERYTHING · FREE FOREVER

Enter your email to unlock the full analytical review.

One email. One time. Unlocks the live working paper preview, flagged items detail with ISA 520.7 status, key ratio analysis (gross margin, current ratio), threshold sensitivity analysis, compliance readiness checklist, and the working paper download — everything at once, forever, on this device.

No payment. No upsell. No "premium tier" pop-ups. Ever.

One audit insight a week. Unsubscribe any time. GDPR-compliant (MailerLite, EU servers).
Your email unlocks every section below automatically.
ADVANCED ANALYSIS

Full ISA 520 workflow, styled the same.

01// flagged_items— ISA 520.7 · investigation required
Enter materiality and load accounts to see flagged items.
02// ratio_analysis— ISA 520.A7 · trend indicators
Load accounts with revenue, COGS and current assets/liabilities to see ratios.
03// threshold_sensitivity— PM ±25% impact on flagged count
Enter materiality and load accounts to see sensitivity.
04// compliance_readiness— ISA 520 requirements checklist
Enter inputs to run the ISA 520 compliance check.
🔒
4 advanced sections · flagged items · ratio analysis · sensitivity
Enter your email above to unlock all of this. It's free — no payment, ever.
Scroll up to unlock ↑
EXPORT (EMAIL TO UNLOCK)

Email unlocks the free download.

No payment required. Enter your email above to unlock the full working paper download.

Format
HTML → PDF
Standard
ISA 520
Price
FREE
or CtrlE

Frequently asked questions

What is an ISA 520 analytical review?
ISA 520 (Analytical Procedures) requires auditors to design and perform analytical procedures near the end of the audit that assist in forming an overall conclusion as to whether the financial statements are consistent with the auditor's understanding of the entity. Analytical procedures involve evaluating financial information through analysis of plausible relationships among both financial and non-financial data. They include the investigation of identified fluctuations or relationships that are inconsistent with other relevant information or that differ from expected values by a significant amount.
How does the dual threshold flagging system work?
The dual threshold system prevents false flags by requiring BOTH conditions to be met before flagging an item for investigation: the percentage change must exceed the threshold percentage (e.g., 10%) AND the absolute change must exceed the materiality amount (e.g., performance materiality). This prevents two types of false positives: large percentage changes on immaterial balances (e.g., a 200% increase on a €500 balance) and small percentage changes on large balances that are still within materiality (e.g., a 3% change on €10M revenue when materiality is €500K). Sign changes (where a balance moves from positive to negative or vice versa) are always flagged regardless of thresholds because they indicate a fundamental change in the nature of the account.
What investigation thresholds should I set for analytical review?
Threshold setting depends on account type and assessed risk. Common practice ranges are: revenue and COGS at 5-10% (tighter because small percentage changes represent large absolute amounts), operating expenses at 10-15%, material balance sheet items at 5-10%, immaterial balance sheet items at 15-25%, and discretionary costs at 15-25%. The absolute threshold is typically set at performance materiality (50-75% of overall materiality). Higher-risk engagements warrant tighter thresholds. The tool allows both global defaults and per-category overrides to match your professional judgment.
Can I import trial balance data from Excel or CSV?
Yes. This is a key feature of the tool and a major time-saver versus manual entry. You can import trial balance data from .csv, .xlsx, or .xls files using the Import mode. After uploading, a column mapping interface lets you match your file's columns to the tool's fields (account name, category, current year, prior year, etc.). The tool handles common data quality issues including extra whitespace, European-format numbers (comma as decimal separator), missing values, and non-numeric characters in number columns. A 5-row preview lets you verify the mapping before importing.
What does the PDF working paper export include?
The PDF export generates a professional ISA 520-compliant working paper suitable for inclusion in your audit file. It includes: a header with client name, reporting period, preparer, and reviewer; the objective statement referencing ISA 520; the materiality and threshold parameters used; the complete comparison table with conditional formatting; a dedicated section listing all flagged items with the auditor's explanations and investigation status; the overall conclusion; and sign-off fields for both preparer and reviewer with dates. This structured format satisfies quality review requirements and demonstrates compliance with ISA 520.5-520.7.
How does the tool handle edge cases like PY = 0 or sign changes?
The tool handles all critical edge cases: when PY is zero, the percentage change shows 'N/A' and the item is labelled 'New in CY' and it's flagged based on absolute change only. When CY is zero with a non-zero PY, the percentage shows -100% and the item is labelled 'Discontinued'. Sign changes (positive to negative or vice versa) are ALWAYS flagged regardless of threshold settings because they represent an inherently significant change in the nature of the balance. Negative balances in denominators use absolute values for percentage calculations to avoid misleading results.
What is the difference between trend analysis and reasonableness testing?
Trend analysis (the primary methodology in this tool) compares CY to PY balances and identifies significant fluctuations. It answers 'has this balance changed significantly?' Reasonableness testing goes further by developing an independent expectation of what the balance should be based on operational data (e.g., expected revenue = units sold × average price, or expected payroll = headcount × average salary). It answers 'is this balance reasonable given what we know about the business?' Both are valid analytical procedures under ISA 520, but reasonableness testing provides stronger audit evidence because the expectation is independently derived.
Is the tool suitable for both planning and completion stage analytics?
Yes. ISA 315 requires analytical procedures during risk assessment (planning stage) to develop an understanding of the entity and identify areas of potential misstatement. ISA 520.6 requires analytical procedures near the end of the audit to form an overall conclusion. This tool supports both: at planning, use it with preliminary trial balance data to identify significant fluctuations that should inform the audit strategy. At completion, use it with final trial balance data to confirm that the financial statements are consistent with the auditor's understanding after all audit procedures have been performed.
How does the tool calculate ratios automatically?
The tool automatically calculates key financial ratios from your entered trial balance data when sufficient line items exist. It identifies revenue, COGS, operating expenses, current assets, and current liabilities from the category classifications you assign, and calculates gross margin, operating margin, and current ratio for both CY and PY. Changes in these ratios are highlighted. For more detailed ratio analysis including inventory turnover, DSO, DPO, and Z-Score, use our dedicated Financial Ratio Calculator tool.
Why is analytical review the most frequently performed audit procedure?
Analytical procedures are mandatory at both the planning (ISA 315) and completion (ISA 520.6) stages of every audit engagement, unlike sampling or going concern assessments which vary by engagement. A firm with 100 audit clients performs analytical review 200-400+ times per year. The typical workflow involves manual Excel spreadsheets with ad-hoc formulas, no standardised flagging logic, and no visual representation, taking 30-60 minutes per client. This tool standardises the process, applies consistent dual-threshold logic, and produces ready-to-file working papers.
What other audit tools do you offer?
Ciferi offers 20+ free audit and accounting tools, all browser-based with no login required. These include the Materiality Calculator (ISA 320), ISA 530 Sampling Calculator, ISA 570 Going Concern Checklist, Financial Ratio Calculator, Depreciation Calculator (IAS 16), IFRS 16 Lease Calculator, IFRS 9 ECL Calculator, IAS 37 Provision Calculator, IAS 12 Deferred Tax Calculator, IAS 36 Impairment Calculator, Transfer Pricing Tool, and Intercompany Elimination Tool (IFRS 10). Visit our free tools hub at ciferi.com/free to see the full collection.

Jurisdiction-specific analytical procedures guidance

While ISA 520 provides the global framework for analytical procedures, national regulators impose additional expectations during inspections. Below is how the top jurisdictions interpret and enforce analytical procedures requirements.

Netherlands — AFM and NV COS 520

The Netherlands adopts ISA 520 as NV COS 520, issued by the NBA (Koninklijke Nederlandse Beroepsorganisatie van Accountants). The standard text is applied in Dutch and is substantively identical to the IAASB base text. NV COS 520 requires auditors to perform analytical procedures at both the planning stage (NV COS 315) and the completion stage, and to design substantive analytical procedures where appropriate for specific assertions.

The AFM (Autoriteit Financiële Markten) has repeatedly highlighted analytical procedures in its thematic inspections of PIE audit firms. Common findings include expectations that are insufficiently precise to identify material misstatements (NV COS 520.5(c)), failure to set quantified investigation thresholds before performing the analysis, and reliance on management explanations for significant fluctuations without obtaining corroborating audit evidence (NV COS 520.7). The AFM expects the working paper to document the expectation, the threshold, the source data used, and the conclusion for each significant variance.

For Dutch statutory audits (wettelijke controles), the AFM places particular emphasis on completion-stage analytical procedures (NV COS 520.6). Inspectors assess whether the auditor performed a comprehensive final analytical review that covered all material financial statement line items, not just those where substantive analytical procedures were planned. Auditors should ensure that their completion-stage analysis addresses changes in key ratios and any new items or discontinued balances that emerged after the planning stage.

United Kingdom — FRC and ISA (UK) 520

The UK applies ISA (UK) 520 (Revised June 2016), issued by the FRC (Financial Reporting Council). The standard is substantively identical to the IAASB base text, with no UK-specific paragraphs added to ISA 520 itself. However, the FRC’s inspection reports interpret the requirements with particular rigour, especially for PIE audits subject to the Audit Enforcement Procedure.

The FRC’s Annual Quality Inspection reports have identified analytical procedures as a recurring area of concern. Key findings include: auditors developing vague or unquantified expectations that could not identify material misstatements (ISA (UK) 520.5(c)), using prior year balances as the sole expectation without adjusting for known changes in the business, and failing to investigate fluctuations that exceeded the stated threshold because management provided a plausible but uncorroborated explanation (ISA (UK) 520.7). The FRC expects the investigation to include evidence beyond management inquiry.

For completion-stage analytical procedures (ISA (UK) 520.6), the FRC expects a documented overall assessment that covers the full financial statements, not a selective review of items already tested. Inspectors have noted cases where the completion-stage analytical review was performed as a tick-box exercise rather than a genuine evaluation of whether the financial statements as a whole are consistent with the auditor’s understanding. Auditors should ensure the completion-stage analysis explicitly references knowledge gained during the audit, including the results of substantive testing and any misstatements identified.

Australia — AUASB and ASA 520

Australia adopts ISA 520 as ASA 520, issued by the AUASB (Auditing and Assurance Standards Board). The standard uses “financial report” rather than “financial statements” throughout, reflecting Corporations Act 2001 terminology, but the analytical procedures requirements are substantively identical to the IAASB base text. ASA 520 applies to all audits conducted under Australian Auditing Standards, including those of listed entities, large proprietary companies, and registered schemes.

ASIC (Australian Securities and Investments Commission) conducts audit inspection programmes and has identified analytical procedures documentation as a focus area. Common findings include expectations that are not sufficiently precise to identify material misstatements (ASA 520.5(c)), investigation thresholds that are not documented before the analysis is performed, and insufficient corroboration of management explanations for significant fluctuations. ASIC has also noted instances where auditors applied analytical procedures to accounts for which the methodology was not suitable given the nature and predictability of the balance.

The AUASB has not added Australia-specific paragraphs to ASA 520, but ASIC expects auditors to apply the standard with attention to the entity’s regulatory environment under the Corporations Act. For completion-stage analytical procedures, ASIC inspectors assess whether the auditor considered all material line items and whether the overall conclusion is consistent with the audit evidence obtained. Auditors should ensure that their analytical review working papers clearly link the investigation of each flagged item to the corroborating evidence obtained, rather than relying solely on management representations.

UAE — ISA as issued by the IAASB

The UAE adopts ISA as issued by the IAASB for all statutory audits, per Ministerial Resolution No. 403/2015. There are no UAE-specific modifications to ISA 520. The regulatory framework is governed by Federal Decree Law No. 41/2023 on the Regulation of the Accounting and Auditing Profession, with the Ministry of Economy and Tourism (MoET) as the primary regulatory authority for audit quality oversight.

The Emirates Association for Accountants and Auditors (EAAA), an IFAC member body, coordinates quality assurance reviews. In practice, analytical procedures in the UAE present particular challenges due to the prevalence of rapid-growth entities, newly established businesses with limited prior-year comparatives, and entities operating across multiple free zones with different reporting requirements. Auditors should pay particular attention to the reliability of prior-year data used in trend analysis (ISA 520.5(b)), especially for entities that have undergone restructuring, changed accounting policies, or shifted operations between mainland and free zone jurisdictions.

Financial free zones (DIFC under DFSA rules, ADGM, and SCA-regulated entities) require ISA in full. For completion-stage analytical procedures, auditors in the UAE should consider the impact of VAT implementation (introduced 2018), economic substance regulations, and evolving transfer pricing rules on year-over-year comparability. Fluctuations caused by regulatory changes should be documented as known business changes rather than investigated as potential misstatements, provided the auditor has obtained sufficient evidence that the regulatory change explains the movement.

United States — AICPA AU-C 520 / PCAOB AS 2305

The United States operates a dual-standard regime for analytical procedures. Audits of non-public entities follow AICPA AU-C 520 (Analytical Procedures), which closely converges with ISA 520. Audits of SEC registrants (public companies) are governed by PCAOB AS 2305, Substantive Analytical Procedures, which differs from ISA 520 in structure and emphasis. AS 2305 addresses only substantive analytical procedures, while completion-stage analytical review is covered separately under AS 2810 (Evaluating Audit Results).

PCAOB inspection reports have consistently identified analytical procedures as a deficiency area, particularly the precision of expectations. Common findings include: developing expectations based solely on prior-year balances without considering known changes (AS 2305.09), failing to quantify the expected amount or acceptable range before comparing to the recorded balance, and accepting management explanations for significant differences without obtaining corroborating evidence (AS 2305.16). The PCAOB expects the auditor to document the expectation, the factors considered, the threshold for investigation, and the conclusion for each substantive analytical procedure.

AU-C 520 largely mirrors ISA 520 but adds specific guidance for governmental entities (AU-C 520.A17), directing auditors to consider the unique operating environment and funding mechanisms of government entities when developing expectations. For both AU-C 520 and AS 2305, the key inspection theme is the same: analytical procedures must produce evidence that is persuasive enough to reduce substantive detection risk to an acceptably low level. When the auditor uses analytical procedures as the sole substantive test for an assertion, the expectation must be developed with a higher degree of precision, typically using disaggregated data and independent sources rather than simple year-over-year comparison.

Get practical audit insights, weekly.

No exam theory. Just what makes audits run faster.

290+ guides published20 free toolsBuilt by practicing auditors

No spam. We’re auditors, not marketers.