Contact Explore tools
E-commerce Tools

Shopify / Stripe Payout Reconciliation Tool

Make every payout add up.

Paste in your payout and transaction exports to see how each deposit breaks down into sales, fees, refunds and adjustments.

  • Every deposit explained
  • Catch problems quickly
  • Cleaner books
Illustrative preview with fictional sample data.
The problem

What it helps you do

Payment processors pay out in batches, net of fees, refunds and chargebacks. Matching those deposits back to individual orders by hand is slow and easy to get wrong.

  • Break each payout into gross sales, fees, refunds and adjustments
  • Find unmatched or unusual transactions quickly
  • Give your bookkeeper a clear, consistent reconciliation
Benefits

What you get with the Shopify / Stripe Payout Reconciliation Tool

The practical difference it makes to how you run the business.

Every deposit explained

Break each payout into sales, fees, refunds and adjustments so your bank statement finally makes sense.

Catch problems quickly

Unmatched or unusual transactions are listed, so missing money and surprise fees don’t go unnoticed.

Cleaner books

Hand your bookkeeper or accountant a consistent monthly reconciliation instead of a pile of exports.

Less month-end chasing

Paste in your exports and let the matching do the work, instead of ticking off transactions by hand.

  • No spreadsheet buildingFormulas, layouts and charts are already set up. You enter your figures; the tool does the maths.
  • Yours to adaptRename categories, change the currency and add rows to fit how your business actually works.
  • One payment, no subscriptionBuy once and keep the file. No monthly fees, logins or software to install.
  • Your data stays with youThe file lives on your computer or in your own Google Drive. We never see your numbers.
Order now — £35 Digital file · emailed within 24 hours of payment

Key features

  • Import area for payout and transaction CSV exports
  • Payout-to-transaction matching
  • Fee, refund and chargeback breakdown
  • Unmatched items list
  • Monthly reconciliation summary

What’s included

  • Excel workbook (.xlsx)
  • Google Sheets version (make-a-copy link)
  • Quick-start guide (PDF)

Files are delivered digitally. No physical item is shipped.

Compatibility

Microsoft Excel
Desktop version for Windows or Mac (Microsoft 365 recommended).
Google Sheets
Free with a Google account. Works in any modern browser.
Not recommended
Apple Numbers, LibreOffice and mobile apps may not display every feature correctly.
Software not included
This is a template file. We don’t sell or include Excel, Google Sheets or any software licence — use your own.
Language & currency
English. Currency symbol can be changed in Settings.
How it works

From checkout to your first report.

  1. 1

    Order

    Place your order and pay through the secure payment link we send you.

  2. 2

    Receive

    We email your files within 24 hours of payment.

  3. 3

    Open

    Open the Excel file, or use the Google Sheets link to make your own copy.

  4. 4

    Enter your figures

    Add your data in the input tabs. The dashboard updates automatically.

Preview

What the dashboard is designed to show

An illustrative layout with fictional sample data.

Illustrative preview with fictional sample data.
Who it’s for

Built for

If you recognise yourself here, this tool is designed around the way you work.

  • Shopify store owners
  • Businesses taking card payments through Stripe
  • Bookkeepers working with online sellers
FAQ

Questions about this tool

What are digital products?

Our products are downloadable files — Excel workbooks and Google Sheets templates — rather than physical items. Nothing is posted to you. After purchase you receive access to the files online.

Do you sell Microsoft Excel, Google Sheets or any software licence?

No. We only sell template files — spreadsheets you open in software you already have. We don’t sell, resell or include Microsoft Excel, Microsoft 365, Google Workspace or any other software, licence, product key or subscription. To use our files you need your own copy of Excel or a free Google account.

How will I receive my purchase?

We send your files by email within 24 hours of your payment being confirmed — usually much sooner. You’ll receive the Excel file and, where included, a Google Sheets link that creates your own private copy. Check your spam folder if you don’t see it, or contact us.

What software do I need?

You need Microsoft Excel (desktop) or a free Google account to use Google Sheets. Each product page lists the exact compatibility for that tool. We don’t sell software licences — you use your own copy of Excel or Google Sheets.

Can I customise the tools?

Yes. You can rename categories, add rows, change labels and adjust colours. Core calculation areas are clearly marked so you can see what to edit and what to leave alone. Changes to formulas are at your own discretion.

Can I share the files with other people?

You can share the files with people inside your own business who work with you. You may not resell, redistribute, publish or give away the files or modified versions of them. See our Terms & Conditions for the full licence.

Refund policy

If your file is faulty, won’t open, or isn’t as described, contact us within 14 days of purchase. We’ll fix or replace it, or refund you if we can’t. Because digital files can be kept once downloaded, change-of-mind refunds aren’t normally available once the files have been sent to you. Your statutory rights are not affected.

Read the full Refund Policy

Related tools

Make every payout add up.

Paste in your payout and transaction exports to see how each deposit breaks down into sales, fees, refunds and adjustments.

Get the tool See what’s included
Shopify / Stripe Payout Reconciliation Tool £35 GBP · Excel + Google Sheets
Order now