How it works in Flippedit
A bulk purchase is one record for the whole haul. You link items to it as you list them, choose how the lot cost is split, and read cost, revenue, profit and ROI for the buy as a unit.
Here is how a haul reads as it sells down. The figures are illustrative. Week one: a $100 box of 40 items, split by auto weight, so the $30 camera carries more of the cost than the $4 DVDs. Week two: 6 items sold for $85, and after fees and their share of cost the haul shows a profit of minus $15. That is normal, and the spreadsheet version usually stops here.
Week six: 22 sold for $310 in revenue. Fees, postage and $55 of linked cost come off, and the haul shows $210 of profit, 210% ROI on the $100. Eighteen items are still listed and still carry $45 of cost between them, so the number keeps moving as they sell. You can see the day the box paid for itself, and you can sort every haul by ROI to see which sources to go back to.
The tail is where hauls quietly lose money. Ten items that never sell still hold $25 of cost. Flag them as stale, hand them to auto relist for one more run, or write them off. A write-off books the $25 as a loss and closes the haul at $185 profit, which is still a good box, and now you know that instead of guessing.
Log the haul once
Record the description, date, total cost and item count. If you paid in parts, add each payment to the same purchase.
Link items over time
Link items from unlisted inventory, active listings, sold items or write-offs. The purchase stays open, so listings posted weeks later still take their share.
Auto weight or flat average
Auto weight uses each item's listed or sold price to give pricier items more of the cost. Flat average gives every unlocked item the same. Switch at any time and the split re-runs.
Lock a known cost
If you know what one piece was really worth, lock its COGS. The remaining cost re-splits across the unlocked items.
Per-haul numbers
Total cost, linked items, average cost, listed value, revenue so far, profit and ROI on the haul page, with tabs for each item's status.
Sort sources by ROI
The bulk purchases list sorts by ROI, profit, sold count or average cost, so you can see which suppliers and sales are worth going back to.
Feeds the sale and the P&L
Each item's share becomes its COGS on the sale. Unsold bulk cost shows on the P&L as inventory, informational and outside the profit totals.