Setup step on the Transaction code mapping page · Cash and bank management
Set up Transaction code mapping
Used so reconciliation matching rules match only the same kinds of transactions between Finance and the bank statement.
- Used by
- Chief financial officer, Accountant, Accounting manager and 3 more roles
- Business process
- Establish matching rules for bank reconciliation in Dynamics 365 Finance
- Menu item
BankStatementTransactionTypeMapping- Main table
BankStatementTransactionTypeHeader- Data entity
BankStatementTransactionTypeEntity- Setup steps
- 1 on this page
Show what matters for
Everyone
1What it is and why
| What it is | A setup page where you map your bank's statement transaction codes to bank transaction types, for each bank account. |
|---|---|
| What you do here | Used so reconciliation matching rules match only the same kinds of transactions between Finance and the bank statement. |
| Example | — |
Functional consultant · Solution architect
2Where it fits
| Business process | Define accounting policies › Define banking policies › Establish matching rules for bank reconciliation in Dynamics 365 Finance |
|---|---|
| Menu path | Cash and bank management › Setup › Advanced bank reconciliation setup › Transaction code mapping |
| Set up first | Bank transaction types Microsoft Learn ↗ |
| Used next by | Reconciliation matching rules Microsoft Learn ↗ |
| Related pages | Cash and bank management parameters Microsoft Learn ↗ |
| In this process | Set up Reconciliation matching rules → |
End user · Functional consultant
3How to do it
Step by step, with screenshots
Set up Transaction code mapping1 screen
Used so reconciliation matching rules match only the same kinds of transactions between Finance and the bank statement.
Screen 1
Map the statement transaction code
Go to Cash and bank management > Setup > Advanced bank reconciliation setup > Transaction code mapping
- Select New and select the Bank account
- In the Mappings section, select Add
- Enter the Statement transaction code and select the Bank transaction type
- Select Save
1Bank account BEAT-OPS 2Statement transaction code BEAT-FEE 2Bank transaction type BEAT-FEE 
Show the full screen
page title tab to open what to set or check
Microsoft's steps
- Go to Cash and bank management > Setup > Advanced bank reconciliation setup > Transaction code mapping.
- Select New.
- In the Bank account field, select the bank account.
- In the Mappings area, select Add, and map a statement code to a bank transaction type.
- Repeat the mapping for each bank account.
Source: Microsoft Learn ↗
Field guide
| Field | What it means | Worked example | Table column |
|---|---|---|---|
| Bank account | The bank account the mapping applies to; each account is mapped separately.Microsoft Learn ↗ | BEAT-OPS | — |
| Mappings | The pairs of statement codes and bank transaction types.Microsoft Learn ↗ | — | — |
| Statement transaction code | — | BEAT-FEE | — |
| Bank transaction type | — | BEAT-FEE | — |
Functional consultant
4Setup decisions
| Setup step | Recommended value and why | Decision · common mistake · test |
|---|---|---|
| Set up Transaction code mapping | — | — |
Solution architect
5Design impact
| Shared or per company | Per company: each legal entity has its own records. Microsoft data model ↗ |
|---|---|
| Can it be undone | — |
| Feature or country | — |
| If you change it later | — |
Technical architect
6Technical
| Menu item | BankStatementTransactionTypeMapping Checked in Dynamics 365 |
|---|---|
| Form | BankStatementTransactionTypeMapping Checked in Dynamics 365 |
| Table | BankStatementTransactionTypeHeaderShown as “Transaction code mapping” in Record infoKey field: BankAccountTableChecked in Dynamics 365 |
| Data entities | BankStatementTransactionTypeEntityTransaction code mapping Microsoft data model ↗ |
| Who can open it | PrivilegesMaintain bank statement transaction type mapping BankStmtTransactionTypeMapMaintainView bank statement transaction type mapping BankStmtTransactionTypeMapViewDutiesInquire into bank account reconciliation status BankBankAcctReconStatusInquireEnable bank management process BankBankManagementProcessEnable6 security rolesChief financial officerCompanyChiefFinancialOfficerAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialControllerTreasurer PaymTreasurer |
| Actions on the page | Options: Personalize, Page options, ShareChecked in Dynamics 365 |
Developer
7Developer
| Open it directly | https://<your-environment>/?mi=BankStatementTransactionTypeMapping |
|---|---|
| Integrate with | BankStatementTransactionTypeEntity data entity Microsoft data model ↗ |
| Table definition | BankStatementTransactionTypeHeader columns and relations Microsoft data model ↗ |
Everyone
8Sources and checks
- learn.microsoft.com/dynamics365/finance/cash-bank-management/configure-advanced-bank-reconciliation
- learn.microsoft.com/common-data-model/schema/core/operationscommon/tables/finance/bank/group/bankstatementtransactiontypeheader
- Checked in a working Dynamics 365 system, version 10.0.49: the menu item, form, table and security, the page, the demo records and the values in the screenshots.
CB-SETUP-150 — Set up Transaction code mapping. Beyond ERP Atlas Hub, snapshot 2026-10-16, partly verified. https://www.beyonderp.cloud/atlas/step/CB-SETUP-150