This report gives the ability to match a student’s balance from the AR Card with the balance from an external system. The report includes the students that have transactions in GEGI or the students with the imported balance.
The "Reconciled" tab shows the students whose AR Card balance matches the balance from an external system.
The "Not Reconciled" tab shows the students whose AR Card balance did not match the balance from an external system, or the balance has not been imported from an external system.
Besides the standard filters from Search & Order, the following filters are available in the report: Balance from AR Card, Balance from External System. And you can compare Balance from External System with Balance from AR Card on any date using the Balance from AR Card Calculation Date filter:
The report can be downloaded as a CSV file. Click Export to CSV in the Actions drop-down menu below the table:
The external system balance can be imported for a student using the Import Student’s Balance link on the Balance Reconciliation page, or from the menu: Financial → Import → Import Student’s Balances:
Note: The imported file must be an XLS or an XLSX file and must contain the Student and the Amount columns.
At Step 2, you need to match the students from the file with the students from GEGI if they have not been matched automatically:
At Step 3, you will see all the records from the file that are ready for import. Balance records can be imported partially as well. The imported records will be highlighted:
