How to Reconcile Shop Pay Installments

Start with the captured order

For a merchant, the useful starting point is the Shopify order and its payment status, not the customer's future installment dates. Shopify's Shop Pay Installments FAQ says that after you capture the payment, you receive full payment within one to three business days, excluding the fee incurred for using Shop Pay Installments. Affirm is responsible for collecting installment payments from the customer, and the payout goes to the same bank account used for Shopify Payments.

That makes the customer's repayment schedule a poor substitute for your payout reconciliation. Capture, settlement, and bank receipt are the merchant-side events to trace. Record the order ID, capture date and time, payout currency, payout ID when available, gross captured amount, fee line, and any later refund or dispute.

Build an order-to-payout match

Export or review the Shop Pay Installments transactions in the Shopify Payments payout detail, then match them to orders and the bank deposit. Keep Shop Pay Installments identifiable instead of merging it into a vague sales total. The Shopify Payments activity report can group charges, refunds, disputes, and fees, but it is a balance-activity report rather than a revenue statement.

A practical review has three tests: every captured order appears in a transaction or payout detail; each fee is supported by the provider record; and every bank deposit is explained by one or more payout records. If dates do not line up, use capture and payout timestamps and document settlement timing. Do not make a new revenue entry when the deposit clears.

• Filter by the payment method and payout currency before totaling.
• Keep full, partial, and canceled or failed payment states separate from captured payments.
• Carry any pending, held, or disputed amount as an open item until its status changes.

Refunds and disputes need their own trail

Shopify's FAQ says the Shop Pay Installments transaction fee is not returned when you issue a refund. That is a provider-specific fact to check against the transaction detail, not a reason to assume every payment method behaves the same way. A refund reduces customer consideration; the fee treatment should remain visible rather than being silently netted into sales.

A dispute is not necessarily a final loss on the day it appears. For a Shop Pay Installments dispute, Affirm emails the Shopify store owner; the FAQ says the owner has 15 days to reply with evidence, and Affirm resolves the dispute within another 15 days. Disputed funds are held during that period. If the decision favors the merchant, funds are released back to the bank account used for Shopify Payments; if it favors the customer, the disputed funds are returned to the customer.

Fictional simplified example

This is a fictional simplified worked example, not a fee quote. An order is captured for $480. Assume the transaction detail shows a $24 Shop Pay Installments fee, so the associated payout movement is $456. The arithmetic is $480 - $24 = $456. A finance reviewer matches the $480 order to the charge, the $24 to the provider's fee line, and the $456 to the payout detail and eventual bank deposit.

If the customer later receives a $120 refund, the reviewer records the $120 refund as its own event and checks the official fee treatment rather than assuming $6 or the full $24 comes back. The FAQ's rule for the Shop Pay Installments transaction fee is that it is not returned on a refund. If a $480 dispute appears instead, keep the disputed amount open while the response and outcome are pending; do not call it a final loss before the resolution is known.

Handoff for Xero and QBO reviewers

A generic bookkeeping workflow can use a payment clearing account for captured Shop Pay Installments receipts, a reviewed fee category, a refund or returns category, and a bank-clearing match for the payout. That is a workflow pattern, not menu guidance or tax advice. The merchant and adviser should decide the account structure, recognition policy, and supporting records.

Give the close reviewer a transaction export, order IDs, payout details, bank lines, refund evidence, and dispute correspondence. Reconcile in the payout currency and note any currency or timing boundary. Keep the customer's installment collections out of your store's receivable unless your adviser has a specific reason to model something else; the provider collects those installments.

Sources and further reading

Use Shopify's Shop Pay Installments FAQ for payment, fee, refund, dispute, and payout behavior. Use the Shopify Payments activity report to understand balance-activity categories and why the report is not a revenue statement.

Payout Explainer is coming soon

Payout Explainer is coming soon. Join the waitlist for a review-before-posting experience that keeps installment payout explanations inspectable. It will not provide tax or FX advice, and this page does not claim that uploads or connections are available now.