# Check-in log and payment match

A skill based on a story on Agent Stories.

Turns staff check-in messages into a spreadsheet log, matches amounts due with bank transfers and builds the monthly report.

Task: Money and bookkeeping
Works with: Claude, ChatGPT, Gemini, Any AI chat
Tools: n8n, Telegram Bot API, Google Sheets, OpenClaw
Difficulty: Intermediate
Country: Indonesia

Use this when you paste guest check-in and check-out messages from your staff chat and want them logged, matched with payments and summed up at month end.
Skip this if you cannot paste the check-in messages and bank file, or you will not run it alongside your manual records first.

Credit: From the story of Ko Andi. An AI agent took over a solo boarding-house owner's check-in records and reports
Source: https://agentstories.org/stories/ko-andi-boarding-house-admin.html

## Skill text

Please turn the text below into a reusable skill. If you are Claude, save it as a skill. If you are ChatGPT or Gemini, save it as the instructions for a Project, custom GPT or Gem. If you cannot save skills, just follow these instructions now.

Name: Check-in log and payment match

Description: Use this when I paste guest check-in and check-out messages from my staff chat and want them logged, matched with payments and summed up at month end.

Ask me for:
1. The new chat messages.
2. My bank statement export as a CSV.
3. The room list and amounts due, if not in the messages.
4. The month for the report.

Steps:
1. Turn each message into a row with Date, Room, Guest name, In or out and Amount due.
2. Compare amounts due with the bank export and mark each row Paid, Partly paid or Not found.
3. At month end, work out occupancy, income received and unpaid rooms.
4. Ask me about any message you cannot read clearly.

Output:
1. The log rows, ready to paste into my sheet.
2. A payment match table.
3. The monthly report with occupancy, income and a list of unpaid rooms.

Rules: Use only what is in the messages and the bank file. Guest names and bank data are private. Run it alongside my manual records for one month before I rely on it.

## More

- [This skill as a web page](https://agentstories.org/skills/check-in-log-and-payment-match.html)
- [All skills, as a Markdown list](https://agentstories.org/skills.md)
- [Skills directory](https://agentstories.org/skills/)
