Home » Categories » Solutions by Business Process » Finance » Nominal and Cashbook

Cashbook Bank Reconciliation Improvements

Datafile Software

Cashbook Bank Reconciliation Improvements

The Bank Reconciliation screen displayed a list of 10/16 transactions per screen and you scrolled up/down the list as you reconciled the transactions against your bank statement but when there are large numbers of transactions to reconcile this can be unwieldy. This release allows a pick list interface for the reconciliation listing all the transactions on one screen.



You can scroll up/down the transaction list using the up/down arrow keys or the page-up/down keys.You can use the END key to take you to the bottom of the list and the HOME key to take you back to the top of the list; you can also use the mouse to scroll the slider on the right up/down.

To reconcile a transaction you can double-click an entry with the mouse or press the <Enter>, <Space> or <Y> key against the highlighted transaction entry.To clear a reconciliation you can double-click an entry with the mouse or press the <Enter>, <Space> or <N> keys against a reconciled transaction.

Options at the bottom of the screen allow:

Reconcile – select to reconcile the current highlighted transaction, selecting against an already reconciled transaction clears the reconciled flag.

Info – displays additional information relating to the highlighted transaction.

Search – allows you to search for a withdrawal or deposit on the basis of a matching reference or amount.

Comment – allows entry or view of a reconciliation comment against the transaction.

Trans – allows entry of a new receipt, payment or bank transfer transaction for inclusion in this reconciliation.

Update – completes the current reconciliation. Depending on additional configuration settings this allows you to either update the reconciliation or save the reconciliation in progress to continue later.

Close – exits the reconciliation procedure (allowing you to update – if matching balance, exit or save the reconciliation in progress).

In addition to these options the standard pick list tools to sort, filter or find entries in the list are available by right-clicking the appropriate column heading with the mouse.

Installation

Application User Facilities

To enable the pick list interface users can sign on as the SYSTEM user-id (or if Premier any user with ‘Installer’ privileges) and right-click against the menu option for the Bank Reconciliation and select to Configure Option. Alternatively users can select Installation from the main menu followed by Application Manager and then Application User Facilities. Select the Cashbook application as required before selecting Bank Reconciliation and Bank Reconcile.


Use Pick List – set to use the pick list interface for the bank reconciliation.Once set an option to set the highlight colour to use when a transaction is marked as reconciled is displayed, select the colour required (custom colour options are not available). Note that the option to ‘Use tick not Y/N’ is not applicable when using the pick list entry options.

Custom Fields
  • Release ID: 6.5
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
VAT Form 100 - Process on Period Dates
Viewed 2433 times since Tue, Jun 12, 2012
Bank Reconciliation – Default Date for New Transactions
Viewed 1164 times since Wed, Jun 13, 2012
VAT Form 100 - Cashbook
Viewed 2448 times since Wed, Jun 27, 2012
Cash Book Configuration
Viewed 1840 times since Thu, Jun 28, 2012
Account Cash Book - Nominal - Database Profiles
Viewed 1699 times since Thu, Jun 28, 2012
Receipt Posting – Advanced Search Options for Sales A/C’s
Viewed 1279 times since Wed, Jun 13, 2012
Application Screen Layouts - Cashbook
Viewed 1873 times since Thu, Jun 28, 2012
Quick Allocation Options
Viewed 1804 times since Wed, Jun 13, 2012
Account Enquiry - Nominal
Viewed 1569 times since Wed, Jun 27, 2012
Standard Update – Payroll - Nominal
Viewed 1601 times since Thu, Jun 28, 2012