Shopify Finance Reports Unpacked: Bridging Sales, Payments, and Payouts for Clear Books

Ever stare at your Shopify finance reports, seeing three different numbers for what feels like the same thing, and wonder if your eyes are playing tricks on you? You’re not alone. This is a super common pain point, and it’s exactly what a recent discussion in the Shopify community tackled head-on. Our fellow store owner, Janglo, kicked off the thread, expressing the frustration of trying to reconcile sales, payments, and payouts, especially when dealing with deposits and orders that take weeks to complete.

Janglo’s situation is pretty relatable: Shopify records a sale and applies VAT the moment any partial payment is received, even if the order isn't fully paid or fulfilled. This creates a headache, making the daily Finance Summary report feel inaccurate and year-end reconciliation a nightmare. Shopify’s suggestion to use draft orders didn’t help, as they convert to sales upon payment anyway. So, what’s the secret to making sense of it all?

Why Your Shopify Numbers Don't Match (And It's Not a Bug!)

The core of the issue, as Report_Pundit1 expertly laid out in the community discussion, isn't that any figure is wrong; it’s that they’re looking at different things based on different dates. Think of it like this:

  • Sales (Finance Summary): This is the full order value, recorded by the day the order was placed.
  • Payments (by gateway): This is the money the customer actually paid, recorded by the day they paid.
  • Payouts: This is the money reaching your bank account after fees, recorded by the day Shopify paid you.

See the problem? With deposits and extended payment terms, one order can easily span sales in one month, payments across two, and payouts hitting your bank even later. They all need a "bridge" to connect them.

Your Essential Reconciliation Toolkit: The Reports You Need

To build these bridges, you’ll need a few key reports. Report_Pundit1 highlighted these as crucial, and they can all be scheduled to a Google Sheet for easier matching:

  1. Payment Transaction Export: This is your holy grail for payments. It details every single payment with the order number, date, gateway, amount, and status. It’s the foundation for your payments figure.
  2. Tax Report: Provides each order’s total and VAT, which is essential for calculating VAT per payment.
  3. Payout Order Report: This links individual payments to specific payouts, showing associated fees and the net amount.
  4. Shopify Payout Report: This offers a single line per payout and should directly match what hits your bank statement.

A quick note: If you’re using other gateways like PayPal or Stripe, remember their payouts aren’t part of Shopify Payments. You’ll need to use their own reconciliation reports for those.

Building the Bridges: Step-by-Step Reconciliation

Let’s walk through the reconciliation process, using a simplified example from the thread, to connect those dots. Imagine a scenario at a December 31st year-end, with 20% VAT and 2% fees:

  • #1001: Placed 10 Dec, £1,200 (VAT £200). £360 deposit 10 Dec, £840 balance 15 Jan.
  • #1002: Placed 18 Nov, £600 (VAT £100). £150 deposit 18 Nov, £450 balance 12 Dec.
  • #1003: Placed 30 Dec, £240 (VAT £40). Paid in full 30 Dec.

1. Bridging Sales to Payments

This bridge adjusts your total sales to reflect the actual payments received within your chosen period.

Bridge Amount
December sales (#1001 + #1003) £1,440
Less: balance still due on #1001 −£840
Add: balance received on #1002 +£450
December payments (£360 + £450 + £240) £1,050

2. Bridging VAT to Payments (Crucial for Deposit Workflows)

This is where things get interesting for store owners like Janglo, who deal with deposits and need to account for VAT only when payment is received. As takisoft and Report_Pundit1 pointed out, you can calculate VAT per payment:

VAT on payment = (payment ÷ order total) × order VAT

Bridge Amount
VAT per sales report (#1001 + #1003) £240
Less: VAT on #1001’s unpaid balance (840 ÷ 1,200 × £200) −£140
Add: VAT on #1002’s balance (450 ÷ 600 × £100) +£75
VAT on December payments (£60 + £75 + £40) £175

This method ensures that over an order’s full lifecycle, the total VAT agrees. For example, #1001 carries £60 in December and £140 in January, totaling its £200. Remember, it’s always best to check this per-payment VAT method with your accountant before using it for official returns, as VAT treatment of deposits can vary based on your specific circumstances.

3. Bridging Payments to Your Bank Account

Finally, we connect the payments received to the money that actually lands in your bank, accounting for fees and payout timing.

  • Payouts: 12 Dec £352.80 (#1001 deposit), 15 Dec £441.00 (#1002 balance), 2 Jan £235.20 (#1003).
  • Fees: £7.20, £9.00 and £4.80.
Bridge Amount
December payments £1,050.00
Less: fees on December payouts (£7.20 + £9.00) −£16.20
Less: paid 30 Dec, paid out in January (#1003) −£240.00
December payouts £793.80

This final figure should align perfectly with your Shopify Payout Report and, ultimately, your bank statement. Don't forget, refunds, chargebacks, and adjustments will appear as separate lines in your payout reports and should be factored in similarly.

Year-End & Ongoing Checks

For year-end clarity, you’ll want to carry forward specific figures:

  • Customer balances due: For our example, £840 (#1001), with £140 of VAT not yet paid. You can get this by running the Payment Transaction Export up to your year-end date: order total − payments to date + refunds to date.
  • Money in transit from Shopify: £235.20 net (#1003), which arrived in January.
  • Fees for the year: Gather these from your payout reports, not your sales report.

To keep things tidy month-to-month, Report_Pundit1 suggested a helpful check: opening balances due + new orders − payments received + refunds = closing balances due. If that equation balances out, you know you’re fully reconciled.

Ibrahim132 also chimed in, suggesting the Net payments by order report (under Analytics → Reports) as a great starting point, as it shows payment activity for a selected period, including payments against orders created earlier. This is especially useful for tracking deposits and final payments against a single Shopify order, which Janglo confirmed was their setup. It helps you see each order’s full value, deposits, subsequent payments, refunds, and that all-important outstanding balance as of your year-end date.

It’s clear from this community discussion that while Shopify provides a ton of data, understanding how to connect the dots between sales, payments, and payouts—especially with complex workflows like deposits—is key to accurate financial reporting. Taking the time to set up these reconciliation bridges can save you immense headaches, particularly as you approach tax time. If you’re looking to get started on Shopify or refine your existing store’s financial processes, understanding these reports is a fundamental step. And if you're thinking about diving into the world of e-commerce, starting your Shopify store with a solid grasp of its financial reporting will put you miles ahead.

Share:

Start with the tools

Explore migration tools

See options, compare methods, and pick the path that fits your store.

Explore migration tools