NGO Fundraising Dashboard: Metrics for Leaders and Trustees

What an NGO Fundraising Dashboard Should Tell Leaders

An NGO fundraising dashboard should show whether the organisation is raising enough reliable money, from the right sources, at an acceptable cost, and with proper compliance. The most useful NGO fundraising dashboard metrics connect daily fundraising activity with trustee-level questions about sustainability, donor trust and programme delivery.

A dashboard is not simply a collection of charts. It is a decision tool. A fundraiser may need to know which campaign generated the most donations yesterday, while a trustee may need to know whether the organisation depends too heavily on one donor or whether restricted funds are being used correctly.

For Indian NGOs, the dashboard may need to combine data from UPI, bank transfers, payment gateways, cheque receipts, CSR contributions, grants, crowdfunding platforms and offline fundraising. It may also need to support receipts, 80G-related donor records, FCRA reporting where applicable, utilisation statements and audit preparation.

The right metrics depend on the NGO’s model. A community organisation funded mainly by individual donors should not use exactly the same dashboard as a research nonprofit receiving institutional grants. However, the underlying questions remain similar:

• How much money was raised?
• How much of it is usable for current work?
• Where did it come from?
• How much did it cost to raise?
• Are donors returning?
• Are fundraising activities producing enough value?
• Are records complete and compliant?
• What decisions should the leadership take next?

Start With Decisions, Not Charts

Before selecting metrics, list the decisions that leaders and trustees need to make. This prevents the dashboard from becoming a screen full of numbers that nobody uses.

A founder may need to decide whether to continue a paid digital campaign. A finance head may need to reconcile donations received through multiple bank accounts. A programme director may need to check whether a restricted grant has enough balance for planned activities. A trustee may want to understand whether the NGO is building a dependable donor base or surviving on occasional large contributions.

Questions for NGO leaders

A leadership dashboard can answer operational questions such as:

• Which campaigns need more attention this week?
• Which donation channels are producing completed payments rather than only enquiries?
• How many first-time donors have given again?
• Which appeals are attracting many small donations?
• Are donation receipts being issued and reconciled promptly?
• Are fundraising costs increasing without a corresponding increase in net funds?
• Which grant applications, renewals or reporting deadlines are approaching?

These questions usually require more detailed data than a trustee dashboard. Leaders may need daily or weekly views, campaign filters and donor segments.

Questions for trustees

Trustees generally need a higher-level view:

• What percentage of income comes from the largest donors or grants?
• Is unrestricted income sufficient to cover core operations?
• Are restricted funds clearly separated from general donations?
• Is the fundraising pipeline strong enough for the next financial period?
• Are donor retention and repeat giving improving or weakening?
• Are there unusual refunds, failed transactions or unexplained variances?
• Are fundraising activities consistent with the NGO’s objectives and legal obligations?

The trustee view should not be overloaded with every transaction. It should show trends, exceptions, concentration risks and decisions requiring oversight.

A practical dashboard hierarchy

A useful arrangement is to create three layers:

All three layers should use consistent definitions. If “active donor”, “net funds raised” or “campaign cost” means something different in different reports, leadership discussions will become unreliable.

Core NGO Fundraising Dashboard Metrics

A fundraising dashboard should begin with a small set of core metrics. More metrics can be added later, but the first version should make the financial position understandable within a few minutes.

Gross funds raised

Gross funds raised is the total value of donations, grants, sponsorships and other fundraising income recorded during a selected period, before refunds, payment charges and fundraising expenses.

This number is useful for tracking activity, but it can be misleading if shown alone. A campaign may collect a large amount while also generating high costs or restricted income that cannot be used for general operations.

Always allow users to filter gross funds raised by:

• Date or financial year
• Campaign
• Donor type
• Funding source
• Geography
• Restricted or unrestricted purpose
• Payment method
• Domestic or foreign source, where relevant

Net funds raised

Net funds raised subtracts directly attributable costs from the funds collected. Depending on the NGO’s accounting policy, this may include payment gateway charges, event costs, advertising expenditure, agency fees, printing and campaign-related logistics.

