Skip to main content

Notifications

Announcements

No record found.

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

Best Practise for Processing Vendor Payments and Bank Reconciliation

(0) ShareShare
ReportReport
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 4,032 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.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,904 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,605 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans