HVAC Client Support Portal

HVAC Dashboard Mastery Guide

Welcome to your Key Forecasts HVAC Executive Dashboard. This platform transforms raw bookkeeping and dispatch data into actionable, fractional CFO insights for HVAC businesses.

Executive Preview

Visualize Your Financial Health

Explore the robust, fractional CFO tools elite contractors rely on to dominate the Los Angeles HVAC market. Click any dashboard module below to expand and see the level of financial clarity we provide.

Zoom

Part 1: Security & Setup

256-Bit Encrypted

Bank-Grade Security

Your portal is strictly protected. All financial data is fully encrypted both in transit (SSL/TLS) and at rest, ensuring your sensitive business intelligence remains confidential.

Navigate to dashboard.keyforecasts.com.

Enter your assigned credentials to access your private portal.

Forgot Your Password?

Click the reset link on the login page to receive a secure, 1-hour expiring token via email.

Updating Your Company Profile

Before generating any reports, ensure your company information is accurate. This data is merged directly into your automated PDF summaries.

Click the 👤 Profile button in the navigation bar.

Update your Company Name, Primary Email, Phone, and Address.

Click Save Profile Updates.

Dynamic Goal Setting & Pacing

Your dashboard features a live Goal Pacing Tracker. Because your goals change every year, you can set independent targets for each operating year.

Click 👤 Profile in your top navigation.

Select the Target Year from the dropdown (e.g., 2025).

Enter your Annual Revenue and Net Profit goals, then click Save.

How Pacing Works:

Monthly View: Divides your annual goal by 12.
Annual View: Tracks full-year actuals against your full-year goal.
All-Time View: Goal tracker is hidden (comparing multi-year actuals to a 1-year goal is inaccurate).

Part 2: Uploading Your Data

Upload two simple CSV files each month: your Financial Report (from QuickBooks/Xero) and your Operational Report (from ServiceTitan/Housecall Pro).

1
Click the blue Upload button in the top navigation.
2
Select the Report Date: Type the year and month (e.g., 2026-03).
3
Attach Financial Report: Select your Profit & Loss CSV.

4
Attach Operational Report: Select your KPI CSV.
5
Click Upload Data.

CRITICAL NOTE: Always upload individual months (Jan, Feb, Mar). The dashboard will automatically calculate your annual totals. Never upload a 12-month “Full Year” CSV.

Mapping Accounts

If the system detects a new bookkeeping account, it will automatically pause and ask you to categorize it.

You will be redirected to the Map Accounts screen.
Next to each unmapped account, select the Master Category (e.g., Vehicle/Fleet Expenses).
Click Save All Mappings.

Data Management

Auto-Overwrite: If you uploaded a draft P&L, simply re-upload the correct file. It will safely overwrite.
Delete a Month: Open the ⚙️ Customize panel, scroll to the bottom, select the month, and click Delete.

Part 3: Navigating & Trends

Time Travel (Period Selection)

Use the dropdown menu in the top-left corner to filter your view:

Monthly View (e.g., 2026-03) Shows performance strictly for that selected operating month.

Annual Roll-Up (e.g., 2026 Full Year) Automatically adds up all monthly files uploaded for that year to give you a massive, year-to-date overview.

Period-over-Period Trends

When you select a specific month, you will see ↑ Green and ↓ Red arrows next to your numbers. The system automatically fetches the previous period and calculates your growth. Green always means “Good” (even if the number went down, such as your Callback Rate dropping).

Using the Interactive ROI Sandbox

At the bottom of your dashboard is a powerful simulator. Use the sliders to test how small operational changes compound into massive cash flow gains.

Lever 1: Complete More Jobs See the impact of dispatching just 10 more calls per month.

Lever 2: Raise Avg Ticket See how adding a $250 IAQ product to your average ticket explodes net profit.

Lever 3: Improve Gross Margin Simulate the cash impact of cutting material waste by 3%.

Lever 4: Add Fixed OpEx Test if you can afford to hire a new dispatcher or buy a new truck.

Part 4: CFO Report Breakdown

The dashboard is broken down into critical tiers. Here is exactly how they are calculated, what the industry benchmarks are, and how to fix unfavorable numbers.

Tier 1: Profitability

Gross Margin (%)

Formula: (Total Revenue – COGS) / Total Revenue

Benchmark: 45% – 55%

Action: If below 40%, you have a pricing or waste issue. Raise prices, renegotiate materials, or audit technicians for unbilled materials.

Net Profit (%)

Formula: (Total Revenue – COGS – OpEx) / Total Revenue

Benchmark: 15%+ (Industry avg: 5-10%)

Action: If Gross is healthy but Net is low, overhead is too high. Audit fixed costs (software, payroll, rent).

Free Cash Flow ($)

Formula: Net Profit – Accounts Receivable

Meaning: True cash generated to buy trucks or take draws. If negative while Net is positive, tighten collection terms.

Tier 2: Financial Health

Cash on Hand ($)

Formula: Total liquid bank balances

Benchmark: Maintain enough cash to cover 1 to 2 months of Operating Expenses to survive shoulder seasons.

Debt-to-Income (DTI) (%)

Formula: (Short-Term Liabilities + Credit Cards) / Total Revenue

Benchmark: Under 30%

Action: If this turns red, too much future revenue is spoken for by creditors. Pause capital expenditures.

Tier 3: Operations

Average Ticket ($)

Benchmark: $800+ (blended)

