How many bookings can this caravan park Excel spreadsheet hold?

The Bookings sheet has prepared operational rows 2 to 101, giving you 100 rows for bookings. It is not an unlimited booking system, so larger parks should monitor the number of rows and move to dedicated reservation software when the register becomes difficult to control.

Does the spreadsheet calculate GST for caravan park bookings?

Yes. It calculates GST at 10% on Total ex GST and adds it to Total inc GST. The sample rates and formulas use ex-GST amounts, but you must confirm the GST treatment of your park's supplies before using the figures for BAS reporting.

What site types and rates are included?

Lists & Instructions includes Powered Site at $45.00, Unpowered Site at $32.00, Ensuite Site at $58.00 and Cabin at $135.00, all ex GST. These are sample rates that you can update in the list before entering live bookings.

Can I track deposits and unpaid caravan park bookings?

Yes. Enter the amount received in Deposit Paid. The spreadsheet subtracts it from Total inc GST to calculate Balance Due and labels Payment Status as Paid, Part-paid or Unpaid.

Does the template prevent double-booking a caravan site?

No. It records Site Number and dates but does not contain an automated overlap check or live availability calendar. Check confirmed bookings with the park's site map before accepting overlapping dates.

What does the Dashboard show?

The Dashboard shows total bookings, confirmed bookings, total booked nights, average stay, total revenue including GST, outstanding balance and paid booking percentage. It also summarises booking count, nights and revenue for each of the four site types and includes three charts.

Sales & Customers

Caravan Park Booking Excel - Free Template

Manage caravan park bookings, site types, GST, deposits and balances with an Excel spreadsheet for Australian park operators.

2026-09-26

504 Downloads

4.8/5 Average rating

Download template

Screenshot 1: Bookings tab - Excel template caravan park site booking excel spreadsheet australia

This caravan park booking Excel spreadsheet records guest details, arrival and departure dates, site numbers, site types, nightly rates, extras, deposits and booking status. It calculates nights, GST, totals and balances, then summarises booking activity and site-type revenue on a dashboard.

The Bookings sheet provides 100 prepared operational rows, with pale-yellow input cells and calculated columns. Image 1 shows the full booking register from Booking ID through to Notes, while image 2 shows the Dashboard with booking totals, revenue, outstanding balances, site-type summaries and three charts.

The Lists & Instructions sheet, shown in image 3, contains four site types, sample rates, booking and payment statuses, plus instructions for entering dates, deposits and Australian financial-year information.

The key benefits of this Excel template

Record up to 100 bookings in prepared rows, with fields for guest contact details, home city, dates, site number and guest count.
Calculate nights automatically from arrival and departure dates, such as 5 nights for a booking from 12/01/2026 to 17/01/2026.
Apply the selected site type's nightly rate using VLOOKUP, with sample rates from $32.00 for an unpowered site to $135.00 for a cabin.
Separate accommodation and extras ex GST before calculating GST at 10% and the total including GST.
Track deposits, balance due and payment status so paid, part-paid and unpaid bookings are visible.
Review total bookings, confirmed bookings, booked nights, average stay, revenue and outstanding balances in one dashboard.
Compare powered sites, unpowered sites, ensuite sites and cabins by booking count, nights and revenue.

Step-by-step guide

Open the Lists & Instructions sheet and review the four site types, nightly rates, booking statuses and payment statuses. Replace the sample rates with your park's rates before entering new bookings.
Go to the Bookings sheet and enter a unique Booking ID, guest name, contact number, email address and home city in the input cells.
Enter arrival and departure dates in DD/MM/YYYY format, then add the site number, site type and number of guests. The date validation accepts whole guest numbers from 1 to 20.
Enter any extras ex GST and the deposit received. Leave calculated columns alone; Nights, Nightly Rate ex GST, Accommodation ex GST, totals, GST, balance and Payment Status update automatically.
Choose the booking status from the list, such as Confirmed, Tentative, Cancelled or Completed, and add operational details in Notes.
Review the Dashboard for booking volume, confirmed bookings, total nights, average stay, revenue including GST and outstanding balances.
Before BAS or end-of-financial-year work, reconcile deposits and booking records against your bank and accounting records. Keep a copy of the workbook after each reporting period.

