1.2 Expense Layout - Creating Expense Detail Item Layout aka Batch Entry Excel Layout

1.2 Expense Layout - Creating Expense Detail Item Layout aka Batch Entry Excel Layout

After creating Expense Layout, you can now continue to create the Expense Detail Item Layout. However, this is relatively simple and easy. 

Step 1 ,2 & 3: Go to Expense -> General Setting-> Batch Entry Excel Layout,


Step 4: Click 'Create'.


Step 5:. Enter the Code and Description in the column. 

Step 6:. Enter the Description in the columns. Do note that there are a few types of columns that you can create or customize here, such as Text, Number, Check Box, and others. 

Step 7: Click 'Save'





    • Related Articles

    • 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 -> ...
    • 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 ...
    • 1.4 Features of Expense - Advanced Expenses Application

      Location: Home -> Expense -> Advance Expenses Application ->  Expense Application in Advanced Admin Page for Advance Expenses Entry.   1. Employee Search Use this column to search for employees. You can use the arrow buttons or drop-down list to ...
    • 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 ...
    • 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 ...