Payment Counterpart Lines Import XLSX
This module add import xlsx template to import payment distribution
auto_awesome What this module does
AI-generated from the code · Odoo 16.0Import payment distribution lines into a draft payment from an Excel file. The button "Import Payment Distribution" appears on the payment form and fills the counterpart lines automatically.
This module adds an Excel import for the distribution (counterpart) lines of a payment. On a payment in draft state, a new button "Import Payment Distribution" appears next to the "Reset to Draft" button. It opens an Excel import wizard using the template "Payment Distribution (import)" (file payment_detail.xlsx).
The template expects columns for description, invoice/move, amount, account, analytic account and fully paid. When the file is imported, the module:
- Deletes the existing counterpart lines of the payment before loading the new ones.
- Fills missing descriptions with "/".
- If an invoice number is given, replaces it with the invoice name and uses the invoice partner.
- If no account is given, uses the payment's destination account code.
- Adds the payment partner when a column is missing.
After import, a post-processing step recalculates each line from its linked journal entry (move) and then restores the imported description and amount, so the lines stay consistent with the accounting entry.
The module works on account.payment and its counterpart lines (line_payment_counterpart_ids), and relies on the Excel import/export framework.
Depends on
Models and fields (1)
- account.payment · extends an existing model
Text generated by AI (DeepSeek) from reading the Odoo 16.0 code on GitHub; it may contain mistakes, so check the code before deciding. View the code on GitHub
Availability by version
Reviewed: 2026-11-03Confirmation status: 2 confirmed, 7 with no information of 9 versions.
Sources · Odoo 16.0
Confirmed on 2026-11-03 in branch 16.0 of OCA/account-payment.
terminal Installation and usage
OCA documentation · Odoo 16.0Usage
Source · Odoo 16.0In draft state on payment you can open wizard on action "Import Excel", or use bottom "Import Payment Distribution", you can download sample on wizard
No verified information in OCA: Installation, Configuration.
Installation instructions, the distribution package, dependencies and configuration steps are not shown because they have not yet been verified in the module documentation for any version.
Data imported from GitHub: this sheet reflects the latest catalog review, not a live lookup. Always check the module documentation and staging before installing in production.