Rhino — Operations Dashboard

Period

Revenue

—

Gross Profit

—

Open Pipeline

—

Open AR

—

Cash Timing - 30 / 60 Day

Revenue by Month

Revenue by Customer

Sales by Item

SKU	Item	Cat	Units	Revenue	COGS*	GP	GPM%

*COGS estimated from BOM unit cost × units invoiced

Gross Profit by Customer

	Customer	Revenue	GP	GPM %	vs Prior

AR Aging — Open Invoices

Detail

Customer	Invoice	Balance	Days	Status

Open Sales Orders — Pipeline

	SO #	Customer	Value	Blocking	Exp Ship	Stage

Open Purchase Orders

	PO #	Vendor	Lines	Days Open	Status

Finished Goods Inventory Position

SKU	Item	Category	On Hand	Committed	Available	On Order	Effective Inv.

📊

Cash Flow View — Phase 2

Requires QuickBooks actuals export. Add QB_CashFlow report to daily export batch to enable.

Stuck — Awaiting Packing

—

Stuck — Awaiting Shipment

—

Low Stock Alerts

15

SKUs: demand, no avail.

Open POs (not received)

—

STUCK THRESHOLD 3 days since order with no packing — orders flagged

Stuck — Awaiting Packing

	SO #	Customer	Rep	Order Date	Days Open	Blocking	Fillable	Value

Stuck — Packed, Not Shipped

	SO #	Customer	Rep	Order Date	Days	Qty Packed	Blocking	Value

All Open Sales Orders

	SO #	Customer	Rep	Order Date	Exp Ship	Days	Blocking	Value	Stage

Open Purchase Orders

	PO #	Vendor	Status	PO Date	Days Open	Lines	Exp Delivery

Low Stock Alerts — Available = 0, Demand Exists

SKU	Item	Category	On Hand	Committed	Available	On Order	Effective Inv.

Finished Goods Inventory Position

SKU	Item	Category	On Hand	Committed	Available	On Order	Effective Inv.	Planned Build	Projected On Hand

Packaging & Components — Build Planner

Build Quantity Planner

Set planned build quantities per SKU. Component draw-down respects shared pools in real time.

Component Draw-Down after Planned Builds

Sub SKU	Component	Shared	Current Stock	Current Demand	On Order	Effective Stock	Planned Demand	Projected On Hand	Status

Component Master — All Subcomponents

Sub SKU	Component Name	Stock	On Order	Used By	FG SKUs

Inbound & Outbound Shipment Tracking

Tracked Shipments

—

In Transit

—

Carrier ETA active

Arriving Soon

—

ETA within 3 days

ETA Missing

—

Needs carrier update

Shipment Tracking

	Type	Ref #	Customer / Vendor	Carrier	Tracking / PRO	Status	ETA	Last Update	Link

Accounts Receivable

Total Open AR

—

Overdue (90+ days)

—

90+ days overdue

Current (0-30 days)

—

Current (0-30 days)

Open Credit Notes

—

Unapplied credits on file

AR Aging Waterfall

Open AR by Customer

Full AR Ledger

Type	Record #	Date	Customer	Cust PO#	Inv. Amt	Balance	COGS	GP	GPM%	Status	Days

Commission Summary

Rep	Historical Base	Earned @ 5%	Earned @ 2%	Paid to Date	Balance @ 5%	Balance @ 2%

Open SO Pipeline - Indicative

Rep	Open SO Value	Pipeline @ 5%	Pipeline @ 2%	Status

Open decisions: rate per rep, Michael methodology exception, Jerry prior overpayment disposition.

Accounts Payable

🧾

AP View — Awaiting Data Feed

To enable this view, add the following QuickBooks export to your daily batch:
Reports → Vendors & Payables → Unpaid Bills Detail (export as CSV)

Fields needed: Vendor, Bill Date, Due Date, Amount, Open Balance, Aging Days
Deliver to inbox with filename prefix: AP_UnpaidBills_