Resort P&L Financial Tracker
A comprehensive weekly profit & loss tracking system built for McCarthy Lodge Resort, a historic Alaska resort (est. 1906). Automates financial reporting across three revenue departments (Food & Beverage, Hotel, Mercantile) plus 25+ SG&A expense categories, with an executive dashboard, PDF exports, and role-based access control.
The Challenge
McCarthy Lodge Resort operated three distinct revenue streams — Food & Beverage, Hotel, and Mercantile retail — each with their own cost structures. Financial data was scattered across multiple spreadsheets with no real-time visibility. Weekly P&L compilation took 4+ hours, and generating board-ready reports was a manual, error-prone process. Management had no way to compare week-over-week performance or spot trends across departments.
The Solution
Built a full-stack web application with dedicated data entry forms for each department, a real-time executive dashboard with KPI cards and interactive charts (revenue trends, expense breakdowns, net margin tracking), and advanced reporting with company-wide and department-specific P&L statements. Added role-based access control with granular permissions, 52-week period management, and one-click PDF exports for stakeholder meetings.
Results & Impact
Weekly P&L compilation dropped from 4+ hours to under 15 minutes. Leadership gained real-time access to departmental trends, enabling faster operational decisions. Board-ready reports are now generated in seconds. The permission system ensures only authorized staff access sensitive financial data.
Key Features
Multi-department P&L tracking (F&B, Hotel, Mercantile)
Executive dashboard with interactive charts
52-week period management
Role-based access with 2FA
PDF report generation
25+ SG&A expense categories
Project Deep Dive
McCarthy Lodge Resort is a 117-year-old Alaska hospitality business with a uniquely complex financial structure. Three completely separate revenue operations — a restaurant/bar (F&B), hotel rooms, and a mercantile retail shop — each generate income and expenses on different cycles. The resort also tracks 25+ overhead/SGA expense categories ranging from admin payroll to fuel costs to seasonal marketing.
The existing process involved multiple Excel workbooks that different managers updated independently, with the general manager manually consolidating them every week. Cross-department comparisons were virtually impossible, and the annual board presentation required weeks of manual chart creation.
We built the system around a PnlCalculationService that handles all financial computations — weekly P&L per department, cumulative aggregation through any selected week, automatic net income calculations, and payroll/COGS separation. The 52-week period system aligns to the resort's fiscal calendar, and data entry forms mirror the exact line items each department manager was already tracking in Excel.
The executive dashboard uses ApexCharts for interactive visualizations: stacked bar charts for weekly revenue breakdown, cumulative trend lines for revenue and net income, department comparison views, and expense category pie charts. Every view can be filtered by period and week range, making year-over-year comparison straightforward.
Security was critical for this project. We implemented Spatie Permission with three roles (Super Admin, Admin, User) and granular permissions for viewing P&L, editing entries, exporting reports, and managing periods. Two-factor authentication adds an extra layer of protection for sensitive financial data.
Technologies Used
"Before this tool, I was spending every Monday morning buried in spreadsheets trying to figure out how the week went. Now I open the dashboard and everything is right there — revenue, expenses, margins, all broken out by department. Our board meetings are completely different now."
Ready to Transform Your Excel?
Stop struggling with complex spreadsheets. Get a professional web application built to your exact specifications.