Skill · Sales and revenue

Reservation pickup

Since yesterday, on which stay dates have we gained or lost rooms?

Type
Skill
Department
Sales and revenue
Input
Two PMS occupancy reports taken on different dates
Output
Formula-based Excel analysis and a one-page Word summary
License
CC BY 4.0
Raw text
SKILL.md

Download skill package

rezervasyon-pickup/
├─ SKILL.md
├─ assets/
│  └─ ornek-girdi.xlsx
└─ ornekler/
   ├─ analiz.xlsx
   └─ yonetim-ozeti.docx
Download skill package .zip

SKILL.md instructions and sample files in one package

How to use

  1. Download the package.
  2. 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.
  3. 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:

message
Compare my two reservation reports. Calculate net pickup and current occupancy by stay date. Prepare an Excel analysis and a one-page Word summary for the sales meeting.
Expected result on the sample data

Across four common stay dates, a net 9 room nights were gained.

Sample files

The sample files are in Turkish.

Instructions (SKILL.md)

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.

  1. Map the date the report was taken and the guest's stay date to separate fields. Verify the order of the two snapshots. Limit the scope to a single hotel and equivalent reservation statuses. If there is more than one hotel, report them separately. Identify the rooms available for sale and the rooms on the books. If there is no capacity field, still produce the pickup analysis.
  2. Use the stay date as the basis. Do not add room-type or channel sub-rows together with the hotel total. Use the union of the dates in both reports. Show stays before the current report date as out of scope. If a single file contains several report dates, state in the heading which two snapshots were used.
  3. Net pickup = current rooms on the books − previous rooms on the books. On a single stay date the difference is in rooms; summed across dates the total difference is in room nights. Current occupancy = current rooms on the books / current rooms available for sale on that date. Include in the total pickup only the stay dates present in both snapshots. Do not count a side with a missing record as zero. Flag capacity changes. If capacity is zero, leave the rate blank. Keep rates above 100% and put them under review.
  4. In Excel, provide columns for stay date, previous and current rooms, net pickup, current capacity, occupancy and a check note. In Word, write the net room-night change, the dates with the largest increase and decrease, how many dates were left out and the point the sales team should review. Do not derive cancellation or new-booking counts without a movement report.

Try it with the sample

Compare my two reservation reports. Calculate net pickup and current occupancy by stay date. Prepare an Excel analysis and a one-page Word summary for the sales meeting.

The sample file is assets/ornek-girdi.xlsx. The expected Excel and Word outputs are in the ornekler/ folder.

Let Talkwo run this work for you

Talkwo brings your PMS, messaging and review data into one place and prepares these reports for you every morning.

Meet Talkwo

License: The prompts and skills in this library are licensed under CC BY 4.0. You may copy, adapt and use them freely, including commercially, as long as you credit Talkwo. CC BY 4.0

Sample files use fictional hotel data.

© 2026 Talkwo Contact Privacy Terms