How to Keep Track of Cost of Goods as a Reseller for Accurate Profit Tracking

Tracking the cost of goods sold (COGS) is essential for any reseller to understand profitability and meet accounting standards. To keep precise records, include not only the purchase price but also shipping, taxes, fees, and any other expenses directly tied to acquiring your products. Setting up an organized system to capture and update these costs ensures your profit calculations are accurate and your financial records stay compliant.

What exactly counts toward your cost of goods as a reseller?

Your COGS includes all expenses directly related to acquiring and preparing products for resale. Start with the purchase price of the items. Then add shipping costs you paid to receive the items, such as freight or courier fees. Include import taxes, customs duties, and handling fees if applicable. For example, if you buy a gadget for $20, pay $5 shipping, and $3 in import taxes, your total cost for that item is $28.

Also include any fees or commissions directly tied to acquiring inventory, like a sourcing agent’s fee. However, fees you pay when you sell the item, such as marketplace commissions, are selling expenses, not part of COGS.

If you buy in bulk and receive a discount, use the net price after the discount. Add costs for packaging or labeling that are necessary before resale. Storage or warehousing costs are generally excluded from COGS unless they directly relate to preparing the product for sale.

Tracking all these components prevents underestimating your costs and inflating profit figures.

How do I set up a simple system to track these costs?

A clear and simple way to track COGS is with a spreadsheet or basic accounting software. Create categories for Purchase Price, Shipping, Taxes/Fees, Discounts, and any other relevant costs.

Organize your spreadsheet with columns for:

• Product Name or SKU
• Purchase Date
• Purchase Price
• Shipping Cost
• Taxes and Fees
• Discounts Received
• Total Cost (calculated by summing the above)

Keep all purchase receipts and invoices organized, either digitally or physically, to reference when entering data. Assign a unique identifier to each purchase batch or item to keep costs from mixing.

Update your records every time you buy inventory. Regularly reconcile your entries with bank or payment statements to catch errors early.

When you buy multiple units in one purchase, divide the total cost among items based on quantity or weight to get accurate per-item costs.

Maintain consistency and clarity in your tracking system to save time and avoid confusion during tax season or profit review.

What software or apps can help automate cost tracking?

Several tools can simplify COGS tracking and reduce manual errors. For small resellers, cloud accounting software like QuickBooks or Xero lets you record purchase costs, shipping, and taxes, linking these to your sales.

Inventory management apps such as Sortly or Zoho Inventory help assign costs to specific items and update them as inventory changes. Many integrate with marketplaces and payment processors to automatically import purchase and sales data.

If you sell on platforms like eBay or Amazon, specialized tools like GoDaddy Online Bookkeeping or A2X sync sales and fees to help calculate accurate COGS.

These tools automate tracking and reduce mistakes but often have monthly fees and require some setup. If you're just starting out, a well-organized spreadsheet may be enough until your volume grows.

Choose a tool based on your budget and the complexity of your business operations.

How should I adjust cost records when items are returned, discounted, or damaged?

Returns, discounts, and damaged inventory affect your profitability and should be reflected accurately in your records.

When a customer returns an item, reduce your COGS by the cost of that item since you regain inventory or avoid a sale loss. If you restock it, track its condition and determine if its cost value needs adjustment.

Discounts affect your revenue and profit margin but do not change your COGS. Do not reduce COGS by the discount; instead, record the sale price accordingly to keep margins accurate.

If inventory is damaged or lost, write off its cost as a loss or expense separate from COGS. This prevents overestimating the cost of goods available for sale.

For example, if you sold an item costing $30 and gave a $5 discount, your COGS stays $30, but your revenue is $25. Writing off a damaged item costing $30 means removing it from inventory and recording the $30 as an expense.

Regularly review and update your records to maintain an accurate financial picture.

How can I double-check my cost tracking to avoid costly mistakes?

Errors in tracking COGS can hide losses or cause tax problems. To avoid these, regularly audit your records.

Compare your recorded purchase costs against invoices and receipts to ensure accuracy for every purchase price, shipping fee, and tax.

Reconcile your data with bank and credit card statements to catch missing or duplicate entries.

Physically count your inventory to verify it matches your records; discrepancies may indicate errors in cost allocation.

Common mistakes include forgetting to include shipping or taxes in COGS, mixing personal and business expenses, and misclassifying fees.

Set a regular schedule, such as monthly reviews, to verify and correct your data. This keeps your profit calculations reliable and your books accurate.

Conclusion

Once you know what costs to include and have a system to track them, managing your COGS records becomes straightforward. Whether you use spreadsheets or software, consistently updating your data with every purchase, return, or inventory change gives you a clear view of your profits. Regular checks and adjustments for returns or damages prevent surprises and keep your finances accurate. These good habits help you make better business decisions and simplify your accounting.