Study guide

11.5 Customer Write-Offs, Bad Debt & Write-Off Reversals

Microsoft Certified: Dynamics 365 Finance Functional Consultant Associate MB-310

Track your progress as you read

Finished sections get a check mark.

1 Chapter 1: MB-310 Exam Overview & Financial Architecture

1.1 MB-310 Exam Structure, Skills Measured & Consultant Role 1.2 Dynamics 365 Finance Architecture, Legal Entities & Global Address Book 1.3 Hands-on Lab Strategy & Preparation Framework

2 Chapter 2: Chart of Accounts & Main Accounts

2.1 Designing Chart of Accounts & Main Account Types 2.2 Main Account Categories & Ledger Account Aliases 2.3 Balance Control Accounts & Year-End Opening Account Setup 2.4 Legal Entity Overrides for Main Accounts & Dimensions

3 Chapter 3: Financial Dimensions & Account Structures

3.1 Custom & Entity-Backed Financial Dimensions 3.2 Financial Tags: Limits, Storage & Ledger Settlement Use 3.3 Account Structures, Segment Criteria & Activation 3.4 Advanced Rules & Advanced Rule Structures 3.5 Derived Dimensions & Dimension Default Templates

4 Chapter 4: Ledgers, Calendars & Currencies

4.1 Fiscal Calendars, Period Statuses & Module Access Control 4.2 Posting Layers, Multi-GAAP Reporting & the Ledger Form 4.3 Currency Exchange Types, Rate Providers & Triangulation 4.4 Accounting & Reporting Currencies (Dual-Currency Architecture) 4.5 Foreign Currency Revaluation & Revaluation Posting Profiles

5 Chapter 5: General Ledger Journals & Allocations

5.1 Journal Names & Voucher Number Sequences 5.2 Journal Control & Posting Restriction Rules 5.3 Journal Entry, the One-Voucher Rule, Validation & Posting 5.4 Reversals, Storno Corrections & Excel Integration 5.5 Ledger Allocation Rules & the Four Allocation Methods 5.6 Allocation Processing & Periodic (Recurring) Journals

6 Chapter 6: Intercompany Accounting & Settlements

6.1 Intercompany Accounting Setup & Due-To / Due-From Postings 6.2 Intercompany Journal Processing & Multi-Company Vouchers 6.3 Ledger Settlements Configuration & Processing

7 Chapter 7: Cash and Bank Management

7.1 Bank Groups, Bank Accounts & Ledger Integration 7.2 Payment Formats, Bank FX Revaluation & Shared Payment Setup 7.3 Manual vs. Advanced Bank Reconciliation & Statement Formats 7.4 Matching Rule Sets, Reconciliation Execution & Reversals 7.5 Cash Flow Forecasting Setup & Automation 7.6 Customer and Vendor Netting

8 Chapter 8: Periodic Closing & Financial Consolidations

8.1 Financial Period Close Workspace, Closing Roles & Schedules 8.2 Year-End Close Configuration & General Ledger Balance Carryforward 8.3 Consolidations Online: Legal Entity Setup, COA Mapping & Currency Translation 8.4 Import Consolidations & Intercompany Elimination Rules

9 Chapter 9: Sales Tax & Withholding Tax

9.1 Sales Tax Engine Hierarchy, Authorities & Settlement Periods 9.2 Ledger Posting Groups, Sales Tax Codes & Calculation Methods 9.3 Sales Tax Groups, Item Sales Tax Groups & Tax Exemptions 9.4 Sales Tax Adjustments and Settle and Post Sales Tax 9.5 Withholding Tax & US 1099 Vendor Reporting

10 Chapter 10: Accounts Receivable Setup & Invoicing

10.1 Customer Master, Customer Groups & Shared Customers 10.2 Customer Posting Profiles & Account Code Precedence 10.3 Free Text Invoices, Recurring Invoice Templates & AR Charges 10.4 Sales Order Invoicing, Billing Classifications & Prepayments 10.5 Customer Payment Methods, Payment Processing & Customer Bank Accounts

11 Chapter 11: Credit Management & Collections

11.1 Credit Management Architecture & Customer Credit Groups 11.2 Risk Scoring, Credit Limits, Blocking Rules & Credit Holds 11.3 Aging Definitions, Collections Workspace & Customer Pools 11.4 Collection Letter Sequences & Interest Notes 11.5 Customer Write-Offs, Bad Debt & Write-Off Reversals

12 Chapter 12: Subscription Billing & Revenue Deferrals

12.1 Recurring Contract Billing, Billing Schedules & Milestones 12.2 Deferral Principles, Deferral Defaults & Schedule Calculation Methods 12.3 Recognition Processing, Expense Deferrals & Modifying Schedules 12.4 Multiple Element Revenue Allocation (MEA / ASC 606)