The dashboard should clearly display what is included. It should not quietly mix direct fundraising costs with general administration expenses.

A basic formula is:

Net funds raised = Gross funds raised – refunds – transaction charges – direct fundraising costs

The formula may need to be adapted by the finance team and confirmed with the auditor.

Unrestricted and restricted income

This is one of the most important distinctions for NGO leaders. Unrestricted funds can generally be used for permitted organisational needs, subject to the donor agreement and applicable rules. Restricted funds are intended for a specified programme, activity, location, beneficiary group or purpose.

The dashboard should show:

• Unrestricted funds received
• Restricted funds received
• Unspent restricted balances
• Funds due to be released or reported
• Programme-wise utilisation
• Restrictions expiring or requiring action
• Donor or grant conditions attached to the money

A strong fundraising month does not automatically mean the organisation has more money available for salaries, rent, technology or other core costs. Leaders must see usable funds separately from total income.

Fundraising target and progress

Targets can be set by campaign, month, quarter, financial year, donor segment or funding programme. The dashboard should show both the amount raised and the proportion of the target achieved.

Targets should be treated as planning tools, not as proof of performance by themselves. A campaign can reach its target because of one unusually large donation, while recurring donor activity weakens. Showing donor count, average gift and donor concentration alongside target progress gives better context.

Fundraising pipeline

For grants, CSR partnerships and major gifts, income is often not immediate. A pipeline view can include:

• Prospects identified
• Initial conversations
• Concept notes submitted
• Proposals submitted
• Proposals under review
• Approved grants
• Agreements awaiting signature
• Funds expected
• Funds received
• Renewals due

Do not present the entire pipeline as confirmed income. The dashboard should distinguish committed, probable and potential funds. Trustees should be able to see how much future income is uncertain and when cash may actually arrive.

Donor Analytics That Support Better Decisions

Donor analytics help an NGO understand relationships rather than just transactions. The goal is not to treat supporters only as revenue sources. It is to understand how people engage, what they support and where communication or stewardship needs improvement.

Number of donors

Track unique donors separately from the number of donations. One donor making five payments is not the same as five donors making one payment each.

The dashboard can show:

• First-time donors
• Repeat donors
• Recurring donors
• Lapsed donors
• Donors who upgraded or downgraded
• Donors by city, state or country where appropriate
• Individual, corporate, foundation and institutional donors

Donor counts should be based on a reliable identity process. If a person donates once through UPI and again through a payment gateway using a different spelling, the system may count them as two donors unless records are carefully matched.

Donor retention

Donor retention measures how many donors from one period give again in a later period. The comparison period should be stated clearly. For example, an NGO may compare donors who gave in one financial year with those who gave again in the following financial year.

A simple form is:

Donor retention rate = Donors who gave again ÷ Donors in the original donor group

Retention is more meaningful when segmented by donor source and first donation month. A donor acquired through a specific campaign may behave differently from a donor introduced through a volunteer or an institutional relationship.

Avoid interpreting a low repeat rate without context. Some emergency appeals naturally bring one-time donors. A long-term child education programme may have stronger potential for monthly giving.

Recurring donation performance

Recurring donations can provide greater predictability, but only if payments continue successfully. Track:

• Active recurring donors
• New recurring registrations
• Successful recurring payments
• Failed recurring payments
• Cancelled mandates or subscriptions
• Renewal and recovery actions
• Average recurring contribution
• Net recurring income

The dashboard should identify failed payments promptly. A failed UPI AutoPay mandate, card payment or bank instruction is not the same as a donor cancellation. The follow-up process should be visible to the fundraising team.

Average gift size

Average gift size can be calculated as:

Total donation value ÷ Number of completed donations

Show this metric with the number of donations. If a few major contributions increase the average, the median gift or gift-size bands may offer a more representative view.

Useful bands might include small individual donations, mid-value contributions and major gifts. The exact bands should match the NGO’s donor base rather than being copied from another organisation.

Donor concentration

Donor concentration is a governance and financial sustainability metric. It shows how dependent the NGO is on a small number of donors or grants.

