Bank Guarantee & Letter-of-Credit Expiry Tracker
Download the free Bank Guarantee & Letter-of-Credit Expiry Tracker and see, for every instrument, which of four deadlines comes next - expiry, evergreen non-extension notice, latest shipment, or presentation deadline.
Bank Guarantee & Letter-of-Credit Expiry Tracker
Microsoft Excel (.xlsx) — Free
Track each bank guarantee, standby LC, commercial LC, and performance guarantee - type, ref, beneficiary, applicant, issuing bank, optional amount and currency, issue and expiry dates, evergreen / auto-renew flag, non-extension notice deadline, latest shipment date, and presentation deadline (the earlier of expiry or shipment + presentation days). A MIN-based Next Critical Date names the next event and counts the days to it, and Status flags Expired, Notice Deadline Passed, Critical, Due Soon, OK, Complete, and Missing Date. Includes a dashboard, instructions sheet, and lookup dropdowns. Track-and-remind only - not financial or legal advice. No sign-up required.
Free Template DownloadWhat's Inside the Spreadsheet
Four pre-built sheets that keep four instrument deadlines on one row - and pick the next one for you.
BG LC Tracker Sheet
Notice deadline (evergreen only), presentation deadline (MIN of expiry and shipment + days), Next Critical Date, Next Critical Event, Days to Next Critical, and a color-coded status.
Instrument Dashboard
Status counts, the next 5 critical dates with their event, counts by instrument type and issuing bank, and a portfolio health score.
Instructions Sheet
How to use, a column guide, the MIN logic behind Next Critical Date, status meanings, and a not-financial-or-legal-advice note.
Dropdown Lookup Lists
Editable lists for instrument type, currency, evergreen yes/no, notice days, presentation period, reminder status, status labels, issuing bank, and owner.
Who it's for: Treasury, Trade Finance & Legal Teams
Every guarantee or LC runs on up to four clocks at once - an expiry, an evergreen non-extension notice window, a latest shipment date, and a presentation deadline that is the earlier of expiry or shipment plus the presentation period. Working out which one comes next for each instrument by hand is exactly where dates slip, so this workbook does it with a single MIN formula per row. Track-and-remind only - not financial or legal advice; confirm terms against the instrument and the UCP/URDG rules your bank applies.
- Treasury teams watching evergreen standby LCs before the non-extension notice window closes
- Trade operations teams holding latest shipment and presentation deadlines for commercial LCs
- Contracts and legal teams tracking performance and advance-payment guarantees by beneficiary
Related Remindax pages: bank guarantee tracking, letter of credit tracking, and surety & performance bonds.
Automate Guarantee & LC Deadline Reminders
Spreadsheets work - until an evergreen notice window closes unnoticed and an instrument rolls over, or a presentation deadline passes while documents are still in transit. Remindax automates email, SMS, and WhatsApp reminders before each date. See Remindax finance compliance for multi-channel reminders.
- Automated email, SMS & WhatsApp reminders before expiry, notice, shipment, and presentation dates
- Every instrument tied to its beneficiary and issuing bank - dates only, no account details
- Forever Free plan - no credit card required
Stop losing track of
critical deadlines.
Join 30,000+ businesses that use Remindax to automate expiry tracking, compliance, and renewal reminders — so nothing slips through the cracks.