Vespa - Project Management Office Reporting Tool

"My IT department is trying to sell me a Mack truck when all I need is a Vespa" - PMO Manager

Client

Corporate & Institutional Bank

Business Problem

The Project Management Office at a corporate and institutional bank needed a cost-effective system to track project budgets, monitor costs, and produce flexible management reports.

Their IT department proposed a six-figure solution with a six-month delivery timeline — significantly exceeding the PMO's budget and urgency. The PMO Manager's assessment: "My IT department is trying to sell me a Mack truck when all I need is a Vespa."

Solution Delivered

We built "Vespa" — a lightweight but capable MS Access database solution designed for the six-person PMO team.

  • A centralised project cost tracking system accessible to all PMO team members
  • Pre-formatted Excel report templates drawing directly from the database, eliminating manual data consolidation
  • Flexible ad-hoc reporting capability for management reviews and budget variance analysis

Delivered in weeks at a fraction of the IT department's quote.

Results

  • Delivered in weeks rather than 6 months — meeting the PMO's immediate operational need
  • Cost a fraction of the IT department's six-figure quote
  • Enabled 6 PMO staff to track and report project costs independently without IT support
  • Provided flexible reporting that scaled with the team's evolving project portfolio

Technology

MS Access | Excel | VBA

Free Download

Explore 30 Excel Solutions Used by Leading Financial Services Firms

Discover how Excel automation can drive measurable results. This exclusive portfolio showcases over 30 high-impact projects, each designed to streamline workflows, save time, and reduce operational risks for financial services firms. Download now to see real examples of how we’ve helped firms like yours achieve ROI gains of up to 631%.

Ready to stop managing Excel and start improving it?

Book a 30-minute discovery call.

We'll look at your current Excel environment, identify where the biggest risks and inefficiencies are, and tell you honestly whether Excel on Tap is the right fit.

No sales pitch. No obligation. Just a straightforward conversation about your situation.

Book a Discovery Call
>