HOS-HOTE29-02 · Lesson 6 · 13 clock hours · lab
Front Desk Math: Rates, Postings, and Folios
Objective. Students will manually calculate room charges, taxes, adjustments, and running folio balances with no more than one arithmetic error across a ten-transaction set.
⚠ Pending professional review
This lesson, its worked examples and its practice questions has not yet been verified by a certified food-safety manager and industry professional or by a certification or approval body. It is a study draft and may contain errors. Do not use it as instructions for work on a job site or on live equipment. Always follow your instructor, your supervising professional, and current official references and regulations.
VoTechWorks program approval and accreditation are still in progress. Credentials are issued only by the certifying bodies named in each program, after their own exams.
Why Front Desk Math Matters
Every dollar a guest pays—or disputes—passes through the guest folio. A folio is the running record of every charge, payment, and adjustment attached to a single guest stay or group account. Errors on folios delay checkouts, trigger chargebacks, and damage guest trust. Supervisors and front desk representatives are expected to catch arithmetic mistakes before a bill reaches the guest, so manual calculation skill is not optional—it is a baseline competency tested by AHLEI credentials and by employers during hiring.
The Guest Folio
A folio begins the moment a reservation is created or a guest checks in and a room account is opened. Every transaction is posted—entered into the folio in chronological order. The folio carries a running balance, meaning each new posting is added to or subtracted from the previous total. At checkout, the balance should reach zero after final payment is applied.
Folios commonly contain:
- Room charges – the nightly rate for each day of occupancy, posted once per night (usually by an automatic night-audit routine)
- Tax charges – occupancy or lodging tax posted alongside the room rate; the tax amount depends on the applicable rate for that jurisdiction
- Outlet transfers – charges from the restaurant, spa, gift shop, or other hotel outlets that are moved to the room folio when a guest signs for them
- Miscellaneous fees – parking, late-checkout fees, pet fees, resort fees
- Adjustments – corrections to a previous posting, usually shown as a negative (credit) entry
- Payments – cash, credit card, or direct-bill payments that reduce the balance
Debits and Credits on a Folio
In hotel accounting, charges that increase what the guest owes are debits; items that decrease what the guest owes are credits. A discount or rate adjustment appears as a credit. A payment appears as a credit. A room charge or outlet transfer appears as a debit. Keeping this distinction clear prevents the most common folio errors.
Calculating Room Charges and Tax
The room charge for each night is the contracted or rack rate. Tax is calculated as a percentage of that rate:
Tax amount = Room rate × Tax rate
Total nightly posting = Room rate + Tax amount
Tax rates vary by state, county, and city; always use the current reference card for your property's jurisdiction. Never guess or round a tax rate—even a fraction of a percentage point compounded over hundreds of folios creates a significant accounting discrepancy.
Adjustments and Discounts
When a charge must be corrected, a supervisor posts an adjustment. An adjustment entry shows the corrected amount as a negative figure on the folio so the running balance decreases by exactly the amount of the error. Then the correct charge is reposted. Common reasons for adjustments include:
- Rate override (loyalty discount, corporate rate applied after the fact)
- Outlet charge posted to the wrong room
- Duplicate posting of the same charge
- Manager's comp or goodwill credit
Adjustments above a set dollar threshold typically require a supervisor authorization code. This internal control limits exposure to fraud.
The Running Balance
After each posting, recalculate:
New balance = Previous balance + Debit postings − Credit postings
Work through every line in order. The most common student error is adding a credit instead of subtracting it, or vice versa. Label each line D (debit) or C (credit) before you calculate—this single habit eliminates the majority of folio arithmetic errors.
Night Audit and Folio Integrity
During the night audit, the property management system (PMS) rolls the date, posts all room charges and taxes, and produces trial balance reports. Front desk staff reconcile those system-generated totals against source documents (outlet reports, shift transaction logs). Any discrepancy must be traced to a specific posting and corrected with a documented adjustment—never by altering an original entry. Altering source records without documentation is a serious compliance violation and can constitute fraud.
Accuracy and Data Safety
Folios contain personally identifiable information (PII): guest names, credit card last-four digits, and stay dates. Printed folio worksheets and practice documents used in training must be shredded after use—do not leave them in open waste bins. In a live property environment, access to folio data is controlled by PMS login credentials; never share your login or view another employee's access-level screens without authorization.
Using Spreadsheets to Verify Manual Work
A spreadsheet does not replace the ability to calculate by hand, but it is a powerful verification tool. Build your folio template so that each row represents one posting and a formula column maintains the running balance automatically. When your manual totals and spreadsheet totals disagree, trace every line until you find the source of the variance—do not simply accept the spreadsheet figure. Computers reflect the data you enter; garbage in, garbage out.
Accuracy Standard
The AHLEI Front Desk Representative and Hospitality Supervisor competencies both include basic accounting accuracy. The standard used in this program—no more than one arithmetic error across a ten-transaction set—mirrors the professional expectation that front desk staff post with near-perfect precision before submitting a folio to a guest.
Key terms9
FolioA chronological record of all charges, credits, and payments associated with a guest account during a stay; also called a guest account or guest bill.
PostingThe act of entering a transaction—charge, payment, or adjustment—onto a guest folio.
Running balanceThe current amount owed by the guest after each successive posting is applied; updated after every debit or credit entry.
DebitA folio entry that increases the amount the guest owes, such as a room charge, tax, or outlet transfer.
CreditA folio entry that decreases the amount the guest owes, such as a payment, discount, or adjustment.
AdjustmentA correcting entry posted to a folio to reverse or reduce a previous charge that was posted in error or requires modification.
Outlet transferA charge originating in a hotel food, beverage, or service outlet that is moved to the guest's room folio at the guest's request.
Night auditThe daily process of reconciling all hotel transactions, posting room charges and taxes, and closing the accounting day; traditionally performed overnight.
Occupancy taxA government-imposed tax calculated as a percentage of the room rate, collected by the hotel on behalf of the taxing authority and remitted periodically.
Worked examples4
1. A guest's room rate is $120.00 per night. The local occupancy tax rate is 8%. Calculate the total nightly posting (room charge plus tax) and enter it on a folio that currently has a zero balance. What is the new running balance?
- Step 1 – Calculate tax: $120.00 × 0.08 = $9.60
- Step 2 – Calculate total nightly posting: $120.00 + $9.60 = $129.60
- Step 3 – Post room charge debit: Previous balance $0.00 + $120.00 = $120.00
- Step 4 – Post tax debit: $120.00 + $9.60 = $129.60
- Step 5 – New running balance = $129.60
Answer: New running balance: $129.60
2. A guest folio shows a running balance of $387.40 after two nights. A restaurant transfer of $54.75 is posted, followed by a late-checkout fee of $30.00. The guest then pays $200.00 by credit card. What is the running balance after all three transactions?
- Step 1 – Start with current balance: $387.40
- Step 2 – Post restaurant transfer (debit): $387.40 + $54.75 = $442.15
- Step 3 – Post late-checkout fee (debit): $442.15 + $30.00 = $472.15
- Step 4 – Post credit card payment (credit): $472.15 − $200.00 = $272.15
- Step 5 – New running balance = $272.15
Answer: New running balance: $272.15
3. A front desk agent accidentally posted a $95.00 spa charge to Room 214 instead of Room 241. The folio for Room 214 currently shows a balance of $310.50. Post the correcting adjustment and repost the charge to the correct room (Room 241, which has a balance of $188.00). Show the resulting balances for both rooms.
- Step 1 – Post adjustment (credit) to Room 214: $310.50 − $95.00 = $215.50
- Step 2 – Room 214 corrected balance = $215.50
- Step 3 – Post spa charge (debit) to Room 241: $188.00 + $95.00 = $283.00
- Step 4 – Room 241 corrected balance = $283.00
Answer: Room 214 balance: $215.50; Room 241 balance: $283.00
4. A corporate guest receives a 15% discount on a $160.00 room rate. The property collects 10% occupancy tax on the discounted rate only. Calculate: (a) the discounted room rate, (b) the tax on the discounted rate, and (c) the total nightly posting.
- Step 1 – Calculate discount amount: $160.00 × 0.15 = $24.00
- Step 2 – Calculate discounted room rate: $160.00 − $24.00 = $136.00
- Step 3 – Calculate tax on discounted rate: $136.00 × 0.10 = $13.60
- Step 4 – Calculate total nightly posting: $136.00 + $13.60 = $149.60
Answer: (a) Discounted rate: $136.00 | (b) Tax: $13.60 | (c) Total nightly posting: $149.60
The math in this lesson1
Learners apply 8% tax to a $120 room rate and post a $129.60 running folio balance.
7.RP.3
In class: Work through a 15-step folio worksheet that includes room charges, restaurant transfers, late-checkout fees, and a discount adjustment; check answers against a key. · Given three guest folios with deliberate errors, identify and correct each posting error, writing a brief explanation of what caused the discrepancy. · Use a spreadsheet template to recreate the same folio math, then compare manual totals to spreadsheet totals and reconcile any differences.
Materials: Folio math worksheets, calculator, tax-rate reference card, Microsoft Excel or Google Sheets, printer for folio printouts
Check: Ten-transaction folio assessment graded by instructor; pass requires no more than one arithmetic error and correct identification of all posting types.
Practice check8
Answer each question, then check it. Nothing is recorded; this is your own practice.
Record this lesson on my transcript. Sign in with your key and enrollment email to record lessons (enroll free if you have no key). This page stays open to read and practise.