Ecommerce bookkeeping across sales channels

A bank payout isn’t the same thing as a sale. Ecommerce bookkeeping brings sales, fees and payment processor transactions from each channel together in one accounting system; under accrual accounting, revenue is recorded when it’s earned, not when the payout arrives. That distinction helps explain why online sales can need a different bookkeeping approach from a business with one till and one bank deposit.

It’s easy to assume that matching deposits to sales is enough, especially when a platform sends regular payouts. But deposits can combine sales with fees, refunds and other transactions, so recording the payout as income alone can distort the picture. This guide explains ecommerce bookkeeping, how it differs from traditional bookkeeping, and how integrations, platform charges and payouts should appear in your records.

You’ll also learn what to consider when reconciling activity across sales channels and choosing a bookkeeping approach for your business. The aim is to make the moving parts clearer, so you can understand your figures and see where careful bookkeeping can support better decisions.

Sales channel and accounting software integrations

A business selling through Shopify, Amazon and its own website has separate records for orders, refunds and charges. Integrations can bring each channel’s sales data, fees and payment transactions into one accounting system. This gives you a consolidated view, but the records still need consistent categories and regular review. Without that structure, a sale could appear twice or a refund might not be matched to its original transaction.

Start by listing every sales channel and payment processor, then map each type of data to an accounting category. Keep Shopify sales distinct from Amazon sales, for example, and record processor fees separately from product revenue. Document how each integration handles refunds, discounts, delivery charges and fees. A test transaction from each channel can show whether the software imports the details as expected.

Accrual accounting recognises ecommerce revenue when it’s earned, rather than when a payout reaches the bank. If a customer places an order before the platform transfers the funds, record the sale in the period it was earned. This timing matters when a payout includes transactions from different periods. Allocate sales to the appropriate period, then reconcile the later bank deposit against the platform’s settlement report.

Cost of goods sold (COGS) follows the stock that has been sold. When an order records a product sale, reflect the corresponding inventory cost as an expense rather than treating every stock purchase as an immediate cost of sales. For example, buying a batch adds stock; selling one product reduces inventory and records its associated cost. This gives you a clearer view of gross profit by product or channel.

Cloud accounting software and integrations can reduce repeated data entry, but they depend on consistent settings. Review account mappings when you add a marketplace, change a payment processor or introduce a product category. Check that the order date, transaction type and sales channel remain identifiable after import. These controls support accurate ecommerce bookkeeping and help distinguish a genuine change in sales from a change in how data is recorded.

Each month, compare channel reports, processor statements and accounting entries. Investigate missing orders, duplicate imports and unmatched fees before closing the period. Then compare sales and COGS by channel to spot differences in product mix or selling costs. This review also helps explain cash flow, since recorded revenue and bank payouts may fall in different periods.

For businesses managing several platforms, a clear integration process turns separate commerce records into usable accounting information. The ecommerce accounting support page explains how this work can fit the needs of online sellers.

Ecommerce platform sales, fees and payout reconciliation

Accounting is required for all businesses, and accurate records help show sales, costs, refunds and settlements. In the UK, VAT-registered businesses need more detailed bookkeeping to account for VAT.

Sales, Returns and Refunds

Record daily sales by channel, separating completed orders from cancellations and refunds. A returned item should reduce sales and restore inventory if it is returned to sellable stock. Keep the order reference with each adjustment so you can trace a refund back to its original sale. This makes sales figures easier to review and shows how returns affect profit.

Compare the platform’s order report with the accounting entries for the same period. Check that discounts, delivery charges and refunds are in the right categories. If a refund is processed after the original sale period, record its date and link it to the original order. This keeps the audit trail clear without obscuring the timing difference.

Merchant Fees and Sales Tax

Payment providers and marketplaces may deduct merchant fees before transferring funds. Record these charges separately as expenses rather than reducing sales by the payout amount. This distinction shows gross revenue, selling costs and the resulting profit for each channel. Compare fee statements with platform activity, including adjustments and refunded transaction charges.

