TOMS VAT for Travel Businesses: Why Spreadsheets Don’t Work (and What to Do Instead)

Why Spreadsheets Don’t Work for TOMS VAT (A Real Case from a Travel Business)

When I work with travel businesses, especially tour operators under the Tour Operators’ Margin Scheme (TOMS), I often see the same pattern: TOMS VAT spreadsheets being used to manage what should be structured accounting records. At first glance, they look detailed: tabs, formulas, summaries, categories — sometimes hundreds of lines of data. But when it comes to VAT, and especially TOMS, those spreadsheets don’t provide clarity.

They create confusion.

In this article, I’ll walk you through a real scenario (anonymised) and explain why spreadsheets fail in a TOMS environment — and what actually works instead. HMRC sets out clear requirements for digital record-keeping and VAT compliance under Making Tax Digital.

The Starting Point: “We Already Have Everything in Spreadsheets”

A travel business approached me with what they believed was a complete financial picture. They had:

• spreadsheets tracking income and costs per trip
• breakdowns across months
• internal summaries of profitability

From their perspective, everything was already organised. But when I reviewed the data, a few issues became immediately clear:

• large amounts grouped under vague categories like “Other”
• no consistent link between transactions and actual trips
• no clear separation between TOMS and non-TOMS items
• no audit trail from bank transaction → accounting treatment

One category alone contained close to £200,000 labelled simply as “Other”.

That is not accounting. That is aggregation without meaning.

The Turning Point: Profit vs Loss

Based on their spreadsheets, the business initially believed they were making a profit of around £250,000. After proper review and reconstruction of the data, the position changed significantly. The actual result was a loss of approximately £60,000.

This wasn’t a minor adjustment. It was a complete reversal of the financial picture.

The Hidden Risk: Missing the VAT Threshold

There was a second, more serious issue. Because the data was spread across multiple spreadsheets and not tied properly to accounting records, the business did not have a clear, reliable view of its turnover. As a result, they failed to identify that they had exceeded the VAT registration threshold. By the time this was addressed, the VAT registration had to be backdated by approximately three years.

This created:

• over three years of retrospective VAT exposure
• VAT payable in excess of £100,000
• additional penalties of over £10,000

This is where spreadsheet-based systems become genuinely dangerous. The issue is not just incorrect reporting.

It is late detection of obligations, which leads directly to financial consequences.

Why This Happens

Spreadsheets fail in this context for a simple reason: they are not designed to produce defensible, compliant financial records. They are designed for internal tracking. That distinction matters. 

1. No audit trail

In a proper accounting system:

• every number links back to a transaction
• every transaction has context
• every decision can be explained

In spreadsheets:

• numbers are often aggregated
• formulas overwrite visibility
• the source of figures becomes unclear

That is why when HMRC asks: “What is this number and how was it calculated?” You must be able to answer that directly. You must be able to answer that directly and clearly. If you cannot:

• the figures may be challenged
• adjustments may be imposed
• penalties and interest may follow

This is not theoretical. VAT positions must be defensible, not just internally understandable. Spreadsheets often can’t support that. This is why relying on TOMS VAT spreadsheets leads to VAT positions that cannot be explained, supported, or defended when challenged.

This is why businesses working with specialist accountants for travel businesses avoid these issues — because the structure is built correctly from the outset, not reconstructed later.

2. TOMS requires structure, not estimation

Under TOMS:

• VAT is calculated on the margin, not turnover
• costs must be correctly identified as direct trip costs
• timing (departure dates) matters

This cannot be reconstructed reliably from loosely structured data. If the underlying records are unclear, the margin calculation becomes unreliable.

3. “Other” is not a category

One of the biggest red flags I see is large amounts grouped under:

• “Other”
• “Misc”
• “General expenses”

These labels hide the actual nature of transactions. For VAT purposes, that’s a problem, because VAT treatment depends on:

• what the expense is
• where the supplier is based
• whether VAT was charged

Without that detail, the correct treatment cannot be determined.

The Xero Approach (and Why It Works)

Instead of relying on spreadsheets, I set up a structured system in Xero. This is not about making things complicated. It’s about making them usable for compliance. The system is simple: 

For TOMS transactions

• record the transaction
• assign the date of departure

That’s it. No interpretation required from the business owner.

For non-TOMS transactions

Add a short note:

• what the expense is
• whether it’s UK or non-UK
• whether there is a VAT invoice

This provides exactly the information needed to determine VAT treatment.

One system, one source of truth

All data sits inside Xero. Not:

• partially in spreadsheets
• partially in emails
• partially in someone’s head

This ensures:

• consistency
• traceability
• compliance

Why Travel Business Owners Sometimes Resist This

This is the part that often gets misunderstood. The resistance is not about the system being wrong. It’s about control and familiarity. Spreadsheets feel:

• familiar
• flexible
• understandable

Accounting systems feel:

• structured
• less intuitive
• harder to “sense-check”

So travel business owners try to recreate their own version of the numbers outside the system.

That creates two parallel systems:

1. the accounting system
2. the “comfort system”

And they don’t match. This becomes a problem because:

• decisions are made using one version of the numbers
• VAT is calculated using another
• discrepancies go unnoticed until it is too late

In practice, this leads to:

• incorrect VAT returns
• unexpected liabilities
• loss of confidence in the figures

A business can only operate reliably when there is one version of the truth.

The Risk of Parallel Systems

Running both: accounting software AND spreadsheets…does not give you better insight. In many cases, one system is based on accounting records, while the other relies on TOMS VAT spreadsheets, and the two rarely align. This results in:

• conflicting numbers
• duplicated effort
• increased risk

And ultimately:

• decisions based on the wrong data

The Role Split (and Why It Matters)

A key point that often needs clarifying: travel business owners are not expected to calculate VAT. The reason is simple. VAT treatment under TOMS depends on:

• technical rules
• correct classification of costs
• timing and structure of transactions

These are not intuitive and cannot be reliably determined without specialist knowledge.

The travel business owner’s role is to provide accurate, structured information. The accountant’s role is to interpret that information and apply the correct VAT treatment.

When business owners try to take on both roles, the system breaks down. Not because control is a problem, but because:

• assumptions replace technical treatment
• incomplete data leads to incorrect conclusions
• decisions are made without full visibility of the rules

This creates a situation where:

• the accounting system says one thing
• the internal view says another

And neither can be relied upon with confidence. This is where structured support from accountants for travel agents becomes critical to ensure VAT treatment and reporting remain consistent.

What HMRC Actually Requires

Under Making Tax Digital (MTD):

• records must be kept digitally
• transactions must be traceable
• VAT calculations must be supported

This does not align with:

• disconnected spreadsheets
• reconstructed summaries
• estimated figures

If records are challenged by HMRC, they must be:

• clear
• consistent
• defensible

What to Do Instead

If you are a travel business working under TOMS:

1. Use a proper accounting system (e.g. Xero)
2. Record transactions consistently
3. Provide minimal but precise context
4. Avoid creating parallel spreadsheet systems
5. Let your accountant handle VAT treatment

You do not need to:

• calculate margins yourself
• second-guess VAT
• rebuild the numbers externally

Final Thought

Spreadsheets are not the problem. Using them as a substitute for proper accounting records is. If your numbers don’t reconcile, if your reports don’t make sense or if your VAT position feels unclear — the issue is usually not complexity.

It is usually that the underlying records are not structured in a way that supports accurate reporting.

Once the structure is correct, the numbers begin to make sense. TOMS VAT spreadsheets may feel familiar, but they are not a substitute for structured accounting records that support compliance.

This is not about better spreadsheets. It is about using a system that produces VAT outcomes that can be relied on.