ExportFlow — MSME Export Dashboard

Total Export Value (INR)

₹40.6Cr

≈ $4.82M · at avg FEDAI rate

▲ 12.4% vs last FY

Receivables Outstanding

₹2.14Cr

≈ $2.54L · live FEDAI rate

Across 6 buyers

Forex Gain (Realised)

+₹3.6L

This month · FEDAI rates

▲ vs last month

Active Shipments

2 sailing · 5 in port

₹18.4Cr in transit

Docs Pending

BL · COO · SB

Action required

Order Pipeline

View all →

PI Sent

ORD-2601

🇩🇪 Müller GmbH

₹23.9L $28,400

ORD-2602

🇦🇪 Al-Fardan Trading

₹12.8L $15,200

›

PO Received

ORD-2598

🇺🇸 ClearPath Inc.

₹52.3L $62,000

›

In Transit

ORD-2591

🇬🇧 Hargreaves Ltd.

₹36.6L £34,100

ORD-2585

🇸🇬 Pacific Dist.

₹16.6L $19,750

›

Payment Due

ORD-2579

🇳🇱 DutchTrade BV

₹40.6L €44,600

Live Rates · FEDAI

LIVE

USD/INR

84.32

+0.18

+₹1.8L

EUR/INR

91.14

−0.09

−₹0.4L

GBP/INR

107.42

+0.31

+₹2.2L

AED/INR

22.96

+0.04

+₹0.6L

RBI FEDAI API · Updated 10:42 IST · Used for all OCR-extracted invoice conversions

Monthly Export Revenue

Payment Modes

FY 2025–26

100% Advance

₹48.2L

12 orders

Partial Advance

₹31.6L

8 orders

₹62.4L

5 orders

DP / CAD

₹18.9L

3 orders

DA (Credit)

₹44.6L

DA 60d · 4 orders

TT Direct

₹9.1L

2 orders

Alerts & Actions

3 urgent

ORD-2579 — DutchTrade BV: Payment overdue by 6 days. DA 60 credit expired.

Today · High priority

ORD-2591: BL copy not uploaded. Vessel sailed 2 days ago.

2 days ago · Docs team

USD/INR at 84.32 — Book forex now to lock ₹1.8L gain on ORD-2598.

FEDAI Rate Alert · Finance

ORD-2602: PI approved by Al-Fardan. Awaiting advance payment.

3 hrs ago

CN-2024-02 — Hargreaves: Credit note £1,640 under review. Buyer response pending.

Yesterday · Finance

CLM-003 — DutchTrade: Transit damage €4,200. Surveyor appointed. Insurance ref UIIC-2024-8821.

2 days ago · Claims

Forex P&L — Booked

ORD-2579 — €44,600

Sale 89.20 → Rcvd 91.14 · FEDAI

+₹86,444

ORD-2585 — $19,750

Sale 83.10 → Rcvd 84.32 · FEDAI

+₹24,095

ORD-2571 — $31,000

Sale 84.80 → Rcvd 83.90 · FEDAI

−₹27,900

ORD-2564 — £22,000

Sale 104.20 → Rcvd 107.42 · FEDAI

+₹70,840

Container Tracking

via ShipsGo API

🚢

MSCU7241930

Nhava Sheva → Hamburg

ETA Mar 28, 2026

Arabian Sea

11d left

🚢

CMAU4851220

Mundra → Jebel Ali

ETA Mar 20, 2026

Arrived port

3d left

⚓

HLCU6723412

Chennai → Singapore

ETA Apr 2, 2026

Bay of Bengal

16d left

Order ID	Buyer	Country	Invoice Amt	INR Value	Rate at Sale	Payment Mode	Drawback	Status
ORD-2601	Müller GmbH	🇩🇪 Germany	$28,400	₹23,94,688	84.32	100% Advance	Claimed	PI Sent
ORD-2602	Al-Fardan Trading	🇦🇪 UAE	$15,200	₹12,81,664	84.28	TT Direct	—	PI Sent
ORD-2598	ClearPath Inc.	🇺🇸 USA	$62,000	₹52,27,840	84.32	LC	Claimed	PO Received
ORD-2591	Hargreaves Ltd.	🇬🇧 UK	£34,100	₹36,62,822	107.42	Partial Adv.	—	In Transit
ORD-2585	Pacific Distributors	🇸🇬 Singapore	$19,750	₹16,64,320	84.27	DP/CAD	Pending	In Transit
ORD-2579	DutchTrade BV	🇳🇱 Netherlands	€44,600	₹40,64,844	91.14	DA 60 days	Claimed	Payment Due
ORD-2571	Sunrise Corp	🇯🇵 Japan	$31,000	₹26,13,920	84.32	LC	Claimed	Completed

