Every open order with its status and the actions assigned on it. The tiles show the money tied up in the orders matching the processor and customer filters. An order can carry several actions, each with its own person. The second table gathers each person's action points.
One-page view for management: the money tied up in open orders, and what we plan to ship and earn over the next three months. Open actions and who is chasing them are in Daily follow-ups.
Revenue = sale value + RoDTEP + drawback, from each order's latest workbook. Orders sit in the month of their sale: the invoice date if recorded, else the LEO date once shipped; otherwise the latest planned date.
An order stays on the board until its eBRC is issued. Target shipment = first pre-shipment advance + 45 days (house rule); payment due = shipment + the order's credit days; eBRC due 15 days after payment. Click any row to log a development, a hurdle or a new planned shipment date. Planned dates override the 45-day target everywhere on the board.
Committed = the P&L frozen for management at the start of the month (order list and figures as they stood that day; it never changes). Projection = every order in the month: shipped orders by invoice date (or LEO date if no invoice date is recorded), the rest by planned shipment date. Actuals (till date) = only the orders already invoiced and shipped in the month. Figures come from each order's latest workbook stage: budget until it ships, then post-shipment, then post-settlement. Revenue includes the full RoDTEP and duty drawback; the processor's 50% share sits in costs. ₹ in lakh; costs shown as negatives.
The month-start plan is frozen the first time the board is opened in a new month: every order planned to ship that month, at its planned date and revenue. Actual = orders invoiced and shipped in the month (by invoice date, else LEO date) at their latest revenue. The forecast line is the month total the board projected at the close of each day (shipped + still planned). When the month ends its tracker freezes and stays here for review.
Money expected from buyers, month by month: buyer advances still to come on unshipped orders, and the balance on every order not yet paid. Click a month to see each expected receipt by date.
Dates: shipped orders — the expected payment date if one is set; when tracking has a current ETA — Thailand buyers and Glory Fish / Glory Diamond (who pay before arrival) ETA − 4 days, US buyers ETA + 21 days; else shipment (LEO) + the order's credit days; unshipped orders — the planned shipment date (else the 45-day target, or today if that has passed) + credit days for the balance (+ 60 days for Glory Fish and Glory Diamond), and planned shipment − 5 days for a fixed buyer advance not yet received. Receipts already past their date are shown as overdue in the current month. Amounts in ₹ at each order's exchange rate (LEO rate once shipped, budget rate before); USD-based balances are net of any buyer advance already received. RoDTEP, drawback and GST refunds are not included.
Every order's documents in one grid, each linked to its file in Drive, with the date it was issued. Red = due and nothing recorded; amber = the number or date is known but no file is linked; grey = not due yet at this stage. Click any status to add a link, or the PI to see all of that order's documents.
When each document is due: PI and buyer PO from order confirmation; LC / advance proof when the order has an LC or a buyer advance; CI, packing list, shipping bill, B/L, test reports, health certificate, certificate of origin, catch certificate, insurance and the courier AWB once the order has shipped (LEO); IRM once the buyer has paid; eBRC once it is issued. Mark a document “not needed” on orders where it doesn't apply (for example insurance on FOB terms). The red count under each column heading is the number of orders still to chase for that document.
Containers at sea, checked once a day against the carrier's public tracking (Maersk, Evergreen, Unifeeder), each linked to its order's PI and commercial invoice. A container moves to the archive only when it has reached its destination and the order's eBRC has been received.
Planned events are the carrier's current schedule and can move. Dates are local time at each port.