The Transactions Search Report allows you to:
Search for multiple items
Limit the search to particular accounts, classes, or just Profit & Loss accounts
You can also filter flagged or tagged transactions
Extend the search across different reporting periods
Be flexible on which columns to include/exclude
Export on-screen data to Excel
Below are more details on the functions you can do in this report.
Access
To access the Transactions Search report:
In AccountsPrep, click Reports.
On the drop-down, click Transactions Search.
Filter for multiple search items
You can search multiple terms/values from the search bar by separating each item with a semi-colon (;).
You can include anything in the Details or Reference fields (such as a payee etc.). You can also search values (such as payment/receipt amounts etc.)
Filter by accounts
By default, all will show as All accounts selected.
Use the accounts selector drop-down menu to choose which accounts to include/exclude.
Click Check All to select multiple accounts at once
You can select whole classes of accounts by clicking the class heading
Click Check P&L only to isolate the Profit & Loss accounts
Click Uncheck all to clear all checked boxes
📎NOTE: This will clear any previous selection and will search for all items again.
Use the search bar within the accounts selector drop-down to find accounts quickly
Extend the Search Across Different Periods
In the dates drop-down menu, you can quickly choose:
Current Period (default)
Prior Period 1
Prior Period 2
Custom
You can also simply type the dates in the date from/to fields to create a custom selection across periods.
Manage columns
Click Settings to add or remove columns.
Account
Type
Batch
Total
Click Preview to see what the changes will look like. Click Save to confirm the changes for the next time you open the transactions search page.
Exporting
Click Export to Excel to export the on-screen results to Excel.