The spreadsheet is a tool that helps you identify the records that need actioning. Without an automated process to prompt and support that action, the records don't move. That gap between knowing what needs to happen and having a system that helps it happen, is where most retention backlogs come from.
Our earlier guide to building and maintaining a retention schedule in Excel walks through how to properly set up a retention spreadsheet for Victorian government agencies. But a spreadsheet-based approach presents process limitations that tend to emerge as the volume of records grows, staff turn over, and competing pressures on the records team increase.
Three process limitations of spreadsheet-based records retention management and how to overcome them
1. A spreadsheet is only as reliable as the data manually entered into it
A retention schedule in a spreadsheet depends entirely on the person who built it, and everyone who has touched it since. Retention periods, disposal triggers, and PROV authority references have to be researched and manually transposed into the file by the records manager. That’s the point where information gets forgotten, entered incorrectly, or drops out entirely.
The problem compounds over time. When a records officer leaves, the logic behind the spreadsheet often goes with them. Fields that were meaningful to one person become unclear to the next. Columns get repurposed, formulas get broken, and the spreadsheet that was once a reliable reference becomes a file that requires careful interpretation before it can be trusted.
Even in well-maintained spreadsheets, the manual transposition step carries inherent risk. A retention period entered from memory rather than confirmed against the current PROV authority. A disposal trigger recorded inconsistently across record classes. An update made to one row that should have been applied to twenty.
A spreadsheet is only as complete and reliable as the data someone manually put into it — and that manual entry process is where retention information quietly degrades.
The solution
A dedicated information management system holds records information in a structured, consistently formatted environment. Running a disposal or review report from an information management system (like Compu-Stor’s CIMS) is faster and more reliable than combing through a spreadsheet, because the holdings are already organised and searchable in one place — there are no formula errors to check, no missing fields to hunt for, no risk that a critical column was deleted at some point in the past.
For records that haven’t yet been sentenced — where the retention period, disposal trigger, and PROV authority haven’t been confirmed and recorded against each item — Compu-Stor can sentence those records on your behalf. The retention information is identified and input directly into CIMS in the correct format. You don’t have to manually research and transpose that information yourself, which is precisely where retention data tends to degrade in a spreadsheet over time.
2. Identifying disposal eligibility and acting on it are two entirely separate steps in the process
A retention schedule can flag that a record class is due for disposal. But acting on that flag — retrieving the records, reviewing them against the current authority, digitising where required, arranging certified destruction, and obtaining a certificate for the audit trail — is a separate and resource-intensive process that a spreadsheet can’t action.
For government agencies with physical records held in offsite storage, the distance between a disposal-eligible record on the register and a compliantly disposed record is significant. Disposal-eligible records are visible in the register. But coordinating what comes next requires time and internal capacity that isn’t always available. So the records stay, storage costs continue to climb, and the compliance exposure increases.
While a spreadsheet retention schedule can help you identify records eligible for disposal, the time and resources required to action those records means disposal tends to get deferred — and backlogs continue to grow.
The solution
A third-party information management system can close the gap between identification and action. When a records manager identifies a record class that has reached its authorised disposal date, a disposal request can be submitted directly through Compu-Stor’s CIMS portal. From there, Compu-Stor provides an authorisation listing the relevant records — including barcode and item description — for the records manager to review and sign off on. Once authorised, Compu-Stor carries out the certified physical destruction and returns a certificate of destruction for the agency’s records.
The records manager retains oversight and sign-off authority throughout. What they don’t have to do is coordinate the retrieval, physical handling, and destruction process internally — the request triggers the work, and the documentation follows.
3. The compliance trail for disposal decisions is manual
A spreadsheet can record what disposal decision was made, but recording who made it, when, on what authority, and whether the right checks were completed is an additional manual step. Technically, this can all be captured in separate columns against each record. In practice, it means manual data entry, additional time per record, and if a certificate of destruction needs to be linked — saving the document to the right location, copying a public link, and pasting it into the correct row in Excel. Each of those steps introduces opportunity for error or omission.
Under PROV’s records disposal framework, disposal must be authorised against an approved Retention and Disposal Authority (RDA), and agencies are expected to maintain evidence that the correct authority was applied and that disposal was carried out appropriately. A shared spreadsheet can store that evidence, but it doesn’t make the process of capturing it easy.
The compliance trail for a disposal decision is only as reliable as the manual process used to record it.
The solution
Compu-Stor’s CIMS captures key elements of the disposal trail automatically — who requested the destruction and who authorised it, with a timestamp against each action. Where records have been sentenced and that information is held in CIMS, the relevant retention and authority details are also available against the record. When an audit requires evidence of the disposal process, that documentation is already in the system rather than needing to be reconstructed from a spreadsheet or separate filing location.
Signs your process may have outgrown your spreadsheet
Some common themes we hear from government agencies that are ready for a more structured approach:
- Disposal-eligible records are visible in the register but haven’t been actioned
- The last formal review cycle was deferred or didn’t run to completion
- Retention decisions are not consistently documented against the authority used
- Physical records in storage aren’t all represented in the retention schedule
- Moving from disposal eligibility to certified destruction relies on having a quiet day to dedicate to it
- The logic behind the retention schedule lives in one person’s head — and that person may not be there forever
These are common patterns and a natural consequence of a process that relies on manual data entry, individual memory, and internal coordination across multiple steps. A third-party information management system doesn’t remove the complexity of records retention, but it can remove the friction that turns that complexity into a backlog.
What a dedicated information management portal can do for you
Compu-Stor’s CIMS portal gives you a single, structured view of your full records holdings — what is held, where, and the current disposal status of each record class. For agencies whose records have been sentenced by Compu-Stor, that view also includes the retention period, disposal trigger, and PROV authority against each item, held in a consistent format that’s searchable and reportable.
From the portal, you can run disposal and review reports, access digitised copies of records, submit retrieval requests for physical copies, and arrange disposal. Compu-Stor can manage the physical handling, certified destruction, and documentation at every step, with the authorisation and certificate of destruction captured in the system.
The retention management process becomes more reliable — not because the system removes every manual step, but because the information it holds is structured, consistent, and complete in a way that a spreadsheet maintained over years rarely is.
See what CIMS can do for you
If you’d like to understand how the CIMS portal could support your records retention program, we’re happy to walk through it. Learn more about Compu-Stor’s CIMS portal →
Compu-Stor’s PROV RDA Finder is a guided, interactive tool designed specifically for Victorian council records managers. Rather than downloading a schedule and working through the hierarchy manually, our Finder provides an interactive guide that allows you to manually click through Function, Activity and Class designations, or search based on a keyword.
For councils wanting to increase productivity, Compu-Stor provides a complete, PROV-compliant pathway from digitisation through to certified physical destruction, with full chain-of-custody documentation and a disposal certificate for your records. Get in touch to find out more.
The RDA Finder is designed to support retention decisions and should be used as a guide. For complex or edge-case record types, we recommend confirming the outcome with your Records Manager or contacting PROV directly.
This guide is intended as general guidance. For complex records or edge-case situations, we recommend confirming disposal decisions with your Records Manager or contacting PROV directly.
