Versions Compared

Old Version 2

changes.mady.by.user Former user

Saved on

compared with

New Version Current

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The Bank Reconciliation window consists of several areas:

  • A left pane which:
  • usually displays unpresented general ledger bank transactions before the closing date entered earlier
  • can be used to display presented general ledger bank transactions.
  • A totals area below the left pane, summarising the general ledger bank transactions.
  • A right pane which displays:
  • bank transactions reconciled with corresponding general ledger transactions (in the left pane)
  • manually-entered bank transactions, not yet matched to a general ledger transaction
  • manually-entered bank transactions, matching several bank entries to one general ledger transaction
  • bank transactions not yet brought to account (NYBA).
  • A totals area below the right pane, summarising the bank transactions.
    Image RemovedImage Added

 

Expand
titleOpening the Bank Reconciliation window

To open the Bank Reconciliation window:

  1. Select Module > General Ledger > Bank Reconciliation from the main menu.
    The Select Current Bank Statement Control window is displayed.
    Image RemovedImage Added
    Tip: You can also access General Ledger functions by clicking Image Removed Image Added.
  2. Click Image RemovedImage Added.
    The Create New Bank Statement Control window is displayed.
    Image RemovedImage Added
  3. Select the bank account to reconcile using the Bank Code drop-down list, if you have more than one bank account.
    Image RemovedImage Added
  4. Either:
    • enter the statement control details using details from the bank statement
    • accept the current control details if importing using a bank file.
    Image RemovedImage Added
    Note: Most of the details are usually populated from the previous bank reconciliation.
  5. Click Image Removed Image Added.
    The Bank Reconciliation window is displayed.
    Image RemovedImage Added


Bank Reconciliation window key fields and buttons
Fields

Field

Description

Unpresented

Display the unpresented general ledger bank transactions in the left pane.
Image Removed Image Added

Presented

Display the presented general ledger bank transactions in the left pane.

Selected

Two values are displayed. Each one totals the selected transactions in the corresponding pane.
Image Removed Image Added
You can match general ledger entries with bank entries when these values are equal. For an example, see Manually creating bank transactions to match to a G/L bank transaction (on page ).

Tick & Match

Option used to manually reconcile individual general ledger transactions, which are then added to the right pane.
In the following example, a general ledger transaction is being ticked (reconciled) and matched manually using the bank statement.
Image Removed Image Added

Manual Match

Option used to match individual transactions on the left and right panes.

Multi Match

Image Removed Image Added
Option used to either match several transactions on:


Buttons

Image RemovedDelete Image Added

Image RemovedImage RemovedImage Added

Image Removed Image Added
Tip: Click the button repeatedly to move the entry up the desired number of lines.

Image Removed
Image Added
Tip: Click the button repeatedly to move the entry down the desired number of lines. Image RemovedRemove the selected

Image Removed
Image Added
Tip: You can also double click on the entry in the right pane to remove it.

Image Removed
Image Added
Either match:

Image Removed
Tip: You can Image Added
Tip: You can also press Alt+M to match selected transactions. Image RemovedImage Added

Image Removed Image RemovedImage Added

Image RemovedImage Added

Image Removed Image RemovedImage Added

Image Removed Image Added
To find an unpresented general ledger transaction:

  1. Enter one or more search criteria.
  2. Click Image Removed Image Added.

    The first matching entry is highlighted.
    anchor Image Added
Image Removed Image RemovedImage Added

Image Removed Image RemovedImage Added

Image Removed Image Added
For field descriptions, see Manually creating bank transactions to match to a G/L bank transaction (on page ). Image Removed

Image Removed
Image Added
You can:

  • select a current bank reconciliation for a different bank account
  • create a new bank reconciliation.
Image Removed
  • .
Image Removed
Image Added
Type ABANDON and click Image Removed Image Added.

Image RemovedImage Added

Image RemovedImage Added

Button

Description

Image RemovedImage Added

Add bank statement transactions manually.
These can be used to add one or more bank transactions that correspond to a general ledger transaction. See Manually creating bank transactions to match to a G/L bank transaction (on page ).
Image Removed Image Added

Anchor
O_20764O_20764

Delete the selected manual bank statement transactions, if allowed.
Note: You cannot delete reconciled transactions, items in red and NYBTA items from a previous bank reconciliation.
Manually-entered transactions are initially displayed in a black font while reconciled transactions are displayed in a blue font. In the following example, transactions 8 and 9 were entered manually and either can be deleted.

Anchor
O_20785O_20785

