Shopify Bookkeeping Explained: How to Reconcile Payouts Without the Headache

by Ariful | Mar 17, 2026 | E-Commerce

Why Reconciliation is Your Secret Weapon

Reconciliation is simply the process of ensuring that your internal records (Shopify) match your external records (your bank account). If these two don’t talk to each other correctly, your financial reports are essentially fiction.

For UK Limited Companies, getting this right is non-negotiable. HMRC doesn’t just want to see what landed in your bank; they want to see the gross sales before fees. If you only record the net amount that hits your bank, you are underreporting your turnover, which can lead to massive headaches during an audit.

Step 1: Understanding the “Payout” Gap

The biggest hurdle in Shopify bookkeeping is the “Payout.” Shopify doesn’t send you money for every individual order. Instead, they bundle several orders together, subtract their processing fees, subtract any refunds, and then send a lump sum to your bank.

To reconcile this, you need to look at three specific numbers for every payout:

1. Gross Sales: The total amount your customers paid.
2. Fees: What Shopify (or PayPal/Stripe) took for the transaction.
3. Net Payout: The actual cash that landed in your business bank account.

If you don’t separate these, your Profit & Loss statement will be inaccurate, and you’ll likely miss out on claiming those transaction fees as a business expense.

Step 2: The Practical Workflow for UK Sellers

Don’t wait until the end of the quarter to do this. We recommend a weekly or bi-weekly routine. Here is how you should approach it:

• Export your Shopify Payout Reports: Go to Settings > Payments > View Payouts. This will give you the itemized breakdown of which orders are included in a specific bank deposit.
• Match the Date, not the Order: Shopify payouts usually lag by 2-3 days. Don’t look for the sale date; look for the payout date provided in your Shopify admin.
• Account for the “Ghost” Fees: Remember that if you use Shopify Payments, the fee is taken out before it hits you. If you use PayPal, the full amount might hit Shopify, but PayPal takes their cut separately. This is a common trap that leads to major e-commerce bookkeeping mistakes.

Step 3: Handling the VAT Maze (Shipping & Discounts)

This is where things get tricky for UK sellers. VAT isn’t just on the product; it’s on the total value of the supply.

VAT on Shipping

In the UK, if the item you are selling is standard-rated (20%), the shipping charge is also standard-rated. Many sellers accidentally categorize shipping as “exempt” or “zero-rated,” which is a quick way to get on HMRC’s bad side. When reconciling your payouts, ensure the VAT collected on shipping is accounted for in your VAT return.

The Discount Trap

If you offer a “Buy One Get One Free” or a 20% discount code, you only owe VAT on the actual amount received.

• Correct: Sale is £100, Discount is £20, customer pays £80. You pay VAT on £80.
• Incorrect: Recording the sale as £100 and the discount as an “expense.” This results in you overpaying VAT by £4.

Step 4: Dealing with Refunds and Adjustments

Refunds are a nightmare for manual bookkeeping. When a customer gets a refund, Shopify often deducts that amount from your future payouts.

This means your bank deposit might be significantly lower than your sales for that week. You must ensure your bookkeeping software reflects the refund as a reduction in sales and a “negative” VAT entry. If you don’t reconcile these adjustments, you end up paying tax on money you’ve already given back to the customer.

Step 5: Stop Doing It Manually (The Power of Automation)

If you are still using a spreadsheet to track Shopify sales, we need to have a serious talk. It is 2026, and manual entry is the fastest way to invite human error and HMRC penalties.

Using tools like Xero or QuickBooks integrated with Shopify is a start, but even then, the “out of the box” integrations often dump data in a way that is hard to reconcile. Many high-growth brands partner with professional compliance services to manage the bookkeeping, VAT calculations, and year-end filings.

Why UK Sellers Face Unique Challenges in 2026

HMRC has become increasingly digital. With the latest updates in 2026, there is a heavier focus on real-time data accuracy. If you are selling across borders: perhaps to the EU or the US: the complexity triples.

For instance, if you are holding stock in the EU to speed up delivery, you likely have VAT obligations in those specific countries. Reconciling payouts then involves multi-currency accounting and different VAT rates (like 19% in Germany vs. 21% in Spain).

A Simple Checklist for Your Next Reconciliation

To make your life easier, use this 5-point checklist every time you sit down to do your books:

1. Does the Net Payout match the Bank Deposit exactly? (Down to the penny).
2. Are the Shopify Fees recorded as an expense? (Don’t just record the net income).
3. Is the VAT on Shipping correctly categorized? (Usually matches the product rate).
4. Are Refunds accounted for in the correct period? (Timing is everything).
5. Are your Sales Funnel metrics aligned? (Ensuring your performance indicators match your financial reality).

7 Mistakes You’re Making with Amazon Payouts (and How to Fix Them)

by Ariful | Mar 17, 2026 | E-Commerce

For many Amazon FBA sellers, the “Disbursement Initiated” email is the highlight of the week. It represents the hard work of sourcing, listing, and shipping finally hitting your bank account. However, that number you see in your bank statement is rarely the number you should be recording in your accounts.

If you are treating your Amazon payout as your total revenue, you are likely making a series of expensive mistakes. In the world of e-commerce, what you receive is the “net” amount, what’s left over after Amazon has taken its pound of flesh.

Mismanaging these payouts doesn’t just lead to messy books; it leads to overpaying tax, underestimating your margins, and potential trouble with authorities like HMRC or the IRS. As your dedicated amazon seller accountant uk, we see these pitfalls every day.

