Skip to content

eCommerce payout reconciliation for Amazon Sellers

Bi-weekly Amazon disbursements, FBA fulfillment charges, advertising costs, and inventory reimbursements reconciled down to the penny.

Connected to:

  • Xero
  • FreeAgent
  • QuickBooks
  • NetSuite
  • Amazon

+ more

From Amazon disbursement to your ledger in four steps

Connect once. After that, complex bi-weekly Amazon settlement summaries post automatically to your accounts.

  1. Link your Amazon account through the Equali app in the Amazon Selling Partner Appstore in seconds.

  2. Assign dedicated ledger accounts for FBA fulfillment, long-term storage fees, sponsored product ads, and reimbursements.

  3. Compare settlement reports with bank records and investigate any difference in the amount received.

  4. Transmit itemised accounting journals separating customer sales, marketplace withheld taxes, and Amazon service fees.

Automated Amazon settlement accounting for multi-channel sellers

Stop manually splitting bi-weekly Amazon settlement statements. Equali breaks down every order, FBA charge, and reserve movement before posting to your ledger.

FBA Fee & Ad Spend Decomposition

Separate gross product sales from FBA pick-and-pack fees, monthly inventory storage, Sponsored Products advertising, and refund administration charges.

Unavailable Balance & Reserve Tracking

Track Amazon account-level reserves and carried-forward balances in a dedicated clearing account so every bank transfer reconciles to the penny.

Marketplace Facilitator VAT

Isolate UK standard VAT, EU One-Stop Shop (OSS), and deemed-supplier marketplace tax lines automatically.

Inventory Reimbursements

Route FBA warehouse damage and lost-inbound inventory credits to a dedicated recovery nominal code.

Multi-Marketplace FX

Reconcile Amazon UK, EU, and North American disbursements across GBP, EUR, and USD bank accounts.

Idempotent Settlement Sync

Each settlement ID posts once with deterministic duplicate protection across month-end cutoffs.

Sales captured£12,000.00
Refunds−£600.00
Provider fees−£240.00
Expected in the bank£11,160.00

From bi-weekly SP-API settlement to penny-matched bank deposit

Every Amazon fee, reserve hold, and tax line accounted for. Amazon disbursements bundle thousands of orders, FBA fees, promotional rebates, and rolling reserve adjustments into a single net bank transfer. Equali ingests the raw SP-API settlement report, splits each component to your chart of accounts, and matches the net payout in your bank feed.

Trusted by merchants & FinTechs

Company logo

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

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
Compare all features
Feature
Sales & Payment IntegrationsIncludes eCommerce platforms (e.g. Shopify, Amazon) and payment providers (e.g. Stripe). May require additional setup.13 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 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 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.StandardStandardCustom
Scheduled ReportsAutomated reports delivered on a chosen cadence (daily, weekly or monthly) via the dashboard.MonthlyDaily, Weekly or MonthlyDaily, 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 chatHelp centre, support chat & SlackHelp 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

Related reading & guides

Explore technical guides and architectures for automated reconciliation and accounting.

View all guides →

Amazon questions

What should an Amazon settlement review include?

For Amazon in Equali, compare the settlement period, sales, refunds, fees and any held or released amounts with the provider report. Keep the payout reference with the review so the expected cash movement can be checked against the bank.

How should Amazon reserve balances be investigated?

For Amazon in Equali, a held balance and a paid-out amount answer different questions. Compare the opening and closing position with the adjustments in the source report. Do not assume that every withheld amount is a fee or a missing payment.

What should I check for Amazon fees and reimbursements?

For Amazon in Equali, check the transaction descriptions and references in the Amazon report. Fees, refunds and reimbursements can have different accounting treatments; review the available breakdown before deciding the destination accounts.

What should I check when Amazon holds back funds?

For Amazon in Equali, compare the reserve shown on the report with the sum paid out. Held funds are not the same as a selling fee. Keep the report dates when you review the next payout.

How should I assess sales from several Amazon marketplaces?

For Amazon in Equali, list each marketplace and the currency it pays in. Bring a report from each one. Confirm which seller accounts belong to the same business before grouping their books.

Which Amazon records help explain a refund?

For Amazon in Equali, keep the order ID, refund date and payout batch. A return may fall in a later batch than the sale. Compare those references before treating a lower deposit as a missing order.