Reconciliation
Last updated: May 14, 2020 by JTG
Purpose: To setup bank accounts of the school and view reconciliation of available accounts
Prerequisite/Dependencies: Finance Setup, Students, Payments
Output: For Bank Reconciliation/View all payment transactions
Go to Finance > Reconciliation
Creating a Bank Account
Payment transactions can be classified under different bank accounts depending on what accounts are setup in Reconciliation.
1) Click + Account.
2) 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
3) Once done, don't forget to click Add Account.
Editing a Bank Account's details
Click the ellipsis (three horizontal dots) of the account to edit; click Edit Details. Modify the contents as needed.
Viewing a Bank Account's Summary
1) An account will show summary details:
Bank balance – current bank balance based on payment transactions recorded
Verified – verified payment amount
Not verified – unverified payment amount
Invalid – Invalid transactions recorded
For now, payment verification feature is not yet available.
Viewing a Bank Account's Transactions
All the payment transactions made by students recorded by the cashier/finance through Payments module will also appear in Reconciliation.
1) Click View Transactions of the bank to search. The Summary box will also turn to Yellow to indicate that it is the currently selected account.
2) To breakdown the details, let's take the first example:
July 23, 2019 - when the transaction was actually made
Cash - payment mode of the transaction
AR 18998 - OR / AR number for the transaction
406577190019 - transaction sequence
Garrett, Dalton - student
10,000 - amount; how much was paid for that transaction
3) To search for payment transactions, click the search bar on the right side and type the keyword to search.
Sorting a Bank Account's Transactions
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 - amount of transaction; ascending or descending
By Student - alphabetical A-Z or Z-A
Downloading Summary Balance
1) Click the Kebab menu next to the Accounts, then click on Download Summary Balance
2) Select which school year to download, then click the Download.
3) Wait for the download to finish, and then open the file. It will show each student’s tuition, discount, collectibles before penalties, penalty, collectibles, total payment, balance, remarks, and balance percentage.
Tuition – Total tuition amount of the student
Discount – total discounts
Collectibles before penalties – total amount of collectibles
Penalty – penalties incurred for late payments
Collectibles – total amount collectibles with penalty
Total payment – total payment made
Refunds – total refund amount
Balance – student’s outstanding balance
Remarks – other information about the student's finances
Balance percentage – student’s total payment percentage
Frequently Asked Questions (FAQs)
Pending content
Last updated