Case Studies & Portfolio

The Baseline: Sifting Through the Chaos

When I took over this process, the administrative system just couldn’t keep up with how fast the business was growing. The alert module was filled with hundreds of unresolved notifications, and the backend customer dashboards didn’t match the central CRM. Because the tracking was out of sync, it was incredibly difficult to tell when customer contracts actually ended or exactly how much data they were using.

Before planning for the future, the system needed to get back to a clean slate. I rolled up my sleeves and manually went through the entire backlog, checking every single client project against actual sales history and hunting down missing contracts.

During this big cleanup, a major issue was uncovered: because the tracking systems hadn’t been connected, some active customers were going over their project limits completely undetected. Thanks to the audit, the company was able to go back to those active clients, bill them for their actual usage, and immediately bring in that lost revenue.

Once the backlog was completely cleared and the data was verified, I built a simple, daily monitoring system to catch these overages in real time so the issue wouldn’t happen again.

Phase 1: Real-Time Account Lifecycle Monitoring

Once a clean slate was established, the goal was making sure the backend system and the CRM talked to each other perfectly every single day so the data stayed completely accurate.

• Catch the Discrepancy – Daily Audit: Every morning, I checked the system for newly created projects. If a project was missing an expiration date, it immediately caught my eye. I’d grab the project name and look it up in the CRM.
• Match the Contract Details – System Sync: Once the account was located, I checked the contract details to see exactly what had been paid for—like how many years they signed up for and their specific project limit details.
• Update the Limits – Data Guarding: I’d jump into the backend settings, plug in their project limits, and log a confirmation checkmark in the CRM so everyone on the team knew the guardrails were up.
• Set the Expiration – Closing the Loop: If the contract terms were locked in, I set the exact expiration date in both systems. If the account details were still up in the air, I used a rolling weekly alert loop to clear it for the day but remind myself to check back on it the following week.

Catching the Anomalies: Every now and then, a project would get generated before a contract was officially finalized. I built a simple safety valve into the process: I’d set the account to a temporary 2-week window, flag it in the CRM, and ping the account managers on Slack so they could follow up and finalize the paperwork.

Phase 2: Preventing Revenue Leakage & Driving Upsells

Once the initial back-billing was complete, I used Phase 2 of this daily system to ensure usage overages were caught in real time so the business always captured billable usage moving forward.

• The Trigger: The moment a client reached or went over their pre-paid project limit, an alert popped up on the dashboard.
• The Audit: I pulled the client’s actual usage history to see if it was a temporary data spike or if they had genuinely outgrew their plan.
• The Hand-off: I logged the exact overage date and amount in the CRM, created a mandatory follow-up task, and looped in the Customer Success team on Slack. This allowed them to reach out for an upsell or an immediate contract expansion. The task stayed open until a contract amendment was signed.

Phase 3: Tracking Client Bundles & Multi-Project Accounts

The Challenge: Standard usage alerts were originally designed to monitor just one project at a time. However, some clients often bought a single big bundle of usage to spread across multiple separate projects. Because the software couldn’t combine the data from these different projects automatically at the time, there was no easy way to track their overall usage. This created a big blind spot where clients could go over their limits undetected.

To protect these contracts, I set up a simple manual tracking system:

• The Setup: The moment a multi-project client launched their first project, I bypassed the standard single-account alerts and set up a custom corporate tracking reminder inside the CRM.
• Combining the Data: Every month, I went into each active project tied to that client, pulled their individual usage numbers, and added them all together. Then, I logged that total unified balance directly into their master CRM account so the whole team could see the true picture.
• Smart Scheduling: To keep things efficient, I looked at how fast each client used their allowance. For fast-moving accounts, I did strict monthly checks. For slow-moving accounts, I spaced the checks out to every 90 days. This kept tracking incredibly accurate without wasting extra administrative time.

The Ultimate Win: Shifting from Manual to Automatic

Cleaning up the backlog and running this daily system completely protected company revenue and got the data into great shape, but the best part came next:

