{"id":17956,"date":"2026-01-30T12:29:39","date_gmt":"2026-01-30T12:29:39","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=17956"},"modified":"2026-10-15T11:08:32","modified_gmt":"2026-10-15T11:08:32","slug":"how-receivables-write-off-works-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-receivables-write-off-works-in-idempiere\/","title":{"rendered":"How Receivables Write-Off Works in iDempiere"},"content":{"rendered":"\n

Receivables Write-Off<\/strong> is the controlled process used to close unpaid or partially paid customer invoices when recovery is no longer expected. Instead of cash receipt, the invoice is settled through accounting, keeping Accounts Receivable accurate, auditable, and aligned with financial reality.<\/p>\n\n\n\n

Process Flow<\/strong><\/h2>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Write-Off Scope Definition<\/strong><\/h2>\n\n\n\n

Receivables Write-Off works through criteria-based selection<\/strong>, not manual invoice edits. The user defines which invoices are eligible, and the system evaluates them automatically.<\/p>\n\n\n\n

The scope is defined by configuration choices such as:<\/p>\n\n\n\n

    \n
  • Business Partner or Business Partner Group<\/li>\n\n\n\n
  • Specific Invoice (optional, for targeted write-off)<\/li>\n\n\n\n
  • AP\u2013AR selection set to r<\/strong>eceivables<\/strong> only<\/strong><\/li>\n\n\n\n
  • Maximum write-off per invoice<\/li>\n\n\n\n
  • Invoice date range and accounting date<\/li>\n<\/ul>\n\n\n\n
    \"\"<\/figure>\n\n\n\n

    These controls ensure write-offs follow company policy, accounting periods, and approval limits.<\/p>\n\n\n\n

    Processing Behavior<\/strong><\/h2>\n\n\n\n

    When the process is started, iDempiere scans all invoices that match the criteria and checks their open balance<\/strong> against the allowed write-off threshold. Only eligible invoices are processed.<\/p>\n\n\n\n

    For each qualifying invoice, the system:<\/p>\n\n\n\n

      \n
    • Identifies the remaining open amount<\/li>\n\n\n\n
    • Confirms it is within the permitted write-off limit<\/li>\n\n\n\n
    • Prepares the accounting settlement automatically<\/li>\n<\/ul>\n\n\n\n
      \"\"<\/figure>\n\n\n\n

      No invoice data is edited directly. The system relies entirely on allocation and accounting logic.<\/p>\n\n\n\n

      Allocation Creation and Accounting Flow<\/strong><\/h2>\n\n\n\n

      Instead of creating a real payment, iDempiere generates a manual payment allocation<\/strong> document. This allocation acts as the financial bridge that closes the invoice.<\/p>\n\n\n\n

      Accounting impact is generated during posting:<\/p>\n\n\n\n

        \n
      • Accounts receivable is cleared<\/li>\n\n\n\n
      • The write-off amount is posted to the configured bad debt or write-off expense account<\/li>\n<\/ul>\n\n\n\n
        \"\"<\/figure>\n\n\n\n

        This keeps financial statements balanced and traceable<\/p>\n\n\n\n

        \"\"<\/figure>\n\n\n\n

        This keeps financial statements balanced and traceable<\/p>\n\n\n\n

        Invoice Status After Write-Off<\/strong><\/h2>\n\n\n\n

        After posting, the invoice remains c<\/strong>ompleted<\/strong> and <\/strong>p<\/strong>osted<\/strong>, but its financial state changes. The open amount becomes zero because the allocation satisfies the balance. There is no actual payment record unless the Create Payment<\/em> option was explicitly enabled.<\/p>\n\n\n\n

        \"\"<\/figure>\n\n\n\n

        From an AR perspective, the invoice is now fully settled.<\/p>\n\n\n\n

        Practical Usage in Operations<\/strong><\/h2>\n\n\n\n

        Receivables Write-Off is typically used during month-end or year-end cleanup<\/strong>, customer account reconciliation, and credit control reviews. It prevents inflated receivables, improves ageing accuracy, and ensures overdue balances reflect real collectability.<\/p>\n\n\n\n

        Because the process is parameter-driven, auditable, and posted through standard accounting, it provides a safe and compliant way<\/strong> to handle unavoidable revenue losses without distorting sales or cash reports.<\/p>\n\n\n\n

        Key Characteristics<\/strong><\/h2>\n\n\n\n
          \n
        • No cash movement is involved<\/li>\n\n\n\n
        • Always processed via allocation and posting<\/li>\n\n\n\n
        • AR is cleared without modifying invoice lines<\/li>\n\n\n\n
        • Fully traceable from invoice to allocation to accounting<\/li>\n<\/ul>\n\n\n\n

          This design keeps financial data consistent while giving finance teams precise control over receivables closure.<\/p>\n\n\n\n