What is Ecommerce Bookkeeping? How to do it (Right) in 2024

Did you know that 90% of eCommerce businesses fail? Learning to properly manage your business's finances could help ensure your business thrives and remains in that coveted 10% of successful businesses.

Not sure where to begin? You've come to the right place. Today, we're talking all about eCommerce bookkeeping. We're giving real, actionable advice. Plus, we'll be sharing some of the most common bookkeeping mistakes that eCommerce businesses make so you can be sure to avoid them.

What is Ecommerce Bookkeeping?

In 2022, there were around 580,000 eCommerce businesses in the UK alone. If you're one of these eCommerce business owners, you'll have a lot on your plate. From inventory management and marketing your brand, to selling your products and handling customer enquiries. eCommerce bookkeeping is another essential component in your eCommerce business.

eCommerce bookkeeping is the process of recording, storing, and organising your eCommerce business's financial transactions. These records give you insights into your business's financial health by allowing you to track your revenue and expenditure. This data can then be turned into financial statements and reports like balance sheets, cash flow statements and forecasts, and profit and loss statements.

Ecommerce Bookkeeping vs Ecommerce Accounting

‍

‍

The main difference between ecommerce bookkeeping and ecommerce accounting is how the financial data is used. An eCommerce bookkeeper records the financial data and transactions of an eCommerce business. They ensure all records are reconciled and accurate.

An eCommerce accountant, on the other hand, analyses the financial data and interprets it. eCommerce accounting involves creating reports - such as risk analyses and financial forecasts - based on the data recorded by the bookkeeper.

You can think of e commerce bookkeeping as the first stage in the whole eCommerce accounting process. Bookkeepers set the stage for accountants to work their magic with the numbers. It's also worth noting that the two jobs are closely entwined. As such, e commerce bookkeeping and eCommerce accounting responsibilities can sometimes overlap.

Examples of eCommerce Bookkeeping

‍

‍

Here are some examples of eCommerce bookkeeping practices:

• Recording and categorising transactions: Bookkeepers record every single financial transaction that happens within a business and sorts them into categories. This could involve exporting transaction data to an eCommerce accounting software. Or, manually recording transactions in spreadsheets. Transactions are categorised according to their context and purpose. For example, income, expenses, and equity.

• Managing accounts payables and accounts receivables: This refers to keeping a record of money owed to a business and money that the business owes. For example, recurring Shopify store fees, employee wages, or PPC costs. Keeping records of these helps eCommerce accountants manage budgets and create cash flow forecasts.
• Invoicing: Bookkeepers can create invoices which are kept on file and sent to customers to confirm transactions. As eCommerce stores operate online, bookkeepers will often use invoice automation software to create, send, and record invoices. This information is then taken into account when accountants create their financial reports.
• Bank account reconciliation: eCommerce bookkeepers ensure all transactions are recorded accurately by comparing figures with bank accounts. Thus ensuring a business's financial records line up with bank transactions.
• Inventory management: Bookkeepers can track inventory, which is particularly important when it comes to managing eCommerce stores. They will keep track of stock levels and determine the value of the assets that belong to the store. This helps accountants to determine a company's net worth, and also assists with creating financial statements and forecasts.

Types of eCommerce Bookkeeping 

There are two types of eCommerce bookkeeping:

Cash Basis

‍

‍

Cash basis bookkeeping is the most straightforward of the two types. It's the method of recording money going in and out of your business as it happens. In other words, when you make a sale in your online store, you only record it when the money hits your bank account.

Equally, when you pay expenses such as shipping fees or sales tax, you record the actual amount that has been paid rather than the amount you expect to pay.

Cash basis bookkeeping keeps things nice and simple. It's recommended for small businesses and start-ups. It also provides an accurate representation of real-time finances. A potential drawback though is that because it doesn't take liabilities and receivables into consideration, cash basis bookkeeping can make it difficult to get a complete picture of a business, along with its cash flow and finances.