• Immediate Revenue Recovery: The initial audit caught substantial chunks of unbilled, over-limit usage, allowing the company to successfully back-invoice existing clients and bring that money in right away.
• The Roadmap for Automation: Because I took the time to do the manual cleanup and map out every single “if/then” scenario by hand, I was able to give the team a perfect blueprint so they knew exactly what to build to automate the process.
• Plugged the Revenue Leak: Established absolute accuracy across the entire client base, making it impossible for any account to quietly go over their contract terms or use unbillable data.

The Baseline: Fixing the Financial Disconnect

When this project began, the organization’s CRM records and QuickBooks transaction history were completely out of sync. This gap was creating some major operational blind spots: formal price quotes were getting lost between sales and accounting, unpaid invoices were sitting on the books with zero follow-up, and there was no centralized way to track annual payments for long-term contracts.

Taking ownership of the billing backlog was the first step to getting the records back to a clean slate. During this cleanup, a detailed audit uncovered forgotten, past-due invoices and unbilled project usage, which allowed the company to back-invoice active clients and immediately bring in lost revenue. From there, a new weekly and monthly routine was established, partnering directly with the Customer Success team to make sure every quote was tracked, every past-due invoice was followed up on, and long-term subscription revenue was protected.

Phase 1: The Weekly QuickBooks & Sales Pipeline Audit

To stop quotes and estimates from getting lost between sales and accounting, a quick weekly review routine was implemented to ensure the active sales pipeline matched actual financial numbers:

• The Review Process: Every Monday, the full list of QuickBooks estimates, invoices, and payments from the previous week was extracted and cross-referenced directly against CRM records and email threads.
• Fixing the Discrepancies: Missing or updated versions of financial documents were tracked down, accounts were manually moved to their correct sales stages, invoice numbers were updated, and total contract values were corrected in the CRM so the sales data was 100% accurate.
• Setting Up Safeguards: For newly paid customers, contract details were immediately audited and project limits were locked into tracking files before services even started. This gave the team a clear baseline to prevent future unbilled over-usage.

Phase 2: Fixing Invoicing Traps & Navigating the Multi-Year Subscriptions

The biggest revenue risk uncovered was in how unpaid invoices were managed, which were stalling out due to manual processes and tracking confusion.

Clients would often sign a multi-year contract but pay on an annual basis. Because the billing wasn’t automated, the business relied entirely on manual CRM reminders to trigger next year’s invoice. If a reminder was missed, the client didn’t get billed. On top of that, the books were cluttered because the exact same invoice format was being used for standard bills and temporary placeholders created for clients to submit for grant proposals

A new monthly review system was put in place to clean up the books and partner with Customer Success to keep revenue on track:

• Securing Recurring Revenue: Manual triggers for those long-term contracts were restructured into a proactive review process. This ensured upcoming annual invoices were generated and sent out exactly on time, completely removing the risk of a missed CRM reminder.
• The Invoicing Notes Matrix: On the 1st of every month, the unpaid invoices summary was exported into a master tracking sheet. A simple formula was built to automatically pull forward internal tracking notes from previous months, allowing the team to instantly separate active, past-due invoices from inactive “grant proposal” placeholders.
• Team Alignment & The Year-End Cleanup: All genuine past-due accounts were compiled into a unified monthly report and handed off to the Customer Success team for direct follow-up. To ensure each fiscal year started with an accurate cash flow forecast, a year-end cleanup process was implemented to verify grant statuses with clients, purging dead placeholder invoices from the system entirely.

The Ultimate Win: Creating a Reliable, Stress-Free Billing Routine

Cleaning up the financial backlog and establishing these routine checks delivered immediate stability to the business:

• Direct Revenue Recovery: The initial audit caught unbilled contract usage and forgotten, past-due invoices, allowing the company to back-invoice existing clients and successfully collect outstanding money.
• Clear Cash Flow Forecasting: By separating real past-due invoices from temporary grant placeholders, leadership received a completely accurate, clutter-free picture of what the business was actually owed.
• Cross-Functional Efficiency: By building a seamless bridge between QuickBooks data and the Customer Success team, a manual, easily missed billing cycle was transformed into a highly disciplined, team-wide monthly routine.

The Baseline: Centralizing the Deadlines

