CORAA
AI Modules/Working Papers/Inventory
SA 501 · Inventory· पत्र

Inventory

Closing stock sourced from the Stock-in-Hand ledger, CY/PY movement, a gross-profit trend with a written conclusion, per-item price exceptions, quantity-coverage, obsolescence and cut-off flags, and an honest Type B nil state when there's genuinely nothing to test.

CORAA working paper exported to firm Excel template

Inventory sources its closing stock figure directly from the Stock-in-Hand ledger, then composes CY/PY movement as a percentage so a swing stands out without needing a separate calculation. A gross-profit-percentage trend sits alongside it with a written conclusion, not just a number, reading as an SA 520 analytical review: what moved, and whether the movement is explained or needs a follow-up. Per-item price exceptions compare vendor rates across purchases and flag wide spreads for AS 2 cost-measurement review. A quantity-coverage card shows how much of the counted inventory the audit evidence gathered actually covers, so the auditor can see the gap rather than assume full coverage. Obsolescence, expiry, and cut-off risk are flagged where the data supports it, and third-party-stock prompts surface when inventory may be held on someone else's premises or someone else's stock may be held on the auditee's. Where there is genuinely no inventory to test, the working paper states a Type B nil plainly, rather than rendering an empty grid that looks like missing work.

  • Closing stock sourced from the Stock-in-Hand ledger, not re-derived
  • CY/PY movement composed as a percentage, swings stand out immediately
  • Gross-profit-percentage trend with a written conclusion, SA 520 analytical review framing, not a bare number
  • Per-item price exceptions across vendor rates, wide spreads flagged for AS 2 cost-measurement review
  • Quantity-coverage card shows how much of counted inventory the evidence actually covers
  • Obsolescence/expiry and cut-off risk flags, third-party-stock prompts, and an honest Type B nil state when there's nothing to test
Two paths, one ledger

The old way, and ours.

Two paths to the same audit conclusion. One leaves traces; the other doesn't.

Traditional

The old way

  • -Closing stock figure re-keyed from a separate stock statement, disconnected from the ledger it should tie to
  • -Gross-profit trend computed as a number with no written read on what moved or why
  • -Vendor price comparison done on a sample, wide spreads found only if someone happens to notice
  • -Coverage of counted inventory assumed complete, rarely quantified against the evidence actually gathered
  • -A nil-inventory engagement often left as a blank template page, indistinguishable from unfinished work
Build time: a day of stock-sheet reconciliation. A blank inventory page and a genuinely nil inventory look identical unless someone writes it down.
CORAA

On the Ledger

  • Closing stock read straight from the Stock-in-Hand ledger, CY/PY movement composed as a percentage automatically
  • Gross-profit trend carries a written conclusion alongside the number, framed as SA 520 analytical review
  • Every vendor price compared per item, spreads flagged for AS 2 review, not just a sample
  • Quantity-coverage card quantifies how much of the count the evidence covers
  • Obsolescence, expiry, cut-off, and third-party-stock flags surfaced where the data supports them
  • Type B nil stated plainly when there's genuinely no inventory, never an empty grid
Build time: instant. A genuine nil is stated as a nil, not left to look like missing work.
How it works

Three steps. Every trace logged.

Step 01

Closing stock from the ledger, movement as a percentage

Closing stock is read directly from the Stock-in-Hand ledger. CY and PY balances are compared and expressed as a movement percentage, so an unusual swing is visible without a separate calculation.

Step 02

Gross-profit trend, written not just numeric

The gross-profit percentage is trended CY against PY and comes with a written conclusion under SA 520 analytical review framing, describing what moved and whether it holds up, not just the percentage itself.

Step 03

Price exceptions, coverage, and risk flags

Vendor rates are compared per item and wide spreads are flagged for AS 2 cost-measurement review. A quantity-coverage card shows how much of the counted inventory the gathered evidence covers. Obsolescence, expiry, and cut-off risk are flagged, with third-party-stock prompts where relevant, and a Type B nil is stated plainly when there's nothing to test.

Inside the module

What you actually get.

Ledger-sourced closing stock and movement

Closing stock comes straight from the Stock-in-Hand ledger balance, never re-derived from a separate stock sheet, with CY/PY movement composed as a percentage.

  • Closing stock sourced from the Stock-in-Hand ledger
  • CY vs PY movement expressed as a percentage
  • No re-derivation from a separate stock statement
  • Ties to the balance sheet closing figure

Gross-profit trend with a written conclusion

The GP% trend is presented with a written read, not a bare figure, describing whether the movement is explained or flags a follow-up, under SA 520 analytical review.

  • CY vs PY gross-profit percentage trend
  • Written conclusion accompanies the number
  • Framed under SA 520 analytical procedures
  • Surfaced for the auditor's sign-off, not auto-concluded

Per-item price exceptions and quantity coverage

Vendor rates are compared item by item and wide spreads flagged for AS 2 review. A quantity-coverage card quantifies how much of the counted inventory the gathered audit evidence actually covers.

  • Per-item vendor rate comparison
  • Spreads flagged for AS 2 / Ind AS 2 cost-measurement review
  • Quantity-coverage card: evidence gathered vs quantity counted
  • Gaps in coverage surfaced, never assumed closed

Risk flags and honest Type B nil

Obsolescence, expiry, and cut-off risk are flagged where the data supports it, third-party-stock holding is prompted for, and a genuinely nil inventory position is stated as a Type B nil rather than an empty grid.

  • Obsolescence and expiry risk flags
  • Cut-off risk flags around year-end movement
  • Third-party-stock prompts, held-for-others or held-by-others
  • Type B nil stated plainly when there's nothing to test, cited to SA 501
Frequently asked

Answers, up front.

No. CORAA surfaces the ledger-sourced closing stock, the price spreads, and the risk flags as evidence. Valuation and the obsolescence call under AS 2 / Ind AS 2 stay the auditor's judgment, recorded against the working paper.
It means the working paper checked and found no inventory to test, and says so plainly, rather than rendering an empty grid that could be mistaken for unfinished work. It's an explicit conclusion, not a blank page.
The coverage card quantifies how much of the counted inventory the gathered audit evidence actually reaches, so a partial verification shows as a partial number rather than reading the same as a full one.
See it on a real ledger

Run inventory on one of your engagements.

Bring a Trial Balance and a General Ledger. We'll walk through working papers end-to-end on your data, not a sandbox.

Start the free trial →
Inventory Working Paper | GP% Trend, AS 2, SA 501 | CORAA