# 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="/files/dWYYbipNr3gSnVUh9LLk" 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="/files/DXJks0MGQTx2ZRKSlMuU" 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="/files/AJM0R131XaNSDkrRPPZL" 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="/files/T0El27SViTTR2MIuoT93" 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="/files/b6qpawHAdWUlB2J10lqI" 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="/files/AuDhOPQgezzWfwRbMILi" 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="/files/0Nrba6eW9nKXbw5H0Y5A" 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="/files/bwPnYJncLGLEy3Xomn20" 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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://info.edusuite.asia/product-guide-k12/admin-home/finance-module/reconciliation.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
