GAT Solutions logoGAT SolutionsBook a call
Menu

Salesforce Consulting for Nonprofits

Salesforce consulting for nonprofits that run programs: registration, cohorts and attendance, gifts and grants, clean data loads and reports funders ask for.

What we build for nonprofits that run programs

We build the program side of Salesforce the way a nonprofit runs it: a registration portal where a family finds itself before it registers, households, schools, cohorts and enrollments by term, attendance and alumni status, and the gifts, fees, sponsors and grants that pay for it all. Then the outcome reports funders ask for, on totals that recount every night. If your org already exists, we start by drawing how it works, then load the program data kept in spreadsheets without adding anyone twice. The diagrams further down come from that work for Center for Leadership Development, a youth leadership nonprofit on Nonprofit Cloud.

  • MappedHow the org works, drawn from the org itself in pictures staff can follow.
  • MatchedEvery person in a program load matched to a record already there before anything is added.
  • Handed overA checklist, a template sheet and the steps written down, so your admin runs the next load.

What we build for nonprofit teams

Real systems, grouped by how a program nonprofit works: enroll families, deliver the program, fund it, then run it and report on it. Each one ships on its own and connects to the rest.

  1. Enroll families
  2. Deliver the program
  3. Fund it
  4. Run it and report on it

Enroll families

From the program link, or last year's spreadsheet, to a family in a cohort, with each person in Salesforce once.

  • Program registration portal

    A parent registers a student from the program link, finds the family already on file, and the enrollment, cohort spot and fee reach Salesforce without staff retyping a form.

    • Find yourself first, so no family is added twice
    • One form for the student, each parent or guardian and any supportive adult
    • Enrollment and cohort created together, with the fee paid online when one is due
    Experience CloudFlowProgram ManagementGoFundMe Pro
  • Households, parents and schools

    Staff open one student and see the household, each parent or guardian, the school and district, and every program the family has been part of.

    • Households built or reused at registration, never duplicated
    • Parent, guardian and supportive adult roles on each relationship
    • Schools and districts as accounts, with grade and graduation year kept on the student
    Nonprofit CloudPerson AccountsFlow
  • Cohorts and enrollments by term

    Each term opens with its own cohorts, and staff switch registration on or off per cohort instead of editing the form.

    • Programs with eligible grades, location and fee rules
    • A cohort per term, with registration switched on or off
    • Student and supportive adult enrollments linked to each other
    Program ManagementFlowReports
  • Program data loads from spreadsheets

    A term of sign-ups and sessions kept in spreadsheets lands on the people already in Salesforce, instead of creating a second copy of every family.

    • Each person matched by name and birth date, email or legacy id before anything is added
    • A new person added only when nothing matches, with look-alikes held for staff to decide
    • Rehearsed in a full sandbox, then run in Production and checked against reports
    Data LoaderFull sandboxProgram Management

    In productionRun for Center for Leadership Development: every person matched before anything was added, rehearsed in a full sandbox before Production.

Deliver the program

What happens between the first session and the last, recorded where the reports can find it.

  • Attendance, services and sessions

    Facilitators mark who came to each session, and the services each student received build up on the enrollment instead of on a paper sign-in sheet.

    • Services and sessions set up once for each program
    • Attendance marked per session, with the reason for an absence
    • Orientation and prerequisites tracked before the first session
    Program ManagementFlowSalesforce mobile app
  • Volunteer applications and clearance

    A volunteer applies once online, and staff see the background check, youth clearance and code of conduct before anyone is placed with students.

    • An online application with tutoring and facilitator interests
    • Background check, youth-interaction clearance and code of conduct tracked with dates
    • Only cleared volunteers offered for sessions
    Experience CloudFlowNonprofit Cloud
  • Alumni status and tracking

    A student who completes a program that grants it becomes an alum on the record, and staff can find alumni for the next program, a scholarship or an event.

    • Alumni status set when the enrollment is completed
    • Status checked after every data load, since loads can skip the automation
    • Alumni lists for next programs, scholarships and invitations
    FlowProgram ManagementReports

