To generate a Reconciliation report

This report allows you to display a list of reconciled or unreconciled transactions.  

1. From the top menu choose Reporting. On the Transactions tab choose Bank and Reconciliation report.
2. In the Display section, set the options you require:
   • Select the Reconciliation status you want to include (choose from Reconciled transactions or Unreconciled transactions).
   • In the Show report with area, select the information you would like to include:
     • Gross totals
     • Short report format - with option to include invoice number.
     • Search criteria - to include the search criteria in the report.
     • Report notes boxes. The following text box will appear for you to enter your text.
3. In the Settings section, enter any criteria you want to apply to this report as follows:
   • Select the Transaction types you want to include (choose from Income, Expenditure, Journal transfers and Last year's transactions).
   • In the From bank accounts field, by default all bank accounts are selected. If you want the report to include transactions from only selected bank accounts, click on the required account, or hold down the Ctrl key to select multiple accounts.
   • Budget codes - To include only a section of the alphabetic list in the report, choose the first and last codes to include from the two drop-down lists.
   • Sources/Suppliers - To include only a section of the alphabetic list in the report, choose the first and last accounts to include from the two drop-down lists.
   • Analysis codes - To include only a section of the alphabetic list in the report, choose the first and last analysis codes to include from the two drop-down lists.
   • Periods - To restrict the report to a particular range of periods, enter the first and last period number in the two text boxes.
   • Dates - To restrict the report to a particular range of dates, enter the first and last date in the two text boxes (for details see Date entry formats).
   • Reconcile refs  - To filter the report by a range in the alphabetic list of reconciliation references, enter the first and last reconciliation reference in the two text boxes.
   • Voucher no's - To filter the report by a range of voucher numbers, enter the first and last voucher number in the two text boxes.
   • Invoice no's - To filter the report by a range of invoice numbers, enter the first and last invoice number in the two text boxes.
4. You can change the sort order of the report by clicking Change sort order in the top-right. A Sort order and Subtotal pop-up is displayed.  
   Choose to sort by Budget code, Source/Supplier, Analysis code, Period, Date or Reference. You can also chose to Subtotal by any field you sort by. Click Save to confirm your choices.
5. Click Generate report. The report opens in the Report viewer.

Click here to see an example of a Reconciliation report.