Sponsorships Table
Use the Sponsorships table when you need to review donor-recipient commitments across programs, check which commitments are current or due, create new sponsorship relationships, update commitment settings, export or import relationship data, or work with selected sponsorships in bulk.
Start from Sponsorships in the sidebar.
Choose the Commitments You Want to Review
Use the count strip above the table when you need to narrow the list by program.
Total Sponsorships shows the sponsorship relationships your role can access across programs.
Program counts show sponsorships for each accessible sponsorship program.
The All Sponsorships program selector lets you switch from all programs to one program.
The programs you see depend on your role and program access. If you do not have access to any sponsorship programs, Gratona shows a message instead of the table.
Read the Sponsorships Table
Each row represents one donor-recipient sponsorship relationship.
Common columns include:
Recipient: the sponsored recipient or record
Donor: the donor connected to the recipient
Program: the program where the relationship exists
Status: whether the sponsorship is Current or Due
Next Payment: the next expected payment date, when available
Given To Date: the amount recorded for the relationship so far
Recipient and donor names can open more detail when your role allows it. Recipient actions can open the recipient drawer, and donor actions can open the donor profile. Some worksheet views also show quick preview actions, such as opening a donor, emailing a donor, logging an interaction, editing a recipient, or viewing recipient files.
Search and Filter Sponsorships
Use Search sponsorships when you need to find records by the columns shown in the table. Search also includes the donor and recipient title fields for the active sponsorship form.
Use Filter when you need a more specific list.
Filters can use:
recipient fields and system recipient fields
donor fields and system donor fields
payment fields, such as next payment, given to date, recurring amount, frequency, method, until, and last payment
logical combinations such as AND and OR
date presets and custom date ranges for date-based fields
Active filters affect the table, saved views, and exports where those tools are available.
Save Views and Choose Columns
Use Columns when you want the table to show the fields that matter for your current task.
You can add or hide columns from the column menu. Worksheet views can also include an Add column control in the table header.
Save a view when you want to reuse a combination of:
selected program context
visible columns
column order
sorting
filters
Some accounts may still show the classic table tools. In that experience, use Views or Manage Fields to choose the fields shown in the table.
Export or Import Sponsorship Relationships
Use Export / Import when you need a CSV of sponsorship relationships for reporting, commitment review, or offline analysis.
Confirm the active program, view, columns, search, and filters.
Select Export / Import and choose your option:
Current page CSV — downloads the rows currently shown on the page.
All as CSV — starts a background export of all sponsorships matching the current view.
All sent to email — starts a background export and emails a download link when ready.
Large exports are prepared in the background. A progress section appears at the top of the page while processing and provides the download when ready.
CSV import is for sponsorship relationships. The import template includes columns such as donor ID, recipient ID, amount, frequency, start date, next payment date, payment method, status, and notes.
Add or Update Sponsorships
Use Add Sponsorship when you need to create a donor-recipient relationship.
The add workflow starts with donor and recipient selection. After you save that selection, Gratona loads the remaining commitment details for the chosen donor and recipient, such as amount, payment method, payment frequency, and next payment due. Review the confirmation before creating the sponsorship.
See Add Sponsorship for the full add-sponsorship workflow.
Work With Selected Sponsorships
Select sponsorship rows when you need to update or archive more than one relationship.
Selected-row actions can include:
Bulk Edit to update commitment fields such as payment frequency, set date, next action date, payment method, commitment amount, or amount basis
Archive to disassociate the donor-recipient relationship
Mailings when mailings are enabled for your account and compatible templates are available
When you select all rows on the current page, Gratona may offer a second option to select all matching sponsorships in the current filtered view. Review the selected count before running a bulk action.
Archiving a sponsorship stops regular payments connected to that relationship, so review the confirmation message before continuing.
Replace a Sponsorship Safely
Gratona can archive one or many sponsorship relationships, but it does not automatically reassign those relationships to another donor or recipient. Bulk edit also does not perform a sponsorship transfer.
When a donor should move to a different recipient, or a recipient should be connected to a replacement donor:
Open the current sponsorship and record its donor, recipient, program, amount, payment method, payment frequency, and next payment date.
Confirm which relationship should end and which donor-recipient relationship should replace it.
Archive the old sponsorship. Remember that this stops its regular payments.
Select Add Sponsorship and choose the donor and recipient for the replacement relationship.
Enter the intended amount, payment method, payment frequency, and Next Payment Due date.
Review the confirmation, create the sponsorship, and verify that only the intended relationship is current.
Do not create the replacement without reviewing the old sponsorship first. Two current relationships or an incorrect next-payment date can produce duplicate or mistimed charges.
For a large reassignment project, contact support before changing records. Include the program, the selection rule, the expected number of relationships, and whether payment schedules must be preserved. Do not use a CSV import as an unreviewed transfer shortcut.
Permissions
Your role controls what you can see and do in the Sponsorships table. Program access, sponsorship management, donor access, recipient access, donations access, exports, imports, bulk edit, archive, mailings, reports, and saved views can all be permission-gated.
If you can manage the program but the archive action is missing, ask an organization admin to check the exact Block archiving sponsorships safety restriction in your permission set. This is separate from Block archiving recipients.
Related Guides
Last updated