MYOB inventory: items, stock and costs in 2026
Keep MYOB inventory aligned with what your store can sell. Follow item setup, quantity and cost adjustments, then reconcile storefront availability.
- Published
- Last updated
MYOB inventory management tracks the items you buy and sell, their on-hand quantities and their cost value. Start with the right MYOB edition, establish opening balances, then record purchases, sales and corrections against the same item. Your storefront needs a separate rule for how much of that stock customers can buy.
Identify your MYOB inventory product
Identify both your MYOB subscription and the interface you use before following inventory instructions. Lite and Pro run in a browser. AccountRight Plus and Premier combine desktop software with browser access to online company files.
| Product | Inventory allowance | Workflow distinction |
|---|---|---|
| MYOB Business Lite | 10 active tracked items included, or unlimited with Premium Inventory | Browser inventory for selling stock on hand. Sales orders are unavailable in Lite. |
| MYOB Business Pro | 10 active tracked items included, or unlimited with Premium Inventory | Browser inventory with sales orders and committed quantities. |
| AccountRight Plus | Unlimited inventory | Use the Windows desktop app for advanced functions such as item builds, backorders and tiered pricing. |
| AccountRight Premier | Unlimited inventory and multiple warehouse locations | Use the Windows desktop app for multiple-location inventory. Browser sales check only the primary location. |
MYOB’s Premium Inventory explanation defines the limit by active items with stock tracking selected. Untracked items don’t consume that allowance. Premium Inventory adds an item-count allowance to Lite or Pro, with an extra subscription fee. It retains the included inventory functions.
The browser and desktop feature guide explains why a browser session doesn’t expose every AccountRight feature. Plus and Premier need a Windows computer for setup and advanced functions. AccountRight Standard appears in legacy-file help, but isn’t one of the current editions compared here.
MYOB Acumatica, formerly MYOB Advanced, is a separate enterprise resource planning product. Its inventory setup belongs to that system’s implementation, so don’t apply the small-business steps below to it.
Native MYOB inventory suits a retailer whose required stock states and purchasing workflow fit the selected edition. A connected inventory system can be useful when you need warehouse allocations or storefront updates that the native workflow doesn’t supply. Compare its location support and reservation states. Confirm how receipts and storefront updates work before assigning it control of availability.
Create items and establish opening quantities
Create one tracked record for each item you need to count, then enter the stock quantity and cost value already held. The following steps use MYOB Business in the browser.
- Open Create > Item. Enter a unique Item ID and a recognisable name.
- Select “I track stock for this item”. Choose the asset category that holds its inventory value.
- Complete the selling settings. Select “I sell this item”, set the selling unit and choose the income and cost of sales categories.
- Complete the buying settings. Select “I buy this item”, enter the buying unit and set the number of inventory units per buying unit.
- Save the item, then open Products & services. Select the tracked item and choose Adjust inventory to enter its opening balance.
- Enter the opening quantity difference and unit cost. Use the agreed opening-balance category and a memo that identifies the supporting records, then save.
Follow MYOB’s item creation instructions for the individual tax and price fields. Keep the inventory unit explicit. If you buy a carton of 12 bottles and sell individual bottles, one buying unit must add 12 inventory units.
For an illustrative opening balance, assume no stock is recorded yet. Enter 20 bottles at $10 each. The resulting inventory record must show 20 on hand, a total value of $200 and an average cost of $10. MYOB’s opening inventory procedure uses an inventory adjustment to establish those balances. Reconcile the opening value with the accounting opening balances so it isn’t entered twice.
In AccountRight desktop, create the record through Inventory > Items List > New. Its buying, selling and inventory selections use accounts instead of the browser’s category wording. Use the desktop opening-balance workflow for that company file.
Keep the item identity consistent across systems. For example, map storefront variant BOTTLE-NAVY-750 to MYOB Item ID BT750N. Record the mapping explicitly and keep other sizes or colours separate. A matching product name alone doesn’t prove that a transfer updates the right variant.
Follow purchases and sales through stock and cost
A tracked item purchase increases quantity and inventory value. An item sale reduces quantity and recognises the stock’s cost in cost of sales. The customer’s selling price is a separate amount.
This illustrative MYOB Business sequence uses individual bottles and excludes goods and services tax (GST) from the calculations. It assumes no freight allocations, returns or other movements.
| Recorded event | On-hand quantity | Inventory value | Average cost | Cost of sales for event |
|---|---|---|---|---|
| Opening balance, 20 at $10 | 20 | $200 | $10 | None |
| Supplier bill, 10 at $16 | 30 | $360 | $12 | None |
| Item invoice, 5 sold | 25 | $300 | $12 | $60 |
MYOB uses weighted average cost. Divide the total item value by its on-hand quantity. After the purchase, $360 divided by 30 is $12. Selling five bottles removes $60 of inventory cost, leaving $300 across 25 bottles.
A selling price of $30 per bottle would produce $150 of sales revenue before GST. It doesn’t change the $12 average cost.
Record the purchase as a supplier bill with the tracked item selected, using Purchases > Bills. Record the sale as an item invoice through Sales > Invoices. A payment against either document settles the amount owed. Don’t enter another stock movement just because the payment arrives.
Keep orders separate from completed movements. A purchase order records stock ordered from a supplier, not stock already received. AccountRight desktop also supports receiving items against an order before the bill, with an inventory accrual until billing.
MYOB Business Pro and AccountRight browser sales orders mark inventoried items as committed to customers. Convert the order to an invoice when ready to supply it. Lite doesn’t have sales orders. AccountRight desktop handles backordering, while AccountRight browser doesn’t support backordering to fulfil sales. Don’t count a supplier order as stock ready for immediate delivery.
Record a quantity or value adjustment
Use an inventory adjustment for a genuine quantity or cost correction, after checking the underlying transaction. Enter the difference needed, not the desired closing balance.
For one damaged bottle in the example, the quantity difference is minus 1. Its current average cost is $12, so the inventory value reduction is $12.
- Open Products & services, select the tracked item and choose Adjust inventory.
- Set the adjustment’s transaction date and reference. Confirm the displayed current quantity is 25.
- Enter minus 1 in the Adjustment column, using inventory units. Confirm New on hand is 24.
- Review Unit cost of $12 and Amount of minus $12. Select the appropriate damage expense or cost of sales category.
- Add a Memo identifying the damaged unit and supporting record. Save the adjustment, then reopen the item to confirm quantity and value.
AccountRight desktop uses Inventory > Adjust Inventory and Record. Keep the same distinction between the quantity difference and the closing balance. MYOB’s adjustment instructions cover both interfaces.
Quantity and value corrections compared
Each correction below starts independently from 25 bottles worth $300. The rows are alternatives, not consecutive entries.
| Correction | Quantity difference | Value difference | Closing quantity | Closing value | Closing average cost |
|---|---|---|---|---|---|
| Write off one damaged bottle at average cost | Minus 1 | Minus $12 | 24 | $288 | $12 |
| Correct an understated value without changing stock | 0 | Plus $25 | 25 | $325 | $13 |
| Remove one unit while retaining total value | Minus 1 | $0 | 24 | $300 | $12.50 |
For a value-only correction, keep the quantity difference at zero and enter the required amount. Increasing value at a fixed quantity increases average cost. Removing quantity without removing value also increases average cost, which makes it unsuitable for the damage example.
Before correcting an opening record, inspect later purchases, invoices and adjustments. A wrong buying-unit conversion or duplicate bill needs its source error resolved. Another adjustment could hide it. MYOB prevents deletion of an adjustment that would leave negative quantities or item values. If a change is refused, inspect dependent transactions and their order before changing anything else.
Keep the correction in the item’s inventory history. An unrelated general journal can change the inventory asset balance without correcting the item quantity or value.
Set the stock authority your storefront can use
Assign one owner to each field so an accounting correction doesn’t overwrite an approved selling price or publish unavailable stock.
| Field | Example authority | Transfer rule |
|---|---|---|
| Item identity and variant mapping | Catalogue administrator | Approve the mapping before quantities move. |
| Inventory cost | MYOB accounting record | Keep cost separate from public prices. |
| Sellable quantity | Designated inventory or reservation system | Publish the approved available quantity for eligible locations. |
| Customer-facing price | Storefront pricing settings | Apply the store’s price and promotion rules. |
Consider a separate illustrative stock position. MYOB records 40 units on hand. Eight are reserved for unfulfilled orders, two are damaged but awaiting write-off, and five are at a location excluded from online fulfilment. These groups don’t overlap. The storefront can offer 25 units: 40 minus 8 minus 2 minus 5.
Once the damage adjustment reduces MYOB on hand to 38, remove the separate two-unit damage deduction. Availability remains 25. Deducting the damage again would understate what the store can sell. Use the same rule for reservations already deducted by the source system.
Trace each approved availability change through the transfer process. Identify the item mapping, the source quantity, any deductions and the resulting storefront quantity. Keep the last successful transfer time and outcome in the integration’s operational records. The shopper’s product page and stock answer must consume the same approved availability.
If transfers stop, follow a defined stale-data rule. For example, withdraw an immediate-delivery promise for the affected variant and direct the stock question to staff. A previous successful transfer proves what arrived then, not what remains available now.
Connecting accounting records and installing a shopping agent are separate tasks. An agent needs the approved catalogue availability to answer a stock question. It mustn’t derive sellable stock from an accounting cost balance. For connector configuration, use the Shopify MYOB integration guide. The Shopify catalogue integration guide explains field ownership across connected systems.
Reconcile records and investigate differences
Reconcile the same item, inventory unit and reporting boundary before comparing MYOB with your storefront. Otherwise a timing difference can look like missing stock.
In the browser, open Reporting > Reports > Inventory. Use Items register to follow movements, Stock on hand for quantities and cost, and Inventory value reconciliation exceptions for item values against linked asset categories. AccountRight desktop has equivalent views through Items Register Detail and Items Register Summary, plus Inventory Value Reconciliation. MYOB’s inventory report guide explains the available views.
| Symptom | Check | Corrective action |
|---|---|---|
| Wrong on-hand quantity | Compare item mapping, buying units and duplicate or missing transactions. | Correct the source error or record the evidenced physical difference. |
| Unexpected average cost | Divide current value by quantity, then inspect purchases and value-only adjustments. | Resolve the incorrect cost or adjustment before changing storefront prices. |
| Reports disagree | Match the reporting boundary and inspect future-dated movements. | Compare the same transaction population and correct any misdated source record. |
| MYOB is correct but storefront stock is stale | Inspect the last successful transfer, variant mapping and location filters. | Repair the responsible transfer and confirm the received storefront value. |
| Asset balance differs from item values | Inspect reconciliation exceptions and direct postings to the inventory asset category. | Resolve the identified posting or category error with the accounting record’s owner. |
Finish by checking the illustrated purchase, sale and damage correction in order. The purchase leaves 30 bottles worth $360. The sale leaves 25 worth $300 and records $60 in cost of sales. The damage correction leaves 24 worth $288. Compare the storefront against its own reservation and location deductions, then confirm a customer can buy only the authorised quantity after the next successful transfer.
Give your store its own shopping agent
Customers ask in their own words. Your agent finds, compares and checks out from your catalogue, right on your site.