Previous Topic

Next Topic

Book Contents

Book Index

GL Account Reconciliation

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

  • Open - reconciliation is in progress.
  • Closed - reconciliation is closed and transactions marked as reconciled.
  • Deleted - reconciliation deleted.

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 All branches to clear the selection. (Accredo Saturn only)

 

Department Code

Select a Department Code to reconcile for a single department. Click All departments to clear the selection. (Accredo Saturn only)

 

Toolbar

ToolbarExpand

Expand Toolbar (Ctrl+F9)

Expand the toolbar to give access to all toolbar options. Press Esc to close the expanded toolbar.

Edit (F11)

Edit the Account Reconciliation.

Insert (F4)

Insert a new Account Reconciliation.

RecordMemo

Memos (F6)

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.

RecordLinks

Links (Alt+F6)

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

ToolbarExpand Customise Toolbar or right-click in the toolbar below the buttons to access the Customise Toolbar Menu.

Reconciled Grid

Transactions reconciled in this reconciliation.

Reconciled Grid Toolbar

ToolbarExpand

Expand Toolbar (Ctrl+F9)

Expand the toolbar to give access to all toolbar options. Press Esc to close the expanded toolbar.

Move (Shift+Up) (Shift+ Down)

Reorder the transactions.

Unselect All (Shift+F3)

Unreconcile all the transactions in the reconciled grid.

Open (F12)

Opens the GL Batch the transaction was posted in. You can also double-click a line to open the transaction.

Drill down (Shift+F12)

View the source document. You can also double-click a line to open the transaction.

Sort (Ctrl+F2)

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 (Alt+F5)

Open Customise Fields, you can customise the fields visible in the grid.

 

Customise Toolbar

ToolbarExpand Customise Toolbar or right-click in the toolbar below the buttons to access the Customise Toolbar Menu.

Reconciled Totals Panel

You can change the size of the grid by dragging the splitter bar.

Unpost

Unreconcile (Ctrl+Down)

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 (Ctrl+Up)

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.

ToolbarExpand

Expand Toolbar (Ctrl+F9)

Expand the toolbar to give access to all toolbar options. Press Esc to close the expanded toolbar.

Insert (F4)

Insert a new GL Batch.

Select All (Shift+F4)

Move all transactions currently displayed to the reconciled grid.

Open (F12)

Opens the GL Batch the transaction was posted in. You can also double-click a line to open the transaction.

Drill down (Shift+F12)

View the source document. You can also double-click a line to open the transaction.

RecordFilterSort_Hot

Filter / Sort List (Ctrl+F2)

Clear Filter / Sort (Ctrl+F3)

Apply or clear a Filter & Sort. The button changes to indicate if a filter and sort is applied.

Print (Ctrl+P)

Print a report of the information in the grid.

Customise (Alt+F5)

Open Customise Fields, you can customise the fields visible in the grid.

Refresh (F5)

Transactions reload to reflect changes other Users may have made.

Find Unreconciled (Ctrl+F)

Find transactions displayed in the unreconciled grid by searching on a combination of:

  • Account - exact match required.
  • Branch - exact match required. (Accredo Saturn Only)
  • Department - exact match required. (Accredo Saturn Only)
  • Reference - must contain the text searched on.
  • Comment - must contain the text searched on.
  • Narration - must contain the text searched on.
  • Source ID - exact match required.

 

Customise Toolbar

ToolbarExpand Customise Toolbar or right-click in the toolbar below the buttons to access the Customise Toolbar Menu.

Unreconciled Totals Panel

Debits

Total of the unreconciled debit transactions.

Credits

Total of the unreconciled credit transactions.

Total

Debits less Credits.

Lower Buttons

Print (Ctrl+P)

Print a reconciliation report.

RecordClose

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 (F9)

Save the reconciliation as status Open.

Cancel (Esc)

Cancels work since the last save.

In This Section

GL Account Reconciliation - Links tab

GL Account Reconciliation - Memos tab