AutoCount BOM Import Plugin

AutoCount BOM Import Plugin — Bulk Bill of Materials Import from Excel for AutoCount

AutoCount BOM Import Plugin is an AutoCount Accounting add-on that enables Malaysian manufacturers to bulk import Bill of Materials (BOM) data from Excel files directly into AutoCount's Stock Assembly module. Instead of creating each BOM manually — adding the finished good item, defining every component, specifying quantities, and setting wastage for each product one by one — this plugin reads your BOM data from Excel and creates all BOM records in AutoCount in a single batch operation. Includes field mapping, data validation, and bulk import capabilities. Sold as a 1-year subscription license. Requires AutoCount Premium Edition with Stock Assembly module enabled.

Why AutoCount BOM Import Plugin?

AutoCount Premium's Stock Assembly module lets you define BOMs — specifying which raw materials and components are needed to produce a finished good, with quantities and wastage per component. But creating BOMs manually in AutoCount is time-consuming. A manufacturer producing 100 different finished goods, each with 10–20 components, needs to create 100 BOM records with a total of 1,000–2,000 component lines. Each line requires selecting the component item code, entering the quantity, and setting the UOM. Manually, this takes days. Most manufacturers already have their BOM data in Excel spreadsheets — maintained by the production team, engineering department, or procurement. The BOM Import Plugin lets you import that existing Excel data directly into AutoCount without re-entering it.

AutoCount BOM Import Plugin Key Features

Excel to AutoCount BOM Import

Prepare your BOM data in Excel (.xlsx) or CSV format — finished good item code, component item codes, component quantities, UOM, wastage percentages, and any other BOM fields. Upload the file to the plugin and it creates the corresponding BOM records in AutoCount's Stock Assembly module. One Excel file can contain multiple BOMs — import your entire product range in a single operation.

Field Mapping

Map the column headers in your Excel file to the corresponding fields in AutoCount's BOM structure. Your Excel may use "Parent Item" while AutoCount expects "Assembly Item Code." The mapping interface lets you align each column to the correct AutoCount field — finished good code, component code, component quantity, UOM, wastage, and other BOM attributes. Save your mapping configuration for repeated use — set it up once and reuse for future BOM imports.

Data Validation

Before importing, the plugin validates your BOM data against AutoCount's item master and Stock Assembly requirements. Invalid item codes, missing components, incorrect UOM references, duplicate entries, and data format errors are flagged before import. Review and correct errors in the validation report before committing the import — no bad data enters your Stock Assembly records.

Bulk Import

Import multiple BOMs in a single batch operation. A manufacturer with 200 products can prepare all 200 BOMs in one Excel file and import them in one go. Each BOM is created in AutoCount with its full component list, quantities, and settings. No need to create BOMs one at a time through the Stock Assembly interface.

BOM Updates & Maintenance

When product formulations change — new components, adjusted quantities, replaced materials — update your Excel BOM file and re-import. The plugin handles BOM updates alongside new BOM creation. Keep your Excel master BOM file as the single source of truth and push changes to AutoCount when production requirements change.

Version Control

Maintain BOM versions through your Excel files and import history. When a product recipe or assembly specification is revised, import the updated version while retaining visibility of previous BOM configurations. This supports manufacturing businesses that need to track how their product compositions change over time for quality control and regulatory compliance.

Who Should Buy AutoCount BOM Import Plugin?

Manufacturers with Large Product Ranges

Factories producing dozens or hundreds of different finished goods — each with its own BOM. Manually creating 100+ BOMs with 10–20 components each in AutoCount's Stock Assembly interface is impractical. The plugin imports the entire product range from an Excel master file in minutes.

Food & Beverage Manufacturers

F&B producers managing recipes with multiple ingredients per product. Each recipe is a BOM — the finished food product is the assembly item, and the ingredients are the components. Import all recipes from a centralised Excel recipe database into AutoCount for production costing and stock deduction.

Furniture & Woodworking Manufacturers

Furniture makers where each finished product (table, chair, cabinet) has a BOM listing timber, hardware, fabric, foam, glass, and other components. Import BOMs from production planning spreadsheets into AutoCount for material requirement planning and cost calculation.

Electronics & Assembly Operations

Electronics assemblers, cable manufacturers, and component assembly businesses where each finished product has a detailed BOM of sub-components. Engineering teams typically maintain BOMs in Excel — the plugin bridges the gap between engineering's Excel data and accounting's AutoCount system.

Businesses Migrating to AutoCount Premium

Companies upgrading to AutoCount Premium and setting up Stock Assembly for the first time. Existing BOM data in spreadsheets from the previous system (or from production planning) can be imported directly — no need to recreate every BOM from scratch in AutoCount.

Businesses with Frequently Changing BOMs

Manufacturers that regularly update product formulations — seasonal ingredient changes, material substitutions, cost optimisation adjustments. Instead of manually editing BOMs in AutoCount one by one, maintain the master BOM file in Excel and reimport when changes occur.

AutoCount BOM Import Plugin vs Manual BOM Entry

Without the plugin, each BOM is created manually in AutoCount's Stock Assembly interface — select the assembly item, add each component line by line, enter quantities and UOM for every component. For a product with 15 components, that's 15 lines of manual entry per BOM. For 100 products, that's 1,500 manual component entries. With the plugin, prepare all 100 BOMs in Excel and import them in one operation. The time saving is proportional to your product range — the larger your catalogue, the more critical this plugin becomes.

What's Included

✅ Excel (.xlsx) & CSV BOM Data Import
✅ Field Mapping (Excel Columns → AutoCount BOM Fields)
✅ Data Validation Before Import
✅ Bulk Import (Multiple BOMs in Single Operation)
✅ BOM Update & Maintenance via Re-Import
✅ Version Control Support
✅ Saved Mapping Configurations for Repeated Use
✅ Sold as a 1-Year Subscription License
✅ Requires AutoCount Premium Edition with Stock Assembly Module
✅ Compatible with AutoCount Accounting 2.2