HospitalityHospitality
Food Truck Financial Model
View case study
Back to all work
HospitalityClient engagement
Financial Analysis: POS Sales & Operations
A Square POS sales-and-operations deep-dive for a hospitality venue: net sales, tickets, tips, fees, and daily trends.
Shown anonymised at the client's request.
- Client
- Confidential
- Our role
- Financial Analyst
The engagement
The client had raw Square POS exports but no structured view of sales performance, tip and fee patterns, or day-to-day operational trends.
What we built
A 5-tab analysis built from Square POS data: a summary, a monthly trend view, an operational analysis, daily sales detail, and a ratios & analysis tab, with internal-consistency checks throughout.
The outcome
$97K in net sales reconciled across 3,171 transactions and 204 trading days, with a $30.60 average ticket and clear monthly and daily sales trends surfaced for the operator.
Deliverables
- Sales summary
- Monthly trend analysis
- Operational analysis
- Daily sales detail
- Ratios & analysis
Skills & tools
- Sales Analysis
- POS Data Reconciliation
- Hospitality Finance
- Operational KPIs
- Trend Analysis
- Data Cleaning
- Advanced Excel
Deliverable (view only)
ProtectedFinancial Analysis: POS Sales & Operations
Opens in a distraction free, full screen reader. View only, no download.
Downloading, printing and copying are disabled. All work is the property of A&S Financial Consultants and its clients.
Discuss a similar model
Book a free scoping call and we will map out the model your business needs. Available 9:00 AM to 8:00 PM EST, Mon to Fri.
