(GRANTS-24-01) Federal Pell Grant Program Reconciliation

Author
Federal Student Aid
Electronic Announcement ID
GRANTS-24-01
Subject
Federal Pell Grant Program Reconciliation

In a Nov. 21, 2023 Electronic Announcement we published general information regarding Title IV Aid Disbursement Reporting, Excess Cash, and Reconciliation Requirements. In addition, updated disbursement reporting and data submission timelines for all programs were published in a recent Federal Register Notice see Federal Register Volume 88, Number 120 (Wednesday, June 21, 2023) for the 2023–2024 deadlines.

In this announcement, we provide specific information to assist your school in reconciling the Federal Pell Grant (Pell Grant) Program. The information provided below is for both the financial aid office and business office.

Pell Grant Reconciliation Defined

Pell Grant Reconciliation is the process by which a school reviews and compares Pell Grant data recorded on the U.S. Department of Education’s (the Department’s) systems with the information in the school’s internal records and resolves any discrepancies. This process should be performed on a regular basis and is recommended at least monthly.

Note: Conducting reconciliation frequently can help ensure that your school is properly exercising its fiduciary responsibilities to safeguard federal funds and ensure that they are used as intended.

There are two types of reconciliation, which can be performed separately or simultaneously during the month, including:

  • Internal Reconciliation

    This is the process where the business and financial aid offices compare disbursement transactions (actual disbursements and adjustments) and related cash transactions (Drawdowns, Drawdown Adjustments, Refunds of Cash, and Returns). If discrepancies are found, the school must document and resolve them in a timely manner.   

  • External Reconciliation

    The school compares its reconciled internal records to the Department’s records of funds received and returned, student disbursements and adjustments, and cash balances recorded in the Common Origination and Disbursement (COD) System. At a minimum, this reconciliation must be completed at least monthly to ensure that data is correct in all systems and that cash management and disbursement reporting timelines are being met. The Department offers various tools to assist you with external reconciliation. For more information, see the questions and answers below.

Schools may perform internal and external reconciliation in either order. However, if you have completed internal reconciliation first, there will be fewer discrepancies to resolve when you perform the external reconciliation.

It is very important for schools to maintain good communication between the Business Office and the Financial Aid Office to successfully reconcile both internally and externally. Reconciliation is a shared responsibility. It requires joint action by the Financial Aid and Business Office to identify discrepancies and any missing data, and to correct these in a timely manner.

Schools should document their reconciliation process and the resolution of any identified discrepancies.

Final Reconciliation of a Pell Grant Award Year

In addition to regular monthly reconciliation of Pell Grant data, a final reconciliation should be performed as soon as possible after final scheduled disbursements have been made for the award year. This final reconciliation should ensure that all data is correct, and the Total Net Drawdowns equals the Net Accepted and Posted Disbursements (NAPD), in the COD System (Cash >NAPD balance should equal $0.00). This process must be performed within the applicable data submission (closeout) deadline (defined below), as well as immediately following processing of any additional data by the school (for example, eligible late disbursements or disbursement adjustments made within regulatory timeframes, but which occur after the data submission deadline). There are two deadlines which impact this process:

  • Data Submission (Closeout) Deadline – The data submission (closeout) deadline is published annually in a Federal Register Notice. It is generally the end of September following the end of the award year. For example, the 2023–24 award year will close on Sept. 30, 2024. After this date, the COD System will not accept new or increased awards or new or increased disbursement amounts without prior approval for an extension to the established data submission (closeout) deadline. Downward adjustments will continue to be accepted without an extension. If your school needs to request an extension to the data submission deadline, this request must be submitted via the COD website at https://cod.ed.gov. For more information on Extended Processing, see question #10 in the questions and answers below.

  • Funding Cancellation Deadline – Pell Grant funding availability is canceled five years after the data submission (closeout) deadline for the award year. For example, for the 2018–19 Federal Pell Grant award year (July 1, 2018 - June 30, 2019), the funding cancellation date is Sept. 30, 2024 [2019 + 5 = 2024]. After the funding cancellation deadline, schools will be unable to report any further award or disbursement changes to the COD System for that award year. In addition, schools will be unable to draw down or adjust funds via the G6 website, and any refunds of cash must be made to the Pell miscellaneous account (contact the G6 help desk for instructions). As such, schools must complete all final reconciliation activities well before this final deadline and in accordance with disbursement reporting timelines and the data submission (closeout) deadline defined above.

