Analytics Reports: Transaction Search Report
The Transaction Search report is one of the most powerful analytics reports in Inomial Billing.
With this report, you can do things such as:
- Find a transaction, e.g. a payment has been made to the company bank account for $45.16 but the bank does not have a reference recorded against it, such as an Invoice Number. You suspect it’s a payment for a customer invoice and so are trying to determine likely customers so that you can create a receipt against the correct account.
- List out your largest receipts for a given period, e.g. greater than $500 for the last financial year.
- See the credit notes that have been raised by your staff in the past month so you can confirm that they are raising them for valid reasons.
- Find the account for the invoice you reversed. You can’t remember the account name but you know it was for $100 and sometime in the first half of 2018.
The Transaction Search report is found in the Finance section (or use the search box to search for part or all of its name – I’ve entered in “search” in the screenshot below).
Transaction Search is a relatively wide report with lots of filters. You may want to shrink the report list pane on the left by positioning your mouse pointer over the vertical bar (see the icon in the image below) and dragging to the left. This will leave more room to display the report results.
This report is grouped by currency and then transaction type, and sorted in transaction date order. The footer of the report shows the numeric totals of the above columns. Note: the totals, apart from the count in the second column, will be meaningless if the report shows multiple currencies.
Clicking on the “disclosure triangles” to the left of the transaction type grouping label will contract or expand the group. In the following image, I have run a report in AUD which shows lots of transaction types in the given period and then contracted each group so that I just see the summary totals.
The Transaction Search report has the following filters which limit the reported transactions:
- From – mandatory, and defaults to the first of the current month.
- To – optional, between these dates. A null To date means all transactions regardless of transaction date from the From date, inclusive.
- Min / Max Amounts: Limit the report to transactions that are between these values (inclusive). Note: Debits are positive numbers, credits are negative numbers. For example, to find a receipt of at least $500, set a Max Amount of -$500. To find an invoice of at least $500, set a Min amount of $500. A null filter means all values.
- Currencies: all (null) or just the selected currency. Note: The report totals in the footer are the totals of the raw numbers. If you report multiple currencies then the footer totals will be meaningless.
- Account Type: all (null) or just the selected account type.
- Transaction Type: all (null) or just the selected transaction type.
The following settings have found the invoice reversal mentioned in example 4. I could have also filtered to values between $100 and $100 if there were more results, but the extra filters were not necessary for me to easily identify the transaction I was after.
In the case of the Transaction Search report the action will take you to the transaction of the related row.
As is the case with all true Analytics reports, you can download the results to CSV or xlsx with our billing software.