web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Customer Short Payments (Bad Debt / Write-off) in Business Central

(3) ShareShare
ReportReport
Posted on by 262

I have a customer invoice for $1,082.50.
The customer paid only $1,000, and the remaining $82.50 will not be received (to be treated as bad debt / write-off / discount).

What I Did in Cash Receipt Journal

  1. Posted a customer payment of $1,000 to the bank account.
  2. Added a second journal line for $82.50 to a G/L account (Bad Debt Expense).
  3. Applied both lines to the same customer and invoice using Apply Customer Entries.

Both lines are marked as Applied = Yes.

What I Am Expecting

  • The invoice should be fully paid and closed
  • Customer should have no remaining balance
  • Bank account should reflect only $1,000 received
  • The $82.50 should be reflected only as an expense (bad debt / write-off)
  • No open amount should remain on the customer ledger

What Actually Happens After Posting

  • Business Central still shows $82.50 as remaining amount on the invoice
  • Customer ledger indicates the customer still owes $82.50
  • Even though:
    • The bank received only $1,000
    • The $82.50 is already posted to a G/L expense
    • Both lines are applied to the customer

The Gap / Issue

From an accounting perspective:

  • The customer does not owe the remaining amount
  • The loss is already recognized in P&L

But from a system perspective: Business Central still treats the invoice as not fully settled

Looking for guidance on:

  • Whether this is the expected standard behavior or am I making any mistakes?
  • Or if there is a recommended setup / posting method to fully clear the invoice while correctly recording the write-off, without impacting bank reconciliation.

Appreciate insights from anyone who has handled short payments or customer write-offs in Business Central.

I have the same question (0)
  • Suggested answer
    CU05020828-0 Profile Picture
    2 on at
    Why Your Current Approach Does NOT Close the Invoice
     
    Key rule in Business Central:  Only customer ledger entries (with Customer Posting Group) can settle customer invoices.
    Posting directly to a G/L expense does not reduce the customer balance.
     
    What happened with your posting
    You posted:
    $1,000 → Bank → Customer - (Correct)
    $82.50 → G/L Bad Debt Expense → Customer - (Wrong)
     
    Even though:
    You applied both lines
    Both show “Applied = Yes”
     
    G/L shows the expense
     BC still sees only $1,000 posted through the customer subledger.
    The $82.50 went around the customer control account, so the invoice remains partially open

    Correct & Recommended Ways to Handle This in Business Central
    (BEST PRACTICE): Use Customer Payment Tolerance
    This is exactly what Payment Tolerance is designed for.
     
    Setup (One-time)
    Customer Posting Group>>Set Payment Tolerance Account >>Bad Debt Expense (or Write-Off)
    General Ledger Setup Enable
    Payment Tolerance
    Payment Tolerance Posting
    Posting Flow
    Post only $1,000 as customer payment
    Apply it to the invoice
    BC automatically: Writes off $82.50
     
    Posts it to the tolerance account Closes the invoice fully
    Bank = $1,000
    P&L = $82.50 expense
    Customer balance = $0
     Invoice = Closed
     
    This is the cleanest and most audit-friendly method
     
     
    Hope this resolved your Query.
    Regards
    Tech-Lucky
  • Honey98 Profile Picture
    262 on at

    Hi Team,

    I have set up the maximum tolerance, and currently it is posting to only one G/L account. However, I would like to categorize the differences—for example, if it is a bank fee, credit card charge, manual discount, or loss—while receiving payments from the Cash Receipt Journal.

    Is it possible to use dimensions to handle these scenarios? Would that be the right approach, or is there any alternative method to categorize and post these differences to separate G/L accounts?

    Looking forward to your suggestions.

  • Suggested answer
    OussamaSabbouh Profile Picture
    9,231 on at
    Hello,
    This is expected standard Business Central behavior: even though your accounting is correct, BC will not fully close an invoice unless it’s settled only with customer ledger entries. The $1,000 payment clears part of the invoice, but the $82.50 posted directly to a G/L account (Bad Debt Expense) does not reduce the customer balance, even if it’s marked as Applied. As a result, BC keeps the invoice partially open. To fully clear it, the write-off must be posted as a Sales Credit Memo (recommended) or as a Customer-type journal line balanced to the bad debt G/L account—both create customer ledger entries that BC can apply and close the invoice correctly, without affecting bank reconciliation.
    Regards,
    Oussama Sabbouh

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,167

#2
Dhiren Nagar Profile Picture

Dhiren Nagar 1,184

#3
YUN ZHU Profile Picture

YUN ZHU 1,161 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans