Forum Discussion

BenAus's avatar
11 days ago

Profit and Loss Report

Please help. The Cost of Sales is incorrect in my Profit and Loss Report. When I go in to see what makes up my Cost of Sales / Purchases, it is importing Customer Invoices instead of Supplier Bills.  Last Financial year it was correctly importing Supplier Bills but not this year. When I go in and run my Purchases by Supplier, the amount is completely different to the Cost of Sales field and I am unable to work out where in the P&L my Purchases by Supplier is showing.

 

Some background....

We started live with MYOB this financial year, and the company that did the import, imported our inventory incorrectly - it was not imported as 'inventory tracked', so I was advised that we had to make all our items inactive, then re put them in. We have done this and setup the following accounts per item.

Now when we run the P&L for this year, my supplier purchases are not showing at all and the report is pulling in Customer Invoicing instead of Supplier Bills. To me, and to our accountant, it seems there is a coding error but I have been on the phone to MYOB multiple times for multiple hours and I still don't have an answer. Does anyone know what the issue could be?

 

As you can see - last year's Cost of Sales Transactions in the P&L shows this...

This September, the Cost of Sales Transactions in the P&L shows this...

Any help would be greatly appreciated, I really don't know how to move forward from here.

 

Thanks in advance.

  • Hi BenAus 

     

    If set up correctly, when using 'I Inventory', what gets posted to the Cost of Sales account is from Sales. When you purchase, the full cost gets posted to the Inventory Asset account. Then when you sell the items, the cost of the sold items is moved from the Inventory Asset account to the Cost of Sales account. 

     

    If you do not use 'I Inventory' then your purchases get posted to the specified Expense account (some use Cost of Sales).

     

    So I would suggest your prior year P&L was where Items were NOT set to 'I Inventory'.

     

    If you can't get good assistance from MYOB, try someone like MYOX Services. Might be a small fee but may save you hours stuffing around. Esp if during the migration there were other things 'missed'. Get some experienced eyes to look over the file, particularly if you think the Cost of Sales figures are wrong.

     

    Regards

    Gavin