Add a Stocktaking Sheet
A stocktaking sheet compares the physical quantity in the warehouse with the quantity recorded in the system for each product, then settles the difference automatically with inbound requisitions for overages and outbound requisitions for shortages. This guide explains how to create and adjust a stocktaking sheet, how to record a stocktaking with a past date, and how stocktaking affects inventory and accounts.
🛈
Note: Before you begin, make sure the Inventory app is active in your account.
Contents
Steps to create a stocktaking sheet
- Click Inventory in the main menu, then Manage Stocktakings.
- Click Add Stocktaking.
- Choose the Warehouse, set the Date and time, and add Notes if any.
- Click Do Stocktaking.
- Click Add Item and add the products, or click Add All Products From Warehouse.
- For each product, enter the Physical Count (the actual quantity you counted).
- Click Done to save the sheet as a draft.
- Review the differences, then click Adjust to approve the stocktaking.
Stocktaking sheet fields
| Field | Description |
|---|---|
| Warehouse | The warehouse being counted. Each stocktaking sheet is for one warehouse. |
| Number | A serial number for the sheet. Its format is set from the auto number settings. |
| Date and time | The date and time of the stocktaking. It can be a past date (see the next section). |
| Notes | Any notes about the stocktaking. |
| Product Name | The product to count, found by searching by name. |
| Unit | The unit of measure you counted the product in. It appears only for products that have units. |
| Physical Count | The actual quantity in the warehouse. It doesn’t accept a negative value. |
| System Count | The product’s balance in the system up to the stocktaking date and time, calculated automatically by the system. |
The system compares the Physical Count with the System Count and calculates the shortage or overage for each product.
Stocktaking sheet with a past date
Yes, a stocktaking sheet can have a past date; the Date field accepts any earlier date, as long as it isn’t within a closed financial period. This is used when the physical count is done on one day and recorded in the system later, or to record an opening stocktaking with its correct date.
How the system handles a past date
- The System Count is calculated from the product’s balance up to the stocktaking date and time, not its balance today; only transactions made before that time are included.
- Transactions made after the stocktaking date and time (later sales or purchases) aren’t included in the comparison.
- The adjustment requisitions (Stocktaking Inbound and Stocktaking Outbound) are recorded with the stocktaking sheet’s own date, so the balances and transactions after it are recalculated.
Example
🛈
Note: Set the correct date and time before adding products, because the System Count is calculated based on them. The time matters if there are transactions on the same day as the stocktaking: transactions recorded before the stocktaking time are included in the balance, and those after it aren’t.
⚠
Warning: You can’t record a stocktaking sheet with a date within a closed financial period. And if overdraft isn’t allowed, the system may refuse to adjust a shortage with a past date if it would make the product balance negative on that date or after it because of later transactions.
Adjust the stocktaking sheet
After you click Adjust:
- A Stocktaking Inbound requisition is created with the overage quantities, and a Stocktaking Outbound requisition with the shortage quantities.
- The stocktaking sheet status changes from draft to adjusted, and it can’t be adjusted again.
- For tracked products (serial number, lot number, or expiry date), you must enter the tracking data for the difference quantity before adjusting.
Effect on inventory and accounts
- Overage quantities are added to and shortage quantities are deducted from the warehouse on the stocktaking sheet date.
- The value of the differences is posted to the Cost of Goods Sold account against the warehouse account.
- The transactions appear in the Inventory Detailed Transactions report as Stocktaking Inbound (overage) or Stocktaking Outbound (shortage).
Error messages and solutions
| Message | Reason | Solution |
|---|---|---|
| Stock can’t be adjusted because the stocktaking has no items | The sheet has no products. | Add at least one product. |
| Stock products can’t be adjusted because some items don’t have a physical count | Products without a Physical Count. | Enter the count for all products or remove the product. |
| The quantity is not available for … You cannot save the transaction with a negative amount | Adjusting the shortage would make the balance negative and overdraft isn’t allowed. | Review the transactions after the stocktaking date, or allow overdraft temporarily. |
| You cannot add, edit, or delete a transaction on this day …, within a closed period | The stocktaking date is within a closed period. | Choose a date outside the closed period or ask for it to be opened. |
Frequently asked questions
Can an inventory stocktaking sheet have a past date?
Yes. Set the past date in the Date field, and the system calculates the System Count from the product’s balance up to that date and time, and records the adjustment with the same date. The date must not be within a closed period. See Stocktaking sheet with a past date.
Why is the “System Count” different from the product’s current balance?
Because it’s the product’s balance up to the stocktaking sheet date and time, not today’s balance; transactions made after that time aren’t included.
Can I count more than one warehouse in one sheet?
No. Each stocktaking sheet is for one warehouse. Create a sheet for each warehouse.
Where can I find the adjustment requisitions created by the stocktaking?
In the requisitions, with the type Stocktaking Inbound or Stocktaking Outbound, and in the Inventory Detailed Transactions report.