Forum Discussion

TheRob's avatar
TheRob
Experienced User
2 months ago

GP based on GST excl. sell and GST incl. cost

Have I done something wrong in my MYOB setup? When I look at Business Insights Item Profit margin it shows the Sell Price excluding GST, but the Buy price is Inclusive of GST. The screen shots below...
  • TheRob's avatar
    TheRob
    2 days ago

    After consulting with the Product Specialist, he confirmed that the MYOB calculation is wrong, and has been for many years, but seemed disinterested in doing any more than referring it to the development team to consider. I guess I wait and see how long, if ever, MYOB take to fix this accounting error in the Business Insights section of their accounting software. 

TheRob's avatar
TheRob
Experienced User
2 months ago

Hi Genreve_S,

 

Thanks for your response, however I believe that this is actually either a programmed mathematical/accounting error, or I have some incorrect setting that needs to be fixed. If its a programming error, I don't think any votes should be needed to fix it, so I am assuming I have a wrong setting somewhere that I need to fix. If this is the wrong forum for that, I request some guidance.

 

To help demonstrate the error, I have reproduced a basic scenario. Bear in mind that my assumptions are based on the following formulas:

GROSS PROFIT(excl. GST) = REVENUE (excl. GST) - COST (excl. GST) 

GROSS PROFIT MARGIN = GROSS PROFIT(excl. GST) ÷ REVENUE (excl. GST) X 100% 

Mathematically GROSS PROFIT MARGIN would give the same result if GROSS PROFIT and REVENUE were both calculated using GST inclusive figures. The problem is that MYOB uses GST inclusive cost and GST exclusive Sell.

   

  • Doreen_P's avatar
    Doreen_P
    MYOB Moderator
    2 months ago

    Hey there TheRob,

     

    To check if there's any incorrect setup or setting, please reach out to our support team directly via our virtual assistant MOCA or by submitting a support case via MyAccount.

     

    Best regards,

    Doreen

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.

 

Related content