Front office
What is a city ledger?
A city ledger is the hotel's record of money owed by parties who are not currently staying: companies with credit accounts, travel agents, OTAs and guests who left with an unpaid balance. It is the hotel's accounts receivable for stays that were billed rather than paid at check-out.
City ledger example: a company stay
A company with a credit account and 30-day payment terms books a room for its sales manager: three nights at ₹5,000, with the room billed to the company and personal extras paid by the guest. Here is how the money moves, with GST on the room at 5%.
| Step | What happens | Guest ledger | City ledger |
|---|---|---|---|
| 1. Check-in | The folio opens with the room charges routed to the company. The front desk checks the stay fits the company's credit limit. | Folio open, ₹0 | No change |
| 2. During the stay | Each night posts ₹5,000 plus ₹250 GST. The guest signs a ₹1,260 dinner bill, GST included, to the room. | ₹17,010 open by the last night | No change |
| 3. Check-out | The guest pays the ₹1,260 dinner bill by UPI. The ₹15,750 room balance is transferred to the company's account and a GST invoice with its GSTIN is sent. | ₹0, folio closed | Company owes ₹15,750 |
| 4. Day 30 | The invoice is unpaid on its due date, so it shows in the 30-day column of the ageing report and accounts follows up. | No change | ₹15,750, 30 days old |
| 5. Payment | The company pays by bank transfer and the payment is matched to the invoice. | No change | ₹0, account clear |
City ledger vs guest ledger
The guest ledger covers guests who are in-house: their folios are still open. When a guest checks out and the bill goes to a company or agent, the balance moves from the guest ledger to the city ledger, where it stays until it is paid.
| Guest ledger | City ledger | |
|---|---|---|
| Whose accounts | Guests staying in the hotel now | Companies, travel agents, OTAs and guests who checked out on credit |
| Opens | At check-in, when the folio opens | When a balance is transferred at check-out, or a credit account is set up |
| Clears | At check-out: paid, or transferred to the city ledger | When the invoice is paid |
| Lasts | The length of the stay | The credit terms agreed with the account |
| Checked by | The night audit, every day | An ageing report (30, 60 and 90 days) |
| Also called | Front office or transient ledger | Accounts receivable for the hotel |
Managing it
Each account should have a credit limit and payment terms, and balances should be aged (30, 60, 90 days) so overdue accounts are chased. The night audit should confirm that every transfer to the city ledger went to the right account.
In StaySynq
StaySynq keeps accounts receivable for companies, travel agents and OTAs, with open items and a city-ledger report.
Common questions
What is an example of a city ledger account?
A company that sends its staff to the hotel on credit. At check-out the room charges move off the guest's folio and onto the company's city ledger account, the hotel sends a GST invoice, and the balance stays there until the company pays it.
Why is it called a city ledger?
The name comes from accounts held by local ('city') businesses and residents rather than guests staying in the hotel.
Related terms
- Guest ledgerThe guest ledger is the set of accounts for guests who are currently staying in the hotel. It is the total of all open folios: the charges posted to in-house guests, less what they have paid so far. It is also called the front office ledger or transient ledger.
- FolioA folio is the running account of everything a guest is charged and everything they pay during a stay: room nights, restaurant bills, minibar, laundry, taxes, deposits and payments. At check-out the folio is settled and becomes the basis for the invoice.
- Night auditA night audit is the daily routine that closes one hotel business day and opens the next. It posts the night's room and tax charges to guest folios, reconciles the day's payments and cash, identifies no-shows and errors, and produces the daily reports for management.
- TCS on OTA bookingsTCS on OTA bookings is tax collected at source under Section 52 of India's GST law. When an online travel agency collects payment from the guest on the hotel's behalf, it deducts a small percentage of the booking value, pays it to the government and reports it against the hotel's GSTIN.
Try StaySynq on your own hotel for 45 days.
Run your hotel on StaySynq free for 45 days, with migration done for you and a parallel run in week one. Or book a 30-minute demo first and see your own workflow on screen.