Letter of Credit Tracking Spreadsheet Template
The columns to include in a spreadsheet for tracking Letters of Credit, deadlines and document status.
Reviewed by LCCheck team (owner-approved) · 2026-10-12
Short answer
A Letter of Credit tracking spreadsheet keeps every open credit, its key dates and its document status in one place. Include one row per credit (or per shipment under a credit) with the amount, dates, required documents and status, so nothing reaches the deadline unnoticed.
| One row per | Credit or shipment |
|---|---|
| Must-track dates | 44C, presentation deadline, 31D |
| Review | At least weekly |
Columns
- Credit number and issuing bank.
- Buyer and country.
- Amount, currency, tolerance.
- Latest shipment, presentation deadline, expiry.
- Amendments received and accepted.
- Required documents and status of each.
- Presentation date and bank.
- Payment status and date.
Good practice
- Highlight deadlines within 7 days.
- Record who owns each document.
- Archive closed credits separately.
Sources
- ICC — UCP 600 (Uniform Customs and Practice for Documentary Credits)
- ICC Academy — avoiding Letter of Credit discrepancies
General guidance, not legal advice. Your bank examines documents independently.
Related guides
Run an LC document check
Free snapshot in under a minute. No account needed.
Upload your Letter of Credit
PDF · up to 25 MB