Velan Bookkeepers Manage Books Worth Over $1 Billion Velan is in the 18th Year of Business Offering Accounting & Bookkeeping Services Velan Delivers Outsourced Bookkeeping & Accounting Services to Clients Nationwide Velan Offers Accounting & Bookkeeping Services to Small, Medium to Fortune 500 Companies Velan Bookkeepers Have Expertise in Multiple Software Platforms Including QuickBooks, Xero, Sage, FreshBooks, Myob & Accounting CS Velan Offers Bookkeeping Services to Clients in Various Industries Including CPA Firms, SMEs, Retailers, Non-Profit Organizations, Real Estate & Property Management.

E-commerce Bookkeeping: A Complete Guide For Online Businesses (2027)

Posted on 20/11/2026

E-commerce accounting is the accounting of all transactions in an online business, such as payments for sales, returns, payment processing charges, purchase of inventory, cost of goods sold (COGS), shipment and advertising, to determine the true profits and losses of the business.

An online business involves multiple transactions that take place in different forms. Money will be transferred from the marketplace minus the transaction charges, the refund process will reverse earlier sales, payment processors receive their fee, there are expenses incurred on inventory and also the budget for advertising changes with every campaign.

This guide will tell you about what is included in e-commerce bookkeeping, its significance, differences between regular bookkeeping, and how to handle channels such as Shopify and Amazon. This will include the process of setting up, best practices, reports, mistakes to avoid, software choices, sales tax information, outsourcing, and many other important things.

What is E-commerce Bookkeeping?

E-commerce bookkeeping involves the organization, classification and reconciliation of a web-based store’s financial transactions. It’s not just for order tracking or recording bank deposits. While an order report will tell you what you’ve sold and a deposit will tell you what you’ve deposited, neither will give you the complete financial view. It covers:

  • Sales and refunds: revenue recognized at net of returns and at the correct amount/date.
  • Payment processor fees: fees that are charged as expenses, and not buried within payouts.
  • COGS and Inventory purchases: the cost of the inventory purchased and the inventory sold.
  • Shipping, advertising and operating costs: all of the costs involved in running the store.
  • Matching up records to bank statements and generating accurate reports.

A marketplace reports $1000 worth of sales for a settlement period, subtracts $150 in fees, $50 in refunds, and pays out $800. The bank deposit is $800, while the sales revenue is $1000. The $200 difference is not to be ignored and is to be listed as fees and refunds.

Why Bookkeeping is important to e-commerce Businesses?

Books that are accurate bring together data on transactions so that you can make decisions you can act on, making them important at every stage of growth. The principal advantages are:

  • Measure the real profitability of the business: income – cost of goods sold – fees – shipping – marketing expenses show how much each period has made, rather than how much has been received.
  • Cash flows and paying vendors: when cash flows in and out, and bills are coming due, can be used to order inventory to prevent a cash shortage.
  • Management of the inventory and cost of the product: proper information on inventory and costs give you the knowledge of the slow-moving inventory, narrow profit margin, and the requirement to reorder well before time.
  • Generate proper financial statements: proper records lead to reliable financial statements.
  • Keep tax paperwork organized: This speeds up the tax preparation process and is useful in case questions come up, as all income and expenses are documented.

These benefits are revisited in the sections below as we discuss the specific processes, so that you can see how each process contributes to those benefits.

What’s the Difference between E-commerce Bookkeeping and Traditional Bookkeeping?

Traditional bookkeeping typically has fewer, larger transactions that are the same as the transactions on the invoice and in the bank. Online selling introduces new issues in the volumes, timing gaps, and third parties that affect how the books need to be kept. Each order can result in a sale, a fee, a shipping charge and ultimately a refund – all of which will be recorded separately.

Area E-commerce consideration
Sales High order volume and multiple sales channels
Payments Marketplace payouts, processor fees, and settlement delays
Inventory Stock movements, returns, and COGS
Returns Refunds, chargebacks, and restocking
Taxes Sales tax obligations that vary by jurisdiction
Reporting Profitability by product, channel, or period

The bookkeeping task is created for every row. For example, returns impact revenue, inventory and possibly fees simultaneously. Manual entry is not feasible with high order volumes and there may be delays in settlement, too a sale in one month can be paid out in another.

A bank feed method will account only for those transactions that make it to the bank, either net payouts or lump sum settlements. This method does not provide information about total sales, commission, returns, charge backs, stock changes, and delayed payouts. In absence of such information, profitability analysis becomes impossible.

