LevyTrack vs Spreadsheets for Scottish Visitor Levy Tracking

Spreadsheets are not bad. A good spreadsheet is often the first sensible step when a host wants to understand visitor levy properly.

The question is not whether a spreadsheet can calculate 5% of a booking. It can. The question is whether it can keep up with booking cutoffs, night caps, exemptions, refunds, multiple council schemes, quarterly returns, and evidence months later.

That is where the comparison between LevyTrack and spreadsheets becomes useful.

When a spreadsheet is probably fine

A spreadsheet may be enough if:

• You have one property.
• You operate in one council area.
• You take a small number of bookings.
• You have simple pricing.
• You rarely amend bookings.
• You update the sheet immediately.
• You understand the local levy rule.
• You are comfortable checking formulas.

In that situation, the spreadsheet is not the problem. The problem is usually forgetting to update it.

What a good levy spreadsheet needs

At minimum, a Scottish visitor levy spreadsheet should track:

• Property.
• Council area.
• Booking reference.
• Booking source.
• Booking date.
• Payment or deposit date where relevant.
• Check-in and check-out dates.
• Accommodation-only charge.
• Extras excluded from levy.
• Levy rate.
• Night cap.
• Charge subject to levy.
• Levy amount.
• Provider retention.
• Amount due to the council.
• Exemption or refund notes.
• Reporting quarter.
• Return submission status.

If that feels like a lot, that is because visitor levy is not just a percentage. It is a small recordkeeping workflow.

Where spreadsheets start to wobble

Spreadsheets usually break quietly.

Common failure points include:

• A formula copied down with the wrong cell reference.
• A guest stay amended after the original calculation.
• A booking made before a cutoff but staying after the scheme start date.
• Extras mixed into the accommodation charge.
• A refund recorded in the platform but not in the levy sheet.
• Two councils using different rules.
• One property added without updating the return summary formulas.
• A sheet owner leaving the business or going on holiday.

None of these are dramatic on day one. They become dramatic when the quarterly return is due.

What LevyTrack does differently

LevyTrack is built around the Scottish short-term let and visitor levy workflow rather than a blank grid.

It helps with:

• Council-specific levy calculations.
• Booking cutoffs and scheme start dates.
• Night caps and full-stay models.
• Exemption handling.
• VAT effect estimates for levy calculations.
• Provider retention where scheme data includes it.
• Stay records grouped into quarterly return summaries.
• Document and licence expiry tracking.
• Multi-property compliance oversight.
• Alerts for upcoming deadlines.

It is not a booking engine, channel manager, accounting package, or replacement for visitorlevy.scot. Hosts still need to take bookings, charge guests, keep business accounts, and submit through official channels where required.

The biggest difference: context

A spreadsheet stores values. LevyTrack stores values with context.

For example, a spreadsheet cell might say:

• Levy: £25

That is useful, but thin.

A better record explains:

• Edinburgh stay.
• Booked after 1 October 2025.
• Stayed after 24 July 2026.
• £500 accommodation charge.
• Extras excluded.
• Five nights subject to levy.
• 5% rate.
• No exemption.
• Included in Q3 return.

That context is what makes a return easier to review.

Cost and control

Spreadsheets are cheap and flexible. They are also easy to duplicate, overwrite, and interpret differently.

LevyTrack costs money, but it gives you a more structured workflow. That matters most when the admin cost of checking the spreadsheet starts to outweigh the subscription cost.

If you have one quiet property, stay with the spreadsheet until the pain is real. If you have several properties, several booking channels, or several council rules, automation starts to look less like luxury and more like risk control.

FAQ

A fair rule of thumb

Use a spreadsheet while the spreadsheet is genuinely simple.

Switch to LevyTrack when you need council-aware calculations, saved evidence, return-ready summaries, reminders, and a clearer view across properties. That is usually the point where a spreadsheet stops feeling free.