Maverick — Finance & CRM Dashboard

YTD Revenue (Paid)

—

Mar – now · confirmed

This Month's Expenses

—

Budgeted · incl. salaries

Retainer Base

—

per month

Monthly Shortfall

—

builds needed to break even

Outstanding Invoices

—

invoiced but not yet collected

Runway (excl. builds)

—

projected balance / net burn

Income vs Expenses // FY2026

Revenue // By Type

Cash Balance Trend // Projected

Expense Breakdown

Retainer Coverage

—

this month · budgeted

0%—100%

Active Retainers

Pipeline Snapshot

Active projects —

Total project value —

Received to date —

Project outstanding —

CRM leads (active) —

Proposals sent —

Monthly Income Detail

Confirmed Paid Income by Month // Loading…

Income by Client // YTD Top 10

Loading…

Invoice Register // Sage invoices synced from CSV • Oct 2025 – present

All Invoices

0 invoices selected

	Invoice #	Client	Assignment	Type	Date	Due	Amount	Paid	Outstanding	Status
Loading…

Payment Schedule // pulled live from Clients & Builds

All Client Payments // Schedule by Month

Retainer amounts come from the Retainers tab module stacks. Project rows show milestone-based expected payments. Manual rows are freeform entries. Click any client name to open their profile.

Expenses

Monthly Fixed Expenses // loading…

Item	Category	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Annual

Click any month cell to override the amount for that specific month. Pink = overridden. Current month is highlighted.

Salaries & People Costs

Cashflow Forecast // rolling 6-month projection

Projected Cashflow // retainers + build milestones vs fixed costs

Loading…

Bank Ledger // FNB inContact Feed

0 rows selected

	Date	Merchant / Description	Client	Reference	Category	Subcategory	Amount	Balance	Status

Active Clients

—

on retainer or builds

Monthly Retainer

—

confirmed active

Paused

—

retainer on hold

Churned

—

no longer active

Total Clients

—

all time

Client Register

Client	Contact	Services	Type	Status	Retainer	Start Date	Team

Total Leads

—

all time in system

Active Pipeline

—

excl. won, lost & archived

Proposals Out

—

awaiting response

Won (all time)

—

of proposals → won

Lead Pipeline // By Stage

Leads by Source // Where They Come From

Recent Leads

Lead Register // CRM

0 leads selected

	Name / Company	Email	Interests	Source	Status	Date	Next Action

Total Project Value

—

active projects

Received

—

of total value

Outstanding

—

remaining

Starts This Month

—

commencement due

Project Register // Active Projects

Client	Project	Value	Paid	Outstanding	Phase	Start	Timeline	Status	Risk

Payment Milestones // Upcoming

Project Revenue // Received vs Outstanding

Completed Projects // All time

Client	Project	Total Value	Received	Outstanding	Start Date

Project Type

Project Info

Client

Status

Project Name

Spec / Brief File (Google Drive link)

Current Phase

Financials & Timeline

Total Project Value (R)

Paid to Date (R) auto from milestones

Payment Terms

Project Timeline (weeks)

Start Date

Commencement Date (actual kick-off)

Payment Schedule

Notes

Retainer Income

Monthly Retainer Revenue

current month

Fixed Retainers

consistent monthly

Variable Retainers

month-by-month

Annual Projected

based on current rates

Retainer Schedule // Monthly by Client

Builds & Ad-Hoc

Active Projects

in progress

Total Pipeline Value

active projects

Received

of pipeline

Outstanding

yet to be received

Project Payment Schedule // Builds & Ad-Hoc

Good morning, Melissa

Loading your daily briefing…

LEADS TO ACTION —

Loading…

OVERDUE INVOICES —

Loading…

COMING UP

Loading…

Data Architecture

How Data Flows Into This Dashboard

FNBinContact Emails

→

Gmaillabel: ops/fnb_alerts

→

Apps ScriptFNB_Parser.gs

→

Google SheetsFNB Bank Feed → Ledger

→

Supabasezpyahgaywnkwuvnoelaz

→

DashboardThis file

GmailShopify / Webflow leads

→

Apps ScriptCRM_Parser.gs

→

Google SheetsCRM / Leads / Raw

→

SupabaseCRM table

→

DashboardCRM tab

Supabase Tables

Table	Source	Status
ledger	FNB Email → Sheets → Sync	Live
crm_leads	Gmail → Sheets → Sync	Live
settings	Apps Script operational	Live

Google Sheets Structure

Sheet	Purpose
FNB Bank Feed	Raw FNB inContact email transactions
Ledger	Categorised + enriched transactions
Rules	Auto-categorisation rules engine
Categories	Category master list
CRM	All leads — pipeline status tracked
Settings	Supabase URL, sync timestamps
System Log	Import + sync activity log

Supabase Integration Code

// Maverick Dashboard — Supabase config
// Project: https://zpyahgaywnkwuvnoelaz.supabase.co
// Anon key is read-only — safe to embed here for the dashboard

const SUPABASE_URL = 'https://zpyahgaywnkwuvnoelaz.supabase.co'
const SUPABASE_ANON_KEY = 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZSIsInJlZiI6InpweWFoZ2F5d25rd3V2bm9lbGF6Iiwicm9sZSI6ImFub24iLCJpYXQiOjE3ODU3Nzk1ODQsImV4cCI6MjEwMTM1NTU4NH0.apL5-Ve1FVq84cfpOU0j2ALe4XAaTIXSOoGeLdFm8bY'

// Fetch ledger transactions
async function fetchLedger(month) {
  const { data, error } = await supabase
    .from('ledger')
    .select('*')
    .gte('txn_date', month.start)
    .lte('txn_date', month.end)
    .order('txn_date', { ascending: false })
  return data
}

// Apps Script writes to Supabase using the service_role key (stored in Script Properties — never in code)
// This dashboard reads using the anon key above — read-only, safe for Netlify

Active Team

—

team members

Total Monthly CTC

—

combined payroll

Leave Balance

—

total days remaining (all staff)

Leave Requests

Staff Member	Type	Dates	Days	Submitted	Status
Loading leave requests…

Team Members

Loading team…

Settings