Odoo Asset Depreciation Wrong — Incorrect Calculations and Missing Entries Fix

Asset Depreciation Errors in Odoo

The Odoo Assets module calculates depreciation for fixed assets. When calculations are wrong:

Issues:
- Monthly depreciation amount doesn't match expected value
- Depreciation entries are not being generated
- Asset shows "fully depreciated" but book value is not zero
- Different depreciation method than expected
- Start date of depreciation is wrong

Fix 1: Verify Depreciation Method

# Odoo supports several depreciation methods:
# - Linear (Straight-line): equal amounts each period
# - Degressive (Declining balance): percentage of remaining value
# - Degressive then Linear: switches methods partway

# Check the asset's method:
# Accounting > Assets > select asset
# Verify: Method, Duration, Starting Date

# Linear calculation:
# Annual depreciation = (Original Value - Salvage Value) / Duration in years
# Monthly depreciation = Annual / 12

# Example: Asset $12,000, Salvage $0, 5 years
# Monthly = ($12,000 - $0) / (5 * 12) = $200/month

# If you see a different amount, check:
# - Salvage value is correctly set
# - Duration (months vs years) is correct
# - Start date is when you expect depreciation to begin

Fix 2: Depreciation Entries Not Generated

# Depreciation entries are created by a scheduled action (cron)

# Check if the cron is running:
# Settings > Technical > Automation > Scheduled Actions
# Find: "Generate Assets" or "Asset: compute depreciation board"
# Verify it's active and runs regularly

# Run manually:
# Accounting > Assets > select asset > "Compute Depreciation Board"

# If the board is computed but entries are not posted:
# Check if auto-posting is enabled on the asset model
# Accounting > Configuration > Asset Models > check "Auto-confirm"

Fix 3: Wrong Start Date

# The depreciation start date determines when calculations begin

# Odoo calculates start date from:
# 1. The "First Depreciation Date" on the asset
# 2. Or the asset acquisition date + prorata settings

# For prorata temporis (partial first period):
# If asset acquired mid-month, first depreciation is proportional
# Check: "Prorata Temporis" checkbox on the asset

# Fix the start date:
# 1. Reset asset to draft (if possible)
# 2. Change the First Depreciation Date
# 3. Recompute the depreciation board
# 4. Confirm the asset

Fix 4: Asset Model Configuration

# Asset Models define default depreciation rules
# Accounting > Configuration > Asset Models

# Required fields:
# - Depreciation Method (Linear, Degressive, etc.)
# - Duration (number of months or years)
# - Journal (where entries are posted)
# - Asset Account (balance sheet account for the asset)
# - Depreciation Account (expense account for depreciation)
# - Counterpart Account (accumulated depreciation)

# Common mistake: wrong account assignments
# Asset Account: 1500 - Fixed Assets (balance sheet)
# Depreciation Account: 6810 - Depreciation Expense (P&L)
# Counterpart Account: 1590 - Accumulated Depreciation (balance sheet)

Fix 5: Fully Depreciated But Book Value Not Zero

# This happens when:
# - Salvage value was set to a non-zero amount
# - Rounding differences accumulated over many periods
# - Asset value was modified after depreciation started

# Check remaining value:
sudo -u postgres psql -d mydb -c "
  SELECT name, original_value, salvage_value, book_value,
    value_residual, state
  FROM account_asset
  WHERE id = ASSET_ID;
"

# If book_value should be zero but shows a small amount:
# Create a manual depreciation entry for the remaining amount
# Or adjust the last depreciation line to absorb the difference

Fix 6: Modifying Depreciation After Posting

# Once depreciation entries are posted, you cannot change the asset
# To fix wrong depreciation on an active asset:

# Option 1: Pause and adjust
# 1. Pause the asset (set to "Paused" state)
# 2. Modify the remaining useful life or method
# 3. Recompute the board for remaining periods
# 4. Resume the asset

# Option 2: Dispose and recreate
# 1. Sell/dispose the asset at current book value
# 2. Create a new asset with correct parameters

# Option 3: Manual journal entries
# Post adjustment entries to correct the cumulative difference

Depreciation Calculation Reference

Prevention

DeployMonkey's AI agent validates asset model configurations and depreciation calculations during setup. The agent monitors depreciation schedules and alerts on calculation discrepancies before they compound.