Year-end project stocktake and material consumption
Quick summary: Count material that remains unused at project locations. Use an inventory adjustment only for differences confirmed as consumption that has not yet been recorded. Unused material remains in stock, including on projects still open at year-end.
When to use this procedure
Section titled “When to use this procedure”Use this procedure when material was received or transferred to a project location and some was actually consumed without that consumption being recorded. The stocktake reconciles the records to unused material remaining. It does not close the project or manufacturing order.
| Stocktake finding | Treatment |
|---|---|
| Material remains unused at the project location. | Include it in the counted quantity. |
| Material is elsewhere or is returning to the warehouse. | Record an internal transfer; do not also expense the same relocation. |
| Material was demonstrably consumed, but the consumption is unrecorded. | Record the substantiated difference using this procedure. |
| Material was already consumed on a completed movement. | Do not record the same consumption again. |
| Material is missing, but the reason is unknown. | Investigate and agree its treatment with accounting. |
| Material has been incorporated into an unfinished product. | Distinguish raw-material consumption from work-in-progress valuation. Accounting determines the treatment of the unfinished product. |
Check the account before the first posting
Section titled “Check the account before the first posting”An inventory adjustment uses the product’s inventory adjustment location. It does not automatically use the location that receives manufacturing consumption. A correctly configured production-location account therefore does not guarantee the correct account for an inventory adjustment.
Accounting and the administrator should check these points on a test copy:
- which inventory adjustment location the actual correction uses and its Stock Valuation Account;
- whether that account represents the agreed material consumption rather than unexplained inventory loss;
- whether this procedure needs a separate location from general inventory differences; changing a shared setting can affect other products and future adjustments;
- whether the expected journal entry is produced and, with periodic valuation, included correctly in the stock closing.
If the company uses 310000 for stock and 400000 for material consumption, the expected effect of confirmed consumption is debit 400000 / credit 310000. These are example account codes; use your company’s accounts. A reduction in quantity alone does not prove that the expense reached the correct account. With periodic valuation, check the closing entry because the quantity change and accounting entry may occur at different times.
Count and apply consumption
Section titled “Count and apply consumption”- Agree the cutoff date, for example 31 December, and the list of projects and their locations with accounting. Include child locations where material is stored. Save an opening quantity and value export and the stocktake record.
- Coordinate movements during counting. Check missing receipts, returns, internal transfers, reservations and manufacturing consumption already recorded. For relocated goods, first process the document substantiating the relocation.
- Open Inventory > Operations > Physical Inventory. Filter to the correct company and project location. Check all relevant products, including archived products with stock, and distinguish lots, serial numbers, packages and owners.
- Enter the actual unused quantity remaining in Counted. Enter the remainder, not the quantity you want to consume. Enter zero only after confirming that no unused material remains.
- Review Difference on every line. A negative difference can represent unrecorded consumption only after its cause has been checked. Handle positive and unexplained differences separately. If warned about movements since counting, reconcile the new situation first.
- The Stock Manager selects only reviewed lines and clicks Apply. Enter an Inventory Reason, for example “Year-end stocktake – Project A – confirmed material consumption”, and check Counting Date, including time and time zone at the year boundary.
- Before clicking Update Quantities, check the selected lines and date. Confirmation creates completed movements and changes stock. Then verify the actual movement dates and new quantities.
- Accounting checks consumption value, accounts and posting period. With periodic valuation, also review the relevant stock closing. If a closing was already posted for that date, use the supported procedure to include the later adjustment; do not duplicate the old closing.
- Retain the link between the stocktake, project, movements and journal entries. Before closing the manufacturing order later, reconcile its components and remaining stock so consumption already recorded through the stocktake is not recorded again.
Example of partial consumption
Section titled “Example of partial consumption”A project location shows 100 kg of material. After reconciling all receipts and transfers, 25 kg remains physically unused. The responsible person confirms that the other 75 kg was consumed in production and has not yet been recorded as consumed.
Enter 25 in Counted, producing a Difference of −75 kg. If the correct value of those 75 kg is €300.00, the agreed accounting effect is a €300.00 debit to expense and credit to stock. The location retains 25 kg; check its value using the applicable costing method. With different FIFO purchase prices, do not use an arbitrary average price.
Entering 75 would record a difference of only 25 kg. Entering zero would also remove the 25 kg the company still holds.
Other year-end checks
Section titled “Other year-end checks”The stocktake does not itself ensure project analytic allocation or inclusion in the manufacturing order’s valuation. Accounting should check project analytics and prevent duplicate costs already recorded on bills or other movements.
Handle work in progress and finished-product valuation separately. Material may already have been consumed while its value still needs to be included in work in progress according to accounting’s assessment. A general stocktake does not replace that reclassification.
Valid open purchases and bills remain part of the open-document review. If the quantity is correct and only the value is wrong, use the valuation review rather than recording additional quantity consumption.