What are the key components of e-commerce bookkeeping?

The following components provide information on what to record, why it’s important, and a typical mistake to steer clear of.

Where do Sales, Discounts and Refunds Go?

  • Record: List gross sales, discounts and refunds as separate lines.
  • Importance: Only accurate if returns and promotions can be seen, as this is net revenue.
  • Avoid: only book the net amount.

Marketplace and Payment Processing Fees are Recorded How?

  • Record: commissions, referral fees and processor fees as expense.
  • Importance: fees directly contribute to margin and vary from channel to channel.
  • Avoid: pay-outs within pay-outs.

How is Inventory tracked and valued?

  • Record: Purchase, stock available, and always use a single valuation technique.
  • Importance: inventory is an asset and its value can impact profit.
  • Avoid: taking a write off for each purchase of stock.

What is the Formula for Cost of Goods Sold (COGS)?

  • Record: purchase + beginning inventory – ending inventory (and direct costs).
  • Importance: COGS is used to calculate gross profit and for pricing decisions.
  • Avoid: Using purchases as COGS.

How Much Do Shipping, Fulfillment, and Storage Cost?

  • Record: Keep track of postage, packaging, fulfilment and storage costs in separate books.
  • Importance: Fulfilment can be a silent margin killer.
  • Avoid: Using one shipping account.

What are the methods of tracking advertising and marketing expenses?

  • Record: spend & promotions on ad platforms by channel or campaign.
  • Importance: it tells us the true cost of acquiring a customer.
  • Avoid: lumping ad spend with general spend.

Do accounts payable and receivable apply in all situations?

  • Record: supplier bills due and wholesale invoices due (if applicable).
  • Importance: Displays the obligations and expected cash.
  • Avoid: Recording bills just when paid.

How Do the Bank Reconciliations and Payment Processor Reconciliations Work?

  • Record: Reconcile bank, processor and marketplace reports to your books every period.
  • Importance: It identifies duplicate and missed deposits.
  • Avoid: Only reconciling to the bank statement.

Looking for a walkthrough with implementation? Read our e-commerce bookkeeping set-up guide.

How can you work on Bookkeeping for various E-commerce platforms?

Every sales channel has its own reporting and payment methods, and thus requires accurate settlement and transaction records. Each merchant has their own reports, fee structure and payout schedule like Shopify, Amazon, WooCommerce, eBay and Etsy. Don’t assume that all platforms have the same accounting workflow.

Platform Common bookkeeping challenge Records to reconcile
Shopify and direct-to-consumer stores Payouts bundle multiple orders, fees, and refunds, and arrive after the sale Order and payout reports, gateway statements, bank deposits
Amazon marketplace and FBA Referral, fulfillment, and storage fees, plus returns and reimbursements Settlement reports, FBA inventory and fee reports, bank deposits
WooCommerce and independent stores Orders live on the store while payments settle through separate gateways Order reports, gateway statements, bank deposits
eBay, Etsy, and other marketplaces Fee types and payout schedules differ by platform Platform payout and fee reports, bank deposits
Multi-channel businesses Shared inventory and mixed fee structures across channels Each channel’s reports, inventory counts, consolidated bank and processor statements

How to implement an E-commerce Bookkeeping System?

A brief description of the setting up process is provided below. We break down each step in more detail in our guide:

  • Separate business and personal finance: Keep your money separate by opening business bank and business credit accounts; this will make it easy to classify all transactions because they will be purely business transactions.
  • Pick the right accounting software: Pick the accounting software which suits the company based on the company’s size, sales channel, and inventory requirements.
  • Create the chart of accounts: Different accounts should be created for sales, refunds, fees, inventory, cost of goods sold, shipping, and marketing expenses.
  • Connect sales channels and payment gateways: Ensure that the correct integrations are used in order to have sales, fees, and payouts captured in your accounting system, and see what has been captured.
  • Establish the accounting method: Decide how to account for sales, fees, returns, and inventory.
  • Implement monthly Reconciliation and Reporting Procedures: determine a schedule, owner, and checklist for each monthly process to ensure nothing is missed.

Initially, set up very simply. A simple, consistently applied structure is more valuable than a complicated structure, inconsistently applied and can be tweaked as the business expands and additional sales channels are developed.

What are the best practices when it comes to e-commerce bookkeeping?