Total Forex Gain

+₹3.61L

Realised FY 25-26

Total Forex Loss

−₹27,900

2 adverse orders

Unrealised Exposure

₹2.14L

DA orders · at live rate

Net P&L

+₹3.33L

After all deductions

Live Unrealised Exposure — DA / Credit Orders

ORD-2579 · €44,600 · DA 60d

Sale rate: 89.20

Live rate: 91.14

Unrealised: +₹86,444

ORD-2591 · £34,100 · Partial

Sale rate: 104.20

Live rate: 107.42

Unrealised: +₹1,09,802

ORD-2602 · $15,200 · TT

Sale rate: 84.28

Live rate: 84.32

Unrealised: +₹608

Rates updating live from RBI FEDAI API · Gain/loss recalculates automatically when payment is recorded

Forex Gain / Loss Register

All rates sourced from

RBI FEDAI API

Order	Buyer	FCY Amt	Invoice Date	Rate at Sale ①	Advance Rate ②	Balance Rate ③	INR Expected	INR Realised	Forex G/L	Reg.
ORD-2579	DutchTrade BV	€44,600	Jan 9	89.20	88.50	91.14	₹39,78,320	₹40,64,844	+₹86,524	EB
ORD-2585	Pacific Dist.	$19,750	Feb 1	83.10	83.10	84.32	₹16,41,225	₹16,65,320	+₹24,095	KC
ORD-2571	Sunrise Corp	$31,000	Dec 14	84.80	84.80	83.90	₹26,28,800	₹26,00,900	−₹27,900	RBI
ORD-2564	Hargreaves Ltd.	£22,000	Nov 22	104.20	105.00	107.42	₹22,92,400	₹23,63,240	+₹70,840	EB

① Rate at Sale = FEDAI rate on invoice date (auto-fetched) | ② Advance Rate = FEDAI rate on advance receipt date | ③ Balance Rate = FEDAI rate on balance payment date | G/L = (Realised rate − Sale rate) × FCY amount

Overdue

€44,600

DutchTrade · 6 days late

Due This Week

$15,200

Al-Fardan · Mar 22

Partial Pending

£17,050

Hargreaves · Apr 5

Fully Settled

Müller + ClearPath

Payment Ledger

Order	Buyer	Total (FCY)	Mode	Advance Rcvd	Adv. Rate	Balance Due	Bal. Rate	Due Date	INR Realised	Forex G/L	Bank Reg.	Status
ORD-2601	Müller GmbH	$28,400	100% Advance	$28,400	84.32 FEDAI	—	—	—	₹23,94,688	+₹5,680	KC Reg.	Settled
ORD-2602	Al-Fardan Trading	$15,200	TT Direct	—	—	$15,200	Pending	Mar 22, 2026	—	Unrealised	Pending	Awaiting
ORD-2598	ClearPath Inc.	$62,000	LC	$62,000	84.32 FEDAI	—	—	—	₹52,27,840	+₹12,400	EB Reg.	LC Realised
ORD-2591	Hargreaves Ltd.	£34,100	Partial Adv.	£17,050	107.42 FEDAI	£17,050	Pending	Apr 5, 2026	₹18,31,411 (partial)	Partial	RBI Reg.	Partial
ORD-2579	DutchTrade BV	€44,600	DA 60 days	—	—	€44,600	Pending	Mar 10 ⚠ Overdue	—	Unrealised	EB Reg.	Overdue

Advance Rate and Balance Rate auto-fetched from RBI FEDAI on the date each payment is recorded · Forex G/L auto-calculated on save

Payment History — All Tranches

Ref No.	Order	Buyer	Tranche	FCY Amount	Payment Date	FEDAI Rate	INR Credited	Mode	UTR / Ref	Bank
PAY-001	ORD-2601	Müller GmbH	100% Advance	$28,400	Mar 2, 2026	84.32 FEDAI	₹23,94,688	TT / Wire	ICIC26030200421	ICICI Bank
PAY-002	ORD-2598	ClearPath Inc.	LC Realisation	$62,000	Mar 8, 2026	84.32 FEDAI	₹52,27,840	LC	HDFC26030812891	HDFC Bank
PAY-003	ORD-2591	Hargreaves Ltd.	50% Advance	£17,050	Jan 14, 2026	107.42 FEDAI	₹18,31,411	TT / Wire	AXIS26011487234	Axis Bank

