Expiry Dates in a Spreadsheet: The Cost of Acting Too Late on Renewals

The tolerated pain: knowing the date but acting too late

Most businesses do know when things expire. There is a spreadsheet somewhere with a column headed "renewal date". It lists the company's annual return, the tax compliance status needed for a large customer's supplier file, the professional registrations of key staff, the website's security certificate, the insurance policy, the vehicle licences and the service contract on the generator. Someone opens it, usually when they remember to, and scans down the list.

The problem is not that the date is unknown. It is that the date is the wrong thing to watch. Almost every obligation needs lead time before the deadline: documents to gather, a return to file first, a payment to clear, an approval to obtain, a supplier to chase. A register that shows only the expiry date tells you when the trouble starts, not when the work must begin. By the time the date looks close on the sheet, the business is already late.

Mellorca has written separately about recurring tasks that live in someone's memory. This article looks at the next stage: businesses that have written their deadlines down, but still monitor them by hand, and still act too late.

Why businesses tolerate it

• The spreadsheet feels like control. Having a list looks responsible, so nobody asks whether the list actually triggers action.
• Most items come round once a year. Annual deadlines are easy to forget between cycles, and the person who handled the last one may have moved on.
• Ownership is split. Finance pays, operations uses, the director signs and an outside accountant or consultant may file. The register belongs to whoever created it.
• Near misses are invisible. A renewal done in a rush on the last day counts as a success, so the system is never questioned.

Where late action costs real money

Some South African obligations show clearly how a missed or late action turns into money and lost business.

Company annual returns

The Companies and Intellectual Property Commission (CIPC) states in its FAQs that companies have 30 business days from the date when annual returns become due to file before they are considered non-compliant, and that late filing results in penalties. More seriously, where returns remain outstanding CIPC may assume the company is inactive and start deregistration. A deregistered company loses its legal personality, and getting it restored takes time, fees and professional help, while contracts, bank relationships and tenders wait.

Tax compliance status

Customers, government departments and large corporates often check a supplier's tax compliance status before they pay or award work. SARS explains that its Tax Compliance Status system lets a taxpayer authorise a third party to view the status online with a PIN, and that the status shown is the position at the moment it is viewed. SARS lists outstanding returns, outstanding debt without a payment arrangement, missing registrations and outdated registered particulars as reasons for non-compliance. A business that tracks the "renewal" of a tax clearance letter on a spreadsheet misses the point: the status can turn red between checks, and it is often discovered when a customer's supplier-vetting process rejects the business.

Website security certificates

Technical renewals are moving faster. DigiCert reports that, under a CA/Browser Forum ballot adopted in April 2025, the maximum lifetime of public TLS certificates dropped to 200 days from 15 March 2026, falls to 100 days from March 2027 and reaches 47 days from March 2029. A certificate that used to be renewed once a year will soon need renewing about eight times a year. An expired certificate puts browser warnings in front of customers, can break online payments and stops integrations that call the website. Monitoring that by hand on a spreadsheet will not keep up.

Operational symptoms

• Renewals happen in the final week, with staff dropping other work to chase documents.
• A customer or tender portal rejects the business because a certificate, letter or status has lapsed.
• Penalties, reinstatement fees or interest appear in the accounts with no clear owner.
• The deadline register exists in more than one version, with different dates.
• Nobody can say, without checking, which obligations fall due in the next 90 days.
• Expiry is discovered by an outsider: a customer, a bank, an insurer or a browser warning.

How the pain becomes money

The cost of manual deadline monitoring comes through several routes at once:

• Direct penalties and fees: late-filing penalties, interest and reinstatement or reapplication costs.
• Revenue delay or loss: invoices held back by a customer's supplier-vetting check, or a tender that cannot be submitted because a compliance document has lapsed.
• Risk exposure: operating with a lapsed licence, registration or insurance cover.
• Rush cost: senior time pulled into last-minute recovery, and courier or professional fees for urgent work.
• Labour cost of the checking itself: someone has to open the sheet, read every line and decide what needs doing.

An illustrative cost model

The figures below are illustrative assumptions for an unnamed South African business with about 40 staff. They are not benchmarks. Replace them with your own numbers.

Checking the arithmetic: 1 × R350 × 48 = R16,800; 6 × 5 × R600 = R18,000; R400,000 × 11% × 30 ÷ 365 ≈ R3,616; and R16,800 + R18,000 + R3,616 + R8,000 ≈ R46,400.

The figure that matters most is not in the table. If a lapsed document costs the business one tender or one key customer, the loss is the margin on that work, which can be far larger than everything above. That is the number to estimate honestly for your own business.

When it becomes commercially urgent

Deadline monitoring needs attention when any of these are true:

• the business sells to government, large corporates or regulated customers who vet suppliers;
• a penalty or lapse has happened in the last year, even if it was fixed quickly;
• the register is maintained by one person, as described in our article on key-person dependency;
• the number of entities, sites, vehicles or staff registrations is growing;
• contract notice periods are being missed, a problem covered in supplier contracts renewing without review.

What better looks like

A good obligations register records, for each item, more than the expiry date:

1. Action start date: the date work must begin, worked back from the deadline using the real lead time.
2. Owner and deputy: a named person and a named backup.
3. Dependencies: what must happen first, such as filing a return before a compliance status can turn green.
4. Consequence: what happens if it lapses, so priorities are clear.
5. Evidence: where proof of renewal is stored.

The register then sends reminders to the owner automatically at the action start date and escalates to a manager if nothing is marked done. Status checks that can be automated, such as certificate expiry, should be monitored by tools rather than people, and certificate renewal itself should be automated where the provider supports it. This is ordinary business automation, not a large project.

Practical first steps

1. Collect every deadline list in the business into one register. Expect duplicates and disagreements.
2. Add a lead time and an action start date for each item. Ask the person who last did it how long it really took.
3. Assign an owner and a deputy. Remove any item nobody will own and decide whether it is still needed.
4. Move reminders out of personal calendars and into a shared tool that notifies the owner and escalates.
5. Check high-risk statuses, such as tax compliance and company registration, on a fixed monthly routine rather than only at renewal.
6. Review the register each quarter and record every near miss as a lesson, not as a success.

Bottom line

A list of expiry dates is a record, not a control. The money lost to missed obligations rarely comes from not knowing the date. It comes from starting too late, with nobody clearly responsible and no prompt to act. Moving from manual checking to lead-time reminders with named owners is cheap. The alternative is paying penalties, losing work and fixing problems in a rush.

Sources and further reading

• FAQs - CIPC (last verified 10 October 2026)
• Manage your Tax Compliance Status - South African Revenue Service (last verified 10 October 2026)
• TLS Certificate Lifetimes Will Officially Reduce to 47 Days (last verified 10 October 2026)

Related Mellorca reading

• Rebuilding the Same Report Every Month: The Labour Cost of Manual Reporting
• Creating the Same Documents by Hand: The Labour Cost of Repeat Paperwork
• The Payroll Cost of Work Software Could Do Automatically