Carrying Cost of Inventory

Hi,

Sorry if this question has been asked before. If it has been, kindly link me to the appropriate thread.

Onto my question:

I have been using Simply Accounting Premium 2013 for 2 years now. I was never able to figure out why the program doesn't show me the actual carrying cost of inventory.

For example i buy something from abroad. I pay the duty on it. There are the freight charges (not paid by shipper. it is paid by us and it is invoiced to us separately) from the port to our warehouse. There is also the matter of brokerage fees. Basically there are a number of direct charges including duties, fees, freight costs etc involved in getting a particular shipment of items from the seller to the buyer.

Now i finally realized that that simply accounting has a feature called track import duty. Rest assured i have followed all the steps and it is calculating import duty properly and it is now including the duty in the item cost.

BUT what about the other direct charges i incurred to get this shipment to my warehouse. How do i make the program tack these costs onto the inventory?

I have to use Excel to calculate/factor in all these costs to create a spreadsheet which basically shows the true cost of the shipment/items.

My question is as following:

Is there any way to make the program tack the expenses besides the duty onto the inventory? So that the cost per unit reflects all the cost associated with getting that item to our warehouse.

Thank you in advance.

Parents
  • 0

    mmr said:
    Is there any way to make the program tack the expenses besides the duty onto the inventory?

    Automatically?  No.

    You can manually add the freight cost using inventory 'Adjustments' or by using 'Build from Item Assembly'

     - It is possible to over-ride the G/L account to your freight expense account, when using 'Adjustments', while

     - 'Build from Item Assembly' uses the linked account set up under Setup | Settings | Inventory | Linked Accounts as 'Item Assembly Costs'.  

    If you don't use Item Assembly for anything else, you could set up another 'Freight included in inventory account' and change the default account.

    Whether all that effort is worth it, depends on how much of your COGS is freight-in.

    *******************************************************************************************************

    If you never use Purchase Orders, and aren't worried about messing up the 'Last Purchase Price' in your system, you can also record the total landed cost of items, with freight as a negative amount.  

    i.e. you purchase an item for $1000, and you separately pay your freight vendor $200, so you would record the invoice purchase price as $1,200, and record freight of -$200, then fix the rounding differences on the tax.  

    If you were using Sage 50 Quantum, this landed cost by vendor will also make the Item Price Comparison report more useful.

Reply
  • 0

    mmr said:
    Is there any way to make the program tack the expenses besides the duty onto the inventory?

    Automatically?  No.

    You can manually add the freight cost using inventory 'Adjustments' or by using 'Build from Item Assembly'

     - It is possible to over-ride the G/L account to your freight expense account, when using 'Adjustments', while

     - 'Build from Item Assembly' uses the linked account set up under Setup | Settings | Inventory | Linked Accounts as 'Item Assembly Costs'.  

    If you don't use Item Assembly for anything else, you could set up another 'Freight included in inventory account' and change the default account.

    Whether all that effort is worth it, depends on how much of your COGS is freight-in.

    *******************************************************************************************************

    If you never use Purchase Orders, and aren't worried about messing up the 'Last Purchase Price' in your system, you can also record the total landed cost of items, with freight as a negative amount.  

    i.e. you purchase an item for $1000, and you separately pay your freight vendor $200, so you would record the invoice purchase price as $1,200, and record freight of -$200, then fix the rounding differences on the tax.  

    If you were using Sage 50 Quantum, this landed cost by vendor will also make the Item Price Comparison report more useful.

Children
No Data