Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
HTML Wrap
classsection group
HTML Wrap
classcol span_3_of_5

Before filling out your inventory, it's important to understand the different between Perpetual and Periodical inventory management, average costing method, and how it all affects your ending inventory.

Don't worry! It's a lot easier than it sounds, and this information will give you greater control over managing your stock - making your business life even easier.

UI Text Box
typetip

Managing a full inventory can sometimes be tricky. The MYOB Inventory Training Course is an excellent resource to better understand AccountRight's inventory and its features - helping you stock smarter.

First, we'll have a look at Perpetual vs Periodical inventory management. Then we'll outline average costing method and what it means for your inventory in AccountRight.

UI Expand
titlePerpetual vs Periodical inventory

Perpetual and Periodical are the two methods of managing your inventory.

UI Text Box
typenote

AccountRight is setup to record inventory perpetually. For more information on recording a periodical inventory, see Periodical inventory. Before implementing periodical inventory, you should discuss its suitability with your accounting adviser.

PerpetualContinually tracks monetary and physical inventory movement. In AccountRight, this system is used whenever an item is marked I Inventory This Item.
PeriodicalOnly updates the ending inventory balance when a physical count is done. In AccountRight, this system is used whenever an item is marked with I Buy This Item and I Sell This Item only.

For more information on when you'd use I Inventory This Item, I Buy This Item, or I Sell This Item, visit our page Creating items.

UI Expand
titleAverage costing method

No matter which inventory method you choose, AccountRight calculates your inventory's value by using the Average costcosting method.

Unlike other valuing methods, such as First In First Out (FIFO), the average costing method values your inventory by calculating its weighted average value, using the formula: Average Cost=Total Value of the item÷Total Quantity of items. Let's take a look at an example of how this would work in everyday business.

UI Text Box

Example

Let's say you purchase 10 wine glasses for $10.00 each. This will result in an average cost of $10.00 per item.

The following day, 10 more wine glasses were purchased, this time for $12.00 each. Your inventory looks like this:

  • Total Quantity of win glasses: 20
  • Total Value of wine glasses: $220.00
  • Average Cost: $11.00 ($220.00÷20)

It's important to note that this example is of the average cost method in a perpetual inventory system, where which AccountRight is setup to run. In this system, the average cost is calculated before each transaction.

In a periodical inventory system, the average is recorded after a physical stocktake, the multiplied with the number of items sold and number of units in ending inventory to arrive at cost of goods sold (COGS) and value of ending inventory respectively.

 

 

 

HTML Wrap
width15%
classcol span_1_of_5
 
HTML Wrap
floatleft
classcol span_1_of_5
Panelbox
namegreen
titleRelated topics
HTML Wrap
classsidebarlinks

Inventory

Periodical inventory

Create detail and header accounts

Recording a journal entry

Enter end-of-year adjustments

Error: Non-zero value

Error: Not enough items on hand to record this transaction

Panelbox
nameyellow
titleFrom the community

RSS Feed
titleBarfalse
max5
showTitlesOnlytrue
urlhttp://community.myob.com/myob/rss/search?q=inventory&filter=labels%2Clocation%2CsolvedThreads&location=category%3AAccountRight&search_type=thread&solved=true

HTML Wrap
classmorelinks
More »

...