Flow IQ – Founder Console

Authenticate

Active Orgs

–

New Signups (30d)

–

MRR (cash)

–

Churn (30d)

–

Revenue – 12 Month View

Loading…

Module Usage (30d)

Loading…

User Engagement

Loading…

Feature Adoption

Loading…

Organization Health

Loading…

Error Analytics (7d)

Loading…

Total Organizations

–

⚠️ Needs Attention

Click to filter

On Trial

–

Active Paid

–

Trial Expired

–

Total MRR

Click for revenue details

All Organizations

Loading organizations...

Support Issues / Bug Reports

Only unresolved Only repeated From To

Select all on page 0 selected

Bulk Mark Closed updates issue status in database. Clear Checked (UI Only) only resets the current checkbox selection.

Select	ID	Org	Module	Source	Severity	Status	Pipeline	Occurrences	Last Seen	Environment	Summary
Loading bug reports…

0 results

Issue Detail

Select a bug from the list.

Status

Assigned To

Internal Notes

No issue selected.

Infrastructure covers database, cron jobs, edge functions and performance checks.

Database Errors (24h)

–

Failed Cron Jobs (24h)

–

Performance Issues (24h)

–

System Health

–

System Health Trend (7 Days)

Error Distribution

Database Performance (24h)

Cron Job Success Rate

Recent Database Errors

Loading active errors...

Cron Job Status

Loading cron job status...

Edge Function Status

Loading Edge Function status...

Performance Issues

Loading performance issues...

Error Resolution

System Monitoring Tools

Application errors focus on front-end/runtime failures and impacted users.

App Errors (24h)

–

JavaScript Errors (24h)

–

React Errors (24h)

–

Error Rate

–

Error Trend (7 Days)

Error Types Distribution

Module Error Breakdown

User Impact Analysis

Recent Application Errors

Loading active application errors...

Error Analytics

Loading error analytics...

Recent Error Logs

Loading…

Error Management Tools

Xero Organization Comparison

Compare data between two Xero organizations for QBlue vs FlowIQ cross-analysis.

ORGANIZATION 1 (QBlue/Old System)

ORGANIZATION 2 (FlowIQ/New System)

DATE RANGE

🚀 Copy Xero Organization

Automatically copy all settings, accounts, contacts, products, and tax rates from Org 1 to Org 2.

SOURCE (FlowIQ Org ID - QBlue)

TARGET (FlowIQ Org ID - New Org)

💰 Affiliate Fee Management

Manage affiliates, assign orgs to affiliates, run monthly commissions from billingiq_invoices, export CSV for payout.

Affiliates

Name	Email	Commission %	Status	Bank

Deep database telemetry, query hotspots, index health and connection diagnostics.

Cache Hit Rate

Checking...

Total Queries

Last 24h

Database Size

Total usage

Active Connections

Right now

📊 Cache Hit Rate Trend

💾 Top 10 Tables by Size

⚡ Most Frequently Called Queries (Top 10)

Query	Calls	Avg Time	Total Time	Role
Loading...

🐌 Slowest Queries (Outliers - Top 10)

Query	Max Time	Mean Time	Calls
Loading...

💾 Largest Tables (Top 10)

🔍 Index Health

🔒 Blocking Queries

🔌 Active Connections

Provider-level Supabase database host metrics from the Metrics API. Refresh cadence is one minute.

CPU Used

Ideal <60% · watch 60-75% · action >75%

Memory Used

Ideal <70% · watch 70-80% · action >80%

Disk Used

Ideal <70% · watch 70-80% · action >80%

Connection Capacity

Ideal <50% · watch 50-70% · action >70%

1m Load

Ideal <1 · watch 1-2 · action >2 sustained

Current DB Connections

Healthy when waiting clients stay at 0.

Parsed Metric Series

Expected diagnostic coverage: 1,000+ series.

Latest Provider Scrape

Not loaded

Resource Usage Trend

Memory, disk and connection capacity from stored provider snapshots.

Load & Connection Trend

1m load and current database connections from the latest 24 hours.

Operating Thresholds

Recommended Actions

Provider Warnings

Scrape Details

Metric Families Sample

First 40 family names returned by the Supabase Metrics API. Full raw metrics stay server-side.

📥 FlowIQ Smart Data Importer

Import historical data from QBlue + Xero into Biomek

✅ Database Ready

✅ 15,000+ Records Available

⚙️ Import Configuration

Select the FlowIQ organization to import data TO, and the Xero organization to pull data FROM.

FlowIQ Organization (Import TO)

Xero Organization (Pull Data FROM)

🛠️ Admin API Import Lane

Use this lane for guided migration imports from package APIs or API JSON payloads. Pick the package, set date range, run a dry check first, then import live and review the verification report.

Step 1 · Choose source package and dates

Package

Import Mode

From Date

To Date

Step 2 · Client intake checklist

QuickBooks path: ask for one admin approval login, correct company name, import date range, invoice/bill/payment scope, and whether PDFs are needed later as attachments.

Select a provider to load intake requirements.

Step 3 · Paste API JSON payload

Grade 8 guide: paste one JSON object with arrays like invoices, bills, and optional historical_sales. For QuickBooks or Pastel API pulls, paste the API response JSON here.

Tip: Choose a package first, then click Load Example JSON to see the expected shape.

Step 5 · Validate, dry-run, then live import

Dry run only (recommended first) Refresh ForecastIQ trends after import

Ready. Select org + package, then run a dry check first.

Progress Grade 1

Select package + mode to load the guided steps.

Checklist will appear here.

Next action: choose package + mode.

📁 Select QBlue Data Files

Select the folder containing your QBlue CSV files. The importer will read all CSV files and merge missing data from Xero.

🚀 Quick Start Import

Data Sources:

✅ QBlue Files: 0 files selected (Excel .xlsx preferred, CSV also supported)
✅ Xero API: Will fetch missing invoice line items automatically
✅ raw_files Stock Snapshots: 43 days (1,331 SKUs/day)

🔄 Hybrid Mode: QBlue headers + Xero line items = Complete invoices

✅ Document Verification Tool

Verify invoices, credit notes, purchase orders, and debit notes against comprehensive checklist

🔍 Enter Document Number

Enter document number (Invoice: INV-XXXX, PF-XXXX, QU-XXXX | Credit Note: CN-XXXX | Purchase Order: PO-XXXX | Debit Note: DN-XXXX) to verify all dependencies and data integrity.

🏢 Organization (Optional - leave blank to search all orgs)

Founder Console

Organization Details

Active Organizations

Error Details

Resolution

All Errors

Founder Console

💰 Revenue Dashboard

Organization Details

Active Organizations

Error Details

Resolution

All Errors