The dashboard might display:

• Share of total income from the largest donor
• Share from the top group of donors
• Share from institutional grants
• Share from CSR funding
• Share from individual donors
• Share from recurring donors
• Income expiring during the next financial period

No single concentration threshold applies to every NGO. The right level depends on the organisation’s size, programme model and funding history. What matters is that trustees can see the dependency and ask whether there is a mitigation plan.

Campaign and Channel Metrics

Campaign metrics help teams decide which activities deserve more effort. They also prevent the organisation from judging a campaign only by the amount collected.

Conversion rate

For a digital campaign, conversion rate may measure completed donations divided by the number of relevant visitors or people who reached the donation page.

For an event, it may measure donors divided by attendees or invitations. For a volunteer-led appeal, it may measure donors divided by contacted supporters.

The denominator must be defined. “People reached” on a social platform is not directly comparable with visitors to a donation page. The dashboard should label each conversion metric according to the journey being measured.

Cost per acquired donor

This metric estimates the cost of attracting a new donor:

Cost per acquired donor = Attributable acquisition cost ÷ Number of new donors

Attributable cost may include advertising, creative work, landing-page production, payment tools and campaign agency charges. It should not include every organisational expense unless the NGO deliberately uses a fully loaded cost model.

Cost per acquired donor needs to be viewed with donor value and retention. A channel with a higher acquisition cost may still be useful if it brings donors who give repeatedly. A low-cost channel may be less valuable if most donors give only once.

Return on fundraising expenditure

A common view is:

Funds raised ÷ Direct fundraising cost

This can be useful for comparing campaigns, but it is not a complete measure of effectiveness. It may favour large one-time grants and undervalue relationship-building work. It also needs consistent treatment of staff time, technology, events and shared costs.

Show both gross and net return where possible. Trustees should be able to ask whether the organisation is maximising funds, building sustainable relationships or meeting a specific programme need.

Channel performance

Compare channels such as:

• NGO website
• UPI QR codes
• Payment gateway links
• Email
• WhatsApp communication
• Social media
• Crowdfunding platforms
• Events
• Volunteer referrals
• Corporate introductions
• Direct grant applications
• Offline appeals

For each channel, consider showing donations, unique donors, average gift, repeat giving, transaction charges and net funds. Attribution will not always be perfect, especially when someone sees a social post and later donates through a direct bank transfer. The dashboard should record the source as accurately as practical and flag unknown attribution instead of pretending it is precise.

Payment success and reconciliation

Payment performance is both an operational and donor experience metric. Track:

• Payment attempts
• Successful payments
• Failed payments
• Abandoned donation forms
• Refunds
• Chargebacks where applicable
• Gateway settlement amount
• Bank receipt status
• Unmatched transactions

A donation should not be treated as fully reconciled simply because a payment gateway shows it as successful. Finance teams need to match the transaction with settlement records and bank entries. This is particularly important when an NGO uses multiple gateways, bank accounts or QR codes.

NGO Reporting, Compliance and Data Quality

A fundraising dashboard cannot replace accounting software, statutory filings or an audit. It should make those processes easier by providing consistent and traceable data.

Receipts and donor records

The system should record the information needed for donor acknowledgement and receipts, based on the NGO’s process and professional advice. Depending on the donation and donor type, this may include name, address, PAN, email, transaction reference, amount, date, payment mode and purpose.

The dashboard can monitor:

• Receipts issued
• Receipts pending
• Duplicate receipts
• Missing donor information
• Failed email or WhatsApp delivery
• Refunds after receipt issue
• Donor requests for corrections

For 80G-related records, the organisation should follow current requirements and confirm details with its accountant or tax adviser. The dashboard should not assume that every donor is eligible for the same tax treatment.

FCRA-related visibility

An NGO receiving foreign contribution may have additional obligations under the Foreign Contribution (Regulation) Act and related rules. The dashboard should distinguish foreign contribution from domestic donations and display relevant source, account and utilisation information.

