5.4 Reversals, Storno Corrections & Excel Integration

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:

1. On the journal line, check the Reversing entry checkbox.
2. 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).
3. 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'

Standard Data Entities for General Journals

1. LedgerJournalHeaderEntity (General journal header): Manages journal batch creation, journal names, and header-level parameters.
2. 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!       |
+-----------------------------------------------------------------------------+

1. Open General ledger > Journal entries > General journals and select a journal batch.
2. Click the Microsoft Office icon in the upper right corner and select Open in Excel > General journal line entry template.
3. Open the downloaded workbook and enable editing. The Microsoft Dynamics Office Add-in loads in the side task pane, authenticating through Microsoft Entra ID.
4. Enter or paste transaction rows into the formatted Excel table. Use the built-in lookup controls for Main Accounts and Financial Dimensions.
5. Click Publish in the Excel Add-in pane.
6. 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.