Free business template (Excel (.xlsx) with formulas)
Cost and margin calculation sheet
Find the true cost of each product and the margin you really make.
Template structure and example
Excel (.xlsx) with formulas| Product | Purchase price ($) | Rate | Purchase (₾) | Shipping (₾) | Packaging (₾) | Ad cost per sale (₾) | Total cost (₾) | Selling price (₾) | Margin (%) | Net profit (₾) |
|---|---|---|---|---|---|---|---|---|---|---|
| Black T-shirt | 6 | 2.7 | 16.2 | 2 | 1 | 5 | 24.2 | 45 | 46% | 20.8 |
| White sneakers | 25 | 2.7 | 67.5 | 6 | 2 | 12 | 87.5 | 160 | 45% | 72.5 |
Why move from Excel to a CRM?
Once you know the cost, store it on the product in Gayidvebi.ge. Every order then shows its profit, and analytics subtract delivery, bank fees, ad spend and the tax estimate for the period.
Frequently asked questions
Should ad spend be part of the cost?
For pricing decisions, yes. In Gayidvebi.ge ad spend is entered per period and subtracted from net profit.
Move this template into Gayidvebi in minutes
Upload your Excel file and your orders, products and stock go into the system automatically.
Get started now