Reconciliation Guide
How to reconcile Shopify payouts with LedgerBridge
LedgerBridge posts a balanced journal entry for every Shopify payout. This guide explains what happens after the journal entry is posted, and how to complete the reconciliation in your accounting platform.
The steps differ depending on your posting method (clearing account vs. bank account) and your accounting platform (Zoho Books, QuickBooks Online, or Xero).
Understanding the journal entry
Each journal entry LedgerBridge creates contains line items for every component of the payout:
- Gross sales (credit) — Revenue before discounts, shipping, and taxes
- Processing fees (debit) — Card processing fees charged by Shopify Payments
- Returns & refunds (debit) — Amounts returned to customers
- Taxes collected (credit) — Sales tax, VAT, or GST collected at checkout
- Shipping income (credit) — Shipping charges collected from customers
- Discounts (debit) — Discount amounts applied to orders
- Shopify payout (debit) — The net deposit amount going to your bank or clearing account
The entry always balances: total debits equal total credits. The Shopify payout line is the balancing amount — it equals the net deposit Shopify sends to your bank.
Additional line items
Depending on your store's activity, you may also see:
- Shopify fees — Platform fees beyond processing
- Refund fees — Fees retained when processing refunds
- Gift card sales — Liability created when gift cards are sold
- Gift card payments — Liability relieved when gift cards are redeemed
- Reserves held / released — Funds held back or released by Shopify
- Capital repayment — Shopify Capital deductions
- Custom transaction types — Shipping labels, chargebacks, billing charges, and other types you've mapped in the Account Mappings page
Posting method: Clearing account
With the clearing account method, LedgerBridge posts the payout amount to an intermediate clearing account (e.g., "Shopify Payout Clearing"). When the actual bank deposit arrives, you record a transfer from the clearing account to your bank account. This zeroes out the clearing account and completes the reconciliation.
Example: $950 payout
Your store made $1,000 in sales with $50 in processing fees. Shopify pays out $950. LedgerBridge posts this journal entry:
| Account | Debit | Credit |
|---|---|---|
| Revenue (Gross Sales) | $1,000.00 | |
| Processing Fees | $50.00 | |
| Shopify Payout Clearing | $950.00 |
One to two business days later, $950 appears in your bank account. You record a transfer from the clearing account to the bank account — the clearing balance returns to zero, and the payout is fully reconciled.
Why use a clearing account?
- The journal entry and the bank deposit are separate events — the clearing account bridges them
- Easier to spot discrepancies: if the clearing account doesn't zero out, something needs attention
- Recommended for most merchants, especially those with an accountant or bookkeeper
Zoho Books — Clearing account steps
- LedgerBridge posts the journal entry. The Shopify payout line debits your clearing account (e.g., "Shopify Payout Clearing").
- When the bank deposit appears in your bank feed, go to Banking in the left sidebar.
- Select the bank account that received the deposit.
- Find the Shopify deposit transaction in the statement lines.
- Click the transaction, then select Transfer Funds.
- Set the "From" account to your clearing account (e.g., "Shopify Payout Clearing").
- Confirm the amount matches and save.
- The clearing account should now show a zero balance for that payout.
QuickBooks Online — Clearing account steps Coming soon
- LedgerBridge posts the journal entry. The Shopify payout line debits your clearing account.
- When the bank deposit appears in your bank feed, go to Banking (or Transactions > Bank transactions).
- Find the Shopify deposit in the "For Review" tab.
- Click the transaction, then select Record as transfer.
- Set the transfer account to your clearing account.
- Confirm the amount matches and save.
- The clearing account balance should net to zero for that payout.
Xero — Clearing account steps Coming soon
- LedgerBridge posts the manual journal. The Shopify payout line debits your clearing account.
- When the bank deposit appears in your bank feed, go to Accounting > Bank accounts.
- Click on the bank account that received the deposit.
- Find the Shopify deposit in the statement lines.
- Click Transfer and select the clearing account as the source.
- Confirm the amount and reconcile.
- The clearing account should zero out for that payout.
Posting method: Bank account
With the bank account method, LedgerBridge posts the payout amount directly to your bank account. When the actual bank deposit arrives, you match it to the existing journal entry. There's no intermediate account.
Why use bank account posting?
- Simpler — one fewer account to manage
- Works well when deposits and payouts arrive on predictable schedules
- Best for merchants who do their own bookkeeping and prefer fewer steps
Zoho Books — Bank account steps
- LedgerBridge posts the journal entry. The Shopify payout line debits your bank account directly.
- When the bank deposit appears in your bank feed, go to Banking.
- Select the bank account.
- Find the Shopify deposit transaction.
- Click the transaction. Zoho should suggest matching it to the journal entry based on the amount and date.
- Select Match and confirm.
- The transaction is now reconciled.
QuickBooks Online — Bank account steps Coming soon
- LedgerBridge posts the journal entry. The Shopify payout line debits your bank account directly.
- When the bank deposit appears in your bank feed, go to Banking.
- Find the Shopify deposit in the "For Review" tab.
- QBO should suggest a match to the existing journal entry. If it does, click Match.
- If no match is suggested, click the transaction, select Find match, and search by amount or date.
- Select the journal entry and confirm.
Xero — Bank account steps Coming soon
- LedgerBridge posts the manual journal. The Shopify payout line debits your bank account directly.
- When the bank deposit appears in your bank feed, go to Accounting > Bank accounts.
- Click the bank account.
- Find the Shopify deposit. Xero should suggest matching it to the journal.
- Click OK to reconcile.
- If no match is suggested, click Find & Match and search by amount.
Month-end splitting
When a Shopify payout includes transactions from two calendar months (e.g., sales from March 28-31 and April 1-2), LedgerBridge splits them into separate journal entries — one for each month. This keeps your monthly revenue, fees, and tax figures accurate.
You'll see two entries with reference numbers like PAYOUT-12345-2026-03 and PAYOUT-12345-2026-04. Each entry's payout line represents that month's portion of the total deposit. Reconcile each month's entry against the corresponding portion, or reconcile the total deposit against both entries together.
Refunds
Refunds are booked from the exact Shopify refund that paid them out, not guessed from a matching amount. LedgerBridge reverses the tax a refund returned — including shipping tax — and keeps the books balanced.
Example: $11 shipping-only refund
A customer is refunded $11 for shipping: $10 shipping and $1 shipping tax, paid back to their card. Within the payout's journal entry, this refund contributes:
| Account | Debit | Credit |
|---|---|---|
| Returns & Refunds | $10.00 | |
| Taxes Collected | $1.00 | |
| Shopify Payout Clearing | $11.00 |
Gift-card refunds
Refunding a gift-card product — a sale of a gift card, not a payment made with one — reduces the Gift Card Sales liability instead of revenue. The sale was never revenue in the first place, so reversing it doesn't touch Returns & Refunds.
Split refunds: card and gift card
A refund can be paid back partly to the original card and partly onto a gift card. Only the card part shows up in a Shopify payout — LedgerBridge also restores the gift-card balance and books the full contra-revenue once, in the first payout LedgerBridge books for it.
Example: a $100 refund (no tax on this refund) pays $20 back to the card and $80 onto a gift card. The payout carrying the $20 card refund books:
| Account | Debit | Credit |
|---|---|---|
| Returns & Refunds | $100.00 | |
| Gift Card Payments | $80.00 | |
| Shopify Payout Clearing | $20.00 |
Split refunds: several cards, several payouts
A refund can also be paid back to more than one card, and each card's portion can land in a different Shopify payout. Each payout books only its own share of the refund; together, every payout carrying part of the refund adds up to the full refund exactly once.
When a payout is held
LedgerBridge never guesses. If it can't be certain how to book part of a payout, it holds the whole payout — nothing is posted — and shows the reason in Activity.
Why a payout is held
- A refund isn't linked to a Shopify refund LedgerBridge can find
- A refund is still pending, or failed, at Shopify
- A refund where one payment attempt failed, even if a later one succeeded
- A refund was paid through a method LedgerBridge doesn't book
- The refund or order amounts don't add up
- A refund includes a restocking fee, or an adjustment that carries tax
- The refund includes duties or customs charges
- An order's currency is different from the payout's currency
- An order has more data (line items, refunds, or transactions) than LedgerBridge reads
Releasing a held payout
Open the order or refund in Shopify and confirm the amounts, payment method and status match what you expect. Some causes resolve once Shopify finishes processing, for example a refund that is still pending. Even then, the payout stays held until you choose Retry sync on the Activity page. Syncing the payout again from the dashboard's "Sync a specific payout", or running a backfill, does not release it. If the cause can't change (duties or customs, a refund payment that failed, a payment method LedgerBridge doesn't book, or a currency different from the payout), choose Skip payout and record it yourself.
Skip, Delete and Retry
From a payout's row in Activity, you can choose Skip payout, Delete posted entry, or Retry sync, depending on its state.
Skip payout
You'll post this payout yourself — LedgerBridge won't post it. Activity shows whether a payout owns any order's tax or a refund's shared part. If it does, your manual entry must include those lines.
Delete posted entry
Removes LedgerBridge's entries from Zoho Books, but keeps the record so Retry sync can post again. Until you choose Retry sync, the lines this payout booked, including any order tax or refund share it owned, are missing from your books.
Retry sync
For a held payout, LedgerBridge reads Shopify again and posts the payout if everything now adds up. After you delete a posted entry, it posts the same figures again.
Orders paid in more than one payout
An order's payment can be captured across more than one Shopify payout. The first payout LedgerBridge books for an order books its tax, shipping, and discounts; every later payout carrying part of the same order books only the revenue it captures.
Order edits after posting
If you edit an order after LedgerBridge has posted its payout, the posted journal entry is not re-booked. It reflects the order as it stood when it was first posted.
What payouts can't show
A refund returned entirely to a gift card, or through a payment method other than Shopify Payments, never appears in a Shopify Payments payout — so LedgerBridge can't see it and can't book it. Record refunds like these directly in Zoho Books.
Troubleshooting
The clearing account doesn't zero out
This means either the journal entry amount doesn't match the bank deposit, or the transfer wasn't recorded. Check the journal entry in LedgerBridge's Activity page and compare the payout amount to the bank deposit. Small differences (under $0.02) are rounding and are handled automatically.
The bank feed doesn't suggest a match
This usually happens when the deposit date differs from the journal entry date by more than a few days. Use the "Find match" or manual search feature in your accounting platform and search by amount.
I see unexpected amounts in the Adjustments line
Adjustments captures transaction types that aren't mapped to a specific account. Go to Account Mappings in LedgerBridge and check the "Your transaction types" section — you may have unmapped types that can be assigned to more specific accounts.