For businesses running multiple corporate entities or serving clients backed by federal funding, compliance is a high-stakes operational necessity. Missing a single state or federal deadline can lead to steep financial penalties, frozen business accounts, or a total loss of eligibility to work with key clients.

Taking ownership of the corporate compliance calendar across several entities was the main focus of this project. The system inherited was a scattered mix of moving state and federal deadlines, which needed to be brought together into an airtight, proactive tracking routine. By managing federal SAM.gov registrations, complex California franchise taxes, and biennial Statements of Information, the project achieved 100% compliance continuity with zero downtime or missed filings.

Phase 1: Federal Vendor Compliance

The Challenge: While the company itself did not directly apply for federal grants, its primary client base relied heavily on grant funding to pay for services. To remain an eligible vendor for these clients, the business was required to maintain active registration in the federal vendor portal. Because these federal registrations expire on a strict, rolling 12-month cycle based on the exact date of approval, any lapse would immediately freeze the clients’ ability to work with the business.

To keep these accounts active, a highly reliable tracking system was put in place:

• The Review Cycle: A strict verification routine was established to trigger exactly one month before expiration, allowing plenty of time to manage secure multi-factor authentication steps and update company records, tax setups, and vendor preferences.
• Airtight Tracking: Because approval dates can shift the expiration timeline slightly every year, a mandatory follow-up check was scheduled one week after submission. This ensured the newly calculated federal expiration date was logged instantly, dynamically updating the corporate calendar for the following year.

Phase 2: State Tax Deadlines & Multi-Entity Management

The Challenge: Managing state tax compliance across multiple corporate structures requires careful cash-flow planning. The California Franchise Tax Board (FTB) requires a flat minimum annual tax alongside a variable corporate fee that scales depending on gross revenue thresholds, meaning different entities carry completely different financial liabilities.

The process was restructured to remove guesswork and prevent last-minute rushes:

• Proactive Planning: Rather than relying on physical or digital mailers from the state (which are frequently delayed or lost), an internal operational alert was set up exactly 30 days before the major deadlines on April 15 and June 15.
• Multi-Entity Allocation: Payments were precisely executed for multiple distinct corporate structures via secure state web portals, ensuring the correct minimum franchise tax (Form 3522) and corporate fees (Form 3536) were paid accurately and matched to the correct Secretary of State identifiers.

Phase 3: Every-Other-Year Corporate Filings

The Challenge: California requires a Statement of Information filing with the SOS every odd-numbered year within a rigid five-month window. For a business managing multiple entities, tracking which years are active and coordinating executive signatures can easily lead to administrative bottlenecks.

To keep things moving seamlessly, a secure digital workflow was built:

• Handling the Signatures & Security: I took care of the online submissions for each separate business entity. To keep things moving quickly, I coordinated directly with leadership to get the necessary approvals, digital signatures, and routed everything smoothly through the state portals.
• Organizing the Paperwork: I made sure no document was ever left floating around. The second a filing went through, I saved the receipts and confirmation pages, sent them directly over to the bookkeeping system so the expenses matched up perfectly, and filed them away using a clean, easy-to-read naming system in the master files.

The Ultimate Win: Moving from Stressful to Turn-Key

Bringing these scattered financial and regulatory deadlines into a single, organized system delivered permanent risk reduction to the business:

• Protected Client Funding: Kept the company’s federal vendor status 100% active year-round, ensuring grant-funded clients experienced zero disruption or compliance blocks when doing business together.
• Zero Late Fees or Lapses: Maintained a perfect record of on-time state and federal filings, completely eliminating the risk of late penalties or entity suspensions.
• Predictable Financial Planning: By mapping out the exact annual minimum and variable corporate fee, leadership was able to accurately forecast and reserve expenses well ahead of deadlines.
• A Clean, Central System: By gathering all the company’s login credentials and past templates into one secure spot, a stressful, scattered scramble was transformed into a calm, turn-key routine.

The Baseline: The Event Packing Scramble

For corporate travel and major trade shows, keeping track of equipment and event gear can quickly turn into a logistics bottleneck. Without a centralized inventory system, teams frequently face last-minute scrambles, missing components, and expensive airline baggage fees from packing under pressure.

