FY24–FY26 Transaction Analysis — Dashboard

FY24–FY26 transaction analysis · SUMMARY sheet · 36 fiscal months · 24,293 transactions

Three fiscal years,
one shrinking gift

Revenue fell 34.6% from FY24 to FY26 while transaction volume rose 7.6%. That combination has exactly one explanation, and it is the subject of this dashboard: the average transaction lost $1,430.

About the original ask You asked for raised-by-opportunity and raised-by-account-owner. This file has neither column — it is a monthly roll-up with no opportunity, account, or owner detail, and dollars are not broken out by payment method. The two closest units this file does support are fiscal month and payment channel, so those take positions 01 and 02. For true opportunity and owner cuts, use the pledge export from earlier in this conversation.
Fiscal year
Measure
Fiscal summary
Total raised
Transactions
Avg per transaction
Peak month
ACH
Check
Credit card
Best month
Weakest month
Months above $2M
01 / nearest equivalent

Raised by fiscal month

The month is the only unit of aggregation this file offers, so it stands in for "each opportunity." Bars share one scale across all three years, so length is directly comparable. Switch the measure above to see transactions or average gift instead of dollars.

FY24 FY25 FY26 Fiscal year runs July → June
02 / nearest equivalent

By payment channel

Standing in for account owner — it is the only "who or how" dimension in the file. Important limit: the sheet counts transactions per channel but does not split dollars, so these are volume shares, not revenue shares.

Channel mix by year

Share of all transactions. Check is collapsing; credit card has nearly doubled its share in two years.

Channel counts

Absolute transaction counts and the FY24 → FY26 change.

03 / added

Everything else worth watching

Seven views this file supports that were not on the original ask.

Fiscal-year pacing

Cumulative dollars from July forward. Where the lines separate is where the year was won or lost — and the December step is doing most of the work.

Year-over-year by month

Same-month change, FY26 vs FY25. This is the column your sheet labels "Diff MxM" — it is actually a year-over-year comparison, not month-to-month.

Where the decline came from

FY24 → FY26 change decomposed by month, largest losses first. One month accounts for a plurality of the entire drop.

Fiscal quarters

Q1 Jul–Sep · Q2 Oct–Dec · Q3 Jan–Mar · Q4 Apr–Jun. Q4 is the one place FY26 beat both prior years.

Average transaction size

Dollars per transaction by month. The floor keeps dropping even in months where volume holds up.

December dependency

Share of each fiscal year that arrives in December, and how top-heavy the calendar is overall.

Volume up, value down

Indexed to FY24 = 100. The divergence is the whole finding.

Reading notes

What to check before this goes anywhere with a logo on it.

Source: FY24-FY26_Transaction_Analysis_FOR_ALI.xlsx, SUMMARY sheet · 36 monthly rows, July–June fiscal calendar · $68,828,606 and 24,293 transactions in total · channel counts reconcile exactly to total transactions in all 36 months.