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
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.
Privacy Remove bank account numbers, PAN, personal phone numbers and emails. Use vendor business names or codes, item codes and approved commercial details.
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.
Keep your actual records in your own workbook; ask AI for the local method using headings and rules only.
Excel A:I shipment, foreign value, booking rate, duty, freight, proforma status, invoice status, shipping document status, customs document status. Approved checklist [Approved document checklist]. Currency [Currency], basis [Approved cost basis]. Give formulas for complete landed cost, missing input and pending/unknown document checks per required field, sum known landed cost separately from document statuses. No guessed duty/FX. Tell me exactly where to paste formulas or set up the local steps. Use fictional examples only; do not ask for actual company records.
Run the method locally; check every exception against physical stock, contracts or source records as applicable, and obtain approval before acting.
- S2Duty missing. Hold landed calculation.
- S4FX and customs status missing. Hold cost; confirm document status with consultant.
- S5BL pending. Cost complete, document still pending.
Then send this: Recalculate landed amounts, count each supplied document status and flag missing or unclear fields; no assumed duty, FX or compliance.
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?
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.