4. Expense

4. Expense

How to migrate employees' expenses data?
  1. Download the Employee Expense Data Migration template file as per attached or download at Expense Home -> Main -> General -> Expense Data Migration.
  2. Click on Download Sample Leave Entry Excel Format button.
  3. Open with Excel (default) format for Microsoft Excel 2003 & above.
  4. Fill data for each column and further explanation for each column as below:
Column Name
Description
Remark
Employee Number
Employee Identified Number
Compulsory.
Employee Name
Employee Name
Compulsory.
From Date
Effective From Date
Compulsory. Record effective date. Date format in dd/MMM/yyyy.
To Date
Effective To Date
Compulsory. Record effective date. Date format in dd/MMM/yyyy.
Expense Item
Expense Item
Compulsory.
Total Amount
Total Amount
Compulsory.
With Receipt?
Receipt needed
Compulsory. Only the expense item which need receipt set as "Y".
        5. Save the migration file as per default Microsoft Excel (*.xls/.xlsx) format.
        6. Click on Browse button to search for your saved Employee Expense Data Migration file.
        7. Click on Upload button to import the Employee Expense Data Migration file into system.


How to verify employees' expenses data?
1.  Go to Expense Home -> General -> Expense Claim Application.
2.  Check on employee "Claim Applications History" box on the right page if the previously entered description is in or not.

    • Related Articles

    • 3. Create Expense Group

      Creating an Expense Group helps you to manage your Expense Claims better. The idea is that you can group Employee under different Categories based on their entitlement, jog grade, etc.  We will show you how to create a new Expense Group in this ...
    • 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 -> ...
    • 7. Assign Expense Group

      At this stage, you have basically completed the basic setups of e-Expense Claim. Now you will assign the Expense Group of your Employee. 1. Go to Expense -> General -> Employee List. Then choose the Employee that you want to assign Expense Group, and ...
    • 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 ...
    • 2. Create Expense Description

      This article will guide you on how to create the Expense Description. Think of Description like the name or title of the type of Expenses that your company allows Employees to claim, such as mileage, medical bill, and others.  Follow the steps below ...