Skip to Content

AR Overpayment Management

by
Odoo

$ 230.59

v 18.0 Third Party
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Invoicing (account)
• Discuss (mail)
Community Apps Dependencies
Lines of code 3203
Technical Name aos_ar_overpayment
LicenseOPL-1
Websitehttp://www.alphasoft.co.id
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Invoicing (account)
• Discuss (mail)
Community Apps Dependencies
Lines of code 3203
Technical Name aos_ar_overpayment
LicenseOPL-1
Websitehttp://www.alphasoft.co.id

AR Overpayment Management

Surface every unallocated AR credit your customers have, then settle them — either by allocating to an invoice (same- or cross-customer) or writing off to revenue / bad debt. Tested on Odoo 18 Community & Enterprise.

Built for finance teams that need an explicit, audit-friendly workflow on top of Odoo's generic reconciliation widget. Portfolio view + 1-click allocate + clean write-off channel.

The Gaps in Standard Odoo

 Without this module  With this module
  • Credits buried inside each invoice form — no portfolio view
  • No supported way to transfer a credit from Customer A to Customer B
  • Small over/under-payments accumulate with no clean write-off channel
  • Standard reconciliation widget overwhelming for AR-only workflow
  • Dashboard shows every customer with credit + age buckets
  • Cross-Customer Allocation wizard: DR AR Source / CR AR Target + auto-reconcile
  • Write-off wizard: 2 directions in one tool (revenue OR bad debt)
  • 1-click [Allocate] / [Write-off] per credit line

Dashboard at a Glance

Open Overpayments → AR Overpayment Dashboard for a portfolio view of every customer holding a credit — with the snapshot date, customer set, aging buckets, and per-branch breakdown all on one screen.

Element What you get
Snapshot filter
"until <date>" pill		 Freeze the balances as of any date — month-end close, board pack, audit cut-off. The whole dashboard recomputes against that as-of date.
Six summary tiles Customers count · Total Overpayment · 0–30 / 31–60 / 61–90 / 91+ days aging buckets. Each tile shows both the line count and the amount.
Per-partner table ID, Customer, Branch, #Credits, Total Overpayment, Oldest Date, colour-coded Max Age badge, and each aging bucket as its own column.
Live search Filter rows by customer name or ID without leaving the dashboard.
Total footer Reflects whichever filtered subset is on screen — not the unfiltered grand total.
One-click XLSX Styled workbook matching the on-screen layout, ready for the auditor.

Three Settlement Flows

Same-Customer Allocate

Customer has a credit AND an unpaid invoice. One click reconciles the two against existing moves.

JE posted: none — partial reconciliation only.

Use case: overpayment that should apply to a later invoice.

Cross-Customer Transfer

Payment was applied to the wrong customer. Transfer the credit and reconcile against the target customer's invoice in one step.

JE posted: DR AR Source / CR AR Target, then auto-reconciles both legs.

Multi-line Write-off

Clear any number of credit lines in one journal entry. Two directions in one tool:

Overpayment → Revenue: DR AR / CR Revenue.
Bad debt: DR Bad Debt Expense / CR AR.

Summary panel shows the running total before you confirm.

Screen-by-Screen

  AR Overpayment Dashboard

Portfolio view of every customer holding a credit. Six summary tiles (Customers / Total Overpayment / four aging buckets), with each tile showing both line count and amount. Per-partner detail table includes ID, Customer, Branch, #Credits, Total Overpayment, Oldest Date, Max Age badge, and aging buckets as columns. "Until <date>" snapshot filter, live customer search, and one-click XLSX export.

AR Overpayment Dashboard

  AR Overpayments list

Every unallocated credit line with per-row [Allocate] and [Write-off] buttons. No need to dig through invoice forms — act directly from this list.

  Outstanding Credits AR

Flat, searchable list of all unreconciled AR credits with document, age, and amount. The same dataset the Dashboard summarises — opened flat for spreadsheet-style filtering.

  Allocate Outstanding Credit wizard

Two-mode dialog. Same Customer: reconcile the credit directly with one of the customer's invoices (no JE created). Different Customer: transfer the credit and reconcile against the target customer's invoice in one step (DR AR Source / CR AR Target, auto-reconciles both legs). Explanation panel re-renders as you toggle modes.

Allocate Outstanding Credit wizard

  AR Write-off wizard (multi-line)

Clear any number of credit lines in one journal entry. Two directions in one tool: small overpayments → Revenue (DR AR / CR Revenue) or uncollectible balances → Bad Debt Expense (DR Bad Debt / CR AR). Summary panel shows the running total before you click Confirm Write-off.

AR Write-off wizard

Features at a Glance

  • OWL Dashboard with 6 summary tiles (count + amount)
  • Per-branch column + customer-level aging buckets
  • "Until <date>" snapshot filter for historical balances
  • Live search by customer name or ID
  • Outstanding Credits flat list with per-row actions
  • Same-Customer reconcile (no JE created)
  • Cross-Customer Transfer with auto-reconcile both legs
  • Allocate wizard with dynamic mode-aware copy
  • Multi-line Write-off wizard (revenue + bad debt)
  • Invoice "Has Outstanding Credits" boolean + filter
  • Suppresses redundant standard Odoo credits banner
  • Styled XLSX export of Dashboard + Outstanding Credits

Pairs with: AR Undefined Customer & Cash Advance

For receipts where the customer is not yet identified — park to a Cash Advance account, then assign when known. Sold separately as aos_ar_undefined (€99).

About Alphasoft

Odoo Indonesia partner since 2014. Production modules for accounting, e-faktur, and process automation.

 www.alphasoft.co.id ·  admin@alphasoft.co.id

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.

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.