BeyondERP.Newsletter
Menu

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

Review unreconciled bank transactions

List the bank transactions that aren't on a reconciled statement yet.

Business process
Reconcile bank accounts
Menu item
output:BankAccountNonReconciled
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 report that lists the bank transactions that aren't reconciled yet.
What you do hereUse this report to show and print the bank transactions that still have to be matched to a bank statement.
ExampleFor example, after reconciling the March statement of the operating account, BEAT runs the report for that account: it lists 6 open transactions, including check 10052 for 4,800.00 issued on 30 March that the vendor hasn't cashed yet.
Unreconciled 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.

When to run it

When to run itAfter you reconcile a bank account against a bank statement, to see which bank transactions are still open.
How oftenEach time you reconcile a bank account, usually once per bank statement.
What the output showsA list of bank transactions that aren't reconciled yet. Old items that never clear usually point to a check that wasn't cashed or a transaction posted to the wrong bank account.

Source: Microsoft Learn

Setup steps on this page

Review unreconciled bank transactions

List the bank transactions that aren't on a reconciled statement yet.

Steps from Microsoft

  1. Go to Cash and bank management > Inquiries and reports > Bank reconciliation reports > Unreconciled bank transactions.
  2. Under Records to include, filter on the bank account you are reconciling and, if needed, on the transaction date.
  3. Run it after you have marked the cleared transactions in Account reconciliation and posted the reconciliation, so only open items remain.
  4. Go through the listed transactions: each one is a bank transaction that isn't matched to a bank statement yet and should show up on a later statement.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Bank accountThe bank account whose open transactions are listed.Microsoft Learn OPERATING
Transaction dateFilter on the date of the bank transactions.Checked in Dynamics 365
Pending cancellationFilter to leave out payments whose reversal is entered but not yet posted or rejected.Microsoft Learn

Common errors and fixes

MessageWhat to do
A transaction that is on the statement still shows as unreconciledIt wasn't marked Cleared before the reconciliation was posted, or it is Pending cancellation. Clear it on the next reconciliation, or have the reversal posted or rejected first. Microsoft Learn
Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Review unreconciled bank transactionsRun it per bank account after each posted reconciliation and follow up items older than one statement period.Old open items are usually uncashed checks, stopped payments or transactions entered twice; the report is the list to work through.Who follows up items left open after reconciliation?Running it before the reconciliation is posted. Every transaction of the period then shows as open.Test: Open items listed after reconciliation

Feature management and licence

Licence or add-inIn this system 10 roles can open this page, among them Treasurer, Chief financial officer, Accounting manager and Financial controller.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: the report lists bank transactions of the current legal entity. Microsoft Learn
Can it be undoneReversible: The report changes no data.
If you change it laterThe list depends on what has been reconciled; it shrinks only when transactions are cleared in a posted reconciliation. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:BankAccountNonReconciled Checked in Dynamics 365
FormSysOperationTemplateForm 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 run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=output:BankAccountNonReconciled
Data migrationLoad order: The Unreconciled bank transactions report has no data entity in Data management, so it can't be loaded from a file or a configuration template. It reads posted bank transactions; at go-live, outstanding items are the open transactions posted after the opening balance.Microsoft Learn
Everyone

8Sources

To cite this step: CB-RPT-110, Review unreconciled bank transactions. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/CB-RPT-110