---
title: "Singapore Management University automated its daily finance file preparation"
person: "Singapore Management University"
tools:
  - "SMU internal RPA solution"
  - "Microsoft Excel"
country: "Singapore"
category: "Get tasks done"
category_slug: get-tasks-done
proof:
  - label: "Read the original public source"
    url: "https://goru.sg/stories/smu-data-processing"
date: 2026-11-07
date_posted: 2026-10-20
as_claimed: "The result is shown as claimed in the public source linked here. It has not been checked and is not a typical outcome."
url: "https://agentstories.org/stories/smu-daily-finance-data-processing-rpa.html"
markdown_url: "https://agentstories.org/stories/smu-daily-finance-data-processing-rpa.md"
site: "Agent Stories by Solopreneur Code"
---

# Singapore Management University automated its daily finance file preparation

Singapore Management University · Singapore · SMU internal RPA solution, Microsoft Excel

## What the agent did

An internally developed fixed RPA workflow retrieves the password, extracts and converts files, populates fields, matches accounting references and consolidates the reporting spreadsheet.

## Result, as claimed

GORU reports 60 min to 8 sec of data processing per run and 59 min saved per day.

> The result is shown as claimed in the public source linked here. It has not been checked and is not a typical outcome.

## Proof

- [Read the original public source](https://goru.sg/stories/smu-data-processing)

## Try it yourself

Rehearse a clean and join process on copies.

Prompt:

```text
Using [redacted sample export], [reference rows], [join key] and [columns allowed to fill down], propose an Excel workflow. Show input and output row counts, duplicate keys and unmatched rows. Keep ambiguous matches in an exceptions list. Produce a review draft only.
```

Tools:

- [Microsoft Excel](https://www.microsoft.com/en-us/microsoft-365/excel): Source-named tool. Use a copy with synthetic or redacted data.

Steps:

1. Copy ten sample rows and record expected totals.
2. Fill down only in allowed columns and test the join.
3. Compare counts and totals, then inspect duplicates and missing matches.
4. Have the process owner review. Stop before appending, deleting or emailing.

Watch out: A non-unique join key can silently multiply financial rows.

## More

- [This story as a web page](https://agentstories.org/stories/smu-daily-finance-data-processing-rpa.html)
- [More stories: Get tasks done](https://agentstories.org/categories/get-tasks-done.html)
- [More stories from Singapore](https://agentstories.org/countries/singapore.html)
- [More stories that use Microsoft Excel](https://agentstories.org/tools/microsoft-excel.html)
- [Every story, indexed for AI assistants](https://agentstories.org/llms.txt)
