最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

Duplicate Accounting Entries with Gross and Net in Payroll Structure (Odoo 17) - Stack Overflow

programmeradmin2浏览0评论

I’m encountering a very confuse issue with the Payroll module in Odoo 17 related to accounting entries when using Gross and Net salary rules. The problem causes duplicate amounts in the journal items, leading to incorrect totals. Here’s a detailed breakdown: payroll - configure - payroll structure Scenario & Configuration Salary Structure:

Basic Wage: 10,000 (Account: Salary Expense)

Allowance: 1,000 (Account: Allowance Expense)

Tax Withholding: -180 (Account: Tax Liability)

Gross: 11,000 (Category: Gross, Code GROSS, aggregated from Basic + Allowance)

Net: 10,820 (Category: Net, Code NET, calculated as GROSS - Tax Withholding)

Expected Result:

Journal entries should reflect:

Debit Salary Expense (10,000) + Allowance Expense (1,000) = 11,000

Credit Tax Liability (180) and Net Payable (10,820).

Actual Result:

Journal entries include duplicate amounts for Gross and Net:

DEBIT:

  • Basic Wage: 10,000
  • Allowance: 1,000
  • Gross: 11,000 ❌ Duplicate
  • Net: 10,820 ❌ Duplicate
    CREDIT:
  • Tax Liability: 180
  • Net Payable: 10,820
    Total debits = 10k + 1k + 11k + 10.82k = 32,820 (3x inflated).

Suspected Causes Salary Rule Configuration:

Gross/Net might be set as "Appears on Payslip" with their own accounts, causing them to post separately even though they are aggregates.

Rules for Gross/Net may have "Account Debit/Credit" assigned, overriding the default behavior.

Category Types:

Gross/Net categories (e.g., Total, Deduction) might incorrectly trigger accounting entries.

Accounting Logic:

Odoo’s default payroll accounting logic may not handle aggregated categories (Gross/Net) correctly, treating them as separate inputs instead of derived values.

Steps Tried Removed explicit accounts for Gross/Net rules → No change.

Set Gross/Net rules to "Not Applicable" for accounting → Journal items omit them but lose tax/Net tracking.

Reviewed documentation/forum posts but found no clear guidance for Odoo 17.

Questions Should Gross and Net ever have their own accounting entries, or are they purely computational?

How to configure salary rules to ensure only actual components (Basic, Allowance, Tax) post to accounts, while Gross/Net act as totals?

Is there a hidden setting or a workaround to prevent aggregated categories from generating duplicate entries?

Any insights or examples of a working salary structure in Odoo 17 would be greatly appreciated!

发布评论

评论列表(0)

  1. 暂无评论