Invoice/Bill Reconcile & Writeoff on Payment
by BeyonData Solutions Private Limited https://www.beyondatagroup.com$ 46.46
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Accounting (accountant)
• Invoicing (account) • Discuss (mail) |
| Lines of code | 208 |
| Technical Name |
bd_payment_reconcile_writeoff |
| License | OPL-1 |
| Website | https://www.beyondatagroup.com |
| Versions | 16.0 17.0 18.0 19.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Accounting (accountant)
• Invoicing (account) • Discuss (mail) |
| Lines of code | 208 |
| Technical Name |
bd_payment_reconcile_writeoff |
| License | OPL-1 |
| Website | https://www.beyondatagroup.com |
| Versions | 16.0 17.0 18.0 19.0 |
Invoice/Bill Reconcile & Writeoff on Payment
Reconcile customer invoices and vendor bills directly from payments with write-off support in Odoo 18.
Key Highlights
Invoice/Bill Reconcile & Writeoff on Payment
Invoice & Bill Loader on Payment Form
Load all outstanding customer invoices or vendor bills for a partner with one click — directly inside the payment form. No navigation to individual invoices required.
Smart Partner-Scoped Invoice Search
Only shows posted, unpaid or partially paid invoices for the selected partner. Inbound payments load Customer Invoices; Outbound loads Vendor Bills — fully automatic.
Multi-Invoice Selection in One Payment
Tick any combination of invoices or bills to settle in a single payment. Each line shows Reference, Date, Due Date, Total Amount, Outstanding Balance and Status.
Integrated Write-Off Entry
Enter the write-off amount, select the G/L account (e.g. Bad Debt, Discount Allowed) and add a narration note — all on the same form. No separate manual journal entry needed.
Auto-Reconciliation on Confirm
On confirmation, the module automatically matches payment A/R or A/P journal lines against selected invoice lines — no separate reconciliation step required.
Conditional Write-Off Fields & Validation Guards
Write-off Account and Note only appear when amount > 0, keeping the form clean. The system blocks confirmation if no invoice is selected or a write-off account is missing.
Quick-View Invoice Button
Each invoice row has an eye icon button that opens the source invoice in a popup form — so accountants can verify line items and due dates without leaving the payment screen.
Inbound & Outbound Payment Support
Works for both customer invoice payments (inbound) and vendor bill payments (outbound) in a single unified interface with direction-aware search and write-off logic.
Intelligent Multi-Company Isolation
The system is intelligent enough to show only the bills or invoices that belong to the specific company you are currently working in, preventing any cross-company mistakes.
Seamless Foreign Currency Support
Whether you are dealing with local or foreign money, the tool tracks the specific currency of each invoice and ensures the payment matches correctly.
Overview
Invoice/Bill Reconcile & Writeoff on Payment
The Invoice/Bill Reconcile & Writeoff on Payment module enhances Odoo’s standard payment processing by allowing users to selectively pay multiple invoices or bills directly from the Payment screen. It introduces a streamlined workflow to handle Write-offs simultaneously, ensuring that small discrepancies or discounts are accounted for without manual journal entries. This module is ideal for businesses managing high volumes of transactions where quick, line-by-line reconciliation and instant write-off adjustments are required at the point of payment.
SCREENSHOTS
Configuration
Mandatory Configuration: Setting Up Outstanding Accounts
In Odoo, the payment process requires a temporary "Bridge Account" to hold funds before they are
fully reconciled with your bank statement. These are known as Outstanding Receipts and
Outstanding Payments accounts.
Since this module automates the reconciliation of multiple invoices and handles write-offs, the
system must have these accounts configured to generate the correct journal entries.
If these accounts are missing, Odoo’s internal validation will block the payment and
display the following error message: “Please set Outstanding Receipts Account in the Journal for
the selected payment method.”
1.How to Fix the "Outstanding Account" Validation Error
Go to Accounting → Configuration → Journals and select your Bank/Cash journal.
Set a valid account in the Outstanding Receipts (for Customers) or Outstanding Payments (for Vendors) column under the respective payment tabs.
2. Configurations:
Go to Accounting → Customers → Payments.
Click New to create a new payment.
Select Payment Type and choose the Customer (or Vendor for outbound).
Click the Load Invoices/Bills button.
The module searches for all Posted invoices in Not Paid or Partial status for the selected partner and populates the Invoices & Write-off tab.
Enter the payment amount in the Amount field.
If the user forgets to enter the payment amount, the system displays a validation error: “Please enter an amount.”
Tick the Select checkbox on each invoice/bill you want to include in this payment.
If the user forgets to select an invoice or bill, the system prompts a validation message requiring them to select at least one invoice or bill for payment.
Use the eye icon on any row to open the source invoice/bill in a popup form and verify line items — without leaving the payment screen.
3. Confirm Payment with all Writeoff details
If the payment does not exactly cover the invoice/bill total, enter the difference in the Write-off Amount field.
If the user selects invoices and enters a write-off amount but does not specify a write-off account, the system displays a warning: “Invalid fields: Write-off Account.”
When the user provides all write-off details (i.e., Write-off Amount, Write-off Account, and optionally Write-off Notes) and clicks Confirm, the system Creates a complete and accurate journal entry and the selected invoices as paid.
The payment status is Paid for the selected invoices
A journal entry is created following Odoo’s default behavior. If a write-off account, write-off amount, and write-off note are entered on the payment form, these values are applied to the write-off line in the generated journal entry.
4. Confirm Payment without Write-off Details
When the user does not enter any write-off details and simply enters the total invoice amount, selects the invoices, and clicks Confirm, the system creates a complete and accurate journal entry and marks the selected invoices as Paid without applying any write-off.
Journal Entry when Write-off Details not assigned in Payment
Suggested Applications
Our Service
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
For any Query
Checkout our
Apps
Check App Demo
Please log in to comment on this module