Skip to main content

Advanced Payment and Deposit Tax Invoicing

Did You Know?

UK and EU VAT / Sales Tax rules mean that when you take a deposit or advanced payment for services, such as a stay in your property, that creates a tax point. This means you need to report the payment in the current VAT period and produce an invoice detailing the tax allocation. This can be quite complex, error prone and time consuming process.  Even more so if you have to deal with different Tax Rates for different invoice items. More information from HMRC https://www.gov.uk/guidance/vat-instalments-deposits-credit-sales

Example

You take a booking in April for 1 room, 2 guests with breakfast for 5 nights starting in November at £630 and right now you take 50% deposit of £315. A tax point has been created and you need to report the receipt of £315 on your current VAT return and issue an invoice to the guest. 

Lets assume this is the breakdown of the chargeable services:
  • room rate : £96 * 5 = £480 (gross, inc VAT)
  • breakfast : £15 * 10 = £150 (gross, inc VAT)
How do you allocate the 50% or £315 deposit? In the UK it's not so bad as VAT rate on room and breakfast is the same at 20% but for some European countries the rates for rooms and breakfast differ making it quite complex and an invoice may also include other items like tourist tax.

We'll take the approach of allocating to the largest item first, in this case the room rate. So a deposit invoice will need to include :
  • room rate : £96 * 5 = £480 (gross, inc VAT), VAT @ 20%  =  £96, 
    • Payment allocated to this invoice : 
      • gross £315
      • VAT £52.50
      • Net £262.50
  • breakfast : £15 * 10 = £150 (gross, inc VAT), VAT @ 20% = £25
    • No payment allocated on this invoice as we have allocated all the deposit to the room. If we hadn't allocated all the deposit to the room then the remainder would need to be allocated to the breakfast charge as well.
And keep in mind if you have non-VAT items or different tax rate items this all needs handling.

How Does Guestbook 247 Help?

With full support for deposit or advance payment invoices. This takes out the pain of working out the correct VAT & producing an invoice for the customer. Added to that you can save deposit invoices for future review and the final balancing invoice will calculate the correct VAT.

If you need more than one advance payment invoice that's supported as well. Combined with Guestbook's invoice base rate templates and payment recording you have a system that really takes away the hassle and time of producing correct invoices.

Try it out with a free 30 day trial guestbook247.com



Comments

Popular posts from this blog

QuickBooks, VAT, MTD and online accounting

Get Linked, Save Time. We're pleased to announce Guestbook247 can now be linked to QuickBooks Online for UK based customers, providing seamless way to integrate your booking invoices direct to your online accounting solution. We believe this will save businesses significant time, reduce mistakes and for UK customers help meet Making Tax Digital (MTD) VAT compliance and ease changing VAT rates during these COVID times.  MTD VAT - What Is That? For UK VAT registered businesses from April 2019 Making Tax Digital (MTD) for VAT went live. This obligates VAT registered businesses with a turnover over £85,000 to keep digital records and to submit VAT returns online using an HMRC approved software, such as QuickBooks Online. Up until now you have been able to manually move data from your other business software solutions, such as Guestbook247, into your accounting software. However from April 2021 so called "copy and paste" of VAT related transaction data will no longer t

New Dashboard And Modern Look.

Lots Has Been Happening. We've been very busy with lots of exciting new features and have created a more modern and cleaner look for guestbook 247. Not just a new look but a much enhanced dashboard from which to see at a glance key info, bookings, availability and business insights. We hope the new look will make using and navigating guestbook more pleasant, easier and productive. The Dashboard.  The dashboard is your new Guestbook 247 home from where you can see and do most of your daily task and get easy insights on your business. The availability calendar sporting a new fresh look and improved navigation Key business metrics such as number of bookings and enquiries, rooms occupied  The Timeline shows your booking info for the  the most relevant bookings recent activity new enquires who's in and out Instant guest search based on name or email Booking source charts - see at a glance where your bookings are coming from, compare different time periods to spo

Making Invoicing Even Easier

Base Rate Templates. With the recent release of Guestbook 247 Kaprun invoicing has just become even easier. We've worked to make it simple to split a booking base rate into one or more invoice lines. So for instance if a booking base rate includes a room rate and breakfast fee attracting different tax rates you can now define this once in a base rate template and apply it to selected bookings. Guestbook will generate an invoice containing separate lines for the room rate and breakfast. The template can define a mix of invoice items with fixed or percentage based amounts. Guestbook 247 will take care of allocating the base rate across the different invoice categories and tax rates. So taking our bed and breakfast example the template rules would look like: breakfast €15 inc 12% tax per night room rate 100% of unallocated base rate (after breakfast amount) inc 15% tax per night You can define multiple base rate templates to cover different requirements and set one to be