PROMPT BRO
Accounts desk

Landed cost and forex difference working

One shipment, three currencies, four documents. The landed cost sheet is having a busy day.

Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files

By hand3–4 hrs
With AI45 min
Per month · estimate
Easier on your office computer.Send to my computer
I usePick yours. We'll show the right steps.

Get approved import working

Use shipment ref, foreign amount, booking rate and settlement rate in ₹ per foreign unit, plus approved duty and freight. Use one currency per sheet.

First time? Try it on fake data first:

Confirm treatment with accountant

Duty and other cost components come from your own records. This is an arithmetic working only.

Privacy Use shipment refs and approved costs; remove bank and personal details. Delete bank account numbers; replace customer UPI IDs and phone numbers.

Fill the orange boxes
You send (the "prompt": the message you paste into your AI tool)
import-working.xlsx

I'm attaching import working in [Foreign currency]. Cost basis: [Approved cost basis]. A. Per shipment calculate booked INR = foreign amount × booking rate; landed working = booked INR + duty + freight; settlement INR and settlement difference = settlement minus booked. Missing input makes that calculation unknown; flag it. B. Sum landed amounts only for complete rows, and settlement differences only where both rates present. Show excluded rows separately. C. Questions for accountant / consultant about landed cost and forex treatment; no invented rate, duty, GST or posting. Use only my data. GST rates, HSN and TDS rates only from my supplied figures; never guess tax treatment. This is a first pass; a person checks and posts any final entries in Tally/Busy.

Which model? Use your tool's strongest model with thinking turned on.

In your AI tool: attach the files with the + button, paste, send.

What you'll get back (example, from the practice files)
₹3.68 Lknown landed
₹2,000FX difference
2data gaps
  • S2₹1,000 more paid. USD 1,000 × (₹84 − ₹83).
  • S4Duty missing. No landed total for this row.
  • S5Settlement rate missing. Landed cost known; forex difference unknown.
Before you trust it

Then send this: Recalculate each amount, sum complete landed rows and known settlement differences separately; verify missing values not zero.

If it goes wrong
It looks up exchange rate

Reply: "Use my supplied rates only."

It includes forex in landed cost

Reply: "Separate per approved basis."

It treats missing duty zero

Reply: "Hold landed calculation."

Sir ne bola urgent. Ab bolo: ho gaya.

Did it work?