How do I record Shopify sales in QuickBooks?
The deposit from Shopify is not your sales number. Shopify deducts payment processing fees, transaction fees, and any refunds before sending you money. If you record the bank deposit as sales income, your revenue will be understated and those fees will be invisible in your books.
The correct approach is recording gross sales separately from the payout. Your total sales go to an income account. Processing fees go to an expense account. Refunds reduce your sales. The net amount after all that should match what actually lands in your bank account.
In QuickBooks, set up a clearing account for Shopify. This can be an Other Current Asset account or a bank-type account. When you record sales, the money goes into this clearing account rather than directly to your checking account. When you record fees and refunds, they reduce the clearing account balance. When Shopify deposits money into your actual bank account, you transfer that amount from the clearing account to checking. If everything is recorded correctly, the clearing account zeros out after each payout.
For manual recording, pull Shopify’s payout reports and enter summary amounts for each deposit. Create a sales receipt or journal entry showing gross sales, fees, and refunds. Match this to the bank deposit. This method works for low-volume sellers but becomes tedious quickly if you’re processing dozens of orders daily.
Integration apps handle this automatically. A2X is the most reliable option for Shopify-to-QuickBooks connections. It pulls your payout data, breaks it into correct categories, and posts accurate journal entries. The cost is usually worth it for anyone doing real volume. Other options include the native Shopify connector and apps like Webgility, though A2X tends to handle the accounting more precisely.
Sales tax adds complexity. Shopify collects tax from customers, but that money isn’t your income. It’s a liability you owe to the state. Your books need to track tax collected separately and show it flowing through to your sales tax payments. Integration apps typically handle this categorization automatically.
Reconcile your Shopify clearing account monthly. If the balance isn’t close to zero, something is off. A payout wasn’t recorded, fees were missed, or sales got duplicated somewhere. Catching these issues monthly is much easier than untangling a year of e-commerce transactions at tax time.
If you’re running a Shopify store and struggling to make sense of the numbers, a Richmond bookkeeper familiar with e-commerce can set up your accounts correctly from the start. Getting the structure right means your reports actually show true sales and real profit margins instead of numbers that don’t quite add up.
Greater Richmond's Small Business Bookkeeper
The Next Step:
A Short Conversation
Fifteen minutes to tell us what you're dealing with. We'll let you know how we can help and give you a clear price quote.
More Questions
What's the best way to track business expenses?
The best expense tracking system is one you'll actually use consistently. Separate business and personal finances, capture receipts immediately, and reconcile weekly instead of waiting until month-end.
Read answerHow do I know if I need to collect sales tax in other states?
You need to collect sales tax in states where you have economic nexus, which usually means exceeding $100,000 in sales or 200 transactions. The rules changed in 2018, so physical presence is no longer required.
Read answerHow do I handle overtime pay correctly?
Non-exempt employees must receive 1.5 times their regular rate for hours worked over 40 in a workweek. The tricky parts are calculating the regular rate correctly and making sure employees are classified properly.
Read answerWhat documents do I need to provide for catch-up bookkeeping?
Bank statements are the foundation. Credit card statements come next. Receipts, invoices, and payroll records help fill in the details, but you don't need perfect documentation to get started.
Read answerDo I need to charge sales tax on services in Virginia?
Virginia generally does not tax most services. The retail sales tax applies mainly to tangible goods, not labor or professional expertise. However, there are exceptions for certain services like accommodations and repair work involving parts.
Read answerWhen should I switch from doing my own books to hiring a bookkeeper?
There's no universal trigger point. The signs are usually falling behind on reconciliation, making recurring errors, or spending hours each month on something that pulls you away from actually running your business.
Read answer
