Tabellab
Accounting Beginner

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.

20 lessons 20 labs Certificate

  • 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

  1. Trial Balance Tie-Out: Totals, Difference and GL AgreementLabFree
  2. Materiality: Overall, Performance and Clearly TrivialLab Locked
  3. Selecting Samples: Every n-th Item and Random with a Seed ColumnLab Locked
  4. Vouching Tracker: Differences, Exceptions and the Error RateLab Locked
  5. Analytics: Year-over-Year Changes, Flags and Key RatiosLab Locked
  6. Duplicate Payments: Vendor, Invoice and Amount with COUNTIFSLab Locked
  7. Journal Entries Posted on Weekends and Public HolidaysLab Locked
  8. Round-Amount Journal Entries with MODLab Locked
  9. Cut-Off Test: Invoice Date vs Shipping Date at Year EndLab Locked
  10. Recalculating the Client’s Aged Receivables ReportLab Locked
  11. Workpaper Sign-Off Status for the Audit FileLab Locked
  12. Summary of Misstatements vs Materiality, with a ChartLab Locked
  13. Auditing the Bank Reconciliation: Confirmed Balance, Items Cleared after Year End and Stale ChequesLab Locked
  14. Receivables Confirmations: Differences, Response Rates and Alternative Procedures for Non-RepliesLab Locked
  15. Payroll Proof in Total: Headcount × Salary, a Mid-Year Pay Rise and the Difference to ExplainLab Locked
  16. Fixed Asset Additions: Capitalisation Policy, Items to Expense and Depreciation from the Month of UseLab Locked
  17. Inventory at Cost or NRV: Net Realisable Value from January Prices and the Write-Down with MAXLab Locked
  18. Lead Schedules: Posting Audit Adjustments with SUMIF and Summarising Areas with SUMIFSLab Locked
  19. Going-Concern Indicators: Current Ratio, a Monthly Cash Forecast and the First Month below the MinimumLab Locked
  20. Final Project: Audit Completion Dashboard – Hours vs Budget, Uncorrected Misstatements, Open Points and «Ready for Review?»Lab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy