Profit & pricing
Know what a sale earns before you list it.
Illustrative preview. Download files contain calculator examples and blank trackers.
UK checkout total, including 20% VAT. Applicable taxes for other locations are shown at checkout.
Excel .xlsxGoogle SheetsLight / dark stylingNo paid desktop Excel is needed. Open the .xlsx files in free Excel for the web with a Microsoft account and internet access. The standalone 500-row Profit & Sales workbook was tested by the owner in Excel for the web. Other workbook versions have not been tested there, and some features may differ.
- Item profit, ROI and margin after your entered costs and fees.
- Break-even and target selling prices.
- 500-row sales log with review flags.
Two overlapping calculators are supplied together: profit/sales and a focused pricing view. Fees are entered manually. Results are before tax. Inventory, cash flow and tax are not included.
Etsy shows its current price and any applicable tax before payment.
GBP price. Any applicable checkout tax is shown before payment. One-off digital download.
See the calculator in use.
Compare a £50 sale with a £60 sale and see how the profit and margin change.
18-second edited sequence of real Windows Excel captures, with captions and no audio. Example figures; results are before tax.
Working out your costs?
See a £15 sale worked through step by step, including £3.25 postage and example selling fees.
Read the resale profit guideGetting started
Download and extract the ZIP, keep an untouched backup, and read START_HERE and the workbook’s Read me sheet. For Excel for the web, sign in to Microsoft with a free account and open the .xlsx file in OneDrive. For Google Sheets, open the included access guide (TXT or HTML), follow the links for your purchased templates and choose File > Make a copy. A Microsoft or Google account is needed to save an editable copy. Edit amber inputs and correct Review flags before relying on the totals.
The Profit & Sales workbook includes 500 sales rows. The separate pricing calculator uses its own input layout. Standalone files do not synchronise. No automatic bank or marketplace feeds, VAT returns or submission software are included. Commercial results are before tax.
Checked with calculation and workbook-structure tests, plus representative tasks in Windows desktop Excel. Native Google Sheets versions were checked in the browser. The 500-row Profit & Sales workbook was tested by the owner in Excel for the web on another PC. Other workbook versions, Excel for Mac, mobile apps and offline Google Sheets use have not been tested. Some features can differ between spreadsheet apps.
Read purchase, permitted-use, support and privacy information