It starts innocently enough. An email arrives at 4:57 p.m. on a Friday—because of course it does. It gets flagged. Or maybe it doesn’t. It’s forwarded to legal. Or communications. Or both. Somewhere in the shuffle, details get missed. Attachments are overlooked. A reply goes out asking for clarification… and the countdown doesn’t stop.

Email was never designed to be a records management system. We all know that. Yet here we are.

Spreadsheets feel reassuring. Columns. Rows. Filters. It looks organized. Until it isn’t.

One version saved locally. Another shared in Teams. A third emailed around with “FINAL_v3_REALLYFINAL.xlsx” in the file name. Who updated what? When? Good question.

And when the volume creeps up—because it always does—the spreadsheet becomes less of a tracking tool and more of a liability. Cells go blank. Deadlines slip. It happens.

Here’s the part that keeps people up at night.

FOIA deadlines aren’t suggestions. They’re statutory. There’s no “we’ll get to it next week.” When requests are scattered across inboxes and spreadsheets, it becomes far too easy for one to fall through the cracks. Not intentionally. Just… humanly.

One missed deadline can mean escalations, complaints, reputational damage. In today’s climate, where transparency is front and center and public scrutiny is sharp—sometimes unforgiving—that’s not a small thing.

If someone asks, “Who approved this redaction?” you should be able to answer instantly.

Instead, what often happens? You scroll through email chains. You search old notes. You piece together the story from fragments. It’s detective work, and not the fun kind.

Without a centralized system, there’s no reliable audit trail. No definitive record of who reviewed what, when it was modified, why a decision was made. That’s risky. And frankly, exhausting.

Every department has its own way of doing things. Some of that’s healthy. Some of it creates chaos.

One request gets routed to legal first. Another goes to policy. A third sits in someone’s queue because they’re on leave and no one else realized it was theirs. Approvals happen via email in one case, verbally in another. It’s inconsistent. Which means it’s unpredictable.

And unpredictability is the enemy of compliance.

Managing exemptions isn’t just a technical task—it’s nuanced. It requires careful judgment. Documentation. Consistency.

When supporting documents live in separate systems—or worse, on individual desktops—tracking redactions and exemption decisions becomes fragmented. Was that exemption applied before? Was it justified the same way? Is the language consistent?

Without a cohesive process, every request feels like starting from scratch.

At some point, someone will ask for metrics. They always do.

“How many FOIA requests did we receive this quarter?”
“What’s our average response time?”
“Which categories are increasing?”

If your data lives across spreadsheets and inboxes, producing accurate reports can take hours. Sometimes days. And even then, you’re hoping the numbers line up.

It’s not that agencies lack effort. Far from it. The teams handling FOIA requests are often meticulous, dedicated, and stretched thin. The issue isn’t commitment. It’s infrastructure.

At the end of the day—when the emails are still coming in and the spreadsheet is open on monitor two—it becomes clear.

Your agency needs FOIA request tracking software that centralizes and automates the entire lifecycle.