Recording stocktakes

1. Go to the Reporting menu and choose Reports.

2. Click the Inventory tab.

3. Click Stock on hand to run the report.

4. Use the item filters to choose what items you want to report on. As you change report filters, the report will update automatically.

5. Select your Report options, for example if you want to include cents in amounts or if you want to show currency symbols.

6. If you want to customise the report further, for example to select and reorder columns, click Customise. For general information about customising reports, see Customising reports.

7. Click the Export button and export it as an Excel file.

You now need to count your physical stock and compare that to the on-hand quantities recorded in MYOB Business.

If you don't already have a method for counting your physical stock, you can easily use the Stock on hand report as a count sheet. Use it on a portable device like a tablet or iPad, or print it out and update it by hand.

1. Open the Stock on hand report Excel file you created and add two additional columns to it, for example: Counted and Difference.

2. Count the physical quantities of each item and add the figure in the Counted column.

3. In the Difference column, subtract the On hand quantities from the Counted quantities to record any differences.
   
   Your Stock on hand report should look a bit like this:
   

   

4. Save your changes to the Excel file.

If there was any difference between the on-hand quantities recorded in MYOB Business and the physical quantities of items (such as indicated in the Difference column in the Stock on hand report Excel file you created previously), you'll need to enter an inventory adjustment.

1. Go to the Products & services menu to open the Products and services page.

2. Select one or more inventory items you want to adjust and click Adjust inventory.

3. The Inventory journal number appears by default. You can change this is if you want, as well as the date of the adjustment. You can also enter a description of the inventory adjustment transaction.

4. Select whether you want this adjustment to be allocated as an end-of-financial-year adjustment. EOFY adjustments can be excluded from your financial reports.

5. Choose the Item ID of the item you want to adjust (inventoried items only). The name and the current on-hand quantity of the item appear. To find an item, you can start typing the item number or item name into this field.

6. In the Qty adjustment column, enter the quantity by which you want to increase or decrease the quantity held. Only enter the quantity variation – refer to the figure in the Difference column you added in the Stock on hand report Excel file. Enter the quantity in inventory units, not buying or selling units. If you enter a positive number, that number is added to your on-hand inventory. If you enter a negative number, that number is subtracted from your on-hand inventory.
   When you enter the adjustment:

   • the New on hand column displays what the on-hand quantity of the item will be after recording the adjustment

   • the Unit cost of the item appears by default. This is calculated as the total cost of the item divided by the number of units on hand. If these are new items, enter their purchase cost

   • the Amount field displays the value of the adjustment.

7. Choose the Category you want to assign the adjustment amount to. If you’re reducing the inventory value, this account is usually a cost of sales category or an expense category called ‘Shrinkage and Spoilage’ or similar to track loss or theft of items. If you're not sure what category to assign the inventory adjustment to, consult your accounting advisor.

8. If the item is related to a job, choose the Job.

9. You can add a description of the adjustment line in the Memo field.
   Here's our inventory adjustment example:

9. Click Save to save the inventory adjustment and update your inventory.