Forecasting & Cash Planning
Projected duty payments, container arrivals, overseas freight, and inbounding costs based on shipment ETAs. Rolling 7/14/30/60/90-day windows for working-capital planning.
5 shipment(s) without SKU/units — duty estimates can't be computed for these. Container costs still count toward the cash forecast, but expect totals to be conservative. Edit shipment SKU + units in Neon or wait for richer ForceGet API data.
Cash need next 7 days
$65.8K
duty + freight + inbounding
Cash need next 30 days
$85K
6 container(s) arriving
Cash need next 90 days
$85K
full rolling outlook
Total unpaid duty
$27.4K
1 actual + 0 estimated
Containers in pipeline
6
ETA within 30 days
12-week cash-flow projection
Stacked: amber = duty, blue = overseas freight, teal = inbounding. Each bar is one rolling week. Anything overdue piles into week 1.
Cumulative windows
Inclusive — Next 30 includes everything in Next 7, etc.
Next 7 days
$65.8K
Duty$27.4K
Freight$34K
Inbounding$4.4K
4 container(s)· 3 missing duty estimate
Next 14 days
$65.8K
Duty$27.4K
Freight$34K
Inbounding$4.4K
4 container(s)· 3 missing duty estimate
Next 30 days
$85K
Duty$27.4K
Freight$51K
Inbounding$6.6K
6 container(s)· 5 missing duty estimate
Next 60 days
$85K
Duty$27.4K
Freight$51K
Inbounding$6.6K
6 container(s)· 5 missing duty estimate
Next 90 days
$85K
Duty$27.4K
Freight$51K
Inbounding$6.6K
6 container(s)· 5 missing duty estimate
Upcoming arrivals
Per-shipment cash need. Badges: green "actual" = real DT invoice, amber "estimated" = SKU rate × units, grey "no rate" = SKU missing.
6 of 6 shipments
| FGET # | SKU | Destination | ETA | Duty | Source | Overseas | Inbounding | Cash need |
|---|---|---|---|---|---|---|---|---|
| 81703 | unknown | — | Sep 19 32d overdue | $27,448.72 | actual | $8,500.00 | $1,100.00 | $37,048.72 |
| 83992 | unknown | Los Angeles | Oct 18 3d overdue | — | no rate | $8,500.00 | $1,100.00 | $9,600.00 |
| 83832 | unknown | Los Angeles | Oct 19 2d overdue | — | no rate | $8,500.00 | $1,100.00 | $9,600.00 |
| 83206 | unknown | Los Angeles | Oct 23 in 2d | — | no rate | $8,500.00 | $1,100.00 | $9,600.00 |
| 84193 | unknown | Los Angeles | Nov 11 in 21d | — | no rate | $8,500.00 | $1,100.00 | $9,600.00 |
| 84317 | unknown | Columbus | Nov 12 in 22d | — | no rate | $8,500.00 | $1,100.00 | $9,600.00 |