3 Common Ecommerce Bookkeeping Mistakes & How to Avoid Them

In this guide
The quick answer
What are the three most common ecommerce bookkeeping mistakes?
The three mistakes are using incomplete marketplace reports, making manual data-entry and spreadsheet errors, and spending hours reconciling payouts by hand. In my discussion with Daniel Little, co-founder of Link My Books, we explain why these problems affect profit visibility, tax reporting, and cash flow—and how a payout-to-accounting workflow can reduce them.
A busy ecommerce store can look healthy on the surface. Orders arrive, your dashboard shows a growing sales number, and marketplaces send money to your bank account. Yet when you sit down to check what you actually earned, those figures may tell very different stories.
I spoke with Daniel Little, an Amazon seller who later co-founded Link My Books with fellow seller Pete, about the bookkeeping problems they repeatedly saw among online merchants. Daniel had built and sold two Amazon businesses before creating the software. That experience shaped one of the most useful ideas from our conversation: revenue can impress people, but profit is what makes a business sustainable.
Affiliate disclosure
This article includes an affiliate link. If you subscribe through it, I may earn a commission at no additional cost to you. I share the offer alongside practical information so you can decide whether the software fits your business. Read my full disclosure.
Why accurate ecommerce bookkeeping matters more than sales figures
Imagine selling in the United States, United Kingdom, and several European marketplaces. Your European operation generates exciting revenue growth, so you concentrate your energy there. But after marketplace fees, fulfilment, advertising, and stock costs, most of your actual profit may still come from the US. Without a reliable profit breakdown, your growth strategy could be based on the wrong signal.
Revenue
How much customers bought before deducting the costs and adjustments that matter to your accounts.
Payout
The net cash transferred by a marketplace after the items it has deducted or withheld.
Profit
What remains after applicable expenses, inventory costs, and adjustments are properly accounted for.
Tax reporting adds another layer. A business may need to distinguish taxable and non-taxable sales, marketplace-collected tax, domestic and cross-border transactions, and different categories of marketplace fees. Incorrect classifications can cause underpayments, overpayments, corrections, or penalties. The exact treatment depends on your jurisdiction and circumstances, not merely on the label a marketplace uses in a report.
Mistake 1: Relying on the wrong Amazon and marketplace reports
One of the biggest Amazon bookkeeping mistakes is downloading a convenient monthly summary and assuming it contains everything needed for accounting. In the interview, Daniel uses an Amazon day-range summary report as his example. It groups income and expenses in a useful overview, but that overview alone may not capture the transaction-level distinctions needed to prepare accurate books.
Consider a UK marketplace account. A sale shown in an Amazon UK report does not necessarily mean the customer received the goods in the UK. The destination may be elsewhere, and the appropriate VAT treatment may depend on the movement of goods, registration status, applicable rules, and who is responsible for collecting the tax. Treating every sale in one report as if it had the same tax treatment can distort the records.
There is also the settlement problem. Your report may cover the first through the last day of a calendar month, while Amazon deposits money according to its own payout schedule. Some transactions can appear in one period and be paid in another. When you enter month-end totals manually and then attempt to match several bank deposits, amounts often fail to line up neatly.
| Information | Why it matters | What to check |
|---|---|---|
| Sales destination | Cross-border sales may require different treatment. | Destination and relevant tax information. |
| Refunds and adjustments | Gross sales do not equal net revenue. | Returns, credits, reimbursements, and deductions. |
| Fees by category | Different charges can have different accounting treatment. | Referral, fulfilment, service, and other fees. |
| Marketplace-collected tax | The seller may not be the party remitting every tax amount. | Collection responsibility and supporting reports. |
| Payout dates and reserves | Bank deposits can cross reporting periods. | Settlement references and outstanding balances. |
Daniel also highlights clearing accounts. If you record marketplace income into a temporary account and later clear it when the bank payment arrives, any remaining balance should have an explanation. It might represent unsettled cash or reserves, but it could also indicate missed entries, duplicate transactions, or a timing mismatch. Check rather than assuming that an unexplained balance will correct itself.
Mistake 2: Making errors while copying data into spreadsheets
A spreadsheet is flexible, but it does not automatically make a bookkeeping process accurate. You can download the right data and still arrive at the wrong total if a formula refers to an incorrect cell, a row is missing, or one marketplace report was not imported. In a business handling hundreds or thousands of transactions, small mistakes can be difficult to spot.
Daniel describes common errors such as dragging a formula incorrectly, copying figures into the wrong category, and failing to distinguish tax collected by a marketplace from tax owed by a seller. These are not dramatic failures. Often, they look like perfectly normal numbers until someone compares the books against the underlying records.
If you still prefer manual ecommerce bookkeeping, introduce a repeatable review process. Keep original exports unchanged, work from clearly labelled copies, use consistent date ranges, verify subtotals, and document who approved each month. Compare the total of the settlement components to the payout amount. For anything that does not balance, investigate before posting.
Mistake 3: Spending too much time on manual reconciliation
The third mistake is less obvious because your final accounts might be correct. You could spend several hours downloading reports, rearranging columns, calculating fees, entering summaries, and matching deposits. If the process works, it can feel normal to repeat it every month. But that time could be spent investigating margins, improving products, or preparing for your next inventory purchase.
In our interview, Daniel contrasts a hypothetical six-hour monthly routine with a very quick payout match after automation. That is a demonstration, not a universal time-saving guarantee. The amount you save depends on your sales channels, transactions, accounting setup, and how often exceptional cases need attention.
Try the automation discussed in the video
Link My Books free trial + VOVA20
Start with a 14-day free trial. If you decide to subscribe, enter VOVA20 when choosing an eligible monthly plan to request 50% off the first three months. New-customer eligibility and the final discount are confirmed at checkout.
VOVA20
50% off for 3 months on eligible monthly subscriptions
For new customers. Not combined with other offers; not applicable to legacy annual billing.
How Link My Books automates ecommerce bookkeeping
Link My Books is a software connection between your sales platforms and your accounting system. It is not the same thing as outsourcing all bookkeeping to an accountant. You connect a marketplace or store, connect Xero or QuickBooks Online, and let the software process eligible payout data into structured accounting entries.
In the interview, Daniel shows how a settlement can be broken into sales, refunds, marketplace charges, and relevant tax categories. Instead of posting a single bank deposit as if it were total sales, the accounting system receives an entry that explains what made up that payout. You then match the corresponding bank transaction in Xero or QuickBooks.
1. Collect
Retrieve available settlement data from your connected ecommerce sales channel.
2. Categorise
Organise sales, returns, fees, adjustments, and configured tax categories.
3. Post
Send the settlement summary to Xero or QuickBooks Online, manually or automatically.
4. Reconcile
Match the accounting entry to the bank payout and investigate any exceptions.
The important distinction is between posting and reconciling. Auto-posting reduces the work of moving settlement data into your ledger. Reconciliation confirms that the resulting accounting entries are supported by the money that arrived. Review both sides, especially after connecting a new sales channel or changing your chart of accounts.
A simple example: why a payout is not the same as profit
Suppose an online store reports $10,000 in product sales during a settlement period. The marketplace also records $500 in customer refunds, $1,800 in various marketplace charges, and another $200 in adjustments. For this simplified example, assume taxes, advertising billed elsewhere, and reserves are excluded from the calculation.
| Item | Illustrative amount |
|---|---|
| Product sales | $10,000 |
| Customer refunds | -$500 |
| Marketplace fees | -$1,800 |
| Other settlement adjustments | -$200 |
| Net marketplace payout | $7,500 |
| Cost of goods sold, accounted for separately | -$3,500 |
| Illustrative amount remaining before other costs and taxes | $4,000 |
If you record only the $7,500 deposit as revenue, you lose visibility of the $10,000 sale total, the refunds, and the marketplace charges. If you call the $7,500 deposit profit, you ignore the cost of the inventory sold and any additional advertising, payroll, shipping, software, or business overhead.
How to connect Link My Books to Xero or QuickBooks Online
- Create your trial account. Use the official registration flow and supply the relevant business information. The current trial is advertised as 14 days with no credit card required.
- Connect your marketplace or store. Select Amazon, Shopify, eBay, or another supported channel, then authorise access using its connection process.
- Connect Xero or QuickBooks Online. Choose the bookkeeping company in which you want the entries recorded and check that you selected the correct legal business.
- Review account and tax mappings. Inspect suggested ledger accounts and tax categories. Confirm them with your accountant when your situation involves multiple jurisdictions or unusual products.
- Inspect an imported settlement. Check sales, refunds, fees, tax allocations, the reporting period, and the payout amount before sending the first entry.
- Post and reconcile. Send the entry to your accounting system, compare it with the corresponding bank deposit, and resolve any mismatch.
- Enable auto-posting when ready. Once you are satisfied with the setup, activate automation for subsequent eligible settlements and continue monitoring exceptions.
The current Link My Books connection guide provides channel-specific steps. The setup wizard should be completed from sales-channel authorisation through the accounting and tax configuration, rather than leaving a partially connected account.
VAT, GST, sales tax and cross-border sales: what to review
Taxes are a recurring theme in Daniel's explanation. The relevant question is not simply how much tax appears on an order. You also need to know the customer's destination, the tax category, who collected the amount, and who must report or remit it. In certain transactions, a marketplace may collect and remit tax; in others, the seller may have obligations.
Link My Books can organise available transaction information and apply the tax mappings you configure. For UK sellers, that may include separating domestic and other sales and handling products that fall into different VAT categories. Australian businesses need to consider GST treatment. US businesses should review sales tax and marketplace-facilitator treatment in the states where they have obligations.
It would be misleading to say that a particular destination automatically means a lower tax rate. Rules vary with transaction type, origin, destination, registration, and relevant law. Use the tool's categorisation as part of a controlled accounting process, then have a qualified adviser verify the approach for your business.
Which ecommerce platforms does Link My Books support in 2026?
Our interview was recorded when some sales-channel connections were still being introduced. The current platform lists integrations for Amazon, Shopify, eBay, Etsy, Walmart, TikTok Shop, Square, and WooCommerce, with Xero and QuickBooks Online as accounting platforms. Availability can vary by geography: for example, Walmart support is listed for the US, and TikTok Shop support is listed for the UK and US.
Amazon regions also deserve attention when estimating how many channels your plan needs. Multiple marketplaces within one connected Amazon region may fall under one Merchant ID connection, while selling through separate regions can count as separate sales channels. For example, a seller connected to Amazon Europe and Amazon North America may require two channel allowances even if both are managed by the same business.
Daniel explained that sellers outside the company's main UK, US, and Australian markets could still use the software with supported accounting connections, but might need to configure their own tax settings. That remains a useful caution: confirm the specific platform, marketplace, country, and tax workflow before assuming a global integration handles every local requirement.
You can verify available connections and the method for counting them in the official sales-channel guide.
Link My Books pricing, free trial and historical data
Pricing depends on both monthly order volume and the number of connected sales channels. The historical pound amounts discussed in the video are not current prices. Link My Books introduced updated pricing in July 2026, so choose your order band and channel count in the live pricing calculator before making a budget.
| Tier | Included channels | Included history |
|---|---|---|
| Lite | 1 | 3 months |
| Plus | 2 | 12 months |
| Pro | 5 | 18 months |
| Premium | 10 | 24 months |
The free trial currently runs for 14 days and imports approximately three months of historical settlement data. Its history allowance cannot be extended during the trial. A paid customer who needs older records may purchase an additional history bundle without changing channel tiers. The official historical-data guide explains the limits and optional bundles.
One significant change from the video concerns annual payments. Annual billing is now a legacy option and has not been offered to new customers since 2025, according to Link My Books' 2026 billing notice. Existing annual customers may have their own renewal terms. New buyers should plan around the monthly checkout options actually shown to them.
If you use coupon code VOVA20, the advertised saving is 50% for the first three months of an eligible monthly subscription. It does not mean a permanent 50% reduction. The normal rate applies afterward unless another approved arrangement exists. Verify the code, discount period, taxes, and monthly renewal amount before subscribing.
What should you still check after automating your books?
Automation is most valuable when it makes financial information easier to trust and easier to review. That means leaving room for normal bookkeeping controls. I would still check each new connection, maintain accurate product costs, reconcile deposits, and confirm tax mappings whenever the business changes its markets or product categories.
If you are switching from manual records, decide where the new system should start. Importing historical settlements over entries you already posted can create duplicates. Review the cutover date with your bookkeeper and confirm that old periods will not be counted twice. Likewise, if a payout does not match the bank feed, investigate fees, reserves, timing, and missing information rather than adjusting the accounts merely to force a match.
Prefer to test before paying?
Try Link My Books with your own marketplace payouts
Connect one channel, inspect an actual settlement, and see whether the breakdown and bank match solve your biggest bookkeeping problem. New customers can use the free trial first and check the VOVA20 offer when choosing a monthly subscription.
14-day trial
Explore the workflow before you commit to a paid plan.
VOVA20
50% off the first 3 months if the monthly promotion is accepted.
Ecommerce bookkeeping and Link My Books FAQs
Can Link My Books replace my accountant?
No. It automates important bookkeeping tasks such as settlement processing and posting, but a professional may still be needed for tax treatment, filings, year-end accounts, and advice. Software improves the workflow when its setup and records are correct.
Does Link My Books work with both Xero and QuickBooks?
Yes. It connects supported ecommerce channels to Xero or QuickBooks Online. Do not assume QuickBooks Desktop is covered: the published integration is for QuickBooks Online. Check the connection and permissions required for your account.
Will Link My Books record every Amazon sale as an individual invoice?
Its core approach is settlement-based summary posting, which groups relevant sales, refunds, fees, and tax categories into accounting entries associated with payouts. That is different from manually adding every order as a separate invoice. Specific posting details depend on the accounting platform and configuration.
How far back can I import settlements?
The free trial includes about three months of history. Paid tier allowances range from three to 24 months, and eligible paid subscribers can buy additional history bundles. Confirm the availability of the dates you need before replacing earlier bookkeeping records.
Is VOVA20 a permanent Link My Books discount?
No. The offer promoted here is 50% off for three months on an eligible monthly plan for a new customer. Standard billing follows the promotional period. Apply the code during direct checkout, confirm the acceptance and the next invoice, and check the conditions before paying.
Can automated bookkeeping prevent every tax or reconciliation mistake?
No system can guarantee that. It can reduce repetitive manual errors and improve traceability, but incorrect tax rates, product classifications, missing settlements, and duplicate historical entries can still cause problems. Check the exceptions and seek professional guidance when needed.
Final thoughts: keep your ecommerce numbers useful
My suggestion is simple: review one recent settlement and see whether you can trace its sales, deductions, taxes, and final bank payment. If that exercise is unnecessarily complicated, the free trial is a sensible way to evaluate whether Link My Books helps. Keep your accountant involved, verify your settings, and judge the tool by the clarity it brings to your own records.
For more walkthroughs, explore my Link My Books resource hub, the complete Link My Books tutorial, and my ecommerce seller pricing guide. Your books should help you make decisions, not leave you guessing what happened to your sales.