About purchase proportional costing

Learn how your purchase orders are factored into your material unit costs

Our Expenses feature is renaming to Purchases from 21 June 2023. More details

When you create a new purchase order, the total shipping and discount paid on the expense are automatically proportioned to each material purchased.

This allows all unit costs in Craftybase to represent the "fully landed" unit cost for your inventory valuation and thus COGS calculations. Learn more about material costs here →

As an example, say you have created a purchase containing 3 materials:

Material Quantity Total Cost
Blue Ribbon 1 spool $10
Red Ribbon 1 spool $14
Green Ribbon 1 spool $12

The supplier has charged you a shipping amount of $10 to send these materials to you.

When you save the purchase, Craftybase will calculate how much of the $10 shipping charge should be applied to each material. We do this by calculating the percentage of each cost relative to the total amount paid.

Taking a look at Blue Ribbon, we can see that $10 of $36 is ~27.77% of the total. Applying this percentage to the $10 results in ~$2.77, which we then include as part of the material's fully landed cost.

Material Quantity Total Cost Shipping* Landed Cost*
Blue Ribbon 1 spool $10 (27.77%) ~$2.77 ~$12.77
Red Ribbon 1 spool $14 (38.88%) ~$3.88 ~$17.88
Green Ribbon 1 spool $12 (33.33%) ~$3.33 ~$15.33
$36 $10 $46

* For this example, we are rounding all values to 2 decimal places for simplicity, however in reality, Craftybase will calculate this with much more accuracy (to 5 decimal places).

Once each material's landed cost is calculated, this is then added to your stock adjustments and your real time Actual Unit Cost of each material is recalculated to factor in the new amounts.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.