Odoo Employee Advance & Expense Management System | Advance Requests, Settlement & Accounting Integration

Introduction 

Managing Employee advance involves Advance requests & payments, expense reporting, reimbursements, and accurate accounting. Handling these processes manually often leads to tracking issues, delays, and reconciliation challenges. 

TechVaria’s Employee Advance Expense Management app for Odoo streamlines the entire workflow—from request approval to expense settlement—with fully automated accounting entries. This article demonstrates three common scenarios—Exact Match, Underspend, and Overspend settlements—and explains how they are efficiently managed within Odoo. 

Business Challenge 

Employees often require advance funds before a business trip and submit actual expenses after returning. Since actual expenses do not always match the advance amount, organizations need an efficient mechanism for settlement and accounting. 

Three situations are possible: 

Scenario 1: Exact Match 

Advance Amount = Actual Expense 

Scenario 2: Underspend 

Advance Amount > Actual Expense 
Employee must return the remaining balance. 

Scenario 3: Overspend 

Advance Amount < Actual Expense 
Company must reimburse the additional amount spent by the employee. 

Industries That Can Benefit Advance Request Expense Management App 

This solution is useful across various industries, including: 

• IT Services 
• Software Companies 
• Consulting Firms 
• Construction Companies 
• Manufacturing Businesses 
• Telecom Organizations 
• Government Projects 
• NGOs 
• Pharmaceutical Companies 
• Engineering Services 

Any organization with frequent employee Advance can benefit significantly. 

2. Configurations

2.1 Advance Account Settings 

Employee advances are treated as Current Assets. 

2.2 Approval Category Configuration 

First, create a new Approval Category by navigating to Approvals → Configuration → Approval Categories. Enable Project and Quantity as required fields and configure the required approvers. 

Next, go to Approval → Dashboard –>Open created category–> Activate Is Advance Expense and select the approval category you created. 

2.3 Outstanding Receipt and Payment Account 

Configure Outstanding Payments and Outstanding Receipts accounts in the Bank Journal to temporarily hold amounts until they are cleared and reconciled with the bank statement. 

3.How to create Advance Request in Odoo 

Step 1: Create an Advance Request 

To create an advance request in Odoo, the employee opens the Approvals Dashboard and selects the advance approval category created for Employee Advance Request. The employee enters required details, selects the expense category (Travel, Meals, Accommodation, etc.), and clicks Submit for approval. 

Step 2: Manager Approval 

Once submitted, the approval manager receives a notification in the Activities menu. The manager reviews the request and clicks Approve. 

Step 3: Approval Confirmation 

After approval, the Create Advance Payment button becomes available. The configured Advance Expense Account and Journal fields are also visible for selection. 

Step 4: Create Advance Payment 

Click Create Advance Payment to process the employee’s advance. 

Next, navigate to: 
Accounting → Reporting → Balance Sheet 

You will notice: 

• Outstanding Payments (e.g., -₹5,000)  
• Employee Advance Account (+₹5,000)  

After reconciliation: 

• Outstanding payment becomes zero  
• Amount remains recorded under the Employee Advance Account  

This confirms that the advance has been allocated to the employee. 

Step 5: After Reconciliation 

Once the advance payment is created and reconciled, the system automatically generates: 

• Advance Journal Entry  
• Advance Payment Record  

For example: 

• Advance Journal Entry: PBNK1/26-27/0001 (Advance – Travel to Delhi)  
• Advance Payment: PBNK1/26-27/0001  

These can be accessed via smart buttons on the advance request form. 

After reconciliation, the Create Expense button becomes available, allowing the employee to submit actual expenses for settlement. 

Step 6: Verify the Advance Allocation 

Open the related Advance Journal Entry from the Balance Sheet. You can see the employee (partner) linked to the advance, enabling clear employee-wise tracking for reporting and auditing. 

Step 7 Create Expense 

• Open the Advance Request form  
• Click Create Expense  
• A pop-up window appears  
• Select expense category and enter actual expense amount  
• Click Create  
• Return to the Advance Request form—you will now see settlement status: 
• Exact Match  
• Overpayment  
• Underpayment  
• Settlement Difference 
• Submit for manager approval → Approve → Post journal entry 

Steps 1 to 7 remain common across all three scenarios (Exact Match, Underspend, Overspend). The variation occurs only during expense submission and settlement based on the difference between advance and actual expenses. 

Scenario 1: Exact Match Settlement 

Let’s consider the first use case. 

Advance Request 

• Destination: Delhi  
• Advance Requested: ₹5,000  

Accounting Impact (check Balance sheet) 

• Employee Advance Balance = ₹5,000  
• Outstanding Account = -₹5,000  

After reconciliation: 

• Outstanding Account = ₹0  
• Employee Advance = ₹5,000  

 Expense Submission 