Train techs to present options (Good/Better/Best) and offer IAQ add-ons.

First-Time Fix Rate (%)

Benchmark: 85% – 90%

If below 75%, audit truck stock and dispatching accuracy.

Callback Rate (%)

Benchmark: Under 5%

Callbacks kill profit. Review processes for rushing or lack of diagnostic skills.

Utilization Rate (%)

Benchmark: 75% – 85%

If below 60%, you are paying for excessive windshield time or shop standing.

Tier 4: Sales & Marketing

Close Rate (%)

Benchmark: 60%+ Service / 40%+ Replacements

Ensure comfort advisors are offering monthly payment plans on every quote.

Customer Acq. Cost (CAC)

Benchmark: Under $250

If this spikes, ad spend is inefficient or CSRs are failing to book leads.

Tech Generated Leads

Meaning: Replacement leads generated by techs. Implement a spiff program to reward handoffs.

Part 5: 6-Month Growth Forecast

At the bottom of your dashboard is a predictive modeling chart. It takes your most recently completed month of revenue and compounds it forward.

1. Open the ⚙️ Customize panel and locate the Forecast Scenario dropdown.
2. Toggle between targets, from a realistic Steady (2% MoM) to an Aggressive Ramp (5% MoM).

CFO Advice:

Use this chart to accurately time your capital expenditures. Don’t guess when you can afford to finance a new van; use the forecast to see exactly which month your revenue will naturally support the payment.

Part 6: Exports & Troubleshooting

Instantly package your dashboard into a clean, branded PDF to share with your leadership team, CPA, or bank.

Click the green 📩 Email Report button in the navigation bar.
Select the specific period you want to report on (e.g., March 2026 or 2025 Full Year).
Confirm or type the email address you want the report sent to.
Click Send Report.
Look for a green success banner at the top of your screen. The PDF will arrive in seconds.

CFO Excel Export

Need to manipulate the raw data or add your own notes? Click the Export Excel button to download a formatted worksheet containing your actuals and targets.

Troubleshooting & Errors

If you encounter an error (such as a failed upload, a charting bug, or an incorrect calculation), please follow these steps:

Log in to your Dashboard.
Look for the Comment / Help Box widget inside the portal.
Submit a detailed description of the error (include the month/year you were trying to view).
Our engineering team will receive the ticket instantly and resolve it.

* For security and tracking purposes, all technical support must go through the internal portal comment box.

Frequently Asked Questions

Quick answers to help you master your Key Forecasts dashboard.

How much does it cost and what is included?

The executive dashboard is $199 per month. This flat fee includes custom data mapping, active monthly monitoring, and automated fractional CFO findings and recommendations. There are no long-term contracts, and you can cancel at any time.

How are payments and subscriptions managed?

All payments are securely processed through Stripe, which accepts all major credit cards. You maintain complete control over your billing information, subscription status, and cancellations directly through your secure Stripe billing portal.

What happens to my data if my subscription is unpaid?

If a subscription payment fails or is canceled, the ability to upload new data is immediately restricted. However, you will maintain read-only access to your existing historical data and reports for 90 days before the data is permanently purged from our servers.

Can your team access my password or my uploaded files?

No. We do not have access to customer passwords; if you lose access, you must use the “Forgot Password” link to securely reset it yourself. Furthermore, we cannot view your raw uploaded files. Your uploads are fully encrypted and are strictly parsed to be read visually on your private client portal.

How secure is my financial data on the dashboard?

Your portal is secured with 256-bit encryption. All financial data is encrypted both in transit (SSL/TLS) and at rest to ensure bank-grade security for your business.

Do I need to upload a full-year report?

No. You should only upload individual monthly reports (e.g., Jan, Feb, Mar). The dashboard’s database automatically aggregates your monthly files to build your annual roll-up view.

What happens if I accidentally upload the wrong file?

The system is designed with Auto-Overwrite. Simply re-upload the correct file for that exact same month, and the system will safely replace the old data without duplicating numbers.

How often should I upload my reports?

We recommend uploading your data exactly once a month, immediately after your bookkeeper reconciles and closes the previous month’s books.

How is the 6-Month Growth Forecast calculated?

The forecasting engine identifies your most recently completed month of actual top-line revenue and compounds it forward up to 6 months using the specific Month-over-Month (MoM) growth target you select in your settings.

What if my QuickBooks chart of accounts uses different names?

The dashboard uses a custom mapping tool. The first time you upload a file with unique account names, you will be prompted to map them to our standardized Master Categories. The system remembers these rules forever.

Where do the industry benchmarks come from?

Our benchmarks are established by fractional CFOs who specialize in the trades, analyzing aggregated, elite-performing HVAC contractors nationwide.

How do I generate a PDF report for my CPA?

Simply select your desired time period, click the “Email Report” button in your top navigation bar, type in your CPA’s email address, and hit send. The dashboard handles the rest.

Can I change the email address where reports are automatically sent?

Yes. When you click “Email Report,” the system will prompt you with a box where you can manually type or override the email address just for that specific send.

What operational software do I need to use this dashboard?

The dashboard accepts standard CSV exports, meaning it is compatible with ServiceTitan, Housecall Pro, FieldEdge, or any other dispatch software that allows you to export your KPIs to a spreadsheet.

Need Strategic Help?

If you run into any formatting issues or need strategic advice on what your numbers are telling you, the Key Forecasts team is here to support your growth.

Contact Our Team 213-444-2224