Templates › Forms › SEO page

Run: FOIA Annual Report Data Compilation Worksheet

Compile the data needed for an agency FOIA annual report in one worksheet. Capture request volume, backlog, processing time, exemptions, fees, and certificat...

Fill this out, get a PDF emailed to you. No account required. Want to run it with your team and track results? Sign up free →

Reporting Period and Submitter

Reporting year (required)

Enter the calendar year covered by this annual FOIA report.

Office or component name (required)

Name of the office, component, or program submitting the data.

Submitter name (required)

Name of the person compiling the worksheet for internal routing and follow-up.

Submitter email (required)

Work email address for questions about this submission.

Submission date (required)

Date the worksheet is completed and submitted.

Request Volume Summary

Total FOIA requests received (required)

Count all FOIA requests received during the reporting year.

Requests pending at start of year (required)

Number of requests carried over from the prior reporting year.

Requests closed during year (required)

Total requests closed during the reporting year.

Requests pending at end of year (required)

Number of requests still open at the end of the reporting year.

Requests for expedited processing

Count of requests where expedited processing was requested.

Backlog and Processing Time

Backlog at start of year (required)

Number of requests in backlog at the start of the reporting year.

Backlog at end of year (required)

Number of requests in backlog at the end of the reporting year.

Median processing time in days (required)

Median number of calendar days to process closed requests.

Average processing time in days

Average number of calendar days to process closed requests, if tracked.

Age of oldest pending request in days

Number of days the oldest open request has been pending at year-end.

Exemptions and Dispositions

Requests granted in full (required)

Number of requests granted in full.

Requests granted in part (required)

Number of requests granted in part.

Requests denied in full (required)

Number of requests denied in full.

Exemption categories used

Select the FOIA exemption categories applied during the reporting year.

Exemption notes

Optional notes explaining unusual exemption use, redaction trends, or reporting clarifications.

Fee and Administrative Data

Fee waiver requests received

Count of fee waiver requests received during the reporting year.

Fee waivers granted

Count of fee waiver requests granted.

Administrative appeals received

Count of FOIA administrative appeals received during the reporting year.

Administrative appeals closed

Count of FOIA administrative appeals closed during the reporting year.

Fee and administrative notes

Optional clarifications about fee calculations, appeal handling, or data sources used for the report.

Certification and Data Quality

Data source confirmed (required)

Confirm the figures were compiled from official FOIA tracking records and supporting reports.

Yes No N/A

Accuracy attestation (required)

I attest that the information provided is complete and accurate to the best of my knowledge.

Yes No N/A

Certification notes

Optional notes about data limitations, assumptions, or reconciliation issues.

Get your results

Enter your email — we'll send you a PDF of your filled-out template, plus the occasional MangoScoop newsletter (templates, workflow tips, product updates). Unsubscribe anytime — link is in every email.

Email (required)

Your name (optional)

Generated with MangoApps Templates — browse 250+ free