-
Working inside Link My Books: what LedgerBPO does
Link My Books bookkeeping services from LedgerBPO give online sellers a named accountant who sets up and maintains your Link My Books tax and account mappings, reviews every Amazon, eBay, Shopify and Etsy settlement summary before it posts to Xero or QuickBooks Online, matches each one to the bank, and reconciles the clearing accounts so VAT is right.
01 / 06 -
Your subscription, your data
Link My Books bookkeeping services from LedgerBPO give online sellers a named accountant who sets up and maintains your Link My Books tax and account mappings, reviews every Amazon, eBay, Shopify and Etsy settlement summary before it posts to Xero or QuickBooks Online, matches each one to the bank, and reconciles the clearing accounts so VAT is right.
02 / 06 -
Inside your file
Settlement summaries reviewed and matched to the bank every cycle
03 / 06 -
Reconciled on a calendar
VAT rates and account mappings maintained as marketplaces change fees
04 / 06 -
Reviewed before you see it
Clearing accounts reconciled to the marketplace balance monthly
05 / 06 -
A named accountant, a backup and a team lead
Inside your own software, on a fixed close calendar, with a reply from a person within 1 business day. Call +1-657-777-0006 or start a quote.
Get a custom quote 06 / 06
Why businesses on Link My Books outsource
Link My Books was built for UK sellers who need VAT handled properly on marketplace sales, and it does that well. What it cannot do is check itself. A new Amazon fee type lands unmapped, a summary posts twice after a reconnection, an EU sale is treated as UK-rated, and the Xero clearing account drifts away from the marketplace balance. Sellers only notice when the VAT return looks wrong.
A dedicated accountant reviews Link My Books rather than trusting it blindly. We build the mapping by channel, fee type and VAT rate, check every summary against the settlement report, match it to the bank, and reconcile the clearing account monthly. The VAT return workings then come from figures that have been checked, and you or your accountant submit them.
What we do inside Link My Books
Account and VAT rate mapping
We map every Link My Books transaction type, sales by VAT rate, refunds, referral and FBA fees, advertising, reimbursements and reserves, to the right Xero or QuickBooks Online account and tax rate, and update it when marketplaces change.
Settlement summary review
Each summary is checked against the marketplace settlement report before or after posting so the split between sales, fees and VAT agrees with what the marketplace shows.
Bank matching
Every posted summary is matched to its bank deposit in Xero or QuickBooks Online, with reserves and timing differences explained, so the bank feed stays clean.
Clearing account reconciliation
The clearing account for each channel is reconciled to the marketplace balance, including reserves and unsettled funds, at every month-end.
Multi-channel sellers
Amazon, eBay, Shopify and Etsy each get their own connection and clearing account so channel margin is visible and nothing is double-counted.
VAT return workings
We summarise UK, EU and marketplace-collected VAT from the posted summaries into VAT return workings that you or your accountant submit under Making Tax Digital.
Integrations we reconcile
- XeroSettlement summaries posted as invoices with VAT rates set, matched to the bank feed.
- QuickBooks OnlineSummaries posted with tax codes checked and clearing accounts reconciled monthly.
- Amazon Seller CentralUK and EU marketplace settlements summarised by Link My Books, checked by us against the original report.
- ShopifyShopify Payments payouts summarised with other gateways handled separately.
- PayPalPayPal receipts from eBay and Etsy reconciled alongside the Link My Books summaries.
- DextSupplier invoices for stock purchases captured in Dext and matched to the cost of sales.
Migration to and from Link My Books
Moving to Link My Books
Setting up Link My Books starts with the VAT position: registered or not, which marketplaces collect VAT on your behalf, and whether you sell into the EU. We create the clearing, fee, refund and reserve accounts, connect each channel and the ledger, build the mapping by VAT rate, and post the first settlements with a full check against the settlement reports. Back months can be posted in a batch.
Moving from Link My Books
Moving from Link My Books to A2X or manual settlement journals starts with the last posted summary. We confirm every settlement up to the switch date has posted once and matched the bank, reconcile each clearing account to the marketplace balance, export the mapping so it can be rebuilt, and disconnect only after the new method has posted its first settlement correctly.
Common Link My Books reconciliation problems we fix
Unmapped fee types in suspense
A new Amazon or Etsy fee appears and Link My Books parks it until someone maps it. We review the mapping every month and clear anything sitting unmapped.
Summaries posted twice
A reconnection or a manual re-send can post the same settlement twice and double sales for the period. We check for duplicates by settlement reference before matching to the bank.
EU or marketplace-collected VAT treated as UK sales
Post-Brexit, sales to EU customers and sales where the marketplace collects VAT need different treatment. We map them by rate so the VAT return does not overstate output tax.
Clearing account drifts from the marketplace balance
Reserves, refunds and timing differences make the bank deposit smaller than the summary. We reconcile the clearing account to the marketplace balance monthly so every difference is explained.
Settlement spans month-end
A fortnightly settlement often crosses a month boundary and lands sales in the wrong period. We use the month-end split so each month carries its own sales and fees.
Other payments & e-commerce platforms
Frequently asked questions
Do you work inside my existing Link My Books account?
Yes. You add us as a user in your own Link My Books account, or your accountant grants access from their partner dashboard. You keep ownership of the subscription, the marketplace connections and the ledger. We maintain the mapping, review and post summaries, and reconcile; the settings and connections stay yours.
How much does Link My Books bookkeeping support cost?
Pricing depends on volume and scope, so we send a custom quote within 1 business day. The main drivers are settlements and channels per month, whether you sell into the EU or other countries, whether stock and cost of sales are in scope, and whether VAT return workings and monthly bookkeeping are part of the same engagement.
Does Link My Books handle my VAT return?
It posts sales and fees with VAT rates set, which feeds the VAT return in Xero or QuickBooks Online. We check those rates, reconcile the figures and prepare the return workings; you or your accountant submit under Making Tax Digital. Our UK VAT returns service covers the submission side.
How do you handle Amazon reserves in Link My Books?
The reserve movement in each settlement is mapped to a reserve receivable rather than to sales or fees, and that receivable is reconciled to the reserve shown in Seller Central each month. When Amazon releases the reserve, the receivable clears against the deposit.
Can you set up Link My Books for eBay and Etsy as well as Amazon?
Yes. Each channel gets its own connection, clearing account and VAT mapping, and PayPal receipts from eBay or Etsy are reconciled alongside. Channel-level sales and fees are then visible in the ledger. Our ecommerce accounting service explains the multi-channel setup.
Can you fix a Link My Books setup that has posted VAT wrong for several quarters?
Yes. We scope it as a cleanup: review the mapping, identify the periods affected, reverse or reclassify the posted summaries, check for duplicates, reconcile each clearing account and prepare corrected VAT workings for your accountant to assess. Then the account moves to the monthly review service.
Ask an AI assistant to summarize this page
Opens the assistant with a prefilled prompt so you can check our claims against the page yourself.