A reseller inventory log book is a simple record-keeping tool that tracks every item you buy, hold, and sell so you always know what you have on hand, what you paid, and what you sold it for. At its core, it is a running list of stock movements with enough detail to answer three questions: what do I own, what did it cost, and where is it now.
Resellers—people who flip items on marketplaces, at flea markets, or through online stores—often start with memory and sticky notes. That works for the first ten items, then fails. A log book (paper or digital) prevents overselling, forgotten purchase prices, and tax-season panic. This article explains what a reseller inventory log book should contain, how to set one up, common mistakes, and whether you need software or a paper notebook.
Why a Reseller Needs an Inventory Log
Unlike a retail store with a point-of-sale system, most individual resellers buy items one at a time from thrift stores, estate sales, garage sales, or wholesale lots. The purchase price varies wildly, and the selling price depends on condition, demand, and timing. Without a log, you cannot calculate profit per item, total profit, or even know which items have been listed for months and need price drops.
A log book also protects you in disputes. If a buyer claims an item was never shipped, your log shows the sale date, tracking number, and platform. If a tax authority asks about income, your log shows your cost basis and sale price. If you sell on multiple platforms, the log is your single source of truth.
What to Record in Each Entry
A useful log entry captures the item’s life cycle from purchase to sale. Here are the fields that matter most:
- Date purchased – when you paid for the item
- Item description – brand, model, size, color, condition (e.g., “Levi’s 501 jeans, men’s 32×34, new with tags”)
- Purchase price – what you actually paid, including tax if any
- Source – thrift store, estate sale, auction, wholesale supplier
- Cost of goods sold (COGS) – purchase price plus any direct costs like cleaning supplies, parts, or shipping you paid to receive it
- Listing date – when you put it up for sale
- Sale date – when it sold
- Selling price – what the buyer paid before fees
- Fees – platform fees, payment processing, shipping cost you paid
- Net profit – selling price minus fees minus COGS
- Status – in stock, listed, sold, returned, damaged, donated
- Location – if you store items in multiple bins or shelves, note where it is
If you sell on a platform that provides order reports, you can copy the relevant numbers into your log. If you sell locally for cash, write the details down at the moment of sale—memory fades fast.
Paper vs. Digital Log Books
Both methods work; the right one depends on your volume and comfort with technology.
Paper log books are cheap, require no batteries, and are easy to use at a garage sale or estate sale where you are buying on the spot. A simple columnar pad or a pre-printed inventory notebook works. The downside is manual math and no automatic search or sorting. If you sell more than 20 items a month, paper becomes tedious.
Digital log books (spreadsheets or dedicated inventory apps) allow you to sort by status, calculate totals automatically, and back up your data. A spreadsheet is free and flexible—you can add columns as needed. Dedicated reseller inventory apps often include barcode scanning, listing integration, and profit reports. The learning curve is real, but for high-volume resellers, the time saved is worth it.
Many resellers start with paper, then move to a spreadsheet once they have 50+ items. That is a natural progression.
How to Set Up a Simple Log Book
You do not need a complex system. Follow these steps to create a functional log in under an hour:
- Choose your format: a notebook, a spreadsheet, or an app.
- Decide on your columns. At minimum, use the fields listed above. You can always add more later.
- Create a row for each item the moment you buy it. Fill in the purchase date, description, source, and cost.
- When you list the item, add the listing date and the platform.
- When it sells, fill in the sale date, price, fees, and net profit.
- If an item is returned, mark the status as “returned” and note the return reason and any restocking fee.
- Review your log weekly. Look for items that have been listed for 30+ days—those are candidates for price drops or relisting.
That is the entire workflow. The hard part is consistency, not complexity.
Common Mistakes Resellers Make
Even with a log, resellers often stumble on a few recurring issues:
- Forgetting to record purchase price at the time of purchase – you will not remember it accurately later.
- Not including all fees – shipping, packaging, platform fees, and payment processing fees eat into profit. If you ignore them, your profit numbers are wrong.
- Mixing personal items with inventory – if you sell your own used items alongside your flips, separate them or you will distort your profit calculations.
- Not tracking returns – a return can turn a profitable sale into a loss. Log it.
- Using vague descriptions – “blue dress” is useless when you have three blue dresses. Be specific.
- Never reviewing the log – a log only helps if you look at it. Set a weekly review time.
Another common misconception is that you must track every single item individually. That is true for unique items like vintage clothing or collectibles. But if you buy identical items in bulk (e.g., 50 identical phone cases), you can log them as a single lot with a quantity field. Just remember to reduce the quantity when you sell one.
Tax and Profit Considerations
Your inventory log is the backbone of your tax records. It shows your cost of goods sold, which directly reduces your taxable income. Without it, you might overpay taxes or fail to report income accurately.
For tax purposes, you need to know your total sales, total COGS, and total expenses (fees, shipping, supplies). Your log should be able to produce those numbers with a quick sort or sum. If you are unsure how to treat inventory for taxes, ask a qualified accountant or tax professional—this is not something to guess.
Also note that if you sell on platforms like eBay or Etsy, they may issue a 1099-K form if your sales exceed a certain threshold. Your log should match that form. Discrepancies can trigger questions.
Template
Reseller Inventory Log
| Date Purchased | Item Description | Source | Purchase Price | COGS | Date Listed | Date Sold | Selling Price | Fees | Net Profit | Status | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|
Sample row (fictional): 2025-03-14 | Vintage Canon AE-1 camera, tested, works | Estate sale | $45.00 | $45.00 | 2025-03-15 | 2025-03-22 | $120.00 | $18.50 | $56.50 | Sold | Shelf A
Frequently Asked Questions
Do I need a separate log for each selling platform?
No. One log that includes a column for the platform is enough. You can filter or sort by platform later if you need to see which one performs best.
Can I use a simple spreadsheet instead of a printed book?
Yes. A spreadsheet is often better because it does math for you. Just set up the columns and use formulas for net profit.
What if I buy a lot of items together for one price?
Allocate the total cost across the items based on their estimated individual values. For example, if you pay $20 for a box of 5 items, you might assign $5 to one, $3 to another, and so on. The total must equal $20.
How long should I keep my inventory log?
Keep it for at least three years after the tax filing deadline for the year you sold the items. Some experts recommend seven years. When in doubt, keep it longer.
What if an item is lost or damaged before sale?
Record the loss in your log. Mark the status as “damaged” or “lost” and note the original cost. This is a business expense that may be deductible—ask a tax professional.
Is a log book the same as a sales ledger?
No. A sales ledger tracks only sales. An inventory log tracks purchases, listing, and sales in one place. Resellers need both, but a combined log is more efficient.