60-second Shopify reconciliation walkthrough

Watch one Shopify payout become a balanced accounting entry.

This illustrative walkthrough follows 142 sample orders from gross sales through discounts, refunds, chargebacks and fees to the exact bank deposit.

Duration: 59 secondsIllustrative sample data · Captions included

What the walkthrough demonstrates

The bank receives the net payout. The books still need the complete story.

The sample store reports just over $21,000 in sales, while $18,613.94 reaches the bank. The difference is not treated as unexplained missing cash. It is traced to the individual categories that changed the settlement amount.

1. Start with gross activity

Orders establish the sales, discounts, refunds and other customer activity. Recording only the bank deposit would omit the detail needed to understand revenue and margins.

2. Identify payout adjustments

Processing fees, platform fees, chargebacks and other adjustments are assigned to the intended accounts rather than being buried inside a net deposit.

3. Create one balanced settlement entry

The workflow combines the approved categories into a balanced entry and transfers the exact net amount from the processor balance to the bank.

4. Match the deposit

The accounting deposit equals the amount received by the bank, while the supporting entry preserves the gross sales and deductions behind it. In the sample, the remaining difference is exactly zero.

Does your real payout still differ?

Run the free diagnostic to identify the strongest workflow signals before you change another rule or journal entry.

Run the diagnostic →

Video transcript

One payout. A hundred and forty-two orders. And a whole lot happening beneath the surface. For North and Pine, Shopify shows just over twenty-one thousand dollars in sales. But only eighteen thousand, six hundred thirteen dollars and ninety-four cents reached the bank. That gap isn't missing money. It's discounts, refunds, chargebacks, processing fees, and platform fees. LZ Books finds every adjustment, then sends each amount to the right account automatically. From there, it creates one clean, balanced journal entry and matches the payout to the bank deposit. The difference? Exactly zero. So instead of spending your weekend piecing together spreadsheets, you open your books and everything is already current, reconciled, and ready for your accountant. That's bookkeeping that runs quietly in the background, while you focus on growing the business.

Continue with the details

Shopify + QuickBooks reconciliationSee the complete accounting workflow.Why payouts do not matchWork through the common causes.Reconciliation setup serviceReview scope, fit and transparent pricing.