There are several ways to find a transaction. The method you use depends on the information you have at hand. See the instructions for each method below this table:
|Use the...||To find...|
|Find Transactions window|
journal entries, sales, purchases, cheques, deposits, supplier and customer payments, money transfers.
|Sales Register||transactions relating to sales (such as open and closed invoices), quotes, orders, credits and returns. This method is most useful if you know the transaction date or the customer’s name.|
|transactions relating to purchases (such as open and closed bills) quotes, orders, debits and returns. This method is most useful if you know the transaction date or the supplier’s name.|
|Bank Register||cash and bank transactions, including customer and supplier payments.|
|inventory item transactions for a particular date range. This includes adjustments, auto-build and other inventory transactions.|
|Transaction Journal window||any transaction by source journal. This includes Disbursements, Receipts, Sales, Purchases and Inventory transactions.|
|Recurring Transactions List window||recurring transactions. You can sort transactions by name, type, or frequency, or search for a transaction by name, amount, or next due.|
Most of the above windows enable you to search a date range and you can search for transactions recorded in previous financial years.
You can also print the data in each window as a report by clicking Print.
You might need to adjust date filters and other options to make the transaction appear.
When the report appears, click the Insert/Modify tab and you can move columns and order data in the report to your liking.
There's lots more you can do to set your transaction report up the way you want it – see Customising reports.
Need to change or delete a transaction? See Changing or deleting a transaction.
Need to see who created a transaction? See Company file security audits.
To find a transaction using the Find Transactions window
From any command centre, click Find Transactions from the bottom of the command centre.
- In the Find Transactions window, click the appropriate tab—for example, the Card tab to search by card. Or, if you want to see all credit and debit transactions for accounts, click Account.
Filter your search using the Search By and date range fields. Results will appear based on your search criteria.
If no results appear after selecting a date range, ensure you've selected a secondary Search by field. For example, if searching the Card tab, select a card – in the example above, we've selected A-Z Stationery Supplies. You can also increase the number of results by expanding the date range.
- If you want to narrow your search further:
- Click Advanced. The Advanced Filters window appears.
- Type or select additional search filters, and click OK. The transactions that match your search criteria appear in the Find Transactions window. You can view a transaction in detail by clicking the zoom arrow () next to it.
Quotes and orders without applied payments don’t appear in the Find Transactions window (Not Basics)
To find these types of transactions, go to the Quotes and Orders views of the Sales Register or Purchases Register.
Using the simple filter
To filter your transactions, use the blank row at the top of your find transactions (right under the column headings).
Can’t remember the precise payee in the memo field? Use a keyword with an asterisk in front of it like *filter to find transactions from all businesses with that word in their name.
Do you know how much the transaction was worth? Specify a value or range. For example, type >25 to find transactions over $25, or hover over a column header and click the filter icon to set a range.
By default, typing a filter term will only show results that begin with the characters you enter. If you want to show all fields that contain the filter term, not just start with it, add an asterisk at the beginning.
- When filtering a currency column:
- you don't need to enter commas or the currency sign.
- you can use these characters to filter the amounts:
- < (less than)
- <= (less than or equal to)
- > (greater than)
- >= (greater than or equal to)
- - (between).
For example, type 1000-2000 to find all amounts between $1,000 and $2,000. Or type >1000 to find amounts greater than $1,000.
Advanced filters (Customise Filter)
Need even more filtering power? Then give the Customise Filter a go.
You can access it by either clicking a filter icon in a column header and choosing Custom, right-clicking a column header and choosing Filter Editor, or by clicking the Edit button at the bottom of the list if a filter has already been applied.
The filter allows you to create or edit multiple conditions in one go.
Advanced filter options
A filter has several parts you can define:
|Filter option||How to use|
You can choose to only show transactions that match all conditions you set (select AND), or all transactions that match at least one of the conditions (select OR).
Click the red “And” or “Or” link to choose your filter type.
Which column do you want to filter? Click the text that’s within the square brackets to choose from the columns that appear on the Find Transactions window.
Choose the appropriate operator for the condition. For example, greater than, equal to, doesn’t contain, or begins with, etc.
What's the value you are looking for, or comparing to? What you enter depends on the column type.
To find a recurring transaction
Go to the Listsmenu and choose Recurring Transactions. TheRecurring Transactions List window appears.
- Locate the recurring transaction. You can:
- sort the transactions by name, type or frequency
- search for a transaction by name, amount or due date.
- For more information on changing the details of a recurring transaction, see Recurring transactions.