It should not allow staff to combine domestic and foreign receipts casually. The organisation should configure account mappings and reporting fields with professional guidance. FCRA status, permitted activities, designated accounts and filing requirements can change, so the technology should support updates rather than hard-code assumptions.

CSR and institutional grants

For CSR and grant-funded work, fundraising data often needs to connect with programme and utilisation reporting. Useful fields include:

• Corporate or grantor name
• Agreement date
• Approved amount
• Instalment schedule
• Restricted purpose
• Project period
• Budget categories
• Amount received
• Amount spent
• Balance available
• Utilisation certificate status
• Narrative report status
• Renewal or closure date

CSR-1 registration and related obligations should be handled according to current Ministry of Corporate Affairs requirements and professional advice. The dashboard can show whether documents are complete, but it should not be treated as a legal compliance system by itself.

Data quality metrics

Bad data produces bad decisions. Add quality indicators such as:

• Unmatched bank transactions
• Missing donor names
• Duplicate donor profiles
• Unassigned campaign codes
• Donations without purpose classification
• Receipts pending beyond the organisation’s internal standard
• Transactions with incorrect source tagging
• Records not reconciled to bank statements

A dashboard that displays its own data-quality warnings is more trustworthy than one that presents every figure with false confidence.

Privacy and access control

Donor data should be collected only for clear organisational purposes and stored with appropriate safeguards. The Digital Personal Data Protection Act, 2023 and other applicable requirements should be considered when designing collection, storage, access and deletion processes.

Not every user should see every donor field. A volunteer may need campaign totals but not full PAN details. A fundraiser may need communication history but not bank account information. A trustee may need concentration data without seeing personal addresses.

Use role-based access, strong passwords, multi-factor authentication where available, audit logs and regular access reviews. Exported spreadsheets should be treated as sensitive files, not as harmless working documents.

Designing the Dashboard for Trustees

A trustee dashboard should be concise enough to review before a meeting and detailed enough to support questions. It should show trends rather than isolated totals.

A practical trustee page may contain:

1. Total income received during the selected period
2. Unrestricted versus restricted funds
3. Net funds raised
4. Donor retention and recurring income trend
5. Largest funding sources and concentration
6. Fundraising cost and net return
7. Pipeline of committed and probable funds
8. Reconciliation or compliance exceptions
9. Major risks and decisions required

Use trends and comparisons

A single month’s total can be misleading. Compare with the previous period, the same period in the previous financial year or the approved budget where the comparison is meaningful.

Explain unusual changes. A large grant received in one month may distort the trend. A temporary reduction in donations may result from a campaign ending, payment failure or a seasonal pattern. The dashboard should include notes or commentary fields so that context is not lost.

Separate facts from interpretation

The dashboard should show the metric first and the explanation second. For example:

• Fact: Individual donations fell during the quarter.
• Possible explanation: The organisation shifted campaign spending to a grant application.
• Decision: Trustees must decide whether to restore individual donor activity.

This structure encourages constructive oversight rather than dashboard-driven speculation.

Avoid vanity metrics

Follower counts, impressions and website visits may indicate awareness, but they do not automatically show fundraising effectiveness. Include them only when they help explain donor behaviour.

A campaign with fewer impressions but stronger repeat giving may be more valuable than a campaign with high reach. Leaders should prioritise completed donations, net funds, donor quality and mission-aligned outcomes.

Comparing Dashboard Approaches

There is no single correct technology choice. The appropriate approach depends on transaction volume, team capability, existing systems and reporting complexity.

Many NGOs begin with spreadsheets and later move to a CRM or integrated system. That progression is reasonable, but migrating poor data does not solve the underlying problem. Define fields, naming conventions and ownership before selecting software.

Implementing an NGO Fundraising Dashboard

Start with a focused first version rather than attempting to track every possible metric.

Step 1: Map the data sources

List where fundraising data currently sits:

• Bank statements
• Payment gateways
• UPI reports
• Donation forms
• Accounting software
• Excel files
• Crowdfunding platforms
• Email marketing tools
• WhatsApp records
• Event registration systems
• Grant trackers

