# Review a recurring spreadsheet join

A skill based on a story on Agent Stories.

Tests a finance file join and reports exceptions before import.

Task: Money
Works with: Claude, ChatGPT, Gemini
Tools: Microsoft Excel (source-used)
Difficulty: Intermediate
Country: Singapore

Use this when you need to prepare repeated exports for a controlled import.
Skip this if you want the join imported or files overwritten without a person approving exceptions.

Credit: From the story of Singapore Management University. Singapore Management University automated its daily finance file preparation
Source: https://agentstories.org/stories/smu-daily-finance-data-processing-rpa.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
Review a recurring spreadsheet join

Description
Use this when you need to prepare repeated exports for a controlled import

Ask me for
Redacted source and reference rows, the intended join key, permitted fill-down columns and expected totals.

Steps
1. Count inputs and identify duplicate or blank keys.
2. Describe cleaning rules and preview joined rows.
3. List missing and multiple matches. Compare control totals against the expected totals.
4. Ask the process owner to confirm exceptions and approve the draft.

Output
A draft mapping, exceptions list and control totals.

Rules
Use redacted data and follow applicable privacy duties, including Singapore PDPA where relevant. Do not invent matches, overwrite files, import entries or send anything.

## More

- [This skill as a web page](https://agentstories.org/skills/recurring-spreadsheet-join-review.html)
- [All skills, as a Markdown list](https://agentstories.org/skills.md)
- [Skills directory](https://agentstories.org/skills/)
