Nonprofit Donation Tracker Spreadsheet with Pledges

Year-end statements, pledge follow-ups and event acknowledgments are where donor records slip. This nonprofit bookkeeping spreadsheet for donors and fundraising has a donor log that prints year-end giving statements, a pledge & campaign tracker, a fundraising event tracker, a volunteer hours & in-kind log, a client assistance log, and a Word pack of 16 donor, grant and sponsor letters and forms. Excel, Google Sheets & Word.

Most templates in this space are checklists, Word forms and simple sheets. These workbooks do the math and flag errors.

Every workbook has a Check column that tells you what to fix before statements go out or the board sees the numbers: gifts dated outside the giving year, donor IDs that aren't on the donor list, missing check numbers, donor addresses too incomplete to mail, pledges behind schedule or past their last payment date, event payments that still need a written acknowledgment or quid pro quo disclosure, unpaid event bills, in-kind gifts not yet acknowledged, and client assistance requests over your per-case or annual household limit, repeat requests, unverified need, or cash paid to the person instead of the vendor.

WHAT'S INCLUDED (10 Excel files + 2 Word files)

• Nonprofit_Donor_Log_Giving_Statements.xlsx + EXAMPLE: one line per gift by donor ID, fund and type, with the value of anything the donor received; pick a donor ID and a printable year-end contribution statement fills itself in; giving summary by fund, type and size band

• Nonprofit_Pledge_Campaign_Tracker.xlsx + EXAMPLE: every pledge with its payment schedule, what should have arrived by the as-of date, received, balance and how far behind; campaign totals against goal; a follow-up list of the pledges furthest behind

• Nonprofit_Fundraising_Event_Tracker.xlsx + EXAMPLE: event revenue, event costs and auction items for up to 12 events; deductible portion per payment (amount paid minus value received); net proceeds, percent of goal, cost per dollar raised; a one-page board dashboard with tie checks

• Nonprofit_Volunteer_Hours_InKind_Log.xlsx + EXAMPLE: volunteer roster, hours log by program, in-kind gifts log, a board and grant-report summary, and a printable volunteer hours statement

• Nonprofit_Client_Assistance_Log.xlsx + EXAMPLE: requests recorded by household code (no names), approvals, vendor payments, per-case and annual limits, a share-safe summary and a 10-point policy checklist

• Nonprofit_Forms_and_Letters_Pack.docx + EXAMPLE (Word): 16 print-ready letters and forms, including donation acknowledgment, quid pro quo disclosure, in-kind receipt, year-end statement cover letter, grant thank-you and report cover letters, sponsorship acknowledgment, volunteer forms, reimbursement request, petty cash voucher, conflict-of-interest statement and restricted gift agreement

HOW IT WORKS

1. Enter your organization once on each Setup tab: name, address, EIN, funds, receipt thresholds, campaigns, events, programs and limits.

2. Record gifts, pledge payments, event payments, volunteer shifts, in-kind gifts and assistance requests one line at a time.

3. The Check column flags problems; statements, campaign totals, event results and summaries fill themselves in. Use the Word letters for acknowledgments and grant correspondence.

Fund categories used throughout: Unrestricted (General), Board-designated, Donor-restricted, with fund codes like GEN, DES-OPR and RES-BLD.

Plain-English Start Here tab in every workbook · no macros · blank + filled EXAMPLE for every file.

WORKS IN EXCEL, GOOGLE SHEETS AND WORD

Excel: download the ZIP, open any .xlsx, and start on the Start Here tab.

Google Sheets: File → Import → Upload → choose the .xlsx → create new spreadsheet. (Sheets does not carry over Excel's sheet protection, so formula cells are unlocked there.)

Word: open the Forms & Letters .docx in Word or upload it to Google Docs, and fill in the yellow-highlighted blanks.

Keep the EXAMPLE files as a filled reference; work in the blank files.

WHO THIS IS FOR

Part-time treasurers, development staff and bookkeepers at small nonprofits and charitable organizations (roughly 1 to 25 staff) who record gifts, send year-end giving statements, run fundraising events, and track pledges, volunteers and client assistance.

PAIRS WITH OUR OTHER PACKS

Nonprofit Treasurer Controls Pack (cash & donation count, restricted funds tracker, bank reconciliation, sample chart of accounts)

Nonprofit Monthly Ops & 990 Pack (income log, expense & bill log, budget vs actual, treasurer report, functional expenses)

Nonprofit Grants & Compliance Pack (grant tracker, compliance calendar, written financial policies, fixed assets, petty cash, mileage, partner support)

Same fund codes, same account numbers, same Start Here layout.

INSTANT DOWNLOAD · FINAL SALE

This is a digital product. Files are available immediately after purchase. Because of the nature of digital downloads, all sales are final (see shop policies for detail).

DISCLAIMER

Organizational tools only for small nonprofits and charitable organizations. Not tax, legal, or accounting advice. Not approved or endorsed by the IRS or any regulator. Does not guarantee compliance or a clean audit. The $250 written-acknowledgment and $75 quid pro quo thresholds are editable examples shown for convenience, and the letters are general templates; have a qualified CPA or attorney confirm current rules and review the letters, and how these tools apply to your organization.

Built by ReconciledBooksCo, a small shop run by an experienced accountant.

Shop: ReconciledBooksCo