Screenshot 2: Dashboard tab - Excel template caravan park site booking excel spreadsheet australia — Figure 2: Worksheet "Dashboard"

What is included

Bookings sheet with columns for Booking ID, Guest Name, Contact Number, Email, Home City, Arrival Date, Departure Date, Nights, Site Number, Site Type, Guests, rates, totals, deposits, statuses and Notes.

Automatic nights calculation using date subtraction, with blank results when the booking ID or either date is missing.

VLOOKUP rate lookup from Lists & Instructions for Powered Site, Unpowered Site, Ensuite Site and Cabin.

Automatic calculations for accommodation, extras, total ex GST, GST (10%), total inc GST and Balance Due.

Booking Status and Site Type drop-down lists, plus date, guest-number and non-negative amount validation.

Dashboard formulas using COUNTA, COUNTIF, SUM, AVERAGE and SUMIF to summarise the booking register.

Three Dashboard charts covering site-type revenue, booking numbers by site type and balances due by guest.

Who uses a caravan park booking spreadsheet in Australia

A small caravan park often has bookings coming from phone calls, email, online enquiries and repeat guests at the same time. This spreadsheet gives the office manager or park owner one register for the reservation details, rather than relying on a diary for dates and a separate notebook for deposits.

Busy holiday periods and ordinary weeks

A regional park may use it heavily before school holidays, long weekends and the summer rush, then keep it updated daily during quieter periods. A manager handling 300 online and phone bookings a month can filter the Bookings sheet by arrival date, site type or status while still keeping guest contact details beside the reservation.

The prepared rows run from row 2 to row 101. The workbook includes sample bookings, but those examples are not extra capacity: you should replace or clear them before using the file for live records. Image 1 shows the input and calculated columns across the booking register.

A practical booking example

Suppose a guest books a Powered Site from 12/01/2026 to 17/01/2026. The sheet calculates 5 nights at the sample $45.00 ex GST rate, giving $225.00 accommodation. Add $20.00 of extras and the ex-GST total is $245.00; GST is $24.50, the total including GST is $269.50, and a $100.00 deposit leaves $169.50 due.

A volunteer treasurer at a camping club could also use the same structure for a short event, while a park bookkeeper can copy the completed totals into the accounting system. It is best used as an operational register and checking tool, not as a replacement for a proper reservation platform when availability must be controlled in real time.

Screenshot 3: Lists & Instructions tab - Excel template caravan park site booking excel spreadsheet australia — Figure 3: Worksheet "Lists & Instructions"

GST and record-keeping rules for Australian caravan parks

For a GST-registered Australian business, the workbook applies the standard GST rate of 10% to the total ex GST. GST registration is generally required once annual turnover reaches $75,000, or $150,000 for a not-for-profit organisation. The workbook's Lists & Instructions sheet states that rates are exclusive of GST and that the GST treatment must be checked against the park's reporting arrangements.

How the calculation works

The Bookings sheet adds Accommodation ex GST and Extras ex GST in Total ex GST, calculates GST (10%), then adds it to Total inc GST. For example, $500.00 accommodation plus $50.00 extras produces $550.00 ex GST, $55.00 GST and $605.00 including GST. A $200.00 deposit then leaves a calculated balance of $405.00.

Do not assume every charge has the same treatment without checking the underlying supply. A standard powered or unpowered site supplied by a GST-registered park is commonly taxable, while particular goods or services may be GST-free under Australian GST rules. The spreadsheet applies 10% to the booking total, so unusual packages or non-taxable components need to be reviewed before the figure is used in a BAS.

BAS timing and supporting records

Most small businesses lodge BAS quarterly; businesses with GST turnover above $20 million generally lodge monthly. The ATO expects records that support sales, GST collected, deposits and adjustments, and business records generally need to be retained for 5 years.

Use the workbook alongside tax invoices, bank statements and your accounting records. A tax invoice should include the supplier's identity and ABN, the words Tax Invoice, the invoice date, a description and GST shown separately where required, including invoices over $82.50. This file calculates booking figures but does not generate tax invoices or lodge BAS.

After checking the booking totals and supporting records, a BAS statement workbook can help organise GST sales and purchases into a quarterly summary before lodging.

