Nonprofit Transparency · Public-Interest Data

Tools for nonprofit insight

Essential resources to enhance transparency and understanding within the nonprofit sector — the data, the tools, and the math left in.

Transparency in social services

NoProfits.org is dedicated to promoting transparency and accountability in social services, ensuring that resources intended for community assistance reach those in need efficiently and equitably.

We work to connect people with verified service providers while advocating for responsible stewardship of public and private funding in the social services sector.

Resources

Red flags to watch

  • Excessive admin costs

    Compare admin expenses to program spending.

  • Unclear financial reporting

    Look for detailed breakdowns of spending.

  • Related party transactions

    Check for conflicts of interest in Form 990.

  • High executive compensation

    Compare to similar organizations' reporting.

How to research

  • Start with Form 990

    Review Part III for program details.

  • Check multiple years

    Look for patterns and changes over time.

  • Compare organizations

    Use similar-sized nonprofits as benchmarks.

Financial metrics for non-profits

Understanding the financial health of a non-profit is crucial. These metrics can be derived from the IRS Form 990.

Key metrics

  • Program Expense Ratio  (Program Service Expenses / Total Expenses) × 100 990 Data: Program Service Expenses (Part IX, line 24, col B), Total Expenses (Part IX, line 25, col A)
  • Administrative Expense Ratio  (Management & General / Total Expenses) × 100 990 Data: Management & General (Part IX, line 24, col A), Total Expenses (Part IX, line 25, col A)
  • Fundraising Efficiency Ratio  (Fundraising Expenses / Contributions) × 100 990 Data: Fundraising Expenses (Part IX, line 24, col D), Contributions (Part VIII, line 1a)
  • Current Ratio  (Current Assets / Current Liabilities) 990 Data: Current Assets (Part X, Lines 1–6 sum), Current Liabilities (Part X, Lines 18–22 sum)
  • Operating Reserve Ratio  (Unrestricted Net Assets / (Total Expenses / 12)) 990 Data: Unrestricted Net Assets (Part X, line 30, col A), Total Expenses (Part IX, line 25, col A)

Analyzing these metrics over time and comparing them to benchmarks provides valuable insights.

Blog

Field notes on nonprofit data, automation, and the command line — published at blog.noprofits.org.

Latest RECENT POSTS

Loading recent posts…

All posts →
Curriculum Vitae

Peter Johnston, PhD

Project & Operations Coordinator — AEC · Office Technology

Seattle, WA pvjohnst@gmail.com github.com/noprofits-org

Download PDF

Construction project coordinator with a research scientist's rigor and a builder's instinct for process improvement. I coordinate subcontractors, suppliers, materials procurement, scheduling, and client communication across dozens of concurrent jobs in the insurance-restoration and custom-build space — and I build the systems that make that coordination faster and more accurate. I pair advanced spreadsheet and document-automation skills with AI-assisted tooling to turn repetitive tasks into reliable systems, comfortable both running an AEC office day to day and improving the technology that runs it.

Core Competencies

Operations & Coordination

Project coordination across concurrent jobs · subcontractor & vendor coordination · materials procurement and order tracking · scheduling and milestone management · records management and document control · client communication.

Documentation & Productivity

Advanced spreadsheet modeling (formulas, pivots, cost & markup analysis, data validation, external data connections) · templated document generation · database creation & reporting · Google Workspace power user (Sheets, Docs, Apps Script) and equivalent MS Office workflows · Adobe Creative Cloud (20+ years).

Process Improvement & Automation

Spotting manual bottlenecks and building systems to remove them · workflow design · document-generation automation · procurement reconciliation · AI-assisted tool development · self-directed process projects from idea to rollout.

Industry Knowledge

Insurance restoration · subcontractor scoping & competitive bidding · finishing-materials selection and allowances · Xactimate estimate workflows · construction procurement and supplier relationships.

Experience

Grey Wolfe Construction — Project Coordinator

Jan 2026 – Present · Seattle, WA

Coordinate insurance-restoration and custom-build projects end to end while continuously building the internal systems that run the office.

  • Coordinate dozens of concurrent construction projects — subcontractor and supplier coordination, scheduling, materials procurement, document control, and client communication.
  • Led the design and rollout of the company's project-tracking system: a suite of six connected applications that replaced scattered spreadsheets with a single live source of truth for job status, schedules, and materials — used daily by field crews, the warehouse, and office staff.
  • Automated the office's document production — finishing-materials selection letters, subcontractor scope-of-work and competitive-bid packages, supplier quote requests, and client letters generated directly from job data — cutting routine paperwork from hours to minutes.
  • Built a procurement reconciliation dashboard that matches supplier orders against deliveries and flags discrepancies and outstanding materials by dollar value, tightening cost control across active jobs.
  • Standardized subcontractor scoping and competitive bidding across trades (electrical, plumbing, flooring, gutters, roofing, and more), with margin targets built into the cost analysis.

Freelance Administrative Consultant

2020 – Present · Seattle, WA

Developed office solutions while expanding technical expertise through self-directed learning and real-world projects.

  • Created dynamic spreadsheets connecting to external data sources, eliminating manual data entry.
  • Built custom expense-tracking and reporting systems using Google Apps Script.
  • Designed and produced a professional 28-page monthly newsletter reaching 1,000+ readers.
  • Developed web-based tools for data collection and organization for nonprofit organizations.

Grace Connection Services — Executive Assistant

Sep – Oct 2024 · Marysville, WA
  • Provided administrative support to executive leadership; managed complex schedules and stakeholder communications.
  • Created digital expense-tracking systems in Google Sheets; managed payroll and authored training SOPs.

Amazon — Classification Specialist

2017 – 2018 · Seattle, WA
  • Managed complex product-classification databases; developed search logic for hazardous-materials classification.
  • Created SQL queries for data retrieval and reporting; built tracking systems to monitor classification accuracy; advised on DOT/GHS compliance.

HMS Productions — Technical Designer

1995 – 2004 · New York, NY
  • Created print catalogs, marketing materials, and early web graphics for fashion-industry clients on tight deadlines.

Community Service Roles

2024 – 2025 · Seattle, WA
  • Newsletter Editor (Seattle Intergroup) · Web Developer (Hunger Intervention Program — WordPress redesign + web-enabled cold-storage sensors) · Driver (Operation Nightwatch) · meal service (Senior Meals Program).

Education

Research & Publications

11 peer-reviewed publications, 320+ citations in materials chemistry & photonics (2014–2017) — Journal of Materials Chemistry C, Applied Physics Letters, Journal of Lightwave Technology, Optics Express, and others.

Built in Public

The systems thinking above isn't just on the job — these are live, open-source tools I build and run. Working proof, one click away.

Contact

peter@noprofits.org