Cost of Sales value for one item is consistently incorrect?

Highlighted
Contributing User
10 Posts
Contributing User
Contributing User

10Posts

0Kudos

0Solutions

Cost of Sales value for one item is consistently incorrect?

Have just upgraded to Account right live. When we invoice one item, the relevant cost of sale is consistenly under valued. How do we correct this? It was the same problem before we upgraded.

7 REPLIES 7
Highlighted
MYOB Staff Post
425 Posts
MYOB Staff Post
MYOB Staff Post

425Posts

170Kudos

115Solutions

Re: Cost of Sales value for one item is consistently incorrect?

Hello @BPollard ,

MYOB follows Average costing method, whereby COGS of an item is determinted by:

Current Value / Qty on hand

 

(as seen in the screenshot below, the average cost is $346.326 (total value: $1731.63 / 5 qty = cost $346.326)

We recommend that you talk to your accountant about perhaps recording an inventory adjustment to bring up the total value of this item, thereby increasing the average cost.

https://help.myob.com/wiki/x/IYFW

I would also recommend looking at the item history, by clicking into the blue arrow next to Current Value, in an attempt to determine whether a cost discrepancy can be found in any past transactions.

 

Furthermore, also be mindful that this average cost & total value is usually a GST exclusive amount. and hence the COGS realised on the sales invoice is also a GST exclusive amount.


Regards
Ali
MYOB Client Support
average cost.JPG
Highlighted
Contributing User
10 Posts
Contributing User
Contributing User

10Posts

0Kudos

0Solutions

Re: Cost of Sales value for one item is consistently incorrect?

Hi Alik607, thanks for your response.

Unfortunately not solved, however it was helpful. I did find some errors in builds from looking at the item history. 

I adjusted my stock to get the correct cost based on current value/current stock. See screen shot 1

I then entered a sales but the resulting COGs does not take the average cost. See screen shots 2 & 3

COGS calculation is still wrong and does not appear to be based on the average cost

 

Highlighted
MYOB Moderator
2,317 Posts
MYOB Moderator
MYOB Moderator

2,317Posts

251Kudos

362Solutions

Re: Cost of Sales value for one item is consistently incorrect?

Hi @BPollard 

 

Apologies for the delay in response. 

 

In AccountRight, when an item is sold, the asset account for the item is reduced thereby increasing the cost of sales account, and is determined based on average costing method, as explained by @AliK607. The resulting amount for cost of sales is shown exclusive of GST in the Items Register window.

 

Therefore,  it is $2140.52 for your item when 1000 units were sold. However, in order to clarify if that value is correct, please open the sales transaction, recap it by pressing Ctrl +R and attach screenshots for both the sale and recap window, so we can investigate it further.

Kind regards,
Komal

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

Highlighted
Contributing User
10 Posts
Contributing User
Contributing User

10Posts

0Kudos

0Solutions

Re: Cost of Sales value for one item is consistently incorrect?

Hi Komal

 

I've attached screen shots for the sales journal and recap. I have also included screenshots from the Inventory register which shows the average cost as $30 but cogs of about $12. Look forward to hearing from you.

thanks 

 

 

Highlighted
MYOB Moderator
2,317 Posts
MYOB Moderator
MYOB Moderator

2,317Posts

251Kudos

362Solutions

Re: Cost of Sales value for one item is consistently incorrect?

Hi @BPollard 

 

The cost of sale values do look incorrect, provided the tax code is N-T and average cost is approximately $30. However, if your file is online, please send me your serial number by a Private Message so I can run an online inventory script which resolves the issue at times.

Kind regards,
Komal

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

Highlighted
Contributing User
10 Posts
Contributing User
Contributing User

10Posts

0Kudos

0Solutions

Re: Cost of Sales value for one item is consistently incorrect?

see file attached, problem persists

Highlighted
MYOB Moderator
2,317 Posts
MYOB Moderator
MYOB Moderator

2,317Posts

251Kudos

362Solutions

Re: Cost of Sales value for one item is consistently incorrect?

Hi @BPollard 


I have sent you a Private Message with details on how to upload the backup to us.

Kind regards,
Komal

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

Didn't find your answer here?

Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post