Once you have installed, it has just begun. The following is a set of practices that will allow you to sustain your financial management on a continuous basis and also keep your books correct as those prepared in the previous step:

  • Reconciliation: It involves comparing your books with reports from banks, processors, and marketplaces to make sure any duplication and error are not missed.
  • Organize by Category: same category for each of the same kind of transactions each time, making reports comparable from month-to-month.
  • Keep records: keep copies of such documents as the platform’s report and invoices, so that you have a record of each transaction in your book.
  • Inventory checks: Look for cases of theft and damages.
  • Monitor fee charges: look at the processor and marketplace’s charges as a percentage of sales.
  • Monthly financial analysis: analyse the monthly profit and loss, balance sheet, and cash flow statement, and ask yourself what changed.

All of these practices are simple. The idea is to have a consistent monthly cadence where transactions are classified, documents are filed and reconciliations are completed prior to the start of the next month. It’s much easier to do little checks throughout the year rather than one big clean out at the end, and they will be sure to have your report when you need it.

What Financial Reports and KPIs to track for e-Commerce companies?

Bookkeeping information is useful for making good decisions when it is utilized to create regular reports and metrics. Look at this monthly and make comparisons to previous years to identify any trends early. Present each report with a question, what’s changed from last month, which product/service or channel contributed to that and

Report or KPI What it helps assess
Profit and Loss Revenue, expenses, and reported profit
Cash flow Timing of cash receipts and payments
Balance Sheet Assets, liabilities, and equity
Gross profit margin Revenue remaining after COGS
Inventory turnover How quickly inventory sells
Channel-level profitability Financial performance by sales channel, where data supports it

Gross profit margins and inventory turnover are very relevant indicators for online businesses, reflecting how profitable the products are and how fast the inventory turns over. Increase in revenue doesn’t always mean increase in profit when the advertising costs, commissions, refunds, and cost of goods sold grow faster than revenue, profit goes down.

The accounting profit also doesn’t reflect cash that is available to spend because the cash can be used in unsold inventory or payments to suppliers. Take into account all three indicators together.

What are the most frequent e-commerce bookkeeping errors and how to steer clear of them?

The majority of ecommerce bookkeeping mistakes stem from using the data from the platform as if it were bank data. It’s much easier to catch them early on than a year of entries. Watch for these:

  • Duplicate sales entries: do not make duplicate entries from an integration and as a manual entry.
  • Treating net payouts as gross sales: recording gross sales first and fees and refunds separately – this approach would not cause understatement of revenue.
  • Misclassifying fees: separate marketplace, processing and fulfillment fees into their own accounts to see each fee.
  • Making an incorrect inventory purchase: record inventory and book the cost of the inventory to COGS upon selling.
  • Ignoring refunds and charge-backs: Make sure to account for refunds and charge-backs when they happen and make sure the fees are accounted for, so the revenue matches the cash.
  • Failure to reconcile: Reconcile regularly, rather than only at tax time when it is more difficult to locate mistakes.

For instance: The sales report for a week displays a week’s total of $2000. Marketplace charges will be $300 and marketplaces refunds will be $100, giving the payout of $1,600. The $1600 deposit is booked as sales, which understates the revenue by $400, and doesn’t show the fees and refunds. $2,000 sales, $300 fees and $100 refunds equal the deposit. If there are hundreds of orders with these little gaps they will begin to add up and affect your profit loss statement.

E-commerce business owners should ask themselves: What Accounting Software Is Right for Them?

There is no one winner; it’s about what you need. A single-channel retailer might just require basic integration, whereas a multi-channel retailer with high sales volume might require a more robust settlement and inventory offering. Compare options by:

  • Business size: Transactions volume and team size.
  • Sales channels: which sales channels are you selling through and how they are reporting.
  • Inventory Complexity: Simple stock or variants/multiple locations.
  • Reporting needs: Standard statements, or channel-level views.
  • Integration requirements: how well it integrates with your channels and payment processors.

QuickBooks Online and Xero are popular cloud accounting platforms for small businesses. Many sellers add an e-commerce connector to transfer and summarize sales channel data into their accounting software. Connectors save time, but reconciliation and accounting accuracy still need verification. Confirm features and pricing on the vendor’s website before deciding.

Connectors are summarizing data so be sure to verify their fee, refund and timing policies before using them. Reconcile following the setup and check some periods against your platform reports and bank deposits. If there is a trial or demo, try it for yourself with real data before making a purchase, don’t solely go on the features list.

What’s the Impact of Sales Tax on E-commerce Bookkeeping?

