LinkMyBooks Amazon FBA UK Setup: The Only Integration Guide You Need for 2026

By Connor · 16 February 2026

Most Amazon FBA sellers in the UK are doing their bookkeeping wrong. They're either drowning in Excel spreadsheets or paying their accountant £200+ every month to decipher Amazon's settlement reports. LinkMyBooks fixes this - but only if you set it up correctly. Get it wrong, and you'll be explaining discrepancies to HMRC while your competitor is already reinvesting their profits.

I've seen sellers spend three months trying to reconcile their Amazon payments manually. Three months. That's a quarter gone because they couldn't be bothered to spend 30 minutes setting up LinkMyBooks properly. The irony? LinkMyBooks costs less than what most people spend on coffee in a week, but it'll save you more time than any other tool in your stack.

Let me walk you through the exact setup I use for my own FBA business. This isn't theory - it's the system that's handled over £400k in Amazon sales without a single reconciliation nightmare.

First, understand what LinkMyBooks actually does. It reads your Amazon settlement reports and automatically creates the correct journal entries in your accounting software. Sounds simple? It is, once you know which buttons to press. Most people connect their Amazon account, see some numbers appear in Xero or QuickBooks, and think they're done. Wrong. Dead wrong.

> Quick reality check: Amazon settlement reports are not the same as your actual sales. They include refunds, fees, adjustments, and a dozen other line items that need to be categorised correctly for HMRC. LinkMyBooks handles this automatically, but only if you tell it what you're selling and where.

Start with your Amazon Seller Central account connection. Log into LinkMyBooks, hit 'Add Marketplace', and select Amazon UK. You'll need your Seller ID (not your account email - the actual seller ID from your account info page). The connection takes about 2 minutes to authenticate. Don't panic if it shows 'pending' for a few hours - Amazon's API can be slow.

Here's where most people mess up: the product categorisation. LinkMyBooks needs to know what you're selling so it can assign the correct VAT rates and expense categories. If you're selling books (standard rated), electronics (standard rated), or children's clothing (zero rated), this matters for your VAT return. Set this up wrong, and you'll be manually adjusting entries later.

The mapping screen looks intimidating but it's straightforward. You'll see a list of all your ASINs on the left, and category dropdowns on the right. For most FBA sellers doing online arbitrage or wholesale, everything will be 'Standard Rate Sales' at 20% VAT. If you're selling zero-rated items like children's books or clothes, mark them correctly. This isn't optional - it's compliance.

Now for the technical bit. LinkMyBooks creates journal entries based on Amazon's settlement periods, not when you actually made sales. This means if Amazon settled £1,000 on Tuesday, that's when the journal entry appears in your accounts, even if those sales happened over the previous two weeks. This is actually correct for cash accounting, which most small FBA businesses use.

The fee breakdown is where LinkMyBooks really shines. Amazon charges FBA fees, referral fees, storage fees, and about fifteen other random charges that change monthly. LinkMyBooks automatically categorises these into the right expense accounts. FBA fees go to 'Fulfilment Costs', referral fees to 'Platform Fees', and storage fees to 'Warehouse Costs'. Your accountant will love you for this.

But here's the kicker - and this is where the seasonal strategy piece comes in - LinkMyBooks tracks your fee percentages over time. During Q4, your FBA fees as a percentage of sales typically drop because you're moving more volume through the same fixed costs. I've seen sellers go from 15% total fees in March to 11% in December just through volume efficiency. LinkMyBooks shows you this automatically in the dashboard.

For your financing stack, clean books aren't just nice to have - they're essential. Whether you're applying for invoice financing, asset-based lending, or even just a business credit card, lenders want to see professional accounts. LinkMyBooks gives you that. I know sellers who've secured £50k credit lines purely because their books were pristine from day one.

The SAS walkthrough integration is brilliant if you're using SellerAmp SAS for product research. When you buy products that SAS flagged as profitable, those purchase costs need to flow correctly through your accounts. LinkMyBooks handles the sales side automatically, but you still need to track your cost of goods sold properly. Most sellers use a simple spreadsheet for purchases and let LinkMyBooks handle everything else.

One mistake I see constantly: people connect LinkMyBooks but don't set up the bank reconciliation properly. Your Amazon settlements hit your bank account, but the timing doesn't always match LinkMyBooks' journal entries. Amazon might settle on Friday but your bank doesn't process until Monday. Set up a 'Amazon Settlements' bank account in your accounting software and reconcile weekly, not daily.

The reimbursement handling is crucial for FBA sellers. When Amazon loses your inventory or damages products, they reimburse you. These aren't sales - they're recoveries of lost stock. LinkMyBooks categorises these correctly as 'Reimbursements' rather than 'Sales', which keeps your revenue figures clean and your cost of goods sold accurate.

For multi-marketplace sellers, LinkMyBooks scales beautifully. Connect your UK, DE, FR, IT, and ES accounts separately. Each marketplace has different VAT rules and settlement currencies. The EU marketplaces settle in EUR, so you'll see exchange rate adjustments in your accounts. This is normal and expected.

The reporting side is where you'll spend most of your time after setup. The profit and loss report shows your true Amazon profitability after all fees. I check this weekly, not monthly. If your margin drops below 30% for two consecutive weeks, something's wrong. Either your fees have increased, your product mix has shifted, or you're getting hammered by returns.

Currency handling matters more than people think. If you're buying in USD but selling in GBP, your true margin depends on exchange rates. LinkMyBooks shows your Amazon revenue in GBP (obviously), but if your cost of goods sold is in USD, you need to track exchange rate gains and losses. This is where a proper seasonal strategy comes in - hedge your currency exposure during Q4 when your volume peaks.

The integration with Xero is smoother than QuickBooks in my experience. Fewer mapping errors, faster sync times, and better handling of multi-currency transactions. If you're choosing accounting software specifically for Amazon FBA, go with Xero. The monthly cost difference is negligible but the time savings are real.

Troubleshooting is inevitable. Sometimes Amazon changes their settlement report format and LinkMyBooks takes a few days to adjust. Keep a backup of your original settlement reports for the first three months until you trust the system. I've never needed them, but better safe than sorry.

The real power comes from the data over time. After six months, you'll see patterns. Your FBA fees are higher in January (long-term storage charges). Your refund rate spikes during gift-giving seasons. Your average selling price varies by month as your product mix changes. This data drives better purchasing decisions.

For sellers doing Amazon-to-Amazon arbitrage, the category mapping gets trickier. You might buy books but sell in Electronics if they're tech manuals. LinkMyBooks doesn't automatically detect this - you need to map each ASIN correctly based on how Amazon categorises it for fees, not what the product actually is.

The VAT reporting feature saves hours during quarterly returns. Instead of manually adding up your Amazon sales from three months of settlement reports, LinkMyBooks gives you a clean summary. Your accountant can complete your VAT return in 15 minutes instead of 2 hours. That's £300+ saved every quarter if you're paying hourly rates.

One final technical note: the API connection sometimes hiccups during Amazon's system updates. This usually happens overnight and resolves automatically. If you see 'Connection Error' for more than 24 hours, disconnect and reconnect your marketplace. Don't create duplicate connections - that creates duplicate transactions.

Setup takes 30 minutes. The time savings start immediately. After three months, you'll wonder how you ever managed without it. After six months, your accountant will be sending you Christmas cards.

Proper bookkeeping isn't glamorous, but it's the difference between a hobby and a business. LinkMyBooks turns the most tedious part of Amazon FBA into a completely automated system. Set it up correctly once, and your books will be audit-ready from day one. That's not just convenient - it's competitive advantage.

Frequently Asked Questions