Night Audit Posting Agent
Codes the night audit's revenue, tax and payment totals and other transactions to the hotel ledger.
- Industry
- Hotel
- Department
- Finance
- Team
- Accounting Operations
- Kind
- Assistant
- Approver
- Financial Controller
- Code
- FIN-01
It takes the night audit's daily revenue report from the PMS and point-of-sale system, plus bank and card transactions, and codes each line to the USALI departmental chart of accounts (rooms, F&B outlets, spa, other operated departments), the tax code and the guest, city or advance deposit ledger, then posts them to the general ledger as journal entries or drafts. Anything it cannot code from a standing mapping goes to suspense with a question for the night auditor or the accounting team.
How it works
6 steps, and a person signs off before step 6.
- 01Looks it up
Finds the record the request is about in the property management system (PMS): the night audit revenue, tax, payment and ledger balance reports for the property and business date, and the transaction-code mapping..
- 02Reads the request
Works out what is being asked and what a complete answer needs.
- 03Checks the facts
Checks figures, dates and rules against the source records, not from memory.
- 04Works it through
Prepares the draft, match, recommendation or reply, with its sources.
- 05Asks a person
Hands the work to Financial Controller with its reasoning before anything goes out.
- 06Acts
Once approved, it acts in the accounting system's general ledger: it posts the coded entries as journals or drafts and parks uncoded lines in suspense. and records what was done.
What it works with
Your knowledge, your systems, your people.
Knows
The hotel accounting manual: the USALI chart of accounts, the PMS transaction-code and POS-outlet mappings, the tourism, sales and occupancy tax codes, the service charge and tips accounts, the guest, city and deposit ledger rules, and the capitalisation policy for FF&E.
Reads from
the property management system (PMS): the night audit revenue, tax, payment and ledger balance reports for the property and business date, and the transaction-code mapping.
Acts in
the accounting system's general ledger: it posts the coded entries as journals or drafts and parks uncoded lines in suspense.
Hands back
An object with entries (a list, each with business_date, account, department, tax_code, debit, credit, description and status (posted, draft or suspense)), tie_out (an object with each night audit total, the posted total and the difference) and questions (a list).
Asks a person when
An entry is above 1000, is not covered by a standing mapping, is capitalised, falls in a closed period, the posting does not tie to the night audit within 1, or a line would go to 9999 Suspense.
Settings
Your limits, set by your managers.
| Setting | Default | What it controls |
|---|---|---|
| Post without review up to (USD) | 1000 | A single entry above this is posted as a draft for review. |
| Capitalise FF&E from (USD) | 2500 | Furniture, fixtures and equipment at or above this is capitalised, not expensed. |
| Suspense account | 9999 Suspense | Where lines it cannot code are parked. |
| Night audit tie-out tolerance (USD) | 1 | Posted revenue, tax and payments must tie to the night audit report within this. |
| Post service charge to the staff distribution liability | On | When on, service charge and tips collected are posted to the liability account, never to revenue, until paid out through payroll. |
Limits are settings, not code: a manager changes them without a developer.
Rules it always follows
- Code each PMS transaction code and POS outlet to its USALI department and account from the standing mapping, with its tax code.
- Posted room, F&B and other revenue, taxes and payments must tie to the night audit totals within 1; if not, nothing posts and the difference is reported.
- When on is true, service charge and tips go to the staff distribution liability, and tourism and occupancy tax collected goes to its tax payable account, never to revenue.
- Post entries up to 1000 directly and anything above as a draft for the Financial Controller.
- Capitalise FF&E at or above 2500; anything without a standing mapping goes to 9999 Suspense with a question.
See the Night Audit Posting Agent agent on your own work.
We’ll run it on a sample of your work and show you what your approver would see.