Expense Reporting App - Created & Coded by Sonam Kaloti in Microsoft Power Apps
Behind the Curtain,
Running the Show
I design functional systems that bring clarity, efficiency, and cohesion across business operations, project management, and event production. My work ranges from back-end infrastructure—like building floor plans, SOPs for spa scheduling in Fresha, and custom-coded Excel tools that automate AP inputs and track utility expenses—to immersive, logistics-heavy experiences like a full-scale murder mystery escape room party, complete with asset lists, gameplay flow, and site execution.
I apply project management principles to everything I build: defining scope, anticipating bottlenecks, and translating complexity into usable tools. My recent portfolio includes a visual expense report app prototype and systems for reconciling RBC Visa statements, alongside operational logs for SOP development. Every build, from spreadsheet to immersive event, is rooted in function-first design—streamlining how things work, and how teams move.
PROJECT MANAGEMENT & EVENT PLANNING
Conceptual proposal for a VOKRA community event—crafted as a demonstration of event planning, outreach, and logistical strategy.
Staffing Requirements | Event Budget
Production Schedule | Planning Timeline
Company roles and functions - responsibility delegation and management.
Financial Actuals and Forecasting
“Carnival Noir: The Final Act”
Murder Mystery x Escape Room Event
Created and Hosted by Sonam Kaloti
custom-coded and conditionally formatted
EXCEL TOOLS & TEMPLATES
GL Code Builder - Easy-Input Access to Financial GL Ledger Codes
GL Code Builder - Background Coding
GL Code Builder - Background Coding
Utility Query - Conditionally Formatted to Auto-Update by Date, Ensuring Timely Payment Processing
Utility Query - Conditional Formatting
Company Bank Reconciliation Template - Coded to Automatically Match Bank Statement Deductions Against Partial File Totals
Company Bank Reconciliation - Background Coding
Company Credit Card Statements Template - Generates Coding Table Based on Background Coding, Data Validation, and Pivot Tables
Company Credit Card Statements Template - Background Coding
Company Credit Card Statements Template - Background Coding
Company Credit Card Statements Template - Pivot Table With Auto-Generated Coding
KPI Reports - Finance and Accounting Payment Tracking
Invoice Tracker - Facilitates Communication on Invoice Processing Between AP and Plant Accounting Teams. Search Bar Coded to Use Either Invoice Number or PO Number Input to Quickly Find Details
SOP Development
Company Procedure Documentation & Training Manuals
Floor Plans & 3D Construction Models
Floor plans and 3D models created for studio construction and layout planning.
Focused on structure, spatial logic, and functional use.

