Stock on Hand workpaper (CLS)
How Stock on Hand is populated from an Inventory Item Summary, a client-provided document, and the separate Work in Progress section.
The Stock on Hand (CLS) workpaper reconciles closing stock and, where relevant, work in progress, at year end.
Data extraction, Stock on Hand
● Amount: from the Inventory Item Summary report (Reports, Transactions, Inventory Item Summary), the Total of the Closing Balance column. Where a client instead provides an Excel document, the Grand Total of the dollar-currency amount column is used; where a client provides a PDF, the Total figure is picked from that document directly.
● Description: the reference heading used depends on which of the three source scenarios applied.
● GL balance: closing balance of the account matching Stock on Hand, Inventory, or Closing Stock (account type Current Assets).
Data extraction, Work in Progress
● Amount: from a client-provided PDF, the total outstanding amount against items with status "In Progress".
● GL balance: closing balance of the account matching WIP Adjustments, WIP, or Work in Progress (account type Current Assets), specifically the "Finished Goods, WIP Adjustment" account.
How to access
● Go to Jobs and open the relevant job.
● Click the Workpapers icon or navigate to Job Results then Workpapers.
● Select CLS on the Workpapers Dashboard.