3.2 Expense Report - Filter Setting
Location: Expense -> Standard Report -> Any standard report > Filter tab
1. Smart Filter and Advanced Search
2. Company
By default, the data shown in the report is based on the current company only. However, if you wish to generate an inter-company report, select the companies relevant in Advanced Search first, and ensure the same companies are selected in this Company filter as well.
3. Date Range
Use the two Date Picker to choose a Date Range of your report. Ensure the right checkbox is selected to indicate the reference of the date range which can be either the claim submission date (Submit Date), the date of the expense claim (Claim Date), or the date of the action status (Approve/Reject Date). By default, the date range refers to the submission date.
4. Expense Item
To narrow down the data to a particular Expense item(s) only, hover your cursor to the Expense Item row, click on the Edit icon, and select the preferred Expense item(s). If no Expense item is selected, the report will include all Expense items.
5. Group By
To group the data by employees' Job Groups, hover the cursor to the Group By row, click on the Edit icon, and select the relevant Job Group(s).
6. Order By
Hover the cursor to the Order By row and click on the Edit icon. Select the preferred type of data for the data order in the report. By default, the data is ordered by Date.
7. Include Status
Hover the cursor to the Include Status row and click on the Edit icon. Mark the status checkbox to be included in the report. For example, if the status selected is Approved, only approved expense claims data will be shown in the report.
Related Articles
1. Features of e-Expense
Features of Expense module : 1.1 Features of Expense - Employee List 1.2 Features of Expense - Expense Summary 1.3 Features of Expense - Expense Claim Application, Withdrawal, & Cancellation 1.4 Features of Expense - Advanced Expenses Application ...4. Expense General Setting
Here you will set some of the general settings for e-Expense. Step 1 ,2 & 3: Go to Home -> Expense -> General -> Expense General Setting. 1. Does your Company allow back date Expense claim? If yes, how many days/week/months? Enter the value in the ...3.0 Expense Report
Location: Expense Claim -> Standard Report You can download many useful Reports for Expense Claim, or even create a Report that customized to your requirement accordingly! Most of the steps to download different Reports are the same. The Report ...1.1 Expense Layout - Creating Expense Layout
Before we start creating Expense Claim, we need to first define how the Layout will be. The system has created a few columns by default. You can edit these columns and also add new according to your needs. Step 1 ,2 & 3:. First, go to Expense -> ...3.3 Expense Report - Layout Setting
Location: Expense > Standard Report > Any Standard Report > Setting tab The screenshot below shows the Expense standard report layout setting page. The description of settings indicated (1 - 6) is provided below. The report setting consists of the ...