Skip to content

Odoo 18 to Odoo 19 Migration: How to Handle Remaining Balances in Stock Interim Accounts

Odoo 18 to Odoo 19 Migration – Stock Interim Account Balance Infographic

One of the most common accounting situations encountered during an Odoo 18 to Odoo 19 migration involves residual balances in inventory interim accounts. These balances must be properly handled before or during migration to ensure clean, auditable financial records.

Understanding the Problem

In Odoo 18, two interim accounts are heavily used in perpetual inventory valuation workflows:

  • Stock Interim Received Not Billed (GRNI) — Created when goods are received but the vendor bill has not yet been processed.
  • Stock Interim Delivered Not Invoiced (GINI) — Created when products are delivered to customers but no invoice has been raised yet.

Odoo 19 significantly changes inventory accounting. These interim accounts are no longer used in the same manner, so any remaining balances must be resolved before or during migration.

Example — Stock Interim Received Not Billed

Account Debit (₹) Credit (₹)
Inventory Valuation 1,00,000
Stock Interim Received Not Billed 1,00,000
Balance Remaining: Stock Interim Received Not Billed = Credit ₹1,00,000

Example — Stock Interim Delivered Not Invoiced

Account Debit (₹) Credit (₹)
Stock Interim Delivered Not Invoiced 80,000
Inventory Valuation 80,000
Balance Remaining: Stock Interim Delivered Not Invoiced = Debit ₹80,000

After migration, these accounts are no longer expected to be actively used. There are two practical methods to clean them up.

Method 1: Settle Against Inventory Valuation Account

Inventory Valuation Account Approach

No P&L Impact · Balance Sheet Only

In this approach, the interim balance is transferred directly to the Inventory Valuation Account. This assumes the inventory physically exists, the remaining balances represent historical accounting timing differences, and the organisation wants inventory accounting to remain self-contained.

Received Not Billed — Adjustment Entry

Account Debit (₹) Credit (₹)
Stock Interim Received Not Billed 1,00,000
Inventory Valuation 1,00,000

Interim account becomes zero

Inventory valuation decreases by ₹1,00,000

Delivered Not Invoiced — Adjustment Entry

Account Debit (₹) Credit (₹)
Inventory Valuation 80,000
Stock Interim Delivered Not Invoiced 80,000

Interim account becomes zero

Inventory valuation increases by ₹80,000

Advantages
  • Simple migration process
  • No direct P&L impact
  • Corrections stay within balance sheet accounts
  • Suitable for valuation timing differences
Considerations
  • Inventory valuation account will change
  • Stock value reports may differ pre/post migration
  • External auditor approval may be required

Method 2: Settle Against Inventory Variation Account

Inventory Variation Account Approach

Preserves Valuation · Stronger Audit Trail

Instead of modifying inventory asset values, balances are transferred to an Inventory Variation Account (also referred to as Inventory Adjustment, Stock Difference, or Inventory Migration Adjustment). This method is commonly preferred when businesses want to preserve historical inventory valuation while recognising unresolved balances separately.

Received Not Billed — Adjustment Entry

Account Debit (₹) Credit (₹)
Stock Interim Received Not Billed 1,00,000
Inventory Variation Account 1,00,000

Interim account becomes zero

Inventory valuation remains unchanged

Difference is isolated in the variation account

Delivered Not Invoiced — Adjustment Entry

Account Debit (₹) Credit (₹)
Inventory Variation Account 80,000
Stock Interim Delivered Not Invoiced 80,000

Interim account becomes zero

Inventory valuation remains untouched

Difference clearly isolated in variation account

Advantages
  • Preserves historical inventory valuation
  • Easier audit trail and transparency
  • Migration impact clearly visible
  • Suitable for year-end migrations
  • Commonly preferred by auditors
Considerations
  • Creates impact on Inventory Variation account
  • May affect P&L if variation account is an expense account
  • Finance team should review tax and statutory implications

Which Method Should You Choose?

Criteria Method 1: Inventory Valuation Method 2: Inventory Variation
Inventory value remains unchanged ✗ No ✓ Yes
P&L impact ✓ No △ Possible
Simplicity High Medium
Audit visibility Medium High
Suitable for unresolved historical balances ✗ No ✓ Yes
Preferred for migration adjustments Sometimes ✓ Often
Best Practice Always resolve genuine business transactions first (create missing bills, invoices, and reconcile open entries). Only apply Method 1 or Method 2 to balances that genuinely cannot be resolved operationally.

Recommended Migration Approach

1

Analyze Remaining Interim Entries

Identify unbilled receipts, uninvoiced deliveries, legacy accounting issues, duplicate entries, and incomplete procurement cycles.

2

Resolve Genuine Business Transactions

  • Create missing vendor bills for all received goods
  • Create missing customer invoices for all delivered products
  • Reconcile all outstanding transactions
3

Adjust Only Residual Balances

Only balances that cannot be practically resolved should be transferred using Method 1 or Method 2, based on your accounting policy and auditor guidance.

4

Document the Migration Adjustment

  • Adjustment rationale and business justification
  • Journal entry references
  • Approval records from finance management
  • Auditor sign-off documentation

Conclusion

When migrating from Odoo 18 to Odoo 19, organisations frequently encounter residual balances in Stock Interim Received Not Billed and Stock Interim Delivered Not Invoiced accounts. Two practical approaches are available:

  • Method 1 — Transfer balances to the Inventory Valuation Account. No direct P&L impact. Simpler to implement. Changes inventory asset value.
  • Method 2 — Transfer balances to the Inventory Variation Account. Preserves inventory valuation. Provides stronger audit visibility. Commonly preferred for migration-specific adjustments.

The appropriate method depends on your accounting policy, auditor guidance, and the nature of the remaining balances. In all cases, businesses should first attempt to resolve genuine operational transactions before posting migration adjustment entries.

A well-planned cleanup strategy ensures a smoother transition to Odoo 19 while maintaining accurate and auditable inventory accounting records.

Planning Your Odoo 18 to Odoo 19 Migration?

Migrating to Odoo 19 is more than a technical upgrade — it is an opportunity to validate and clean critical accounting, inventory, and operational data. Techvaria helps businesses perform comprehensive migration assessments.

  • Stock Interim Account Analysis
  • Inventory Valuation Validation
  • Accounting Data Reconciliation
  • Open Transaction Review
  • Custom Module Migration Assessment
  • Financial Data Integrity Checks
  • Post-Migration Validation & Testing

Successful Odoo migrations are not just about moving data — they are about moving clean, validated, and financially accurate data. That is where Techvaria helps organisations reduce risk and migrate with confidence.

Get in Touch with Techvaria →

 

Mustafa Rahi

Mustufa Rahi is an Odoo Certified Functional Consultant and ERP expert at Techvaria with 15+ years of experience in implementation, automation, and business process optimization, helping organizations scale efficiently.