Study guide

9.5 Withholding Tax & US 1099 Vendor Reporting

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.5 Withholding Tax & US 1099 Vendor Reporting

Key Takeaways Explain This Topic AI

Withholding tax is deducted from a vendor payment and remitted to the authority on the vendor's behalf, configured through withholding tax codes, groups, and authorities.

Withholding tax is calculated at payment time, not at invoice time, and requires 'Calculate withholding tax' on the vendor record.

US 1099 reporting is driven by the 1099 box assigned on the vendor and can be overridden per invoice line.

The Vendor settlement for 1099s periodic task retroactively updates 1099 amounts for invoices posted without correct box mapping.

Last updated: October 2026

9.5 Withholding Tax & US 1099 Vendor Reporting

Quick Summary: Withholding tax deducts an amount from a vendor payment and remits it to a tax authority, while US 1099 reporting classifies vendor spend into IRS boxes. This section covers configuration of both and the retroactive update path when 1099 mapping was missed.

1. Withholding Tax Architecture, Configuration & Processing

Withholding Tax is an income tax deduction mechanism where the purchasing company is legally mandated to withhold a specific percentage of payment from a vendor (typically independent service contractors, freelancers, or foreign royalty licensors) and remit that withheld tax directly to the government on the vendor's behalf.

Withholding Tax Setup Components

Withholding Tax Authorities: Tax > Indirect taxes > Withholding tax > Withholding tax authorities (Linked to Tax Authority AP Vendor).

Withholding Tax Settlement Periods: Tax > Indirect taxes > Withholding tax > Withholding tax settlement periods (Defines reporting intervals).

Withholding Tax Ledger Posting Groups: Tax > Setup > Withholding tax > Withholding tax ledger posting groups (Maps Withholding Tax Payable liability account 220300 ).

Withholding Tax Codes: Tax > Indirect taxes > Withholding tax > Withholding tax codes (Defines withholding rate %, minimum/maximum threshold amounts).

Withholding Tax Groups: Tax > Indirect taxes > Withholding tax > Withholding tax groups (Assigned to Vendor records or document lines). +---------------------------------------------------------------------------------------------+

  • | Withholding Tax Payment Flow Mechanics |
  • +---------------------------------------------------------------------------------------------+
  • | |
  • | 1. Vendor Submits Consulting Invoice: $10,000.00 |
  • | - Withholding Tax Group: 'WHT_10' (10% Withholding Tax Rate) |
  • | |
  • | 2. Vendor Invoice Posting: |
  • | - Debit Consulting Expense (610500): ............ $10,000.00 |
  • | - Credit Accounts Payable (Vendor V-1001): ....... $10,000.00 |
  • | |
  • | 3. Vendor Payment Disbursement (Applying 10% Withholding Tax at Payment): |
  • | - Debit Accounts Payable (Vendor V-1001): ....... $10,000.00 (Clears full invoice) |
  • | - Credit Operating Bank Account (110110): ........ $9,000.00 (Net cash to vendor) |
  • | - Credit Withholding Tax Payable (220300): ....... $1,000.00 (Owed to IRS / Gov) |
  • | |
  • | 4. Periodic Withholding Tax Settlement: |
  • | - Debit Withholding Tax Payable (220300): ....... $1,000.00 |
  • | - Credit AP Tax Authority Vendor (V-IRS): ........ $1,000.00 |
  • +---------------------------------------------------------------------------------------------+
  • 2. US 1099 Vendor Tax Reporting, Box Mapping & Retroactive Updates

In the United States, businesses must report payments made to non-corporate independent contractors, attorneys, and service providers to the Internal Revenue Service (IRS) via Form 1099 .

Vendor Master 1099 Setup

Navigate to Accounts payable > Vendors > All vendors > open vendor record > expand Tax reporting FastTab:

Report 1099: Set toggle to Yes .

Federal tax ID: Enter the vendor's Taxpayer Identification Number (TIN), Employer Identification Number (EIN), or Social Security Number (SSN).

Tax ID type: Select EIN , SSN , or ITIN .

1099 Box (Default): Select the appropriate default 1099 form and box code.

DBA (Doing Business As): Specify registered trade name if different from legal name.

Comprehensive 1099 Form & Box Mapping Reference Table

1099 Form Box Code Box Description Federal Minimum Threshold Common Business Expenditure Types

1099-NEC NEC-01 Nonemployee Compensation $2,000.00 (2026; $600.00 through 2025) Independent contractors, freelance developers, consulting fees, professional services.

1099-MISC MISC-01 Rents $2,000.00 (2026; $600.00 through 2025) Real estate office leases, equipment rental, land leasing.

1099-MISC MISC-02 Royalties $10.00 Intellectual property royalties, software licensing rights, publishing royalties.

1099-MISC MISC-03 Other Income $2,000.00 (2026; $600.00 through 2025) Prizes, awards, deceased employee wages paid to beneficiaries.

1099-MISC MISC-10 Gross Proceeds Paid to an Attorney $600.00 Legal settlements paid to attorneys in connection with legal services.

1099-INT INT-01 Interest Income $10.00 Interest paid on promissory notes, vendor debts, loans.

1099-DIV DIV-01 Total Ordinary Dividends $10.00 Corporate dividend distributions to shareholders.

1099-G G-01 Certain Government Payments $10.00 State or local tax refunds, agricultural program payments.

The 'Update 1099 Information' Utility

When a vendor is mistakenly created without enabling the Report 1099 toggle, or when transactions were posted to the wrong 1099 box during the fiscal year, consultants do not need to reverse and re-post invoices manually. Instead, run the Update 1099 information periodic utility:

Path: Accounts payable > Periodic tasks > Update 1099 information +---------------------------------------------------------------------------------------------+

  • | Update 1099 Information Utility Flow |
  • +---------------------------------------------------------------------------------------------+
  • | |
  • | Selection Options: |
  • | 1. [ Update all transactions ] -> Updates vendor header 1099 status and recalculates all |
  • | historical invoice distributions for the year. |
  • | 2. [ Update 1099 box only ] -> Reclassifies transactions from one box to another |
  • | (e.g., from MISC-07 to NEC-01). |
  • | 3. [ Update 1099 amount only ] -> Adjusts reportable amounts based on threshold criteria.|
  • | |
  • | Filter Criteria: Vendor Account = 'V-10042', Date Range = '01/01/2026 .. 12/31/2026' |
  • | Result: Instantly repairs historical 1099 ledger tables without altering posted GL vouchers!|
  • +---------------------------------------------------------------------------------------------+
  • 3. Exam Traps & Real-World Best Practices

Warning

Exam Trap: 'Corrections' vs. 'Latest Corrections' Settlement Versions MB-310 questions frequently test the difference between settlement versions when backdated entries occur:

Corrections: Generates a full settlement report containing the original transactions plus all backdated transactions.

Latest corrections: Generates an incremental settlement voucher containing only the delta difference since the last settlement run. When the question asks how to post only the additional tax owed without reprocessing the original voucher, choose Latest corrections !

Important

Consultant Pro-Tip: Fixing 1099 Data at Year-End If a client realizes in January that 50 contractor invoices were posted throughout the year without 1099 tracking because the Report 1099 checkbox was turned off on the vendor master, never recommend posting reversing GL journals! Enable Report 1099 and assign the default 1099 box on the vendor master, then navigate to Accounts payable > Periodic tasks > Update 1099 information and execute the batch update for that vendor and fiscal year.

Loading diagram... 1099 Setup, Transaction Tagging, and Retroactive Update Workflow