Stay-level inputs
Booking source, cutoff evidence, dates, accommodation revenue, extras, cap revenue and adjustments.
Menu
Free visitor levy template
Keep the stay-level records behind your visitor levy return.
Download a simple CSV for imports or a formula-driven XLSX workbook with an Edinburgh first-return summary. Both are designed around the evidence operators need to reconcile before using visitorlevy.scot.
Template rules and official source links last verified 29 August 2026.
Formula-driven checks
Levy basis, levy due, VAT-on-levy, provider retention and amount due to the council.
Edinburgh first return
Monthly working totals for accommodation revenue, protected bookings, cap revenue, levy and council amount.
What to keep
A defensible record for each stay.
✓ Property, council area, booking channel and reservation reference.
✓ Original booking date and qualifying payment timing.
✓ Check-in and check-out dates, including amendments.
✓ Accommodation-only revenue and optional extras excluded.
✓ Revenue protected by a booking cutoff and revenue beyond any night cap.
✓ Levy rate, levy due, VAT-on-levy and provider retention.
✓ Net amount due to the council.
✓ Cancellation, no-show, refund, adjustment and evidence references.
Template FAQs
What should a visitor levy record include?
Keep the property, council, booking reference and source, booking and payment timing, stay dates, accommodation-only charge, excluded extras, levy basis, rate, levy, VAT treatment, retention, council amount and adjustment evidence.
Can this template be uploaded to visitorlevy.scot?
It is a working and reconciliation template, not an official upload format. Use it to prepare and support the figures you submit through the official service.
Does the workbook calculate visitor levy?
Yes. The XLSX includes formula columns for nights, levy basis, levy, VAT-on-levy, provider retention and council amount. You remain responsible for confirming inputs and council rules.
This free template is operational guidance, not tax or legal advice. Confirm figures against current council guidance. If you want saved calculations and ongoing return workflows instead of a file, see LevyTrack visitor levy software.