13 Chapter 13: Accounts Payable & Invoice Processing

13.1 Shared Vendors, Global Address Book & Vendor Groups 13.2 Vendor Posting Profiles, AP Parameters & Vendor Bank Accounts 13.3 Invoice Matching Setup (2-Way, 3-Way), Tolerances & Exceptions 13.4 Vendor Invoicing Methods, Journals & Invoice Automation

14 Chapter 14: Vendor Payments & Expense Management

14.1 Methods of Payment & the Vendor Payment Proposal Engine 14.2 Generating Payments, Centralized Payments & Check Lifecycle 14.3 Expense Management Configuration, Categories & Policies 14.4 Expense Reports Processing, Mobile Receipts & Intercompany Expenses

15 Chapter 15: Budgeting & Budget Control

15.1 Budget Models, Budget Codes & Allocation Terms 15.2 Budget Register Entries, Workflows & Budget vs. Actual 15.3 Budget Transfer Rules & Processing Budget Transfers 15.4 Budget Control Configuration, Cycles, Rules & Budget Groups 15.5 Budget Funds Available, Over-Budget Permissions & Document Budget Check 15.6 Budget Planning Framework, Organization Hierarchies & Planning Processes 15.7 Budget Plans, Scenarios, Allocations & Generating Register Entries

16 Chapter 16: Fixed Assets Configuration & Transactions

16.1 Fixed Asset Groups, Asset Records & Group/Book Mapping 16.2 Depreciation Profiles: Methods & Conventions 16.3 Fixed Asset Books, Derived Books & Posting Profiles 16.4 Fixed Asset Acquisition Pathways 16.5 Depreciation Proposals, Multi-Company Runs & Fixed Asset Budgets 16.6 Fixed Asset Disposals: Sale, Scrap & Disposal Accounting 16.7 Fixed Asset Splits, Transfers & Reclassification 16.8 Asset Leasing (IFRS 16 / ASC 842)

11.5 Customer Write-Offs, Bad Debt & Write-Off Reversals

Key Takeaways Explain This Topic AI

The write-off journal name and the bad debt expense account are set in Accounts receivable parameters, not on the posting profile.

Writing off a customer transaction posts bad debt expense and settles the open invoice in one step.

Sales tax on a written-off invoice can be reversed at write-off time if the parameter to separate sales tax is enabled.

A recovered write-off is handled by reversing the write-off transaction, which reinstates the receivable before the payment is applied.

Last updated: August 2026

11.5 Customer Write-Offs, Bad Debt & Write-Off Reversals

Quick Summary: Customer write-offs move an uncollectible receivable to bad debt expense and settle the invoice. This section covers the Accounts receivable parameter setup that drives the accounts used, the sales tax treatment, and how to reverse a write-off when the customer unexpectedly pays.

1. Customer Write-Offs & Bad Debt Accounting

When customer balances are deemed uncollectible due to bankruptcy, legal abandonment, or protracted default, the organization must perform a Customer Write-Off to derecognize the asset from Accounts Receivable and recognize the bad debt expense.

Navigation

Write-Off Execution: Accessible via Credit and collections > Collections > (Select Customer) > Write off or Accounts receivable > Customers > All customers > Collect tab > Write off .

Write-off Reason Codes: Credit and collections > Setup > Write-off reason codes . +---------------------------------------------------------------------------------------------+

  • | Customer Write-Off Dialog Box |
  • +---------------------------------------------------------------------------------------------+
  • | Write-off Date: ........................ [ 08/31/2026 ] |
  • | Write-off Reason Code: ................. [ `WR_BANKRUPT` ] (Customer Chapter 7 Bankruptcy) |
  • | Description: ........................... [ Uncollectible balance written off per legal ] |
  • | Write-off Amount: ...................... [ $14,250.00 ] |
  • | Write-off Options: ..................... (•) Entire Customer Balance ( ) Selected Invoices|
  • +---------------------------------------------------------------------------------------------+
  • Customer Posting Profile Configuration for Write-Offs

The General Ledger account debited during write-off is determined by the Write-off account configured in the active Customer Posting Profile ( Accounts receivable > Setup > Customer posting profiles ): +---------------------------------------------------------------------------------------------+

  • | Customer Posting Profile: [ GEN_AR ] |
  • +---------------------------------------------------------------------------------------------+
  • | Setup FastTab: |
  • | Account Code: [ All ] Summary Account: [ 130100 - Accounts Receivable Control ] |
  • | Settle Account: [ 130190 ] Interest Account: [ 450100 - Interest Income ] |
  • | Collection Letter Fee: [450200] Write-Off Account: [ 605100 - Bad Debt Expense ] |
  • +---------------------------------------------------------------------------------------------+
  • Detailed Write-Off Accounting Ledger Voucher