• After returning from the trip, the employee submits actual expenses. 
• Actual Expense = ₹5,000 
• The actual expense exactly matches the advance amount. 
• Now submit Expense –> Approve–> Post journal entry 

Advance Settlement 

Open journal entry and click on “Settle against advance” The employee expense report is settled against the previously issued advance.  

The expense is fully matched with the advance. Using “Settle against advance”, the expense report is reconciled. 

Financial Impact 

Before settlement: 

• Employee Advance = ₹5,000  

After settlement: 

• Employee Advance = ₹0 

The balance sheet no longer shows in advance expense account. 

This indicates that the advance has been fully utilized and accounted for. 

When we click on Advance Expense settlement button, an entry will create for the actual expense with Miscellaneous journal, the system will automatically set the default journal to the first Miscellaneous journal configured in the current company’s journal list. 

Scenario 2: Underspend Settlement 

Now let’s examine the second scenario. Please Follow point 3 to give advance to employee. 

Advance Request 

• Destination: Dubai 
• Advance Requested: ₹30,000 
• Advance Paid: ₹30,000 
• The finance team releases the advance and records the transaction. 
• Employee Advance Balance = ₹30,000 

 Actual Expenses 

• After returning from the trip, the employee submits expenses. 
• Total Expense = ₹15,000 

Settlement Calculation 

• Advance Paid = ₹30,000 
• Actual Expense = ₹15,000 
• Difference = ₹15,000 

The difference becomes visible in the advance request form. 

In the journal entry click on the settlement against advance button to settle actual expense 

Accounting Entry (Balance sheet) 

Before Settlement 

Employee advance Expense Account=30000 

After Settlement 

Employee advance Expense Account=15000 

Refund Process 

• The employee must return ₹15,000 to the company. 
• The system automatically identifies the difference 
• Go to Advance request form and hit the “Advance Settlement” Button 
• A pop window will open–> add journal–> hit Create Settlement Entry 
• Using the Advance Settlement button, the remaining amount is settled.

After settlement: 

• Outstanding receipt reflects ₹15,000 return 

After creating settlement entry, you will see the return amount in Outstanding receipt 

Scenario 3: Overspend Settlement 

The third scenario occurs when the employee spends more than the approved advance. 

This is particularly common in international travel due to: 

• Currency fluctuations 
• Unexpected accommodation costs 
• Emergency expenses 
• Additional transportation charges 

Note: – Please follow Point 3 to create Advance request and record actual expense 

Advance Request 

Destination: Travel to Mumbai 

Advance Requested = ₹5,000 

Advance Paid = ₹5,000 

Actual Expenses 

Total Expense = ₹10,000 

Settlement Calculation 

Advance Paid = ₹5,000 

Actual Expense = ₹10,000 

Difference = ₹5,000(Overspend) 

The employee spent ₹5,000 more than the advance received. 

Expense Submission 

• Submit Expense 
• Manager approves expense  
• Post journal entry  
• Click Settle against advance  

Accounting Entry: 

Before Settlement- 

Employee Advance Expense Account: 5000 

After Settlement- 

Employee Advance Expense Account: 0  

After settlement: 

The system identifies overspend and enables reimbursement. 

• Partial payment is processed  
• Pay button appears 

Reimbursement Process 

• The system identifies the overspend amount. 
• After settlement you will see pay button in journal entry/bill and partial payment ribbon. 
• Settlement Difference = ₹5,000 
• Finance creates a reimbursement payment. 
• Hit the pay button 
• The company transfers ₹5,000 to the employee. 
• Now reconcile the transaction 

Accounting Entry 

After clicking “Settle Against Advance”, the remaining amount is reflected as a receivable/payable balance in the Partner Ledger for that employee (partner). 

You can verify this in the Partner Ledger Report, where the unsettled difference (underpay or overpay) will appear against the employee. 

After payment is made and the transaction is reconciled, the partner ledger balance becomes zero for that employee, confirming that the settlement is fully completed. 

Accounting Impact of the module 

The reimbursement payment is linked directly to: 

• Employee 
• Advance Request 
• Expense Report 

This maintains complete auditability. 

Financial Reporting Benefits of Advance Request and Expense Management module 

• Balance Sheet: Track employee advances as current assets  
• General Ledger: View employee-wise accounting movements  
• Journal Entries: Review all Advanced-related financial transactions  

Advantages of Automated Advance Request & Expense Management 

• Improved financial control over employee advances  
• Better employee accountability  
• Faster approval and reimbursement cycles  
• Reduced manual workload for finance teams  
• Accurate accounting with fewer errors  
• Enhanced visibility of Advance expenses across departments 

Why Integrate Advance Management with Accounting? 

Many companies use separate systems for Advance requests and accounting, which leads to: 

• Data duplication  
• Manual errors  
• Delayed reporting  
• Reconciliation issues  

Integrating Advance management directly with Odoo Accounting eliminates these challenges and provides real-time financial visibility without spreadsheets or manual adjustments.