Fund it

Gifts, fees, sponsors and grants on the same records as the programs they pay for.

  • Donor and gift management

    Every gift, pledge and soft credit sits on the donor's record, so the thank-you, the receipt and next year's ask come from one place.

    • Gifts, pledges and recurring gifts, each with a designation
    • Soft credits and tributes for honor and memorial gifts
    • Anonymous donors kept anonymous in every report
    FundraisingNonprofit CloudAccount Engagement
  • Online giving and fees from GoFundMe Pro

    Donations and registration fees paid on GoFundMe Pro arrive in Salesforce as gifts, and a paid fee marks the student's enrollment paid.

    • Gifts and donors synced from each GoFundMe Pro campaign
    • Each registration fee linked to the student's enrollment
    • Fees that arrive without a match listed for staff to link
    GoFundMe ProFundraisingFlow
  • Event sponsorships

    The gala, golf classic and college fair each keep their sponsors, levels and payments in Salesforce, so next year's asks start from this year's list.

    • Sponsorship levels for each event on the sponsor's account
    • Commitments, payments and promised benefits tracked to the end
    • Last year's sponsors listed for renewal
    FundraisingCampaignsAccount Engagement
  • Grants calendar

    Every grant has its deadlines, requirements and reports due on one calendar with an owner, so nothing is found the week it is due.

    • Applications, awards and report dates on one calendar
    • Requirements and restrictions saved on the grant
    • Reminders to the owner before each report is due
    FundraisingFlowReports and dashboards

Run it and report on it

