Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesNonprofit & CommunityFundraising & DonorsCapital Campaign Pledge Tracker

SpreadsheetFundraising & DonorsFree

Capital Campaign Pledge Tracker

Track campaign pledges, payments and balances against a gift range chart, with % fulfilled and behind-schedule alerts.

Shown with sample data

Colour

Capital Campaign Pledge Tracker

Track campaign pledges, payments and balances against a gift range chart, with % fulfilled and behind-schedule alerts.

Campaign goal
$3,000,000
Total pledged
$1,401,000
Goal pledged
47%
Cash received
$724,500
Outstanding pledges
$676,500
Pledges behind or overdue
2
Gift chart total
$3,000,000
Should equal the goal
Prospects needed
262
Amount secured by gift level
  • $600,000$600,000
  • $300,000$300,000
  • $150,000$300,000
  • $75,000$75,000
  • $50,000$50,000
  • $25,000$50,000
  • $10,000$20,000
  • $5,000$5,000
  • $1,000$1,000
Pledged by donor
  • Harborview Community Foundation$600,000
  • Margaret & Alan Okafor$300,000
  • Larkin Family Foundation$150,000
  • Thomas Whitfield$150,000
  • Coastal Credit Union$75,000
  • Robert & Mina Kim$50,000
  • Grace Fellowship Church$25,000
  • Aisha Grant$25,000

How to use it

  1. 1Type your campaign goal on the Settings sheet and adjust the gift range chart so the subtotals add up to it.
  2. 2Record each pledge with the pledge date, amount, payment schedule and the date of the final payment.
  3. 3Update Paid to date whenever a payment arrives (or link it to your donor database).
  4. 4Review pledges marked Behind each month and send a friendly reminder or call.
  5. 5Use the Gift Range Chart at cabinet meetings to focus solicitations on the levels with gifts still needed.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Run a capital campaign from one workbook. Record each pledge with its payment schedule and payments to date; the tracker calculates the outstanding balance, % fulfilled, what should have been paid by now and flags pledges that are behind or overdue. The Gift Range Chart lays out the gifts needed at every level to reach your goal and shows, live, how many gifts you have secured at each level and how many are still needed.

Who it’s for

  • Capital and endowment campaigns with multi-year pledges
  • Campaign cabinet and board progress reports
  • Planning the quiet phase around a gift range chart

What’s included

  • Pledges sheet: One row per campaign pledge.
  • Gift range chart sheet: The gifts needed at each level to reach the goal, and how many are secured.
  • Settings sheet: Campaign goal.

How to use it

  1. 1Type your campaign goal on the Settings sheet and adjust the gift range chart so the subtotals add up to it.
  2. 2Record each pledge with the pledge date, amount, payment schedule and the date of the final payment.
  3. 3Update Paid to date whenever a payment arrives (or link it to your donor database).
  4. 4Review pledges marked Behind each month and send a friendly reminder or call.
  5. 5Use the Gift Range Chart at cabinet meetings to focus solicitations on the levels with gifts still needed.

Tips

  • A classic gift range chart expects the lead gift to be 10–20% of the goal and the top ten gifts to provide around half of it.
  • Most campaigns secure 50–70% of the goal in the quiet phase before going public; do not announce until you are confident.
  • Send pledge reminders a few weeks before each instalment is due, not after it is missed.
  • Book pledges and payments consistently with your auditor’s guidance: unconditional pledges are usually recorded as revenue when made.

Questions

What is a gift range chart?

A table showing how many gifts you need at each amount to reach a campaign goal, and how many prospects you need to get them. It keeps the campaign realistic: if you cannot name prospects for the top levels, the goal is too high.

How many prospects do I need per gift?

A common rule is three to five qualified prospects for each gift at the top levels and two to three at lower levels, because not everyone says yes at the amount asked.

How long do capital campaign pledges usually run?

Three to five years is typical, paid annually, quarterly or monthly. The tracker counts the instalments that should have been paid by today (the first is due on the pledge date and the last on the final payment date) and compares that amount with what has been paid.

Is a pledge legally binding?

It depends on the wording and local law. Many organisations treat pledges as statements of intent and do not pursue legal action, but a signed pledge is important for planning and for your audit.

Related searchescapital campaign pledge trackerpledge tracking spreadsheetgift range chart templatecapital campaign templatemulti-year pledge trackercampaign gift table

Details

Format
Spreadsheet
Category
Fundraising & Donors
Sheets
3
Setup
20 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetFundraising & DonorsFree

Capital Campaign Pledge Tracker

Track campaign pledges, payments and balances against a gift range chart, with % fulfilled and behind-schedule alerts.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Fundraising & Donors
Sheets
3
Setup
20 min
Level
Intermediate
Price
Free

Your copy is private to you.

More fundraising & donors templates

View all
Donor Database5 sheets

Raised this fiscal year

$15,325

Donor retention

67%

LYBUNT donors

2

ABCD
1DonorTypeLifetime givingGifts
2Margaret & Alan OkaforHousehold$2,5002
3Thomas WhitfieldIndividual$10,0002
4Harborview Community FoundationFoundation$22,5002
5Daniel ReyesIndividual$500.002
Donors
SpreadsheetFundraising & Donors

Donor Database

Track every donor and gift, with lifetime giving, LYBUNT and SYBUNT flags, giving levels and a suggested next ask.

20 min setupPreview

Organization Name Street Address · City, State ZIP · Phone · Website Tax ID (EIN): 00-0000000 · Organization Name is a tax-exempt organization under Section 501(c)(3) of the Internal Revenue Code.

Date

Re: Thank you for your gift of $500.00 received on November 12, 2026

Dear Ms. Okafor,

Thank you for your generous gift of $500.00 to Organization Name. Because of you, twelve children in our Reading Bridges after-school program will have a trained tutor beside them twice a week this winter, the kind

This is your fifth year standing with our students, and your loyalty means more than we can say. Gifts like yours are what keep our doors open on the afternoons when children need us most.

DocumentFundraising & Donors

Donation Acknowledgment Letter

A warm thank-you letter that doubles as a tax receipt, with a gift table and the goods-and-services statement donors need.

10 min setupPreview

Grant Proposal: Reading Bridges After-School Literacy Program

ApplicantRiverside Youth Alliance
Tax ID (EIN)00-0000000
ContactMaya Torres, Director of De

1. Executive Summary

Riverside Youth Alliance requests $45,000 to expand Reading Bridges, our after-school literacy program, from two to three elementary schools in East Riverside. In 2027, Reading Bridges will give 120 strugglin

2. Organization Background and Capacity

Founded in 2009, Riverside Youth Alliance serves 1,400 young people a year through mentoring, tutoring and summer learning. Our annual budget is $1.2 million and we employ 14 staff and 160 volunteers.

  • •Track record: Since 2021, 86% of Reading Bridges students have gained at lea
  • •Partnerships: We hold data-sharing agreements with Riverside Unified School Dis
  • •Leadership: Program Director Andre Wallace is a former reading specialist with
DocumentFundraising & Donors

Grant Proposal

A complete, funder-ready proposal: need statement, SMART objectives, methods, evaluation, budget table, narrative and sustainability.

45 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