Accrual Method

‍

‍

The accrual bookkeeping method records transactions based on events rather than actual cash flow. For example, if you make a sale in week one but will ship the products in week 2, you record the shipping costs in week one because that is when the sale happened.

The accrual method is no doubt more complex than the cash basis method. However, it does give a more accurate view of a company's operations and success. It can also help accountants spot trends in sales.

Say, for example, you have a big boost in sales before Christmas but you offer customers the opportunity to spread costs over a set period of time. This big boost would not accurately reflect the pre-Christmas shopping trend if you were to use the cash basis method. Because, you would be recording transactions as the money comes in rather than when the sales are made.

Why eCommerce Bookkeeping is Important

You can probably guess that there are numerous reasons why bookkeeping is important for eCommerce businesses. We're now going to go through the specific benefits:

Improving Your Business's Financial Health

‍

‍

Without monitoring and recording transactions, it would be near impossible to come up with a successful strategy to improve your business. With e commerce bookkeeping, accountants can look back on historical data and identify trends in sales.

For example, you might notice a month where your sales significantly drop. With this information, you can help identify the cause. Maybe you didn't invest in the right products that month or maybe you lowered your advertising budget, for instance.

Tracking Inventory

It's essential for an eCommerce business to track inventory. You need to know how much stock you have at any given time to avoid shortages. Tracking inventory also helps businesses identify best-selling products so they know which products to invest more money in.

Through proper inventory tracking, you might also notice you've held certain stock for a long time. Therefore, rather than hold on to it for longer and incur more storage fees, you could launch promotions or sales for these products to shift them.

Accurate Tax Calculations

‍

‍

Imagine not recording your sales and having to work out a whole year's worth of taxes in one go. Not only is this going to be incredibly difficult but it's also likely you'll end up making a mistake (or two!). By keeping accurate records of your financial transactions, accountants can more easily ensure their tax calculations are accurate, and also paid on time. Thus, avoiding any potential fees and penalties.

Common Mistakes in eCommerce Bookkeeping

As promised, here are some common mistakes people make in eCommerce bookkeeping:

Not Using Bookkeeping Tools and Software

‍

‍

First and foremost, a bookkeeping software is an absolute must for eCommerce businesses. With the low-cost, and even free, options available, it makes no sense to rely solely on manual bookkeeping. Even relying on spreadsheets can create massive complexities that simply do not need to exist.

Bookkeeping software keeps your records neat and tidy. They help you stay compliant with tax laws and regulations, and can even keep records of customer details. With the right tools and software, many of your bookkeeping tasks can be automated. This saves you hours of time every month and minimises the chance of errors.

Some brilliant bookkeeping solutions:

• Link My Books: Connects your eCommerce store to your accounting software so your transactions are automatically recorded.
• Xero: A popular accounting solution through which you can record and manage eCommerce transactions.
• QuickBooks: Another popular accounting software with some advanced accounting capabilities, such as employee time tracking and income tax estimates.
• Zoho: An accounting software that also has a free plan available.
• Zapier: A software that allows you to connect thousands of applications to your accounting software to create automated workflows.

Manually Tracking Inventory

‍

‍

If you're manually tracking your inventory levels, you're wasting your time. You need the right inventory tracking software so that you can manage stock levels efficiently. Some software gives you visuals and reports of best-selling products, and notifies you when stock levels are low.

Manually tracking inventory becomes even more complicated when you sell across multiple eCommerce platforms. Your chosen accounting software might even have built-in inventory management tools. Shopify also has an inventory tracker. Some other notable trackers include Netsuite, Lynnworks, and SOS Inventory.

Infrequent Bank Account Reconciliation

Without frequent bank account reconciliations, it can be very difficult to spot errors in your records. And if you do spot errors down the line, it can be more difficult still to identify where, when, and why the error was made. Bank reconciliations should be done once a month so that accountants can produce accurate, up-to-date monthly reports.

Inaccurate COGS (Cost of Goods Sold)

