Main Features:

• Map Excel columns to specific accounting accounts.

• Detect and report missing employees based on VAT/ID/Passport numbers.

• Associate imported data with a specific accounting journal.

• Support for multiple mapping configurations per company.

This module is ideal for companies that receive externally processed payroll in Excel format and need a semi-automated way to post it into Odoo’s accounting system.

Table of contents

Excel File Requirements

• File must be in .xlsx format.

• Must contain a column with employee identifiers (e.g., VAT/ID/Passport).

• Data columns must match those defined in the selected mapping.

• Format has to be:

Employee Requirements

In order to correctly match payroll entries with existing employees (and their linked partners), each employee must have a unique identifier set in one of the following fields:

• Identification Nº (identification_id)

• Passport (passport_id)

These fields must match the values provided in the corresponding Excel column. If no matching employee is found, the system will list the missing identifiers, and you will need to create the missing records or update the identifiers accordingly.

Creating a Column Mapping

1. Navigate to Accounting > Configuration > Payroll Mapping.

2. Create a new mapping and configure:

   • Mapping name.

   • Target journal.

   • Name of the column containing employee VAT/ID/Pasport.

   • Mapping lines: Excel column → account → move type (debit/credit). Ex: “NET SALARY”, 230000, credit

     • Other Partner (optional): set this field on a mapping line to use a specific partner instead of the partner associated with the employee. If left empty, the employee’s partner is used. Example: for private health insurance paid by the company, select the insurance provider as Other Partner so that the corresponding journal item is assigned to the provider instead of the employee.

3. Save the mapping for future use.

Import

1. Go to Accounting > Accounting > Payroll Import.

2. Upload an Excel file containing payroll data.

3. Choose a previously configured column mapping.

4. The system will attempt to match employees using VAT/ID/Passport numbers:

5. After validation, click Import to generate journal entries.

6. If employees are missing, a warning will show the unmatched identifiers.

Planned Features

• Possibility to import summarized payroll.

• Compatiblity with other sheet file types.

Credits

Authors

• APSL-Nagarro

Contributors

• APSL-Nagarro:

  • Bernat Obrador <bobrador@apsl.net>

Maintainers

This module is maintained by the OCA.

OCA, or the Odoo Community Association, is a nonprofit organization whose mission is to support the collaborative development of Odoo features and promote its widespread use.

Current maintainer:

This module is part of the OCA/account-financial-tools project on GitHub.

You are welcome to contribute. To learn how please visit https://odoo-community.org/page/Contribute.