BeyondERP.Newsletter
Menu

Setup step on the Bank transactions page · Cash and bank management

Reconcile reversed bank transactions with each other

Clear reversed payments and canceled checks before the reconciliation worksheet.

Used by
Accounts payable manager, Auditor, Chief executive officer and 7 more roles
Business process
Perform advanced bank reconciliation in Dynamics 365 Finance
Menu item
BankDocumentTableListPage
Main table
BankDocumentTableView
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA list page of the bank transactions recorded in Finance for advanced bank reconciliation, where reversed transactions can be reconciled with each other.
What you do hereUse this page to reconcile two opposite bank transactions, such as a payment and its reversal, so that they don't appear on the reconciliation worksheet.
ExampleFor example, BEAT voided check 10045 for 3,200.00 and posted its reversal: the check and its reversal have the same bank account, document type and payment reference, so they are reconciled together here and don't appear on the next reconciliation worksheet.
Bank transactions page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Setup steps on this page

Reconcile reversed bank transactions with each other

Clear reversed payments and canceled checks before the reconciliation worksheet.

Steps from Microsoft

  1. Go to Cash and bank management > Bank statement reconciliation > Bank transactions.
  2. Filter on the bank account, the date range, Document type and Reconciled = No.
  3. Select the transaction and its reversal: they must have the same bank account, document type and payment reference and opposite amounts.
  4. Select Reconcile transactions, or select a single canceled check and reconcile it on its own.
  5. Use Reconciliation relations to see which transactions were reconciled together.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Bank accountThe bank account of the bank transaction.Microsoft Learn OPERATING
Document typeThe kind of bank document, such as a check or a deposit; reversed pairs must have the same document type.Microsoft Learn Check
Payment referenceThe payment reference; reversed pairs must have the same reference.Microsoft Learn 10045
ReconciledWhether the bank transaction is already reconciled.Microsoft Learn No

Common errors and fixes

MessageWhat to do
Two transactions can't be reconciled togetherThey must have the same bank account, document type and payment reference, and opposite amounts. Check the reference on the reversal. Microsoft Learn

Test checklist

  1. Post a check and its reversal for 3,200.00.
  2. Filter the page on the check's payment reference.
  3. Select both and Reconcile transactions.
  4. Open the reconciliation worksheet and check neither line is listed.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Reconcile reversed bank transactions with each otherReconcile reversal pairs and canceled checks here before each reconciliation, filtered on Reconciled = No.Reversed company transactions must be reconciled on this page, otherwise both stay open on the worksheet with no statement line to match.Should reversed company transactions be cleared by hand on this page or by a matching rule?Waiting for a bank statement line for a voided check. A check that never reached the bank has no line, so it stays open unless it is reconciled here.Test: Reversed check pair is reconciled

Feature management and licence

Licence or add-inIn this system 10 roles can open this page, among them Auditor, Chief executive officer, Chief financial officer and Accounts receivable manager.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: the bank transactions belong to the bank accounts of the current legal entity. Microsoft Learn
Can it be undoneHard to reverse: Check the pair before you reconcile it.
If you change it laterReconciled pairs and single canceled checks no longer appear on the reconciliation worksheet, so they don't need a bank statement line. Microsoft Learn
Technical architect

6Technical

Menu itemBankDocumentTableListPage Checked in Dynamics 365
FormBankDocumentTableListPage Checked in Dynamics 365
TableBankDocumentTableViewShown as “Bank document table view” in Record infoChecked in Dynamics 365
Who can open itPrivilegesView bank documents BankDocumentBookViewDutiesInquire into bank account reconciliation status BankBankAcctReconStatusInquireEnable bank management process BankBankManagementProcessEnableReview bank management process performance BankBankManagementProcessPerfReview
10 security rolesAuditor AuditPolicyManagerChief executive officer CompanyChiefExecutiveOfficerChief financial officer CompanyChiefFinancialOfficerAccounts receivable manager CustInvoiceAccountsReceivableManagerAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialControllerTreasurer PaymTreasurerAccounts payable manager VendInvoiceAccountsPayableManager
Checked in Dynamics 365
Roles to set it up and use itTo use itTreasurer PaymTreasurerChief financial officer CompanyChiefFinancialOfficerAccounting manager LedgerAccountingManagerFinancial controller LedgerFinancialControllerAccountant LedgerAccountantGive people one of these roles. On this system, 10 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=BankDocumentTableListPage
Data migrationLoad order: Bank transactions reconciliation has no data entity in Data management, so it can't be loaded from a file or a configuration template. Bank transactions come from posted journals; reconcile reversed pairs in each environment.Checked in Dynamics 365
Everyone

8Sources

To cite this step: CB-REC-030, Reconcile reversed bank transactions with each other. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/CB-REC-030