Link My Books Tutorial for Accountants & Bookkeepers (2026)

In this guide
The quick answer
How do accountants and bookkeepers use Link My Books?
Link My Books helps accounting professionals turn ecommerce marketplace settlements into organized entries in Xero or QuickBooks Online. Add a client, connect their sales channels securely, map accounts and tax rates, review the first settlement, and reconcile its payout. You can then use financial analytics and repeatable workflows to manage more clients without manually rebuilding every marketplace report.
Ecommerce bookkeeping is rarely as simple as recording the amount that lands in a bank account. One Amazon or Shopify payment may contain sales, returns, fulfillment charges, advertising costs, tax adjustments, and money held back for another period.
The video below, Link My Books Tutorial for Accountants & Bookkeepers, focuses on how accounting professionals can onboard clients and automate ecommerce bookkeeping. This written guide expands the workflow using current documentation, then compares 2026 subscription prices with examples from a separate Link My Books pricing excerpt.
Affiliate disclosure
Some links in this guide are affiliate links. If you subscribe through them, I may earn a commission at no extra cost to you. Read the full disclosure.
Why Link My Books matters for an ecommerce accounting practice
An accountant needs to explain what happened between a customer's order and the money deposited by a marketplace. Recording only the payout understates the underlying activity and can obscure sales, refunds, seller fees, and taxes.
Link My Books imports supported settlement data, categorizes transactions using your approved mappings, and prepares entries for the connected bookkeeping system. It can reduce repetitive data entry, but the chart of accounts, tax settings, and final review remain your responsibility.
For bookkeepers
Spend less time reconstructing settlement reports and more time checking balances and exceptions.
For accountants and firms
Standardize client onboarding, review tax treatment, and use reports to support better business discussions.
Supported channels include Amazon, Shopify, eBay, Etsy, TikTok Shop, Walmart, WooCommerce, and Square, although regional availability varies. Link My Books connects directly with Xero and QuickBooks Online. Confirm the client's particular country, store, and accounting platform before planning the migration.
Step 1: Add your first client and connect their stores securely
Start in the accountant or bookkeeper workflow, not by asking the client to share their Amazon password. Link My Books has a dedicated invitation process so the person authorized to manage the store can approve access.
- Enter the client's business name and an optional reference that you can recognize in your practice records.
- Select the marketplaces and storefronts the client actually uses.
- Choose who will own the Link My Books account. The owner controls billing and user management, so agree on this before proceeding.
- Connect the appropriate Xero organization or QuickBooks Online company.
- Enter the client's email so they can authorize their own sales-channel connections.
Use the official accountant onboarding instructions for the current screens. Certain channels may require the client to complete the authorization themselves. After they connect, you can finish the account and tax setup.
Small but important detail: Send the invitation to the client's email, not your own. Also confirm the correct business and accounting file before importing historical transactions.
Step 2: Map the chart of accounts in Xero or QuickBooks
The Accounts & Taxes wizard asks where each settlement category should go. Typical categories include product sales, refunds, marketplace fees, fulfillment fees, advertising costs, reimbursements, and balances held by the marketplace.
You can use the suggested default accounts or select existing custom accounts. For an established client, I would check how the books are already structured before creating new codes. You want consistent reporting, not duplicate revenue and expense categories.
For a practice serving similar clients, a reusable mapping structure can make onboarding much easier. Link My Books also documents practice-level defaults in beta. Check each client's result rather than assuming one template is correct for every marketplace and tax jurisdiction.
For detailed setup options, refer to the Amazon-to-Xero mapping walkthrough or the Amazon-to-QuickBooks walkthrough.
A useful first test is to identify the destination of three lines: a sale, a refund, and a marketplace fee. If you cannot explain where they post, the mapping needs more attention before automation.
Try the complete workflow
Link My Books Free Trial + Free Onboarding
14-day free trial
Test the connection, settlement review, and accounting workflow. The provider advertises no card required.
Coupon VOVA20
Advertised 50% off for your first three paid months on eligible subscriptions. Confirm the offer at checkout.
Start Free Trial + Free Onboarding
Trial access, onboarding availability, and discount eligibility are subject to the terms shown when you sign up.
Step 3: Configure VAT and other tax rates carefully
Bookkeeping automation depends on correct tax treatment. Link My Books can suggest tax settings using the connected accounting system and business location, but it cannot make a professional judgment about every cross-border transaction.
For a UK client, review VAT registration status and the handling of standard-rated, reduced-rated, and zero-rated goods where applicable. Consider marketplace-collected taxes, overseas sales, refunds, and mixed-rate product groups. Requirements in other countries will differ.
Before approving the wizard, compare a small sample of real transactions with the tax treatment you expect. Keep documentation for unusual cases. After changes, check whether previously posted settlements must be corrected; new mappings do not automatically rewrite historical journal entries.
Important: Link My Books is an accounting workflow tool, not a substitute for tax advice. Use a qualified professional's interpretation of the client's registration status and jurisdiction-specific rules.
Step 4: Review, post, and reconcile marketplace settlements
After setup, choose a settlement that has a corresponding payout in the bank feed. Compare its individual components with the marketplace report, then post the summarized entry to Xero or QuickBooks Online using the selected workflow.
Imagine a settlement with £10,000 in sales, £900 in refunds, and £1,400 in marketplace charges. Ignoring other adjustments for this simple illustration, the payout would be £7,700. Your books should preserve the sales, refunds, and charges separately instead of treating £7,700 as gross revenue.
When the entry is available in the accounting system, compare it against the actual bank deposit. If it does not match, investigate withheld balances, timing differences, additional fees, currencies, or missing transactions before forcing a reconciliation.
Once you trust a sample, consider enabling automatic posting where it suits the client's controls. I would still maintain a regular exception review: automation can reduce repetitive steps, but discrepancies deserve human investigation.
If a posting fails with an incomplete account or tax code message, revisit the Accounts & Taxes wizard. The official troubleshooting guide explains what needs checking.
Step 5: Turn bookkeeping data into useful client reports
Link My Books' Financial Analytics tools let you examine more than a single payout. Review profitability by channel, compare periods, and investigate tax-related totals before preparing a client update.
| Report or view | Useful question |
|---|---|
| Overview | How have sales, costs, and overall results changed? |
| P&L by Channel | Which marketplace is contributing most to the result? |
| VAT Audit | Do tax-rate totals and classifications deserve closer review? |
| Industry benchmarking | Which operating ratios look unusual compared with available benchmarks? |
For example, a client might be growing rapidly on TikTok Shop while Amazon still generates more profit. A channel-by-channel view helps distinguish revenue growth from financial contribution. Benchmarks can suggest questions to investigate, but they are not a guarantee that two businesses are directly comparable.
As of the 2026 reporting update, the Overview report can be downloaded as a PDF, while P&L by Channel and VAT Audit exports are available as CSV files. The report export instructions explain how to select accounts and dates before downloading.
Step 6: Build a repeatable workflow across your client practice
Once one account is working well, document the process before onboarding ten more. Keep a record of account ownership, connected sales channels, chart mappings, tax assumptions, posting preferences, and who reviews exceptions.
Link My Books also supports team workspaces and permission-based access. Colleagues can work with client accounts without everyone sharing the same login. Check the correct team and channel when a client account appears to be missing.
I would run a consistent monthly review: confirm all expected settlements arrived, investigate posting errors, reconcile bank payouts, check important tax balances, then prepare a short performance summary. Clients value an accurate report more when you can explain what changed and why.
Account ownership matters here too. The owner normally controls billing and certain user settings; being invited as an accountant does not automatically give you permission to change every subscription. See the Teams guide for current collaboration details.
Link My Books pricing in 2026: small, medium, and large sellers
A separate Link My Books pricing excerpt compares three seller-size scenarios; those figures are not from the accountants-and-bookkeepers tutorial embedded above. The historical UK examples were £32, £59, and £203 per month, with corresponding US-dollar and Australian-dollar prices. Use the current plans below when budgeting.
Link My Books updated plan pricing from July 1, 2026. The table below matches the same order-volume and channel examples to published 2026 plan tiers, before taxes or coupons.
| Example | Earlier pricing example | 2026 plan and monthly price |
|---|---|---|
| 900 orders, 1 channel | £32 / $41 / A$63 | 1K Lite — £35 / $47 / A$68 |
| 4,500 orders, 3 channels | £59 / $75 / A$116 | 5K Pro — £68 / $90 / A$131 |
| 24,000 orders, 10 channels | £203 / $258 / A$396 | 25K Premium — £233 / $310 / A$450 |
Published price sources: GBP, USD, and AUD. These are separate published currency price lists, not exchange-rate calculations.
Plans are based on order volume and connected channels. For accountants, the important distinction is between a client's subscription and your practice's overall service pricing. Do not assume orders from unrelated client businesses can automatically be pooled into one subscription; verify account ownership and billing arrangements with the provider.
For a deeper discussion of pricing for accounting practices, see my Link My Books pricing review for accountants and bookkeepers. It includes historical examples, so check today's rates before purchasing.
Reader offer
Start with one client and use VOVA20 if eligible
Test a sales-channel connection, confirm the mapping, and reconcile a real payout during the free trial. If the software fits, use code VOVA20 for the advertised 50% off the first three paid months, subject to the offer accepted at checkout.
Confirm the applicable currency, taxes, plan limits, subscription ownership, and promotional conditions before paying.
Link My Books FAQ for accountants and bookkeepers
Does my client have to share marketplace passwords?
No. The accountant can invite the client to authorize their own supported marketplace connection. This is preferable to collecting seller credentials yourself. Authorization requirements depend on the channel.
Do I need Xero or QuickBooks Online?
One of those accounting connections is needed to complete initial setup. Link My Books also describes exporting settlement entries as CSV after setup if you later use another bookkeeping system, but its normal automated workflow is built around Xero and QuickBooks Online.
Does Link My Books file VAT returns automatically?
It helps organize transactions and tax-related reports, including a VAT Audit view. Your firm remains responsible for checking the tax treatment and completing any required filing through the appropriate process.
How can a practice keep month-end work under control?
Use a repeatable checklist for incoming settlements, mapped accounts, failed postings, bank reconciliation, tax review, and client reports. Keep an exception log and document who is responsible for correcting issues.
A practical way to get started
If I were evaluating Link My Books for an accounting practice, I would begin with one willing client and one completed payout cycle. Verify the connection, mapping, tax treatment, journal entry, and bank reconciliation before scaling the process.
The video helps introduce the product, and the updated pricing examples give you a budget reference. The bigger opportunity for accountants and bookkeepers is a dependable process that produces cleaner records and more useful conversations with ecommerce clients.