To filter a report

1. Open the report you want to view and click the Filters tab (if it's not already selected).
   
   
   
   
2. If you want to change the date range, enter or select a new date range or period in the Dates section. Note that date filters are unavailable for some reports.

3. In the Refinements section, select values for the various filters. The example below shows the options available for the Item List [Summary] report.
   
   

   A	Click Run Report to apply filter changes.
   B	Click Sort to sort the order of information in the report.
   C	Select values for filters to limit the data that will be included in the report. Depending on the report you are producing, you may be able to filter by card type, custom lists, tax codes, amounts, etc.
   D	Click Additional Filters to set filtering options that are not visible in the tab. Only available if the report you're running has more filters available. See step 4 below.
   E	Click to return all filters to their default values.

4. If you want to apply more filtering options, click Additional Filters and complete any filters you want to apply.
   
   
   
   Note that the options available in this window depend on the report you are viewing.
    
5. Click OK. The Reports window reappears.
6. Click Refresh Report to apply the new filter settings.

To sort a report

1. Open the report you want to view.
2. In the Filters tab, click Sort. The Sort window appears.
   
   
   
   

3. In the Sort by field, select the column you want to sort the report by, then select which order you want to sort that information in.
   For example, to sort a report alphabetically by name, select Name, then select Ascending in the adjacent field.

4. If you want to add additional sorting levels, click Add Sort Level, then select the type of information you want to sort by and the order you want to sort it in.
   In the example above, the report will first be sorted alphabetically by name, and if there are multiple entries for the same customer, those rows will be sorted by the amount.

5. Click OK. The report is sorted in the specified order.

Preparing financial reports? Financial reports, such as your profit and loss statement, are reported by financial year, and can't be filtered to a calendar year.

These reports can only be filtered to show information for the last, current or next financial year. If you haven't closed the previous financial year, the Financial Year filter will show a prior year as the "current" year. If you're still not ready to close the previous year, you'll need to select the Next Year option when preparing your reports for this financial year.