How should a dropshipping business track cost of goods sold when inventory is never on hand?
The fact that you never touch the product doesn’t mean cost of goods sold disappears from your books. Every order you fulfill through a supplier has a real cost, and if you’re not tracking it per order, your profit numbers are meaningless.
For each sale, your COGS includes the supplier’s price for that item plus whatever shipping cost gets charged to move it from the supplier to your customer. Some suppliers bundle shipping into the product price and others break it out separately. Either way, the total amount you pay to fulfill that order is your cost of goods sold for that transaction.
In QuickBooks Online, set up your products as non-inventory items. This tells QBO that you’re selling something with a cost but you’re not tracking physical stock levels. When you create the item, enter the cost (what you pay the supplier) and the sales price (what you charge the customer). QBO will record the revenue to your income account and the cost to your COGS account automatically when you record a sale. If you need help getting this configured correctly, we handle inventory accounting in Orlando for businesses that sell physical products without warehousing them.
The tricky part is keeping those costs accurate. Supplier prices change. Shipping rates fluctuate. Currency conversion adds variability if you’re sourcing internationally. Review and update your item costs in QBO regularly so your COGS reflects what you’re actually paying, not what you paid six months ago.
Match each sale to its corresponding supplier cost in the same accounting period. If you record $5,000 in sales in March but the supplier invoices don’t get entered until April, your March financials show inflated profit and April looks worse than it actually was. This timing mismatch makes your monthly reports unreliable. Enter supplier costs in the same period as the related sales.
Track COGS at the product level, not just as one lump number. When you can see margin by product, you quickly find out which items are actually making money and which ones look busy but barely break even after supplier costs and shipping. A product selling 200 units a month at a 5% margin is less valuable than one selling 30 units at a 40% margin. That kind of visibility is what lets you make real decisions about which products to keep, which to cut, and where to invest your ad spend.
Don’t forget platform fees and transaction costs. While these aren’t technically COGS, they eat into your margin on every sale. Track them separately so you can see gross margin (revenue minus COGS) and net margin (after all selling costs). Many e-commerce sellers are surprised when they realize their actual take-home per order is far less than expected once Shopify fees, payment processing, and ad costs are factored in.
If your books are currently lumping all supplier payments into one expense category with no connection to individual sales, the fix isn’t complicated but it does require some setup discipline. Create a non-inventory item for each product you sell, establish a consistent process for recording costs per order, and reconcile your supplier invoices against sales weekly. Do that and you’ll actually know which products and which sales channels are worth your time.
Central Florida's Trusted Bookkeeping Firm
Start Here:
A 30-Minute Consultation
Tell us about your business and what's going on with your books. We'll figure out exactly what you need, and give you a straightforward quote.
More Questions
What should I look for when hiring a bilingual bookkeeper for my business?
Look for real bookkeeping qualifications first, then evaluate their ability to explain financial concepts clearly in your preferred language. Bilingual ability should complement competence, not replace it.
Read answerHow do I separate bookkeeping when I have rental properties in different LLCs?
Each LLC needs its own bank account, credit card, and set of books. Keeping finances completely separate is what preserves the liability protection you created the LLCs for in the first place.
Read answerHow do I reconcile Amazon FBA settlement reports with what shows in my bank account?
Amazon deposits a net settlement amount after deducting fees, returns, reimbursements, and reserves. You need to break that single deposit into its component parts so your books reflect actual revenue and actual expenses.
Read answerWhat's the best way for a retail store to catch and track inventory shrinkage?
Regular physical inventory counts compared against your book inventory reveal shrinkage. The key is doing counts frequently enough to catch problems early and categorizing losses so you can identify patterns and root causes.
Read answerHow does sales tax nexus work for a Florida-based e-commerce seller shipping to other states?
Your Florida location creates automatic nexus in the state, but you likely owe sales tax in other states too. Since the 2018 Wayfair ruling, any state where you exceed economic nexus thresholds can require you to collect and remit sales tax.
Read answerWhat financial reports does a lender want to see from a rental property investor?
Lenders typically want a profit and loss statement, a balance sheet, a rent roll, and a schedule of real estate owned. They also ask for tax returns and bank statements to verify what those reports show.
Read answer

