How to track the true cost of a storage unit (or pallet, or estate lot)

You won the storage unit for $600. Add the $45 trailer rental and the $20 the facility charged to haul away what you left behind, and the buy cost you $665. You have unpacked four boxes, listed thirty things, and a leather jacket sold last night for $85.

What did that jacket cost you?

Every reseller who buys in bulk meets this question, and most quietly stop asking it. The total is easy: $665 left your bank account. The cost of one thing out of that pile is not, and it is the number every other number depends on.

Why the per-item cost matters at all

If the total is right, does the split matter? It does, in three places.

Deciding what to list. A cast-iron pan that cost you $2 is worth twenty minutes of photos and listing. One that cost you $18 out of the same unit, because it was most of what the unit was really worth, may not be. You cannot make that call without a per-item figure.

Knowing whether the buy was good. “I made money on that unit” usually means “the payouts so far are bigger than what I paid”. That is a cash statement, and it says nothing about the forty things still in the garage or the ones that will never sell.

Your profit for the year. The cost of a mixed lot does not all count in the year you paid it. Broadly, what you sold that year is counted as cost of goods, and what is still on the shelves is inventory you carry into next year. Buy a unit in November, sell half of it by New Year’s Eve, and how you split the price decides how much of it counts this year and how much next. (That is the general shape; how it applies to your business is a question for whoever does your taxes, and nothing here is tax advice.)

The usual ways of splitting it, and where each goes wrong

Divide by what you have found so far

$665 ÷ 30 items listed = $22.17 each. The jacket cost $22.17 and cleared a healthy margin.

Then you open the other boxes and find 170 more things. The real figure was nearer $3.33 each. Everything you sold in the meantime is carrying a cost almost seven times too high, and, worse, the number looked authoritative the whole time because it sat in a spreadsheet cell like every other number.

This is the most common method, and it fails in the most misleading direction: it shows losses on early sales that never happened, at exactly the moment you are judging whether the buy was worth it.

Wait until it is all counted

Honest, and expensive. A storage unit can take weeks to work through; an estate lot can take a season. Not listing anything until the last box is counted costs you weeks of selling on the buys where getting the good pieces out quickly matters most.

In practice nobody waits. They sell, mean to come back to the numbers, and end up using the first method by default.

Split it evenly once it is counted

$665 ÷ 200 = $3.33 each, applied once the unit is empty. The arithmetic is now correct, and it is still wrong for most units, because a storage unit is not 200 equal things. It is one good jacket, a box of tools, a set of dishes, and 150 things worth a dollar each. An even split gives the jacket and a single coffee mug the same cost. The jacket’s margin looks better than it was, the mug’s looks worse, and decisions about which kind of thing to buy more of are being made on numbers that blur the two together.

Split by what each thing is worth

This is the textbook answer. Accountants call a mixed lot a basket purchase, and the usual way to split a basket is by the relative value of what is in it: if the jacket is likely to bring $85 and the whole unit is likely to bring $1,700, the jacket gets 5% of the cost, or about $33.

It is the most defensible method and the hardest to keep up, because it needs a value estimate for every item before you can cost any of them. Most people who use it do it roughly: they price the handful of standout pieces by value and spread the rest evenly. That is a perfectly reasonable compromise, as long as the parts still add up to what you paid.

To try it on a lot of your own, the free pallet and mixed-lot cost splitter spreads what you paid, the buyer’s premium and the trip home over each item by its resale value, to the cent.

Treat everything as free until the buy has paid for itself

Some resellers count every sale as recovering cost until the payouts pass $665, and everything after that as profit. It answers “has this unit paid off yet?”, which is a real question. As a cost per item it is no use at all: the first things sold show zero profit and the last things sold show nothing but profit, so per-item margins tell you only which order you happened to sell in. It also does not match how inventory is counted at year end.

Write the whole thing off the day you buy it

