Skip to main content

Notifications

Community site session details

Community site session details

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

Hey Everyone, I just bought the Business Central subscription and i am trying to post journal entries for around 2000 transactions from my excel extracted bank statement

(0) ShareShare
ReportReport
Posted on by 5

Hey Everyone, I just bought the Business Central subscription and I am trying to post journal entries for around 2000 transactions from my excel extracted bank statement. I see i can manually do it by posting each entries but I would love to know how to do it in one go by uploading the excel to Dynamics. Can anyone give me instructions on how to do it step by step or by a quick call in Teams. or is it really possible to upload transaction through excel once.

  • Suggested answer
    YUN ZHU Profile Picture
    81,491 Super User 2025 Season 1 on at
    RE: Hey Everyone, I just bought the Business Central subscription and i am trying to post journal entries for around 2000 transactions from my excel extracted bank statement

    Or you can just use configuration package feature.

    More details: https://yzhums.com/4286/

    And if this is a Bank Statement File, you can also try the following feature.

    Simplified bank statement file import (Bank Statement File Format Wizard)

    More details: https://yzhums.com/11072/

    Hope this helps.

    Thanks.

    ZHU

  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,021 Moderator on at
    RE: Hey Everyone, I just bought the Business Central subscription and i am trying to post journal entries for around 2000 transactions from my excel extracted bank statement

    Here is one example on how it can be done using the Edit in Excel feature from the general journal.

    www.encorebusiness.com/.../

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,157 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,930 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans