MTD for VAT in Excel, with ACE Complete

Prepare your Making Tax Digital VAT return from a spreadsheet you own, with an interactive dashboard and management reporting. One off price.

MTD for VAT spreadsheet with a VAT summary

Making Tax Digital for VAT, still in Excel

Since April 2022, all VAT registered businesses have had to follow Making Tax Digital for VAT, keeping digital records and filing through compatible software. HMRC allows spreadsheets, as long as there’s a digital link to the software that submits your return, usually bridging software.

What ACE Complete gives you

VAT return preparation, MTD compliant.

Interactive dashboard for business performance at a glance.

Advanced management reporting.

Everything in ACE Professional: bank reconciliation for up to three accounts, income and expenses, invoices, monthly profit and loss, estimated tax and quarterly Income Tax figures.

ACE Complete dashboard mock-up with illustrative figures

VAT and Income Tax in one place

From April 2027, many VAT registered sole traders also join Making Tax Digital for Income Tax. ACE Complete covers both, so you’re not paying for two systems.

Avoid the classic VAT spreadsheet mistakes

Rounding on totals instead of each line, mixing gross and net figures, and forgetting zero VAT purchases are the errors I see most. ACE Complete is built so those figures calculate consistently every quarter. Read Making Tax Digital for VAT in Excel for more.

About Traci

I’ve worked in accountancy since I was 17, I’m AAT qualified, part CIMA qualified and a Microsoft Excel MVP.

What my customers say

What my customers say

5.0★★★★★20 Google reviews
★★★★★

I did the mini Excel course with Traci - 20 mins a day for 5 days. Traci can squeeze so much into 20 mins, it helps that she talks fast! I was familiar with most of the areas that we covered but there were still lots of little tips that I picked up. Traci has a genuine excitement about all things Excel and her enthusiasm is infectious. I'd recommend her courses to anyone looking to upskill.

Fay · 6 months ago
★★★★★

Traci is amazing!!
She helped me to add formulas to a huge spreadsheet I’ve designed to use in my NHS job.
In 30 minutes the spreadsheet was transformed into a useable, time saving and accurate piece of work.
I’m very grateful for her help.
Traci is approachable, kind and knows her stuff.
I recommend her to anyone struggling with anything in Excel. She is patient - she needed to be with me, taking her time to explain and ensure I understood.
Thanks again Traci 🥰

Claire Perrott · a year ago
★★★★★

The 5-day 20 minute sessions were very informative and easy to follow.

Eddie Hodges · a week ago
★★★★★

I have recently been on Traci's Beginner, Intermediate and Advanced Excel Workshops. I didn't know spreadsheets could be so much fun and you could do so much with them, once you have got your head around one. Tracie makes working with a spreadsheet a joy instead of a task. Her cheerful approach and easy-going manner are both professional and a breath of fresh air.

Angelichuman08 · 5 years ago
★★★★★

I had several absolutely excellent Excel intermediate and advanced sessions with Traci. She is extremely knowledgeable and makes the sessions fun and interactive ~ both face to face and virtual. I would definitely recommend Traci if you need some Excel training ~ she's excellent!

Nancy Whittaker · 5 years ago
★★★★★

Traci was excellent in her Basic Excel workshops - she was really patient and made a scary subject feel really easy! This was such a valuable course which I would recommend anyone to try.

Karl Falconer · 4 years ago
★★★★★

Traci at Excel Ace really knows her stuff, I've been using an amazing spreadsheet daily that she designed many many years ago to keep track of the workshops we are delivering and all the finances and forecasting. I couldn't recommend her services highly enough, she is just fantastic and so helpful also.

Street Style Surgery · 5 years ago
★★★★★

Traci has been training a number of our staff via zoom over the past few weeks, and everyone has greatly benefited from her encyclopaedic knowledge of all things excel. Very approachable and bubbly, she makes what could be a very dry subject, easy and fun.

Claire Piercy · 5 years ago
★★★★★

Traci has done several sessions of training for me and my staff at Bevie. Whilst remaining absolutely professional has brought a fresh lease of life to excel and the great training has allowed the team to big great things and make better use of their days. Thanks Traci!

Ste Haynes · 5 years ago
★★★★★

I took part in Traci's advanced Excel workship and found her insights into spreadsheets very accessible and time saving. Would definitely recommend!

Chris · 5 years ago
★★★★★

Tracie Williams is a master in her field. definitely recommend if you are looking to upskill your Excel Knowledge.

oliver Shepherd · 2 years ago
★★★★★

I loved the training, super engaging and fun! Traci is a lovely person to host the sessions.

Andreea Cosmina · 2 years ago
★★★★★

Tracy’s courses are A ‘must do’ for all Excel users of all standards. First class!

David Elliott · 5 years ago
★★★★★

Really enjoyed Traci’s teaching style, relaxed and informal, yet very knowledgeable. Would definitely recommend.

Roxanne Lally · 5 years ago
★★★★★

Traci is enthusiastic and always willing to help. Just don't get her on the subject of 'Index and Match'

Jon Mackney · 4 years ago
★★★★★

Couldn't recommend highly enough, very helpful and showed great understanding of our processes to create a dynamic solution. Thank you

Terry Hannigan · 2 years ago
★★★★★

Very informative ,professional brilliantly set out I am looking forward to next sessions.

Gary Jopson · 3 years ago
★★★★★

Brilliant service, would highly recommend to anyone

kyle ingram · 2 years ago

Frequently asked questions

Yes. HMRC allows spreadsheets for MTD for VAT, as long as there’s a digital link between your records and the software that submits your return, usually bridging software.

No. ACE Complete prepares your VAT return figures, and HMRC compatible bridging software submits them. The bookkeeping models work with My Tax Digital, which is free, as well as paid options.

Yes. ACE Professional and ACE Complete are both suitable for limited companies. Limited companies aren’t part of Making Tax Digital for Income Tax, but VAT registered companies already follow MTD for VAT.

All VAT registered businesses, whatever their turnover, since April 2022.

Yes. It includes everything in ACE Essentials and Professional, so your quarterly Income Tax figures are covered too.

£699 + VAT one off, with an optional £199 + VAT a year compliance and update plan.

All of them, including the standard scheme, flat rate and cash accounting. ACE Complete prepares your VAT return figures whichever scheme you use, and HMRC compatible bridging software submits them.

Ready to get started?

VAT registered? Book a FREE Bookkeeping Demo and I’ll show you ACE Complete with your type of business.

Join the Excel Ace community!
Get FREE Excel tips, guides, and industry insights delivered straight to your inbox. Sign up for our newsletter today!
Name