Image Added

Move the selected transaction before the next transaction.
You can change the order of the transactions so that they match the order on the bank statement. In the following example, the 5th entry is being moved before the 4th entry. The Ord fields are renumbered accordingly.

Anchor
O_20774O_20774

Image RemovedImage Added

Move the selected transaction after the next transaction.
You can change the order of the transactions so that they match the order on the bank statement. In the following example, the 4th entry is being moved after the 5th entry. The Ord fields are renumbered accordingly.

Anchor
O_20773O_20773
Anchor
O_20761O_20761

Image Added

Remove the selected transaction from the right pane, so that it is no longer reconciled.

Anchor
O_20772O_20772

Image RemovedImage Added

Reconcile the selected transaction and add it to the right pane.
Image Removed Image Added
Also see the Tick & Match field covered earlier.

Image RemovedImage Added

Match the selected transactions if the Selected values are equal on the left and the right panes.

Anchor
O_20802O_20802
Anchor
O_20807O_20807

Anchor
O_20770O_20770

Reverse the match between the corresponding entries in the left and right panes.

Anchor
O_20805O_20805
Anchor
O_20765O_20765

Image Added

Automatically match manually-entered bank transactions with the general ledger transactions in the left pane. For example, Synergetic can match transactions based on the common cheque numbers.
Synergetic automatically matches transactions when you import a file.

Anchor
O_20766O_20766

Refresh the left pane so that the latest general ledger bank transactions are displayed. This is useful if other people are adding entries while you are doing the bank reconciliation.
Tip: You can refresh the grid by right-clicking and selecting Refresh Grid.
anchorImage Added

O_20806O_20806
Anchor
O_20767O_20767

Find an unpresented general ledger transaction in the left pane using the Find Entry window.

Anchor
O_21372O_21372O_21374O_21374

Image Removed

Image Added

Load transactions from a bank file and automatically match them with general ledger transactions.
See Reconciling bank accounts using imported bank files (on page ).

Anchor
O_20756O_20756

Display the bank reconciliation hints.

Anchor
O_21371O_21371
Anchor
O_9143O_9143

Image Added

Change the bank statement control details on the Create Bank Statement Transaction window.

Anchor
O_20786O_20786
Anchor
O_20757O_20757

Image Added

Display the Select Current Bank Statement Control window.

Anchor
O_21373O_21373
Anchor
O_17091O_17091

Image Added

Abandon the current bank reconciliation. For example, you may want to start the reconciliation again.
The Abandon Bank Statement window is displayed.

Anchor
O_20808O_20808

Image RemovedImage Added

Close off the current bank reconciliation if the bank account is reconciled for the selected period.
Tip: You can tell that the current bank reconciliation is reconciled if the following two messages are displayed at the bottom of the window: B/S Reconciled and G/L Reconciled.
The following dialog window is displayed.
Image Removed Image Added
When you click Image Removed Image Added , the Bank Reconciliation report is spooled to your default Synergetic printer. You can then reconcile the next bank account statement or bank file.

Anchor
O_10556O_10556

Close the Bank Reconciliation window if you need to continue doing other tasks.
You can return to the reconciliation by selecting the bank reconciliation control from the Select Current Bank Statement Control window.

Anchor
O_20769O_20769


Unpresented grid area fields (left pane)
AnchorO_20803O_20803 Image Removed)
Image Added


Image Removed
Image Added
Note: You cannot use the Reconciled flag to match transactions if Manual Match or Multi Match is selected. Select transactions and use the Image Removed Image Added button.
Also see the Image Removed Image Added button above.

Field

Description

G/L Date

Date of the posting in the general ledger.

Chq No

Cheque number.
The cheque number is blank for transactions not involving a cheque.

Description

Description from the cheque, EFT or receipts posting.

Deposits

Amount of the deposit or transaction that increases the bank account current balance.

Withdrawals

Amount of the withdrawal or transaction that decreases the bank account current balance.

Reconciled

If selected, this transaction has been reconciled.
If Tick and Match is selected:

  • select to reconcile the transaction and add it to the right pane
  • clear this field to unreconcile it and remove it from the right pane.
Anchor
O_20771O_20771

Posting No

Posting number for the transaction.

Posting Source

Source of the posting.

Chq Date

Date of the cheque if the transaction involves a cheque.

Cancelled

Selected if the cheque has been cancelled.

GLBTSeq

A unique number to identify the General Ledger Bank Transaction.