The numbers funders ask for, the org written down, and a safe way to change it.

  • Outcome and impact reports

    The numbers a funder asks for, such as who was served, how often and who completed, come from one report on totals that recount every night.

    • Participants served by program, term and school
    • Attendance and completion by cohort, as totals with no names
    • Roll-ups that recount every night, with a note to the admin when a run fails
    Reports and dashboardsData Processing EngineProgram Management
  • Documentation and safe releases

    Your admin knows how the org works and ships each change through a sandbox, so a fix for one program does not break registration for another.

    • How the org works, drawn and written down from the org itself
    • Changes built in a full sandbox, saved in git and shipped to Production by one press after sign-off
    • A checklist and template sheet so your admin runs the next data load
    Full sandboxGitHubSalesforce CLI

    In productionDrawn for Center for Leadership Development from the org itself, with a load checklist and template sheet for the admin. The diagrams on this page come from that work.

  • Claude or ChatGPT for staff questions

    Staff ask a plain question, such as which spring students still owe a fee, and get the answer from Salesforce with only the records their own login can see.

    • Signed in as the staff member, so their permissions and sharing apply
    • Read-only to start, with any change confirmed by a person first
    • Answers from live records, not an exported spreadsheet
    ClaudeChatGPTSalesforce MCPApexGenius

    Screens are drawn for illustration. None of them shows a client's org or a real participant.

    ★★★★★
    Gray and GAT were a pleasure to work with, knowledgeable about Salesforce and software development in general. They were able to complete client projects and always exceeded expectations. Would highly recommend them again!!!
    Michele Santagata, Santagata Consulting

    How Center for Leadership Development runs on Salesforce

    Center for Leadership Development (CLD) is a youth leadership nonprofit on Nonprofit Cloud: Program Management for programs, cohorts, enrollments and services, Fundraising for gifts, and a family registration portal on an Experience Cloud site. The org and the portal were already live when we started. We drew and wrote down how the org works, ran the program data load with every person matched before anything was added, and wrote the checklist and template sheet the admin uses for the next load. The release path in the last diagram is the one we are setting up for the org. These six diagrams were drawn from CLD’s org during the engagement, with staff names removed and no participant data in any of them.

    Diagram of how CLD runs on Salesforce: families and students, the CLD portal, Salesforce records, nightly roll-ups, then reports and alumni lists, with staff edits, data uploads and fees and gifts also writing to the records
    The org at a glanceFamilies register on the portal, the records land in Salesforce, roll-ups recount every night, and staff work from reports and alumni lists. Staff edits, data uploads and fees also write to the same records.
    Diagram of the data model: parent or guardian, household and school linked to a person, the person's enrollment linked to cohort member, cohort and program, with services received, each session, services offered and fee payment
    What is in the orgPeople, households and schools on one side. Enrollments, cohorts and programs on the other. Services and sessions hang off the enrollment.
    Diagram of portal registration: program page link, find yourself, registration form, enrollment and cohort, a check on whether a fee is due, pay on GoFundMe Pro, registration complete
    How a family registersFrom the program link to finding yourself, the registration form, the enrollment and cohort, and the fee on GoFundMe Pro when one is due.
    Diagram of what happens after registration: enrolled in a cohort, gets services, program ends, a check on whether the program grants alumni, alumni status, then next programs and scholarships
    After someone registersEnrolled in a cohort, gets services, the program ends, and a flow sets alumni status when the program grants it. Data loads skip that flow, so alumni status is set by hand after a load.
    Diagram of the load plan: files from the client, map the columns, match each person by name and birth date, email or legacy id, add a new person only when there is no match, load enrollments and cohorts, then check and fix alumni
    The load, step by stepMatch by name and birth date, by email, and by the id from the old system. Add a new person only when nothing matches. Load enrollments and cohorts, then check alumni and let the roll-ups recount overnight.
    Diagram of the release pipeline: build it in the full sandbox, check it works, copy it to a branch, press Ship to Production, the release robot deploys it, live in Production, with a nightly sync that saves the admin's Production edits in git
    One path for every changeThe path we are setting up for the org: the release robot deploys only the files that changed and runs only their tests. Data loads stay their own step: rehearse in the full sandbox, then run in Production.

    AI on a nonprofit org

    Staff can ask Claude or ChatGPT about programs, families and gifts, signed in as themselves, so an answer holds only what their login can see. These pages cover how we connect them.

    • Claude and SalesforceConnecting Claude to Salesforce through MCP: setup steps, security and costs.
    • ChatGPT and SalesforceConnecting ChatGPT to Salesforce through MCP, with the connected user's permissions applied.
    • ApexGeniusThe Salesforce MCP product we build and run. It keeps your apps, skills and memory in one connection, so your whole setup goes with you from agent to agent.

    Works with

    Go deeper

    Questions

    Do you work with Nonprofit Cloud?

    Yes. The diagrams on this page come from an org on Nonprofit Cloud, with Program Management for programs, cohorts, enrollments and services, and Fundraising for gifts.

    Can you load our program data without creating duplicates?

    That is what the load plan is for. Each person is matched by name and birth date, by email and by the id from the old system before anything is added, and the load is rehearsed in a full sandbox first. Look-alikes that could be the same person are held for your staff to decide.

    Will our own admin be able to run it afterwards?

    Yes. We write a checklist and a template sheet for each kind of load, and your admin runs the next one with us beside them, so they can repeat it. The steps stay with your team as documents and diagrams.

    Does participant data leave Salesforce?

    The diagrams and documents carry counts only. They hold no participant names or records.

    Can you build a registration portal for families?

    Yes, on Experience Cloud. The family finds itself first so nobody is added twice, then one form creates the household, the enrollment, the cohort spot and the fee when one is due. If you already have a portal, we draw how it works today and test the whole path in a sandbox before changing it.

    Do you connect GoFundMe Pro and other giving tools?

    Yes. The org in the diagrams takes donations and registration fees through GoFundMe Pro's Salesforce package, so we know where those payments land. When we connect giving, each fee is linked to the student's enrollment, and payments that arrive without a match go on a list for staff to fix.

    Can staff use Claude or ChatGPT with our Salesforce data?

    Yes, with care. The assistant signs in as the staff member, so it sees only what that login can see, and we start read-only. The records a question needs are sent to the assistant to answer it, so we agree with you which objects it may read before anyone connects.

    Book a call, or tell us where your data lives today.

    Prefer to talk it through?

    Pick a 30-minute time with Gray. Bring the spreadsheet or the report nobody trusts.

    Loading available times…