E-commerce Dropshipping Accounting: How to Record Inventory You Don't Hold
The Core Problem in Dropshipping Accounting: A Timing Mismatch
For many e-commerce founders, the dropshipping model looks like the simplest path to revenue. Without the need to purchase and store inventory, the business feels lean and cash-efficient. Yet, this same inventory-light model creates a specific and frustrating accounting challenge. Your profit reports can swing wildly from one month to the next, showing huge gains followed by puzzling losses, even with steady sales. This isn't a sales problem; it's an accounting problem rooted in a simple timing mismatch.
The reason your dropshipping profits appear so volatile is often due to the gap between when a customer pays you and when you pay your supplier. If you record revenue when you receive cash and expenses when you pay them (cash-basis accounting), your books will not reflect your actual performance. A customer order in late March means revenue is booked in March. But if you pay the supplier invoice for that exact product in early April, the cost appears in a totally different month. The result? March's gross margin is artificially high, and April's is artificially low.
This is where the principle of accrual accounting becomes essential for managing dropshipping finances. Accrual accounting dictates that you match expenses to the revenue they helped generate, regardless of when cash changes hands. For dropshipping, this means the cost of a product must be recorded as an expense in the same period as the sale of that product. This method provides a true picture of your gross margins on every sale and gives you a stable, reliable view of your company’s financial health month-over-month. Getting your dropshipping accounting right is fundamental to understanding your true profitability, making sound pricing decisions, and managing your cash flow effectively.
How to Record Dropshipping Cost of Goods Sold (COGS) Accurately
To properly manage your dropshipping COGS, you must log the expense when the sale happens, not when the supplier's bill is paid. This core practice ensures your financial reports are accurate. In your accounting software, this is handled by creating a 'Bill' to recognize the liability to your supplier as soon as the sale is made. The reality for most early-stage startups is more pragmatic: the goal is not perfection, but a consistent process. See our guide on fulfilment cost allocation for how to treat shipping and pick-pack fees within COGS.
Let’s walk through the correct step-by-step process for a typical transaction. Imagine a customer places an order on May 25th.
- Record Revenue: You immediately record the revenue from that sale in your May financials. This captures the income in the period it was earned.
- Create a Supplier Bill: At the same time, even if you do not have the supplier invoice yet, you create a Bill in QuickBooks or Xero dated May 25th. This bill should be for the expected cost of the product, including any shipping and fulfillment fees.
- Post the Journal Entry: Creating the bill generates a journal entry that correctly allocates the expense. It does not trigger a payment; it simply creates a record of what you owe, which sits in your Accounts Payable. The basic journal entry looks like this:
- Debit: Cost of Goods Sold (an expense account increases)
- Credit: Accounts Payable (a liability account increases)
- Settle the Liability: When the supplier invoice arrives and you pay it in June, your accounting entry is a simple transaction to clear the liability. You are not recording a new expense, but rather paying off an old debt.
- Debit: Accounts Payable (the liability account decreases)
- Credit: Cash (your bank account decreases)
By following this process, your profit and loss statement for May now tells the truth about that sale's profitability. June's cash outflow is correctly shown as settling a prior debt, not as a new operating expense. This is the foundation of accurate e-commerce accounting.
A Practical Workflow for Reconciling Dropshipping Transactions
Correctly recording COGS is one thing; reconciling hundreds or thousands of individual orders with their corresponding supplier invoices is another. This process can quickly become a major operational bottleneck for growing e-commerce companies. How you approach it depends on your company's stage and sales volume.
Manual Reconciliation for Early-Stage Businesses
For businesses with less than $1 million in annual revenue, a manual system using a spreadsheet or a tool like Airtable is often manageable. The process typically involves exporting your Shopify orders into a central log. Each row represents a customer order and should include the order ID, sale date, and total revenue. You then add columns for the supplier invoice number, the total supplier cost (your COGS), and a status column to mark it as 'Reconciled'. When you receive a supplier invoice, you match it back to the customer orders and update the sheet. This system provides the raw data needed for your accountant to make accurate month-end journal entries.
When to Automate Your Reconciliation Process
Almost every e-commerce company reaches a point where manual reconciliation becomes unsustainable. In practice, we see that once you exceed a few hundred orders a month, the time cost and error rate make spreadsheets a liability. This is the trigger to adopt automation. Tools like A2X or Zapier can connect Shopify to QuickBooks or Xero, streamlining the process of reconciling dropshipping transactions. These platforms automatically create draft bills from new orders, making it much easier to match them with supplier invoices. Adopting these systems ensures that your accounting for dropshipping suppliers scales with your sales volume.
Navigating Sales Tax and VAT for Dropshippers
The complexity of dropshipping is not limited to COGS. Sales tax and VAT present a significant compliance challenge, especially when your suppliers ship from multiple locations. For US companies, the key concept to understand is 'economic nexus'. The South Dakota v. Wayfair Supreme Court decision established the legal precedent for states to charge sales tax based on economic activity rather than just physical presence. This means you may be required to collect and remit sales tax in a state where you have no office or employees.
According to the Sales Tax Institute, "The most common economic nexus thresholds for US sales tax are $100,000 in sales OR 200 separate transactions into a state within a 12-month period." Tracking this manually across 50 states is nearly impossible, which is why services like Avalara, TaxJar, and Anrok are essential for scaling e-commerce businesses.
For companies with a global footprint, it is crucial to understand that rules differ significantly abroad. In day-to-day finance operations, what actually happens is that founders often overlook these differences. A critical distinction is that "VAT rules in the UK/EU are different from US sales tax and often have lower thresholds, requiring attention earlier for businesses with significant sales in those regions." You must monitor these obligations separately to remain compliant.
Putting It All Together: Your Dropshipping Accounting Checklist
To gain control over your dropshipping accounting, focus on implementing a few core practices. These steps will transform your financial data from a source of confusion into a reliable tool for growth.
- Commit to Accrual Accounting. It is the only way to get a true picture of your profitability and make informed decisions about pricing, marketing spend, and inventory management.
- Use the 'Bill' Function for Every Order. Make creating a bill in QuickBooks or Xero your standard procedure for every sale. This ensures costs are matched to the correct revenue period every time.
- Systematize Your Reconciliation Process. Start with a spreadsheet, but define a specific volume metric, such as 150-200 orders per month, that will trigger your move to an automated solution like A2X.
- Monitor Tax Obligations Proactively. Implement a tool to track your economic nexus thresholds in the US from day one. Understand the separate VAT registration requirements in the UK and EU if you sell internationally.
By implementing these foundational practices, you can build a scalable and accurate financial system for your dropshipping business. Explore the Inventory & Fulfilment Cost Accounting hub for related guides and next steps, including our guide to exporting Shopify orders for reconciliation.
Frequently Asked Questions
Q: Do dropshippers have inventory on their balance sheet?
A: No, a pure dropshipping business does not hold inventory, so it does not appear as an asset on the balance sheet. The cost of the product is recorded directly as Cost of Goods Sold (COGS) on the profit and loss statement at the time of the sale.
Q: What is the best accounting method for a dropshipping business?
A: The accrual accounting method is the best and most accurate for dropshipping. It matches the cost of goods sold to the revenue in the same period, providing a true measure of profitability for each sale, unlike the cash-basis method which can distort your financial performance.
Q: How do I account for customer returns and supplier refunds?
A: When a customer returns a product, you record a sales return to reduce your revenue. When your supplier issues a refund, you record it as a credit against your Cost of Goods Sold. This ensures both the revenue and expense sides of the original transaction are correctly reversed.
Curious How We Support Startups Like Yours?


