Looking for a Better Way to Manage Your Public Records Requests?

When your request volume starts to increase, how can you make sure no requests fall through the cracks? Many state and local governments start with a simple spreadsheet to track public records requests like the one available for download here.  At GovQA, we’ve seen hundreds of spreadsheets like these – some better than others.  We’ve compiled the elements that worked best for our customers (before their volume and complexity required our more robust solution).  We hope this template is helpful, and when the volume or complexity of your requests outgrow this template, give us a call to learn more about our automated platform.

Learn More

It’s Easy to Get Started

Download our free public records request tracking spreadsheet to help you log and track requests.

After downloading, submit any feedback or recommendations to peers@govqa.com.

1

Download the free template
2

Enter each of your requests into the spreadsheet, along with date received and requester information
3

Calculate the initial and final response deadlines (per your state laws) and enter these in green
4

Determine if a request will require redaction or legal review and enter these milestones into the spreadsheet

Using the Spreadsheet: Best Practices

The processing columns of the template are where you’ll do most of your tracking.  Update the status of each request as it changes.  When a request is completed, use color-coding and the strikethrough tool to simplify your view.

Spreadsheet to Track Public Records Requests Screenshot
  • Make it a habit to open this spreadsheet and update each request daily or more frequently as needed.
  • Change the date colors to red when requests are nearing or past due.
  • Use the processing columns to enter the current responsible party and notes as well as materials and time fees (where applicable).
  • When requests are complete, use the strikethrough tool to show at a glance that these are done.
  • Move completed requests to the “Logged Requests” worksheet for easier reporting if desired.

Upgrading to Automated Workflows 

Manually tracking complex, voluminous public records requests is stressful.  When spreadsheets just aren’t working for you anymore, GovQA offers a better way to stay compliant and avoid litigation.  Here’s how GovQA can help:

A public portal simplifies intake with deflection technologies to allow citizens, journalists, and other government agencies to self-serve.  If they find what they need on the portal, you avoid creation of an official public records request.  When this happens, request volume goes down!  If the request is submitted anyway, GovQA’s automated workflows make processing easy.

An admin portal simplifies request clarification with templates, which allows linking of duplicates to be processed together, automatically routes requests internally, and makes time and materials estimates a breeze.

GovQA automates delegation of information gathering tasks from backend systems (with no file size limitations).  Reminders and notifications keep everyone on time, plus, you can securely transfer files between anyone inside our outside your organization while generating an audit trail every step of the way.

Powerful in-tool redaction provides an unbroken audit trail and makes it easy to perform text searches and pattern matching with annotations to hide sensitive data and a full exemption log.

Configurable templates ensure consistent responses and help securely release files back to the public portal with no file size limitations.  You can also get alerts when responses are received and viewed.

Dashboards and a robust reporting suite ensure you have all the data you need when you need it.

See GovQA In Action

Interested in how GovQA can help you reduce request volume? Contact GovQA for more information about our Deflection technology today!

Request Demo

Looking for a simpler way to reduce duplicate request volume? Click the train tracks to learn more about our patent-pending deflection technology or click here.