audit-essentials

Designs and documents a defensible audit sample under ISA 530 concepts, choosing between monetary-unit (MUS), attribute, and haphazard sampling, computing sample size from population value, tolerable and expected misstatement, and confidence level, and drafting the audit sampling memo (rationale, method, selection approach, evaluation). Use this when planning substantive tests of detail or tests of controls, sizing a sample for an account balance, selecting items for testing, or preparing the sampling workpaper for an external or internal audit using ISA, IFRS, or US GAAP populations.

Systematically audits an Excel or CSV workbook for spreadsheet risk before a reviewer sees it - flagging hardcoded constants inside formulas, inconsistent formulas across rows and columns, broken or external links,

Ties a set of financial statements to the trial balance and internally cross-checks them for an audit or review engagement - foots and cross-foots each statement, agrees totals to a TB mapping, confirms the balance sheet balances, agrees the cash-flow movement to balance-sheet deltas, and flags untied amounts and rounding inconsistencies as tickmark-style findings. Use this for audit tie-out, financial statement footing, TB-to-FS agreement, IFRS or US GAAP statement cross-referencing, casting checks, and disclosure-to-face-of-statements consistency in Excel or CSV.

Checks a financial-statements draft against core IFRS presentation and disclosure requirements (IAS 1, IAS 7, IFRS 7, IFRS 15, IFRS 16) and produces a gap list mapping each missing or incomplete disclosure to its standard reference with suggested remediation; use this during audit fieldwork, financial-statement review, or year-end close to validate the completeness of notes to the accounts, primary statements, accounting policies, and disclosures around revenue, leases, and financial instruments before sign-off.

Runs ISA 240 journal-entry fraud and anomaly screens over a general-ledger extract (weekend/holiday/post-period postings, round-number amounts, entries just below approval thresholds, rare user-account pairings, unusual account combinations, manual top-side entries) and produces population statistics plus a flagged-items workpaper for audit follow-up; use for financial statement audit journal entry testing, JET, GL data analytics, fraud risk and management override of controls procedures, and Excel/CSV ledger reviews.