What your accountant should review before posting Shopify payouts

The short answer

Before a Shopify payout reaches QuickBooks, your accountant should confirm that Shopify supplied every transaction, the component total equals the completed payout, and each component is mapped to the right account and tax treatment. They should also confirm the posting date and check whether the payout belongs in the bank or Shopify clearing.

The first review is about the accounting design. Later reviews should focus on changes and exceptions: a new transaction type, unusual refund, tax difference, gift-card event, fee credit, foreign currency or unexplained clearing balance. That is more useful than asking an accountant to click Approve on identical clean payouts all month.

Posting is not the final control. The journal must be read back from QuickBooks, the deposit must match the bank, and the period must remain open long enough to catch late evidence. Approval means the proposal is acceptable; verification proves what actually happened.

Decide who owns the Shopify accounting

Start by listing every app, manual process and bookkeeper that creates Shopify-related entries. If one connector posts orders and another posts payout summaries containing the same sales, the books can be duplicated even when both systems behave exactly as configured.

Choose one owner for each category. A per-order connector might own sales and customer payments while a payout workflow adds only missing fees and settlement movements. Alternatively, a payout-summary workflow can own sales, refunds, fees and tax for the period. Document the boundary before testing.

Also list PayPal, Klarna, Amazon Pay and other gateways. Shopify Payments payouts do not settle those providers. Each gateway needs its own posting and bank-matching trail when it controls customer money separately.

Check that the payout evidence is complete

Use a completed Shopify Payments payout, not a pending estimate. Open its detail and retain the payout ID, date, currency, destination account, status, gross activity, fees and net amount. Export transaction rows when the detail is too large to inspect on screen.

The imported rows should add exactly to the provider's payout amount using their authoritative signs. Missing pagination, a truncated export or an unknown future transaction type must block posting. A close number is not complete evidence.

Shopify's Payout Reconciliation Report supports a period-level review of opening balance, activity, payouts and ending balance. Shopify notes that this report can have a data delay, so record the generation time and refresh it before finalising the month.

• Completed payout status
• Payout ID and destination account
• Settlement currency
• Complete transaction pagination
• Exact gross, fee and net arithmetic
• Known treatment for every transaction type
• Order or source references where required
• Period opening and closing provider balances

Review the accounting date

A payout can contain orders, refunds and fees from several dates. Under payout-date bookkeeping, an approved summary is posted on the payout date. Under source-date accrual accounting, activity belongs to its source period and the later payout clears the provider balance.

Your accountant should approve one method and document it. Do not alternate based on which date makes the month easier to close. A consistent method is especially important around month-end, when a late payout can settle sales from the previous period.

Tax can have its own tax-point rules. The payout date should not replace line-level VAT, sales tax or GST evidence. Confirm that the posting method preserves the date and tax code required by the merchant's jurisdiction and approved scheme.

Review every material payout component

Confirm mappings are type-safe

An account name is not enough. Shopify clearing should be a suitable balance-sheet account, not income. Sales should reach an approved revenue account. Processing fees normally belong to an expense account. Tax must reach the approved liability or localized QuickBooks tax workflow.

If a mapped QuickBooks account was deleted, made inactive or changed type, pause posting. Reusing a familiar account name after its accounting purpose changed can produce a plausible-looking journal that damages the balance sheet.

Keep mappings simple enough to review. A merchant rarely needs one revenue account for every SKU, but it may need separate accounts for wholesale, shipping or material product classes. The structure should answer useful management and tax questions without creating hundreds of fragile mappings.

Worked review: a $12,408 payout

Assume a completed US payout contains $13,200 of gross sales, $440 of refunds, $264 of processing fees and $88 of dispute activity. The expected payout is $12,408: $13,200 less $440, $264 and $88.

The accountant confirms that sales tax included in the orders is separated from revenue, the refund reverses its tax component, and the dispute amount is supported by a named case. The fee maps to payment-processing expense and the net amount clears Shopify clearing.

The proposed journal balances, but the review is not finished. The accountant checks that no order connector already posted the $13,200, confirms the payout's bank destination, and verifies that the QuickBooks period is open. After posting, the system reads the journal back and matches the $12,408 bank deposit.

Treat tax as a separate review

Shopify's tax amount should be preserved from the source order or report. Do not calculate a fresh percentage from the payout because the payout can combine rates, exemptions, refunds and marketplace-remitted amounts.

