Case Study
From a full day of reporting she never had time for, squeezed in after hours, to a 15-minute job and a day back every month
Company
R&A Marine Services
Industry
Shipping, telecommunications and energy, Papua New Guinea and Australia
Problem
The monthly accounts payable report took more than a day to build by hand and often went out late.
What we built
- • An accounts payable report assistant in Claude
- • One report with a summary up front, replacing three separate spreadsheets
- • A pay or hold column for the CEO's decisions
- • An email draft for Eva to check and send
Outcome
- ✔ A day back every month: the report now takes about 15 minutes
- ✔ Three reports became one
- ✔ Eva checks and sends, and the assistant never sends
The Situation
Where things stood
R&A Marine Services is a family-led business working across Papua New Guinea and Australia, employing about 300 staff across shipping, telecommunications and energy projects.
Eva manages accounts payable and payroll. By the 15th of each month, her team has entered and reconciled every supplier invoice. Eva then turns that into a report for the leadership team by the 21st: what's owed, what's ageing, which purchase orders are still open and why, and what's been paid.
That report took a full day, and Eva never had a spare day. So it got squeezed in after hours, around everything else, and the leadership team would follow up asking where it was.
The Bottleneck
What was actually in the way
- Three separate reports, from three exports, put together by hand in Excel
- A note typed by hand for every open purchase order, explaining why it was still open
- Checking the team's work could take days
- Report building got squeezed in around everything else, often after hours and past the 21st
- The leadership team wanted one summary, not three spreadsheets
"It takes me three days to check all the things, and even today I was chasing the ladies to check the excels, especially the open purchase orders."
The Fix
What we built
1. Mapping the process. Nina and Eva spent a half-day session mapping every step of the report: where each number comes from, what the team checks, and what the leadership team needs to see first.
2. Building the assistant. Eva starts it by saying "let's do my report". It first checks that her team has confirmed the reconciliation. Then it pulls the latest exports from Dropbox and builds one report:
- a summary
- ageing
- open purchase orders by month, with the reason each is open
- supplier payments
- spending by account
It flags anything that doesn't add up, and asks rather than guesses.
It passed its first live run. The September report was built in about 15 minutes, work that used to take Eva more than a day.
3. Keeping Eva in charge. The checking stays with Eva and her team. The assistant drafts her email to the leadership team with a link to the report. Eva checks it and sends it herself. It never sends anything.
"Now I learn like before starting it, we have to give him the right information."
Tool layer
- Claude: the accounts payable report assistant
- Dropbox: where the accounting exports and finished reports live
- Outlook: the email draft for Eva to send
The Outcome
What changed
- ✔A day back every month: the month-end report now takes about 15 minutes
- ✔Three monthly reports became one, with a summary up front
- ✔The CEO records pay or hold decisions in the report itself, not over email
- ✔Eva went on to build her own personal assistant, and payroll is next
The Human Payoff
What it actually meant
Eva never had a spare day for this report. Now it simply falls off her shoulders. It takes 15 minutes to check and send, and she has that day back every month for the work that actually needs her.
"This is fun, and I'm learning."
Client Feedback
"I'm happy that I'm gonna get the report, and by next month, all my work will be easy."
Eva, Accounts Payable and Payroll Manager, R&A Marine Services, Papua New Guinea
More Results
