---
title: "Month End > Bank Reconciliation"
canonical: "https://technology.bytangram.com/space/TGKB/257393137/Month%20End%20%3E%20Bank%20Reconciliation"
format: markdown
---
**Bank reconciliation** happens in the finance and administration module and is usually managed by designated role(s) or person(s) within each agency or office.

| **ON THIS PAGE YOU WILL FIND:** |
| --- |
| > Macro (toc) |

---

## UPLOADING THE BANK FILE

- Go to the finance & administration module > **month-end **
- Click **bank reconciliation **> go to the **bank account** tab > select the relevant **bank account**

![image](media://7faeb2cc-a34b-4d6a-bd79-7c0d8689d4d6)


- Click on the **import file** tab > select the **import icon**

![image](media://0c9e6114-b433-4d34-adcf-b09d3f881291)


- In the **specification** drop-down select **import of bank data** > in **source** select your downloaded bank file
- Click **ok – import data**

![image](media://e8f49c27-bdbe-4c79-bb66-af9d429fc7a0)


---

## AUTOMATIC RECONCILIATION

- Go to the **reconcile** tab, here the Workbook transactions appear on the left and imported transactions on the right
- Select **auto elimination** to automatically reconcile the transactions that match

![image](media://fe29c8f8-b1b4-4c16-a307-51f888e37826)


> 📝 Keep “hide eliminations” and “close elimination when in balance” checked so, that reconciled transactions will be moved to the bottom of the screen


![image](media://012eff66-76d1-4b94-9c39-8b58636146e6)


---

## MANUAL RECONCILIATION

For remaining transactions, you will need to reconcile and then approve them manually using the check marks next to the transactions.

- When you have two transactions that match check the **reconciled box **of each
- The click the **approve** icon

![image](media://ffba1bd1-2586-4080-bf09-210797c7a785)


---

## RECONCILING NON CREDITOR/DEBTOR RELATED TRANSACTIONS

For bank transactions that are not related to a creditor/debtor invoice (for example bank fees/interest) then you can create and journalise the entries. To do this: 

- **Select** the **transaction**
- Click on the **+ icon**
- In the pop-up, select the **account and description**
- Click **finalise and post**

![image](media://818e517f-f6a2-4ad6-8ee3-e4075c91482d)


---

## REMOVING ELIMINATIONS

- If you need to remove an elimination and redo it, you can do this by **unticking hide eliminations**
- Find the transaction in either the top left or top right box
- Click **remove eliminations**

![image-20240729-214602.png](media://ff5cc2f3-6bf3-4550-aff9-ede81af2d92e)

- The transaction is now available to be re-reconciled.

---

## FINALISING ELIMINATIONS

- Once your bank reconciliation is complete (all transactions balance to $0.00 and are reconciled/approve), click **finalise eliminations**
- In the pop-up enter a **description** and **date**
- Click **ok**

![image](media://a7684ce6-660c-44c8-82f3-a616bc141373)


---

### Related articles

> Macro (contentbylabel)