For US sales tax, review merchant liability separately from tax filed by a marketplace. For UK VAT and other localized regimes, confirm the approved QuickBooks tax codes and tax point. A generic tax liability journal may not populate the statutory return correctly.

Reconcile collected and refunded tax for the period, not only the tax inside one payout. Keep registrations, agency allocation, returns and payments in the month-end evidence. The accountant should approve any tax adjustment with a precise reason.

Review COGS separately from the payout

The payout shows customer money, not the cost of products sold. If the merchant records COGS, use the cost effective on the sale date and tie returns to the original sale and restock evidence.

Post COGS in a separate balanced entry between inventory asset and cost of goods sold. That keeps product margin visible and prevents fee deductions from being mistaken for product cost.

Missing or ambiguous SKU cost should block the COGS result without inventing a percentage. The payout can still be reconstructed for review, but the month should show that gross profit is incomplete until the cost exception is resolved or explicitly handled.

Approve, post, verify and match are four controls

1. Prepare the proposed payout and COGS entries from complete Shopify evidence.
2. Have the authorised reviewer approve the accounting treatment and mappings.
3. Post with a stable document number so a timeout cannot create a duplicate retry.
4. Read the created journal back from QuickBooks and compare every line, account, amount and date.
5. Match the recorded payout to the downloaded bank deposit when it arrives.
6. Keep any bank-pending payout visible instead of calling it reconciled early.

A posting API can time out after QuickBooks has already created the journal. Search by the stable document number before retrying. Idempotency is an accounting control because it prevents one network failure from doubling revenue.

What should be reviewed every month

Review new transaction types, mapping changes, failed posts, journal drift, unmatched deposits, clearing balances, tax exceptions, missing COGS and late payouts every month. A clean routine payout does not need the same manual effort as an exception.

At period end, reconcile the Shopify Payments opening balance, activity, payouts and ending balance. The ending clearing amount should tie to named pending payouts, reserves or supported differences. Old unexplained balances should not roll forward as normal.

Review access and approvals too. Preparers can assemble evidence, but completing or reopening a close should require the authorised role. Preserve who approved, posted and changed each decision.

• All completed payouts imported
• No unknown transaction types
• No duplicated accounting owner
• All required mappings active and compatible
• Every posted journal verified in QuickBooks
• Completed deposits bank matched
• Clearing balance explained by name
• Tax and COGS exceptions reviewed
• Late activity assessed before locking the period

When the accountant should stop the posting

Stop when the payout is not completed, the source export is incomplete, or one transaction type has no approved accounting treatment. Also stop when the proposed bank differs from Shopify's destination, the QuickBooks period is closed, or another connector may already own the sales.

A tax amount without the required jurisdiction or VAT-code evidence is another stop. So is a clearing balance that only works after adding an unexplained adjustment. Blocking one payout is cheaper than reversing a batch of plausible entries after the return or month has been signed off.

Record a useful exception: what failed, which source IDs are affected, what evidence is needed and who owns the next action. Avoid messages such as 'journal error' that force the merchant and accountant to repeat the investigation from the beginning.

How Vatteo changes the accountant's job

Vatteo reconstructs Shopify Payments payouts, preserves source IDs, blocks incomplete evidence and proposes type-safe QuickBooks entries. It separates preparation, approval, posting, read-back verification and bank matching so one status cannot stand in for all five controls.

Accountants approve the policy and concentrate on exceptions. Merchants can see why a payout is blocked and what evidence is missing instead of emailing spreadsheets back and forth. Clean mappings and verified history can later support controlled automatic posting without removing review gates.

For Shopify Payments and QuickBooks Online, Vatteo is the strongest operating layer between raw settlement data and a signed-off month. It keeps payout arithmetic, tax, COGS, mappings, QuickBooks results and close evidence in one review path.

The pre-post checklist

1. Confirm one accounting owner for every Shopify category and gateway.
2. Use a completed payout with all source rows and known transaction types.
3. Recalculate the exact gross-to-net payout total.
4. Confirm the accounting date and period are correct and open.
5. Review tax, refunds, fees, gift cards, disputes and adjustments.
6. Confirm every mapping is active, compatible and approved.
7. Review COGS evidence separately when enabled.
8. Approve the proposal with a named reviewer and recorded decision.
9. Post once, read the journal back, then match the bank deposit.
10. Keep the full evidence pack with the monthly close.