A sports federation where one person spent her week copying numbers between systems

The federation ran on tools that did not talk to each other. Member registrations came in through one platform, invoices went out by email through another, payments cleared through a payment processor, and the accounting ledger sat apart from all of them. Nothing connected, so a person bridged the gap by hand. One full-time staff member spent her days exporting from one tool, reshaping the columns, and pasting them into the next, on top of carrying the finance and budget function herself.

The federation runs on roughly five to six million dollars a year, much of it from grants whose amounts shift mid-year. Every time a grant figure changed, the forecast budget had to be rebuilt by hand, which meant starting over. The numbers were sensitive, salaries among them, and the team had no reliable view of which copy of which spreadsheet was current. The organization was also moving to a new accounting system and wanted it to finally become the financial source of truth instead of one more island.

We did not try to force the existing tools to integrate with each other. Instead we built an independent data layer that sits underneath them and is not tied to any single product. Registrations, invoicing, and payment records flow into it automatically, the accounting system is wired in as the authoritative ledger, and the data is centralized once so it never has to be copied between platforms again.

The accounting system became the single source of truth for entries and financial reads. On top of the clean data, the forecast budget updates itself when a grant figure moves rather than forcing a full rebuild, and month-end close draws from one consistent set of numbers. Because the data lives in its own layer rather than locked inside a vendor, the federation can swap any one tool later without losing its history, and access is role-based with strict permissions over sensitive figures like payroll.

The full-time role that used to be consumed by exporting, reshaping, and pasting is no longer spent that way. That person now works on the finance and budget function itself instead of moving data between systems, and the manual consolidation that ran all week is gone. Month-end close is assembled from one clean set of numbers rather than reconciled across exports.

The forecast budget no longer restarts from zero every time a grant amount changes, it adjusts. There is one current version of the financial picture, sensitive figures are held behind role-based access, and the federation is no longer locked to any single tool, since the data lives in a layer it controls.