Skip to main content

Notifications

Business Central forum
Suggested answer

Best Practise for Processing Vendor Payments and Bank Reconciliation

Posted on by 88

I am looking for guidance, please, on the best practise for managing the payment of vendors using the Payment Journal and then importing the bank statement using the Payment Recon. Journal.

The scenario is as follows:

Use the Payment Journal, suggest vendor payments, export bank file using the AMC functionality, upload the payment batch to local bank and then Post the payment batch. This updates the Vendor sub ledger, matches the payments to the related invoices and posts the credit to the Bank Account and to the associated bank GL Account.

Following day, use the Payment Recon Journal to import the bank statement from the local bank, using the AMC bank import, which populates the journal with the latest transactions, one of which is the payment made the previous day to the vendor(s).

Issue: the vendor payment transaction has already been posted via the Vendor Payment process and so cannot be posted to the bank account again.

From what I can see, there are two possible options: 

1. Delete the vendor payment transaction(s) from the Payment Recon Journal before posting, or

2. Setup and use a different bank account for the Vendor payment process that is associated with a suspense GL account. Apply the Vendor payment transaction(s) in the Payment Recon Journal to the same suspense account when importing the bank statement.

Disadvantage of option 1 is that user may mistakenly delete the wrong transaction(s).

Disadvantage of option 2 is that it requires additional setup and user needs to remember to use the one bank account for vendor payments and the other for Payment Recon Journal.

Or, is there another best practise way that I don't know about?

Look forward to your feedback. Thank you.

  • Mat B Profile Picture
    Mat B 88 on at
    RE: Best Practise for Processing Vendor Payments and Bank Reconciliation

    Thank you for the feedback, however, if you don't post the payment journal but post the recon journal, then the user needs to manually apply the payment to all of the vendors and invoices, which defeats the benefit of running the vendor payments.

    To avoid the issue of payments possibly being blocked / rejected by the bank, I recommend to the users to only post the payment journal once the payment batch has been successfully uploaded and processed by their bank software.

  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,649 Super User 2024 Season 2 on at
    RE: Best Practise for Processing Vendor Payments and Bank Reconciliation

    I think the correct way would be that You export the vendor payments to bank, but don't post the journal. Next day You import statement and post the transactions that have actually been processed, because there is also a scenario that payment was blocked/rejected by bank so this will not be posted.

    This also can vary a lot based on the localization that You are using.

    But maybe some expert who has used this daily, can tell better.

Helpful resources

Quick Links

Dynamics 365 Community Update

Welcome to the inaugural Community Platform Update. As part of our commitment to…

Dynamics 365 Community Newsletter - August 2024

Catch up on the latest D365 Community news

Community Spotlight of the Month

Kudos to Mohana Yadav!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,142 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 227,979 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans