Reconciliation

This feature allows you to set up bank accounts for the school and view the reconciliation of available accounts.

Access and Navigation

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.

Create a Bank Account

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

Edit a Bank Account Details

Click the ellipsis (three horizontal dots) of the account to edit; click Edit Details. Modify the contents as needed.

View a Bank Account Summary

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.

View a Bank Account Transaction

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

Sort and Search Bank Account Transactions

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.

Download Summary Balance

• 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