For UK businesses, VAT records should distinguish VAT charged on sales from VAT on eligible purchases. Under the VAT Cash Accounting Scheme, businesses account for VAT on sales when customers pay and reclaim VAT on purchases when suppliers are paid. International sales may also involve sales tax or GST obligations in other jurisdictions, so organise transaction details by destination.

Payment Gateway Reconciliation

Reconcile payment gateway statements with platform orders and bank deposits, not just the amount received. A payout can combine sales, returns and merchant fees, so match each component to its supporting report. Check the settlement period and transaction references, then investigate unmatched amounts, duplicate imports and delayed refunds before closing the records.

If a gateway payout covers orders from more than one accounting period, allocate each sale to the period in which it was earned. Match the later deposit to the gateway balance rather than recording it again as new income. This keeps monthly sales accurate and makes cash flow easier to interpret.

Keep platform reports, gateway statements, refund records and bank entries together for each reconciliation period. A consistent process makes it easier to explain differences between selling activity and cash received. If you need help organising these records or understanding their VAT treatment, discuss your bookkeeping needs.

What is eCommerce bookkeeping?

Ecommerce bookkeeping records and organises an online seller’s transactions so the accounts reflect activity across each sales channel. It covers sales, refunds, processing charges, stock costs and payments, sorted into suitable accounting categories. A Shopify business that also sells through Amazon can label each channel separately, making it easier to trace transactions and compare trading activity accurately.

A common mistake is recording a platform payout as the sale itself. A settlement may combine customer payments, refunds and processing charges, so entering only the net deposit can obscure revenue and expenses. Use platform reports to identify each component and link it to the accounting entry. Keep order references with adjustments so you can trace a later refund to its original sale.

Duplicate entries can distort the records too. An integration might import Shopify orders while a bank feed imports the later settlement. If both entries are categorised as sales, the same activity appears twice. Compare order reports with processor statements and bank entries, then review repeated or unmatched transactions before finalising the accounts.

Stock records need attention as well. Recording every supplier purchase as an immediate selling cost can misstate profit when products remain unsold. Track inventory received, sold, returned and held for sale. For a returned item, update the sales and stock records according to whether it can be resold. Consistent tracking helps explain differences between stock on hand and recorded costs.

Mixing personal and business transactions makes routine reviews harder. Keep separate accounts for business activity and attach receipts or invoices to the relevant entries. For example, record packaging bought for customer orders as a business expense, with its receipt alongside the transaction. Clear descriptions make supporting evidence easier to find without searching through unrelated personal spending.

International orders can add currency differences to your records. Keep the original transaction details alongside the sterling value used in the accounts. Exchange-rate movements can create gains or losses, so a later converted payout may differ from the original order value. This detail gives your ecommerce bookkeeping a traceable record of overseas sales.

Tax information also needs accurate categorisation. For a sale involving VAT, retain transaction details showing the relevant amounts and destination rather than relying only on a marketplace summary. Review each channel’s tax reporting alongside your underlying sales records. A consistent ecommerce bookkeeping routine helps identify missing documents and explain how reported figures were compiled.

Need Monthly Bookkeeping Services?

Set up your process by listing each sales channel, payment account and bank account, then connecting them to accounting software. Create transaction categories, decide who will review the records, and schedule weekly, monthly and quarterly checks.

1. Weekly: import or enter sales, expenses, refunds and supplier purchases. Match key transactions to platform reports and keep receipts with their entries.
2. Monthly: reconcile each payment account and bank statement, check inventory records, then review income and costs by channel.
3. Quarterly: prepare records for VAT returns if registered, and check that sales and purchase VAT are supported by the underlying transactions.

This routine gives online sellers a consistent record trail instead of leaving transactions until year-end. The level of detail required depends on the number of channels, payment accounts, orders and stock movements you track.

