At a glance
Order distribution by displayFinancialStatus. The payment-state health view: how many orders are paid vs pending vs voided vs partially-refunded vs refunded?
Calculation
Worked example
A US multi-channel home goods brand with B2B catalogue on Shopify Plus. Period: 12 Apr 26 to 11 May 26.
Five things to notice:
- PAID at 87% is healthy for a mixed B2B / DTC store. Pure DTC typically runs 92 to 96% PAID; B2B drags the rate because of Net 30 / Net 60 invoicing. The 3.2% PENDING is almost entirely B2B; check by tag-filter on the orders.
- PARTIALLY_REFUNDED at 4.6% is the silent-margin-leak. Customers who returned 1 of 3 items, or got a 20% post-purchase goodwill credit, sit here. Each is a small loss but they aggregate. Pair with Top Refunded Products to see which SKUs drive partial returns.
- AUTHORIZED at 0.6% needs follow-up. 42 orders held in auth but never captured. Some are intentional (manual capture workflow); some are stuck. Capture windows on most card networks are 7 days; orders sitting in AUTHORIZED for >5 days are at risk of EXPIRED. Set up a daily review of orders aged >3 days in AUTHORIZED.
- EXPIRED at 0.3% is genuine lost revenue. 18 orders where the customer’s card auth expired before capture. Fix the workflow that’s letting orders sit too long. Most often a manual-fulfilment delay coupled with manual-capture toggle on; switch to auto-capture or set a 48h SLA on capture.
- VOIDED at 1.1% should match Cancellation Rate loosely. Voided is the financial-status counterpart to cancelled-status. The two should track within 0.5 ppt.
Sibling cards merchants should reference together
Financial status is a payment-state diagnostic. Pair with these:Reconciling against the vendor’s own dashboard
Where to look in Shopify Admin: Orders → filter by Payment status (each value matches adisplayFinancialStatus). Counts per filter should align with this card.
Other Shopify Admin views:
- Reports → Sales by financial status: a £-revenue split by status; useful for understanding £ at risk in pending / authorised.
- Settings → Payments: configures capture and authorisation settings; doesn’t show counts but explains why certain statuses are common (manual capture vs auto-capture).
- Apps like Eva.guru, Stripe dashboard direct: gateway-level views; finer-grained payment state.
Cross-connector reconciliation:
Known limitations / merchant FAQs
Why is my PENDING share so high? Three usual causes:- B2B Net 30 / Net 60 invoices. Outstanding for days or weeks; structural for B2B.
- Bank-transfer / e-check payments. PayPal e-checks, Klarna pay-later flows, ACH transfers. 1 to 7 day clearing time; expected.
- Manual capture toggle. Some merchants run manual capture (capture only on fulfilment). Orders sit AUTHORIZED until you click capture; that bucket flows through PENDING in some configurations.
- Pull the EXPIRED orders. Check creation-to-expiry lag; usually it’s the days-to-capture metric.
- Audit fulfilment workflow. If orders sat unfulfilled for >5 days, capture expired.
- Switch to auto-capture for routine orders if you’re on manual.
- For B2B / large orders that need manual review, set a 48h SLA on capture decisions.
- Customer-service follow-up: contact EXPIRED customers; offer to recreate the order. Recovery rate is typically 30 to 50% if reached within a week.