Tempting, because it makes the bookkeeping disappear. It also treats the unsold half of the unit as if it were gone when it is sitting in your garage, which is not how the year-end inventory figure works, and it leaves every item you sell with a cost of zero, so your margins show nothing useful.

The costs people forget

Whichever split you use, the amount you are splitting is usually larger than the winning bid:

• The buyer’s premium on an auction, often 10–20% on top of the hammer price.
• Getting it home: the trailer or truck rental, fuel for a long haul, a helper you paid.
• Clearing it out: the dumpster, the haul-away fee, the cleaning deposit you did not get back.
• Freight on a pallet, and any liquidation platform fees.

These belong in the cost of the goods, spread across the pieces you kept. Leaving them out makes every item look cheaper than it was.

And the junk. Most units contain things that go straight in the dumpster. You have two honest options. You can leave the junk out entirely, so its share of the price lands on the things you kept, which is fair because you had to buy the junk to get the good stuff. Or you can record it and write it off, so the loss is visible. What is not honest is recording it, giving it a share of the cost, and then forgetting it, because then that share of what you paid vanishes from your figures.

What a sound method has to do

Put those failures together and the requirements more or less write themselves:

1. Start from what you paid, including the premium, the transport and the haul-away, and never lose track of that total.
2. Let you sell before the count is finished, without inventing a figure for the things you sold early.
3. Say “not known yet” when the cost is not known yet, instead of filling the gap with a number that looks just as solid as the real one.
4. Let you value the standout pieces yourself and spread the rest.
5. Make the parts add back up to the total. If they do not, something has been counted twice or not at all.
6. Rewrite the earlier sales’ costs once the real figure exists. The jacket you sold in week one should end up with the same kind of cost as the lamp you sold in week four.
7. Let you correct it later. The haul-away invoice turns up a month after you closed the books on the unit. Adding it should fix every affected figure, not just the next one.

A spreadsheet can do some of this with discipline. Items 2, 3 and 6 are where it gives out, because a cell holds a number and has no way of saying “this will change when the unit is done”.

How Intakes does it

Intakes was built around this buy. A purchase in Intakes is an intake, and a mixed lot is one intake, entered at what you paid:

• One intake for the whole unit, open while you work through it. Enter the $665 you paid, with the trailer and the haul-away recorded as fees on it, so $600 is left for the goods. You do not need to have counted anything to open it.
• Add things as you unpack them. Thirty items this week, a hundred and seventy over the next three. They all go onto the same intake, so the whole unit stays one purchase and one payment to match against your bank.
• Sell straight away, without a made-up cost. Anything you have added can be shelved and sold the same day. Until the intake closes, its cost is marked provisional rather than guessed, and the profit you see is a ceiling that can only come down, never a $22.17 that turns out to be $3.33.
• Value the standouts yourself, then spread the rest. Type a cost on the jacket and the tool set. Spread Cost then splits whatever is left of the $600 across only the items that have no cost yet, either evenly per item or by quantity, so a box of 40 identical paperbacks takes 40 shares and not one.
• The fees follow the goods. The trailer and the haul-away are spread across everything in proportion to its cost, so the jacket carries more of the trailer than a coffee mug does.
• It will not close until it adds up. Closing an intake is refused, with the gap named, while the items and fees do not add up to what you paid.
• Close it when the last box is empty. Every item gets its final cost, including the ones you already sold, and the profit on those sales updates to the real figure in the month they happened.
• Correct it whenever the paperwork turns up. Reopen the intake, add the forgotten fee, close it again, and every affected cost is recalculated, sold items included.
• Junk you write off keeps its cost, so the loss is valued rather than vanishing.

Intakes does not guess what each piece will sell for. That judgement is yours, and you make it on the pieces where it matters. What Intakes does is keep the arithmetic honest around it: one total, every piece accounted for, and nothing shown as known before it is.

If you want the step-by-step version, the mixed-lot costing concept page walks through it with the screens. Intakes has a free trial with no card up front, and the pricing page shows what it costs after that.