An R2T4 calculation dated from real course activity, checked twice to the cent and signed inside the 45 days
Every worksheet checked twice and every return made inside the 45 days.
See one case, screen by screen ↓Return of Title IV Funds Calculation is R2T4 calculation software for financial aid offices. Seven agents find each withdrawal, date it from the last academic activity in the course log, fill the federal worksheet, recompute it blind and watch the 45-day return. A financial aid analyst prepares each case, the Director of Financial Aid signs it, and the business office posts it; no agent moves money.
AI in education: a buyer's guide to agentic AI for colleges, universities and school districts →
Updated
An R2T4 calculation is the Return of Title IV Funds calculation in 34 CFR 668.22: when a student with federal aid withdraws, officially or by simply stopping, the college works out how much of the aid the student earned, returns the rest within 45 days of the date it determined the student withdrew, and tells the student what they now owe. The arithmetic is a ten-step federal worksheet. The hard part is everything around it: the right withdrawal date, the right count of days with scheduled breaks of five days or more cut out, the students who stopped coming without a word, and a deadline that keeps running while the case sits in an inbox.
For an unofficial withdrawal, analysts email instructors and read gradebooks, and when nobody answers, the last login stands in for the last day, although 34 CFR 600.2 says a login without participation is not academic engagement. One term calendar mistake repeats across every case that term. Since July 1, 2026, a module counts only when the student began attending it. Return of Title IV Funds Calculation puts seven agents on every withdrawal, so the analyst prepares a case that is already dated, calculated twice and cited, and the Director of Financial Aid signs it with one look at the ruler.
Estimated split of the staff hours one unofficial withdrawal takes, by hand and with the agents; our arithmetic, kept modest. Elapsed days on the 45-day clock are a separate matter.
Seven agents find each withdrawal, date it from the course log, calculate it twice and watch the clock; the Director signs and the business office posts.
Dariela Fonseca, Student 2026-08412, AAS Welding Technology on Brandvale's East Campus, stopped attending her Fall 2026 classes without a word. Here is her Return of Title IV Funds case, screen by screen, in the working solution.
The Director's home puts all 128 open cases on one lane by days left, with an escalation zone at 7 days or less. One next step leads: 17 returns wait for his signature. The agents' overnight work is a few cited sentences: 13 cases opened, 12 students dated, one case stopped by the Checker, and 3 returns due within 7 days, all in today's 2:00 PM batch.
Returns due Nov 26 fall on Thanksgiving and post by Nov 24.
At the week-7 progress reports, all four of Dariela's instructors marked her as stopped attending, and no official withdrawal was on file. The Withdrawal Sweep agent opened her case, with confidence 0.98, and Oct 12 became the date of determination that starts the 45-day clock. Her case joins a queue sorted by that clock, in eight stages, searchable by campus, how it was found and days left.
The agent read 412 events in her four courses and marked what counts under 34 CFR 600.2. Her last activity that counts is the ENGL 101-14 Unit 4 Quiz, submitted Sat, Sep 26 at 11:48 PM, with the raw log line cited. A login on Sep 29, a visit to the aid award page on Oct 1 and a login on Oct 3 do not count. Three of four instructors have confirmed, Prof. Alma Ruiz-Castellanos first, on Oct 13.
Does not count: a login without further participation.
The ruler shows every day of the Fall 2026 payment period, 112 counted of 117, with the Nov 25–29 break cut out. Her withdrawal date stands on day 33, the 60% point on day 67.2, Oct 30. She earned 29.5%, or $1,724.87 of $5,847.00. Unearned charges come to $4,198.58 × 70.5% = $2,960.00, the lesser amount, so Brandvale returns $2,960.00: Unsubsidized $990.00, Subsidized $1,732.00 and Pell $238.00.
The Checker agent read the same sources itself and computed every value without seeing the Worksheet agent's result. Side by side, all ten steps match, from $5,847.00 disbursed to the $2,960.00 the college returns: 22 of 22 values equal. Only then can the case go to the Director.
The Checker agrees to the cent, 22 of 22 values, computed blind.
This term 486 cases were calculated twice and 27 differences were found. For Marcus Oyelaran-Pierce, the Worksheet agent counted the full 112 days, but he never began Session B: under the July 1, 2026 module rule only 55 days count, 70.9% is over the 60% point, and nothing is returned instead of $2,468.47. An analyst resolves the difference; the Director then signs.
Joaquín prepares the case with the agents' work in front of him: the progress reports, the course log at confidence 0.97, the certified Fall 2026 calendar, the Checker's agreement, and the Clock agent's plan around Thanksgiving, when the business office is closed Nov 26–27. The Notice agent's letter is drafted; he edits it at 9:12 AM.
Before signing he sees the withdrawal date, the share earned, the order of return, that both calculations agree, who prepared the case, and the deadline: Thu, Nov 26, 2026, 37 days left. The person who prepared the case cannot sign it, and the e-signature goes on the audit trail with the evidence.
I, Sameer Lindqvist, Director of Financial Aid, sign this Return of Title IV Funds calculation and send it to the business office to post.
Only the business office posts, and only what the Director signed. Today's batch of 9 returns, $24,389.36, posts to the federal aid gateway and student accounts together, and the gateway confirms 9 of 9. This term: 345 returns posted, none after the deadline.
The letter tells Dariela, in English and Spanish, that her last class activity was the Sep 26 quiz, that she earned aid for 33 of 112 days, and that Brandvale returned $2,960.00. She owes nothing on her Direct Loans or her Pell Grant, and $2,960.00 to the college, payable over 6 months with no interest. It goes out only after the Director approves it.
The same case, seen by the people who prepare, sign, post, certify and audit it: what their day looked like, and what it looks like now.
Seven agents find each withdrawal, date it from the course log, calculate it twice and watch the clock; the Director signs and the business office posts.
Opens a case for every official withdrawal, drop to zero credits and "stopped attending" progress report, and at term end checks every aided student with all F and W grades, clearing the rest with the evidence.
Reads the course activity log and instructor rosters, classifies every event against 34 CFR 600.2, and picks the last academically related activity, citing the log line.
Fills the federal worksheet, steps 1 to 10, from the aid, the charges, the certified term calendar and the date, with every value cited.
Recomputes every worksheet from the sources without seeing the first result; on any difference it stops the case and says which line differs, why, and which rule settles it.
Counts 45 days for returns, 30 days for loan offers and grant overpayment notices, and 14 days for the student's reply; plans around holidays and business office closures and escalates at 7 days.
Drafts each student letter in plain words, in English and Spanish: what happened, what was returned, any loan offer, any grant or balance owed, and what to do next.
Assembles the single-audit or program-review pack for a sample or a whole award year: both calculations, the date evidence, the calendar certification, the signature, the gateway confirmation and the notices.
Prepare, sign, post. The agents propose; a named person decides.
Ask about any withdrawal, worksheet, deadline or rule. Every answer cites its source and opens the screen it is about.
Why is 2026-08412's withdrawal date September 26?
Her last academic activity was the ENGL 101 Unit 4 quiz, submitted Sat, Sep 26 at 11:48 PM. She logged in on Sep 29 and Oct 3 but submitted nothing, and a login without participation is not academic engagement. Prof. Ruiz-Castellanos confirmed it on Oct 13, and Policy FA-14 §3 uses the last documented activity.
How was the $2,960 return worked out?
Day 33 of 112, with the Thanksgiving break cut out, is 29.5%. Of $5,847.00 disbursed, she earned $1,724.87, so $4,122.13 is unearned. Unearned charges are $4,198.58 × 70.5% = $2,960.00, the lesser, so Brandvale returns that: Unsubsidized $990.00, Subsidized $1,732.00, Pell $238.00. She owes no loan or grant, and the Checker agrees to the cent.
Which returns are closest to the 45-day deadline?
Three are due within 7 days: 2026-05218 Kenji Albrecht-Moore (Oct 24), 2026-05391 Fatima Oduya-Larsen (Oct 25) and 2026-05404 Bryce Halvorsen-Tafoya (Oct 27). All three are signed and in today's 2:00 PM business office batch. Returns due Nov 26 fall on Thanksgiving; the business office will post them by Tue, Nov 24.
What changed in the July 1, 2026 rules for us?
Three things. A session counts toward the payment period only when the student began attending it, which is why the Checker stopped 2026-07731: 55 days, not 112. Schools that take attendance must document the determination within 14 days. And a full-refund withdrawal exemption is optional; Brandvale has not adopted it.
12 screens from the working solution, on its sample data. Pick one to see it large.
The rules both calculations run on are settings, changed by the administrator, saved as a version and logged.
| Setting | Default | Choose from |
|---|---|---|
| Withdrawal date when a student leaves without notice | Last documented academic activity; otherwise the midpoint | Policy FA-14 §3; what counts follows 34 CFR 600.2 |
| Instructor confirmation | Below confidence 0.90 | Last evaluation of the Last Date agent: 0.97 on 400 dated cases |
| Institutional charges | Tuition, mandatory fees, required course materials bought through the college | Parking and optional items are left out |
| Grant overpayment | Not collected at $50 or less | With the 50% grant protection |
| Full-refund withdrawal exemption | Not adopted | Optional since July 1, 2026 |
| Return clock | 45 days after the date of determination | Post at least 2 business days before; escalate at 7 days left to the Director and the business office |
| Notice clocks | Loan offer and grant overpayment notices: 30 days | Student reply to a loan offer: 14 days |
| Course activity | Read only for students with an open case | Every read logged with the reason |
Every figure is labelled: a target the solution is built to, an estimate, a typical published result, or a proven one.
Sources: 34 CFR 668.22, Treatment of title IV funds when a student withdraws (as amended January 3, 2025, effective July 1, 2026) · 34 CFR 600.2 (academic engagement) · FSA Electronic Announcement GENERAL-26-20 (March 27, 2026) · 34 CFR 668.24 (records) · FSA, Top 10 audit and program review findings, and Sikich's summary of FSA's 2020 lists (R2T4 calculation errors 3rd among compliance audit findings and 2nd among program review findings; late returns 4th) · "target" = design goal, measured in the live solution · "demo" = seen in the working solution, on its sample data · "typical" = published figures · "estimated" = our arithmetic, kept modest. Brandvale Community College and the people named on this page are fictional: characters and sample data in the working solution.
Return of Title IV Funds Calculation is R2T4 calculation software for financial aid offices. Seven agents find each withdrawal, date it from the last academic activity in the course log, fill the federal worksheet, recompute it blind and watch the 45-day return. A financial aid analyst prepares each case, the Director of Financial Aid signs it, and the business office posts it; no agent moves money.
R2T4 is the Return of Title IV Funds rule in 34 CFR 668.22. When a student who received federal aid withdraws, the college works out how much of the aid the student earned for the part of the payment period completed, returns the unearned share within 45 days of the date it determined the student withdrew, and notifies the student. After the 60% point of the payment period, all the aid is earned.
The share earned is the days completed divided by the days in the payment period, with scheduled breaks of five days or more left out. In the working solution's example, day 33 of 112 is 29.5%, so $1,724.87 of $5,847.00 is earned. The college returns the lesser of the unearned aid ($4,122.13) and the unearned share of institutional charges ($4,198.58 × 70.5% = $2,960.00), in the federal order: loans first, then the Pell Grant.
An unofficial withdrawal is a student who stops attending without telling the college. The withdrawal date is the midpoint of the payment period or, if the college documents it, the last date of academically related activity, and the college must determine the withdrawal within 30 days after the end of the payment period. The Withdrawal Sweep agent opens a case from instructors' progress reports and, at term end, checks every aided student with all F and W grades.
No. Under 34 CFR 600.2, logging in without participating is not academic engagement. The Last Date agent counts a submitted quiz or assignment or a post in an assigned discussion, marks logins and page views as not counting, cites the log line, and asks the instructor to confirm when its confidence is below 0.90.
A module counts toward the payment period only when the student began attending it; schools that take attendance must document the withdrawal determination within 14 days of the last date of attendance; and a full-refund withdrawal exemption became optional. The Worksheet and Checker agents run the July 1, 2026 rules, and the full-refund exemption is a setting each college chooses.
Yes. An analyst prepares every case and resolves every difference with a reason code; the Director of Financial Aid signs every return and approves every notice; only the business office posts. The person who prepares cannot sign, and the person who signs cannot post. Agents never sign, send, post or move money.
The Agentic Solution Engine builds and deploys it from your requirements and documents, such as your withdrawal policy, term calendars and a sample of past cases, and it goes live once every quality gate has passed. We will walk you through it on your own withdrawals first.
Files cleared in hours, not weeks, with every value cited to its page.
1-min demoFinancial Aid Professional Judgment ReviewAppeals decided in days, not weeks, with the HEA 479A basis and every document cited.
1-min demoSatisfactory Academic Progress AppealsEvery appeal decided on cited evidence, every academic plan checked before the vote.
1-min demoWe'll run Return of Title IV Funds Calculation on a sample of your own withdrawals and term calendars.