Finish monthly bookkeeping with a review of your financial reports. Check the profit and loss report for revenue, refunds, selling fees and other expenses. Compare the month with earlier periods, then investigate changes by channel or product. A fall in reported profit, for example, could reflect higher costs, more returns or a change in sales mix.

Use accounting software to keep source records and reports connected. A monthly close can include checking that sales imports are complete, reviewing uncategorised transactions and matching bank activity. Note unusual items, such as a delayed marketplace settlement or supplier credit. These details help explain differences between recorded revenue and cash received.

When assessing a bookkeeping offer, look at what work it covers and when the usual service terms begin. Check whether the stated period includes transaction processing, reconciliations and monthly reporting, or only initial setup. Clear scope matters more than a headline offer, because sellers need to know which recurring tasks are included.

Monthly reports can also inform practical decisions. If one channel brings in revenue but generates more refunds and selling expenses, compare its net contribution with other channels. Use the same categories each month so the comparison reflects trading activity, not changes in how transactions are recorded.

As order volumes grow, a bookkeeping partner can help maintain the routine and prepare management accounts from organised records. Ecommerce bookkeeping is most useful when transactions are reviewed regularly, exceptions are followed up and reports give sellers a reliable view of revenue, costs and cash flow.

Traditional bookkeeping compared with ecommerce bookkeeping

A local shop with one till may record sales through a single system and count stock in one location. An ecommerce business can sell through Shopify, Amazon and its own website, each with separate order reports and payment records. The difference is more than the number of transactions: each platform can create its own trail of sales, refunds, fees and stock movements.

Stock tracking is often more involved online. Inventory might be held at the seller’s premises, in a marketplace warehouse, at a third-party fulfilment centre or with a dropshipper. This makes it harder to see the full stock position from a single count. A useful ecommerce accounting process records where goods are held and links stock changes to purchases, sales and returns.

Consider a shoe shop holding 50 pairs of shoes. After selling 10 pairs, it should have 40 pairs left to sell. With online sales across channels, the same stock needs consistent tracking so two platforms don’t treat one available pair as two. Reconcile each channel’s orders against inventory records, then investigate mismatches before they affect fulfilment.

In a single-location business, sales and bank activity may be easier to compare directly. Online platforms can combine transactions into settlements while listing fees and refunds separately in their reports. A payout alone won’t show the full activity behind it. Compare the platform report, payment processor statement and bank entry to explain the difference.

Channel-level records make performance comparisons more meaningful. Separate Amazon sales and selling costs from Shopify’s, for example. Then review revenue, returns and expenses by channel instead of relying on one combined total. If the numbers change, this view helps you identify whether the cause is sales volume, product mix or channel costs.

Growth brings further record-keeping demands. Adding a marketplace, a new fulfilment arrangement or international orders creates more data to account for. International transactions can involve multiple currencies, with exchange-rate gains or losses to record. Keep the original transaction and conversion details together so you can trace reported figures back to their source.

Traditional bookkeeping principles still apply: record transactions accurately, retain supporting documents and use consistent categories. The difference lies in the volume and variety of ecommerce data. A clear routine should bring platform reports, payment records, stock locations and accounting entries together. This gives business owners more useful figures for monitoring cash flow and planning growth.

For ecommerce bookkeeping, the practical takeaway is to build records around channels, settlements and inventory locations, not just bank deposits. If your current process struggles to connect those records, discuss a bookkeeping approach for your sales channels.

Coombs Chartered Accountants: Statutory Accounts Preparation

Coombs Chartered Accountants helps ecommerce businesses turn organised sales and expense records into clear year-end accounts. Statutory Accounts Preparation supports businesses with their accounts, while Tax Compliance helps address tax reporting responsibilities. Cloud Accounting can provide a practical foundation for managing sales-channel records. Tax Planning can help you consider the tax implications of business decisions as your ecommerce activity develops. These services can be useful when marketplace transactions, stock movements or refunds make year-end preparation more involved, or when you need clearer information for business decisions. For support tailored to your business and records, contact Coombs Chartered Accountants in Manchester, Stockport, Wilmslow or Alderley Edge.

