Stock on Hand (China-prepaid items)
| Item | Section | Cases on hand | Cost/Case | Value |
|---|
Per-Unit Cost Catalog (what one cup, lid, straw… actually costs — case cost ÷ units per case)
| Item | 中文 | Vendor | Case spec | Units/case | Cost/case | Cost each | Billed/case | Billed each | Picture |
|---|
Units/case is parsed from the case spec ("24unit/case" → 24, "1000pc" → 1000). When the spec doesn't say how many units are in a case, type the number in and the row prices out. "Cost" is JL's landed cost; "Billed" is what the JV pays per the storefront price.
Inventory Position (China prepaid goods — shelf + on the water)
| Month | Ordered (cash to China) | Received into inventory |
|---|
"Ordered" is cash committed the month a PO is placed (China goods are prepaid). "Received" is when that value actually lands on the shelf — the gap between the columns is inventory in transit.
Stock Coverage — Reorder Radar
| Status | Item | 中文 | On hand | Burn / wk | Weeks left | Run-out | Inbound |
|---|
Burn = cases fulfilled to the store over the trailing 8 weeks (window starts at the item's first receipt). GAP = the shelf empties before the container lands. REORDER = nothing inbound and the run-out date is inside the reorder lead time. NO DATA = no fulfillment recorded yet — normal before the store opens.
Place a China Order
| Item | 中文 | Cases | Cost/Case | Value |
|---|
Orders
Add / Update Item
Vendors
All Items
Use the Photo button on a row to add or replace that item's picture — it shows on the Shop tab right away.
| Photo | Item | 中文 | Vendor | Brand | Unit/Case | Price/Case | Active |
|---|
Scan a Vendor Invoice (photo or PDF — Fresh Point deliveries, 3PL invoices, anything the store receives)
Molly Tea is the dashboard-only pilot: this scan IS the invoice record — no Ottimate. Vendor, total, invoice # and line items fill in automatically for review before saving.
Captured Invoices
| Date | Vendor | Invoice # | Lines | Doc | By | Total |
|---|
Expenses — P&L Detail (click a row to see the receipt / documentation)
| Date | Merchant | Category | Description | Receipt | Amount |
|---|
Personal Card Reimbursements (weekly — JV "Overseas Company Expense Reimbursement" format)
Every Monday at 8:15 AM the prior week's Molly Tea expenses (from the Expense Report module, store = Molly Tea WC) are auto-filled into the JV's reimbursement form and emailed to Will. Use the button to run a week manually or resend.
| Doc # | Week | Expenses | Total | Emailed |
|---|
What Molly Tea Owes (completed orders)
| Month | Billed |
|---|
Each completed order has an invoice PDF on the Orders tab.
JV Bank Account (weekly statement dates — backfilled from the accounting sheets)
Daily Cups (the headline KPI — entered nightly until the Chowbus sync takes over)
| Date | Cups | vs Goal | Net Sales | Orders | Cups/Order |
|---|
Live Weekly P&L (bank-side until Chowbus sales land 9/1 — capital & capex kept out of the operating line)
| Week ending | Cups | Sales | COGS | Labor | Opex | Operating net | Capex | Capital in | Bank balance |
|---|
COGS = supply-chain payments · Labor = payroll + ADP tax/fees · Opex = rent, utilities, services, fees · Capex = construction, signage, equipment. Sales fill in automatically from the POS once Chowbus is connected.
Mock P&L — Operating Projection (assumptions are editable; monthly = weekly × 52 ÷ 12)
Submit a Payroll Check (photo required — posts to the Molly Tea Lark chat automatically)
Add a Transaction / Weekly Balance
Weekly Bank Statement (upload the statement, then reconcile it against the ledger)
| Week ending | Opening | Deposits | Expenses | Ledger says | Statement says | Difference | Statement |
|---|
"Ledger says" is the opening balance plus the deposits and minus the expenses recorded here for that week. A difference means the ledger and the bank disagree — usually a transaction that hasn't been entered yet. Uploading a week again replaces it.
Where the Money Went (expenses by category)
| Category | Total | % of spend |
|---|
| Month | In | Out | Balance (wk end) |
|---|
Transactions
| Date | Ref | Counterparty | Description | Category | Invoice | Doc | Amount |
|---|
Categories are editable in place — imported rows keep their sheet amounts; use the category dropdown to sort the unlabeled payee checks (payroll vs contractor) as they clear.