Integration trends: why ecommerce accounting is getting more complex

September 2026

If you sell online, your store and your accounting system need to agree on the basics: what you sold, what you collected, what you refunded, and what it all cost you in fees and taxes. A noticeable trend over the last couple of years is that this “agreement” has become harder to maintain with simple, one-size-fits-all setups. The practical reason is straightforward: more payment options, more marketplaces, more cross-border sales rules, and more detailed reporting expectations have increased the number of moving parts between ecommerce and accounting.

This post focuses on what has changed in practice, and what small-to-medium merchants and their accountants can do to reduce errors and month-end surprises—without needing to follow daily product updates from every platform.

Trend 1: Payments are more fragmented, and deposits rarely match sales

Many merchants now accept a mix of card payments, digital wallets, “buy now, pay later” providers, local payment methods, and sometimes multiple payment processors. Even when everything is offered through a single checkout, the money may still be settled in batches, across different schedules, and with different fee structures.

Practical implication: the amount deposited to the bank for a day (or week) often won’t equal the gross sales in the store for that same period. That’s not new, but it’s becoming more common for the mismatch to be driven by several factors at once:

• Processing fees and rolling reserves: fees may be withheld per transaction or per payout; reserves may delay part of the cash.
• Refund timing differences: refunds can be issued today but netted against a later payout.
• Chargebacks and disputes: money may be removed after the original sale date, sometimes with additional fees.
• Multi-currency settlement: the store may report one currency while the payout arrives in another, with FX conversion effects.

For accounting, this pushes many businesses away from “post sales directly to the bank” approaches. Instead, accountants often prefer a clearing account (sometimes called an “undeposited funds” or “payment processor clearing” account) so that sales, refunds, fees, and payouts can be reconciled systematically.

What to do: agree up front on the unit of reconciliation. Some teams reconcile to payouts (e.g., one journal per payout), others reconcile daily. Either can work, but mixing methods mid-year can create confusion. Also decide whether fees will be posted as a single line per payout or broken out (useful for analysis, but more work).

Trend 2: Tax and compliance reporting expectations are rising

Tax calculation and reporting for online sales has been evolving across many regions. The details vary by country and by where your customers are, and they can change over time. While it’s difficult to summarise every rule, there is a consistent direction: more jurisdictions expect clearer audit trails for what tax was charged (or why it wasn’t), and platforms increasingly provide more tax-related fields and reports.

Practical implication: the accounting system needs data that supports your tax position, not just a total sales number. That often means paying closer attention to:

• Tax-inclusive vs tax-exclusive pricing: mismatches here can distort revenue and tax liability.
• Jurisdiction-based rates: the rate can depend on customer location, product type, and thresholds.
• Marketplace vs direct sales: in some arrangements, marketplaces may collect and remit certain taxes, changing what you should record as tax payable.
• Shipping, discounts, and gift cards: these can affect taxable amounts in different ways depending on local rules.

This trend affects integrations because merchants and accountants increasingly need control over how orders map into the chart of accounts and tax codes. A simple “all sales to one income account” setup may still be fine for some businesses, but others need separate lines for product sales, shipping income, discounts, tax collected, and fees—especially when cross-border sales grow.

Where uncertainty exists: tax treatments can be fact-specific. Two businesses using the same ecommerce platform may need different accounting mappings depending on their registrations, customer locations, and how they fulfil orders. If you’re unsure, document your assumptions and confirm them with a qualified adviser.

Trend 3: More sales channels means more adjustments and “edge cases”

Even smaller merchants now commonly sell through more than one channel: their own site, social commerce, wholesale invoicing, and sometimes one or more marketplaces. Each channel can have different definitions for key events like “order created,” “payment captured,” “fulfilled,” “returned,” or “cancelled.”

Practical implication: the number of exceptions increases. Typical examples include:

• Partial refunds and exchanges: the store may treat an exchange as a return plus a new sale, while accounting may prefer a net view.
• Bundles and kits: ecommerce may sell a bundle SKU, but accounting/stock systems may need component-level tracking.
• Backorders and split shipments: revenue recognition timing may differ from fulfilment timing (your accountant may have a preferred policy).
• Gift cards/store credit: often a liability at sale, then revenue later on redemption; some platforms record this in multiple ways.
• Manual adjustments: edits to orders after the fact can cause integration reruns or duplicated postings if processes aren’t clear.

These edge cases are where integration setups tend to drift over time. A mapping that was accurate when you sold only domestic, card-only orders can become unreliable once you add subscriptions, multi-currency pricing, or a second warehouse.

What to do: set a cadence for reviewing your integration rules—quarterly is common for growing businesses. Ask: did we add a new payment method, a new sales channel, a new tax registration, or new shipping terms? If yes, confirm that the accounting mapping still reflects reality. Keep a short “integration change log” (even a shared document) so that when numbers move, you can trace why.

• Choose a reconciliation approach: reconcile by payout or by day, and keep it consistent.
• Use a clearing account if payouts don’t match sales: ensure fees, refunds, and chargebacks have a clear home.
• Confirm tax settings: document whether prices are tax-inclusive and how shipping/discounts are treated.
• Review multi-currency handling: decide where FX differences should be recorded in the accounts.
• List your edge cases: partial refunds, gift cards, bundles, and split shipments—agree on the accounting treatment.
• Schedule a quarterly integration review: especially after adding payment methods, channels, or new jurisdictions.
• Keep an audit trail: save key reports (sales, refunds, fees, payouts) so month-end can be explained quickly.

Further reading: CarryTheOne publishes integration guidance and practical examples at https://www.carrytheone.co.uk.