NightsBridge PC-Bridge (V6)

How VAT is calculated on the NightsBridge invoice template

Managing your property's billing and tax documentation shouldn't feel like a maths headache. When issuing invoices to your guests, transparency and accuracy build confidence—both for your guest and for your tax records.

In NightsBridge, your invoice templates automatically assume that all quoted rates are inclusive of Value-Added Tax (VAT), following standard South African business accounting practices.

Here is a simple, clear guide to how VAT is calculated on both PDF and Excel invoice templates, and how to verify the figures shown on your accounts.

This calculation is an explanation of how we get the VAT amount on PDF and Excel invoice templates, not a formula that needs to be entered on the Excel template.

VAT-inclusive pricing explained

When you enter room rates or extra charges in NightsBridge, the system treats those amounts as VAT-inclusive:

  1. Standard practice: This matches the pricing approach used across South African hospitality and retail, where the rate your guest sees is the full price they pay.
  2. Built-in calculation: When NightsBridge generates a PDF or Excel invoice, it automatically breaks down the total into the net room rate (excluding VAT) and the 15% VAT portion.

How the calculation works (with an example)

Understanding how the system works out the VAT breakdown from a total amount is straightforward.Let’s look at an example booking with a total rate of R1 000 (inclusive of 15% VAT):

  1. Calculate the rate excluding VAT:

To find the base rate before tax, divide the total by 1.15:

R1 000 ÷ 1.15 = R869.57

2. Calculate the VAT amount (15%):

To determine the 15% tax portion, multiply the total by 15/115 (or calculate 15% of the net rate):

R1 000 × (15 / 115) = R130.43(or R869.57 × 0.15 = R130.43)

3. Verify the total:

R869.57 (Net Rate) + R130.43 (VAT) = R1 000.00 (Total Amount)

Previous Article How to update the VAT formula on your invoice template for 01 May 2025 (PCBridge)
Still Need Help? Contact Us