Using Financial Filters

Who Can Use It?	Where Is It?
Assistant Project Manager Project manager Director Administrator System Administrator	Reports > Edit Report > Filters tab

The financial filters are shown in the report > filters panel. They are shown for any Project, Sub Project, or Transaction type report. The filters can be found by opening Reports, then selecting the edit button in the toolbar. On the filters panel that opens the financial filters are shown in their own group at the end of the list.

Click the image above to see Transaction level financial filters.

When using Transaction level reports, you can apply either Project, Sub Project or Transaction level filters. For example if you expand out the Sub Project level filters, then the financial filters group is shown at the end of the list.

Click the image above to see Sub Project level financial filters in a Transaction report.

The project manager is Simon Waters is working on the Project 'Old Windsor Road'. On this project each of the Sub Projects have been setup using the fee type 'Fixed Fee' with an agreed fee value entered. He needs to get a quick snapshot of which projects have not had their entire agreed fee invoiced as yet, but there is available WIP to invoice to the client. The remaining invoice value for each Sub Project is shown as the Sub Project Residual Fee in reports.

To create this report:

1. Open Reports > Sub Project reports.
2. Let's use the 'Sub Project WIP Report'. This will only show Sub Projects that have a chargeable WIP value greater than $0.00 by default.
3. Double click to add a project filter to only show the project 'reference name' of 'Old Windsor Road'. This is a standard report filter.
4. Next add the sub project level financial filter for 'sub project residual fee' by:
   1. Locating the Sub Project Filters > Financials filters group, and clicking the + to expand.
   2. Select the filter called 'Sub Project Residual Fee' from the Available filters list.
   3. Select a rule such as 'Is Greater Than' and then enter a dollar value. i.e. Greater than $1.00.
   4. Click the Add to Filter button.

Click the image above to view the sub project financial filter.

5. Select the columns tab, and check that all the required columns are shown in the report. Learn more about adding columns.
6. The default report doesn't have the 'sub project residual fee' column. Try adding this column, and removing the profit and cost columns so the report output has enough space on the page to show all the data.

Click the image above to view the report columns.

7. (Optional) Use the style and save tab to save this as one of your custom reports.
8. Click Run to generate the report.
9. The created report example will only show sub projects for the 'Old Windsor Road' that have chargeable WIP values, and a residual fee value.

Click the image above to view the created sub project report.

A manager wants to check on the performance of one of their staff members Jill Lockhart. They want to report on all project related transactions where the chargeable invoice value is greater than the invoice value. In particular they are looking for items that have a $0 invoice value that were not written off.

Create this type of transaction report by:

1. Open Reports > Transaction.
2. Select the 'Transaction Summary Report' in the list and click the 'edit' button in the toolbar.
3. Try applying a standard filter for the 'transaction staff name' first. i.e. Filter to only show transactions entered by 'Jill Lockhart'.
4. Apply a standard filter to exclude transactions with the 'transaction invoice' number of 'W/OFF'. This will exclude the items that were written off by Jill's Manager in the report, or work from non-billable sub projects.
5. Locate the Transaction filters > Financial filters group. Click + to expand the group.
6. Select the financial filter 'Invoiced Value' and use the IS rule and enter the value $0.00. Click Add Filter. This will find only the transactions marked down to $0.00 on an invoice for the report.
7. Select the financial filter 'Transaction Chargeable' and use the IS GREATER THAN FIELD rule. Select the comparison field of 'Invoiced Value' from the list, and click Add Filter.

Click the image above to view the financial comparison filter.

8. Select the Columns tab of the report.
9. Look at the standard report columns and consider what other details you require. In this case we need to see the extra transaction columns of Transaction Invoice $ and Transaction Chargeable $.

Click the image above to view the added report columns.

10. (Optional) Use the style and save tab to save the custom report as one of your 'My Reports'.
11. Click Run to create the report output.
12. The report sample in this case lets us view all the transactions for Jill that have been invoiced, but where the invoice value was $0.00, and a chargeable value existed.

Click the image above to view the report output sample.