Having previously managed event coordination for the client, a major operational gap was identified: the team lacked a standardized blueprint for trade show booth inventory and airline weight restrictions.

Using a custom packing manifest equipped with exact component weights, I was brought in as an independent consultant to handle the entire pre-departure setup. Over the course of 10.5 hours of solo execution, I sorted and organized the physical inventory, caught missing gear before the team departed, and distributed components evenly across the travel cases to ensure every bag remained safely under the strict 50-pound airline limit.

The Operational Challenge

The client needed to transport a complex, multi-component trade show booth and technical gear suite across the country. However, the preparation method carried a few distinct risks:

• Strict Travel Constraints: All equipment had to be packed into standard suitcases and transported via commercial airlines. Every single bag needed to stay strictly under the 50-pound limit to avoid heavy airline fees and airport screening delays.
• Zero Inventory Visibility: There was no active list showing what gear was currently working, what was broken, or what pieces had been misplaced.
• A Tight Timeline: The project required a full audit, a search for missing parts, and the final pack-out to be completely finished within a rigid window before the travel team departed.

The Approach: The Weight-Tracking System

Because I don’t believe in reinventing the wheel under a deadline, I leveraged an asset I had previously designed: a comprehensive, master inventory checklist equipped with exact component weights.

• The System Inventory: Over the course of 10.5 hours and 3 days, the client’s entire physical inventory was sorted, organized, and packed. Every structural element, cable, and technical device was weighed and cross-referenced against the master checklist.
• Catching Missing Gear: Because the tracking sheet accounted for every single nut, bolt, and baseline tool required to build the booth on-site, missing or broken equipment was instantly flagged before the team left headquarters. This completely eliminated the need for expensive, stressful emergency runs to local stores during the convention.
• Balancing the Bags: Using the weight data from the sheet, the packing process was treated like a puzzle. Components were distributed across multiple travel cases, ensuring every single bag maximized its space while remaining safely under a 49-pound safety mark.
• The Return Roadmap: To ensure the team could easily get everything back home without any guesswork, I created clear re-packing manifests for each suitcase. This gave them a visual guide on exactly how to reload the cases at the end of the show so every bag stayed perfectly under weight for the return trip.

The Ultimate Win: A Repeatable Blueprint for Future Events

Rebuilding the packing process from the ground up delivered an organized, seamless travel experience for the team:

• The Ultimate Validation: The client recognized the value of the system so clearly that they specifically hired my external consulting business to manage the project, proving the true return on investment for this framework.
• 100% Weight Compliance: All transport cases arrived at the airport perfectly balanced and under the weight limits, completely eliminating unexpected airline overage fees and airport friction for the executive travel team.
• Calm, Turn-Key Execution: Turned a manual, time-consuming process into a systematic, 10.5-hour solo execution, leaving the client with an airtight blueprint and re-packing guides they can easily reuse for every future event.

The Baseline: Prioritizing Systems over Software Trends

Many businesses adopt software simply because it is trendy, which usually leads to messy configurations, wasted subscription fees, and tools they don’t actually know how to use. My operational philosophy is different: I believe in deeply understanding the manual mechanics and the way data flows through a tool before ever attempting to layer on complex automation.

When launching my virtual assistant and operations business, I acted as my own technical setup expert. I independently researched, learned, and rolled out a foundational digital tool stack spanning finance, web design, scheduling, and email marketing. By taking a deliberate, hands-on approach to configuring these platforms, I built an airtight business setup for myself and developed a repeatable framework for software deployment that I can now directly apply to my clients’ businesses.

The Ground-Up Infrastructure Setup

Instead of chasing overly complex or bloated software, I selected a lean suite of reliable tools and took the time to map out and run their core setups manually.

