Link My Books Review & Tutorial: Automated Bookkeeping

In this guide
The quick answer
What is Link My Books, and how does it work?
Link My Books is ecommerce bookkeeping automation software that connects sales channels such as Amazon, Shopify, eBay and Etsy with Xero or QuickBooks Online. It collects payout transactions, separates sales, refunds, fees and taxes, then prepares accounting summaries for reconciliation. Sellers can review entries manually or enable automatic posting after checking their account and tax settings.
A marketplace payout rarely tells the whole story of what happened in your store. Your bank might receive one deposit, but behind that amount are dozens or thousands of orders, refunds, seller fees and tax movements. Recording the deposit as sales revenue can leave your accounts misleading.
In my conversation with Daniel Little, co-founder of Link My Books, we walk through a simpler approach. Instead of rebuilding every payout in a spreadsheet, the software organizes the underlying activity and transfers a structured summary into your accounting system.
This guide explains what happens to your data, how to set up the connection, which tax checks matter, how pricing and historical imports work, and how to test the service before paying. I have also separated the older prices mentioned in the video from the company's published 2026 plans.
Affiliate disclosure
This article contains affiliate links. If you subscribe through one, I may earn a commission at no extra cost to you. Read my full earnings disclosure.
Free trial and reader offer
VOVA20
50% off your first 3 months
Start with the 14-day free trial. If you choose an eligible monthly plan, enter VOVA20 at checkout. The advertised offer is for new customers, and the regular subscription price applies after the promotion.
Start free trial and claim VOVA20 offer
Confirm the discount before payment. The code is advertised for monthly subscriptions, not annual billing.
How Link My Books turns payouts into reconciled accounts
The central idea in Daniel's demonstration is that a payout is not the same as revenue. Marketplaces deduct fees, issue refunds and sometimes collect or remit taxes before sending money to your bank. An accurate ledger needs to explain those differences.
After you authorize a sales channel, Link My Books gathers the transactions behind each settlement. It groups them into accounting categories and assigns them to accounts and tax rates selected during setup. You can inspect the breakdown before posting it to Xero or QuickBooks Online.
1. Read the settlement
Collect sales, customer refunds, marketplace fees, tax items and adjustments associated with a payout.
2. Prepare the summary
Map transaction types to your chart of accounts and apply your approved tax treatment.
3. Post and reconcile
Send the summary to Xero or QuickBooks and match the accounting entry with the bank deposit.
Here is a simplified illustration. Imagine a settlement containing $12,000 of sales, $1,000 of refunds and $1,000 of marketplace fees. If there are no other adjustments in this example, the bank receives $10,000. Recording only the $10,000 deposit hides both gross sales and the costs that reduced it.
| Illustrative item | Amount | Accounting meaning |
|---|---|---|
| Gross sales | $12,000 | Revenue before deductions |
| Customer refunds | -$1,000 | Sales reductions |
| Marketplace fees | -$1,000 | Selling expenses |
| Bank payout | $10,000 | Deposit to match |
Actual settlements can contain shipping, reserves, reimbursements, tax collections and other adjustments; the table deliberately omits those details. The point is to preserve the components instead of treating the final deposit as one unexplained sales number.
During the video, Daniel contrasts hours of manual monthly bookkeeping with a much shorter matching process. That is a demonstration of a possible time saving, not a guaranteed result for every seller. The amount of work you save depends on your channels, existing records, mapping and review needs.
How to set up Link My Books with Xero or QuickBooks
The guided setup discussed in the interview begins with two connections: your ecommerce sales channel and your bookkeeping platform. You do not need to begin by uploading a large spreadsheet of marketplace transactions.
- Create a trial account. Use your email and follow the sign-in prompts. The provider currently advertises a 14-day free trial without requiring a payment card.
- Connect Xero or QuickBooks Online. Authorize the correct organization or company file, particularly if you manage several businesses.
- Connect your sales channel. Select Amazon, Shopify, Etsy, eBay or another supported channel and grant the requested access.
- Review account mapping. Check where revenue, refunds, fees and other transaction types will appear in the chart of accounts.
- Review tax settings. Confirm suggested rates and any product-specific treatment with your accountant before sending entries.
- Inspect one settlement. Compare the breakdown with the marketplace report, post it, then match it to the corresponding deposit.
Daniel explains that the setup wizard proposes different paths for US, UK and Australian businesses. If your country or company structure needs different treatment, choose the relevant settings rather than assuming one country's defaults apply everywhere.
My recommendation is to begin with manual posting. Once you have checked several summaries, reconciled their deposits and confirmed the mapping with your bookkeeper, you can consider Auto Post. It sends newly processed settlements automatically, but automation is only as reliable as the settings behind it.
Before turning on Auto Post: Check the date from which postings should begin, avoid creating duplicates of entries already in your books, and ask your accountant how historical settlements should be handled. Link My Books documents these settings in its settlement and payment-gateway settings guide.
How does Link My Books handle VAT, GST and sales tax?
Tax handling is one of the most important parts of the transcript. Two payouts with identical totals can require different accounting treatment when orders are delivered to different countries, products have different tax rates, or a marketplace collects taxes on the seller's behalf.
For a UK business, Daniel demonstrates separating domestic and international sales, refunds by destination and fee types that may receive different VAT treatment. Australian businesses must consider GST and the location of sales. US sellers need to distinguish seller revenue from sales tax collected and remitted by a marketplace.
The software provides a structured way to map those transactions. It also supports product groupings where different goods have different applicable rates. However, a correctly formatted entry does not, by itself, establish that a tax position is legally correct.
The software handles
Transaction categorization, mapping, supported tax calculations and posting based on your configuration.
You or your accountant verify
Registrations, applicable rates, product classifications, filing obligations and unusual cross-border cases.
Link My Books says its team can help configure the software but cannot provide individualized tax or accounting advice. If your business has several VAT registrations, complicated inventory movements or historic discrepancies, involve a qualified adviser before changing your bookkeeping method.
Which ecommerce platforms and countries are supported?
The video mentions Amazon, Shopify, eBay, Etsy and Walmart, with TikTok Shop still being prepared at the time. That last detail has changed. The current official pricing and integrations page lists Amazon, eBay, Shopify, Etsy, Walmart, TikTok Shop, WooCommerce and Square.
Coverage still differs by channel. Walmart support is listed for the US, while TikTok Shop support is listed for the UK and US. QuickBooks support refers to QuickBooks Online, not every desktop accounting product. The company lists broad Amazon marketplace coverage, but a separate Amazon merchant token or region can count as another connected sales channel.
Sellers outside the US, UK or Australia can use supported Xero or QuickBooks accounts, as Daniel explains. They may need to configure local tax rates without the same default suggestions available in the guided wizard. Check your exact marketplace, payment gateways and accounting region before subscribing.
For a business selling across two or more platforms, the advantage is consistency: each channel can have a repeatable settlement process while the accounting platform provides the combined financial record. Just remember that Link My Books complements your bookkeeping system; it does not replace Xero or QuickBooks itself.
Link My Books pricing in 2026: what determines your plan?
The £13 starting price and other amounts spoken about in the video belong to an older pricing structure. For 2026, Link My Books publishes Lite, Plus, Pro and Premium tiers, with costs that vary according to the number of orders, sales channels and history required. Do not use an older video screenshot as a current quote.
The table shows illustrative published monthly rates for a business with up to 200 orders per month, using the official UK and US price lists. It is a useful way to compare tiers, not a quote for every store.
| Tier | Monthly price | Channels | History included |
|---|---|---|---|
| Lite | £18 / $24 | 1 | 3 months |
| Plus | £24 / $32 | 2 | 12 months |
| Pro | £32 / $43 | 5 | 18 months |
| Premium | £60 / $80 | 10 | 24 months |
Source: official UK pricing and official US pricing. Amounts are before applicable taxes and promotional discounts; check the live billing screen for your plan.
One order is counted per customer checkout, even if several items were purchased. Link My Books calculates plan usage using a rolling monthly average, which can help smooth seasonal spikes. Your required tier can change when order volume or connected channels increase.
Important 2026 update: The video discusses paying annually to save money. Link My Books now says annual billing has been a legacy option unavailable to new customers since 2025. Existing annual subscribers can retain it. See the company's 2026 price-change notice.
If you are choosing between Lite and Plus, ask whether your second marketplace and the additional historical allowance are useful today. Pro and Premium become more relevant for businesses managing several channels or a deeper bookkeeping catch-up.
Compare your actual checkout
VOVA20 · 50% OFF
The offer is advertised for the first three months of a new monthly subscription. Compare the discounted total with the undiscounted renewal price and choose a tier that covers your channel count.
Can Link My Books import older settlements?
Yes. The standard free trial imports the most recent 90 days of settlements after you connect a channel. This gives you transactions to inspect without immediately posting all historical entries into your accounting software.
If you have a backlog, a paid plan can provide more history. Current published tiers list three months for Lite, twelve for Plus, eighteen for Pro and twenty-four for Premium. This differs from the historical allowances described in the older video. The company also offers extra historical data for a one-off fee; contact support for the price rather than assuming the amounts mentioned in the recording still apply.
For example, imagine you have recorded Amazon payouts manually for the last year but discovered that fees were posted to the wrong expense account. Before importing twelve months into Xero, agree with your accountant whether you should correct existing entries, reverse them or only bring across transactions not yet booked.
A longer history allowance is a bookkeeping convenience, not permission to overwrite previous tax filings or create duplicate sales. Download existing reports, preserve an audit trail and test a small date range before making historical changes.
What should you test during the 14-day free trial?
A trial is most useful when it answers a concrete question. Does one payout reconcile correctly? Do refunds appear in the right accounts? Are fees separated clearly? Can you explain the tax treatment to your bookkeeper? Testing one complete flow gives you more confidence than just viewing the dashboard.
I would connect one channel, inspect two or three recent settlements, compare them against the marketplace's own reports, and post one agreed entry to Xero or QuickBooks. Then reconcile the corresponding bank deposit and examine the profit-and-loss presentation.
Support matters here. In the interview, Daniel discusses help documents, messaging the support team and one-to-one onboarding. The current pricing page still lists email, chat and bookable onboarding calls, including during initial setup. You can ask the team to help you understand the software's settings, while your accountant remains responsible for professional advice.
Practical trial goal: Finish with one reconciled payout, an approved tax and account mapping, and a clear answer on which monthly plan your business requires. Only then decide whether to enable automatic posting.
Common mistakes to avoid when automating ecommerce bookkeeping
The biggest risk is treating automation as a substitute for checking your records. Good software can consistently process the wrong configuration. That is why the first few settlements deserve more attention than the number of buttons you save clicking.
- Posting bank deposits as total revenue: this hides marketplace fees and refunds.
- Using the wrong accounting organization: double-check the Xero or QuickBooks company before authorizing imports.
- Leaving default tax rules unreviewed: especially important for international sales or mixed-rate products.
- Backfilling without a plan: importing the same historical periods twice can cause duplicate entries.
- Switching on Auto Post too early: confirm the first reconciliation and posting dates before removing manual review.
- Confusing bookkeeping with full profitability: account for inventory costs, advertising, subscriptions and other expenses when assessing real profit.
Once your posting workflow is stable, review the accounts regularly. Check refunds and fee trends, compare the marketplace settlement with its bank receipt, and investigate unusual balances rather than assuming a matched payment means every financial figure is correct.
For broader context, I have also written about automating bookkeeping for ecommerce sellers and Link My Books financial analytics. Those are useful next steps once your basic reconciliation is reliable.
Who is Link My Books best for?
The clearest fit is a seller whose marketplace payouts are becoming time-consuming to explain in Xero or QuickBooks Online. Even a single Amazon store can benefit from accurate fee and refund separation. A growing multichannel business may gain more value because each additional payout format adds manual work.
Bookkeepers and accounting firms can also use a repeatable settlement process across clients, provided each client's account mapping and tax obligations are reviewed individually. For a firm-specific workflow, see my Link My Books guide for accountants and bookkeepers.
The software is less suitable as a stand-alone solution for someone who does not use supported bookkeeping software or wants it to replace an accountant's judgment. The strongest result comes from combining correct setup, consistent automated entries and periodic human review.
Link My Books frequently asked questions
Does Link My Books replace Xero or QuickBooks?
No. It organizes ecommerce payout data and posts accounting summaries into Xero or QuickBooks Online. You still use your accounting platform for the wider ledger, bank reconciliation and financial reports.
Is Link My Books free to try?
Yes. The official website advertises a 14-day free trial with no payment card required. The initial import includes the most recent 90 days of settlement data.
Does the VOVA20 coupon work on annual billing?
The advertised 50% discount is for the first three months of an eligible new monthly subscription. It does not apply to annual plans or combine with other offers. Verify the final discount at checkout.
Can I use Link My Books outside the UK or US?
Yes, for supported Xero and QuickBooks Online connections, but sales-channel availability and setup rules vary. Businesses outside the main guided regions may need to define their own tax settings.
Will the software automatically make my taxes correct?
No software can guarantee the correct legal treatment when registrations, product classifications or settings are wrong. Link My Books organizes tax-related settlement information; confirm the configuration with a qualified accountant or tax adviser.
Your next step
See whether your next marketplace payout reconciles cleanly
VOVA20
Try Link My Books for 14 days, review the 90-day import and confirm your chart of accounts. If you subscribe to an eligible monthly plan, use code VOVA20 for the advertised 50% discount across your first three months.
Get the free trial and 50% introductory offer
Availability and checkout terms may change. Check plan limits, discount eligibility and the regular renewal rate before buying.