Bank transactions grid area fields and legend (right pane)
AnchorO_20809O_20809 Image RemovedImage Added

Image Removed and Image Removed .
See the Image Added and Image Added buttons above.

Field

Description

Ord

Order of the bank transaction.
It is optional whether you move the transactions into the same order as the bank statement. It depends on the policy at your organisation.
See the

Anchor
O_20759O_20759
Anchor
O_20760O_20760

Date

Date the deposit or withdrawal occurred against the bank account.

Chq No

Cheque number of any cheque payments.
This is blank for transactions that do not involve a cheque.

Description

Description for the:

  • reconciled general ledger transaction
  • manually-entered bank transaction
  • bank transaction not yet brought to account.

Deposits

Amount if the transaction is a deposit or a transaction that increases the bank account current balance.

Withdrawals

Amount if the transaction is a withdrawal or a transaction that decreases the bank account current balance.

Reconciled

If selected, the transaction has been reconciled.


Legend
AnchorO_20812O_20812 Image RemovedImage Added

Font

Background

Description

Red

White

NYBA bank transactions, such as when fees have been paid into the account by EFT before the slip has been received and entered.

Blue

White

Reconciled transactions. Also includes manually-entered bank transactions that have been matched.
Note: Reconciled transactions have the Reconciled flag selected. If a reconciled transaction is selected, the Reconciled field of all matching transactions is highlighted green.

Black

White

Manually-entered bank transactions that have not been matched.

White

Blue

Currently selected record.


Bank Reconciliation window G/L Reconciliation area (below left pane)
AnchorO_20791O_20791 Image RemovedImage Added
If the general ledger bank transactions are reconciled the following message is highlighted in green: G/L Reconciled.

Image RemovedImage Added

Field

Description

Unpresented deposits

Total amount of unpresented deposits in the left pane prior to the Closing Date specified on the Create New Bank Statement Control window.
The total does not include greyed out transactions. That is, unpresented general ledger transactions after the closing date.

Anchor
O_20792O_20792

Unpresented withdrawals

Total amount of unpresented withdrawals in the left pane prior to the Closing Date specified on the Create New Bank Statement Control window.
The total does not include greyed out transactions.

Unpresented Total

Calculated sum of the following fields:

  • Unpresented deposits
  • Unpresented withdrawals.

NYBA

Not Yet Brought to Account total.
See Reconciling transactions not yet brought to account (on page ).

B/S Closing Bal

Closing balance of the bank account on the closing date.
See Closing Bal in the B/S Reconciliation area below.

Variance

Calculated difference between the following fields:

  • Actual G/L Bank Bal
  • Calc'd G/L Closing Bal.
    The following message is highlighted in green when this field is zero: G/L Reconciled.

Actual G/L Bank Bal

Actual general ledger bank closing balance.

Calc'd G/L Closing Bal

Calculated general ledger bank closing balance. This is the calculated sum of the following fields:

  • B/S Closing Bal
  • Unpresented Total
  • NYBA.


Bank Reconciliation window B/S Reconciliation area (below right pane)
AnchorO_20790O_20790 Image Removed)
Image Added
If the bank statement is reconciled the following message is highlighted in green: B/S Reconciled.

Image Removed
Image Added
See Reconciling transactions not yet brought to account (on page ).

Field

Description

Reconciled dep

Total amount of reconciled deposits in the right pane.

Reconciled w/d

Total amount of reconciled withdrawals in the right pane.

NYBA

Not Yet Brought to Account total.
In the following example, a deposit of $2350 has appeared on the bank account. We cannot reconcile it today as we do not have a corresponding general ledger entry. This will be resolved when details come through from the debtor who has paid by EFT before sending in their fees slip. Once this transaction is reconciled the NYBA total drops to zero.

Anchor
O_20793O_20793
Anchor
H_20804H_20804

Total

Net amount calculated as the sum of the following fields:

  • Reconciled dep
  • Reconciled w/d
  • NYBA.

Opening Bal

Opening balance of the bank account on the opening date.
This is entered on the Create New Bank Statement Control window.
Image Removed Image Added
See:

Diff

Calculated difference between the following fields:

  • Closing Bal
  • Calc'd Closing Bal.
    The following message is highlighted in green when this field is zero: B/S Reconciled.

Closing Bal

Closing balance of the bank account on the closing date.
This is entered on the Create New Bank Statement Control window.
Image Removed Image Added
See:

Calc'd Closing Bal

Calculated closing balance determined by summing the following fields:

  • Opening Bal
  • Total.

 

...