A / START FRESH
Blank workbook
Four connected tabs, editable input cells, and room for 100 distinct inventory items and 100 sale records.
Download blank workbookFREE RESELLER RESOURCE · DOWNLOADABLE
What’s still in stock,
and what did you earn?
Keep each item, its costs, and its eventual sale connected. Start with a blank workbook, or open the filled example to see how unsold stock stays separate from realized profit.
Choose your downloadTAKE THE FILE, KEEP YOUR OWN COPY
Choose a starting point.
Free downloads require newsletter email confirmation or an Upcyclist account. No paid trial is required. Nothing you enter is uploaded, saved for you, or carried into signup.
B / SEE THE METHOD
Filled example
A hypothetical small shop with sold and unsold pieces, a loss, and zero-acquisition items. Follow the IDs from inventory to sales.
Download example workbookBEFORE YOU OPEN IT
Read the field notes.
Headers, entry rules, and the workbook’s boundaries in a plain text file.
Download the read meResource version: single-unit-usd-v1
01 / THE INVENTORY REGISTER
A record for every distinct piece.
Give each item its own stable ID at intake. The inventory tab carries the acquisition record and later connects to a sale by that ID—not by a changing title or row position.
Read the inventory tracking guide| Item ID / description | Acquired | All-in cost | Qty | Status |
|---|---|---|---|---|
| INV-001 · Vintage "Travel", typewriter | 2026-09-01 | $20.00 | 1 | Sold |
| INV-002 · Paperback | 2026-09-02 | $2.00 | 1 | Sold |
| INV-003 · Wool sweater | 2026-09-03 | $6.00 | 1 | Sold |
| INV-004 · Wooden tennis racket | 2026-09-04 | $5.00 | 1 | Sold |
| INV-005 · Ceramic mug | 2026-09-05 | $12.00 | 1 | Unsold |
| INV-006 · Repairable desk lamp | 2026-09-06 | $18.00 | 1 | Sold |
| INV-007 · Gifted silk scarf | 2026-09-07 | $0.00 | 1 | Sold |
02 / THE SALES LEDGER
One completed sale, linked once.
Each sale has its own sale ID and references the matching inventory ID. Enter what the seller actually received and paid; do not treat buyer tax or pass-through label amounts as seller revenue.
See how reseller profit margin works| Sale / item ID | Sold | Item + shipping | Acquisition | Fees | Postage | Other | Profit | Margin / ROI |
|---|---|---|---|---|---|---|---|---|
| SALE-001 / INV-001 | 2026-09-10 | $85.00 + $0.00 | $20.00 | $17.00 | $14.50 | $3.50 | $30.00 | 35.29% / 150.00% |
| SALE-002 / INV-002 | 2026-09-11 | $16.00 + $0.00 | $2.00 | $3.20 | $4.00 | $0.60 | $6.20 | 38.75% / 310.00% |
| SALE-003 / INV-003 | 2026-09-12 | $38.00 + $0.00 | $6.00 | $7.60 | $0.00 | $1.00 | $23.40 | 61.58% / 390.00% |
| SALE-004 / INV-004 | 2026-09-13 | $22.00 + $0.00 | $5.00 | $4.40 | $9.00 | $2.00 | $1.60 | 7.27% / 32.00% |
| SALE-006 / INV-006 | 2026-09-14 | $12.00 + $4.00 | $18.00 | $2.50 | $8.00 | $2.00 | -$14.50 | -90.63% / -80.56% |
| SALE-007 / INV-007 | 2026-09-15 | $20.00 + $0.00 | $0.00 | $4.00 | $0.00 | $1.00 | $15.00 | 75.00% / Unavailable |
03 / A RECONCILED PICTURE
Sold is not the same as owned.
The Summary tab keeps realized results distinct from the acquisition cost still tied up in unsold inventory.
$197.00 seller revenue − $51.00 sold acquisition − $38.70 fees − $35.50 postage − $10.10 other costs = $61.70 realized profit.
Margin on seller revenue: 31.32%. Acquisition ROI on sold cost: 120.98%. Sold acquisition $51.00 + unsold cost $12.00 = $63.00 total acquisition. These are hypothetical records, not marketplace fee presets.
A
INVENTORY TAB
What to enter at intake
item_id- Stable item ID: start with a letter; letters, digits, hyphen or underscore; at most 64 characters. IDs compare case-insensitively.
description- Short description identifying this physical item.
acquisition_date- Date bought: YYYY-MM-DD text, a real date from 1900 through 9999.
acquisition_cost_usd- All-in cost for this one item, including purchase tax and acquisition transport allocated once. USD, enter explicit 0 if free.
quantity- Exactly 1. This template does not allocate lots or multiple units.
storage_location- Optional bin, shelf or other location.
sales_count- Workbook-calculated number of sales referencing this ID.
status- Workbook-calculated Unsold, Sold, Sale needs attention or Needs attention.
check- Workbook check: OK or an issue to fix. Blank prepared rows are ignored.
B
SALES TAB
What to enter after a sale
sale_id- Unique sale ID with the same format rules as item IDs.
item_id- Exact inventory item ID. Each item may be sold once in this workbook.
sale_date- YYYY-MM-DD text; real date, not before acquisition.
item_revenue_usd- Item receipts credited to the seller, excluding buyer sales tax.
shipping_receipts_usd- Shipping money actually credited to you. Enter 0 for buyer-label pass-through you never receive.
marketplace_fees_usd- Actual total marketplace fees; no preset or guessed rate.
actual_postage_usd- Actual seller-paid postage, including postage funded by shipping receipts. Do not deduct a buyer-label pass-through again.
other_direct_costs_usd- Other direct sale costs, such as packaging; exclude acquisition, fees or postage already recorded.
quantity- Exactly 1. Returns, repeat sales and multiple units are outside scope.
linked_acquisition_cost_usd- Workbook lookup of acquisition cost; do not enter it a second time.
seller_revenue_usd- Item revenue + shipping receipts. Buyer sales tax is never revenue.
realized_profit_usd- Seller revenue minus linked acquisition, fees, postage and other direct costs, each once.
margin_on_seller_revenue- Realized profit / seller revenue. Unavailable when revenue is 0.
acquisition_roi- Realized profit / acquisition cost. Unavailable when acquisition is 0.
check- Workbook check; computed financial fields are blank until this row and its reference are valid.
A REPEATABLE ROUTINE
From sourcing to a closed loop.
Keep the record simple enough to maintain. The workbook checks the links and arithmetic you provide; it does not decide what an item is worth.
- 01
Assign an ID at intake
Use a unique, stable item ID and capture its acquisition date, description, and full acquisition cost.
- 02
Track the item as one unit
One inventory row represents one identifiable unit. Do not combine quantities or use this workbook as a multi-unit lot ledger.
- 03
Record the completed sale
Add one sale record for the item and reference its inventory ID. Enter credited shipping revenue and direct sale costs based on the actual transaction.
- 04
Review checks before totals
Resolve flagged IDs, references, dates, quantities, and costs first. The summary withholds financial totals when input checks are not clear.
FORMAT & SUPPORT BOUNDARIES
Built for a tidy, small inventory.
Workbook structure
The XLSX has Read me, Inventory, Sales, and Summary tabs, with 100 prepared inventory rows and 100 prepared sales rows (rows 2–101). Enter records only in the prepared rows. Use a new workbook for more distinct items; do not extend formulas beyond the supplied range.
IDs and dates
IDs use letters, digits, hyphens, or underscores; they must start with a letter, be no longer than 64 characters, and be unique without regard to case. Dates are ISO date-only text from 1900 through 9999.
Money and completeness
USD costs are limited to $0–$1,000,000 with two decimal places. Enter every cost or explicitly enter zero: a blank is missing, never zero. Duplicate item or sale IDs, missing references, invalid dates, quantities, or costs are flagged; financial totals stay suppressed until corrected.
Revenue and profit
Seller revenue is item revenue plus shipping actually credited to the seller—not sales tax or buyer-label pass-through. Profit deducts acquisition, fees, postage, and other direct costs once. Margin is profit ÷ revenue; ROI is profit ÷ acquisition. A zero denominator is unavailable. Unsold acquisition remains separate from realized profit.
Editable cells and protection
Only input cells are intended for editing. No-password sheet protection guards formulas and cells outside the prepared range; it is an editing guard, not security. The workbook flags errors but cannot confirm the truth of a transaction or prevent cross-workbook duplicate IDs.
CSV is a snapshot
CSV files contain static values and documented headers only—no formulas, tabs, dropdowns, validation, or automatic updates. Blank CSVs contain headers only. If you edit calculated values in a filled CSV, you must recalculate them manually.
Not an import file
These downloads are not direct Upcyclist import files. The current importer uses different headers and ZIP/name-based relationships; this workbook’s stable IDs do not transform into those importer relationships.
Not included
No multi-unit inventory, FIFO accounting, returns, tax advice, live marketplace fees, synchronization, saving, or signup transfer. No ID deduplication runs across separate workbook copies.
WHEN YOU WANT THE RECORDS IN ONE PLACE
Move from a sheet to your shop.
Track purchases, completed sales, and profit in Upcyclist. This download does not upload or transfer into an account.
Start your 14-day trial
Free for up to 25 active items. 14 days of Pro included. No credit card required.
A FEW STRAIGHT ANSWERS
Before you start entering rows.
Do I need an account to download or use the files?
No. The workbook, CSVs, and read me download directly. Your entries stay in the copy you keep; this page does not collect them or transfer them at signup.
Can I leave a cost cell blank when the cost is zero?
No. Blank means incomplete, not zero. Enter an explicit zero for each cost that does not apply so the checks can distinguish a complete record from missing information.
How does shipping affect seller revenue?
Include only shipping actually credited to the seller. Do not count sales tax or buyer-paid label amounts passed through to a carrier as seller revenue. Deduct each fee, postage, or other cost once.
Can I add more rows or put several units on one line?
The prepared workbook supports up to 100 distinct inventory items and 100 sales, one identifiable unit per inventory record. Do not extend the rows or formulas; start another workbook for additional items. This is not a multi-unit or FIFO tracker.
Will a CSV keep the workbook’s formulas and checks?
No. CSV is a static-value format with documented headers only. It has no formulas, worksheets, dropdowns, validation, or automatic updates. Changes to calculated values in a filled CSV require manual recalculation.
Does the workbook import directly into Upcyclist?
No. The current importer expects different headers and ZIP/name-based relationships. This resource is a standalone worksheet and does not sync, save, or carry records into an account.
A planning resource, not a promise of profit. Check each transaction against your own records and the terms that apply to your sale.