Track what you bought, what it cost, where it is listed and what you made on it, in one sheet that opens in Google Sheets or Excel. It splits a storage unit or a pallet over what came out of it, estimates marketplace fees, and adds up your profit by month and by channel. Where it has to guess, it says so.
One file, five tabs, example rows to show how it works. No email, no sign-up.
Version 1, November 2026. Fee rates read from eBay’s and Etsy’s own fee pages in October 2026. Also opens in Apple Numbers and LibreOffice.
| Item | Lot | Cost each | Cost status | Sold for | Fees | Profit |
|---|---|---|---|---|---|---|
| Leather jacket | L-001 | $64.93 | Provisional | $115.00 | $17.74 | $32.13 |
| Pyrex bowls, set of 4 | L-001 | $32.47 | Provisional | $55.00 | $6.53 | $12.90 |
| Mid-century table lamp | L-001 | $45.99 | Provisional | |||
| Levi’s 501 jeans | $6.99 | Final | $42.00 | $7.20 | $27.36 |
Lot L-001 is a $197.50 storage unit still being unpacked, so its items’ costs are provisional. The Pyrex fee was typed from the order; the other two are estimated.
Every item is a row on Inventory. White cells are yours to type in; gray cells are worked out from them. A row’s status follows from what you filled in: it is Listed once it has a channel and Sold once it has a sale price, and its profit is what the buyer paid, item and shipping, less the fees, postage, packaging and what the item cost you.
An item bought on its own costs what you paid for it. An item from a lot carries a share of that lot’s whole cost, from the Purchases tab: price, buyer’s premium and tax, and getting it home. The share is in proportion to what the item should sell for, the method the lot cost splitter uses, and the sheet keeps the shares unrounded so a lot’s items always add back up to exactly what it cost.
A lot you are still unpacking. The cost is spread over the items entered so far, so each new item lowers the cost, and raises the profit, of every item already in the lot, including ones you sold last month. The sheet marks those costs Provisional and counts the sales that rest on them, but it cannot stop the past changing under you. Intakes keeps the purchase open, shows what has sold meanwhile as not priced yet rather than guessing, and spreads the cost once, over everything, when you close it. That is mixed-lot costing.
Marketplace fees. Without the real figure, the sheet charges a flat rate from the Channels tab. Real fees depend on the category, promoted listings, Offsite Ads, labels bought on the marketplace and refunds. Type them from the order and the amber goes; for one sale at a time, the eBay and Etsy fee calculators work them out. Intakes brings eBay and Etsy orders in on their own, with every fee the marketplace charged, by name.
Everything that comes after. Sell three of a row of six and the row has to be split by hand; a receipt found in March means finding every row it should have touched; your year-end count is whatever you typed. Intakes keeps stock by quantity, recalculates what a correction touches, and values your inventory on any date. The longer version is Intakes vs a reseller spreadsheet, including when the spreadsheet is the better choice.
The Inventory columns are named the way Intakes’ import reads them. Make a copy of that tab, delete the rows that have sold (the import brings in stock you hold), and download the copy as a CSV (Google Sheets: File → Download → Comma-separated values; Excel: File → Save a copy, CSV). Import it, and each row becomes an item and a line on a draft purchase at the cost the sheet worked out; nothing is created until you have checked it.
Intakes keeps a lot open while you unpack it and prices everything once at the end, brings eBay and Etsy orders in with the fees they really charged, and imports this sheet to start.
60 days free · No card required · Every feature included
Questions first? Write to support@intakes.app.