11.4 Collection Letter Sequences & Interest Notes
Key Takeaways
- A collection letter sequence defines escalating letter codes with a minimum overdue days and optional fee for each step.
- Collection letters are created in a batch proposal, reviewed, then printed and posted; individual customers can be excluded before posting.
- The letter level advances only when a letter is actually posted, so deleting a proposed letter leaves the customer at the previous level.
- Interest codes define the rate and calculation basis for interest notes, which are proposed, reviewed, and posted as separate customer transactions.
Last updated: August 2026
11.4 Collection Letter Sequences & Interest Notes
Quick Summary: When standard collection activities fail to secure customer payments, Microsoft Dynamics 365 Finance provides formal, automated statutory escalation mechanisms: Collection Letter Sequences (graduated dunning notices with progressive administrative fees), Interest Notes (automated late payment finance charges based on percentage or index rates), and Customer Write-Offs (bad debt recognition and subledger balance relief). This section details the complete configuration matrix, posting profile ledger accounts, automated voucher generation, and write-off cancellation workflows tested on the MB-310 exam.
1. Collection Letter Sequences & Escalation Hierarchy
Collection Letter Sequences govern the progressive escalation ladder applied to delinquent customer invoices. Each sequence contains a series of chronological steps that dictate when letters are produced, what fees are assessed, and whether further sales transactions should be blocked.
Navigation
- Path:
Credit and collections > Setup > Collection letter(Collection letter sequence setup)
+---------------------------------------------------------------------------------------------------------+
| Collection Letter Sequence Setup Grid |
+---------------------------------------------------------------------------------------------------------+
| Sequence ID: [ STANDARD_ESC ] Description: Standard Corporate Escalation Ladder |
| Terms of Payment: [ Net 10 ] (Grace Period) Currency: [ USD ] |
+---------------------------------------------------------------------------------------------------------+
| ESCALATION STEPS MATRIX: |
| Step | Collection Letter Code | Days Overdue | Fee Amount | Currency | Block Sales Order | Account Status |
| :--: | ---------------------- | :----------: | :--------: | :------: | :---------------: | :------------- |
| 1 | `Collection letter 1` | 15 Days | $0.00 | USD | No | Open |
| 2 | `Collection letter 2` | 30 Days | $25.00 | USD | No | Open |
| 3 | `Collection letter 3` | 45 Days | $50.00 | USD | Yes | Open |
| 4 | `Collection letter 4` | 60 Days | $100.00 | USD | Yes | Stopped (Inv) |
| 5 | `Collection` | 90 Days | $250.00 | USD | Yes | Stopped (All) |
+---------------------------------------------------------------------------------------------------------+
Progression Rules & Parameters
- Sequential Progression: By default, Dynamics 365 Finance requires an invoice to progress through each letter code in sequential order (
Letter 1$\rightarrow$Letter 2$\rightarrow$Letter 3$\rightarrow$Letter 4$\rightarrow$Collection). An invoice cannot jump directly fromNonetoLetter 3unless the sequence is explicitly configured to allow non-sequential generation. - Days Overdue Threshold: Specifies the minimum number of days beyond the invoice due date required before the step becomes eligible.
- Fee Amount: Flat administrative penalty assessed to the customer for generating the dunning notice.
- Block Sales Order: When set to Yes, posting this collection letter automatically sets the customer's order hold status, preventing sales order entry and confirmation.
- Terms of Payment: Defines the payment grace period printed on the letter (e.g., "Payment must be received within 10 days of this notice").
2. Periodic Creation, Processing & Posting of Collection Letters
Generating and issuing collection letters is a two-step periodic workflow: Creation (proposal) followed by Review and Posting.
+---------------------------------------------------------------------------------------------+
| Collection Letter Two-Step Processing Pipeline |
+---------------------------------------------------------------------------------------------+
| |
| STEP 1: CREATION (PROPOSAL GENERATION) |
| Path: Credit and collections > Collection letter > Creation of collection letters |
| - Evaluates open invoices against Collection Letter Sequence rules. |
| - Filters by Customer Pool, Legal Entity, and Aging Date. |
| - Parameters: [X] Exclude transactions in dispute. |
| - Status generated: 'Created' (Proposal stage - no GL impact). |
| |
| | |
| v |
| |
| STEP 2: REVIEW & POSTING |
| Path: Credit and collections > Collection letter > Review and process collection letters |
| - Credit manager reviews proposed letters, edits fee amounts, or deletes lines. |
| - Executes 'Post' action: |
| 1. Updates invoice status to current Collection Letter Code (e.g., Letter 2). |
| 2. Generates printed/electronic PDF dunning document. |
| 3. Posts General Ledger financial voucher for administrative fees! |
+---------------------------------------------------------------------------------------------+
Collection Letter Fee Accounting Voucher
When a collection letter with an assessed administrative fee is posted, Dynamics 365 Finance posts a financial voucher configured in the Customer Posting Profile (Accounts receivable > Setup > Customer posting profiles > Setup FastTab > Collection letter fee):
+-----------------------------------------------------------------------------+
| Collection Letter Fee Accounting Entry |
+-----------------------------------------------------------------------------+
| Account Description | Main Account | Debit Amount | Credit Amount |
| ------------------------------------ | ------------ | ------------ | ------------- |
| Accounts Receivable (Customer) | `130100` | $50.00 | |
| Collection Letter Fee Revenue | `450200` | | $50.00 |
| **TOTAL BALANCED VOUCHER** | | **$50.00** | **$50.00** |
+-----------------------------------------------------------------------------+
3. Interest Codes & Interest Note Calculation
Interest Codes define the terms and mathematical formulas used to calculate late payment interest (finance charges) on overdue balances.
Navigation
- Path:
Credit and collections > Setup > Interest(Interest codes setup)
+---------------------------------------------------------------------------------------------+
| Interest Code Anatomy: [ LATE_FIN_01 ] |
+---------------------------------------------------------------------------------------------+
| General Tab: |
| - Calculate interest based on: ......... [ Days ] (Options: Days / Months) |
| - Grace period: ........................ [ 5 Days ] |
| - Minimum interest amount: ............. [ $15.00 ] |
| - Calculate interest on: ............... [ Percentage ] (Options: Percentage / Amount / Idx)|
+---------------------------------------------------------------------------------------------+
| Earnings FastTab (Posting Setup): |
| - Ledger posting group / Main account: . [ 450100 - Finance Charge & Interest Income ] |
| - Write-off account: ................... [ 605100 - Bad Debt Expense ] |
+---------------------------------------------------------------------------------------------+
| Rates Tab: |
| From Date | To Date | Interest % | Calculation Method | Interval Units |
| ----------- | ------------ | :---------: | ------------------ | --------------------------- |
| 01/01/2026 | 12/31/2026 | 18.0000 % | Annual Rate (APR) | Daily Accrual (APR / 365) |
+---------------------------------------------------------------------------------------------+
Core Calculation Parameters
- Calculate Interest Based On:
- Percentage: Applies a fixed annual percentage rate (APR) converted to a daily or monthly periodic rate.
- Amount / Tiered Rates: Configures progressive interest rates based on the number of days overdue (e.g., 1–30 days = 10%, 31–60 days = 15%, > 60 days = 20%).
- Interest Index Rate: Dynamically links interest to a floating financial market benchmark (e.g., Fed Funds Effective Rate + 5.0% margin).
- Grace Period: Number of days after the invoice due date during which no interest is assessed. If paid within the grace period, zero interest applies; once the grace period expires, interest calculates retroactively from day 1 past due or from the grace cutoff date based on parameter setup.
- Minimum Interest Amount: If calculated interest is below this threshold (e.g., $15.00), no interest note is generated, preventing uneconomical micro-invoicing.
Creation & Posting of Interest Notes
- Creation:
Credit and collections > Interest > Creation of interest notes(Generates interest note proposals). - Posting:
Credit and collections > Interest > Review and process interest notes(Posts voucher and generates customer statement).
+-----------------------------------------------------------------------------+
| Interest Note Accounting Entry |
+-----------------------------------------------------------------------------+
| Account Description | Main Account | Debit Amount | Credit Amount |
| ------------------------------------ | ------------ | ------------ | ------------- |
| Accounts Receivable (Customer) | `130100` | $187.50 | |
| Interest & Finance Charge Income | `450100` | | $187.50 |
| **TOTAL BALANCED VOUCHER** | | **$187.50** | **$187.50** |
+-----------------------------------------------------------------------------+
Loading diagram...
Test Your Knowledge
An organization configures a Collection Letter Sequence with four steps. When reviewing a proposed batch of collection letters, the credit clerk discovers that an invoice 65 days overdue received Collection Letter 1 instead of Collection Letter 4. What is the most likely cause of this behavior?
A
B
C
D
Test Your Knowledge
A collection letter proposal contains four customers. The credit clerk deletes the proposed letter for one customer whose dispute is still open, then prints and posts the remaining three. What happens to the collection letter level of the excluded customer?
A
B
C
D