PROMPT BRO
Purchase desk

Import document checklist and cost working

Import file has a proforma, three emails and a document everyone calls 'the final BL'.

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

By handHours each
With AI45 min
Each time · estimate
Easier on your office computer.Send to my computer
I usePick yours. We'll show the right steps.

Collect shipment status and cost inputs

Use shipment ref, foreign value, approved booking rate, supplied duty/freight and one status per document from your approved checklist. Never share actual LC, bank or personal details.

First time? Try it on fake data first:

Privacy Remove bank account numbers, PAN, personal phone numbers and emails. Use vendor business names or codes, item codes and approved commercial details.

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

Currency: [Currency] Approved cost basis: [Approved cost basis] Approved document checklist: [Approved document checklist] I'm attaching import-check.xlsx. A. Calculate landed working for complete shipments; hold missing amounts. No guessed customs rate or FX. B. Check each shipment against the supplied document checklist: Ready, Pending or Unknown per document. List missing/unclear documents and sum complete landed cost separately. Do not infer mandatory legal documents or clearance. C. Questions for accountant / consultant and logistics; no filing or payment. Use only supplied facts, quotes and approved terms. Flag missing GST, freight, payment days or delivery instead of assuming. Check stock against physical count or software before ordering. A person checks before sending, ordering, paying or posting.

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)
3complete costs
₹2.7 Lknown landed
2cost gaps
  • S2Duty missing. Hold landed calculation.
  • S4FX and customs status missing. Hold cost; confirm document status with consultant.
  • S5BL pending. Cost complete, document still pending.
Before you trust it

Then send this: Recalculate landed amounts, count each supplied document status and flag missing or unclear fields; no assumed duty, FX or compliance.

If it goes wrong
Looks up rate

Reply: "Supplied booking rate only."

Assumes duty zero

Reply: "Hold missing duty."

Files document

Reply: "Checklist only."

Sir ne bola urgent. Ab bolo: ho gaya.

Did it work?