E-commerce businesses can have tax obligations in multiple states depending on their operations and nexus regulations. Following the decision issued by the Supreme Court in 2018 in the case of ‘South Dakota v. Wayfair, Inc.’, states now have the right to demand that sellers collect sales tax despite not having a physical location there. Marketplace facilitator laws passed in numerous states might obligate marketplaces to collect sales tax on selected sales, although it depends on the situation.

The record-keeping function is related to sales tax, yet does not calculate it. Nexus, registration, filing, and payment are distinct processes. Taxable sales, tax collection, and tax payable for each tax jurisdiction must be included in your bookkeeping, with marketplace tax collections recorded independently. There are different requirements according to states, and you need to make sure that your tax filings are correct as your sales grow.

When it is time to outsource bookkeeping, an e-commerce business knows when it is time?

When it comes to bookkeeping, it can be difficult to maintain an in-house service when:

  • Transaction volume increases at a rate more rapid than your transaction recording time.
  • You have multiple sales channels.
  • The process of tracking inventory and COGS is complex.
  • Consistent Late Reconciliations.
  • There is a lack of trust in or reliability of reports.
  • You have limited amount of money to spend within your team.

General Scope: Transaction entries, payments reconciliation, costs of inventories, expenses classification, and preparation of monthly reports.

Service providers: Evaluate their experience with e-commerce, scope and speed, software knowledge, and security of data.

Expected Monthly Reports: Reconciled accounts, profit and loss statement, balance sheet, and cash flow statement.

If this is you, Velan’s team can help you get rid of the mundane tasks. Get to know the advantages of outsourced e-commerce bookkeeping.

Frequently Asked Questions:

What is an e-commerce bookkeeping?

It involves capturing, tracking and reconciling all your sales, returns, fees, inventory costs, COGS, shipping, advertising and other costs of an online store and getting them to appear in your financial reports.

What is bookkeeping for e-commerce?

Accounting software will extract sales channels and payment processors details to generate transactional information. Bookkeeping refers to the work of a bookkeeper who enters the information of gross sales, charges, refunds, cost of inventory and expenses among others and generates financial statements.

How to book e-commerce sales and marketplace fees?

Always book gross sales as revenue and book marketplace fees, processing fees and refunds as individual transactions rather than the net payout. The totals must agree to the amount of the deposit in your bank account.

Which accounting software would be right for your e-commerce business?

QuickBooks Online and Xero are popular options, and can be integrated with a marketplace data connector. The optimum choice will depend on the sales channels you use, inventory complexity, reporting requirements, and integration requirements.

What is the frequency that an online company should reconcile its accounts?

Anyhow at least once a month. If businesses receive a large number of orders, or have multiple channels, it could be advantageous to check them more often to avoid any problems occurring that would be difficult to trace.

What’s the e-commerce way of tracking inventory and COGS?

Add purchases as inventory, keep track of inventory and transfer purchase costs to COGS when the items sell. COGS is typically defined as the initial inventory + purchases – inventory on hand. The IRS has published its guidelines for inventory for tax purposes in IRS Pub. 538.

Are small e-commerce companies able to outsource their bookkeeping?

Yes. Large companies aren’t the only ones that can utilize outsourcing. Once reconciliation or inventory records, or multiple channels, begin to take time away from the small seller, it is likely that they will outsource.

What is the price of e-commerce bookkeeping service?

Prices are dependent on the volume of transactions, the quantity of sales channels, inventory complexity, software and volume of work. Request a scope of work in writing and quote you according to your specific needs.

Have a need for guidance in handling your e-commerce books?

Bookkeeping assistance can assist online sellers in handling transactions, reconciling marketplace payouts, keeping a track of inventory costs, and generating accurate financial reports. Velan has special outsourced bookkeeping services for e-commerce to manage these needs, and provide you more time to concentrate on your spreadsheet and less on your e-commerce. Whether it’s monthly reconciliations, or clear financial reports, we’re focused on providing you the numbers you can count on. Let our team know about your business needs and we will talk about what is the best way to accomplish those needs.

Our Ecommerce Bookkeeping Experts are here to help.

Topics: Ecommerce Bookkeeping

Pramod

Pramod

Manager

About the Author:

Pramod has over 11 years of experience relating to finance and accounts in diversified industries. He is an expert in resource and process optimization resulting in greater operational efficiencies.

Author can be reached at pramod.fs@velaninfo.com

Quick Connect With Us