Inventory at Cost or NRV: Net Realisable Value from January Prices and the Write-Down with MAX
Lessons in this course
- 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