Dynamics Community Forum Thread Details

Customer Journal Payment Not Appearing on Bank Reconciliation Worksheet

Hi everyone,

I'm currently investigating an issue in Dynamics 365 Finance and would appreciate any insights or suggestions.

We receipted a payment via a Customer Journal, and the offset account used was the same bank account we’re trying to reconcile against the bank statement transactions. The transaction is visible in the bank ledger, but it’s not appearing on the Bank Reconciliation Worksheet under the Bank Transactions section.

Here’s what I’ve checked so far:

Verified that the transaction is posted and visible in the bank ledger.
Confirmed that the bank account used in the journal is the same as the one selected in the bank reconciliation.
Ensured the transaction date falls within the reconciliation date range.

Has anyone encountered a similar issue? Are there specific setups, flags, or statuses that might prevent a customer journal transaction from appearing on the bank rec worksheet?

Any thoughts on troubleshooting steps or areas to investigate would be greatly appreciated.

Thanks in advance!

Categories:

Dynamics 365 Finance

Microsoft Dynamics AX

Hi Umer,

Could you please review the below setups -

Transaction Type Filtering:

Ensure the journal line includes a valid bank transaction type; missing or incorrect types can prevent visibility on the worksheet.

Journal Setup & Workflow:

If using Advanced Bank Reconciliation, confirm the journal isn’t linked to an approval workflow and is properly configured in bank parameters.

Feature Management:

On newer versions (10.0.39+), verify that the Modern bank reconciliation feature is enabled, as it changes how transactions are matched and displayed.

Ledger vs. Bank Module Disconnect:

A transaction may post to the bank ledger but still be excluded from reconciliation due to missing flags or mismatched setup

Try reviewing the transaction under Cash and bank management > Bank accounts > Transactions and confirm it’s marked as unreconciled.

If this helped, please mark it as "Verified" for others facing the same issue.
Keep in mind that it is possible to mark more than one answer as verified.

Quick Links