Versions Compared

Key

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

The Bank Reconciliation window consists of several areas:

...


Bank Reconciliation window key fields and buttons

Fields

Field

Description

Unpresented

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

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.

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.

Manual Match

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

Multi Match


Option used to either match several transactions on:

  • The right pane with an individual transaction on the left pane. See Manually creating bank transactions to match to a G/L bank transaction (on page ).
  • The left pane with an individual transaction on the right pane. See Matching two or more G/L transactions to a bank transaction (on page ).
  • Both panes. See Matching two or more G/L transactions to two or more bank transactions (on page ).
    Note: There are limits to how many G/L transactions or bank statements may be included in a multi-matched statement. See Synergetic Financial Configuration - General tab in the Finance manual.


Buttons

O_20764

O_20774

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


Tip: Click the button repeatedly to move the entry down the desired number of lines.

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


Either match:

  • A single general ledger transaction with a single bank statement transaction. See Reconciling transactions not yet brought to account (on page ).
  • Several transactions to a single transaction. See Manually creating bank transactions to match to a G/L bank transaction (on page ).

    This button is disabled if the Selected values are different.
O_20807

Tip: You can also press Alt+M to match selected transactions.O_20770

Image Removed

O_20766

O_20767


To find an unpresented general ledger transaction:

  1. Enter one or more search criteria.
  2. Click .

    The first matching entry is highlighted.
O_21374
O_20756

O_21371


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


You can:

  • select a current bank reconciliation for a different bank account
  • create a new bank reconciliation.
O_17091
O_20808

Type ABANDON and click .

O_20769Control window.

Button

Description

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 ).

Anchor
O_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

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_20774

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

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

Anchor
O_20772O_20772

Reconcile the selected transaction and add it to the right pane.

Also see the Tick & Match field covered earlier.

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

O_20802O_20802
Anchor
O_20807
Anchor

O_20770

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

Anchor
O_20805O_20805
Anchor
O_20765O_20765
Automatically match manually

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_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.

Anchor
O_20806O_20806
Anchor
O_20767

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

Anchor
O_21372O_21372
Anchor
O_21374

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_20756

Display the bank reconciliation hints.

Anchor
O_21371
Anchor
O_9143O_9143

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

O_20786O_20786
Anchor
O_20757O_20757

Display the Select Current Bank Statement Control window.
anchor

O_21373O_21373
Anchor
O_17091

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

Anchor
O_20808

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.

When you click , 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_20769


Unpresented grid area fields (left pane)
AnchorO_20803O_20803

O_20771


Note: You cannot use the Reconciled flag to match transactions if Manual Match or Multi Match is selected. Select transactions and use thebutton.
Also see the 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_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

and 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_20812
O_20812

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
If the general ledger bank transactions are reconciled the following message is highlighted in green: G/L Reconciled.

O_20792

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_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_20790
O_20790
If the bank statement is reconciled the following message is highlighted in green: B/S Reconciled.


See Reconciling transactions not yet brought to account

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_20804
H_20804
(on page ).

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.

See:

  • Reconciling bank accounts using bank statements (on page )
  • Reconciling bank accounts using imported bank files (on page ).

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.

See:

  • Reconciling bank accounts using bank statements (on page )
  • Reconciling bank accounts using imported bank files (on page ).

Calc'd Closing Bal

Calculated closing balance determined by summing the following fields:

  • Opening Bal
  • Total.

 

...