Shopify Bookkeeping: A Practical Start-to-Finish Guide

You open Shopify and see €10,000 in sales. Then €8,742 reaches the bank. Nothing immediately explains the €1,258 gap, so it is tempting to treat the payout as the “real” sales number or assume money is missing. Usually, neither conclusion is correct: sales and payouts describe different stages of the same activity.

Leafy’s Quick Answer

A Shopify payout can differ from sales because of discounts, refunds, taxes, processing fees, payout timing, reserves, currency conversion, or payments collected elsewhere. Build the sales record first, then reconcile each payment route and payout to the bank. LedgerLeaf turns the recurring Shopify side of that work into reusable sales exports, payout reports, VAT/OSS views, and inventory records instead of another monthly rebuild.

Shopify bookkeeping is the work of connecting those stages: what was sold, what customers paid, what fees or adjustments occurred, what reached the bank, and what still belongs in tax or inventory records. A repeatable month-end process makes that trail easier to follow and easier to hand to an accountant.

The bookkeeping decisions still depend on the business. The recurring operational problem is assembling consistent Shopify evidence for those decisions. That is the job LedgerLeaf is designed to shorten.

This is general bookkeeping information. The appropriate accounts, tax treatment, and filing position depend on the business and jurisdiction.

Why Shopify sales, payments, and payouts are different

The bank deposit is the last page of the story, not the first. Three Shopify figures can appear to describe the same month while answering different questions:

• Sales reports describe order and sales activity, including components such as gross sales, discounts, returns, shipping, and taxes.
• Payments reports describe captured customer payments and refunds across payment methods.
• Payout records describe money moving through Shopify Payments and into your bank after fees and other balance activity.

Shopify explicitly notes that its payout reconciliation report reflects funds received through Shopify Payments, not revenue for accounting purposes. Timing, fees, refunds, reserves, multiple currencies, and third-party gateways can all make a bank deposit differ from sales for the same dates.

The date ranges can differ too. An order might be placed at the end of one month, captured later, and included in a payout after the next month begins. Good bookkeeping explains the difference instead of forcing the figures to match.

Here is one possible route from the image’s €10,000 of gross sales to an €8,742 payout:

The €8,742 payout is not evidence that €1,258 disappeared. The sales figure includes activity that the payout was never meant to mirror exactly. The reconciliation succeeds when every movement has an explanation—not when two unrelated totals are made equal.

1. Set the period before collecting numbers

Start by deciding what “this month” means. Use one reporting boundary and record:

• the bookkeeping period and closing date;
• the store’s reporting time zone;
• the store, payout, and bank currencies;
• every payment gateway and bank account involved;
• whether the books use cash or accrual accounting;
• the export format and fields required by the accountant or bookkeeping process.

Using the same boundary across reports prevents a large class of false discrepancies. Genuine timing differences can then be carried forward and explained rather than mistaken for errors.

2. Build the sales record before looking at the bank

Begin with what happened in the store. For the chosen period, identify:

• gross product sales;
• discounts and returns;
• shipping charged to customers;
• taxes collected;
• gift-card or store-credit activity where relevant;
• order identifiers and payment status;
• product or SKU detail when inventory or cost of goods sold is being reviewed.

Keep tax visible rather than burying it inside revenue. Keep returns and discounts visible rather than replacing gross sales with one unexplained net number. The objective is a sales bridge whose components can be traced back to orders.

This is where LedgerLeaf becomes the starting point for the close. In LedgerLeaf Free, choose the sales columns the bookkeeping process actually needs, export them in CSV or Excel, and save the selection as a reusable profile. The next close then begins with the same sales structure instead of another round of deleting, rearranging, and renaming columns.

Leafy’s Tip

Build the export around its job. An accountant handoff, product analysis, and VAT review should not automatically receive the same columns.

3. Connect payments to payouts and the bank

Shopify’s current payout reconciliation documentation is explicit: its reconciliation report reflects funds received through Shopify Payments and is not a revenue statement for accounting purposes. It can include transactions, fees, refunds, reserves, holds, and other balance activity, while third-party payment methods sit outside it.

For each Shopify Payments payout:

1. Match the payout identifier, currency, and net amount to the bank deposit.
2. Review the charges, refunds, fees, holds, and adjustments behind it.
3. Record timing differences rather than changing the sales record.
4. Investigate missing deposits, duplicated amounts, or unexpected deductions.
5. Reconcile each additional payment gateway separately.

LedgerLeaf Pro brings Shopify Payments payout reporting into the same Shopify-admin workflow as its bookkeeping exports. It is useful here because the task is not merely downloading another file; it is keeping the payout evidence close to the sales data it helps explain.

Leafy’s Watch-Out

Posting the bank deposit directly as sales hides processing fees and collapses several different events into one number. Use the sales record to understand what was sold and the payout record to understand what reached the bank.

4. Review tax without treating it as revenue

Tax collected at checkout may be owed to a tax authority, so it needs to remain distinguishable from sales revenue. Review the period by the registrations, destinations, products, and rates relevant to the store. Refunds, tax-inclusive pricing, exemptions, marketplace collection, and cross-border schemes can all affect the result.

For EU-focused stores, LedgerLeaf Pro provides VAT summaries, transaction exports, country and rate views, quarterly OSS views, and CSV/XLSX tax exports. These views make it easier to spot questionable figures and prepare the evidence an accountant needs without rebuilding the same country-and-rate breakdown each period.

5. Include inventory when products have a cost

For a physical-product business, supplier payments are not automatically the cost of goods sold for the same month. Unsold stock generally remains inventory, while the cost attached to units sold moves into cost of goods sold according to the accounting method used.

Review purchases, customer and supplier returns, damaged or written-off units, transfers, and manual adjustments. Compare the recorded quantities with periodic physical counts rather than quietly overwriting differences.

LedgerLeaf Pro’s inventory snapshots and SKU-based inventory tools help preserve the operational side of that record, particularly when related products or bundles share stock. The accounting treatment still needs the correct product costs, but the close begins from a clearer quantity trail.

6. Finish with a traceable handoff

Before closing the period, check that:

• sales, discounts, returns, shipping, and taxes agree with the chosen period;
• captured payments and refunds are understood by gateway;
• payouts match the bank, including carried timing differences;
• fees and Shopify bills have not disappeared inside net deposits;
• tax and inventory figures have supporting records;
• unusual transactions have been investigated;
• every final figure can be traced to a saved source file.

Then save the exports, payout evidence, tax review, inventory record, and notes in a dated folder. The finished handoff should be understandable without asking someone to reconstruct how the spreadsheet was assembled.

Turn the six checks into a reusable LedgerLeaf close pack

The first month-end close establishes the process. LedgerLeaf makes the Shopify evidence repeatable:

• reuse a Free sales-export profile with the same approved columns;
• use Pro payout reporting to keep the activity bridge beside the sales evidence;
• preserve VAT/OSS views and exports when they apply;
• retain inventory snapshots and SKU records for the period;
• save the resulting files with consistent period and store names.

The memorable connection is practical: LedgerLeaf keeps the Shopify bookkeeping evidence ready to repeat. Free handles customizable CSV and Excel sales exports with saved profiles; Pro adds the payout, VAT/OSS, inventory, and reporting tools that turn those six checks into a more consistent close pack.