Payments Tracker

One-time setup in your Google Sheet:

1. Row 1 must have these exact headers, in any order:
   Supplier Request Type Invoice/Ref/Period Departure From Departure To Currency Amount Request Raised Date Due Date Recon Status Good to Pay Payment Status Initiated Date Payment Date UTR/SWIFT Remarks
   Request Type must be one of: Ticket, SOA, D 14
2. File → Share → Publish to web
3. Select the correct sheet/tab, choose Comma-separated values (.csv), click Publish
4. Copy the link it gives you and paste it below

TAT is calculated in working days (Mon–Fri) from Request Raised Date to Payment Date (or today, if still pending) — weekends don't count against the clock. Once a request passes its TAT, it's flagged as breached and the escalation contact below is shown against it.

Request type mapping: SOA = Regular payout · Ticket and D 14 = Urgent request.