Here are the seven most common mistakes sellers make with Amazon payouts and, more importantly, how you can fix them to ensure your business remains compliant and profitable.

1. Confusing Net Payout with Gross Revenue

This is the single most common mistake in ecommerce bookkeeping. When Amazon deposits £5,000 into your account, that is not your “sales” figure. Your actual sales might have been £7,500, but Amazon deducted £2,500 in fees and advertising before sending you the rest.

If you only record the £5,000 as income, your records are inaccurate. This matters because tax authorities require you to report your gross turnover. Furthermore, in the UK, the VAT registration threshold (currently £90,000) is based on gross turnover, not your net profit.

How to fix it:

Always record the gross sales amount and then record the Amazon fees as a separate expense. This gives you a clear view of your actual business size and ensures you are tracking toward the VAT threshold correctly. Understanding VAT sales vs non-VAT sales is essential for getting this right.

2. Ignoring the Complexity of Amazon Fees

Amazon doesn’t just charge one fee. Your payout is hit by referral fees, FBA fulfillment fees, storage fees (which spike in Q4), and often “Inbound Placement Fees.”

If you don’t break these down, you cannot see where your money is going. Many sellers are shocked to find that a product they thought was profitable is actually losing money once the storage and return fees are factored in.

How to fix it:

Download your Settlement Reports regularly. Don’t just look at the total; look at the line items. If you see high storage fees, it’s a signal to liquidate slow-moving stock. We help our clients by taking this raw data and turning it into structured financial reports, so you always know your true margins.

3. Miscalculating VAT on Amazon Fees

For UK and EU sellers, VAT on Amazon fees is a frequent source of confusion. Amazon typically bills its fees from a different jurisdiction (like Amazon Lux for EU/UK sellers). Depending on your VAT status and whether you have provided your VAT number to Amazon, they may or may not charge you VAT on these fees.

If you are VAT registered, you usually account for this via the “reverse charge” mechanism. If you aren’t VAT registered, that VAT is a cost to your business that you cannot claim back.

How to fix it:

Ensure your VAT number is uploaded to Seller Central correctly. Check your “Amazon Tax Document Library” every month to download the specific VAT invoices for fees. These are separate from your payout reports but are vital for your ecommerce bookkeeping.

4. Failing to Reconcile Payouts with Bank Statements

A payout initiated on the 28th of the month might not hit your bank until the 2nd of the next month. If you are trying to match your bank statement to your Amazon sales for a specific month, the numbers will never align.

This “timing difference” is the bane of many sellers’ existence. Without proper reconciliation, you end up with “phantom” money or missing transactions that make your year-end accounting a nightmare.

How to fix it:

Use a settlement-based approach. Match your bank deposit to the specific Amazon Settlement ID. This ensures that every penny is accounted for, regardless of which month it hits your bank. If this sounds overwhelming, when should you hire an accountant becomes a very relevant question for your growing business.

5. Overlooking Refunds and “Invisible” Deductions

When a customer returns an item, Amazon deducts the refund from your next payout. They also charge a “Refund Administration Fee.”

Sellers often forget to account for these deductions, leading them to believe they made more sales than they actually kept. Additionally, there are “reimbursements” (when Amazon loses your stock) which are actually income and should be recorded differently than a standard sale.

How to fix it:

Categorize every transaction type within your settlement report. Ensure refunds are deducted from your gross sales and reimbursements are added back correctly. Tracking these “invisible” numbers is key to maintaining a healthy cash flow.

6. Getting Cross-Border VAT and Sales Tax Wrong

If you are selling in the USA, Canada, or across the EU, your payouts become significantly more complex. In the US, Amazon may collect and remit Sales Tax for you in many states, but you still have a filing obligation in others.

In the EU, selling across borders involves navigating the One-Stop Shop (OSS) or local VAT registrations. For instance, if you are storing goods in Sweden, you must understand VAT registration in Sweden and how those sales impact your payouts.

How to fix it:

Don’t guess. Each jurisdiction has different rules. At Sterlinx Global, we provide a full compliance suite for the UK, USA, Canada, and Australia, and handle VAT registrations and filings across the EU. We take your raw transaction data and ensure you are compliant in every market you touch.

7. Relying on Manual Data Entry (The Spreadsheet of Doom)

When you start, a spreadsheet is fine. When you scale, a spreadsheet is a liability. Manually typing in numbers from Amazon reports leads to typos, missed rows, and hundreds of hours of wasted time.

Manual entry also makes it nearly impossible to keep up with UK tax tips to run your business accounting because you are too busy fighting with cells and formulas to actually look at the tax-saving opportunities.

How to fix it:

Automate. Use software that bridges the gap between Amazon and your accounting platform, or better yet, partner with a compliance suite that handles the data integration for you. At Sterlinx Global, our model is simple: you provide the data, and we complete the compliance and bookkeeping on a daily basis.

Summary Checklist for Amazon Payout Success

To keep your business on the right side of the law and your profits high, follow this quick checklist:

• Gross vs. Net: Always record the total sales before Amazon takes their fees.
• Download Invoices: Get your monthly VAT invoices for fees from the Tax Document Library.
• Check Categories: Ensure your products are in the right categories so you aren’t being overcharged on referral fees.
• Reconcile Monthly: Match each bank deposit to its corresponding Settlement ID.
• Track Refunds: Record both the customer refund and the administration fee separately.
• Understand Your Jurisdictions: Know the VAT and Sales Tax rules for each country you sell in.
• Automate Your Data: Stop manually entering numbers and invest in accounting software or a compliance partner.