Study guide
5.4 Reversals, Storno Corrections & Excel Integration
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)
5.4 Reversals, Storno Corrections & Excel Integration
Key Takeaways Explain This Topic AI
A financial reversal creates an offsetting voucher; a storno (correction) reversal posts negative amounts on the original side so gross turnover is not inflated.
Storno posting is required in jurisdictions such as Germany where inflated debit and credit turnover is not acceptable, and is switched on in General ledger parameters.
Reversal date and reason code are captured on the reversal so the audit trail explains why the entry was backed out.
The Excel Workbook Designer and the journal data entities let accountants build and publish large journal batches from Excel with live validation against Dynamics 365 Finance.
Last updated: August 2026
5.4 Reversals, Storno Corrections & Excel Integration
Quick Summary: Reversing an entry in Dynamics 365 Finance is either a financial reversal or a storno correction, and the choice changes reported turnover. This section also covers accrual schemes and the Excel add-in path for high-volume journal preparation.
1. Transaction Reversals, Accruals & Storno (Correction) Posting
Financial accounting frequently requires reversing accidental postings or clearing short-term month-end accruals in the subsequent period.
Automated Pre-Posting Reversals (Month-End Accruals)
When entering an accrual journal line on the last day of the month:
On the journal line, check the Reversing entry checkbox.
In the Reversing date field, enter the first day of the subsequent fiscal period (e.g., Transaction Date = 2026-08-31 , Reversing Date = 2026-09-01 ).
Upon clicking Post , Dynamics 365 Finance posts the original voucher on August 31, 2026, and simultaneously generates and posts a mirror reversal voucher dated September 1, 2026, in the General Ledger.
Post-Posting Manual Reversals ('Reverse Transaction')
For vouchers that have already been posted:
Navigation: General ledger > Inquiries and reports > Voucher transactions > select the target voucher > click Reverse transaction in the Action Pane.
Reversal Parameters:
Reversal posting date: Choose to reverse on the Original transaction date or a New transaction date .
Reason code: Select an audit reason code explaining the reversal.
The system creates an offsetting voucher linked to the original voucher, flagging the original transaction with Reversed = Yes and recording the Reversed by voucher ID.
Correction / Storno Accounting (European Regulatory Compliance)
In standard Anglo-American accounting, a reversal swaps the debit and credit sides. However, in many European jurisdictions (Germany, Poland, Czech Republic, France), swapping sides falsely inflates cumulative debit and credit turnover on trial balance reports. Original Transaction: Debit Expense $1,000.00 | Credit Bank $1,000.00
- -------------------------------------------------------------------------------
- Standard Reversal: Debit Bank $1,000.00 | Credit Expense $1,000.00
- (Result: Total Trial Balance turnover increases by $2,000.00!)
Correction / Storno Reversal:
- Debit Expense -$1,000.00 | Credit Bank -$1,000.00
- (Result: Debit remains on Debit side, Credit remains on Credit side; net turnover = $0.00!)
How to Configure: In General ledger > Ledger setup > General ledger parameters > Accounting rules , enable Correction (Storno). In journals, check the Correction checkbox on the voucher line to post negative debits or negative credits.
2. Microsoft Office Integration (Excel Workbook Designer & Data Entities)
Dynamics 365 Finance integrates natively with Microsoft Excel via the Microsoft Dynamics Office Add-in , enabling high-speed data entry, offline journal authoring, and mass line editing.
'Export to Excel' vs. 'Open in Excel'
- Feature Export to Excel Open in Excel (Office Add-in)
- Data Flow One-way download (static snapshot) Two-way bidirectional synchronization
Editing & Updates Changes in Excel cannot be pushed back to D365 Changes in Excel are published directly to D365
- Authentication None (Static file) Microsoft Entra ID (OAuth 2.0)
- Business Logic Validation None Full server-side account structure & posting validation
- Primary Use Case Ad-hoc reporting, printable balance sheets Mass journal entry, opening balance migration
- Standard Data Entities for General Journals
LedgerJournalHeaderEntity (General journal header): Manages journal batch creation, journal names, and header-level parameters.
LedgerJournalLineEntity (General journal line): Manages individual voucher lines, accounts, financial dimensions, debits, credits, and currency codes.
End-to-End Excel Publishing Walkthrough +-----------------------------------------------------------------------------+
- | Excel Office Add-in Data Flow |
- +-----------------------------------------------------------------------------+
- | 1. In D365: Click 'Open in Excel' -> Select General Journal Line Template |
- | 2. Excel opens with embedded Add-in authenticated to D365 OData endpoint |
- | 3. User populates 500 rows (Account, Dimensions, Amount, Currency) |
- | 4. User clicks 'Publish' in the Excel Add-in Task Pane |
- | 5. D365 OData engine validates data rules (Valid main accounts, dims, open)||
- | 6. Result: 500 lines committed into D365 General Journal Lines grid! |
- +-----------------------------------------------------------------------------+
Open General ledger > Journal entries > General journals and select a journal batch.
Click the Microsoft Office icon in the upper right corner and select Open in Excel > General journal line entry template .
Open the downloaded workbook and enable editing. The Microsoft Dynamics Office Add-in loads in the side task pane, authenticating through Microsoft Entra ID.
Enter or paste transaction rows into the formatted Excel table. Use the built-in lookup controls for Main Accounts and Financial Dimensions.
Click Publish in the Excel Add-in pane.
The OData service validates every row against the active Chart of Accounts, Account Structures, and Ledger Calendar period statuses. Any invalid cells are highlighted in red with descriptive error messages in the task pane.
3. Exam Traps & Real-World Best Practices
Warning
Exam Trap: Reversing Settled Subledger Vouchers If an AP or AR subledger transaction has already been settled (e.g., a vendor payment matched against a vendor invoice), clicking Reverse transaction directly from the voucher inquiry will fail with a settlement error. Candidates must first navigate to Accounts payable > Vendors > All vendors > Transactions > Undo settlement to un-settle the invoice and payment before executing the voucher reversal!
Tip
Consultant Pro-Tip: Deploying Custom Document Templates To ensure all corporate accountants use standardized Excel journal layouts with pre-configured dimension columns, design a master template and upload it under Common > Office integration > Document templates . Set the template as default for the LedgerJournalLineEntity .