OdooWiki OCA HUB

Payment Counterpart Lines Import XLSX

account_payment_line_import folder_open OCA/account-payment open_in_new
Account License: AGPL-3

This module add import xlsx template to import payment distribution

auto_awesome What this module does

AI-generated from the code · Odoo 16.0

Import 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.

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-03
Confirmed (verified in repository and branch) Estimated (unverified) No information

Confirmation 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.0

In 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.

info

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.