Welcome, …
Live data from your Supabase project · refreshes automatically
My role
…
Approvals waiting on me
0
Open offers
0
Total team active
0 / 4
Recent Activity live
Loading…
Quick links
- Approvals — items routed to your role
- Audit Log — every system action
- Team Status — verify all execs active
Sales Pipeline
All offers grouped by lifecycle stage. Click a column to filter.
Recent offers across all stages
| Wk | Stage | Origin | Product | USD/Kg | Value (USD) | Created |
|---|---|---|---|---|---|---|
| Loading… | ||||||
Sales Forecast
Per-client and per-product forecast based on agent submissions. Aggregated from sales_forecast table.
Forecast / month (mid)
—
Active clients
—
SKU lines
—
Forecast month
—
Top clients by volume
| Client | Channel | Lines | Vol low | Vol high |
|---|---|---|---|---|
| Loading… | ||||
Top products forecasted
| Product | Clients | Vol low | Vol high |
|---|---|---|---|
| Loading… | |||
All forecast lines
| Month | Client | Product | Origin | Channel | Volume (kg/mo) |
|---|---|---|---|---|---|
| Loading… | |||||
Purchase Orders
Formal commitments to suppliers — issued after CEO approves a supplier offer. Each PO becomes the binding contract.
Total POs
—
Issued / Open
—
Open value (USD)
—
Fulfilled this month
—
| PO # | Supplier | Origin | PO Date | Expected delivery | Lines | Total USD | Status |
|---|---|---|---|---|---|---|---|
| Loading… | |||||||
Sales Invoices
Invoices issued to customers. Issued after a Sales Order is delivered. Tracks payments and overdue status.
Total invoices
—
Outstanding (PHP)
—
Overdue (PHP)
—
Paid this month
—
| Invoice # | Customer | Date | Due | Lines | Total (incl VAT) | Outstanding | Status |
|---|---|---|---|---|---|---|---|
| Loading… | |||||||
Accounts Receivable Aging
Outstanding customer balances grouped by overdue bucket. Click a row to see the underlying invoices.
Total outstanding
—
Current (not yet due)
—
31–90 days overdue
—
90+ days overdue
—
By customer
| Customer | Channel | Current | 1–30 d | 31–60 d | 61–90 d | 90+ d | Total outstanding |
|---|---|---|---|---|---|---|---|
| Loading… | |||||||
Goods Received Notes
When a container arrives, log a GRN. This automatically updates inventory available_kg.
| GRN # | PO | Supplier | Received | Warehouse | Lines | Total kg | Status |
|---|---|---|---|---|---|---|---|
| Loading… | |||||||
Supplier Invoices
Bills received from suppliers. Real Accounts Payable. Auto-status updates as payments are recorded.
Total invoices
—
Outstanding (USD eq.)
—
Overdue
—
Paid this month
—
| Internal Ref | Supplier Inv # | Supplier | Date | Due | Total | Outstanding | Status |
|---|---|---|---|---|---|---|---|
| Loading… | |||||||
Supplier Payments
Outgoing money to suppliers. Records payment and decreases the corresponding bank account balance.
| Payment Ref | Supplier | Date | Amount | Currency | PHP equiv | Method | Bank |
|---|---|---|---|---|---|---|---|
| Loading… | |||||||
Customer Payments
Incoming money from customers. Records payment and applies it to the linked invoice + bank account.
| Payment Ref | Customer | Date | Amount PHP | Method | Bank | Linked Invoice |
|---|---|---|---|---|---|---|
| Loading… | ||||||
Accounts Payable Aging
Outstanding supplier balances grouped by overdue bucket. Mirror of AR aging, but for what we owe.
Total outstanding
—
Current (not yet due)
—
31–90 days overdue
—
90+ days overdue
—
By supplier
| Supplier | Currency | Current | 1–30 d | 31–60 d | 61–90 d | 90+ d | Total outstanding |
|---|---|---|---|---|---|---|---|
| Loading… | |||||||
Inventory
Items available to sell, sourced from approved supplier offers. Used by Quotations and Sales Orders.
Total items
—
In stock
—
Incoming
—
Net available (kg)
—
Most items appear automatically when supplier offers are approved.
| Status | Product | Origin / Brand | Available kg | Reserved | Net | Cost USD/Kg | Expected arrival |
|---|---|---|---|---|---|---|---|
| Loading… | |||||||
Quotations
Price proposals to customers. Each line is pulled from inventory.
| Quotation # | Customer | Date | Valid until | Lines | Total PHP | Status | Prepared by |
|---|---|---|---|---|---|---|---|
| Loading… | |||||||
Sales Orders
Confirmed customer orders. Reduces inventory when fulfilled.
| SO # | Customer | Order date | Delivery | Lines | Total PHP | Status | From quotation |
|---|---|---|---|---|---|---|---|
| Loading… | |||||||
Customers
Companies WG Food sells to. Add new clients here so they appear in the forecast.
| Name | Channel | Contact | Email / Phone | Status |
|---|---|---|---|---|
| Loading… | ||||
Approvals routed to CEO
Live from Supabase. Approving auto-locks the underlying record.
| Ref | Type | Title | Amount | Submitted | Required roles | |
|---|---|---|---|---|---|---|
| Loading… | ||||||
New Offer Entry
Save Draft to keep editing · Submit for approval routes to CEO (and CFO if value ≥ USD 100k)
My Offers
Every offer you've created. 🔒 = locked by executive approval, ⏳ = pending, ✏ = draft.
| Wk | Origin | Product | USD/Kg | Net kg | Status | Created | Action | |
|---|---|---|---|---|---|---|---|---|
| Loading… | ||||||||
Operations Pre-screening Queue
Items needing your review BEFORE they go to the CEO. Includes CPR/FDA/BPI applications, BOC facilitation requests, and containers held at port.
CPR / FDA / BPI in stage
0
BOC facilitation requests
0
Containers at port
0
Days oldest item waiting
0
Live queue
| Source | Ref | Type | Subject | Stage | Days waiting | Action |
|---|---|---|---|---|---|---|
| Loading… | ||||||
CPR / FDA / BPI Pipeline
All Certificate of Product Registration applications across stages. Add new applications by clicking the button.
Loaded {0} active
| Lodged | Agency | Ref | Stage | Days in stage | Expected issue | Expiry |
|---|---|---|---|---|---|---|
| Loading… | ||||||
Containers & BOC Manila
Live container status from pre-arrival to released. Held containers shown in red — flag for CEO when facilitation is needed.
0 active containers
| Container # | BL # | Vessel | Origin | ETA | Stage | Days at port |
|---|---|---|---|---|---|---|
| Loading… | ||||||
Cash Flow & Payables
Live payables aging from active offers. Computes due dates from arrival + supplier payment terms.
Total payables (USD eq.)
—
Overdue
—
Due ≤ 7 days
—
Due 8–30 days
—
Aging detail
| Origin | Supplier | Product | Amount (USD) | Terms | Due date | Bucket | Status |
|---|---|---|---|---|---|---|---|
| Loading… | |||||||
Bank Balances & Cash Position
Update each balance manually for now (or hook a bank API later). Snapshot kept with as-of date.
| Bank | Account | Type | Currency | Balance | As of | Action |
|---|---|---|---|---|---|---|
| Loading… | ||||||
FX & Hedging Board
Live USD/PHP, EUR/PHP, DKK/USD rates and your open hedging contracts.
USD/PHP
—
EUR/PHP
—
DKK/USD
—
Open hedges
0
Open hedging contracts
| Bank | Type | Pair | Notional | Strike | Maturity | MTM (PHP) | Status |
|---|---|---|---|---|---|---|---|
| Loading… | |||||||
Active Negotiations
Offers in back-and-forth between staff and CEO. Click a row to see the full bid timeline.
| Ref | Product | Origin / Brand | Latest USD/Kg | CEO target | Round | Status | Last activity |
|---|---|---|---|---|---|---|---|
| Loading… | |||||||
Audit Log
Every action across the system. Immutable, server-stamped.
| Time (UTC) | Actor | Action | Entity | Field | Before | After |
|---|---|---|---|---|---|---|
| Loading… | ||||||
Team Status
All four executives must be Active. Run the link-UPDATE SQL again from Supabase if anyone shows pending.
| Role | Name | Department | Status | |
|---|---|---|---|---|
| Loading… | ||||