Case Study
Auditing Records Across a Multi-Location Franchise
A completed internship auditing driver contracts and utility bills and working with real sales data across a multi-location franchise organization.
Context
Gabriel completed a customized Accounting & Finance internship with Rosati’s corporate office over the summer, working both in the corporate office and remotely. The internship combined three separate hands-on projects — a driver-contract audit, a utility-bill audit, and a sales-reporting project — plus exposure to how a multi-location franchise organization actually runs day to day.
Driver-Contract Audit
Gabriel reviewed driver-roster and contract-status information across approximately 30 franchise locations, working through which agreements were completed, which were outstanding, and which were missing entirely. That meant reconciling information across different internal records rather than taking any single list at face value.
The point of the project wasn’t to rebuild the organization’s driver-contract system — it was to give the team better visibility into which records still needed follow-up, by surfacing the gaps clearly enough that someone could act on them.
Auditing Utility Bills
Separately, Gabriel reviewed gas, electric, and internet bills across franchise locations: accessing and reviewing invoices, extracting the relevant account and cost information, and entering and organizing it so figures could be compared side by side. Where something in a bill wasn’t clear, the approach was to ask a clarifying question rather than guess.
That review surfaced a billing discrepancy that required additional review by the corporate team. No specific dollar figure is published here — the underlying invoices are Rosati’s internal business data, not Gabriel’s to publish — but flagging it followed the same pattern as the rest of the internship: check, don’t assume.
Working With Real Sales Data
For the sales-reporting project, Gabriel worked with Rosati’s 2025 Control Sales Report and Live Indicators data in Excel — organizing and reviewing actual company sales information rather than a classroom exercise built around made-up numbers. The point of this project was building the habit of interpreting real business data, not producing a specific recommendation or result; no claim is made here about any resulting change in company strategy or revenue.
In the Corporate Office and Remotely
Gabriel completed his work both in Rosati’s corporate office and remotely, receiving assignments from a professional supervisor and working independently to meet stated guidelines and deadlines, communicating progress along the way and asking questions when something needed clarifying. Time spent working around adult professionals in the corporate office — rather than only working remotely — was its own kind of exposure: seeing firsthand how a multi-location franchise organization operates, and how the accounting information Gabriel was reviewing actually connects to the decisions the business makes.
The internship also included a National Franchise Meeting, a company Town Hall, and internal accounting and business-training sessions — broader exposure to the organization woven in alongside the three assigned projects rather than treated as a separate track.
Reflection
A record that looks complete at a glance can still have gaps in it. Whether it was a driver-contract list across 30 locations or a set of utility invoices, the only way to know if something was actually right was to check it against something else instead of trusting that it was probably fine — a habit that later turned into actual code, in the Algorithmic Trading Research System.