To generate an All transactions report

This report allows you to display transactions that have been posted.  

Arbor Finance reports use pop-ups. Ensure your browser does not block pop-ups from the Arbor Finance website. Click here for details.

1. From the top menu choose Reporting. On the Transactions tab choose General and All transactions.

2. In the Display section, set the options you require:

• In the Show report with area, select the information you would like to include:

  • Gross totals - to display the Gross totals as well as the Nett.

  • Totals only - to display only the summary information, without listing the individual entries. 

  • Short report format - with options to include descriptions and invoices.

  • 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, Budgets, Internal charges, Journal transfers and Accruals).

• 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.

• From 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 nos - To filter the report by a range of voucher numbers, enter the first and last voucher number in the two text boxes.

• Batch refs - To filter the report by a range of batch references, enter the first and last batch reference in the two text boxes.

• Batch dates - To filter the transactions by a range of batch dates, enter the first and last batch date in the two text boxes.

• Funding streams - To filter the report by a range in the alphabetic list of funding streams, enter the first and last funding stream in the two text boxes.

• Cost centre - To filter the report by a range in the alphabetic list of cost centres, enter the first and last cost centre 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 or Date. You can also choose 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.