Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

You are also able to export the data from the search that is completed into to open in Excel for further analysis. 

  1. Go to the Admin menu, then click Transaction Search.

...

  1. Image Added
  2. Select your search filters. These can either be one or a combination of the following:

    • Account

    • Analysis Categories

    • Period

    • Date

    • Amount

    • Journal Type

    • Journal Number

    • Journal Reference

    • Description

    Click Search.

  3. Once the search has been performed, this will show all transactions relating to the search options that have been selected. 
    Image Modified

    Every second journal is shaded in light grey for easier viewing. 

  4. Some journal types can be double-clicked on to drill into the transaction details. These are currently journal numbers that start with BKD, EXP, GEN, PAY, REC.

  5. If you wish to export the search data, click on the Export button and this will download

...

  1. an Excel workbook. 

  2. If you wish to clear your search and perform a new one, click the Clear button.