ShipsGo API Connected

Last synced: 10:42 IST · 4 containers tracked

🚢

MSCU7241930

MSC Celestia

Sailing

API ✓

Origin

Nhava Sheva

Sailed Mar 5

Destination

Hamburg, DE

ETA Mar 28

Order

ORD-2591

Buyer

Hargreaves Ltd.

Position

Arabian Sea

Days left

11d

🚢

CMAU4851220

CMA CGM Jade

At Dest.

API ✓

Origin

Mundra

Sailed Mar 12

Destination

Jebel Ali, AE

ETA Mar 20

Order

ORD-2602

Buyer

Al-Fardan Trading

Position

Arrived port

Days left

🚢

HLCU6723412

HAPAG Tian

Sailing

API ✓

Origin

Chennai

Sailed Mar 10

Destination

Singapore

ETA Apr 2

Order

ORD-2585

Buyer

Pacific Dist.

Position

Bay of Bengal

Days left

16d

🚢

OOCU8812774

ONE Crane

Sailing

API ✓

Origin

JNPT

Sailed Feb 28

Destination

Los Angeles, US

ETA Mar 25

Order

ORD-2598

Buyer

ClearPath Inc.

Position

Pacific Ocean

Days left

Full Shipment Register

All fields manually entered · API enriches position & ETA when available

Container No.	Type	Seal No.	Order	Buyer	Vessel	Voyage No.	Shipping Line	Origin Port	Dest. Port	ETD	ETA	BL No.	Position	API	Status
MSCU7241930	40HC	IND8821734	ORD-2591	Hargreaves Ltd.	MSC Celestia	MM317W	MSC	Nhava Sheva	Hamburg, DE	Mar 5	Mar 28	MSCU-BL-9921	Arabian Sea	Live	Sailing
CMAU4851220	20GP	IND9934512	ORD-2602	Al-Fardan Trading	CMA CGM Jade	FE418N	CMA CGM	Mundra	Jebel Ali, AE	Mar 12	Mar 20	CMDU-BL-4421	Arrived port	Live	At Dest.
HLCU6723412	40GP	MAA4412098	ORD-2585	Pacific Dist.	HAPAG Tian	HX220E	Hapag-Lloyd	Chennai	Singapore	Mar 10	Apr 2	HLCU-BL-7710	Bay of Bengal	Live	Sailing
OOCU8812774	40HC	NHV7712340	ORD-2598	ClearPath Inc.	ONE Crane	OW514S	ONE	JNPT	Los Angeles, US	Feb 28	Mar 25	OOLU-BL-3342	Pacific Ocean	Live	Sailing

All container/vessel/voyage details are manually entered · ShipsGo API enriches Position and ETA only · System works fully without API BL number entered manually after sailing

Total Debit Notes

₹3.42L

4 notes issued

Total Credit Notes

₹1.18L

2 notes issued

Net Adjustment

−₹2.24L

Impact on receivables

Pending Approval

Awaiting buyer confirm

Debit Note (DN) — you charge buyer more

Buyer owes you additional money beyond original invoice:

▸Price increase / raw material cost spike after PI

▸Additional freight or handling not in original invoice

▸Interest on delayed payment (DA overdue orders)

▸Custom packing or labelling charges

Forex: DN amount converted at FEDAI rate on DN issue date — creates a separate forex entry vs original invoice rate.

Credit Note (CN) — you reduce buyer's payable

You owe the buyer a reduction from the original invoice:

▸Short shipment — fewer units shipped than invoiced

▸Damage claim settled — partial refund agreed

▸Quality rejection — buyer deducts from balance

▸Price reduction agreed post-shipment

Forex: CN reduces INR realised. Calculated at FEDAI rate on CN date — rupee movement between invoice and CN date creates additional forex delta.

Credit / Debit Note Register

Rates auto-fetched · RBI FEDAI