‍

‍

Accurate COGS (cost of goods sold) is essential for keeping accurate records of profits. Keeping your COGS low will ultimately increase your profits so working them out accurately gives you a benchmark to work with.

eCommerce sellers can get this wrong when they fail to record all the costs directly associated with acquiring the product. For example, the material costs and labour costs for making the product. Cost of goods sold, however, does not include general costs like marketing or employee salaries.

The good news is that many software can work out your COGS for you. Link My Books, for example, has a built-in COGS tool that calculates the cost of every item you sell, and reflects this figure in profit & loss statements.

Recording Sales Tax as Income

‍

‍

Recording your sales tax as income is a common mistake for eCommerce businesses. Doing this could land you in hot water with the government and cause compliance issues when it comes to paying your sales tax. This can lead to large bills, skewed profit figures, and spending cash that isn't rightly yours.

To ensure this doesn't happen, sales tax needs to be recorded in your balance sheets rather than your profit & loss statements. Alternatively, many accounting software can accurately work out your sales tax for you and keep it separate from your eCommerce business income.

How is Bookkeeping for eCommerce Different From Traditional Bookkeeping?

When I speak about traditional accounting and bookkeeping, I'm referring to the process involved with running a brick-and-mortar store. As opposed to, of course, an online business that sells goods. An e commerce business faces unique challenges that a traditional business will not face.

Let's look at some key ways eCommerce bookkeeping is different from traditional bookkeeping:

It's all Done Online

‍

‍

This is the most obvious difference between eCommerce and traditional bookkeeping. eCommerce transactions are done online with no physical cash being handled. Although working with lots of different technologies can get complicated, it can also make a bookkeepers job easier by automating many of the processes.

Here are some aspects you should consider automating using one or more cloud accounting software and tools:

• Transaction recording
• COGS calculations
• Bank account reconciliation
• Inventory tracking
• Sales tax calculations
• Submitting VAT Returns
• Customer detail updates
• Generating financial reports and key financial statements

Multiple Payment Processors and Gateways

‍

‍

Customers like to have a choice in how they pay for their goods online. With a traditional, physical set-up, a customer will pay with cash, card, or more recently, their phone; simple! With e commerce businesses, on the other hand, customers expect access to multiple payment processors in addition to a regular card payment option.

However, when you factor in all the different ways customers can pay for their goods online, you also need to factor in the merchant fees for different payment gateways. And, the fact that payments are coming through from a variety of sources. Therefore, it's essential you work to create a unified system with plenty of automation.

Multiple eCommerce Platforms

‍

‍

The beauty of selling online is that you can sell on multiple sales platforms for relatively little additional costs compared to opening up multiple physical stores. This allows you to branch out and diversify your online presence.

For example, you might sell your products on Shopify, Amazon, and your Tik Tok Shop. By selling across multiple sales channels, you can reach a wider audience and tailor your marketing efforts accordingly.

However, with more eCommerce channels comes more complexity. You'll need a good inventory management system that gathers stock levels from all your stores and adjusts them in real time. You'll also want to make sure your cloud accounting software gathers all your financial data from all your stores, such as online sales, merchant fees, and shipping fees, so that your accounting records are accurate.

How to do eCommerce Bookkeeping 

We're now going to go through the practical steps to doing eCommerce Bookkeeping in preparation for eCommerce accounting:

Connect Your Bookkeeping Solution to Your eCommerce Store

‍

‍

First and foremost, you must choose your bookkeeping solution and then connect it to your eCommerce store. This will act as the middleman and feed accurate financial data from your eCommerce store over to your bookkeeping solution. For example, Xero, QuickBooks, or Zoho.

There are a number of solutions for integrating your bookkeeping software with your eCommerce store, such as Link My Books, A2X, and Zapier. This integration should be a simple 'sign-up and enter your details' process, meaning it should not be too complicated.

Sync Your Transactions

