Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 16 Next »


 

 

Close

How satisfied are you with our online help?*

Just these help pages, not phone support or the product itself

0
1
2
3
4
5
Very dissatisfied
Very satisfied

Why did you give this rating?

Anything else you want to tell us about the help?

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.

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.

Perpetual vs Periodical inventory

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

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.

Average costing method

No matter which inventory method you choose, AccountRight calculates your inventory's value by using the Average costing 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.

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, 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.

 

 

 

 

 

 

 

For 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.