Reconciliation
Last updated: January 2025
Last updated
Was this helpful?
Last updated: January 2025
Last updated
Was this helpful?
This feature allows you to set up bank accounts for the school and view the reconciliation of available accounts.
To access this module, go to Finance > Reconciliation
If you cannot view the link from the list, check the privilege assigned to your account or role.
Contact your school’s system administrator to request view or edit access if you cannot access the rights management screen.
Payment transactions can be classified under different bank accounts depending on what accounts are set up in Reconciliation.
Click + Account
Fill out the necessary details:
Name - what to call the account
Account number - the bank account number for this account
Branch - what branch this account was opened
Click Add Account once done
Click the ellipsis (three horizontal dots) of the account to edit; click Edit Details. Modify the contents as needed.
An account will show the Bank balance which is the current bank balance based on payment transactions recorded
For now, the payment verification feature is not yet available.
All the payment transactions made by students recorded by the cashier/finance through the Payments module will also appear in Reconciliation.
Click View Transactions of the bank to search. The Summary box will also turn yellow to indicate that it is the currently selected account
To break down the details, let's take the first example:
November 22, 2024 - when the transaction was made
CASH - payment mode of the transaction
OR 1486 - OR / AR number for the transaction
1247 - student number
DELA PEÑA - student name
4,088.82 - amount; how much was paid for that transaction
To search, click the Magnifying Glass icon in the upper-right corner of the page, enter a keyword, and press Enter. The relevant search results will then be displayed.
To sort, click the Arrow Down A-Z icon in the upper-right corner of the page and select a sorting option:
By Date - date of payment, ascending or descending
By Mode - cash, bank deposit, check, credit card, online payment; alphabetical A-Z or Z-A
By Amount - the amount of transaction; ascending or descending
By Student - alphabetical A-Z or Z-A
The sorted results will be displayed accordingly.
Click the Kebab menu next to the Accounts, then click on Download Summary Balance
Select which school year to download, then click the Download.
Wait for the download to finish, and then open the file. It will show the following columns
Student Number
Student Name
Year level
Section
Strand
Status
Payment Scheme
Total Assessment
Tuition
Miscellaneous
Lab Fees
Other Fees
Books
School Supplies
Instructional Materials
Donations
Optionals
Discounts
Penalties
Collectibles before additional charge from payment scheme
Collectibles before penalties
Collectibles
Total Payment
Refunds
Balance
Remarks
Balance Percentage
