AR Accounting Hub · Bookkeeping, finance operations & automationU.S. & UK businesses
Free template

Free Shopify payout vs bank reconciliation template

Find out why your Shopify sales and bank deposits never match, without doing it by hand.

Match every Shopify payout to your bank in minutes

Shopify pays out sales after fees, refunds, chargebacks and adjustments, and a payout can land in your bank one to three days later. That is why your sales report and your bank never agree. This free spreadsheet does the matching for you.

  • Paste your Shopify payout export and your bank CSV
  • Each payout is matched to a deposit and marked matched, bank short / over or in transit
  • A summary shows sales, refunds, fees, adjustments and a check cell that must read 0.00
  • Works in Google Sheets and Excel 365, with sample data so you can see it work first

Get the free template

We email it to you straight away.

We email you the template and may follow up once. No spam; unsubscribe any time. Privacy

See it in action

A demo store sold $23,488 in September; $20,065 reached the bank. The reconciler explained every dollar: $830 in fees, a $15 dispute fee nobody booked and $2,354 still in transit. Read the full walkthrough →

Want us to check your numbers?

A $149 Books Health Check compares your payouts with your bank and gives you a fixed quote to fix the gaps.

Book a Health Check