Reseller bookkeeping becomes manageable when every purchase, sale, fee, and remaining item follows the same recordkeeping process. This guide gives beginners a repeatable monthly system for tracking resale income, inventory cost, expenses, cash flow, and tax-ready documents, with formulas and examples you can revisit whenever marketplace fees, shipping costs, or mileage rates change.
Overview
The purpose of reseller bookkeeping is not simply to see how much money entered your bank account. It is to understand what each sale contributed after the costs required to acquire, prepare, list, sell, and deliver the item. A useful system should answer four questions:
- What did I sell, and how much did the buyer pay?
- What did the item cost me, including its share of a bundle or lot?
- Which selling, shipping, repair, supply, and operating costs reduced the result?
- What inventory and supporting records do I still have at month-end?
Keep business and personal activity separate where practical. A dedicated account or card can make reconciliation easier, but the essential requirement is consistent classification. Record sales when they occur according to the method you and your tax adviser use, then retain the marketplace statement, order detail, receipt, or other evidence that supports the entry.
Bookkeeping is different from cash-flow tracking. Cash flow tells you when money moved. Profit tracking assigns inventory cost and other expenses to the activity that generated the sale. For example, a bulk purchase may leave your bank account immediately, while the cost of each item is recognized as inventory is sold under your chosen recordkeeping method.
How to estimate
Start with one row per item or sale in a spreadsheet, bookkeeping app, or inventory tool. Use a unique item ID so the purchase record, listing, sale, refund, and shipping information can be connected. A practical profit estimate is:
Estimated profit = sale proceeds − cost of goods sold − marketplace fees − shipping cost − packaging and supplies − transaction-specific costs
For a more complete monthly view, subtract operating costs that are not tied to one specific order, such as approved mileage, software, storage, equipment, or workspace costs. Keep these separate from the item-level calculation so you can see both product performance and total business performance.
Useful spreadsheet columns include:
- Item ID, product description, category, and source
- Purchase date, purchase price, and acquisition method
- Allocated cost for an item bought in a bundle, pallet, or mixed lot
- Listing date, marketplace, sale date, and order number
- Sale price, buyer-paid shipping, discounts, refunds, and returns
- Marketplace commission, payment processing charge, promoted-listing cost, and other order fees
- Postage, shipping supplies, cleaning materials, repairs, and alterations
- Net proceeds, estimated profit, and current status
To calculate margin, divide profit by the sale price: profit margin = profit ÷ sale price. To calculate return on inventory cost, divide profit by the item cost: inventory ROI = profit ÷ cost of goods sold. Label each result clearly because margin and ROI answer different questions.
For a quick purchasing decision, use a break-even calculation. If fees are a percentage of the selling price, the approximate break-even price is:
Break-even sale price = fixed costs ÷ (1 − fee rate)
Add any variable shipping or preparation costs to fixed costs before applying the formula. If a marketplace has several fee types, model them separately rather than relying on a single assumed percentage. A resale profit calculator can speed up this estimate, but the result is only as reliable as the inputs.
Inputs and assumptions
Good reseller bookkeeping depends on making assumptions visible. Do not hide uncertain costs inside a general profit number. Create an assumptions area in your spreadsheet and update it when an input changes.
Inventory cost
Record the full purchase amount, including applicable shipping or buyer costs paid to acquire inventory. For a bundle, assign a reasonable cost to each item and document the method. You might allocate cost by relative expected selling value, equal units when items are substantially similar, or another consistent approach that fits the lot. Avoid treating the entire bundle cost as the cost of the first item sold.
Marketplace and payment fees
Use the actual fee shown on the order or settlement statement whenever possible. Fees can differ by marketplace, category, payment method, listing option, seller program, promotion, or refund. Keep fee records rather than estimating from the deposit that reaches your bank account.
Shipping and supplies
Separate buyer-paid shipping from your actual postage and packaging cost. A shipping amount collected from the buyer is part of the transaction record, while the carrier charge and materials are costs. Save labels, receipts, and order details together. For reusable supplies bought in bulk, either track usage by item or use a consistent method for assigning the cost.
Mileage and general expenses
Maintain a date-based mileage log for sourcing trips, drop-offs, shipping runs, or other eligible business travel rather than estimating at year-end. Record the purpose and distance. General expenses should have a date, vendor, amount, business purpose, and receipt or other support. Whether a cost is deductible depends on your location, business structure, and circumstances, so treat this guide as a recordkeeping framework rather than tax advice.
Returns, refunds, and unsold inventory
Do not delete a refunded order. Mark it as returned or refunded, record the money returned, and update inventory when the item comes back. At month-end, distinguish sold inventory from unsold inventory. Unsold items are not the same as profit or a completed expense in a simple sales report; they remain part of the inventory records used to calculate future results.
Worked examples
Example 1: single-item online sale. Assume an item has an allocated purchase cost of $18 and sells for $52. The seller pays $7 for postage, $1.50 for packaging, and $8.32 in marketplace and payment fees. The buyer-paid shipping amount is recorded separately from the seller’s actual postage.
The item-level estimate is: $52 − $18 − $7 − $1.50 − $8.32 = $17.18 estimated profit. The estimated profit margin is $17.18 ÷ $52, or about 33%. If the seller later discovers a $3 repair cost that was necessary before listing, the revised profit is $14.18. Recording that repair at the time it occurs prevents an inflated result.
Example 2: mixed-lot purchase. Assume a reseller pays $120 for six items and assigns costs of $30, $25, $20, $18, $15, and $12. Those allocations total $120. If the $30 item sells first, only $30 is assigned to that sale. The remaining $90 stays attached to the five unsold items. If one item proves unsellable, the reseller should document what happened and apply the inventory treatment appropriate to their accounting and tax method rather than quietly changing the original purchase total.
Example 3: monthly business result. Suppose item-level profit across a month totals $640. The reseller also records $45 in mileage-related costs, $28 in software, and $32 in storage or supplies that were not assigned to individual orders. The estimated monthly result before any other adjustments is $640 − $45 − $28 − $32 = $535. This view helps distinguish a strong product from a month that is profitable only because overhead was omitted.
When to recalculate
Reconcile your records at least monthly, even if you make sales every day. A practical month-end workflow is:
- Export or download marketplace order and settlement records.
- Match deposits to orders and identify fees withheld before payout.
- Enter purchases, allocate bundle costs, and mark sold inventory.
- Record postage, supplies, repairs, mileage, refunds, and returns.
- Compare your spreadsheet or app balance with bank and card activity.
- Review unsold inventory, stale listings, negative-margin sales, and missing receipts.
- Save statements and receipts in organized folders with a consistent naming format.
Recalculate whenever a marketplace fee schedule, shipping charge, return outcome, sourcing cost, or promotional expense changes. Also revisit your assumptions before buying liquidation pallets, accepting a bundle, starting a new marketplace, or taking on furniture repairs. Rates used for mileage and tax reporting can change, and reporting requirements vary by jurisdiction and situation, so confirm current details with official guidance or a qualified tax professional.
Finally, review your records before filing or handing them to an adviser. Look for deposits without matching sales, sales without purchase costs, duplicate fees, missing returns, and inventory that appears in the spreadsheet but cannot be located. Consistent monthly reconciliation is more useful than a complicated system that is abandoned after a few weeks. Start with the fields you can maintain, protect the original documents, and improve the model as your flipping operation grows.
