How to Report Patron Counts by County for Grant Applications - Sat - Jul 11, 2026 - 9:44am

Dawn Green
Updated: Sat - Jul 11, 2026 - 9:44am ⚬ 0 Comments Reports
---
Many arts organizations apply for grants that require reporting how many patrons they serve in each county. Funders like state arts councils, community foundations, and the NEA often ask for this data to understand your organization's geographic reach.


The good news: you don't need to collect county information at checkout. Every patron already provides a ZIP code with their billing address, and ZIP codes can be reliably converted to counties using a free federal data source. This is the standard method used in grant reporting nationwide, and funders are very familiar with it.

Why we don't ask patrons for their county


Every additional required field at checkout measurably increases cart abandonment, especially on mobile devices. A required dropdown with dozens of county options would slow down every purchase, all year long, to serve a report most organizations only need once a year. Deriving counties from ZIP codes gives you the same data (arguably better data, since it comes from verified billing addresses) with zero added friction for your patrons.

The method: ZIP to county conversion


The U.S. Department of Housing and Urban Development, together with USPS, publishes an official ZIP-County Crosswalk that assigns every active ZIP code in the country to its county. About 90 percent of ZIP codes fall entirely within a single county. For ZIPs that cross county lines, the standard practice is to assign the ZIP to the county containing the largest share of its residential addresses.


We've packaged this into a ready-to-use spreadsheet, attached to this article, so you never have to touch the raw government data.



Step-by-step


1. Export your customers from ThunderTix. Run a customer export that includes the billing ZIP code, filtered to purchases in your reporting period (for example, the last 12 months).
   
   
2. Open the attached spreadsheet and go to the "Paste Data Here" tab. Delete the example row, then paste your ZIP codes into the yellow column A.
   
   
3. Read your results. Counties fill in automatically. The "County Counts" tab shows how many customers you have in each county, along with a summary of how many ZIPs matched. Sort the Customers column largest to smallest and your grant table is done.
   
   
The spreadsheet automatically handles the common data quirks:


• ZIP codes that lost a leading zero in Excel (like 6510 instead of 06510) are repaired
• ZIP+4 entries like 78701-1234 are trimmed to the 5-digit ZIP
• Blank rows are ignored, and anything unrecognized is flagged "Not found" so you can review it

Methodology language for your grant narrative


Funders sometimes ask how geographic data was derived. You're welcome to paste this directly into your application:


Patron counties were derived from customer billing ZIP codes using the U.S. Department of Housing and Urban Development's HUD-USPS ZIP Code Crosswalk (ZIP-County file), available at huduser.gov. Each ZIP code was assigned to the single county containing the largest share of that ZIP's residential addresses.



Frequently asked questions


How accurate is this? 
Very. Roughly 90 percent of ZIP codes sit entirely within one county. For the remainder, assigning the dominant county introduces only a small margin of error, and for a typical venue whose audience clusters in one metro area, the effect on your totals is negligible. This is the accepted standard for federal and state grant reporting.


Does this work outside the 50 states? 
Yes. The lookup covers all active U.S. ZIP codes, including DC and U.S. territories. Puerto Rico ZIPs map to municipios, which is the county equivalent used in federal reporting.


Can I count each customer only once? 
The tool counts each row you paste. If your export contains one row per customer, you'll get unique customer counts. If it contains one row per order, you'll get order counts by county, which some funders also accept. Choose the export that matches what your funder asks for.


What if some ZIPs show "Not found"? 
These are usually typos or foreign postal codes. The summary at the top of the County Counts tab tells you how many there are so you can review them. A handful of unmatched ZIPs won't meaningfully affect your report.


Do I need to update the spreadsheet each year? 
No. County boundaries change extremely rarely, so the same spreadsheet will stay accurate year after year. Just paste in a fresh export each grant season.


If you have questions or run into trouble with your export, reach out to our support team. We're happy to help you get your grant report across the finish line.

• Sign up today and start selling tickets Login