Study guide
9.2 Ledger Posting Groups, Sales Tax Codes & Calculation Methods
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)
9.2 Ledger Posting Groups, Sales Tax Codes & Calculation Methods
Key Takeaways Explain This Topic AI
A ledger posting group maps sales tax payable, receivable, use tax, and settlement accounts for the tax codes assigned to it.
A sales tax code carries the rate, the settlement period, the ledger posting group, and the calculation origin.
Origin options include Percentage of net amount, Percentage of gross amount, Amount per unit, and Percentage of sales tax, which is how tax-on-tax is modelled.
Marginal base and calculation limits let a rate apply only to the portion of a transaction above or below a threshold, which is how luxury and tiered taxes are configured.
Last updated: August 2026
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:
Calculation Method Mathematical Formula Primary Use Case & Business Scenario
Percentage of net amount Tax = Net Amount × Tax Rate % \text{Tax} = \text{Net Amount} \times \text{Tax Rate}\% Tax = Net Amount × Tax Rate % Standard Sales Tax / VAT: Used for the vast majority of commercial sales and purchases where tax is added on top of the net line price (e.g., $100 net @ 6.25% = $6.25 tax).
Percentage of gross amount Tax = Gross Amount × Tax Rate 100 + Tax Rate \text{Tax} = \text{Gross Amount} \times \frac{\text{Tax Rate}}{100 + \text{Tax Rate}} Tax = Gross Amount × 100 + Tax Rate Tax Rate Gross Price Invoicing (Retail / VAT-Inclusive): Used where item pricing includes tax. For a $106.25 gross item at 6.25% tax: Tax = 106.25 × 6.25 106.25 = $ 6.25 \text{Tax} = 106.25 \times \frac{6.25}{106.25} = \text{\textdollar}6.25 Tax = 106.25 × 106.25 6.25 = $ 6.25 .
Amount per unit Tax = Quantity × Unit Tax Rate \text{Tax} = \text{Quantity} \times \text{Unit Tax Rate} Tax = Quantity × Unit Tax Rate Specific Excise Taxes / Tariffs: Fixed tax per unit of volume, weight, or count (e.g., $0.184 per gallon of gasoline, $1.50 per tire disposal fee), independent of currency sales price.
Calculated percentage of net amount Tiered compound formula based on other tax codes. Tax on Tax (Compound Tax): Used in jurisdictions where secondary provincial/municipal taxes are calculated on top of the net price plus prior federal taxes.
- 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:
Net amount per line: Evaluates the net extended amount of each line individually.
Net amount per unit: Evaluates the net unit price of each unit sold/purchased.
Net amount of invoice balance: Evaluates the consolidated net sum of all lines on the entire invoice matching the tax code.
Gross amount per line: Evaluates the gross amount (net + tax) per line.
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.