Complaint handling deadlines

Track complaint deadlines without spreadsheet pain

Q: Which countries are supported?

The complaint deadline tracker currently supports UK and Ireland complaint handling timelines.

Calculate acknowledgement, 20 day update, and final response dates for UK and Ireland complaint timelines.

Why teams use it

A practical way to check complaint deadlines more clearly.

See the next action clearly Track whether the next step is the acknowledgement, 20 day update, or final response.

Spot breaches fast Review 5 day, 20 day, 40 day, and overall milestone status at a glance.

Export a usable Excel tracker Download a formatted workbook to review dates, next steps, and complaint progress more easily.

Rule set

Business day deadlines for UK and Ireland complaints.

Country

Public holidays Exclude public holidays

Single complaint result

Choose a received date to begin

The tool will calculate acknowledgement, 20 day update, and final response dates here.

Bulk upload

Upload a CSV with a received date column, an optional case reference, and optional acknowledgement or 20 day update sent dates. The tool will calculate complaint deadlines, next action, and status fields for export.

Upload CSV file

Expected columns: received_date, optional case_ref, optional acknowledgement_sent_date, and optional update_sent_date. Accepted date formats: YYYY-MM-DD, DD/MM/YYYY, or DD-MM-YYYY.

Example CSV

case_ref,received_date,acknowledgement_sent_date,update_sent_date
CMP-001,22/04/2026,,
CMP-002,23/04/2026,28/04/2026,

Calculated deadlines

Upload a file to generate a deadline dashboard.

Case ref	Received date	Country	Acknowledgement due	Acknowledgement sent	20 day update due	20 day update sent	Final response due	Next action	Next action date	5 day status	20 day status	40 day status	Overall milestone SLA
No uploaded cases yet.

How this tracker helps

More than just a date calculator, this page is designed around practical complaint workflow review.

Support weekly monitoring Upload a live case list, calculate milestone dates, and review which complaints need action next.

Make handovers easier Export an Excel file with due dates, next actions, and status fields for easier review.

Reduce avoidable SLA misses Highlight 5 day, 20 day, 40 day, and overall milestone status more clearly than manual date counting.

Frequently asked questions

Helpful answers for teams using the complaint deadline tracker.

Which countries are supported? Right now the tracker supports UK and Ireland complaint handling timelines.

How are deadlines calculated? The tracker uses business day logic with fixed milestones for acknowledgement, 20 day update, and final response.

Can I include acknowledgement and update sent dates? Yes. Bulk upload accepts acknowledgement and 20 day update sent dates so SLA status can reflect what has already been sent.

What does the Excel export include? The export preserves the formatted complaint tracker layout, formulas, and status fields for weekly operational review.

Can I use this every week with a fresh complaint list? Yes. The workflow is designed for teams to upload a current list, review due dates and breaches, and export a usable Excel tracker.