Good marketplace records do more than support tax preparation: they show which items are profitable, where fees are eroding margins, and whether your inventory is actually moving. This guide gives you a repeatable system for tracking inventory costs, sale proceeds, platform fees, shipping, refunds, mileage, receipts, and buyer communications in one spreadsheet or bookkeeping file.
Overview
Whether you sell a few household items, flip products for profit, make crafts, or operate a small business online, keep records that connect each item to its financial outcome. A marketplace dashboard may show an order total, but that number is not necessarily your revenue, profit, or taxable result. Fees, shipping labels, refunds, discounts, supplies, and the original cost of inventory may need to be considered separately.
A practical recordkeeping system has four parts:
- Inventory records: What you bought or made, when you acquired it, how much it cost, and where it is stored.
- Sales records: The listing, order date, sale proceeds, discounts, refunds, payment received, and item status.
- Expense records: Platform fees, payment processing, shipping, packaging, mileage, tools, supplies, and other costs connected to selling.
- Supporting documents: Receipts, invoices, platform statements, shipping records, photographs, return messages, and buyer communications.
Keep business and personal activity as separate as practical. Use a dedicated spreadsheet tab, bank account, payment method, or folder for selling activity when possible. This makes reconciliation easier and reduces the risk of overlooking a fee or mixing an item's purchase cost with unrelated spending.
Records can also help you choose a better selling channel. Before listing an item, compare expected proceeds with marketplace fees, shipping costs, and the time required to prepare the order. For broader fee decisions, see the Marketplace Fees Comparison.
How to estimate
Use a transaction-level calculation rather than relying on the amount shown in a payout notification. A simple estimate of net result is:
Estimated net result = sale proceeds − refunds − marketplace fees − payment fees − shipping paid by seller − packaging and supplies − item cost − other directly related expenses
If you collect a shipping amount from the buyer, record it as part of the transaction inflow and record the postage or label cost separately. This shows whether shipping is fully covered, partially subsidized, or producing an unexpected loss.
For an inventory item, calculate total cost before it sells:
Total item cost = purchase price + inbound shipping + refurbishment materials + directly attributable preparation costs
Do not assume that every household or business expense belongs in the calculation. Include a cost only when you can explain its connection to the sale and retain reasonable support for it. Rules for deductibility, inventory treatment, mileage, sales tax, and reporting can vary by location and by the nature of your activity, so use this worksheet as an organization and estimating tool rather than a substitute for professional tax advice.
For each order, record both the marketplace's transaction details and the amount that reached your bank or payment account. The difference is often where fees, reserves, adjustments, or refunds appear. Reconcile the two amounts regularly instead of waiting until year-end.
Inputs and assumptions
A spreadsheet-ready seller record can use one row per item or order. Add columns that fit your workflow, but start with these fields:
- Item ID: A unique code such as 2026-001, matched to the listing and storage location.
- Item description and category: Include brand, model, condition, size, or identifying details where useful.
- Acquisition date and source: Record when and where you bought, received, or made the item.
- Item cost: Enter the purchase amount and any allocated inbound cost.
- Listing date and platform: Note where the item was offered and the listing reference.
- Sale date and order ID: Use the platform's order number so you can find the original record.
- Sale proceeds: Separate the item price, buyer-paid shipping, discounts, and taxes shown by the platform.
- Fees: Record listing, transaction, payment processing, promotion, or other marketplace charges as separate columns when available.
- Fulfillment costs: Track postage, shipping labels, packaging, local delivery, and mileage separately.
- Refunds and adjustments: Include partial refunds, cancellations, returns, chargebacks, and platform credits.
- Payment date and payout: Record what was actually transferred and when.
- Status: Use labels such as listed, sold, shipped, returned, refunded, donated, lost, or unsold.
- Document link: Add a filename or cloud-folder link to the receipt, statement, label, or communication.
For mileage, keep a separate log with the date, purpose, starting point, destination, and distance. Do not estimate a full year's driving from memory. For receipts, use consistent filenames such as 2026-001-purchase, 2026-001-shipping, or 2026-platform-statement-January. Save original digital files where possible and photograph paper receipts before they fade.
Marketplace sales tax records deserve separate attention. Preserve order-level tax information and the platform's periodic statements, but do not assume a marketplace's collection or reporting treatment answers every obligation that may apply to your activity. Review the rules relevant to your location and selling structure before filing or preparing official reports.
Worked examples
Example 1: A shipped used item. Assume you paid $28 for an item and spent $4 on preparation. It sells for $60, while the buyer pays $8 for shipping. You pay $7 for postage and $2 for packaging. The marketplace and payment fees together total $9. There is no refund.
The transaction inflow is $68: $60 for the item plus $8 collected for shipping. The recorded outflows are $28 item cost, $4 preparation, $9 fees, $7 postage, and $2 packaging. The estimated net result is $18. Recording only the $60 sale price would hide the shipping inflow; recording only the $52 payout would hide the costs that produced it.
Example 2: A returned item. Assume an item sells for $90, but you issue a $30 partial refund after discovering damage. The original fee is $12, and the return shipping costs $10. Record the original sale, the refund date and amount, the fee, and the return cost as separate entries or clearly labeled columns. This preserves the audit trail and prevents the spreadsheet from treating the original sale as a final result.
Example 3: A local pickup. Assume you buy an item for $40, spend $5 on cleaning supplies, and sell it locally for $85 with no shipping. Your estimated result before mileage and selling-platform fees is $40. If you drive to a meeting point, record the trip in the mileage log rather than burying it in a general expense column. If the transaction occurs in cash, record the date, amount, item ID, and confirmation or message showing completion.
These examples use hypothetical amounts. Replace them with the actual inputs from your platform statements, receipts, and payment records. For pricing decisions, the used item valuation guide can help you estimate a realistic sale price before you commit inventory.
When to recalculate
Recalculate each item before listing, when an offer arrives, after a sale, and after any return or adjustment. A small change in platform fees, shipping rates, packaging costs, or selling price can change whether an item is worth listing. Recheck the calculation whenever you change marketplaces, enable paid promotion, offer free shipping, or move from local pickup to shipping.
Use a simple monthly workflow:
- Import or enter every order, including canceled and refunded orders.
- Match each order to the platform statement and bank or payment payout.
- Attach receipts for inventory, supplies, postage, mileage, and other relevant costs.
- Update inventory status and investigate items that are listed but missing, returned, or unsold.
- Review totals for sales, fees, refunds, shipping, expenses, and estimated net results.
- Back up the spreadsheet and document folder using a second location.
At year-end, check that every sold item has an acquisition cost or a documented explanation, every payout is reconciled, and every refund or return is recorded. Download available annual statements before access changes or records become difficult to locate. Compare the platform's tax forms or summaries with your own transaction ledger, but do not treat a form as a complete substitute for your underlying records.
Finally, review official guidance whenever reporting thresholds, forms, mileage rates, sales-tax responsibilities, platform policies, or fee schedules change. Keep a note in your workbook showing the date you last reviewed these inputs. A consistent monthly habit is more useful than a last-minute search: it helps you price items accurately, identify profitable categories, and prepare complete records when reporting time arrives.
