Skip to content

Automated order-to-cash reconciliation from Shopify to NetSuite

Your Shopify payouts reconciled and posted to Oracle NetSuite automatically. Sales, fees, refunds, and tax lines are split out and matched to the penny.

Start 14-day free trialBook a demo

Automated Shopify bookkeeping for Oracle NetSuite teams

Built for finance teams running Shopify and Oracle NetSuite. Equali reconciles each payout batch before posting balanced journal entries to your general ledger.

Categorised NetSuite Journal Postings

Equali reconciles each Shopify payout and posts balanced debit and credit journal entries to NetSuite with sales, fees, and refunds separated.

AUDIT ENTRY#10432
Posted · Verified
Gross Sale£49.99
VAT (20%, incl.)£8.33
Processing fee (2.9%)−£1.45
Net Payout SettledMatched to bank MT940
£48.54
Audit Ref: AUD-2026-9921Posted to NetSuite · 14 Jun

Order-to-Payout Clearing Tie-Out

Reconcile Shopify orders and payment gateway settlements before posting verified payout breakdowns into your NetSuite accounts.

AUDIT TRAIL#TX-94021
100% 3-Way Matched
01
Shopify Order#10432
12 Jun · Online Checkout
£49.99Gross Sale
02
Stripe Gatewaych_3N84x
Fee deducted: −£1.45 (2.9%)
£48.54Net Captured
03
Barclays SettlementMT940
Payout po_941 · 14 Jun
£48.54Settled In Bank
Variance: £0.00 (Zero Break)Ledger: Xero JE-8892

  • Summarised or Line by Line

    Post each Shopify settlement as a summary or line by line, and split settlements that cross a month end.

  • No Duplicate Postings

    A settlement is marked as posted once it reaches NetSuite and cannot be posted again, so nothing lands twice.

  • Multi-Entity & Currency Support

    Support for multi-currency reconciliations and multi-entity reporting across your NetSuite setup.

  • Transaction-Level Audit Trail

    Trace every NetSuite journal entry back to the underlying Shopify payout and order records inside Equali.

AUDIT ENTRY#10432
Posted · Verified
Gross Sale£49.99
VAT (20%, incl.)£8.33
Processing fee (2.9%)−£1.45
Net Payout SettledMatched to bank MT940
£48.54
Audit Ref: AUD-2026-9921Posted to Xero · 14 Jun

From Shopify checkout to balanced NetSuite journals

Eliminate manual CSV journal imports at month end: Equali pulls in every Shopify payout with its orders, fees, and refunds, reconciles it to the money that landed, and posts balanced journal entries straight into Oracle NetSuite.

Connect Shopify to NetSuite in four simple steps

Set up once. After that, every settlement is reconciled and categorised before it reaches NetSuite.

  1. Connect your Shopify store from the Shopify App Store or your Equali account and link NetSuite.

    Explore Connect Shopify & NetSuite

  2. Confirm your tax settings, NetSuite general ledger accounts, and posting preferences.

    Explore Set Up Your Profile

  3. Review each settlement's reconciliation status and post balanced journal breakdowns to NetSuite.

    Explore Review & Post to NetSuite
MonthlyAnnual Save ~17%

Lite

£18/mo£15/mo

+ VAT/sales tax where applicable

1 store1 month of history on setup
  • 1 sales or payment integration
  • 2 click journal entry posting
  • Settlement reconciliations
  • Dashboard & standard reports
  • Payment Search
  • Tax Items
Start 14-day trial
Most popular

Pro

£36/mo£30/mo

+ VAT/sales tax where applicable

Up to 3 stores6 months of history on setup
  • Everything in Lite
  • Up to 3 sales or payment integrations
  • Slack support
  • Daily, weekly or monthly scheduled reports
  • Multi-Store Support
Start 14-day trial

Premium

£90/mo£75/mo

+ VAT/sales tax where applicable

Up to 5 stores12 months of history on setup
  • Everything in Pro
  • Unlimited sales or payment integrations
  • Custom reporting
  • Ad-hoc Reports
  • File Upload
Start 14-day trial

Enterprise

£Custom

+ VAT/sales tax where applicable

Scalable enterprise solutions for more complex requirements

  • Everything in Premium
  • Unlimited stores
  • Unlimited payment providers
  • Unlimited sales channels
  • Unlimited integrations
  • Custom API access integrations
  • Priority phone & Slack support
  • Custom onboarding & training
