top of page
Accounting services. Find an accountant. Business tax accountant. Accountant. Accountant's phone number. Accounting company. professional services accounting. Accountants. Find an accountant. Find an accountant. accounting services. accounting services. personal accountant. local accountants near me. Affordable accountants. Find a new accountant. accounting services. business tax accountant. Accounting services. personal accountant. company accountants. accounting and tax services. accountants service. accountant payroll services. small business accountants. accounting and financial services. accountants for it consultants. acca find an accountant. financial services accounting. professional services accounting. qualified accountant. sme accounting services. small business accounting services. accountant for startup business.
Find a qualified Accountant
Blog Posts

How to Integrate MTD Bridging Software With Excel in Under 5 Minutes

  • Jul 25
  • 5 min read

If you’re a small business owner in the UK, you’ve likely heard the term "Making Tax Digital" (MTD) more times than you’d care to count. For many, the transition to MTD felt like a forced goodbye to their beloved Excel spreadsheets. But here’s a secret that many accountants aren't shouting from the rooftops: you don’t have to give up your spreadsheets.

By using MTD bridging software, you can keep your existing bookkeeping process in Excel while remaining 100% compliant with HMRC’s digital requirements. In this guide, I’m going to show you exactly how to integrate bridging software with your Excel workbook in under five minutes.

Why Excel Users Are Choosing Bridging Software

For years, Excel has been the backbone of SME accounting. It’s flexible, familiar, and: most importantly: it doesn’t come with a monthly subscription fee that eats into your margins. However, HMRC now requires "digital links" between your records and their systems. You can no longer simply type your totals into the Government Gateway portal manually.

This is where bridging software comes in. It acts as the "translator" between your spreadsheet and HMRC's API. It reads the data from your cells and sends it securely to the taxman. It’s the perfect middle ground for businesses that aren't ready to move to full-blown cloud accounting apps like Xero or QuickBooks. If you're still weighing up the options, check out our deep dive on MTD bridging software vs. full apps to see which fits your workflow better.

Step 1: Prep Your Excel Spreadsheet (The "Digital Record")

Before you even open a piece of bridging software, your Excel sheet needs to be "MTD-ready." This doesn't mean a total redesign, but it does mean your data needs to be structured so the software can read it.

Organize Your Totals

Whether you’re filing for VAT or preparing for the upcoming MTD for Income Tax (ITSA), you need a summary tab.

For VAT, you should have a dedicated area or worksheet that lists the 9 standard VAT boxes:

  1. VAT due on sales

  2. VAT due on acquisitions from EC member states

  3. Total VAT due

  4. VAT reclaimed on purchases

  5. Net VAT to pay or be repaid

  6. Total value of sales (excl. VAT)

  7. Total value of purchases (excl. VAT)

  8. Total value of all supplies of goods to EC member states

  9. Total value of all acquisitions of goods from EC member states

The Golden Rule: These boxes must be populated using formulas (e.g., =SUM(B2:B50)), not by typing the numbers in manually. HMRC requires a "digital link," which means the data must flow automatically from your individual transactions to the final summary.

A diverse small business owner looking relieved and smiling while working on a laptop with the Accountant Search logo in the corner.

Step 2: Choose and Authorize Your Bridging Tool

There are dozens of HMRC-recognized bridging tools available. Some are standalone web apps where you upload your file, while others are "Excel Add-ins" that live directly inside your ribbon.

Once you’ve chosen your tool, the first thing you’ll need to do is Authorize with HMRC. This usually takes about 60 seconds:

  1. Open your bridging software.

  2. Click "Connect to HMRC" or "Authorize."

  3. You will be redirected to the official Government Gateway website.

  4. Log in with your credentials and grant the software permission to "view and change your VAT/Tax information."

This authorization typically lasts for 18 months before you need to click the button again. It’s a secure handshake that tells HMRC, "I trust this software to send my data."

Step 3: Mapping Your Cells (The "Magic" Step)

This is the part that often intimidates people, but it’s actually the simplest bit. "Mapping" just means telling the software which Excel cell corresponds to which tax box.

If you’re using a Web-based Uploader:

You’ll usually be asked to upload your .xlsx file. The software will then show you a list of the 9 VAT boxes. Next to Box 1, you’ll select your sheet name and the cell reference (e.g., Sheet1!B20). The software "memorizes" this location for next time.

If you’re using an Excel Add-in:

You’ll see a new tab in your Excel ribbon labeled "MTD" or the software’s name. You simply click on Box 1 in the software panel, then click on the corresponding cell in your spreadsheet.

A close-up photo representing a digital link connecting a spreadsheet to a government portal with the Accountant Search logo.

Step 4: The 5-Minute Submission Workflow

Once your spreadsheet is prepped and your cells are mapped, the actual submission process is incredibly fast. Here is the workflow I recommend to our SME clients:

  1. Open your Workbook: Ensure all your transactions for the quarter are entered and your summary formulas are correct.

  2. Run the Software: Open the bridging tool.

  3. Fetch Obligations: The software will talk to HMRC and say, "What does this business owe?" It will then display your current open tax period (e.g., April 1st to June 30th).

  4. Review the Figures: The software will pull the numbers from your mapped Excel cells. Take 30 seconds to double-check these against your spreadsheet one last time.

  5. Click Submit: You’ll usually have to tick a declaration box stating the info is correct. Click the big "Submit to HMRC" button.

Within seconds, you should receive a digital receipt and a correlation ID. Save a screenshot of this or download the PDF receipt for your records. Done!

Common Pitfalls to Avoid

While bridging software is a lifesaver, there are a few ways to trip up:

  • Manual Copy-Pasting: Never copy and paste a total from your bookkeeping sheet into your summary sheet. Use a formula. HMRC considers copy-pasting a break in the "digital link."

  • Moving Cells: If you add rows or columns and your summary totals move from cell B20 to B25, you must update your mapping in the bridging software, or it will pull the wrong data (or an empty cell).

  • Multiple Files: Try to keep your full year in one workbook. Using multiple files can make maintaining digital links much more complicated.

When Should You Get Professional Help?

Bridging software is fantastic for simple, straightforward businesses. However, if you have complex VAT schemes (like the Margin Scheme or Partial Exemption), or if you’re worried about the upcoming transition to MTD for Income Tax, it might be time to bring in a pro.

Integrating technology is great, but having an expert look over your spreadsheet structure can save you from a nasty HMRC inquiry down the line. If you're looking for someone who specializes in MTD and cloud transitions, we can help you compare accountant services and find a local or online firm that fits your budget.

A professional business meeting between a small business owner and an accountant in a modern office with the Accountant Search logo.

Final Thoughts

MTD doesn't have to be a headache. By spending just five minutes setting up a bridging link, you can keep the Excel workflow you love while satisfying the taxman's digital cravings. It’s efficient, cost-effective, and: once set up: takes almost no time at all each quarter.

If you need a hand getting your tax preparation in order, take a look at our tax preparation services or reach out to us to get matched with an MTD-expert accountant today.

 
 
 

Comments

bottom of page