Forum Discussion

Mark299's avatar
Mark299
Experienced User
4 years ago

Cost pricing clarification

HI Myob community

Just to clarify when you purchase an item to out into your inventory to sell later is it the price you put in as the purchase price or is it the actual price that you paid. I purchase items internationally as as t he currency changes so does the purchase price. 

For example I'm just trying to get my head around how MYOB calculates "profit". So if I purchase an item for $20 and sell it for $50 then the profit is $30. Then the following time the item costs $25 so the "profit drops to $25. Does MYOB then calculate the average of these two purchases and sales?

 

Then in part two of the question to make things even more complicated I have this scenario.

We have a USA component to our business and we are often sharing equipment purchases. So Au business will buy product A and USA business will buy product B. We then transfer stock between the two businesses. 

At present to keep the inventory in each business correct I will simply put in X number of product A in sales from Au business and have the invoice total of $0 and similarly have a purchase invoice from USA business will a total of $0. 

By doing this will MYOB then see the purchase price as $0 and then calculate t he actual profit of the sale as described earlier as now $50 profit as there was no cost?

I guess then the inventory costs or sales will be affected as I have sold items at $0 in the system. Would this then show up in the system as -$25 profit?

It gets even more complicated as most times the items I am transferring between the two business as priced differently as one business is operating in USD and the other in AUD so exchange rates also come into play.

Sorry it's a bit long. Over to you community

  • Hi Mark299 

     

    The "fair transfer price agreement" is not something that I would be able to comment on.

     

    However, there was a question relating to closing off an invoice and purchase without the impact on the bank account. Generally in these situations, you want to use a contra/holding account and use the below process:

     

    1. Create a holding account if you don't already have one - Accounts>>Accounts Lists>>New - give the account a number, name and set the account type to be Bank.
    2. When ready to make payment, go to Sales>>Receive Payments>>Select the Deposit to Account to be that newly created account and then process the payment as per normal.
    3. Once that has been created, go to Purchases>>Pay Bills>>Select the Pay from Account to be that newly created account and then process the payment as per normal.

    What the above process will do is put the payment from the invoice into the holding account and uses those funds to pay off the purchases. As no "real" bank accounts are involved there is no impact on your bank accounts.

  • Mike_James's avatar
    Mike_James
    Ultimate Partner

    Hi Mark299 , when you buy and sell one item at a time, if there was no stock on hand prior, the cost of each sale will be what the last purchase cost was, in your home currency. 

     

    However, if you buy one item, and then immediately buy another, MYOB will then hold both items in stock and average the cost, so when you sell each item, the (average) cost would be $22.5 in your example. 

     

     In your second example, the inventory quantities will be correct, but:

    - the sale to AUS by USA will generate a loss, 

    - the purchase from USA by AUS will show a 100% margin

    - this is probably unacceptable under transfer pricing regulations

    - you need to determine a fair transfer price, probably including freight costs, then each side will report a portion of the margin. You should investigate which currency the transfer price should be set in.

     

     

    • Mark299's avatar
      Mark299
      Experienced User

      HI Mike Thanks for the prompt reply and I thought this would be the case. Sometimes when you look at the profit and losses they didn't really make sense.

      I guess the answer is to get like for like in the transfers so they cancel each other out as a purchase and a sale.

       

      So if I transferred say 65 item A's in a sale to the USA at a value of $6,500  and then did the same transfer for item B (that cost more)  but there was less of them equal to the $6,500 value each item would retain it's own profit margin in each business.  

      The only thing is how we show that transfer of funds to each company withour having it transfer though a bank account 

      Maybe if I create a credit from each business (based on the sale) and then put the transfer in as a purchase and use the credit to cover the payment. That would show the right figures but would it satisify the "fair tranfer price agreements for each country?

      Any other suggestion?

      Thanks

       

      • Steven_M's avatar
        Steven_M
        Former Staff

        Hi Mark299 

         

        The "fair transfer price agreement" is not something that I would be able to comment on.

         

        However, there was a question relating to closing off an invoice and purchase without the impact on the bank account. Generally in these situations, you want to use a contra/holding account and use the below process:

         

        1. Create a holding account if you don't already have one - Accounts>>Accounts Lists>>New - give the account a number, name and set the account type to be Bank.
        2. When ready to make payment, go to Sales>>Receive Payments>>Select the Deposit to Account to be that newly created account and then process the payment as per normal.
        3. Once that has been created, go to Purchases>>Pay Bills>>Select the Pay from Account to be that newly created account and then process the payment as per normal.

        What the above process will do is put the payment from the invoice into the holding account and uses those funds to pay off the purchases. As no "real" bank accounts are involved there is no impact on your bank accounts.