Navigator > Tasks > General Ledger > Account Reconciliation - OR -
Navigator > Maintain > General Ledger > Account Reconciliation List >
Insert button
Use GL Account Reconciliation to reconcile account balances against transactions, e.g. to reconcile a clearing account or suspense account. Reconciliation is optional.
Fields |
||||
Account Code |
The GL Account to perform the reconciliation for. |
|||
Reconciliation Amount |
The amount to reconcile to. (Zero displayed as empty) |
|||
Reconciliation Date |
The reconciliation date, must be within the reconciliation period. |
|||
Details |
Optional description for the reconciliation. |
|||
Status |
|
|||
Period |
The period for the reconciliation. The period must be equal to or later than the period for all transactions reconciled. |
|||
Closing Balance |
The closing balance for the selected Account, Branch, Department and Period. |
|||
Branch Code |
Select a Branch Code to reconcile for a single branch. Click
|
|||
Department Code |
Select a Department Code to reconcile for a single department. Click
|
|||
Toolbar |
||||
|
Expand Toolbar |
Expand the toolbar to give access to all toolbar options. Press |
||
|
Edit |
Edit the Account Reconciliation. |
||
|
Insert |
Insert a new Account Reconciliation. |
||
|
Memos |
Memos and alarms can be entered or edited. The button changes to indicate if memos and alarms are present. Opens Memos On... with a list of Memos. |
||
|
Links |
Opens Links On... for the record, with a list of links for the record. The button changes to indicate if links are present. |
||
|
Customise Toolbar |
|
||
Reconciled Grid |
||||
Transactions reconciled in this reconciliation. |
||||
Reconciled Grid Toolbar |
||||
|
Expand Toolbar |
Expand the toolbar to give access to all toolbar options. Press |
||
|
Move |
Reorder the transactions. |
||
|
Unselect All |
Unreconcile all the transactions in the reconciled grid. |
||
|
Open |
Opens the GL Batch the transaction was posted in. You can also double-click a line to open the transaction. |
||
|
Drill down |
View the source document. You can also double-click a line to open the transaction. |
||
|
Sort |
Sorts the transaction lines by a specified field or fields in ascending or descending order. When the reconciliation is saved, the lines are saved in the applied order. |
||
|
Customise |
Open Customise Fields, you can customise the fields visible in the grid. |
||
|
Customise Toolbar |
|
||
Reconciled Totals Panel |
||||
You can change the size of the grid by dragging the splitter bar. |
||||
|
Unreconcile |
Move the selected transaction on the Reconciled grid to the Unreconciled grid. You can also double-click the transaction to Unreconcile. |
||
Debits |
Total of the reconciled debit transactions. |
|||
Credits |
Total of the reconciled credit transactions. |
|||
Balance to Reconcile |
Amount still to reconcile. |
|||
Unreconciled Selections |
||||
|
Reconcile |
Move the selected transaction on the Unreconciled grid to the Reconciled grid. You can also double-click the transaction to Reconcile. |
||
|
Selection |
Select the unreconciled transactions to display. |
||
Unreconciled Grid Toolbar |
||||
Shows unreconciled transactions. Transactions from periods later than the reconciliation period are dimmed as they are unavailable. Move transactions from the Unreconciled grid to the Reconcilied grid. Once reconciled and closed, the grid will be unavailable. |
||||
|
Expand Toolbar |
Expand the toolbar to give access to all toolbar options. Press |
||
|
Insert |
Insert a new GL Batch. |
||
|
Select All |
Move all transactions currently displayed to the reconciled grid. |
||
|
Open |
Opens the GL Batch the transaction was posted in. You can also double-click a line to open the transaction. |
||
|
Drill down |
View the source document. You can also double-click a line to open the transaction. |
||
|
Filter / Sort List Clear Filter / Sort |
Apply or clear a Filter & Sort. The button changes to indicate if a filter and sort is applied. |
||
|
Print |
Print a report of the information in the grid. |
||
|
Customise |
Open Customise Fields, you can customise the fields visible in the grid. |
||
|
Refresh |
Transactions reload to reflect changes other Users may have made. |
||
|
Find Unreconciled |
Find transactions displayed in the unreconciled grid by searching on a combination of:
|
||
|
Customise Toolbar |
|
||
Unreconciled Totals Panel |
||||
Debits |
Total of the unreconciled debit transactions. |
|||
Credits |
Total of the unreconciled credit transactions. |
|||
Total |
Debits less Credits. |
|||
Lower Buttons |
||||
|
Print |
Print a reconciliation report. |
||
|
Close |
Mark transactions in the reconciled grid as reconciled and set the reconciliation status to Closed. You can only close a reconciliation if the Balance to Reconcile is zero. |
||
|
Re-open |
Re-open a closed reconciliation. Note: A reconciliation will automatically be re-opened if a transaction included in the reconciliation is Unposted. |
||
|
Save |
Save the reconciliation as status Open. |
||
|
Cancel |
Cancels work since the last save. |
||