Penny-Matched Payout Reconciliation
Every Shopify Payments payout batch is decomposed into gross sales, discounts, shipping, refunds, and processing fees to match your bank feed.
Reconcile daily Shopify Payments payouts, merchant processing costs, refunds, and POS transactions directly into your general ledger.
Connected to:
+ more
Built for high-growth Shopify and Shopify Plus merchants. Reconcile Shopify Payments, third-party gateways, POS register sessions, and multi-currency payouts automatically.
Every Shopify Payments payout batch is decomposed into gross sales, discounts, shipping, refunds, and processing fees to match your bank feed.
Track Shopify Payments, Stripe, and discount movements across dedicated clearing accounts so multi-gateway checkouts always balance.
Reconciles international presentment currencies and foreign exchange conversion spreads automatically.
Maps standard, zero-rated, and destination tax lines to your exact tax liability nominals.
Separates retail store card reader settlements and cash float movements from online orders.
Each Shopify payout ID posts once, preventing duplicate entries across weekend and holiday cutoffs.
Every order, gateway fee, refund, and tax line matched to the penny. Shopify Payments bundles hundreds of orders, refunds, chargeback holds, and card processing deductions into a single bank deposit. Equali unpacks each payout batch and posts balanced entries into Xero, FreeAgent, QuickBooks Online, or NetSuite.
Install in minutes. After that, online store and POS settlement batches flow automatically into your accounting software.
Add the verified Equali app from the Shopify App Store to connect your store catalog, orders, and payment payouts instantly.
Configure currency registers for Shopify Markets international storefronts and physical retail point-of-sale hardware terminals.
Examine automated batch reconciliations matching gross checkout volume against card processing deductions and net bank receipts.
Transmit daily summary journals isolating item sales, shipping fees, multi-tier sales taxes, and customer chargebacks.
"Thanks to Equali, we are able to control in detail the end-to-end flow of all transactions processed, giving us greater visibility and enabling us to detect any potential leaks or anomalies along the way."
£18/mo£15/mo
+ VAT/sales tax where applicable
Not available at this volume
£36/mo£30/mo
+ VAT/sales tax where applicable
Not available at this volume
£90/mo£75/mo
+ VAT/sales tax where applicable
Not available at this volume
| Feature | LiteStart trial | ProStart trial | PremiumStart trial |
|---|---|---|---|
| Sales & Payment IntegrationsIncludes eCommerce platforms (e.g. Shopify, Amazon) and payment providers (e.g. Stripe). May require additional setup. | 1 | 3 | Unlimited |
| Accounting IntegrationsIncludes accounting systems (e.g. Xero). May require additional setup. | |||
| Data Update FrequencyHow frequently payment and order data is refreshed via API (where available). | Every 15 minutes | Every 15 minutes | Every 15 minutes |
| Historical Data (On Setup)Amount of past payment/order data processed during initial setup (via API where possible). | 1 month | 6 months | 12 months |
| Upload FilesUpload and map CSV, XLS, XLSX or TXT files directly in the Equali dashboard. | - | - | |
| Multi-Currency SupportReconcile and report on transactions in multiple currencies. | |||
| Multi-Entity SupportManage and reconcile data across multiple legal entities, subsidiaries or stores in one account. | - | ||
| Categorisation & Tagging For Journal EntriesRevenue sub-ledger with categorised breakdowns for posting to specific journals (revenue, fees, etc). | |||
| Journal Entry PostingDirectly post categorised journal entries to your linked accounting system. | |||
| Link Journal Entries To Orders/PaymentsTrace and link posted journal entries back to the original order or payment record. | |||
| Settlement ReconciliationReconciles settlements vs individual payments and related entries. | |||
| Payment ReconciliationMatches payments from providers with orders from eCommerce platforms, including refunds and chargebacks. | - | - | |
| Payment SearchSearch for any payment or order using several data points directly from the dashboard. | |||
| Advanced Reconciliation ToolsBrowse reconciliation results, review reports, resolve breaks and understand why they occurred. | - | - | |
| Reconciliation Approval WorkflowA second approver reviews and authorises reconciliation changes before they take effect. | - | - | - |
| Split Settlements At Month-EndSplit a settlement that spans a month end so each period's figures are accurate. | - | ||
| Customisable Analytics DashboardCustomisable analytics dashboard with advanced filtering, KPIs and reconciliation breakdown. | |||
| ReportingStandard and customisable scheduled and on demand reporting. | Standard | Standard | Custom |
| Scheduled ReportsAutomated reports delivered on a chosen cadence (daily, weekly or monthly) via the dashboard. | Monthly | Daily, Weekly or Monthly | Daily, Weekly or Monthly |
| Ad-hoc ReportsGenerate custom reports on demand without waiting for a scheduled run. | - | - | |
| Manual Financial EntriesAdd one-off financial entries directly, outside the automated feed, for cases the connectors don't cover. | - | - | |
| Tax ItemsMapping and categorisation of tax rates and items from sales channels and payments, for accurate tax reporting and journals. | |||
| Transaction ViewBreakdown of each transaction, showing all financial entries associated with the order, including sales, refunds, fees and tax. | |||
| Help and supportAvailable support channels and documentation. | Help centre & support chat | Help centre, support chat & Slack | Help centre, support chat, Slack & phone |
| Accountant AccessDedicated read-only or restricted logins for accountants and external advisors. | |||
Ready to get started?14-day free trial on self-serve plans | PremiumStart 14-day trial | ||
Explore technical guides and architectures for automated reconciliation and accounting.
Journal entry automation creates the categorised accounting entries for your sales, fees, refunds and payouts without anyone typing them, and reconciles them back to the orders and settlements they came from.
Should you build automated reconciliations in-house or buy an off-the-shelf specialist product? The factors to weigh, from opportunity cost and complexity to maintenance.
Equali tracks original presentment currencies and domestic settlement conversions across Shopify Markets, preventing foreign exchange variances in your ledger.
Equali integrates online storefront transactions and physical Shopify POS register takings into unified clearing accounts for unified store reporting.
Equali records gift card redemptions as liability movements and isolates promotional discount codes from gross revenue lines.
Equali isolates Shopify Payments and Stripe payouts into individual clearing accounts so each gateway settlement balances independently.
Equali deconstructs credit card processing fees, payout adjustments, and rolling balance holds into discrete nominal lines, matching the exact deposit in your bank feed.
Equali allocates destination-based sales taxes and domestic VAT rates to dedicated tax liability nominals, ensuring clean quarterly VAT returns.
Equali posts refund adjustments, restock fees, and dispute inquiry holdbacks to your ledger, adjusting revenue and customer liability balances in real time.