Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Payment Reconciliation Journal

(3) ShareShare
ReportReport
Posted on by 51
Hello all,
 
We would like to use payment reconciliation journal, however we are coming up with a limitation that i was hoping someone has a solution to.
 
It seems that you can only post the journal if ALL the transactions in the entire journal have been MATCHED / ACCEPTED.
 
Is there a way to only post only the matching ones, and leave the remainder in the journal?  I tried filtering for only the accepted ones and posting but i get the same error.
 
Thanks
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 7,396 Super User 2025 Season 1 on at
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 76,622 Super User 2025 Season 1 on at
    Payment Reconciliation Journal
    Hi, You can delete unmatched lines, or match them first, post them, and reverse them if there are any problems.
    More details:
    Reverse payment reconciliation journal entries
     
    Hope this helps.
    Thanks.
    ZHU
  • Suggested answer
    Kntx Profile Picture
    Kntx 11 on at
    Payment Reconciliation Journal
    Hello,
    it is not possible without developing a customization, this is actually one of the requests that we also often receive from our customers.
     
    I would suggest to vote the following idea about this topic to increase the chances that it is picked up by Microsoft:
     
    We also have this feature in our app BankLink that you can find on AppSource:
     
    The app provides provides functionality to connect to banking institutions and download bank transactions directly into Business Central, without the need to manually download files or login to bank portals every day. If you don't need the import functionalities of the app, of course it would not make sense to purchase it just for this feature.
     
    Best.
     
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 25,565 Super User 2025 Season 1 on at
    Payment Reconciliation Journal
    As far as I know, it's not possible. The reason being that in the journal, you either match the lines from your bank with existing transactions in the system, or, if no corresponding transaction exists, you create and post them.
     
    You can delete the unmatched lines and post only the matched ones, but I'm not sure if this is a viable solution, as the next time you import, you'll need to import the same lines again which will be a mix of matched and unmatched entries.
     

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,963 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,761 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans