Skip to content
Practical templates for small businesses · Paid templates coming soon
≋StackLedger
Hospitality · Spreadsheet template

Function & deposit tracker

Keep function dates, guest numbers, deposits and outstanding balances together.

Built for everyday use

What’s inside

  • Booking dates, start times, contacts and guest numbers
  • Enquiry, confirmed, completed and cancelled statuses
  • Deposit due dates and overdue deposit flags
  • Calculated outstanding deposits and balances
  • A user guide and colour-coded input cells
200 bookingsCapacity
2 worksheetsIncluded
XLSXFile format

Before you choose

Deposit due dates are entered manually. Cancelled bookings are excluded from summary totals. The workbook does not collect payments or send reminders.

Designed as an editable XLSX workbook with clearly shaded input and formula cells. Formula checks have been completed in the generating engine; desktop Excel testing remains recommended. Google Sheets and mobile compatibility are not guaranteed.

Use within one business. Do not resell or redistribute the template.

Workbook preview

Sample data. Scroll horizontally to see every column.

Enlarged workbook preview with sample data