Note: Schools should confirm closeout via the School Balance Confirmation page on the COD website once your school has completed its final reconciliation and reached a $0.00 Cash>NAPD.

Contact Information

For additional information on Pell Grant Program Reconciliation, refer to the Questions and Answers below. If you have questions about this announcement or its attachment, contact the FSA Partner and School Relations Center at 1-800-848-0978. You may also email CODSupport@ed.gov.

Questions and Answers

A1: A school should reconcile both internally and externally at least monthly to help meet all cash management and disbursement reporting requirements. However, the more frequently your school performs reconciliation, the more likely you will be able to identify discrepancies and resolve them before they become part of a systemic problem.

A2: The following items should also be verified during the reconciliation process:

  • Check disbursement dates to ensure the correct actual disbursement date is on file in the COD System.

  • Confirm that no disbursements are in a Pell Grant Potential Overaward Process (POP) situation.

  • Resolve stale dated/uncashed checks (unclaimed credit balances) by returning any unclaimed funds and processing the corresponding downward adjustments to disbursements.

A3: Reconciliation is a team effort consisting of the school’s Business Office and the Financial Aid Office, both of which have information that is needed to reconcile.

Note: If a school uses a third-party servicer, the school is ultimately responsible to ensure that all regulatory requirements are being met and that the school is reconciling on a regular basis. The school should request and retain documentation of your reconciliation efforts. Also, a part of your reconciliation should include ensuring that the school’s internal records match the third-party servicer’s records as well as what is in the COD website.

A4. The Department provides a Pell Grant School Account Statement (SAS) to all schools each month. The SAS is similar to a bank statement and provides the Department’s official Cash > NAPD balance as of the end of the reported month, as well as detailed cash and loan or disbursement detail transactions for the reported period. The SAS is the school’s primary tool used in reconciliation and closeout and should be compared to both financial aid and business office records.

Note: Schools should review SAS content and format options at least annually to ensure these continue to meet their reconciliation needs.

Additional information on the content and formats available for the SAS is available in the COD Technical Reference, Volume 6, Section 7: COD Reports.

Additional optional tools for assistance in reconciliation processes are addressed under Q10 below. However, the SAS must be used for regular monthly reconciliation.

A5: A school’s Cash > NAPD balance can be found on the COD website’s School Funding Information page (found under the “School” link in the blue tool bar along the top of the main page and the Funding Info link on the left-hand tool bar under School Information). It can also be found in the Pell Grant SAS for 2018-19 award year and forward.

Note: A school can also find Cash>NAPD and balance information by logging into the FSA Partner Connect website.  Once on the School Profile page, click on the School Financial Information link and then expand the School Funding Information section for the program and award year you are reconciling. For more information about FSA Partner Connect, refer to A13.

A6: The below formulas and examples illustrate this calculation:

Net Drawdowns - NAPD = Cash > NAPD

  • Example: $155,000 – $115,000 = $40,000

Drawdowns – Refunds of Cash = Net Drawdowns

  • Example: $159,750 – $4,750 = $155,000

Disbursements + Net Disbursement Adjustments (upward or downward) = NAPD

  • Example: $175,859 + ($60,859) = $115,000

Upward Disbursement Adjustments + Downward Disbursement Adjustments = Net Adjustments

  • Example: $10,000 + ($70,859) = -$60,859

If the Cash > NAPD is greater than zero ($0), your school needs to reconcile and determine if you need to report disbursements or return funds (excess cash).

If the Cash > NAPD is less than zero ($0), your school needs to reconcile and determine if you need to report downward disbursement adjustments or draw funds.

