Home / Templates / Inventory Source of Truth Worksheet
Free worksheet

Inventory Source of Truth Worksheet

A one-line-per-SKU worksheet that holds the facts every listing derives from: identity, cost basis, base price and floor, per-platform list prices, listing status on each platform, and the last relist date.

Download the worksheet (.csv)

Reviewed for 2026, updated September 8, 2026.

The mental shift that fixes most sync problems is to stop managing listings and start managing inventory. A listing is a projection of an inventory record onto one platform; the record is the truth. This worksheet is the simplest version of that record: one row per SKU, with the cost basis, the base price you actually want to net, the floor you will not go below, the list price on each platform, and where the item is live, sold, or ended. When a sale, a markdown, or a relist happens, you change the row first and then make every platform match it, never the other way around. The example rows show one item in each common state so you can see what a complete row looks like before you fill in your own.

Keep it as a spreadsheet, a paper sheet, or the inventory table inside your sync tool; the columns are what matter, not the medium. The guide on this site and the article on inventory as a single source of truth explain the reasoning in full, and the article on pricing across marketplaces covers how to choose the per-platform adjustment. If you are not sure how far apart two platforms' list prices should sit to net the same amount after fees, the Marketplace Fee Parity Price Calculator in our Tools section does that arithmetic for you before you write the prices into the row.

SKUItem, condition, bin locationCost basisBase price and floorList price on Platform A / B / CStatus on Platform A / B / CLast relist and notes
2609-001Wool overcoat, size L, excellent, bin A3Your cost including any cleaningYour base price; floor at cost plus shipping and feesA: base; B: base plus your fee adjustment; C: baseA live, B live, C liveListed 2026-09-08; review if no views after your stale threshold
2609-002Running shoes, size 10, worn twice, bin A3Your costYour base price; your floorA: base; B: base plus adjustment; C: not listedA live, B live, C not listedListed 2026-09-08; category tends to move faster on A for you
2609-003Film camera, tested, includes strap, bin B1Your costYour base price; your floorA: base; B: base; C: base plus adjustmentA sold 2026-09-07, B ended, C endedQuantity 0; ship within your handling time; sale price logged
2609-004Board game, complete, box wear, bin B2Your costYour base price; your floorA: base; B: base; C: baseA live, B live, C liveRelisted 2026-09-01 on all three; next relist due per your schedule
2608-017Denim jacket, size M, small repair noted, bin C1Your costMarked down 2026-09-05 to your new base; floor unchangedA: new base; B: new base plus adjustment; C: new baseA live, B live, C liveMarkdown applied on the record first, then confirmed on every platform
2608-022Ceramic vase, no chips, bin C2Your costYour base price; your floorA: base; B: base plus adjustment; C: baseA live, B ended by you, C liveEnded on B after repeated lowball offers; note the reason so you do not relist there by habit
2607-009Textbook, current edition, light highlighting, bin D1Your costYour base price; floor at costA: base; B: not listed; C: baseA live, B not listed, C livePast your days-in-inventory threshold; in this week's relist batch
2607-011Headphones, tested, original case, bin D1Your costYour base price; your floorA: base; B: base plus adjustment; C: baseA ended, B sold 2026-09-08, C endedDouble-sale check done: only one order exists; quantity 0; ship today
Your next SKUItem, condition, bin locationYour costYour base price; your floorYour list price per platformLive, sold, ended, or not listed, per platformYour date and notes

Also from RelistSync