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 records do I need to keep for the IRS?
Keep documentation for all income and expenses reported on your tax return. This includes bank statements, receipts, invoices, payroll records, and asset purchase documentation.
Read answerDo I need to send 1099s to all my subcontractors?
Not every subcontractor needs a 1099. The $600 threshold, corporate status, and payment method all determine who gets one. Collect W-9s from subs before paying them so you have the information you need at tax time.
Read answerHow do I manage cash flow when customers pay in stages?
Structure deposits to cover your initial costs, invoice the same day you hit milestones, and track billed versus received separately. A cash reserve covers the inevitable gaps between completing work and getting paid.
Read answerWhat's the Virginia unemployment tax rate for new employers?
New employers in Virginia typically pay 2.5% on the first $8,000 of each employee's wages annually. After you build employment history over a few years, your rate becomes experience-based and can drop significantly if you have few unemployment claims.
Read answerWhich QuickBooks plan is right for my small business?
The right plan depends on user count, inventory needs, and whether you track project costs. Most small businesses do fine with Simple Start or Essentials. Plus is worth it only if you manage inventory or need job-level profitability.
Read answerShould my restaurant use cash or accrual accounting?
Most small restaurants do well with cash accounting. It's simpler, matches cash flow reality, and the IRS allows it for businesses under $29 million in annual revenue.
Read answer
