Zmana — Billing Health

Monthly Revenue

?

Total monthly recurring revenue from all 1,041 active accounts. Source: Master Monthly spreadsheet (updated weekly). Does not include one-time installation revenue.

$63,254

1,041 active accounts

Monthly Cost

?

Direct platform costs — Alarm.com and ADC licensing fees per account. Does not include labor, overhead, or G&A. Verify against your Alarm.com billing statement monthly.

$19,020

Platform + ADC fees

Monthly Profit

?

Revenue minus direct platform costs only. True net profit will be lower once payroll, rent, and other overhead are factored in. Use this as a gross margin indicator.

$44,077

69.7% margin

Commercial

?

Commercial accounts typically have higher monthly rates and more complex equipment. Flag any commercial account showing under $100/month for review — may indicate a billing error or outdated rate.

176

865 residential

#	Customer	Platform	Type	Revenue	Cost	Profit	Margin	Billing ? Select the billing method for each account. This saves to your browser so your team can track it during review sessions. Monthly — auto-charged each month Quarterly — billed every 3 months ACH — bank draft on file Check — customer mails check DRH Pays — DR Horton pays directly, not homeowner	Status ? Use this during your weekly review to flag accounts that need action. Needs Review — something looks off, needs a second look Follow Up — waiting on customer or team response Escalate — bring to management immediately All changes save automatically in your browser.	Notes ? Type any notes about this account — payment issues, customer calls, special instructions. Saves automatically in your browser. Notes persist between sessions on the same device.

Total Open Issues

?

Count of accounts flagged across all issue categories. Each issue is actionable — someone on the team should review and resolve it. Issues disappear when the underlying data is fixed in the Master Monthly spreadsheet.

—

Across all categories below

Special Billing — Action Before 1st

?

What to do: Before the 1st of each month, go through every account on this list and confirm payment was received or is on the way. These accounts do NOT auto-bill — if you don't manually check, you may miss collecting. Common types: quarterly checks through Hawaiiana, ACH on a specific date, or one-off arrangements.

22

Don't auto-bill — manual check required

Cancellations Missing Reason

?

What to do: Go to the PRINT tab in the Master Monthly spreadsheet and fill in the Reason column for each of these accounts. Options: Moved, Sold Home, Unhappy with Service, Pricing, Other. This data tells you whether cancellations are within your control or not — without it you're flying blind.

—

Need reason logged in PRINT tab

Total Cancellations

?

All accounts that cancelled service since 2019. Source: PRINT tab in the Master Monthly spreadsheet. This list is maintained manually — if you see a cancellation missing, add it to the PRINT tab and it will appear here on the next data refresh.

239

Since 2019 · tracked in PRINT tab

Missing Reason

?

Cancellations with no reason recorded. Action: Find each of these in the PRINT tab of the Master Monthly spreadsheet and fill in the Reason column. This matters — "Unhappy" cancellations are preventable, "Sold Home" are not. Without reasons, you can't tell the difference.

—

Need reason in PRINT tab

With Reason

?

Cancellations where a reason was recorded. Common: Moved, Sold Home, Unhappy with service. Use the filter buttons below to see breakdown by reason.

—

Reason documented

#	Customer	Monthly Rate	Start Date	Last Invoice	Reason ? Why the customer cancelled. If blank, go to the PRINT tab in Master Monthly and fill it in. Preventable: Unhappy, Pricing. Not preventable: Moved, Sold Home.	Notes

Checking Balance

?

Current checking account balance as of Nov 11, 2026. Does not include savings ($41,006). Update this number weekly by checking your bank directly.

$105,479

+ $41,506 savings

Expected In (30 days)

?

Estimated cash coming in over the next 30 days — includes final installation payments, DR Horton lien releases, and MMR billing. These are estimates; actual amounts may vary.

$283,646

Installations + MMR

Expected Out (30 days)

?

Estimated cash going out — payroll, rent, credit card statements, loan payments. Watch the CapitalOne ($48,936) and Alaskan card ($64,000) statements — those are the biggest single outflows.

$241,045

Payroll, rent, cards

Projected End Balance

?

Checking balance after all expected inflows and outflows. This is a projection — actual result depends on timing of payments and collections. If this drops below $50K, flag for review.

$148,080

Checking only · projected

Date	Name	Description	Amount	Running Balance

Avg Profit Margin

?

Average margin across all billed jobs (Jul 1–Oct 2026). Calculated as (QB Income − QB Cost) ÷ QB Income. Target: 35%+. Jobs under 20% margin need a post-mortem to understand why costs ran high.

—

Total Profit Jul–Oct

?

Total profit from installation jobs started July 1, 2026 or later. Source: QuickBooks Projects export. Reconciled against Salesforce — jobs without a Salesforce match are flagged.

—

Over Budget

?

Jobs where QB billed amount is less than the Salesforce quoted amount. This means we either left money on the table or costs ran over the original quote.

Action: Review each flagged job with the project lead. Determine if additional billing is possible or if the variance needs to be explained.

—

Review with project lead

Unbilled Jobs

?

Jobs with costs logged in QuickBooks but $0 billed to customer. These represent work completed but not yet invoiced.

Action: Check with the install team — confirm the job is actually complete, then issue the final invoice immediately.

—

Costs logged, not invoiced

✅ QuickBooks jobs started July 1, 2026+ · reconciled against Salesforce

#	Customer	QB Job	SF Quote ? Amount quoted in Salesforce. If blank, no matching Salesforce opportunity was found — check if the job was logged under a different name.	QB Billed ? Amount actually invoiced in QuickBooks. Compare to SF Quote — a large gap means either under-billing or scope change. $0 means the job is unbilled.	Cost	Margin	Variance ? Difference between SF quote and QB billed. Red = we billed less than quoted. Green = on budget or over. Investigate any variance over $1,000.	SF Stage	Status