(Contents)(Previous)(Next)

Bank Reconciliation Report

To support the audit trail from the bank reconciliation, a report is available which can be ranged between dates, together with the facility to show all transactions - reconciled and unreconciled or reconciled only.

The report is sequenced by date with a sub-total on change of date and, for each bank account transaction printed, will show the date of the posting, the source module, the daybook number, the posting reference and narrative, the suffix where appropriate, the Sales or Purchase Ledger account if relevant, the transaction value in both the base and foreign currency, the currency code, and the reconciled indicator.

To run a Bank reconciliation report:

  1. From the Autoline master menu select the Nominal Ledger option and the company you require.

  2. Select the Bank & currency options option.

  3. Select the Bank reconciliation report option.

  4. The Reconciliation report (NL) form is displayed.

The Reconciliation Report Form

Enter Expense Code: This is the bank account expense code for Report selection. There is no search facility available.

Start Date (or blank) : Enter here the starting date of the report or leave blank for full range. To aid the search, a calendar is displayed by clicking the button.

End Date (or blank): Enter the end date for the report or leave blank for full range. A similar search is available here by clicking the button.

Include Reconciled Items Y/N: Enter a Y to show all transactions whether reconciled or not. The report will indicate their status. Enter a N to only report on unreconciled transactions.

BUTTONS

OK: Commences printing to your specific printer immediately.

Cancel: Returns you to the NL Bank and Currency Menu with no report run.

Help: Displays help on the current application using the default company browser.

To Schedule a report, the user will enter the relevant selection criteria, then click the Schedule button on the form. This will then bring up the Timed Operations screen, and from there the user can add the report to run at a time and frequency that is convenient. For more information, refer to Batch Printing

The Add to Batch button option allows users to run several [often related] reports in a group at once. [e.g. to save time they may run the batch whilst away from their terminal] To run a batched report:

Select the report you wish to run, and fill in the relevant selection criteria, if any is required. If the report is available to be batched on, there will be a button entitled "Add to batch", which must be clicked to bring up a child window prompting the user to enter a Report Group There is no search facility here but if the user types in an entry that does not already exist, it will be created there and then, and if the entry does already exist, it will be added to the report group. There is also a box that will allow the user to set the priority required to execute the report.

Once a report has been added to a group, the running of the batch can take place. This actually takes place by selecting the Report Generator menu option, and then selecting the "Batched Reports" option. Consequently the user can select the report group required [Batch Identifier] with the box, and this will display all the reports in the selected group. At this point the user can also Amend the selection criteria of a report, can Exclude it from the group at this time, or Remove it from the group completely. Alternatively, the user can Run batch, Exit altogether, or access online Help .

(Contents)(Previous)(Next)(Top of the Page)