A7: A final reconciliation should be performed as soon as possible after your school’s final scheduled disbursements have been made for the award year. This process must be performed within the applicable data submission deadline, as well as immediately following processing of any additional data by the school (for example, disbursement adjustments made within regulatory timeframes, but occurred after the data submission (closeout) deadline, as well as returns of unclaimed credit balance checks; see Federal Student Aid Handbook, Volume 4, Chapter 5).

Note: Schools should confirm closeout via the School Balance Confirmation page on the COD website by completing the School Balance Confirmation form (found under the “School” link in the blue tool bar along the top of the main page and the “Balance Confirmation” link on the left-hand tool bar under School Information). Balance confirmation will allow your school to receive a Program Year Closeout Letter to document completion of final reconciliation. It also provides tighter controls over available funding and data submission.

Note: Schools can see additional Balance Confirmation information via the FSA Partner Connect website School Dashboard under the Origination and Disbursement Notification section.  This section will notify your school of balance confirmations needed for closed programs and award years and balance confirmations recently completed. For more information about FSA Partner Connect, refer to A13.

A8: Yes, a school should check their balances regularly even after the data submission (closeout) deadline and/or after you have reached a zero Cash> NAPD Balance because of POP situations, system-generated negative disbursements, and/or changes made in G6 that impact balances on the COD website. We recommend adding this step to your procedures and processing schedule.

Note: Schools can see notifications about unresolved Cash>NAPD balances for closed programs and award years via the FSA Partner Connect website under the Origination and Disbursement Notifications section, Unresolved Cash Balances Greater Than $25 for Closed Program or award year notification. For more information about FSA Partner Connect, refer to A13.

A9: The U.S. Department of Education (the Department) performs periodic global reductions of schools’ Current Funding Levels (CFL) after an award year closes. This global reduction reduces a school’s Available Balance in G6 and the COD System to zero. This zero Available Balance should not be confused with reconciling your net drawdowns to your net disbursements. Schools should monitor their “Cash>NAPD” on the School Funding Information page on the COD website to determine if they have completely reconciled to a zero balance.

Note: A school can find CFL information by logging into the FSA Partner Connect website. Once on the School Profile page, click on the School Financial Information link and then expand the School Funding Information section for the program and award year you are reconciling. For more information about FSA Partner Connect, refer to A13.

A10: Extended processing is not needed to submit downward award or disbursement transaction changes, non-financial changes, or upward changes due to POP. If you need to submit increases to award or disbursement or new disbursements after the data submission (closeout) deadline, you will need to request an extension to the deadline via the COD website Request Reopen/Extended Processing page. However, you should not submit a request until after you have completed reconciliation of all program records and are ready to submit increases or new award or disbursement data to the COD system. 

After the data submission deadline, no Extended Processing needed for:

  • Downward award changes

  • Downward disbursement adjustments (reduction to actual disbursements)

  • Non-financial changes

  • Upward changes due to POP

Extended Processing needed for:

  • Increases to Awards

  • Upward Disbursement Adjustments (increases to actual disbursements)

  • New disbursements

Note: You must submit a separate request for each award year for which Extended Processing is needed.

To request Extended Processing for the Pell Grant Program, log in to the COD website and complete the following steps:

  1. Go to the School Summary Information page by clicking on the School tab on the top blue bar and enter your school identifier information.

  2. Once on the School Summary Information page, click on “Request Reopen/Extended Processing” link located on the left-hand tool bar under School Information.

  3. Complete all required fields—including choosing the reason for the request from a drop-down menu and providing the required additional information. (Do not include Personally Identifiable Information (PII) data in this field (i.e. SSNs, award identifiers, etc.)). The Help link in the upper right corner has additional information to assist you in filling out the form.

  4. Click on the “SUBMIT” button below the data fields.

A11: There are various tools provided by the Department that your school can use to reconcile externally to the records maintained in the COD website.

