Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Procedure for booking bank statement manually in Dynamics 365

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi,

In small companies I don't want to use the advanced bank reconciliation. I receive the statement by mail and just want to enter the transactions and book them directly on the cost and vendor accounts. How shoud I do this?

Hans

*This post is locked for comments

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,031 Super User 2025 Season 1 on at
    RE: Procedure for booking bank statement manually in Dynamics 365

    Hi Hans,

    There are three options:

    - Use the Balance control inquiry on the journal. This is an overview with at least all bank accounts including the opening balance, transactions and closing balance.

    - Put in two additional lines in the journal where you revert the opening balance and add the closing balance on the bank account.

    - Check the Belgium features for the ending balance control setting on journal names. This enables an additional field on the journal for the closing balance. It would be possible to do a customization to have it also available for other countries. (countryregioncodes properties used)

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Procedure for booking bank statement manually in Dynamics 365

    Hi André,

    Thanks for your quick reply. But how do I get the opportunity to have the opening and closing balance of the bank account?

    Hans

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,031 Super User 2025 Season 1 on at
    RE: Procedure for booking bank statement manually in Dynamics 365

    Hi Hans,

    You can setup a general journal name for the bank transactions. Then you can register and post them as a journal. This is commonly used in e.g. the Netherlands. There are some ISV solutions which would enable the option to import the electronic statements in a journal and prepare some automatic matching.

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…

Vahid Ghafarpour – Community Spotlight

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

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,031 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,868 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans