E-Commerce Cost of Goods Sold: Reconciling Purchases, Freight, and Inventory

Key takeaway: Reconcile inventory quantities, ownership, cost and cutoff before accepting e-commerce cost of goods sold. Keep supplier credits separate from customer refunds, include freight once, and distinguish management inventory reporting from the business’s tax accounting method.

This article is part of our guide to industry accounting specialties.

A supplier invoice, a warehouse count and a marketplace payout answer different questions. The invoice identifies a charge, the count identifies stock at a particular place and time, and the payout identifies cash settlement. None alone establishes the period’s cost of goods sold, or COGS.

For a South Florida online seller, the useful starting point is a repeatable close that connects product activity to the general ledger. The examples below assume a resale business using inventory-based accrual management books. Manufacturing costs, specialized industries and a different tax method can require additional adjustments.

Build a COGS calculation with consistent costs

For a period with no separate inventory losses, owner withdrawals or other non-sale removals, the roll-forward is:

Beginning inventory + net inventory purchases + acquisition costs not already included − ending inventory = COGS.

Net purchases reflect supplier returns, allowances and the discounts treated as reductions of purchase cost under the adopted method. They do not mean purchases minus customer refunds. Beginning and ending inventory must use a consistent costing basis, including the appropriate share of landed costs.

IRS Publication 334’s COGS discussion distinguishes purchase returns from sales returns and addresses freight-in and closing inventory. It is tax guidance for its stated reporting context; use the actual business’s method when translating the management reconciliation to a return.

This is our arithmetic illustration. If the purchase report already contains the $2,000 freight, adding it again overstates available cost. If ending inventory excludes its proper freight allocation, the calculation pushes too much cost into the current period. If stock was used personally, donated, lost or removed for samples, identify the separate movement and its proper treatment instead of assuming every inventory reduction represents a sale.

See “Dental Laboratory Costs: Inventory, Equipment, and Gross-Margin Tracking” for more on Dental Laboratory Costs.

Allocate freight without counting it twice

Under the inventory cost method, acquisition cost can include the invoice amount after appropriate discounts plus transportation and other acquisition charges; capitalization rules may add other costs. See Publication 538’s inventory valuation guidance. Keep freight to acquire stock distinct from customer delivery, marketplace commissions, storage and general operating costs. Their classification depends on the service, reporting basis and applicable rules.

For each shipment, connect the freight invoice to the products received. A useful allocation reflects the reason for the charge: weight may fit a heavy shipment, volume may fit bulky products, and units may fit materially similar items. Document the choice and review it when the product mix changes.

For example, a $600 freight charge covers two product groups weighing 200 and 400 pounds. If weight reasonably drives the charge, allocate $200 and $400 respectively. Do not add the entire $600 to both groups, or expense the same invoice again when the bank feed imports the payment. A payment of an already recorded payable clears the liability.

Separate supplier credits from customer returns

A supplier credit can reduce a payable, inventory acquisition cost or the cost attributed to goods already sold, depending on what it corrects. Match the credit to its invoice and affected products. A credit for merchandise does not necessarily mean the supplier refunded the cash in the same month.

A customer refund reverses sales consideration or settles an existing refund liability under the reporting method. It does not belong in the supplier-return line. Track the returned item separately: was it received, does the business own it, is it saleable, and what supported carrying value remains?

Consider a simple completed return with no earlier refund estimate, sales tax or processing fee. A customer receives a $100 refund for a product originally recorded at $60 cost. If the returned product is fully recoverable at that carrying value, the sales-side entry debits sales returns $100 and credits cash $100; the cost-side entry debits inventory $60 and credits COGS $60. Those are two entries with different purposes.

If the recovered product is damaged, do not automatically restore $60 of saleable stock. Establish the appropriate value and record any required loss under the reporting basis. Where GAAP requires estimated returns and an asset for recovery rights before goods come back, that earlier accounting also affects the settlement entries. A refund issued without recovering merchandise does not itself create warehouse inventory.

Count owned stock across every location

Start with warehouse and fulfillment-center reports, then reconcile transfers and goods in transit. An order is not ownership evidence by itself. Review the contract, shipping terms, shipment dates and receiving records to establish cutoff.

For tax inventory, Publication 538’s merchandise rules include purchased goods once title passes, even while in transit, and exclude goods ordered but not yet owned. Goods out on consignment remain distinct from goods held on someone else’s behalf.

A transfer of 50 units from your warehouse to your own fulfillment stock is one movement of the same owned inventory. If both location reports include the shipment during transfer, remove the duplicate from the consolidated quantity. If neither report includes it, add a supported in-transit record. Apply the correct unit cost after resolving quantities; 50 units alone is not a dollar valuation.