Once you've chosen your software and are all signed up, configure your setup to sync your transactions. This process will differ depending on your chosen solutions. Some will allow you to set your tax preferences, marketplace, and the frequency you want to export data. You might also be able to choose which data the software gathers and exports, along with the reports it generates.

Categorise Your eCommerce Transactions

Categorising your eCommerce transactions allows for a neat and tidy system. That being said, the precise steps you take to categorise your transactions will depend on your software. In Xero, for example, you can group together data by transaction, project, and department. You do this by clicking on their respective tabs, and then sub-tabs. You can also create custom categories.

Reconcile Your Bank Accounts

‍

‍

Although bank account reconciliation can (and should) be automatic, you do need to manually review the data from time to time. This ensures there are no discrepancies and everything lines up correctly.

Create and Review Reports and Statements

Although creating reports is traditionally an accountant's responsibility, many bookkeeping solutions include financial reporting tools. In other words, they generate reports for you. eCommerce bookkeepers can take on this responsibility, and then either review the reports themselves or send them over to an eCommerce accountant for review and analysis.

4 Bonus Tips for eCommerce Bookkeeping 

Keep Personal and Business Finances Separate

If you're a Lone Ranger just starting up, it can be tempting to lump all your finances together. However, it's advised to keep your personal and business finances separate from the beginning. This will make things more straightforward, especially as your business grows.

Choose Simple Solutions

You might find a software that can do all kinds of neat tricks to help your business. However, if you can't get to grips with it, it's only going to lead to stress and possible errors in your system. A bookkeeping solution should always serve to make things easier for you and save you time. If it doesn't do this, you need to reconsider the tools you use.

Start off small and work your way up. A start-up doesn't necessarily need a solution with all the bells and whistles that an enterprise needs.

Scan and Store Receipts

‍

‍

Although online businesses operate largely online, there may be instances where you manage physical receipts and invoices. For example, you might purchase goods from a physical store and sell them on your eCommerce store. You might purchase shipping materials like labels or printer ink. Or, you could advertise your store locally with business cards, flyers, or directory ads, which require you to exchange cash in the physical world.

If this is the case, use a receipt scanner that connects with your accounting solution. A good receipt scanner will allow you to scan your receipt with your mobile device, and then upload the data to your records and categorise it accordingly.

Get Help as Your Business Scales

Working solo can keep your costs down. However, there's always the possibility of mistakes being made when you take on too much yourself. As your business grows, don't be afraid to outsource some tasks to professionals.

For example, you might decide to work with an accountant to better analyse your cash flow statements, sales revenue reports, and other financial data. It might also be necessary to get a good eCommerce accountant onboard to ensure you pay the correct amount of sales tax.

What is the Best eCommerce Bookkeeping Software?

We've gone through a lot of information today. The main point of this article is to take advantage of online tools and software. These will make bookkeeping and cash flow management simple and straightforward, and help ensure you meet your sales tax obligations.

‍

‍

In our humble opinion, Link My Books is the best bookkeeping solution for eCommerce entrepreneurs. Our software is easy to use, cost efficient, and incredibly accurate. Link My Books allows you to put your bookkeeping on autopilot by sending real-time data from your eCommerce store over to your Xero or QuickBooks account, with no intervention from you.

Our software takes all that confusing raw data and breaks it down to create clean summaries of your eCommerce transactions. This includes sales, shipping fees, refunds, and the all-important COGS. Furthermore, Link My Books calculates the sales tax on every single item you sell.

To make the experience even better, we offer a free onboarding session for all our customers. So, you can be confident that your configurations are all correct. Be sure to check out our great value plans to see what Link My Books is capable of.

Make Your eCommerce Bookkeeping Simple with Link my Books

eCommerce bookkeeping doesn't need to be confusing or scary. Link My Books makes it simple with its data gathering and reporting capabilities. We're a team of expert online sellers and we know our stuff when it comes to eCommerce bookkeeping.

Sign up today for a free trial - no credit card needed!

‍