KHIZHNYAKOV

← All templates

Electronic Signature and Certificate Tracker — Excel Template

Log of electronic signatures and certificates with a traffic light for expiry, a 90-day renewal plan, responsible persons and a summary. Keys and passwords are not stored.

Electronic Signature and Certificate Tracker — Excel Template
≈ $3.59
290 ₽
Blank template + filled-in example · Excel 2007+, LibreOffice, Google Sheets
Payment is processed securely by YooKassa in Russian rubles. If your card is declined, email us at info@хижняков.рф and we will arrange another way to pay.

What it is for

An electronic signature that has expired halts procurement, reporting and document flow, usually on the least convenient day. Here every signature is entered as a row: the spreadsheet shows which ones are expired and which expire within the next 30 days, and builds a renewal plan in order of expiry. Private keys, passwords and PIN codes are not stored in the spreadsheet: only the owner, the term, the certificate serial number and the token number.

What is inside

  • "Lists": signature and certificate types, systems (procurement portal, payment information system, e-budget, tax authority, government services, inter-agency exchange and others), responsible persons, certification authorities, the "warn N days ahead" setting and the plan horizon.
  • "Signatures": up to 300 signatures: owner, position, type, CA, serial number, issue and expiry dates, where it is used, token number, responsible person, a traffic-light status and days to expiry.
  • "Renewal plan": a list of signatures that are expired or expire within the next 90 days, in order of expiry, without duplicates and with a "what to do" hint. Built with formulas, without macros and without FILTER.
  • "Summary": signatures by status, by month of expiry, by responsible person and by system, two charts.

Who it is for

Accountants, procurement specialists, and HR, security and IT staff in public bodies and organizations, as well as small businesses where several people work with electronic signatures in different systems.

What you get

The package contains a blank spreadsheet and a filled-in sample with fictional data, so you can see how the formulas and checks work. It is a spreadsheet built on ordinary formulas, not accounting software. All fixes and new versions of the project are free.

Compatibility

Excel 2007 and later, LibreOffice. No macros. The file is in English. Thresholds and standard values are kept in the lists: check them against your local rules before use. The calculation is approximate.

📘 Electronic Signature and Certificate Expiry Tracker in Excel

Questions and answers

Does the spreadsheet store keys and passwords?
No, and you should not enter them. It holds only reference data: owner, position, signature type, certification authority, certificate serial number, terms and token number. Keep private keys on a secure device.
How does the spreadsheet decide that a signature is about to expire?
It calculates the difference between the expiry date and the reference date. If no more than the set number of days remain (30 by default), the status is "Expiring"; if the term has passed, it is "Expired". You can change the number of days on the "Lists" sheet.
How is the renewal plan built without the FILTER function?
A helper key is calculated for each signature: the expiry date plus the row number. The SMALL and MATCH functions pull out the keys in ascending order, so signatures with the same date are not duplicated. It works in Excel 2007 and later.
Where do I get the certificate validity terms?
From the certificate itself or from your certification authority's documents. Check the terms and renewal procedure against the current requirements and your CA's own regulations: they are not built into the spreadsheet.