Distribute shipping and other cost into inventory or PO
Ability to take shipping and any other cost associated with a purchase and be able to have it evenly divided among the inventory or PO.
- Under the inventory tab, have a way to add a misc. cost and push it through to all selected inventory. Which could be the entire inventory or maybe just a category. Better if we are allowed to select what to distribute the cost into.
- under the PO tab, when doing the check in where there is the tab to accept all items into inventory, it would be nice to have the option to say accept and distribute all cost into those items. At that point the system would take over and distribute the new cost with the each existing item respectively, like it currently does.
Shipping cost entered in to the PO will get distributed across the PO line items. Those costs are then baked in to the product costs.
Scott Peeler commented
I have been wanting this ever since we started using RepairShopr 2 years ago! Our old POS system would allow you to input shipping amounts to all items on a PO similar to what Troy stated.
1) You could input the total amount of shipping for the entire PO and the software calculated each item amount for you.
2) You could manually enter the shipping amount on each line item of the PO individually.
Having both options was handy, because sometimes everything costs the same. Other times some heavier individual items had higher shipping costs, so we would input them separate. Example: A PO might have a bunch of small cables that way very little and a server rack that ways a lot. You don't want to divide the shipping equally, because that doesn't make sense.
The reports would show COGS with shipping included for the items, plus we could see just shipping costs as well. When you would lookup an item it would show "Cost" and "Landed Cost" separately, which was always very helpful.
Any progress on this? We are having a hard time utilizing the reports if they require us to also manually calculate shipping costs for items. Preferably option A
@Troy thanks for the feedback. I am revisiting this issue.
Having it go to quickbooks doesn't reflect my average cost and all my daily sales reports. Having to do this manually is not ideal and could be an optional feature for those who do not require it.
This absolutely needs to be done. When looking at our margins, it does not take into consideration our freight and any duties and taxes (if purchasing from overseas). The only way around this is to have my team do a calculation to distribute these charges evenly over the entire PO. When considering multiple locations, multiple team members, this is something that RS should have the option for. Reports are not very effective if they aren't accurate. 10,000 Votes here!! :)
Josh Allman commented
Option for both honestly, at minimum, a line item.
+1 for option B although we would call it Freight. Shipping is something you charge a customer for when mailing them something. Freight is what you pay your vendor to ship you an item. It would be great if we could add a Freight non-inventoried item and have that map to the Freight COGS account in our accounting software (we use QB Online). This will allow us to more easily report our overall Freight cost for the year.
For me I usually distribute the cost of shipping evenly across all line items. Order 10 items at $1.00, Shipping is $10.00. True cost of items is $2.00 with shipping included.
Spencer Pous commented
+1 for MSP feature
Any update on this??
I see this is planned and just wanted to chime in. YES, needs to be done. I see that currently shipping is not even associated with any quickbooks items. I usually distribute my costs as well across all items purchased.