Language:


Account Reconciliation

You will most commonly use this report to help with the task of bank reconciliation, which you should do using the Account Reconciliation register. The report is a list of Transaction rows (i.e. individual account postings) for the report period in date order, showing for each the Account, Transaction Number and Date, Amount in either Base Currency (as selected), Amount in foreign Currency (where appropriate) and whether it has been reconciled.

You can also produce this report from the Account Reconciliation register, by selecting 'Account Reconciliation' from the Operations menu.

When printed to screen, the Account Reconciliation report has the HansaWorld Enterprise Drill-down feature. Click on a Sub System Number (e.g. Invoice Number) in the report to open the Nominal Ledger Transaction for that Sub System record. You can then open the Sub System record itself (e.g. the Invoice) by selecting 'Open Subsystem Record' from the Operations menu.

Period
Paste Special    Reporting Periods setting, System module
All Transaction rows whose date falls in the period entered here will be included in the report. The default value is the first period in the Reporting Periods setting.

Accounts
Paste Special    Account register, Nominal Ledger/System module
Range Reporting    Alpha
Use this field to limit the report to Transaction rows posting to a certain Account, or range of Accounts. Usually you will need to specify your Bank Account(s) or other reconcilable Account here, otherwise the report will be much longer than necessary.

Objects
Paste Special    Object register, Nominal Ledger/System module
Specify an Object to list only those Transaction rows featuring that Object in the report. If you enter a number of Objects separated by commas, only those Transaction rows featuring all the Objects listed will be shown.

Balance Date
Paste Special    Choose date
Two totals are shown for each Account: the total reconciled during the report period and the total reconciled before a certain date. Specify that date here.

Recon. Code, Exclude with Code
If you want to list reconciled Transaction rows with a particular Recon. Code (entered on flip D of the 'Account Reconciliation' window), enter that Recon. Code here. To list all reconciled Transaction rows except those with a particular Recon. Code, check the Exclude With Code box as well.

This field and check box have no effect if you are only listing unreconciled Transaction rows.

Reconciled
Check this box to include reconciled Transaction rows in the report.

Unreconciled
Check this box to include unreconciled Transaction rows in the report. At least one of the Reconciled and Unreconciled boxes must be checked or the report will be blank.

Show Reconciliation Comments
When you reconcile each Transaction row, you can enter a Recon. Code on flip D of the 'A/C Reconciliation' window. This Recon. Code may be connected to a longer description in the Reconciliation Descriptions setting. Use this option if you want to print the longer descriptions in the report.

Values in
If you are using the Dual-Base system, values in this report can be shown in either Base Currency. Use these options to choose which Currency is to be used on this occasion.

If you are not using the Dual-Base system, use the Base Currency 1 option to produce a report in your home Currency.

Print
You can choose to show Object Codes or Comments in the report. If you choose the Comment option, the Description from the Transaction row is shown together with the Text from the Transaction header.