Keep one row per item and calculate the outcome only when the item sells. This free template has 100 prepared rows with formulas and a status dropdown. It works without an email address or a FlipFinds account.
Download the free Excel inventory template
Fill in a record
- Enter a stable item ID, recognizable title and Unlisted, Listed or Sold status.
- Record purchase cost, shipping paid, supplies and other costs.
- For a completed sale, enter actual sale price, shipping collected from the buyer and seller fees. Enter explicit zeros when a charge does not apply. Leave an unknown amount blank.
- Review calculated revenue, cash invested, actual profit and ROI in the green columns.
Only Sold rows with all seven numeric cost/revenue fields completed show actual profit. An asking price on an unsold item does not become realized revenue. Zero cash investment leaves ROI blank; losses remain negative. Seller fees are deducted from proceeds rather than included in the investment denominator, matching the public calculator methodology.
Check the first sale
For a hypothetical $40 sale, $10 purchase cost, $5 shipping, $0.75 supplies, no other cost, no shipping collected and $4 seller fees, the template shows $20.25 profit and about 128.6% ROI. Enter actual expenses for your own transaction; no marketplace rate is built into this template.
Keep the workbook useful
Use one currency consistently. Keep identifiers unique, and sort complete rows so inputs stay with their results. To add more than 100 items, copy a complete prepared row, including formulas, before entering the next item. Preserve your own backup.
Your entries remain in the downloaded workbook. FlipFinds does not receive them or automatically import this file. If you want item tracking in the app, start with one item and enter its details manually.