Restriction unresolved
Why it matters
The intended use and available fund do not clearly match.
Next responseRoute development and finance review with donor and gift context.
Donation and follow-up tracking
Donation tracking from gift to follow-up
Connect each gift or pledge to the donor, fund, restriction, finance reference, acknowledgement, stewardship promise, relationship owner, due date, and outcome.
The live tracker shows gift-type and acknowledgement signals above the exact records that need review, with donor context one click away.
- Overdue acknowledgement and restricted-gift queues
- Pledge, finance, and stewardship status in the same view
- Generated identifiers and controlled status choices
Follow every gift from record to resolved commitment
Tracking should tell the team what is done, what is waiting, and who must act.
- 01
Record
Connect transaction reference, donor, date, amount, gift type, fund, restriction, and pledge context.
The identifier is generated and the finance source can be reconciled. - 02
Review
Resolve restriction, anonymity, matching, missing donor, or finance questions.
Exceptions have owners, evidence, and recorded outcomes. - 03
Acknowledge
Choose receipt or acknowledgement method, owner, due date, recognition name, and message context.
Overdue work is visible before the donor follows up. - 04
Steward
Complete promises and schedule a relevant next interaction.
The donor record shows the action and its outcome. - 05
Close or renew
Confirm fulfillment, future commitment, renewed engagement, or a reason to stop follow-up.
The next period starts with a clean status.
Keep exception work out of inboxes
A long donation register is only useful when unusual cases rise to the top.
Reconciliation pending
Why it matters
Operational and finance records do not yet agree.
Next responseRecord the variance, finance owner, reference, and resolution date.
Acknowledgement overdue
Why it matters
The service commitment following the gift is late.
Next responseEscalate by age and donor context instead of sending generic reminders.
Pledge payment at risk
Why it matters
The expected installment or follow-up is late.
Next responseConfirm financial status before assigning appropriate relationship action.
Use measures that lead to a donor action
Every signal should drill down to its contributing records.
Acknowledgements due
Recorded gifts without a completed acknowledgement inside the chosen service window.
Prioritize by age, relationship, gift type, and owner.Restriction review open
Gifts whose fund or use has not been confirmed.
Bring development and finance to the exact record.Pledge follow-up due
Commitments with a missed installment or promised contact date.
Verify finance status and select a respectful next step.Stewardship next-action coverage
Donors with a relevant future action and responsible owner.
Resolve active relationships with no next step.Let a trained administrator adapt the tracker
The tracker should change without creating another disconnected sheet.
Change requestSpreadsheet or fixed processIn Jodoo
Add a new donation type and acknowledgement path
Update columns, formulas, filters, and team instructions separately.
Add the choice, required fields, owner rule, due action, reminder, and dashboard filter together.Review gifts above a threshold
Add a formula and manually email the resulting rows.
Create a review state, responsible role, evidence, decision, and exception queue.Track a pledge installment schedule
Expand one gift row into several hard-to-reconcile rows.
Relate installment records to the commitment, donor, finance status, and follow-up owner.Choose the right tracking depth
Clarify what the tracker should own.
What is the best way to track donations?
Use a stable donation or commitment ID connected to the donor, date, amount, type, fund, restriction, payment or finance reference, reconciliation status, acknowledgement, owner, next action, due date, and outcome. Separate financial authority from relationship follow-up.
Can I start with the donation tracking spreadsheet?
Yes. The downloadable workbook is useful for a small, controlled team. Move to the connected application when several people update records, reminders are missed, permissions differ, or history and drill-down matter.
Does the tracker store payment card data?
No. Use a trusted payment system for payment credentials and settlement. The tracker should store only the stable transaction reference and operational status needed for acknowledgement and follow-up.
How does donor tracking connect to donor management?
Donation tracking owns the gift-to-acknowledgement loop. Donor management adds the broader relationship history, segments, interactions, stewardship cadence, lapse risk, and future engagement.
Open every donation exception from one queue
Use the Jodoo tracker to connect the gift, finance reference, restriction, acknowledgement, donor, owner, and outcome.