Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Unanswered

Duplicate posting of payments only in bank reconciliation worksheet

(0) ShareShare
ReportReport
Posted on by 5

I posted a payment journal with payments to different vendors.

Each payment ID with the amount paid is showing up twice in the bank rec. worksheet.

It is not duplicated in the general ledger account for bank.

It is not duplicated in any of the related vendor ledger entries.

Just duplicated in the bank rec. worksheet.

When I try to clear a line, both lines with the same payment ID get cleared, which does not solve the problem.

Any suggestions on how to resolve this?

Thank you in advance for your assistance.

  • pbelani Profile Picture
    5 on at
    RE: Duplicate posting of payments only in bank reconciliation worksheet

    Hello

    Thank you for attaching link to bank reconciliation in your answer.

    The problem I am encountering is not dealt with there.

    Note that upon posting a payment journal, all 40 transactions have been duplicated in the payment section of the bank reconciliation worksheet

    As an example, I made a payment of $200 to vendor A, it shows up on 2 rows, with same payment ID.

    Same for all 40 transactions.

    So my payments have doubled on the worksheet.

    This has not impacted the general ledger or vendor ledger entries.

    Please help with this specific issue.

    Thanks

  • DAnny3211 Profile Picture
    9,278 Moderator on at
    RE: Duplicate posting of payments only in bank reconciliation worksheet

    hi

    look this

    learn.microsoft.com/.../bank-how-reconcile-bank-accounts-separately

    DAniele

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 1,452

#2
YUN ZHU Profile Picture

YUN ZHU 1,313 Super User 2025 Season 1

#3
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 1,083 Most Valuable Professional

Featured topics

Product updates

Dynamics 365 release plans