Skip to main content

PennyWise

Calendly Book a Meeting
Email

info@pennywiseusa.com

Short answer: A2X for Shopify reads your Shopify payouts and posts one summary per payout to QuickBooks Online, with sales, discounts, shipping, refunds, gift cards, fees and taxes on separate lines. You then match each summary to the Shopify Payments (or PayPal) deposit in your bank feed. The big difference from Amazon: Shopify does not remit sales tax for you, so the tax A2X records is a liability you still owe.

Why Shopify payouts don’t match your sales

Shopify Payments deposits your orders minus processing fees, refunds and chargebacks, often several days of orders in one payout. Orders paid through PayPal, Shop Pay Installments or other gateways arrive separately. If you record only the deposits, your sales, fees and refunds are all wrong.

Setting up A2X for Shopify, step by step

  1. Connect Shopify to A2X. Install the A2X app from the Shopify App Store and approve access.
  2. Connect A2X to QuickBooks Online. Sign in to QuickBooks and authorize the connection.
  3. Map your accounts. Give each transaction type its own account: Shopify Sales, Discounts, Shipping Income, Refunds, Gift Card Liability, Shopify Fees, and a clearing account for each payment gateway.
  4. Set up each payment gateway. Shopify Payments, PayPal and other gateways each settle differently. A2X tracks them separately so each deposit can be matched.
  5. Map sales tax as a liability. Sales tax collected through Shopify goes to a Sales Tax Payable account, not income.
  6. Add product costs for COGS (optional, recommended) so cost of goods sold is posted with each payout.
  7. Choose a start date and make sure no other app or bank-feed rule is also recording Shopify income.
  8. Post payouts and match deposits. Send each payout summary to QuickBooks, then match it to the deposit in your bank feed.

Gift cards, PayPal and other gotchas

  • Gift cards: selling one isn’t revenue yet. It’s a liability until the customer redeems it.
  • PayPal: PayPal orders sit in your PayPal balance until you transfer them, so PayPal needs its own clearing account.
  • Chargebacks: record disputed amounts and fees so your clearing account still balances.
  • Selling on Amazon too: A2X for Amazon is a separate connection with its own settings. See how to set up A2X for Amazon and QuickBooks.

Sales tax: Shopify is not Amazon

On Amazon and most marketplaces, the marketplace collects and remits sales tax for you. On your own Shopify store, you are responsible: tax collected is money you owe to each state where you’re registered. Keep it in a liability account, and file and pay on time through your CPA or a sales tax service. (We record it; we don’t file returns.)

Monthly checklist

  • Every payout posted and matched to its deposit.
  • Gateway clearing accounts close to zero, except payouts still in transit.
  • Gift card liability matches Shopify’s outstanding gift card report.
  • Sales tax payable matches what you collected.
  • Bank and card accounts reconciled.

Selling on several channels? See our e-commerce bookkeeping services.

Want this done for you?

PennyWise is an A2X Certified, QuickBooks ProAdvisor bookkeeping team for US sellers. We reconcile every settlement, record cost of goods sold and send your P&L by the 10th of each month. See our Amazon FBA bookkeeping service or start with a free QuickBooks Health Check.

Leave a Reply

Your email address will not be published. Required fields are marked *