Note the owner, update frequency, export format and known problems for each source.

Step 2: Define metric formulas

Write down exactly how each metric is calculated. For example, decide whether “funds raised” includes pledged donations, whether refunded payments are removed, how gateway charges are treated and how anonymous donations are counted.

This metric dictionary should be approved by the finance and fundraising teams. It is especially useful when staff change or an external technology partner supports the system.

Step 3: Create a clean data structure

Use consistent campaign names, donor categories, funding-purpose codes and payment statuses. Avoid entering the same campaign under several spellings.

Create separate fields for:

• Donor
• Donation
• Campaign
• Payment status
• Funding purpose
• Restriction
• Receipt status
• Reconciliation status
• Source channel
• Reporting period

Separating these concepts makes filtering and reporting more reliable.

Step 4: Build role-based views

Do not give every user the same screen. Create an operations view for action, a management view for planning and a trustee view for oversight.

Set clear ownership for each exception. If a payment is unmatched, finance should own it. If a recurring payment fails, fundraising or donor care may own the follow-up. If a grant report is pending, the grants or programme team should be responsible.

Step 5: Test against real records

Select a past period and compare dashboard totals with bank statements, gateway settlements and accounting records. Check edge cases such as refunds, duplicate payments, anonymous donors, partial instalments and donations received near the end of a financial year.

Do not launch based only on a successful demonstration using clean sample data.

Step 6: Review monthly

Metrics should change as the NGO’s strategy changes. Review whether the dashboard is helping leaders take decisions. Remove charts that nobody uses, add warnings where risks are being missed and record explanations for major variances.

The dashboard should be part of a monthly management rhythm, not a one-time technology project.

Frequently Asked Questions

What are the most important NGO fundraising dashboard metrics?

Begin with gross and net funds raised, unrestricted and restricted income, donor count, repeat giving, recurring donations, average gift size, donor concentration, campaign cost, payment success and reconciliation status. For grant-funded NGOs, add pipeline value, committed funds, utilisation and reporting deadlines. The final list should reflect the organisation’s funding model and accounting process.

How often should trustees review fundraising dashboard data?

Most trustees can review a concise dashboard monthly or quarterly, depending on the NGO’s size and fundraising activity. The data itself may be updated daily or weekly, while formal governance discussion can happen at board meetings. Urgent exceptions, such as a major funding shortfall or compliance concern, should be escalated sooner.

Should an NGO include social media metrics in its fundraising dashboard?

It can include them when they help explain a fundraising outcome. Reach, clicks and engagement are supporting indicators, but completed donations, donor retention and net funds usually matter more for financial decisions. Social metrics should not be presented as fundraising success unless they are connected to a defined donor journey.

Can a spreadsheet be used as a fundraising dashboard?

Yes, a spreadsheet can work for a small NGO with limited channels and disciplined processes. It becomes risky when several people edit it, donor records are duplicated, payment sources are numerous or trustees need a consistent audit trail. At that point, a CRM, accounting integration or reporting dashboard may be more suitable.

How should an NGO measure fundraising cost?

First define which costs are directly attributable to fundraising, such as campaign advertising, event costs, payment charges and fundraising agency fees. Then show the cost alongside gross funds, net funds, new donors and repeat giving. The finance team should document the method so that campaign comparisons remain consistent.

Does a dashboard replace NGO accounting and compliance reports?

No. A dashboard summarises information for decisions and can support reconciliation, donor records and reporting preparation. It does not replace accounting books, statutory filings, audit work, FCRA processes, tax advice or grant-specific documentation.

Where to Start

Choose five to ten decisions the dashboard must support, then map the data needed for each one. Agree on definitions for net funds, donor, campaign, restricted income, recurring donation and fundraising cost before building charts.

Next, reconcile one recent period across bank records, payment gateways and accounting data. Build a simple trustee view first, add operational screens after the underlying data is reliable, and review access controls before sharing donor information.

If you need help planning or building an NGO fundraising dashboard, you can talk to the Govindani Infotech team on WhatsApp; project scope and pricing are confirmed there based on your organisation’s requirements.