13-Week Liquidity Commander - Google Sheet + Slides

Mismanaging short-term cash flow and lacking visibility into financial variance can quickly lead to insolvency. This system tracks your rolling 13-week cash flow, logs actual spending to calculate variance, and automatically generates an executive slide deck so you can present clear data to stakeholders. This spreadsheet is designed to be used in Google Sheets.


The Operational Friction

Relying on scattered, manual spreadsheets to track short-term cash flow often causes critical miscalculations. When business owners override complex waterfall formulas or fail to compare their initial forecasts against actual cleared bank data, they lose sight of their true survival runway. Furthermore, manually copying data from a spreadsheet into a presentation deck introduces formatting errors and wastes hours of executive time.


The Mathematical & Structural Solution

This terminal delivers a uniform, protected interface that calculates your rolling 13-week cash balance and actual variance safely. The underlying calculation framework is completely locked, preventing accidental formula deletion while instantly updating your dashboard metrics based on simple weekly inputs. A built-in export tool then transforms your dashboard into a formatted slide deck. To ensure immediate deployment, your purchase includes two supplementary documents:

• The Operational User Guide: Provides step-by-step instructions so the user can deploy the tool immediately without staring at a confusing blank screen.
  
• The Technical Spec Sheet: Fully exposes the background formulas, math, and logical architecture so the user has absolute trust in the calculations and knows exactly what is happening under the hood.
  

• Dynamic Scenario Selector: Switch instantly between Base, Downside, and Upside data to evaluate different financial projections.
  
• Three Scenario Ledgers: Log your expected inflows, operating expenses, payroll, and debt service for each scenario across a 13-week timeline.
  
• Actuals Variance Tracker: Enter cleared bank data into the Actuals ledger to automatically calculate the dollar variance against your original forecast.
  
• Visual Runway Dashboard: Review dynamic line charts, burn vs. recovery metrics, and a locked cash flow summary table.
  
• Instant Slide Deck Generator: Click a single button in the custom menu to automatically compile your dashboard data and charts into a formatted Google Slides presentation.
  

• Included Assets: 1 Native Google Sheets Template, 1 Step-by-Step User Guide, 1 Technical Spec Sheet.
  
• Format: Native Google Sheets Template
  
• Prerequisites: A free Google Workspace or Gmail account (Not compatible with Microsoft Excel)
  
• Time to Deploy: Under 15 minutes (Input your parameters into the yellow cells; calculations run automatically)