How to create new vendors in bulk?

(6) Share

Report

Posted on by FB-30032328-0

Hello,

I have to create over 100 new vendors and just wonder if we can do that in bulk.

On the Vendors page - i can go Edit in Excel and add the vendor details such as vendor no., phone number, etc. and then publish. However, I cant see where i can add the payment method, BSB and account number.

Does anyone know where i can add the vendor's bank details in bulk on an excel sheet too? Thank you.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Suggested answer

Jainam M. Kothari 15,964 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hello,

You can use the Configuration package to Bulk upload the Vendors and Vendor Bank Account Data because in Edit in Excel you can add the details of Vendor Table only and not for related tables.

Was this reply helpful? Yes No
Verified answer

Mansi Soni 9,156 Super User 2026 Season 1 on at

Like (5)

Report
Copy link

Link copied!

Hello, In Business Central, you can bulk create vendors using the Edit in Excel feature from the Vendors list page. However, vendor bank details such as BSB and account numbers are stored in the Vendor Bank Account table, not directly on the Vendor card. So for that you can use Configuration Packages to import both Vendor and Vendor Bank Account data while ensuring correct table mappings.

Hope this answer will help you!

Regards,
Mansi Soni

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 22,342 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Adding mor details: You can bulk-create vendors using Edit in Excel on the Vendors page, but bank details are in the Vendor Bank Account (Table 288). So, you need to add vendor bank account details first or import both together. You can do this using the Configuration Package.

Please check this. https://help.xe.com/hc/en-gb/articles/17504022439697-How-to-bulk-upload-vendor-information-to-the-Vendor-card-in-Business-Central

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 100,214 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Configuration Package is the most commonly used approach.

More details: Dynamics 365 Business Central: How to Export and Import Data (Using Configuration Packages)

https://yzhums.com/4286/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 32,666 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hope this helps as well - How to Import Data Using Configuration Packages in Dynamics 365 Business Central - Dynamics 365 Business Central Insights

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No