The inventory reports in MYOB Business give you the insights to help you manage your inventory. They save you time from having to manually check stock levels, help ensure that you always have enough stock for your customers and that you're stocking the right type of items. Easily see how many items you have on hand, how many are on order or committed to a sale, how profitable each one is and when you need to reorder them. You can view inventory reports from the Inventory report group (go to the Reports page > Inventory). 
Report descriptionsName | Description |
|---|
| Reorder | See a list of your inventory items, their primary supplier, the number of units on hand or committed to sales or orders and easily reorder them. | | Stock on hand | Get a snapshot of your inventory quantities, including the units on hand and committed to sales, or orders. View the total value and average cost of your items. | | Item sales analysis | Analyse the sales performance and profitability of your items for a specified period. View the quantity of items sold, their gross profit and profit margin, and the cost of sales you incurred selling them. | | Items register | See all of the inventory items you've used in transactions within a specified date range. View the details of these transactions. | | Items list | Easily get a complete list of all of your items, their suppliers and values. | | Inventory value reconciliation exceptions | Reconcile your inventory by comparing the total value of all on-hand inventory to the current balance of the linked inventory accounts. |
| UI Expand |
|---|
| title | To run an inventory report |
|---|
| To run an inventory report- Go to the Reporting menu and choose Reports.
- Click the Inventory tab.
- Click the name of a report to run it.
Choose your report filters – these vary depending on the report. For example, choose what suppliers or items you want to report on. As you change report filters, the report will update automatically. Select your Report options, for example if you want to include cents in amounts or if you want to show the minus sign for negative amounts. 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. | UI Text Box |
|---|
| If the report is long, export it as an Excel file (click the Export button > Excel). Then you can use Excel's tools to sort it. |
|
Click a report name below to find out what it can tell you. | UI Expand |
|---|
| Reorder reportHow report amounts are calculated
 - On hand = the number of the item (by unit of measure, eg. box) in stock (excluding items committed to sales or on order with suppliers)
- On order with supplier = the number of items (by unit of measure) on order from a supplier
- Customers committed = the number of items you've sold (included in an open invoice to a customer)
- Minimum stock level = the minimum number of items, by unit of measure, you want to keep in stock, as set in the Minimum stock level field in the item's restocking information
- Unit of measure = what comprises a buying unit of the item, for example, each, box, case, kit, etc
- Order quantity = the default reorder quantity (per buying unit of the item), as set in the Default reorder quantity field in the item's restocking information
What the report can tell youThis report indicates all the item's you might want to reorder. This is where the available quantity of an item (the on-hand quantity plus the quantity on order with suppliers, less the quantity recorded in sales) falls below the minimum stock level, as set in the item's restocking information. It also gives you a picture of your stock movement: how many items are on order and how many are committed to customer sales. | UI Text Box |
|---|
| | A great feature of the report is that you can instantly create a purchase order for items you want to reorder, without having to go to other menus or pages. See Reordering items for more information. |
|
| UI Expand |
|---|
| title | Stock on hand report |
|---|
| Stock on hand reportHow report amounts are calculated
- Units on hand = the number of buying units of the item in inventory
- Committed = the number of selling units of the item in unpaid (open) invoices
- On order = the number of buying units of the item on order from suppliers
- Total value = the total cost value of the items on hand
- Average cost = Total value / Units on hand
- Grand total = the total value of all of your inventory
What the report can tell youThe report shows your inventory quantities, minus the number of units committed to sales, or orders. This can help you with your inventory planning and to determine if there is sufficient stock for sales. You can also easily see the total value of your inventory. |
| UI Expand |
|---|
| title | Item sales analysis report |
|---|
| Item sales analysis reportHow report amounts are calculated
- Quantity = the number of the selling unit sold in the specified period, for example six boxes
- Amount = the total dollar value of sales of the item for the specified period
- Cost of sales = cost of purchasing or manufacturing the items you've sold
- Gross profit = Amount - Cost of sales
- Profit margin = Gross profit / Amount * 100
What the report can tell youIf there are items with significantly smaller profit margins than then rest of your inventory, it could indicate underperforming product lines, excessive costs of sales for particular items (which might require you to find another supplier) or that you need to adjust your pricing. Run the report over different periods and compare the profit margins of items over time. |
| UI Expand |
|---|
| title | Items register report |
|---|
| Items register reportHow report amounts are calculated
- Starting quantity = the number of units of the item on hand before the transaction was recorded
- Quantity changed = the number of units of the item added to or removed from inventory by the transaction
- Amount = the total cost of the items bought, sold or adjusted
- On hand = the units on hand after each transaction
- Current value = the total value of units on hand after each transaction
| UI Text Box |
|---|
| To see all of the columns in the report, click Expand all. |
What the report can tell youYou can see all the sales, purchases and inventory adjustments which affect the on hand quantities and current value of your inventoried items. |
| UI Expand |
|---|
| Item list reportHow report amounts are calculated
- Units on hand = the on-hand quantity of each item
- Total value = the total cost value of the items on hand (Average cost * Units on hand)
- Average cost = Total value / Units on hand
- Current price = the current selling price of the item
What the report can tell youThis report gives you a basic list of your items, including the primary supplier, units on hand and current values. If you want to see the units on order or committed to sales, run the Stock on hand report instead. |
| UI Expand |
|---|
| title | Inventory value reconciliation exceptions report |
|---|
| Inventory value reconciliation exceptions reportHow report amounts are calculated
- Account balance = the balance of your inventory asset account
- Inventory value = the total current value of your inventory items
- Out of balance amount = Account balance - Inventory value
What the report can tell youThis report reconciles the balances of your inventory asset account with the values of the associated inventoried items as at a particular date. If the report has an out-of-balance amount, it will suggest transactions that may have caused it. Click Expand all to see them and click a transaction's credit or debit to open it. | UI Expand |
|---|
| title | If your inventory is out of balance |
|---|
| If your inventory is out of balanceIf the Inventory value reconciliation exceptions report is out of balance, check the following: | What to look for | Possible cause | Solution |
|---|
| Wrong feature used | Recording an inventory adjustment using a journal entry instead of the inventory adjustment feature. | Delete the transaction and record it again using the correct feature. | | Transactions allocated directly to the inventory asset account | Using the inventory asset account as the allocation account in a sale, purchase, spend money, receive money or inventory adjustment transaction. | Delete the transaction and record it again using the correct allocation account. | | Incorrect linked accounts | The linked asset account for an inventory item has been incorrectly linked to an account other than your inventory asset account. | Check the linked asset account for your items (Inventory > Items > open the item > Inventory section > Asset account for tracking inventory). If this account has been changed:- change it back to the correct linked account.
- determine the value of purchases which have been recorded while the wrong linked account was set (this is likely to be your out of balance amount)
- record a journal entry to transfer this value from the wrong linked account to the correct linked account.
|
|
|
Exporting, saving and printingYou can export a report as an Excel spreadsheet or PDF by clicking Export. For PDFs, you can also choose which style template you want to use. When the PDF displays, you can save or print it. Note that you must enable editing of the spreadsheet from within Excel. If editing is disabled, the spreadsheet will not display the totals calculated in the report. | UI Text Box |
|---|
| Bundle your inventory reports together Add multiple reports to a single document, complete with a cover page, table of contents and personalised styling. You can then run the report pack with your latest inventory or other business data and share it with others. For more information, see Report packs. |
|
Yes
No
Thanks for your feedback.