Reports:

  • Pell Grant School Account Statement (SAS) (refer to Q4 above)

  • Pell SAS Disbursement Detail on Demand, available for the 2017–18 award year and forward – ad-hoc report that allows schools to get SAS Disbursement Detail data independent of the school’s monthly SAS file. This ad-hoc report can be modified to show monthly, year-to-date, or a selected date range to help customize the report for a user’s specific need.

  • Pell Grant Reconciliation Report – provides a one-record summary by student which includes the total year-to-date disbursement amount accepted in the COD System.

  • Pell Grant Year-to-Date (YTD) Report – contains detailed Pell Grant origination and disbursement data at a transaction level.

  • Pell Grant Electronic Statement of Account (ESOA) – summarizes the status of a school’s CFL versus the net drawdown for that award year, and includes YTD Unduplicated Recipient Count, YTD Total Accepted and Posted Disbursements, YTD Total ACA paid to school, and the net drawdown payments in G6 up to the current processing day.

  • Pending Disbursement List Report – contains disbursements not yet funded in the COD System (Disbursement Release Indicator (DRI)=False).

COD website:

  • Funding Information and Funding History Report – (found under the “School” link in the blue tool bar along the top of the main page and the “Funding Info” link on the left-hand tool bar under School Information), shows totals such as CFL, Available Balance, Net Drawdowns, NAPD and Cash > NAPD. These totals can be used to compare against your internal totals from both your Business Office and Financial Aid Office. If discrepancies are found, the detail should be compared, and any discrepancies resolved. The Funding History Report is the downloadable csv file available on the COD Funding Information Screen.

  • Cash Activity – (found under the “School” link in the blue tool bar along the top of the main page and the “Cash Activity” link on the left-hand tool bar under School Information), shows all individual drawdown, refund of cash, and drawdown adjustment transactions. This information is sent to the COD website from G6. This information can be used to reconcile to internal bank statements and cash transactions.

  • Anticipated Disbursement Queue – (found under the “Batch” link in the blue tool bar along the top of the main page and the “Anticip Disb Queue” link on the left-hand tool bar), lists all anticipated (pending) disbursements. It can be used to determine if anticipated disbursements need to be canceled (reduced to zero) or made into actual disbursements (DRI=True). This information is updated daily.

  • Action Queue – (found under the “Batch” link in the blue tool bar along the top of the main page and the “Action Queue” link on the left-hand tool bar), lists records that are in review by the Department’s Payment Analysts for schools on Heightened Cash Monitoring 2 (HCM2) or Reimbursement. Can be used by schools to ensure all records that the school intends to submit in their HCM2 submission have been sent to the COD website.

FSA Partner Connect website (refer to A13 for more information):

  • School’s Dashboard – This page has a section for Origination and Disbursement Notifications that can key your school into areas that need your immediate attention like unsubstantiated cash > 30 days, unresolved balances in closed award years, and balance confirmations needed.

  • School Profile, School Financial Information – This page contains sections that are very similar to the financial pages within COD but with some enhanced features.  They include the School Daily School Account Statement (SAS) Cash Information, School Funding Information, Cash Activity, and Refunds of Cash Information sections.

  • School Options and General Information– This page contains sections with information on Extended Processing status and your SAS Report Selections.

A12: Additional resources for reconciliation include:

A13: FSA Partner Connect is a website for individuals involved in the administration of Title IV financial aid for postsecondary education. On this site users can explore policy and guidance in the Knowledge Center, access helpful tools, find training announcements, or link to other Federal Student Aid websites to manage Title IV program eligibility and complete aid administration tasks. You can subscribe to get the latest news and updates from the FSA Partner Connect - Knowledge Center by clicking on this link: https://fsapartners.ed.gov/subscriptions/.

Below are the different features of the FSA Partner Connect Portal:

  • Knowledge Center: Repository of articles about the administration of Title IV federal student aid.

  • Federal Student Aid Handbook: Web-based, searchable version of the handbook

  • Training: Information about training and links to important training sites.

  • Financial Aid Delivery: Information about the financial aid delivery process as well as links to sites to complete related tasks.

  • Title IV Program Eligibility: Information about how schools can apply for and maintain eligibility for Title IV programs.

  • Origination and Disbursement Notification: A quick, top-level overview of an organization’s current operational status with call outs for the most important information.

  • Student, Parent, Borrower Accounts: Simplified search functionality to access information about a student, parent, or borrower easily.

  • Partner Search: Provides the ability to search and view information about a school.

Last Modified: 02/07/2024