Forum Discussion

rquad3's avatar
rquad3
Contributing User
2 years ago

Inventory and reimbursement in invoice

We have started to inventory items.  I allocate a job number to the puchased item in purchases (clicked I buy, I sell, I inventory).  The purchase does not appear in job if I look up reimbuseable exp...
  • gavin12345's avatar
    gavin12345
    2 years ago

    Hi rquad3 

     

    Re sample files, the link you provided has a link to download samples.zip.

     

    Re searching - yes MYOB's website searching is sub par - I use google or bing to search and add 'MYOB forum' to the search request, it has a better search engine.

     

    Re items with C or T or I - this is a suitable work around. Can't see any problem provided linked accounts are set correctly. Some purchases will be expensed directly to the COG account and will not go to the inventory account - this should sort the Job Costing issue. This approach assumes you know when you purchase, which items and quantities will go to each job. 

     

    Re General Journal,  yes correct in concept. However this can distort your Inventory Valuation Report reconciliation and runs the risk of forgetting to reverse the GJ. I would recommend creating and using 2 temp accounts such as 1-xxxx Inv Temp For Jobs and 5-xxxx COG Temp for Jobs or similar. This way you can readily see that there are transactions that need to be reversed, and the balance of the Inventory account will not be affected. Discuss best option with your accountant.

     

    Regards

    Gavin

rquad3's avatar
rquad3
Contributing User

Thanks Gavin

Frustratingly, I dont' have access to the sample files (clearwater files) as apparently we dont get these with AccountRight 2021.1 or later.  Using the sample company file (Clearwater) - MYOB AccountRight - MYOB Help Centre FAQ's.

I've searched the forum again but haven't come up with anything relevant to creating interim journal entries or any other work around.  I mustn't be using the right combination of words in my search. 

 

My other solution was to create two item numbers that are essentially the same for the same item with an (I) at the end of one to show it is an inventoried item, but use the non inventory item number to allocate purchased goods intended for a job within the same PO.  So technically the item number without the (I) never hits inventory (which is fine.) The other half doesn't think this is a ligitimate way of doing it, though can't give a reason why other than that items/numbers are doubled up in the system.  I can't see a problem with this so long as we know what the item codes mean.  I currently use this practice as we purchase items for COGS and we also purchase the same items for Consumables or Tooling at times.  The separate item numbers with a (C) (T) means the correct account is being adjusted by the PO entry.  Can you see an issue with doubling up items so cost allocation is made to the correct expense accounts in the system?

 

If I were to create Journal entries I presume this is done online in 'create general jounal transaction.'  And the entry would essentially be DR COGS (allocated to a job number) , CR Inventory is that correct?

I am hopeful our next accountant will have the capacity to advise with such issues...we are in a transition phase.

 

Thanks for any further feedback you can provide.  I truely appreciate the time taken to help me understand. I've spent hours on the MYOB help line with no resolution or explanation from multiple people.  This forum is amazing.

gavin12345's avatar
gavin12345
Ultimate User
2 years ago

Hi rquad3 

 

Re sample files, the link you provided has a link to download samples.zip.

 

Re searching - yes MYOB's website searching is sub par - I use google or bing to search and add 'MYOB forum' to the search request, it has a better search engine.

 

Re items with C or T or I - this is a suitable work around. Can't see any problem provided linked accounts are set correctly. Some purchases will be expensed directly to the COG account and will not go to the inventory account - this should sort the Job Costing issue. This approach assumes you know when you purchase, which items and quantities will go to each job. 

 

Re General Journal,  yes correct in concept. However this can distort your Inventory Valuation Report reconciliation and runs the risk of forgetting to reverse the GJ. I would recommend creating and using 2 temp accounts such as 1-xxxx Inv Temp For Jobs and 5-xxxx COG Temp for Jobs or similar. This way you can readily see that there are transactions that need to be reversed, and the balance of the Inventory account will not be affected. Discuss best option with your accountant.

 

Regards

Gavin

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.