1. Home
  2. Bookkeeping
  3. Ledgerline
  4. Guide
  5. Shopify sales on your FreeAgent VAT return: boxes 1...

Shopify sales on your FreeAgent VAT return: boxes 1 and 6 explained

6 min readLedgerline

FreeAgent builds your VAT return from your books. If your Shopify sales are in FreeAgent the right way, boxes 1 and 6 fill themselves in. If they are in the wrong way, or twice, the return is wrong and FreeAgent will still let you file it.

This guide covers the sales side of the return for a UK VAT-registered Shopify store: what goes where, how your VAT scheme changes it, and how to check the figures against Shopify before you file.

Where FreeAgent gets the figures

FreeAgent works out the return from your invoices, bills, expenses and explained bank transactions. Under Making Tax Digital you cannot type figures into the boxes yourself. When you file, FreeAgent sends the totals in boxes 1 to 9 to HMRC, not the list of transactions behind them.

So the return is only as good as the way your Shopify sales were recorded. For Shopify sales, two boxes matter most. HMRC's VAT Notice 700/12 defines them:

  • Box 1 is the VAT due on your sales in the period. VAT on credit notes you issued, such as refunds, comes off it.
  • Box 6 is the total value of your sales, without VAT. It includes zero-rated and reduced-rate sales and exports, not only standard-rated ones.

Invoice basis or cash basis

FreeAgent supports both, and the choice changes when a Shopify sale reaches the return.

  • Invoice basis is the standard method. The VAT on an invoice counts in the period of the invoice, whether or not you have been paid.
  • Cash basis counts VAT when the money arrives. In FreeAgent, the VAT on a new invoice goes to a Deferred VAT account and only moves into box 1 once the invoice is marked as paid.

Most Shopify orders are paid at checkout, so the two methods usually agree. They differ when an order is paid later, for example by bank transfer, or when an invoice is never marked as paid in FreeAgent. On cash basis, an unpaid invoice is simply missing from the return. If box 1 looks low, check for invoices still waiting for a payment.

The Flat Rate Scheme

On the Flat Rate Scheme, you still charge your customers VAT at the normal rates, but you pay HMRC a fixed percentage of your sales including VAT. FreeAgent works this out for you. Two things surprise Shopify sellers:

  • The flat rate is applied to the gross figure. On a £1,200 sale including £200 VAT, a 13.5% flat rate means £162 to pay, not £135.
  • Zero-rated and exempt sales are included in your flat rate turnover too.

So on the Flat Rate Scheme, box 1 will not match the VAT shown in Shopify. That is expected. What still has to be right is the list of sales underneath it.

How to check the return against Shopify

Before you file, open the VAT return in FreeAgent and select the Full Report tab. It lists every invoice, credit note and transaction behind each box. Then compare it with two Shopify reports for the same dates:

  1. Taxes report. Shopify's Taxes finance report shows the tax charged on your sales, with a rate and an amount on each row. On the standard scheme with invoice basis, its UK VAT total should be close to box 1.
  2. Total sales by order. This report exports as a CSV with gross sales, net sales, taxes, returns and shipping for each order. Its net figure is the one to hold against box 6.

HMRC suggests one more quick test: if all your sales are standard-rated, box 1 should be 20% of box 6. If you also sell zero-rated or 5% items, the share will be lower. A share above 20% means something is wrong.

Why the figures do not match

  • Payouts recorded as sales. If you create an invoice for each order and also explain your Shopify payouts as sales, every sale is counted twice. Record payouts as transfers instead: see matching Shopify payouts and fees with a clearing account.
  • Refunds left out. A refund needs a credit note so that its VAT comes off box 1. See Shopify refunds as FreeAgent credit notes.
  • Pennies. Shopify takes VAT out of the price and FreeAgent adds VAT to the net price, so single orders can be 1p apart. See why Shopify and FreeAgent VAT is a penny out.
  • Other currencies. FreeAgent converts foreign currency invoices into pounds for the return, so the totals move slightly with the exchange rate. See Shopify orders in other currencies.
  • Customers outside the UK. Exports of goods are normally zero-rated and belong in box 6 but not box 1, and you need evidence that the goods left the UK. HMRC's VAT Notice 703 sets out the rules. Ask your accountant if you sell abroad regularly.
  • Quarter end. An order placed near midnight on the last day of the quarter can land in different periods, depending on which date and time zone each system uses. Check the orders around the quarter end in both.

Shopify's own fees are a purchase, but they can still reach box 1 and box 6. Where a bill is under the reverse charge, HMRC's rules (Notice 700/12, section 4.6) put it into boxes 1, 4, 6 and 7. Whether that applies depends on what each Shopify bill shows. See VAT on Shopify fees in FreeAgent for how to check and record them.

How Ledgerline fits in

We are building Ledgerline, a Shopify app that sends each paid order to FreeAgent as a sales invoice, so the sales side of the return comes straight from your Shopify orders.

  • Each invoice line uses the nearest VAT rate set up in your FreeAgent account (for example 20%, 5% or 0%), and the invoice VAT is matched to the VAT Shopify charged, to the penny.
  • The invoice is dated with the date Shopify processed the order (in UTC, which matches UK time outside British Summer Time), and marked as paid into the FreeAgent bank account you choose, so it also counts on cash basis.
  • Refunds become credit notes, which take their VAT off box 1.
  • If your FreeAgent company is not VAT registered, Ledgerline records the full amount the customer paid with no VAT split.
  • Ledgerline does not record Shopify payouts or fees, and it does not choose your VAT scheme or file the return. FreeAgent and your accountant still do that.

Ledgerline is in review for the Shopify App Store and not available yet. Leave your email below and we will tell you once when it is live. For the options available today, see FreeAgent Shopify integration discontinued: what to do now.

Notify me at launch

Get one email when Ledgerline is live on the Shopify App Store.

We store your email, the shop URL if you give one, and the time you agreed. We use them to send one email when Ledgerline launches on the Shopify App Store, then delete the list. We send nothing else and share it with no one. To be removed at any time, use the delete link we show after you sign up or email kyle@skillmerc.com.


More Shopify and FreeAgent guides

Ledgerline: Shopify to FreeAgent

Selling on WooCommerce instead?

Our free plugin Skillmerc Sync for FreeAgent sends paid WooCommerce orders to FreeAgent as invoices with VAT, marked as paid. Guides: send WooCommerce orders to FreeAgent and WooCommerce FreeAgent integration options.

LedgerlineGet the launch email