AI Workflow / Data Analysis
Football Finance
[PROJECT_IMAGE]
The Situation
UK football clubs file annual accounts with Companies House, but extracting and interpreting financial data across multiple clubs is slow, manual work. It requires accounting knowledge, patience with inconsistent PDF formats, and hours of time that most analysts don't have.
The Problem
A single club's accounts could take hours to read and analyse manually. There was no way to compare financials across clubs at scale, or to extract structured data from unstructured PDF filings without significant effort.
The Approach
Combined Claude Code, the Companies House API, and Perplexity to build an automated pipeline. Claude handles interpretation and plain-English synthesis; Companies House provides the raw filing data; Perplexity fills in context where filings are ambiguous or incomplete.
What I Built
A pipeline that ingests filed accounts and outputs structured Excel and PDF reports -covering revenue, wages, profitability, and debt across multiple clubs in a single run. The output is designed to be readable by a finance professional without any further processing.
The Stack