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
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.
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.
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.
Keep actual accounting records in your own Excel workbook; ask AI for formulas using column headings only.
Excel A:F shipment, foreign amount, booking rate, settlement rate, duty, freight. Currency [Foreign currency], basis [Approved cost basis]. Give formulas for booked INR, landed cost only when complete, settlement INR and settlement minus booked difference if both rates numeric; separate totals for complete landed and known FX differences. No guessed rate or tax. Tell me exactly where to paste formulas and how to verify totals. Use made-up examples only; do not ask for actual company data.
Run locally, reconcile totals to your source records and have accounts approve any correction or payment before acting.
- 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.
Then send this: Recalculate each amount, sum complete landed rows and known settlement differences separately; verify missing values not zero.
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?
Doing this every week? Save it once.
Save the prompt in your AI tool, so next time you only drop the files in. Pick your tool at the top to see how.
What is that?
A Project is a folder in ChatGPT that keeps your instructions and files for every chat inside it. It's on the free plan too. Checked 14 Nov 2026.
What is that?
A Project in Claude is a workspace with its own instructions and files that every chat inside it uses. Checked 14 Nov 2026.
What is that?
A Gem is a custom Gemini that loads your instructions before every chat. Free on every plan; you create it on a computer. Checked 14 Nov 2026.
What is that?
Signed in with a work account, Microsoft's Copilot Chat applies enterprise data protection: your prompts aren't used to train its models. Checked 14 Nov 2026.
If your whole team does this, we'll set it up for all of them in one session.