Skill · Front office
POS end-of-day reconciliation
Which terminal's close does not match the PMS?
Download skill package
pos-mutabakati/ ├─ SKILL.md ├─ assets/ │ └─ ornek-girdi.xlsx └─ ornekler/ ├─ analiz.xlsx └─ yonetim-ozeti.docx
SKILL.md instructions and sample files in one package
How to use
- Download the package.
- In an assistant that supports skills (e.g. Claude), upload the package as a skill. In other assistants, paste the SKILL.md text into the chat.
- Attach your own Excel export and send the message below. The assistant prepares the formula-based workbook and the Word summary.
Try it with the sample
Before using your own data you can try the sample input in the package. Send this message to the assistant together with the file:
Compare the PMS card payments with the POS end-of-day reports. Show the unmatched terminals and amounts in Excel. Prepare a Word handover note for the night manager.
Two of the five terminal records matched. Three records are awaiting review.
Sample files
- Sample input
ornek-girdi.xlsx - Expected Excel analysis
analiz.xlsx - Expected Word summary
yonetim-ozeti.docx
The sample files are in Turkish.
Instructions (SKILL.md)
Read the attached Excel files and work on a copy of the workbook. If there are multiple tabs, different headers or separate files, map the fields whose meaning can be verified. Note the source file, tab, field, scope and excluded records. Check date and number formats. Reconcile with the source total. If an ambiguity affects the result, ask a single, concrete question. Keep the metrics that can be produced. Deliver analiz.xlsx and yonetim-ozeti.docx to the user. The Excel file should include Analysis, Checks and the required anonymised source fields. Use traceable formulas for derived numbers. The Word file should cover the period, the main result, at most three evidenced findings and the work the team should check. Reopen the files, check for formula errors and compare the Word figures with Excel. Use the sample inputs only when the user wants to work with the sample.
- Select the card payments and the terminal's gross transaction closes. Keep the settlement amount net of bank commission separate. Match on hotel, business day, terminal and currency. For transactions after midnight, if the business-day definition is unclear, do not infer it from the time. State the date coverage on both sides.
- Check the sale and refund flags per source. Compute net as sales minus refunds. If the report is already net, do not deduct refunds a second time. Determine the effect of void/cancelled status from the source report's definition. Do not add the terminal subtotal on top of the transaction list.
- For each hotel × business day × terminal × currency record, calculate PMS net minus POS net. Clearly flag a missing counterpart record and leave the difference blank. Evaluate each currency on its own. Do not net off opposing terminal differences against each other and call them reconciled. Compare with zero tolerance, at the source precision of the relevant currency. If the file defines a tolerance, make it visible.
- In Excel, show the two net amounts, the signed difference and the status. In Word, give the counts of matched records, records with a different amount and records missing the counterpart source. List the largest absolute differences per currency with the terminal name. Do not attribute a cause to a difference whose root cause cannot be verified. Keep card numbers, guest names and payment references out of the management summary.
Try it with the sample
Compare the PMS card payments with the POS end-of-day reports. Show the unmatched terminals and amounts in Excel. Prepare a Word handover note for the night manager.
The sample file is assets/ornek-girdi.xlsx. The expected Excel and Word outputs are in the ornekler/ folder.