# 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**

<figure><img src="https://3973081029-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M1SysIMhMO_ls3VlZcw%2Fuploads%2FE8vHgrvfcOHc4ud38L3a%2Fimage.png?alt=media&#x26;token=11237788-0844-47fd-b1f6-cc161aac8a67" alt=""><figcaption></figcaption></figure>

If you cannot view the link from the list, check the privilege assigned to your account or role.

{% hint style="danger" %}
Contact your school’s system administrator to request view or edit access if you cannot access the rights management screen.
{% endhint %}

## 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

<figure><img src="https://3973081029-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M1SysIMhMO_ls3VlZcw%2Fuploads%2F9Pcbpv4uVdDYoaXxC09s%2Fimage.png?alt=media&#x26;token=b3ebfd13-1f82-411b-8132-3fd716fe63fc" alt=""><figcaption></figcaption></figure>

## Edit a Bank Account Details

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

<figure><img src="https://3973081029-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M1SysIMhMO_ls3VlZcw%2Fuploads%2FmFHnrMCtkfzb6xZwpyzp%2Fimage.png?alt=media&#x26;token=10e9f219-6bb1-447a-94a1-f21df8d7af26" alt=""><figcaption></figcaption></figure>

## View a Bank Account Summary

An account will show the Bank balance which is the current bank balance based on payment transactions recorded

<figure><img src="https://3973081029-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M1SysIMhMO_ls3VlZcw%2Fuploads%2FidldlEpC8Li1ibv1z7Hg%2Fimage.png?alt=media&#x26;token=b52b31be-8c72-483b-8256-258db8f016d8" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://3973081029-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M1SysIMhMO_ls3VlZcw%2Fuploads%2FP49f4OW1rOyJBUIU8ayH%2Fimage.png?alt=media&#x26;token=bd0969ad-e581-4683-aa66-1770d063dc36" alt=""><figcaption></figcaption></figure>

* 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&#x20;
  * **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.

<figure><img src="https://3973081029-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M1SysIMhMO_ls3VlZcw%2Fuploads%2F1LkNXeEPihiOCTt1ig3p%2Fimage.png?alt=media&#x26;token=9f01cce1-a2a1-4fb0-a5cf-15a35d006caa" alt=""><figcaption></figcaption></figure>

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&#x20;
* **By Mode** - cash, bank deposit, check, credit card, online payment; alphabetical A-Z or Z-A&#x20;
* **By Amount** - the amount of transaction; ascending or descending&#x20;
* **By Student** - alphabetical A-Z or Z-A

<figure><img src="https://3973081029-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M1SysIMhMO_ls3VlZcw%2Fuploads%2F7jfUwORwXtoetehTqwyk%2Fimage.png?alt=media&#x26;token=3266085f-38cc-4d77-88f3-b02ddc90f7a1" alt=""><figcaption></figcaption></figure>

The sorted results will be displayed accordingly.

## Download Summary Balance

* Click the **Kebab** menu next to the **Accounts,** then click on **Download Summary Balance**

<figure><img src="https://3973081029-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M1SysIMhMO_ls3VlZcw%2Fuploads%2FkL1cdAfYDfneua032Cir%2Fimage.png?alt=media&#x26;token=ca3f2d70-9842-477e-b4cc-021b9827013e" alt=""><figcaption></figcaption></figure>

* 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
