How to Configure Expense Report in iDempiere

The Expense Report window in iDempiere records employee and store-level expenses such as customer visit costs, petty cash purchases, and travel spending. Retail businesses use it to capture reimbursable expenses at the store level, tag them to a Business Partner, Warehouse, and Price List, and route them through approval. Once approved and processed, expense reports feed into invoicing, reimbursement, and store expense reporting.

Process Flow

Business Rules

• Only Active expense reports are available for entry and processing.
• Line Amount is calculated automatically from Quantity and Expense Amount.
• The Invoiced checkbox blocks duplicate reimbursement of a billed expense line.
• Expense lines can be linked to a Project, Phase, Task, and Activity for cost tracking.
• Currency conversion applies when Expense Amount currency differs from the base currency.

Prerequisites

• Business Partner (employee and supplier) configured.
• Organization (store, e.g. Chennai Store) configured.
• Warehouse configured and linked to the Organization.
• Price List (e.g. Standard Sales Price List) configured.
• Product master data configured for expense items.
• Currency and Currency Rate configured for non-base currency expenses.
• Project, Phase, Task, and Activity configured, if cost allocation is required.

Navigation

Menu → Partner Relations → Service → Expense Report

Configuration Steps

Step 1: Create the Expense Report Header

Open a new Expense Report record. Enter Description, select the Business Partner, Report Date, Price List, and Warehouse. Save the record before adding lines.

Field	Sample Value	Description
Business Partner	Arun Prakash	Employee or party claiming the expense
Report Date	07/21/2026	Date the expense report is created
Price List	Standard Sales Price List	Price list used to value expense products
Warehouse	CHN Godown	Warehouse tied to the claiming store
Description	Customer Visit Expenses	Short label for the report

Step 2: Add Report Lines

In the Report Line tab, select the Product, enter Quantity and Expense Amount, and confirm the Currency. Add a Description for the specific expense. Repeat for each expense item.

Field	Sample Value	Description
Product	Britannia Good Day Butter Cookies	Item or expense category purchased
Quantity	10	Units of the product claimed
Expense Amount	200.00	Cost per line before conversion
Currency	INR	Currency of the expense amount
Line Amount	2,000.00	Total value of the line, calculated automatically
Description	Refreshments during customer meeting	Note on the specific expense

Step 3: Link Reference Details

Expand the Reference section on the Report Line. Select a Business Partner (supplier) if the expense was purchased from a vendor. Set Project, Project Phase, Project Task, and Activity when the expense must be allocated to a specific cost object.

Field	Sample Value	Description
Business Partner	Chennai Suppliers	Supplier the expense item was purchased from
Project	(optional)	Project the expense cost is allocated to
Project Phase	(optional)	Phase within the linked project
Project Task	(optional)	Task within the project phase
Quantity Reimbursed	0	Quantity already reimbursed to the employee
Price Reimbursed	0.00	Amount already reimbursed to the employee

Step 4: Approve the Expense Report

Review the Approval Amount against the report total. Check the Approved box once the amount is confirmed by the approving manager.

Step 5: Complete and Process the Document

Click Document Action and select Complete. Confirm Document Status changes to Completed and the Processed checkbox is set.

Note: Once Processed is checked, header and line fields become read-only

Common Issues and Resolutions

Issue	Cause	Resolution
Document will not Complete	Mandatory field left blank (Business Partner, Report Date)	Fill all fields marked with an asterisk before completing
Warehouse not listed in dropdown	Warehouse not linked to the Organization	Assign the Warehouse to the Organization in Warehouse setup
Product missing from Report Line	Product not present in the selected Price List	Add the product and price to the Price List
Currency conversion error	No conversion rate defined for the expense currency	Set up a Currency Rate under the Conversion Type

Next Steps

• Configure Invoice generation from completed Expense Reports.
• Set up Payment Processing for employee reimbursement.
• Review Product setup for recurring expense categories.
• Configure approval limits and Document Action workflow rules.