Note No.	Type	Linked Order	Buyer	Reason	FCY Amt	FEDAI Rate	INR Value	Effect on Invoice	Forex Δ	Linked Claim	Status
DN-2024-01	Debit Note	ORD-2571	Sunrise Corp	Freight surcharge — carrier revised rate	$1,200	84.10	₹1,00,920	Invoice ↑ $32,200	+₹960	—	Accepted
CN-2024-01	Credit Note	ORD-2585	Pacific Dist.	Short shipment — 48 units missing	$2,400	84.27	₹2,02,248	Invoice ↓ $17,350	−₹2,880	CLM-002	Accepted
DN-2024-02	Debit Note	ORD-2579	DutchTrade BV	Interest on DA 60d overdue — 6 days	€890	91.14	₹81,115	Invoice ↑ €45,490	+₹1,692	—	Pending
CN-2024-02	Credit Note	ORD-2591	Hargreaves Ltd.	Quality claim — 12 defective units	£1,640	107.10	₹1,75,644	Invoice ↓ £32,460	−₹5,248	CLM-001	Under Review
DN-2024-03	Debit Note	ORD-2598	ClearPath Inc.	Special export carton charges	$3,100	84.32	₹2,61,392	Invoice ↑ $65,100	+₹0	—	Pending

Linked Claim column shows associated damage claim where CN was raised as settlement · Forex Δ = (CD Note FEDAI rate − original invoice rate) × FCY amount

Net Realised Value — After All CD Note Adjustments

Order	Original Invoice	Debit Notes (+)	Credit Notes (−)	Adjusted Invoice	INR Expected	INR Realised	CD Note Forex Δ	Final Net G/L
ORD-2571	$31,000	+$1,200	—	$32,200	₹26,28,800	₹27,07,120	+₹960	−₹26,940
ORD-2585	$19,750	—	−$2,400	$17,350	₹16,41,225	₹14,62,977	−₹2,880	−₹1,80,128
ORD-2591	£34,100	—	−£1,640	£32,460	₹36,62,822	₹34,80,486	−₹5,248	−₹1,87,584

Open Claims

₹6.8L at risk

Under Investigation

Surveyor appointed

Claims Settled

₹4.2L

This FY · Insurance

Buyer Deductions

₹2.1L

Via credit notes

Damage Claim Workflow

📦

Damage Reported

Buyer notifies · photos + video required

›

📋

Claim Raised

Filed with insurer / shipping line

›

🔍

Survey

Independent surveyor · determines cause

›

⚖️

Liability Decision

Insurance / carrier / buyer / exporter based on Incoterms

›

💰

Settlement

CN issued or insurance payout · forex logged

FOB — Buyer's risk

Risk transfers at loading port. In-transit damage = buyer's claim. You issue CN only if damage occurred before loading.

CIF — Your risk to destination

You insure the cargo. Transit damage = your insurance claim. Settlement reduces realised value → CN issued to buyer.

DAP/DDP — Full exporter risk

You bear risk until delivery at buyer's door. All damage is yours. Always insure fully at these terms.

Active Damage Claims

Claim ID	Order	Buyer	Damage Type	Incoterms	Claim (FCY)	INR Value	Liable Party	Insurance Ref	CD Note Raised	Status
CLM-001	ORD-2591	Hargreaves Ltd.	Quality defect — 12 non-conforming units	FOB	£1,640	₹1,75,644	Buyer absorbs	—	CN-2024-02 ✓	Under Review
CLM-002	ORD-2585	Pacific Dist.	Short shipment — 48 units not loaded	CIF	$2,400	₹2,02,248	Exporter liable	—	CN-2024-01 ✓	Settled
CLM-003	ORD-2579	DutchTrade BV	Transit damage — moisture, 30 cartons	CIF	€4,200	₹3,82,788	Insurance claim	UIIC-2024-8821	Pending CN	Surveyor Apptd.
CLM-004	ORD-2571	Sunrise Corp	Packing failure — 5 pallets superficial	FOB	$800	₹67,280	Negotiating	—	Pending	Open

"CD Note Raised" column links directly to the credit note created from this claim · Once a claim is settled and CN is raised, forex delta is auto-calculated at FEDAI rate on CN date

Forex Impact — Damage Settlements on Net P&L

When a damage claim is settled and a CN is issued, the INR impact is at the FEDAI rate on CN date — not the original invoice rate. On DA credit orders where months have passed, this difference can be significant.

Example — CLM-002 · ORD-2585 · Short Shipment $2,400

Invoice date rate

83.10

CN issue date rate

84.27

INR loss at invoice rate

₹1,99,440

Actual INR loss at CN rate

₹2,02,248

Additional forex loss due to rupee depreciation between invoice and CN date: −₹2,808