• Financial Tracking & Bookkeeping (Zoho Books): I set up and launched a cloud accounting system from scratch to track all business revenue and expenses. Instead of relying blindly on automated banking algorithms, I chose to manually categorize bank feeds, map invoice categories, and handle reconciliation loops. This hands-on process allowed me to deeply understand the platform’s transaction logic, ensuring total financial accuracy before scaling my business volume.
• Web Content & Layout (WordPress): I developed and launched a professional business website by configuring a custom template framework. The main focus was on clean information design, ensuring layout consistency, clear navigation, and straightforward pages where prospective clients can easily learn about my services.
• Calendar & Availability Mapping (TidyCal): I integrated a dedicated scheduling platform to manage client bookings. I manually structured meeting types, set intentional time buffers between appointments, and linked the platform to my core calendar. This established a simple, stress-free booking method that respects my working capacity and eliminates back-and-forth scheduling emails.
• Audience Building & Email Layouts (MailerLite): I implemented an email marketing platform to begin building an independent subscriber database. I learned the backend configuration of subscriber lists and designed clean, readable templates. By understanding how the data inputs work from the ground up, I ensured proper list sorting right from the start.
• Visual Identity & Asset Design (Canva): I established a cohesive visual style to support both my business website and digital media projects. I built a dedicated brand kit containing standardized typography, custom assets, and color palettes, applying these elements across uniform website graphics and promotional collateral to ensure a polished market presence.

The Ultimate Win: A Mastered Tech Stack

Taking the time to build this framework manually delivered a massive return on investment for my business infrastructure:

• Complete Tool Mastery: By refusing to take shortcuts during the setup phase, I gained a deep, hands-on understanding of each platform, allowing me to troubleshoot and optimize the software effortlessly.
• A Timeless Client Blueprint: The exact research, testing, and deployment workflows used for my own business now serve as a polished service blueprint I can use to save time and eliminate headaches for my clients.
• An Airtight Financial Foundation: Avoided the typical “launch chaos” by establishing crystal-clear bookkeeping habits and visual brand guidelines from day one, leaving the business completely organized and ready for growth.

The Baseline: Moving from Year-End Panic to a Smooth Monthly Routine

Operating with unverified or expired insurance certificates from third-party vendors exposes a business to massive financial and legal risks. A solo business owner was operating under a tough reactive model, waiting until the very end of the fiscal year to check vendor certificates, which resulted in a chaotic, stressful scramble to track down expired documents right in the middle of official financial audits.

The underlying issue was that the compliance paperwork was scattered across different local desktops, personal email threads, and disjointed cloud folders. I was brought in to get a handle on the data, organize the historical files into one central spot, and implement a predictable, monthly review routine to keep vendor paperwork up to date in real time.

The Cleanup & System Restructuring

Following a straightforward, hands-on approach to organizing the chaos, I executed a ground-up overhaul of the entire process:

• Gathering the Documents: Worked closely with the business owner to review email inboxes and digital files to find missing records. I then collected, reviewed, and organized every single historical vendor certificate in one place.
• A Clear Folder System: Built a standardized, intuitive folder layout within OneDrive, using clean naming rules so that active, up-to-date documents are instantly accessible and completely separated from old records.
• The Master Tracking Sheet: Created a dedicated tracking sheet from scratch, mapping out the exact details the business needed to see—including vendor names, coverage types, exact expiration dates, and direct links to the saved files.
• Proactive Outreach: Handled direct, friendly communications with out-of-compliance vendors to secure their updated insurance certificates, successfully closing all paperwork gaps well ahead of the formal audit.

The Ultimate Win: Total Compliance & A Scheduled Review Routine

To permanently eliminate the end-of-year bottleneck, I didn’t just hand over a spreadsheet and walk away. I designed and implemented a consistent monthly routine to manage the system ongoing.

On a steady monthly cycle, I audit the tracking sheet against upcoming dates. I proactively spot expiring certificates, confirm with the business owners which require renewal, and reach out directly to the vendors to request updates. This consistent routine ensures the business remains 100% compliant every single day of the year, transforming a high-stress annual crisis into a quiet, background routine that just works.

• Total Peace of Mind: Shifted the business owner away from a risky guessing game to a proactive setup, ensuring no vendor handles work on behalf of the company with expired insurance.
• Always Audit-Ready: Replaced a multi-week year-end scramble with a continuous, clean tracking system, making future audits completely stress-free.
• Reliable Maintenance: Proved that implementing a highly organized, consistent monthly routine is incredibly effective for business owners who prefer high-touch accuracy over complex, automated software.