A/C Reconciliation
This report will most commonly be used to aid the task of bank reconciliation, which is done using the
Account Reconciliation register. The report is a list of Transaction rows (i.e. individual account postings) for the report period, 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.
- 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
Current 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 A/C Reconciliation screen), 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.
- 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 the Comment option is chosen, the Description from the Transaction row is shown together with the Text from the Transaction header.