A monthly ops routine for pulling financial data from Pilot.com and updating the shared financial file in the company hub. This walkthrough focuses on the repeatable mechanics of moving numbers from a finance vendor tool into an internal reference doc without breaking formatting or introducing errors, a pattern that applies to any recurring data-sync task between an external SaaS tool and an internal hub.
Monthly Financial Update: Pilot.com to Company Hub
The Workflow, Step by Step3
Log into Pilot.com and pull the latest financial figures
At the start of the monthly cycle, the presenter goes into Pilot.com to retrieve the updated financial numbers that need to be reflected internally.
Open the company hub's financial file
The presenter navigates to the shared financial file that lives in the company hub, which serves as the internal source of truth other teams reference.
Transfer and update the figures in the hub file
The new numbers from Pilot.com are entered into the company hub file, replacing or updating the prior month's figures so the internal file stays current.
Tools Used and What For2
Pilot.com
External finance/accounting platform used as the source of monthly financial figures.
Company hub
Internal shared document/workspace where the financial file is maintained for company-wide reference.
Reusable Takeaways2
Build a monthly cadence around external-to-internal data syncs
When a source-of-truth tool (like a finance or HR platform) lives outside your main company workspace, set a fixed monthly touchpoint to pull and reconcile the data rather than letting it drift out of sync.
Keep one internal file as the single reference point
Centralizing updated numbers into one hub file, rather than pointing teams to the external tool directly, reduces confusion about which number is current.
Failures and Gotchas1
Session detail is limited
The transcript and notes only describe the high-level steps of the routine; no specific errors, formatting issues, or edge cases were captured in this recording.

Founder and CEO
Hey everyone, I'm Michael - founder and CEO of Flamingo. Before this, I built Vicarius, a cybersecurity company focused on vulnerability remediation, where I raised over $60M in funding. Working closely with service providers through that journey, I saw firsthand how MSPs were losing money to vendor payouts and inefficient systems - and that's when the idea for Flamingo clicked. I set out to build an open-source platform that dramatically increases MSP margins while helping them deliver better service to their clients.