Book a demo
Compare all features
Feature
LiteStart trial
ProStart trial
PremiumStart trial
EnterpriseBook a demo
Sales & Payment IntegrationsIncludes eCommerce platforms (e.g. Shopify, Amazon) and payment providers (e.g. Stripe). May require additional setup.13 Unlimited Unlimited
Accounting IntegrationsIncludes accounting systems (e.g. Xero). May require additional setup.
ERP IntegrationsIncludes ERP platforms (e.g. NetSuite). May require additional setup.Enterprise OnlyEnterprise OnlyEnterprise Only
Data Update FrequencyHow frequently payment and order data is refreshed via API (where available).Every 15 minutesEvery 15 minutesEvery 15 minutesEvery 15 minutes
Historical Data (On Setup)Amount of past payment/order data processed during initial setup (via API where possible).1 month6 months12 months12 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.-
Custom IntegrationsBespoke API connectors or custom development for proprietary or unique systems.Enterprise OnlyEnterprise OnlyEnterprise Only
Custom WorkflowsBespoke workflow setup for your specific use case.Enterprise OnlyEnterprise OnlyEnterprise Only
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.--
Custom Reconciliation RulesCustomisable reconciliation rules, including rule suppression, tolerance thresholds and more.Enterprise OnlyEnterprise OnlyEnterprise Only
Cross-Platform ReconciliationsReconciliations across platforms e.g. Shopify store orders reconciled with Stripe payments.Enterprise OnlyEnterprise OnlyEnterprise Only
Reconciliation Approval WorkflowA second approver reviews and authorises reconciliation changes before they take effect.---
CASS ReconciliationsSpecialised reconciliation workflows for CASS 15 safeguarding reconciliation and reporting.Enterprise OnlyEnterprise OnlyEnterprise Only
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.StandardStandardCustomCustom
Scheduled ReportsAutomated reports delivered on a chosen cadence (daily, weekly or monthly) via the dashboard.MonthlyDaily, Weekly or MonthlyDaily, Weekly or MonthlyDaily, Weekly or Monthly
Ad-hoc ReportsGenerate custom reports on demand without waiting for a scheduled run.--
Flexible Custom FieldsAdd customisable metadata fields to reporting data for better filtering and reporting.Enterprise OnlyEnterprise OnlyEnterprise Only
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.
CASS DashboardDedicated view and analytics for CASS reconciliation.Enterprise OnlyEnterprise OnlyEnterprise Only
Help and supportAvailable support channels and documentation.Help centre & support chatHelp centre, support chat & SlackHelp centre, support chat, Slack & phoneHelp centre, support chat, Slack & priority 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
LiteStart 14-day trial
ProStart 14-day trial
PremiumStart 14-day trial
EnterpriseBook a demo

Trusted by merchants & FinTechs

Company logoCustomer Story

"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."

Wouter van HaaftenCFO, Sunday

Interview Transcript

Wouter van Haaften, CFO of Sunday, on reconciling with Equali

Sunday is a financial technology company that was established in 2021. The company specialises in payment solutions for the restaurant and broader hospitality industry. It operates in three core geographies (the US, France and the UK) and currently employs 130 people across offices in Atlanta, Chicago, London and Paris.

My role as head of finance is to lead the finance and accounting teams, and my responsibilities are mainly about driving Sunday's financial roadmap and making sure our finances remain healthy.

The core challenge we face at Sunday relates to the fact that we process millions of transactions on a weekly basis on behalf of the restaurants. When, in addition to the volume of transactions, we take the complexity of working with several partners along the value chain, it makes the reconciliation exercise very complex from a finance and accounting standpoint.

We decided to work with Equali first and foremost because of the team. The team, coming from a broad range of experience within the FinTech and payments industry, gave us confidence that they would understand our problem and also provide us with the right solution.

In addition, Equali offered us dedicated customer support, on which they have delivered constantly for the past year. Every piece of feedback we have provided has been taken with great seriousness, and they have adjusted their product to suit our specific needs.

We use Equali mainly on the reconciliation front, making sure that the money we collect from the restaurant guest ends up in the right bank accounts at the right time. Equali provides us with an additional layer of confidence that our team's work is accurate.

Beyond the reconciliation piece, we also use Equali for two specific use cases:

First, our cash in transit: having a good understanding of the amount of money flowing through our systems at all times, still due to restaurants.

And second, fee reconciliation: making sure that the money we are being charged by our partners is correct.

The value that Equali provides Sunday today is, first, great control and visibility into the funds that flow through our system. But also, leveraging Equali enables our product and engineering teams to focus on revenue and growth-driven initiatives, such as building new features for the restaurants we serve. And on the finance side, it helps us focus on the more strategic projects, such as optimising our P&L and being a real strategic business partner for the teams.

Related reading & guides

Explore technical guides and architectures for automated reconciliation and accounting.

Accounting6 min read

What is journal entry automation?

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.

Martin BurnMartin Burn · 22 July 2026
Read article
Strategy6 min read

Build vs buy: automated reconciliations

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.

Martin BurnMartin Burn · 23 July 2026
Read article
Explore all articles and guides

Frequently asked questions about Shopify and NetSuite reconciliation

How does Equali sync Shopify payouts with Oracle NetSuite?

Equali connects to Shopify by API, groups orders, fees, and refunds by payout, reconciles each payout, and posts balanced journal entries to NetSuite.

How are Shopify processing fees and refunds recorded in NetSuite?

Equali splits out gross sales, payment processing fees, shipping, and refunds onto their own journal lines so your NetSuite accounts show revenue and costs in full.

Can Equali post summarised journals to NetSuite instead of raw orders?

Equali lets you post each Shopify settlement as a summary journal or line by line, and splits settlements that cross a month end while keeping full order drill-down in Equali.

How does Equali handle VAT and sales tax from Shopify in NetSuite?

Equali posts the tax Shopify provides on every sale, refund, and fee to NetSuite. Where a channel does not provide tax for a line, Equali estimates it from your confirmed tax profile.

Does Equali support multi-currency and multi-entity NetSuite setups?

Equali supports multi-currency reconciliations and a flexible organisational hierarchy for multi-entity reporting across your NetSuite accounts.

How does Equali prevent duplicate journals in NetSuite?

Equali marks each Shopify settlement as posted once it reaches NetSuite so the same payout batch cannot be posted twice.

Stop chasing reconciliations in spreadsheets

Connect your channels and providers, and let Equali reconcile, categorise and post every transaction. Start free, or see it on your own data.

14-day free trialBook a demo
Equali

Book a demo

Pick a time and tell us what you'd like to cover. All times shown in your local timezone (hosted from London).

Loading times…