Small hospitality teams often receive enquiries through several channels at once. A simple shared log prevents details from being lost between shifts or between the front desk and the events coordinator. The same log later supports quotation preparation, payment tracking and the final handover to suppliers, so every stage rests on the same initial record.
Once an enquiry is logged, the next task is to prepare a quotation that lists every charge and condition clearly, then to keep payment records that match the quotation line by line. Supplier handovers follow the same records so that nothing is omitted on the day. The process works best when each step uses the same reference number and the same basic columns, reducing the chance that information is copied incorrectly or left out.
Creating a shared enquiry log
Start with a single spreadsheet or shared document that every team member can open. Columns should include date received, contact name, event type, expected numbers, preferred dates and the initial reply sent. Each new line receives a unique reference number that travels with the enquiry through every later stage. Update the log the same day an email or phone call arrives. Late entries create gaps that later cause double-booking or missed follow-ups. Colour-code lines that are still awaiting a reply so the team can see at a glance which enquiries need attention. A practical rule is to review the open lines at the start and end of each shift; any line without a next-action date is flagged for immediate follow-up.
Decide in advance what counts as a logged enquiry. Walk-in requests, website forms and phone calls that mention dates or guest numbers all qualify. Brief enquiries that only ask for opening hours do not. The boundary keeps the log focused and prevents it from becoming a general message pad. Common errors include entering the same enquiry twice under slightly different spellings or forgetting to note when a client changes the preferred date. Both mistakes lead to conflicting quotations later. The log should also record the channel used, because some clients expect replies by email while others prefer a quick call. Adding this single extra column saves time when the team prepares the first response.
Preparing quotations from logged details
Use the reference number on every quotation. List each service as a separate line with unit price, quantity and total. Add separate lines for deposits, cancellation terms and any surcharges that apply outside normal hours. Send the quotation as a PDF so the formatting cannot be altered after dispatch. Attach the quotation to the original enquiry line in the log. Note the date sent and the date by which a reply is requested. This creates a clear audit trail without extra software. When a client asks for changes, create a revised version rather than editing the original file; keep both versions linked to the same reference number.
Check the quotation against the logged details before sending. Numbers of guests, room requirements and timing must match exactly. A frequent mistake is quoting for a different date or omitting an agreed discount. Another is listing inclusive prices when the client expects to see VAT shown separately. The quotation should also state the payment schedule clearly, for example a 30 percent deposit due within seven days and the balance due fourteen days before the event. If the enquiry came through an agent, add the agent’s reference as well. These small checks reduce later queries and make the payment record easier to maintain once the booking is confirmed.
Recording payments against each quotation
Keep a separate payment sheet that mirrors the quotation lines. Enter every incoming amount on the date it arrives and mark the quotation line as paid. Retain the bank reference or receipt number in the same row so any later query can be answered in seconds. For staged payments, open a new row for each instalment rather than overwriting earlier figures. At month end, total the paid amounts and compare them with the quotation totals still showing as outstanding. Any difference points to an entry that needs correction before the next event. The sheet should also note the method of payment, because card fees or bank charges may need to be allocated to the correct cost centre.
Only mark a line fully paid when the final amount has cleared. Holding deposits that have not yet reached the account leads to incorrect availability reports. A common error is to record the full quoted sum on the day the deposit arrives, which then hides the remaining balance. Another is to forget to note when a client pays by bank transfer but the reference is missing, making reconciliation difficult at month end. The payment sheet should be reviewed weekly against bank statements; any unmatched credit is investigated immediately. This habit keeps the figures accurate and prevents last-minute surprises when preparing supplier payments.
Compiling the supplier handover file
Once the client confirms and the deposit clears, copy the quotation lines that involve external suppliers into a new handover document. Add delivery times, contact names and any special access instructions. Keep the original quotation reference at the top so the supplier sheet always links back to the client record. Print or share the handover file at least two days before the event. Include a short checklist at the bottom for the person receiving goods to initial each item on arrival. This reduces the chance that a missing item is noticed only after the supplier has left. The file should also list any equipment that the venue itself supplies, so the team can cross-check before the supplier arrives.
Decide in advance which suppliers appear on the handover sheet. Any supplier whose goods or services affect room setup, timing or guest safety must be included. Suppliers who only send invoices after the event can stay on the payment sheet alone. A frequent mistake is to omit last-minute additions such as extra chairs or a different menu, because the change was agreed verbally. Another is to list the wrong delivery entrance or to forget that some suppliers need a pass for the loading bay. The handover document should therefore be checked against the final client confirmation on the morning of the event. Any discrepancy is corrected before the first supplier is due.
Reviewing records after the event
Within one working day, add any last-minute changes to both the payment sheet and the handover file. Note any extra charges that arose on the day and whether they were collected or still need invoicing. Store the completed files together under the original enquiry reference. The review also records which suppliers arrived on time and whether any items were short or damaged. These notes stay with the file so the same supplier can be evaluated quickly the next time the team plans a similar event.
Monthly, scan the log for enquiries that never became events. A short note on why the booking did not proceed helps the team adjust future quotations or response times without repeating the same pattern. The review should also check that every confirmed event has a closed payment record and a completed handover sheet. Open items are listed and assigned to a team member for follow-up. This routine prevents small outstanding balances from remaining unnoticed for months and keeps the supplier records ready for the next booking cycle.
Keeping records consistent across team changes
Write a one-page procedure that explains where the log lives, how to name files and how to close a completed enquiry. New staff can follow the steps without asking colleagues for reminders. Store the procedure in the same folder as the active log so it is never misplaced. The procedure should also state how often backups are made and who is responsible for checking that the payment sheet matches the bank statements each week.
Back up the log and payment sheets at the end of each week. A simple export to a dated folder prevents loss if the main file is accidentally altered. The backup also serves as the archive when the annual accounts are prepared. When a team member leaves, the outgoing person should walk through the current open enquiries with their replacement using the log itself as the guide. This handover takes only a few minutes yet prevents the new person from having to reconstruct the history of each booking from scattered emails. Consistent records therefore reduce training time and lower the risk of errors during staff changes.