The booking errors that create costly caravan park problems

The most expensive booking mistakes are usually small entry errors that multiply across a busy season. A departure date entered one day early turns a 7-night stay into 6 nights, while an incorrect site type can apply a $32.00 unpowered rate instead of the sample $135.00 cabin rate. The difference on a 4-night booking is $412.00 before GST.

Wrong dates and double allocation

This workbook calculates nights from departure date minus arrival date, but it does not check whether two guests have been allocated the same physical site. If P12 is entered for two overlapping confirmed bookings, the register will still calculate both invoices. Compare the Site Number and date columns before confirming a reservation, particularly when a staff member takes a phone booking during check-in.

A common workaround is to mark one booking Tentative until the site map has been checked. That is safer than treating every row as confirmed, because the Dashboard's confirmed booking count is driven by the Booking Status values in column T, not by whether a guest has paid.

Deposits, extras and GST omissions

Leaving a $300.00 deposit out of Deposit Paid makes the reported outstanding balance $300.00 too high. Entering an extra as $110.00 including GST when the column expects ex GST makes the GST calculation wrong as well: the sheet will calculate $11.00 GST on top, producing $121.00 instead of treating $110.00 as the final tax-inclusive amount.

Do not type over formula columns such as Nights, Nightly Rate ex GST, GST, Balance Due or Payment Status. A damaged formula can affect 100 prepared rows and make the Dashboard look credible while reporting incomplete revenue. Check a sample calculation after changing rates, and reconcile totals to deposits received rather than relying only on the status label.

Turning the booking spreadsheet into a reliable park routine

A spreadsheet only helps when someone updates it at a predictable point in the booking cycle. For a small park, enter a new reservation immediately after taking the phone call, then spend 10 minutes at the end of each day checking the next 14 days of arrivals against the site map and deposit records.

Simple habits that keep entries clean

Use the same Booking ID format, such as BKG-2026-001, and never reuse an ID after cancellation.
Update Deposit Paid when money reaches the bank, not when a guest promises to pay.
Review Tentative and Unpaid bookings twice a week, then contact guests before holding scarce holiday sites.
Copy a backup file at month-end and retain the original workbook rather than repeatedly overwriting the only copy.

Image 3 contains the workbook instructions, including the warning not to overwrite formula columns. The five validations already built into Bookings help keep site type, booking status, dates, guest numbers and amount fields consistent. Keep the existing lists intact unless you also update the rate or status references used by the formulas.

When Excel has reached its limit

This file has 100 booking rows and no live availability engine, online booking connection, automated email, invoice generator or chart based on a selectable date range. If the park receives 300 bookings a month, has several staff entering reservations, or needs live inventory across multiple channels, move the operational process to a reservation system or accounting platform such as Xero or MYOB and retain Excel for analysis.

Until then, link the spreadsheet to your weekly occupancy check and month-end reconciliation. At the end of the Australian financial year, 30 June, save a dated copy and compare the Dashboard revenue and outstanding balance with the accounting records.

Frequently asked questions about this template

The Bookings sheet has prepared operational rows 2 to 101, giving you 100 rows for bookings. It is not an unlimited booking system, so larger parks should monitor the number of rows and move to dedicated reservation software when the register becomes difficult to control.
Yes. It calculates GST at 10% on Total ex GST and adds it to Total inc GST. The sample rates and formulas use ex-GST amounts, but you must confirm the GST treatment of your park's supplies before using the figures for BAS reporting.
Lists & Instructions includes Powered Site at $45.00, Unpowered Site at $32.00, Ensuite Site at $58.00 and Cabin at $135.00, all ex GST. These are sample rates that you can update in the list before entering live bookings.
Yes. Enter the amount received in Deposit Paid. The spreadsheet subtracts it from Total inc GST to calculate Balance Due and labels Payment Status as Paid, Part-paid or Unpaid.
No. It records Site Number and dates but does not contain an automated overlap check or live availability calendar. Check confirmed bookings with the park's site map before accepting overlapping dates.
The Dashboard shows total bookings, confirmed bookings, total booked nights, average stay, total revenue including GST, outstanding balance and paid booking percentage. It also summarises booking count, nights and revenue for each of the four site types and includes three charts.