Search

Use the Search Box on the Reconciling Items and Matched Items screen to find the exact transactions you are looking for. The same search logic is applied on the Reconciling Face and on the Matched Screen.

Reconciling Face Search

• • Use Source:Value, Date:Value, Notes:Value and Label:Value to search on these fields

  • All other fields can be searched on directly

Matched Items Search

• • Search will return all matches where one or more of the transactions in the match is found by the search criteria

  • Use Type:Value, User:Value, Notes:Value and Date:Value to search on these fields

  • Possible values for Type are Manual, Auto and Auto [RuleName] where [RuleName]is replaced by the name of a rule in the system

  • All other fields can be searched on directly

General Searches on all screens

• • To search for 90% of items simply enter the Search word in the box and click Search. eg: Audit

  • Use quotations to search for a phrase eg: "Audit Journal"

  • AND will return transactions that match all phrases eg: "Audit Journal" AND May will return items with both "Audit Journal" and May in them

  • OR will return transactions that match any of the phrases eg: "Audit Journal" OR May will return items which have either "Audit Journal" or May in them

  • NOT will return transactions that have one the first phrase but not the second. eg Audit NOT May will return all transactions with Audit that do not contain May

  • * will match all versions of a word. eg test* will return matches to test, tester, tests, tested etc. It cannot be used at the start of a word.

Amount Searches on all screens

• • To search for exact amounts specify the amount with the cents. eg 3456.78. This will return both positive and negative values

  • To only return negative amounts use \-1234.56

  • Use * to return all transactions which match part of an amount. eg: 123* will return 123.45, -123.45, 12367.21, 1237.98 etc

  • Amount:[AmountFrom TO AmountTo] will return all transactions in the range. eg Amount:[0 TO 100] will return all transactions which have a value between 0 and 100.00

Date Searches on all screens

• • Use the format Date:yyyymmdd eg. Date:20120601

  • Date:[FromDate TO ToDate] will return all transaction in the range eg. Date:[20120101 TO 20120131] will return all transactions with a date between 1 January 2012 and 31 January 2012