Excel for Junior Auditors: Sampling, Vouching, Analytics & Workpapers
20 hands-on labs from a first-year audit: trial balance tie-out, materiality, sample selection, vouching tracker, year-over-year analytics, duplicate payments, weekend and round-amount journal entries, cut-off, aged receivables, workpaper sign-off and the summary of misstatements, then the bank reconciliation and stale cheques, receivables confirmations, a payroll proof in total, fixed-asset additions, inventory at cost or NRV, lead schedules with audit adjustments, going-concern indicators and an audit completion dashboard.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
This course follows a first-year audit of a fictional building-supplies company, in 20 auto-graded spreadsheet labs. You tie out the trial balance, set materiality, select and vouch samples, run year-over-year analytics, test for duplicate payments and unusual journal entries, check cut-off, recalculate the aged receivables, track workpaper sign-off and prepare the summary of misstatements. Part two adds the work a junior meets on every file: auditing the bank reconciliation and stale cheques, receivables confirmations with response rates and alternative procedures, a payroll proof in total with a mid-year pay rise, fixed-asset additions against a capitalisation policy, inventory at cost or net realisable value, lead schedules with audit adjustments, going-concern indicators from a cash forecast and a completion dashboard that decides whether the file is ready for partner review.
Lessons
- Trial Balance Tie-Out: Totals, Difference and GL AgreementFree
- Materiality: Overall, Performance and Clearly Trivial Locked
- Selecting Samples: Every n-th Item and Random with a Seed Column Locked
- Vouching Tracker: Differences, Exceptions and the Error Rate Locked
- Analytics: Year-over-Year Changes, Flags and Key Ratios Locked
- Duplicate Payments: Vendor, Invoice and Amount with COUNTIFS Locked
- Journal Entries Posted on Weekends and Public Holidays Locked
- Round-Amount Journal Entries with MOD Locked
- Cut-Off Test: Invoice Date vs Shipping Date at Year End Locked
- Recalculating the Client’s Aged Receivables Report Locked
- Workpaper Sign-Off Status for the Audit File Locked
- Summary of Misstatements vs Materiality, with a Chart Locked
- Auditing the Bank Reconciliation: Confirmed Balance, Items Cleared after Year End and Stale Cheques Locked
- Receivables Confirmations: Differences, Response Rates and Alternative Procedures for Non-Replies Locked
- Payroll Proof in Total: Headcount × Salary, a Mid-Year Pay Rise and the Difference to Explain Locked
- Fixed Asset Additions: Capitalisation Policy, Items to Expense and Depreciation from the Month of Use Locked
- Inventory at Cost or NRV: Net Realisable Value from January Prices and the Write-Down with MAX Locked
- Lead Schedules: Posting Audit Adjustments with SUMIF and Summarising Areas with SUMIFS Locked
- Going-Concern Indicators: Current Ratio, a Monthly Cash Forecast and the First Month below the Minimum Locked
- Final Project: Audit Completion Dashboard – Hours vs Budget, Uncorrected Misstatements, Open Points and «Ready for Review?» Locked
Learner reviews
Be the first to review this course.