Physical counts also need condition and cutoff review. Segregate damaged stock, customer-owned goods and returns awaiting inspection. Investigate missing units with receiving and shipping records before booking a loss; a delayed location update and an actual disappearance require different corrections.

If this raises questions about Retail and E-Commerce Inventory Accounting, “Inventory Accounting for Small Retail and E-Commerce Businesses” addresses it directly.

Use one monthly close sequence

1. Carry forward the opening balance. Preserve the prior close’s quantity and cost reports. Explain any prior-period adjustment separately.
2. Match acquisitions. Compare purchase orders, receiving evidence, invoices, freight and supplier credits. Use bank or card records to establish payment, not an invoice alone.
3. Reconcile movements. Trace sales, returns, location transfers and non-sale removals by product. Resolve cutoff and ownership exceptions.
4. Value ending stock. Apply the adopted costing method and supported allocations; document condition adjustments and any tax differences.
5. Tie to the ledger. Reconcile inventory and COGS reports to their control accounts. Identify the underlying transaction before posting an adjustment.
6. Review margins and cash separately. Compare pricing, product mix, purchase cost, freight and discounts with prior periods. Assign unresolved items to a person and a deadline.

A margin change is a signal for investigation, not proof of a particular error. Price changes, promotions, currency movements, supplier changes and product mix can create real changes. Compare the same period and cost definitions before deciding that the books are wrong.

Separately reconcile marketplace settlements from customer activity through refunds, fees, withheld reserves and payouts. A net payout is not automatically sales revenue. Sales tax collected for a taxing authority is a separate obligation under the applicable arrangement; inventory reconciliation does not establish marketplace or multistate sales-tax compliance.

Keep profit separate from cash availability

Suppose the first example’s business has $70,000 net recognized sales and $40,000 COGS. Gross profit is $30,000 before operating expenses. Assume it collects $60,000 and pays suppliers $45,000 during the period: those two cash categories net to $15,000. Neither amount is a complete cash-flow statement or spendable-cash calculation.

Supplier payments can include old payables and stock still unsold. Sales may remain in receivables or marketplace reserves. Payroll, rent, debt service, taxes and restricted funds also affect available cash. Keep a separate cash forecast that uses expected receipt and payment dates.

Check the tax method before preparing the return

Section 471(c) permits eligible small businesses to use specified inventory alternatives, including non-incidental materials and supplies or qualifying financial-statement/book treatment. Eligibility depends on the gross-receipts test and tax-shelter exclusion, with applicable aggregation and other rules.

For tax years beginning in 2026, the section 448(c) three-year average gross-receipts threshold is $32 million; see Revenue Procedure 2025-32, section 3.30. Passing that threshold test alone does not select a method or authorize an immediate deduction for every inventory payment.

Under the non-incidental materials-and-supplies approach, providing inventory to customers is relevant to when it is used or consumed; payment and other applicable timing requirements also matter. Maintain useful operational stock records even when tax inventory treatment differs. A tax method change generally requires the appropriate consent procedures, commonly Form 3115; review the current procedures before changing treatment.

An LLC’s legal form does not determine its federal tax classification. The business may be disregarded, taxed as a partnership, or taxed as a corporation depending on ownership and valid elections. Reconcile the business’s tax results to the correct entity and owner returns; book gross profit is only a starting point.

We break down E-Commerce Returns and Chargebacks separately in “E-Commerce Returns and Chargebacks: Keeping Revenue Reports Accurate.”

Prepare the year-end handoff

Give the preparer the final reconciliation, cost-method description, count and location reports, invoices, freight support, credit and return records, and a list of unresolved exceptions. Preserve the reports supporting the filed year before rolling the system forward. Show any book-to-tax adjustments explicitly.

CPA Firm South Florida’s published preparation pricing includes cleanup needed for the quoted return. Confirm the inventory work included in your quote and any separately scoped ongoing bookkeeping, amended returns, multistate work or planning. Contact the firm with the actual records and questions to discuss the required engagement.

Frequently asked questions

Does paying for inventory create an immediate tax deduction?

Not automatically. The deduction depends on the business’s permissible tax accounting method and applicable timing rules. Eligible small businesses can use section 471(c) alternatives; eligibility does not make every payment immediately deductible.

Does a customer refund reduce inventory purchases?

No. Record the sales refund separately. Restore returned merchandise only when the business recovers it and at a supported value under its accounting method; damaged or unrecovered goods may require a different entry. Supplier returns and allowances affect purchases.

Should inventory in transit be counted?

Include goods the business owns under the applicable contract and shipping terms. Exclude goods not yet owned and count transfers between your warehouse and a fulfillment center only once.

Why can COGS differ from cash paid to suppliers?

COGS measures the recognized cost associated with goods sold under the applicable method. Cash payments may fund unsold stock, deposits or old supplier balances, while current inventory costs may still be unpaid.