Expense Reporting App - Created & Coded by Sonam Kaloti in Microsoft Power Apps
Behind the Curtain, Running the Show
Sonam Kaloti designs functional systems that bring clarity, efficiency, and cohesion across business operations, project management, and event production. Her 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.
Sonam applies project management principles to everything she builds: defining scope, anticipating bottlenecks, and translating complexity into usable tools. Her 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.
Company roles and functions - responsibility delegation and management.
Staffing Requirements | Event Budget
Production Schedule | Planning Timeline
Financial Actuals and Forecasting
Production Analysis and Reporting
“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.



