Notifications
Announcements
No record found.
Does anyone know of anyway to upload a journal from excel into Business Central?
I have tried rapid starting it and it will upload with no errors, yet doesn't show the lines i posted into the G/L Accounts I specified
Any help would be appreciated
Hi Adellek1,
I hope you are doing well. You can use a configuration package or worksheet to import or export the data from an excel sheet.
You can also use copy-paste functionality from Excel to Business Central.
Regards,
Muhammad Zaid
Thank you, I have tried the configuration packages but it doesn't seem to work - unless I am doing something wrong. Never heard of worksheets, how does that work? Also copy/paste doesn't seem to work either?
The configuration worksheet same as the package but it contains just a single table and its link with the configuration package.
For copy-paste you need to have same column in excel and business central. Also include an empty column in excel if you have any empty field in lines in business central.
I hope it helps.
Yes, you can copy from General Journals to Excel first, and then add the rows in the excel, and then copy all the rows directly back to BC.
For example:
[View:/cfs-file/__key/communityserver-discussions-components-files/758/Example0622.mp4:1024:768]
As a follow up, can you tell us if your question was answered or is your question still open? If the answer(s) provided did help you, please mark them if it answered your question, so the post will get the status verified. This would help other community members which will be then directed to the correct replies.
If you need more help please update with a reply.
Hello,
If you are using Business Central Online (Saas) then you can also fill the Journal by Edit in Excel option.
Please follow below steps.
1) Export template in excel by Edit in Excel option
2) Once the template get exported in Excel. you can fill the data and click on publish to push the data into Business central.
Note: You may need to provide BC login credentials in excel add in.
Saurabh
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 3,229
Jainam M. Kothari 1,867 Super User 2025 Season 2
YUN ZHU 1,153 Super User 2025 Season 2
