A campaign closes with $250,000 in reported revenue. The board packet goes out. The team shifts budget toward the apparent winner.
Then the number moves. A donor requests a refund. A card dispute becomes a chargeback. A gift is moved to another designation. A duplicate record is reversed. A soft credit changes which campaign appears to have influenced the gift.
None of those adjustments is unusual. The reporting problem is pretending they never happened.
A gift adjustment audit gives fundraising and finance teams a shared view of what changed after a gift entered the report. It preserves the first reported result, records each correction, and shows the adjusted net result without quietly rewriting history.
What is a gift adjustment audit?
A gift adjustment audit is a report that connects every post-entry change to the original gift, campaign, donor record, and reporting period. It answers four questions:
- What did the campaign originally report?
- What changed after that report?
- Why did the change happen?
- Which decisions, totals, and ROI calculations should now be updated?
The goal is not to make the first report perfect. Some adjustments arrive days or weeks later. The goal is to make change visible, attributable, and reviewable.
This is different from a cost allocation review. Cost allocation asks whether the expense side of ROI is complete. A gift adjustment audit asks whether the revenue side still represents the gifts the organization can legitimately count in that campaign, period, fund, and donor journey.
Five gift adjustment states keep revenue changes explainable
Most teams do not need dozens of adjustment categories. They need a small set that maps to different reporting consequences.
| Adjustment state | What it means | Reporting treatment |
|---|---|---|
| Returned | Money was sent back to the donor through a refund or similar return. | Reduce received revenue and retain the original gift-to-return relationship. |
| Reversed | A gift entry was canceled because it was duplicated, entered in error, or replaced by a corrected transaction. | Remove the reversed amount from the active total without deleting the audit trail. |
| Disputed | A chargeback or payment dispute is open, won, or lost. | Separate open exposure from confirmed loss so pending disputes do not look final. |
| Reclassified | The gift remains valid, but its campaign, fund, designation, appeal, date, or revenue type changed. | Move credit between reporting dimensions and show both sides of the change. |
| Credit corrected | Hard credit, soft credit, household credit, or influence credit changed without changing cash received. | Update donor and campaign influence views without incorrectly changing cash revenue. |
That last distinction matters. A soft-credit correction can change a relationship manager’s portfolio or an attribution report while leaving deposited revenue untouched. Combining cash adjustments and credit adjustments in one net-revenue column creates a report nobody can safely interpret.
Preserve the first report instead of overwriting it
When a source system updates a gift in place, a dashboard may show only the newest value. That makes the current total look clean, but it removes the explanation for why last month’s campaign report no longer matches this month’s.
Keep three values for each campaign and reporting period:
- Originally reported revenue: the amount included at the named reporting cutoff.
- Net confirmed adjustments: returns, reversals, confirmed disputes, and qualifying reclassifications recorded after that cutoff.
- Adjusted reported revenue: the original amount plus or minus confirmed adjustments.
Then keep open adjustment exposure beside those values. Open disputes and pending corrections belong in a risk column, not inside a confirmed result.
A useful calculation is:
adjusted reported revenue = originally reported revenue + confirmed positive adjustments - confirmed negative adjustments
For campaign ROI, recalculate the return with the adjusted revenue while keeping the cost basis and reporting cutoff visible. That gives the team a corrected answer without erasing the answer it acted on earlier.
The adjustment rate shows where campaign results are unstable
Start with an adjustment rate by campaign:
adjustment rate = absolute value of confirmed adjustments / originally reported revenue
Using the absolute value is important. A $5,000 gift moved into a campaign and a $5,000 gift moved out could net to zero while still revealing $10,000 of reporting movement. Net change shows the financial result. Gross adjustment activity shows how stable the underlying classification was.
Track both. A campaign can have a small net adjustment and a large volume of offsetting corrections, which may point to coding problems, unclear campaign rules, or a difficult reconciliation workflow.
Build the audit at gift level, then roll it up
The summary belongs at campaign level, but the evidence belongs at gift level. Each adjustment record should include:
- original gift or transaction ID
- adjustment ID and effective date
- adjustment state and reason
- original amount and adjustment amount
- original and revised campaign, fund, appeal, or designation
- cash impact, campaign-credit impact, and donor-credit impact as separate fields
- source system and responsible owner
- status: open, confirmed, rejected, or superseded
- the reporting periods and decisions affected
Do not store the reason only in a free-text note. Use a controlled reason list for recurring analysis, with an optional note for context. Otherwise, “refund,” “gift returned,” and “donor reimbursement” become three categories for the same event.
A simple example: one campaign, three different consequences
Imagine an appeal originally reported $100,000 in revenue on June 30.
- A $1,000 duplicate gift is reversed. Cash and campaign revenue both fall by $1,000.
- A $2,500 gift is reclassified from the spring appeal to a capital campaign. Organization-wide cash does not change, but the spring appeal loses $2,500.
- A $5,000 soft credit moves from one relationship manager to another. Cash and campaign revenue do not change, but portfolio credit does.
The spring appeal’s adjusted revenue becomes $96,500. The organization-wide cash adjustment is only $1,000. The portfolio-credit change is $5,000.
One event table can support all three views, but only if cash, campaign classification, and donor credit are modeled separately.
Use a close rule that matches the decision
There is no single moment when every fundraising result becomes permanently final. A useful close rule names both a date and a decision.
- Preliminary: gifts are recorded, but the normal refund, dispute, or reconciliation window is still open.
- Reconciled: known adjustments have been processed and the result is ready for routine campaign evaluation.
- Reopened: a material later adjustment changes a previously reconciled result or decision.
The threshold for reopening should reflect the decision. A small adjustment may not change a board-level revenue story, but it could materially change a narrow channel test, fundraiser portfolio, or donor stewardship action.
Turn the audit into a monthly control, not a forensic project
A practical monthly workflow has six steps:
- Extract new and changed gifts from each source system.
- Match each adjustment to the original transaction and reporting dimensions.
- Classify cash, campaign, designation, and credit effects separately.
- Compare current totals with the last named reporting cutoff.
- Route open or material items to an owner with a due date.
- Publish the adjusted result with its close status and adjustment exposure.
ReportWerks can bring those gift, campaign, and reporting views together so teams can see when a result changed, which decision it affects, and whether the revised ROI is ready to use. The important part is the operating habit: every correction should improve the current report without destroying the history behind it.
Gift adjustment audit FAQ
Should refunded donations stay in fundraising reports?
The original gift should remain in the audit trail, but a confirmed refund should reduce adjusted received revenue. Showing both values explains the change without counting returned money as current revenue.
Do soft credits change nonprofit campaign revenue?
Usually, a soft-credit change affects relationship or influence reporting rather than cash received. Keep cash, campaign attribution, and donor credit in separate fields so a credit correction does not accidentally change net revenue.
How should chargebacks appear in fundraising ROI?
Show open chargebacks as exposure while the dispute is unresolved. Move the amount into confirmed negative adjustments only when the outcome is known, then recalculate campaign revenue and ROI.
How often should nonprofits reconcile gift adjustments?
Review them on a predictable cadence that matches reporting and decision cycles. Monthly is a practical baseline for many teams, with faster review for high-volume campaigns, active disputes, or time-sensitive budget decisions.
Give every changed number an explanation
Choose one recently closed campaign and compare its originally reported revenue with today’s transaction-level total. List every difference, classify its effect, and assign a close status.
If the team can explain each change without reconstructing the campaign from email threads, the report is doing its job. If it cannot, the next dashboard improvement is not another chart. It is an adjustment ledger.