Executing the write-off automatically closes the open subledger transaction and posts the balancing journal voucher: +-----------------------------------------------------------------------------+

  • | Standard Customer Write-Off Ledger Entry |
  • +-----------------------------------------------------------------------------+
  • | Account Description | Main Account | Debit Amount | Credit Amount |
  • | ------------------------------------ | ------------ | --------------- | ------------------- |
  • | Bad Debt Expense (or Allowance) | `605100` | $14,250.00 | |
  • | Accounts Receivable Control | `130100` | | $14,250.00 |
  • | **TOTAL BALANCED VOUCHER** | | **$14,250.00** | **$14,250.00** |
  • +-----------------------------------------------------------------------------+

Note

Allowance Method vs. Direct Write-Off: Depending on enterprise accounting policy (GAAP/IFRS), the Write-off account on the posting profile can point either to a P&L expense account ( 605100 - Bad Debt Expense for Direct Write-Off) or to a balance sheet contra-asset account ( 130150 - Allowance for Doubtful Accounts for Allowance Method).

2. Canceling & Reversing Customer Write-Offs

In real-world business, customers whose balances were written off occasionally submit unexpected payments (e.g., bankruptcy dividend distributions or restructured debt settlements).

The Reversal Workflow

Dynamics 365 Finance provides a native Reverse Write-Off (Cancel Write-Off) function to restore subledger integrity without requiring complex manual General Journal adjustments:

Open the customer account in the Collections Workspace or Customer Transactions form.

In the transaction history grid, locate the closed transaction that was written off.

Click Cancel write-off on the Action Pane.

Enter the Cancellation Date and select a Reason Code (e.g., WR_RECOVER - Bad Debt Recovery). +---------------------------------------------------------------------------------------------+

  • | Write-Off Reversal / Cancellation Mechanics |
  • | |
  • | ORIGINAL WRITE-OFF POSTING: |
  • | Debit: Bad Debt Expense (`605100`) .......................... $14,250.00 |
  • | Credit: Accounts Receivable (`130100`) ....................... $14,250.00 |
  • | |
  • | CANCEL WRITE-OFF POSTING (AUTOMATIC REVERSAL): |
  • | Debit: Accounts Receivable (`130100`) ....................... $14,250.00 |
  • | Credit: Bad Debt Expense / Recovery (`605100`) ............... $14,250.00 |
  • | |
  • | RESULT: |
  • | -> Original customer invoice is re-opened in the AR subledger. |
  • | -> Customer cash payment can now be settled directly against the re-opened invoice! |
  • +---------------------------------------------------------------------------------------------+
  • 3. Comprehensive Sequence, Interest & Write-Off Comparison

Operational Feature Setup Location Transaction Type GL Accounts Debited / Credited Subledger Impact

Collection Letter Credit and collections > Setup > Collection letter Formal dunning notice Dr: Customer AR ( 130100 ); Cr: Fee Income ( 450200 ) Increments letter step code; increases balance by fee amount.

Interest Note Credit and collections > Setup > Interest Late finance charge Dr: Customer AR ( 130100 ); Cr: Interest Income ( 450100 ) Generates new interest note transaction balance for customer.

Customer Write-Off Credit and collections > Collections > Write off Bad debt derecognition Dr: Bad Debt Expense ( 605100 ); Cr: Customer AR ( 130100 ) Settles and closes open customer transactions to $0.00 balance.

Cancel Write-Off Credit and collections > History > Cancel write-off Bad debt recovery Dr: Customer AR ( 130100 ); Cr: Bad Debt Expense ( 605100 ) Re-opens original customer invoice for cash payment settlement.

4. Exam Traps & Real-World Best Practices

Warning

Exam Trap: Write-Off GL Account Origin A frequent MB-310 question asks where the General Ledger account for a customer write-off is defined. Candidates often incorrectly look under Credit and collections parameters or Write-off reason codes . The correct configuration path is always Customer Posting Profiles ( Accounts receivable > Setup > Customer posting profiles > Setup FastTab > Write-off account ). Write-off reason codes provide classification metadata, but the posting profile drives the General Ledger main account mapping.

Important

Consultant Pro-Tip: Sequential Letter Validation When configuring Collection Letter Sequences, ensure the Update collection letter code parameter is enabled. If a user manually attempts to create a Collection Letter 3 for an invoice that has never received Collection Letters 1 and 2, Dynamics 365 Finance will reject the generation unless the sequence setup explicitly allows non-linear skipping.