---
title: "GL Account Reconciliation Dashboard"
canonical: "https://kb.myframeworks.com.au/space/FRAM/28401478/GL%20Account%20Reconciliation%20Dashboard"
format: markdown
---
# Overview
The **Account Reconciliation Dashboard** is a powerful tool that assists in managing the reconciliation process for your **Purchase Clearing** and** Internal Control GL accounts**. It provides an overview of unreconciled amounts for each account up to a specified period end and allows you to download unmatched reports generated by the Branch Transfer and Purchases Clearing Reconciliation tasks. With the ability to select a GL account, you can manually match and reconcile any transactions that were not automatically reconciled. This ensures accurate reconciliation before the GL period closes, contributing to improved financial management.
To begin reconciling your Purchase Clearing and Internal Control GL accounts, it is important to run the [Branch Transfer Reconciliation Scheduled Task](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28409778) and the [Purchase Clearing Reconciliation Schedule Task](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28409788) first. These tasks will generate records on the GL Account Reconciliation Dashboard, enabling you to review and manually reconcile any remaining unmatched transactions efficiently.
# GL Account Reconciliation Enquiry
To enquire on open GL transactions requiring reconciliation, from the home **Dashboard** perform the following:
1. From the **Frameworks Menu**, navigate to **General Ledger > Enquiries > Account Reconciliation Dashboard **from the navigation tree.
2. Search by** Company, From Date and To Date, **select** Find **to display a list of reconciliation results.
3. The list of results is displayed.
> ℹ️ Where there are no unreconciled accounts from the results of the branch transfer or purchase clearing reconciliation scheduled task, the results will still be output; however, there will be a **$0** amount in the unreconciled column.
![image]()
For more information about the GL Dashboard fields, click here.
| **Column** | **Description** |
| --- | --- |
| **Company** | The company interrogated as part of the GL account reconciliation |
| **Date Run** | Date the reconciliation task was run. |
| **GL Account** | The GL account that the reconciliation task was run against. Click on the hyperlink to open the reconciliation dashboard in order to match unmatched transactions and review those that are already matched. Refer to [Matching GL Account transactions](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28401478/GL+Account+Reconciliation+Dashboard#Matching-GL-Account-transactions) below for more information |
| **To period** | Reconciled transactions up to this period end date |
| **Total Unreconciled** | Total dollar value of unreconciled account entries. |
| **Unreconciled List** | Click on the hyperlink to open a .csv output of all unreconciled transactions for the GL account being reconciled. |
# Matching GL Account transactions
From the GL Account Reconcilation Dashboard screen select the required reconciliation via the GL Account hyperlink to open the source transactions available for matching. To match GL transactions perform the following:
![image]()
1. From within the "unmatched" tab locate a transaction on the left side of the screen and enable the transaction to select. Click on a transaction of the right side of the screen under **credits** you wish to match against the **debit** on the left side of the screen.
2. Select "Match" to match the transactions. This will add them under the "Matched" tab for review.
![image]()
> ⚠️ Where the debit and credit matches exactly you will notice the **GL variance account** and** BAS Code** will be greyed out. Only the "Match" button will be available to select.
3. Where the debit and credit transactions ticked are not a perfect match, the user will be required to enter a GL Variance account to post the variance amount to before the "Match" button will become available.
![image]()
4. Continue matching debits and credits until all transactions have been manually reconciled.
5. Click on the "Matched" tab to view the matched transactions for the GL Account:
![image]()
# Additional Information
Configuration/Flags
The Reconciliation Scheduled Tasks are run based on any GL accounts setup as **Purchase Clearing** Accounts under Chart of Account Maintenance 'Control Account Type' e.g.:
![image]()
This field will be used to reconcile the purchase clearing accounts for a branch using the scheduled task below, the task will attempt to reconcile ALL accounts marked in COA maintenance as Purchase Clearing Accounts, find all posting in that account.