To account for freight on incoming inventory, I allocate the freight charges proportionately over the inventory items by total value. Quickbooks doesn’t have a way to handle that, so I use a simple Excel spreadsheet to do the calculation. The last entry is always the freight (or handling or whatever I want to distribute). [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2009/04/17/inventory-freight-calculation/
Posted
Apr 17 2009, 05:51 PM
by
Daily Dose of Excel