---
name: pos-mutabakati
description: "Produces Excel and Word reports by running a POS end-of-day reconciliation analysis on the PMS card payment report and the terminal end-of-day report."
---

# POS end-of-day reconciliation

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.

1. 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.

2. 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.

3. 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.

4. 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.