Build a stronger financial foundation for your next stage

As your online business develops, your ecommerce bookkeeping should develop with it. Use the financial information you already collect to consider upcoming decisions, such as changing your product range or reviewing how you fund growth. Clear records can help you set priorities and identify where more detailed financial support would be useful.

Coombs Chartered Accountants provides Statutory Accounts Preparation and Tax Compliance to support businesses with their accounts and tax responsibilities. Its Tax Planning service can help you consider the tax implications of business decisions. If your ecommerce bookkeeping records need to support year-end preparation or planning, these services connect day-to-day information with your financial requirements.

The right next step depends on the questions you need your figures to answer. If you want to discuss how ecommerce bookkeeping fits your business and its plans, contact Coombs Chartered Accountants. A considered conversation can help you identify a useful way forward and build confidence in the decisions ahead.

Frequently Asked Questions

What is the difference between bookkeeping and accounting?

Bookkeeping records and organises transactions, while accounting interprets those records and prepares financial information. Bookkeeping might capture supplier invoices and customer receipts, which accounting can then use to prepare year-end accounts or support tax reporting. The tasks are connected but serve different purposes. Accurate source records make useful reports easier to prepare and missing information easier to spot before the accounts are finalised.

Can you help me understand my numbers?

Yes. Management Accounts help business owners understand income, expenses and cash flow. You could explore why turnover increased while available cash fell, or compare the performance of different product lines. Ecommerce bookkeeping records provide detail behind those reports, helping you investigate changes instead of relying on a headline total. Cloud Accounting can also give businesses a clearer view of their financial records.

How do you deal with payment processing platforms?

Start by identifying how each processor reports payments, refunds, chargebacks and charges. Keep settlement reports with the related bank statements, then match entries using transaction references and dates. A clearing account can track funds in transit: record a card payment there first, then clear it when the processor’s transfer reaches the bank. This helps identify delayed transfers without treating them as missing sales.

How much is it going to cost?

The price depends on the work involved and is provided after a quote request. Bookkeeping scope can be affected by order volumes, active marketplaces and the bank accounts requiring reconciliation. The condition of your records and the reporting work involved also matter. Explaining how your sales channels and payment accounts are organised helps establish the support needed before a quote is prepared.

What does ecommerce bookkeeping involve?

Ecommerce bookkeeping involves recording and organising a seller’s business transactions, with supporting documents kept alongside the entries. These can include supplier invoices, platform statements, inventory purchases and customer adjustments. For example, retain the invoice for a bulk packaging order and link it to the expense entry. Consistent categories separate trading costs from other spending and make supporting evidence easier to find when reviewing accounts.

How to record ecommerce sales, fees, refunds and chargebacks?

Use platform and processor reports to identify each transaction, then assign sales, fees, refunds and chargebacks to appropriate categories. Keep a chargeback notice with its order reference and processor entry. If a disputed payment is later returned to your account, record the reversal as a separate adjustment. This preserves the transaction history and distinguishes a chargeback from a refund issued directly to a customer.

How to reconcile Shopify, Amazon and other marketplace payouts with bank accounts?

Match each bank deposit with the marketplace settlement report for the relevant transfer. Use the settlement reference to find its supporting transactions, then compare the report with your accounting entries. If a bank credit combines transfers from different platforms, identify and match each component before clearing it. Record timing differences separately so a later transfer isn’t mistaken for an unrecorded sale.

What bookkeeping software is best for UK ecommerce businesses?

The right software depends on your sales channels, reporting needs, stock processes and VAT records. Check whether its features suit your day-to-day transactions and organise the data in a way you can review. Coombs Chartered Accountants provides Cloud Accounting support for Xero, QuickBooks and Sage. Start by listing the reports and integrations your ecommerce bookkeeping process needs, then consider which system fits them.