Modules › Reports and Queries
Every data point in your union database,
reportable in minutes
eMembership includes dozens of built-in reports for union administration, plus a self-service Query Builder that lets staff pull any combination of data from the system without writing code. Results export directly to Excel, and if you would rather not build a query yourself, our team can build it for you.
Book an Intro Call
Dozens
Built-in union administration reports
Every field
Reportable through the Query Builder
Excel
All results export instantly
Built-in Reports
Organized by area, ready to run,
Organized by area, ready to run,
exports straight to Excel
eMembership ships with a full library of reports covering members, finance, employers, organizing, and more. Run any report with date filters and export the results with one click.
Dues Collections
★ Add to Favorites
Query Builder
Build any report without
Build any report without
writing a line of code
The Query Builder lets staff select columns, set filters, and save reusable queries. Advanced users can drop into SQL directly. Results export to Excel in one click. And you are never on your own with it: our team can build a query for you and save it to your library, so the staff who run it only have to click.
Query: Members Missing Email
★ Add to Favorites
Built-in report library
Dozens of pre-built reports organized by area: member records, dues and finance, employer remittances, organizing activity, grievances, and more. Each report supports date and filter parameters and exports to Excel.
Checkbox-driven Query Builder
Build a custom report by selecting columns and setting filter criteria using checkboxes and picklists. No programming knowledge required. And because queries are saved by name, one person builds it once and everyone else just clicks to run it.
SQL for advanced users
Staff who need more complex queries can write or edit native SQL directly. Start with the checkbox interface and convert to SQL to refine further, or write from scratch with table and column references displayed alongside the editor.
Included With Your Subscription
You do not have to build it yourself,
You do not have to build it yourself,
and you do not have to figure it out alone
Self-service reporting only helps if your staff can actually use it. Onboarding training, ongoing support hours, and a named team come with your annual subscription, so the Query Builder is never the only way to get a report out of eMembership.
Training before you go live
Onboarding training is scheduled in short sessions so your staff learn the report library and the Query Builder on your own data rather than on a demo. Refresher sessions are available after go-live.
Ask us to build it
Send us the question you need answered and our team can build the query and save it to your library, using the operational support hours included in your subscription. Larger or ongoing custom report development is scoped as a separate project.
A named team, not a queue
Every union on the platform has an assigned Project Manager and Account Manager, with written response commitments that run from a general question through to a system-down issue.
Module Capabilities
Everything your union needs
Everything your union needs
to get data out of eMembership
Built-in reports cover the most common union administration needs. The Query Builder handles everything else, including custom requirements confirmed during Discovery. And when a query is more complicated than your staff want to take on, our team can build it for you using the support hours included in your subscription.
Membership reports
Membership Listing, Status Change History, Available For Work, Member Account History, and Membership Card Generation are included out of the box. Date ranges and filter parameters are available on each report.
Finance and dues reports
Dues Collections, Check Register, Chapter Payment History, Posted Payments, Employer Receipts, and Employer Remittances. Each finance report includes grouping by chapter, employer, or date period.
Saved and reusable queries
One person builds the query once and everyone else just clicks to run it. Saved queries are named and can stay private, be shared with specific users, or be published to the entire organization, and they run straight from the search page with no setup required. Staff who never open the Query Builder still get the report they need.
Query parameters
Add parameters to saved queries so staff can narrow the results at runtime without editing the query itself. Instead of pulling every member and filtering in Excel, run one saved query for members in arrears more than 60 days in a single chapter, then change the chapter or the date range and run it again.
Query directories
Organize saved queries into named directories. Unions with many staff members and reporting needs can group queries by department, purpose, or workflow to make them easier to find and share across the organization.
Reports we build for you
Any reporting requirement the built-in library and the Query Builder cannot cover is documented during Discovery and built by our development team as part of your implementation. After go-live, our team can build queries and adjust reports for you using the operational support hours included in your subscription. Larger or ongoing custom report development is scoped as a separate project.
Security, Hosting, and Infrastructure
Reporting moves member data.
Reporting moves member data.
It stays protected on the way out.
Reports and queries reach real member records, so who can run what matters as much as what the reports can do. Everything behind them runs in Winmill's own data center, included for every labor union on the platform.
Access granted by role
Functional access is granted by role on a least-privilege basis, so staff only run reports against the data their job requires. Saved queries carry their own visibility setting and can stay private, go to named users, or be published to the organization.
Encrypted, backed up, monitored
Data is encrypted in transit, and sensitive member data including Social Security Numbers is encrypted at rest. Backups run nightly to encrypted offsite storage, and network, database, and application activity is monitored around the clock.
Audited to recognized standards
The environment is covered by SOC 1, SOC 2, HIPAA, ISO 27001, and PCI DSS. Independent penetration testing runs twice a year, vulnerability scanning is continuous, and detailed audit documentation is available on request. See the full Security and Data Center overview.
Questions about union
administration reports in eMembership
eMembership includes dozens of reports organized by area. Member reports cover Membership Listing, Status Change History, Available For Work, Member Account History, and Membership Card Generation. Finance reports include Dues Collections, Check Register, Chapter Payment History, Posted Payments, and Employer Receipts. Additional reports cover employers, organizing activity, grievances, and political. Any custom reporting requirement confirmed during Discovery can also be added as part of your implementation scope.
No. The Query Builder uses a checkbox and picklist interface that any staff member can learn quickly. You select which columns to include, set filter conditions using plain-language operators (equals, not equals, greater than, in a list, is null), and run the query. The results export directly to Excel. Staff who are comfortable with SQL can also write or edit queries directly, but it is not required. Most staff are running their own queries after onboarding training. More complex queries take longer to get comfortable with, and you are not on your own with those: our team can build a query for you and save it to your library, so staff who would rather not use the builder can simply run it.
Yes. Every query is saved by name and can be run again directly from the Query Builder search page without rebuilding it. Queries can be private to the user who created them, shared with specific staff members, or made available to the entire organization. Directories help organize queries when you have many saved. Parameters can also be added to saved queries so staff can specify date ranges or other filter values at runtime.
Yes, and unions use us this way regularly. Send us the question you need answered and our team can build the query, save it to your library under a name your staff will recognize, and walk you through how it works so you can adjust it later. Routine query work is covered by the operational support hours included in your annual subscription. Larger or ongoing custom report development is scoped as a separate project, and we will tell you up front when a request falls into that category rather than after the fact.
Yes. Onboarding training happens before go-live in short sessions, and refresher training is available afterward through the support hours included in your subscription. Unions commonly schedule a session when a new staff member joins, when a reporting need changes, or when someone wants to move from running saved queries to building their own.
Both built-in reports and Query Builder results export to Excel with a single click. The Excel file contains the full result set and can be refined, filtered, or shared outside of eMembership. This makes it easy for staff to work with data in the tools they already use for analysis and distribution.
The Query Builder provides access to every data point in the eMembership database, organized by category: member records, member addresses, chapter assignments, member attributes, contact info, financial data, work history, skills, grievances, organizing activity, and more. Each category expands to show all available columns, which can be included or excluded from the query result.
Yes. Custom reporting requirements are documented during the Discovery process and included in your implementation scope. Winmill's development team builds any report that cannot be satisfied by the built-in library or the Query Builder. Custom reports become part of your report menu and function the same as built-in reports, including date parameters and Excel export.
Functional access is granted by role on a least-privilege basis, so a staff member can only run reports and queries against the data their role permits. Saved queries carry their own visibility setting as well, and can be kept private, shared with named users, or published to the organization. Data is encrypted in transit, sensitive member data including Social Security Numbers is encrypted at rest, and multi-factor authentication is available to every client. Full detail is on our Security and Data Center page.
Dozens of built-in reports across all areas
Self-service Query Builder, plus a team that can build queries for you
All results export directly to Excel
Custom reports available through Discovery
See eMembership reporting
for your union's data
Start with a short intro call. We will walk through the report library, show the Query Builder in action, and learn about your union's current reporting requirements.
Book an Intro Call