School staff must match their students' payments to the College Board's (CB) AP exam order.
School staff keeps track of student payments using various tools, most of which do not allow auto-reconciling with the CB's exam order. Many schools will print out a list of their payments from their accounting system and print their Student Roster from the College Board's system. Staff will then compare these two reports name-by-name, line-by-line, and note any student that has:
Schools then communicate with the students who have the above issues to resolve these before ordering exams, and students sit for exams. Unfortunately, history has proven that it is difficult to collect payments for exams after exams have been administered.
Schools will also compare the students' fee reduction status in CB to their records for students. Schools will edit students' status in CB systems if there is a discrepancy ensuring that CB invoices the schools properly for students who receive fee reductions. Failure to do this results in schools receiving considerably larger AP invoices.
Total Registration (TR) recognizes how time-consuming and overwhelming it is to match reports by hand, student-by-student, so TR created a utility that automates this reconciliation process. Schools download their Student Exam Roster from CB's system and then upload this file into TR's Reconciliation Utility.
The system automatically matches students at the click of a button (using multiple criteria: First Name, Last Name, Student ID, Email Address) and places students in one of several categories:
This table typically contains the majority of students and does not require any further action. Here's an example of this table from TR:
These students have either more exams in TR than CB, more exams in CB than TR, or their fee reduction status does not match in the two systems. Here's an example of what this looks like in TR:
These students enrolled for their exam in the College Board's system but have not registered in TR and therefore have not paid.
These students registered in TR but have not used their join codes to enroll for their exams in CB or did enroll but have not yet indicated in CB that they want to take the exam.
The reconciliation utility remembers all changes made and can be run at any time, even with a new Student Roster file from CB to identify any issues after new registrations, enrollments, and dropped exams.