Get tasks doneBusiness size: Company

Singapore Management University automated its daily finance file preparation

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

Go to the skill

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.

This is the result as claimed in the public source linked below. It has not been checked and is not a typical outcome.

Proof

Read the original public source

Try it yourself

Rehearse a clean and join process on copies.

Difficulty: Intermediate

Prompt

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.

Prompt: starter by Solopreneur Code

Tools

  • Microsoft 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.

Starter version by Solopreneur Code

Skill: Money and bookkeeping

Add this skill

Money and bookkeepingDifficulty: Intermediate

Review a recurring spreadsheet join

Tests a finance file join and reports exceptions before import.

Works with
Claude, ChatGPT, Gemini Manual sample and output review. No Outlook, TMS, SAP or robot connector is included.
Tools in the story
Microsoft Excel (source-used)
Country
Singapore

How to use this: Copy the skill, paste it into Claude, ChatGPT or Gemini, and ask it to save it as a skill. If it cannot, it will still follow the steps.

Show skill

If the Copy button does not work, select this text and copy it.

Sign up for the newsletter

Get the next story from Solopreneur Code in your inbox.

Form not loading? Subscribe on Substack

Back to all stories

More like this

Browse all stories
Get tasks doneBusiness size: SoloIncludes prompt

Solo Tested demonstrates a linked accounting evidence PDF using invented-company mock-ups, with reviewer byline Noa Lin unverified

Noa Lin (source reviewer byline, identity unverified) @solotested · Country unknown · Claude Code, PyMuPDF, Microsoft Excel

The source describes document conversion and an accounting evidence PDF build. Public illustrations are invented-company mock-ups. Claimed private client inputs are not available for review. No completed client tax work or audit outcome is established.

Result, as claimed

Workflow demonstration, not an audited client result. The article illustrates the process with mock-ups whose company and figures are invented. Its claimed underlying client documents are not public. The source reports a first version of 91 pages with 15 accounts linked and a second of 164 pages with 20 accounts across 13 sections plus a five-document folio. It says trade-debtor and trade-creditor balances were flagged because they were absent from their reconciliation reports. The linked social post claims almost an hour saved, without independent timing evidence.

Once a week it reads his spam and archived email, groups it by sender and looks for events and articles that fit his goals for the year. For each useful sender it gives up to 5 action points and suggests pulling it out of spam or unsubscribing. It now checks his calendar and working hours before it shortlists events. Claude also names new files and chats to one convention and drafts unusual workshop formats for him to pick from.

Result, as claimed

The first run went through 718 emails and it now handles about 30 a week. He says AI gives him back 3 to 4 hours a week, and one webinar it flagged put him on a path to new work.

Get tasks doneBusiness size: SoloIncludes prompt

A marketing educator has Claude route her inbox into CRM deals, tasks and draft replies, and says agents save her 3 to 4 hours a week

Cristina Peñaloza Morales · Country unknown · Claude, Gmail, HubSpot, Todoist, Notion, Riverside, Gamma

Reads new email and routes each one. Training enquiries become a HubSpot contact and deal with a drafted reply. Community messages get a draft reply. Possible collaborations become a Todoist task. Invoices and admin get a label. Also runs a scheduled Monday AI news digest.

Result, as claimed

She says agents save her between 3 and 4 hours a week.