Financial Overview & True Profit

Live calculations matching booking_financials, booking_profit_loaded, and monthly_report.

Monthly Revenue vs. Direct Costs & Overheads (PKR)

Excludes inquiries and cancelled bookings

Monthly Net Profit (`monthly_report`)

Wedding profit minus office rent, utilities & gear

Target Scale: 4–5 weddings/mo

Per-Wedding True Profit Breakdown (`booking_profit_loaded`)

Direct profit after crew/editing/album costs vs. fully loaded profit after monthly overhead share

Wedding / Client	Status & Month	Invoiced Net (PKR)	Received / Balance	Direct Cost (PKR)	Direct Profit	Overhead Share	Loaded Net Profit	Action

Bookings Pipeline & Coverage Planner

Manage multi-day wedding events, crew & equipment assignments, timelines, and post-production milestones.

Client Invoices, Installments & Receipts

Generate client-facing package invoices and log Bank, EasyPaisa, JazzCash, or Cash payments.

Direct Wedding Costs & Studio Overheads

Track per-event crew, per-cam editing, album printing, drone, travel, taxes, and monthly studio bills.

Direct Wedding Costs (`booking_costs`)

Photographer/videographer payouts, editing per cam, album printing, drone & travel

Add Direct Cost Line

Wedding Booking

Monthly Studio Overheads (`overhead_expenses`)

Office rent, electricity/utility bills, equipment purchases & software

Add Studio Overhead Expense

Date

Crew & Freelancer Roster (`crew`)

Matching email links crew members automatically to their login schedule

Client Wedding Packages (`packages`)

Standard packages for quick booking & invoice creation

Internal Cost Presets (`rate_presets`)

Standard base costs per event, per cam video edit, or per 10 album pages

Studio Branding & Invoice Settings (`settings`)

Appears on client-facing invoices and payment receipts

Business Name

Phone / WhatsApp

Studio Email

Studio Address

Invoice Prefix

Default Tax Rate (%)

Bank / EasyPaisa / JazzCash Details (Printed on Invoices)

Invoice Terms & Conditions

Live Supabase Configuration

Pre-Configured

SUPABASE_URL

https://qawdauzlmrqzndvevzyu.supabase.co

SUPABASE_PUBLISHABLE_KEY

sb_publishable_IzFfL9_SsEos_VVsOSiDpg_TlydsgPi

Quick Checklist for Supabase & Vercel

In Supabase, open SQL Editor → New Query, paste 01_schema.sql, and click Run.
Go to Authentication → Users → Add User and create your owner email & password.
Run this SQL snippet in the SQL Editor (replace with your email) to unlock Owner RLS permissions:

update profiles set role = 'owner' where id = (select id from auth.users where email = 'you@example.com');

Shareable Client Inquiry Link (Once Live on Vercel):

https://app.ahmadfayyaz.com/?view=inquiry

When clients open ?view=inquiry, the Owner/Crew navigation bar is automatically hidden so they only see your AF Studio inquiry form.

How to Connect app.ahmadfayyaz.com:

1. Upload index.html and vercel.json from the deployment zip to a new GitHub repository.

2. In Vercel → Add New → Project, import your GitHub repository and click Deploy.

3. Go to Vercel Project → Settings → Domains, type app.ahmadfayyaz.com, and click Add.

4. In your domain DNS / WordPress hosting cPanel (Zone Editor for ahmadfayyaz.com), add a CNAME record: Name/Host: app → Target/Value: cname.vercel-dns.com.

Financial Overview & True Profit

Monthly Revenue vs. Direct Costs & Overheads (PKR)

Monthly Net Profit (`monthly_report`)

Per-Wedding True Profit Breakdown (`booking_profit_loaded`)

Bookings Pipeline & Coverage Planner

Client Invoices, Installments & Receipts

Direct Wedding Costs & Studio Overheads

Direct Wedding Costs (`booking_costs`)

Monthly Studio Overheads (`overhead_expenses`)

Crew & Freelancer Roster (`crew`)

Client Wedding Packages (`packages`)

Internal Cost Presets (`rate_presets`)

Studio Branding & Invoice Settings (`settings`)

Live Supabase Configuration

Quick Checklist for Supabase & Vercel

My Assigned Wedding Shoot Schedule (`crew_schedule`)

AF Studio

Create New Wedding Booking

Record Client Payment (`payments`)

Supabase Live Auth & Database Sync

Financial Overview & True Profit

Monthly Revenue vs. Direct Costs & Overheads (PKR)

Monthly Net Profit (monthly_report)

Per-Wedding True Profit Breakdown (booking_profit_loaded)

Bookings Pipeline & Coverage Planner

Client Invoices, Installments & Receipts

Direct Wedding Costs & Studio Overheads

Direct Wedding Costs (booking_costs)

Monthly Studio Overheads (overhead_expenses)

Crew & Freelancer Roster (crew)

Client Wedding Packages (packages)

Internal Cost Presets (rate_presets)

Studio Branding & Invoice Settings (settings)

Live Supabase Configuration

Quick Checklist for Supabase & Vercel

My Assigned Wedding Shoot Schedule (crew_schedule)

AF Studio

Create New Wedding Booking

Record Client Payment (payments)

Supabase Live Auth & Database Sync

Monthly Net Profit (`monthly_report`)

Per-Wedding True Profit Breakdown (`booking_profit_loaded`)

Direct Wedding Costs (`booking_costs`)

Monthly Studio Overheads (`overhead_expenses`)

Crew & Freelancer Roster (`crew`)

Client Wedding Packages (`packages`)

Internal Cost Presets (`rate_presets`)

Studio Branding & Invoice Settings (`settings`)

My Assigned Wedding Shoot Schedule (`crew_schedule`)

Record Client Payment (`payments`)