9.4 Sales Tax Adjustments and Settle and Post Sales Tax

9.4 Sales Tax Adjustments and Settle and Post Sales Tax

Quick Summary: Managing indirect and direct taxation extends beyond transaction calculation to periodic closing, adjustments, and statutory remittances. In Microsoft Dynamics 365 Finance, the periodic Settle and post sales tax routine clears accumulated Sales Tax Payable and Sales Tax Receivable balances and generates a net vendor payable to the tax authority. In parallel, organizations must handle line-level manual sales tax adjustments, configure Withholding Tax (deducting taxes at source from vendor payments), and govern US 1099 Vendor Reporting through box mapping and retroactive transaction update routines.

---

1. Sales Tax Inspection & Manual Adjustments During Entry

Prior to posting journals, sales orders, or purchase invoices, accounting users frequently need to inspect calculated tax amounts or manually adjust tax figures to reconcile subtle penny-rounding discrepancies with supplier paper invoices.

Accessing and Inspecting Sales Tax Details

From any document header or line (e.g., Vendor Invoice Journal > Lines, Sales Order > Sell tab, Vendor Invoice), click the Sales tax button in the Action Pane.

+---------------------------------------------------------------------------------------------+
|                          Sales Tax Transactions Inspection Form                             |
+---------------------------------------------------------------------------------------------+
| Sales Tax Code | Base Amount | Calculated Tax Amount | Actual Sales Tax Amount | Difference |
| -------------- | ----------- | --------------------- | ----------------------- | ---------- |
| `IL_STATE`     | $10,000.00  | $625.00               | $625.00                 | $0.00      |
| `COOK_CNTY`    | $10,000.00  | $175.00               | $175.02                 | +$0.02     |
| `CHI_CITY`     | $10,000.00  | $125.00               | $125.00                 | $0.00      |
+---------------------------------------------------------------------------------------------+
| [ Reset ] -> Restores all Actual Sales Tax Amounts to Calculated Sales Tax Amounts          |
+---------------------------------------------------------------------------------------------+

Manual Tax Adjustment Rules

1. Calculated Sales Tax Amount: The system-derived tax value based on active tax code percentages and marginal base settings (read-only).
2. Actual Sales Tax Amount: An editable field where users can manually adjust the tax figure.
3. Tolerance Controls: Manual adjustments are governed by legal entity parameters (General ledger parameters > Sales tax > Maximum rounding tolerance). If an adjustment exceeds the configured tolerance threshold (e.g., $5.00), the system blocks posting to prevent unauthorized accounting distortion.
4. Reset Button: Instantly clears all manual adjustments and re-runs the standard calculation engine.

---

2. The Settle and Post Sales Tax Periodic Process & Payment Versions

The periodic tax settlement routine consolidates all posted sales tax transactions within a defined settlement period interval, clears the intermediate GL tax accounts, and establishes a net remittance liability against the tax authority vendor.

Navigation

• Path: Tax > Declarations > Sales tax > Settle and post sales tax

+---------------------------------------------------------------------------------------------+
|                       Settle and Post Sales Tax Parameter Dialog                            |
+---------------------------------------------------------------------------------------------+
|  Settlement Period:       [ MONTHLY               ]                                         |
|  From Date:               [ 08/01/2026            ] (Auto-populated from active interval)   |
|  Transaction Date:        [ 08/31/2026            ] (Settlement voucher & invoice date)     |
|  Sales Tax Payment Version:[ Original             ]                                         |
|  Post:                    [X] Yes                                                           |
+---------------------------------------------------------------------------------------------+

Sales Tax Payment Versions Matrix

Understanding the four settlement payment versions is a vital MB-310 exam competency:

---

3. Tax Settlement Accounting Mechanics & T-Account Flows

When the Settle and post sales tax job is posted, Dynamics 365 Finance executes an automated balancing voucher that zeros out the active tax accounts for the period:

Standard Scenario: Net Output Tax Liability Payable to Authority

• Total Output Sales Tax Collected (Payable Account 220100): $45,000.00 (Credit balance)
• Total Input Sales Tax Paid to Vendors (Receivable Account 130700): $30,000.00 (Debit balance)
• Net Tax Due to State Tax Authority Vendor (V-TAX-STATE): $15,000.00 (Credit liability)

  GENERAL LEDGER TAX ACCOUNTS                             TAX AUTHORITY VENDOR SUBLEDGER
  
  Sales Tax Payable (220100)                              Vendor Account: V-TAX-STATE
  ---------------------------------                       ---------------------------------
  (Dr) 45,000 | 45,000 (Open Bal)                                          | 15,000 (Cr Invoice)
  ---------------------------------                       ---------------------------------
  Balance: $0                                             Balance: $15,000 Open AP Liability
  
  Sales Tax Receivable (130700)                           
  ---------------------------------                       
  (Open Bal) 30,000 | 30,000 (Cr)                         
  ---------------------------------                       
  Balance: $0                                             

Step-by-Step Authority Payment Disbursement

1. Settlement Run: Generates Open Vendor Invoice TAX-SETTL-0826 in Accounts Payable for $15,000 against vendor V-TAX-STATE.
2. Payment Execution: Accounts Payable opens Accounts payable > Payments > Vendor payment journal.
3. Payment Proposal: Creates a payment proposal selecting vendor V-TAX-STATE.
4. Disbursement Voucher: Posts payment disbursement:
   • Debit: Vendor Account V-TAX-STATE ($15,000.00)
   • Credit: Operating Bank Account 110110 ($15,000.00)
5. Settlement Complete: All general ledger tax accounts and AP vendor balances are fully settled to $0.00.

---