9.2 Ledger Posting Groups, Sales Tax Codes & Calculation Methods

9.2 Ledger Posting Groups, Sales Tax Codes & Calculation Methods

Quick Summary: Ledger posting groups determine which general ledger accounts tax posts to, and sales tax codes carry the rate and the calculation origin. This section covers both, plus the marginal base and limit settings used for tiered and threshold-based taxes.

---

1. Ledger Posting Groups & Account Mapping Mechanics

Ledger Posting Groups serve as the financial bridge between the sales tax engine and the Chart of Accounts. They define the specific balance sheet main accounts that are automatically debited or credited during operational postings and periodic settlement runs.

Navigation

• Path: Tax > Setup > Sales tax > Ledger posting groups

+---------------------------------------------------------------------------------------------+
|                               Ledger Posting Group Main Accounts                            |
+---------------------------------------------------------------------------------------------+
| Ledger Posting Group: [ STD_TAX ]       Description: Standard VAT / Sales Tax Posting       |
+---------------------------------------------------------------------------------------------+
| Account Field                   | Account ID | Account Title                 | Classification|
| ------------------------------- | ---------- | ----------------------------- | ------------- |
| **Sales tax payable**           | `220100`   | Sales Tax Payable (Output Tax)| Liability     |
| **Sales tax receivable**        | `130700`   | Sales Tax Receivable (Input)  | Asset         |
| **Use tax payable**             | `220200`   | Use Tax Payable               | Liability     |
| **Use tax expense**             | `601900`   | Use Tax Expense / Inventory   | Expense / Cost|
| **Settlement account**          | `220190`   | Sales Tax Settlement Clearing | Balance Sheet |
| **Vendor cash discount tax**    | `520200`   | Tax Cash Discount - Purchase  | Revenue / Adj |
| **Customer cash discount tax**  | `420200`   | Tax Cash Discount - Sales     | Expense / Adj |
+---------------------------------------------------------------------------------------------+

Detailed Main Account Roles in the Transaction Lifecycle

• Sales tax payable (Output Tax): Debited/credited when invoicing sales orders, free text invoices, or customer revenue journals. Represents the legal tax liability owed to the government collected from customers (Credit balance).
• Sales tax receivable (Input Tax / Deductible VAT): Debited when posting vendor purchase order invoices or AP invoice journals. Represents deductible tax paid to suppliers that offsets output tax liabilities (Debit balance).
• Use tax payable: Credited when purchasing from out-of-state/unregistered suppliers where local sales tax was not collected by the vendor, but must be self-assessed and remitted directly to the local tax authority.
• Use tax expense: Debited simultaneously with Use tax payable to record the cost of the self-assessed tax as an operating expense or capitalized into asset/inventory cost.
• Settlement account: An interim balance sheet clearing account utilized during the Settle and post sales tax periodic run. When tax is settled to a vendor account, the net difference between Sales Tax Payable and Sales Tax Receivable flows through this account or offsets directly against the AP vendor balance.

---

2. Sales Tax Codes Configuration & Calculation Methods

Sales Tax Codes represent the fundamental calculation units in Dynamics 365 Finance. Each code defines a specific tax type, currency, calculation formula, rate percentage, minimum/maximum limits, and ledger posting group.

Navigation

• Path: Tax > Indirect taxes > Sales tax > Sales tax codes

+---------------------------------------------------------------------------------------------+
|                              Sales Tax Code Anatomy: [ IL_STATE ]                           |
+---------------------------------------------------------------------------------------------+
| General Tab:                                                                                |
| - Settlement Period: [ MONTHLY ]         - Ledger Posting Group: [ STD_TAX ]                |
| - Currency: [ USD ]                     - Unit of Measure: [ (Blank) ]                      |
+---------------------------------------------------------------------------------------------+
| Calculation FastTab:                                                                        |
| - Calculation Method: [ Percentage of net amount ]                                          |
| - Marginal Base: [ Net amount per line ]                                                    |
| - Base Origin: [ Net amount ]                                                               |
+---------------------------------------------------------------------------------------------+
| Values FastTab (Rates & Thresholds):                                                        |
| From Date   | To Date      | Minimum Limit | Maximum Limit | Value (%) | Marginal Base Applied  |
| ----------- | ------------ | ------------- | ------------- | --------- | ---------------------- |
| 01/01/2026  | 12/31/2026   | 0.00          | 0.00          | 6.2500 %  | Net amount per line    |
+---------------------------------------------------------------------------------------------+

Calculation Methods Comparison

Dynamics 365 Finance provides four distinct mathematical methods for calculating tax on transaction lines:

---

3. Marginal Base, Base Calculation Order & Limits

Marginal Base Options

The Marginal base setting determines which transaction figure the system compares against the configured Minimum limit and Maximum limit thresholds on the Values tab:

1. Net amount per line: Evaluates the net extended amount of each line individually.
2. Net amount per unit: Evaluates the net unit price of each unit sold/purchased.
3. Net amount of invoice balance: Evaluates the consolidated net sum of all lines on the entire invoice matching the tax code.
4. Gross amount per line: Evaluates the gross amount (net + tax) per line.
5. Gross amount per unit: Evaluates the gross amount per single unit.

+---------------------------------------------------------------------------------------------+
|                 Marginal Base Matrix: Invoice Balance vs. Line Item Tiering                 |
|                                                                                             |
|  Tax Code 'LUX_TAX' Rule: 10% tax on amounts exceeding $10,000 threshold.                   |
|                                                                                             |
|  Scenario: Invoice with Line 1 = $6,000 and Line 2 = $7,000 (Total = $13,000).             |
|                                                                                             |
|  - If Marginal Base = 'Net amount per line':                                                |
|    Line 1 ($6,000 < $10k) -> $0.00 tax.                                                     |
|    Line 2 ($7,000 < $10k) -> $0.00 tax.        Total Tax = $0.00                            |
|                                                                                             |
|  - If Marginal Base = 'Net amount of invoice balance':                                      |
|    Total Invoice Net = $13,000 (> $10,000).                                                 |
|    Tax applies to the eligible balance.        Total Tax = $300.00 (10% of $3,000 excess)   |
+---------------------------------------------------------------------------------------------+

Reverse Charge Mechanism

In European VAT and international cross-border B2B transactions, the Reverse Charge rule shifts the legal obligation to account for VAT from the seller to the buyer:

• On the Sales Tax Code, activate Reverse charge = Yes.
• When posted on a purchase invoice, the posting engine automatically generates equal and offsetting entries in both Sales tax receivable (Input VAT deduction) and Sales tax payable (Output VAT liability).
• Net financial impact on the General Ledger trial balance is $0.00, but statutory VAT return boxes reflect both output and input tax turnover seamlessly.

---

4. Exam Traps & Real-World Best Practices

[!WARNING] Exam Trap: Missing AP Vendor on Sales Tax Authority A common MB-310 scenario describes an accounting team successfully running the Settle and post sales tax routine, but the Accounts Payable team cannot find the settlement invoice in the payment journal proposal. The root cause is always a missing Vendor Account link on the Sales Tax Authority record. Without this link, D365 Finance clears the GL tax accounts to the settlement ledger account but cannot create an AP vendor liability subledger transaction.

[!IMPORTANT] Consultant Pro-Tip: Date-Effective Sales Tax Values Never overwrite existing rate percentages on the Values FastTab of a Sales Tax Code when statutory tax rates change! Always create a new line with a new From date and To date. Overwriting the historical rate will retroactively distort re-calculated adjustments, credit notes, and correction settlements.