AutoCount Universal Import Plugin

AutoCount Universal Import Plugin — Bulk Excel & CSV Data Import for AutoCount

AutoCount Universal Import Plugin is an AutoCount Accounting add-on that enables Malaysian businesses to bulk import data from Excel (.xlsx) and CSV (.csv) files directly into AutoCount. Import master records — debtors, creditors, items, chart of accounts — and transactional data — sales invoices, purchase orders, delivery orders, GL journal entries, stock records — in a single operation. The plugin includes flexible column mapping, column searching to auto-fill missing fields, and error record logging for review and correction. Designed for data migration, new system setup, and ongoing batch data processing from external sources.

Why AutoCount Universal Import Plugin?

In standard AutoCount Accounting, data entry is done record by record through the user interface. Setting up a new account book with 500 debtors, 300 items, and 2 years of opening transactions means keying in each record manually. Migrating from another accounting system — SQL Accounting, UBS, or Excel spreadsheets — means re-entering everything from scratch. The Universal Import Plugin eliminates this by reading your existing data from Excel or CSV files and importing it directly into AutoCount's modules. What would take weeks of manual data entry can be completed in hours.

Supported Import Types

Master Data Import

✅ Debtor Master (Customer records)
✅ Creditor Master (Supplier records)
✅ Item Master (Stock/product records)
✅ Account Master (Chart of accounts)
✅ General Maintenance data

Sales Document Import

✅ Quotation
✅ Sales Order
✅ Delivery Order
✅ Sales Invoice
✅ Cash Sale
✅ Credit Note
✅ Debit Note
✅ Sales Consignment

Purchase Document Import

✅ Purchase Order
✅ Purchase Invoice
✅ Purchase documents and related transactions

Accounting & Stock Import

✅ General Ledger (GL) entries
✅ Accounts Receivable (AR) entries
✅ Accounts Payable (AP) entries
✅ Stock records and inventory data

AutoCount Universal Import Plugin Key Features

Excel & CSV File Upload

Upload Excel (.xlsx) or CSV (.csv) files directly into the plugin. The system reads your file, displays the data, and maps it to AutoCount's database fields. No manual copy-paste, no field-by-field data entry. Prepare your data in the spreadsheet format your business already uses, and the plugin handles the import.

Column Mapping

Map the column headers in your Excel or CSV file to the corresponding fields in AutoCount — even when the column names don't match AutoCount's standard field names. If your file uses "CustomerName" but AutoCount expects "DebtorCode," the column mapping feature lets you assign one to the other. The system stores your mapping preferences for repeated use — set it up once and reuse the same mapping for future imports. This eliminates the need to reformat your source files to match AutoCount's naming conventions.

Column Searching (Auto-Fill Missing Fields)

When your import file is missing certain required columns, the plugin can use existing columns to infer and fill in the missing data. If your file has a UDF field like "OldCode" but not "DebtorCode," the system can reference the old code to find and fill in the corresponding debtor code from existing AutoCount records. This feature significantly reduces import preparation — your source data doesn't need to be perfectly complete for a successful import.

Master + Transaction Import in One Process

Import both master records and their associated transaction details in a single operation. When importing sales invoices, the plugin can simultaneously create any new debtor or item records that don't yet exist in AutoCount — no need to import master data first and transactions second as separate steps.

Error Record Logging

When import errors occur — missing required fields, duplicate records, invalid data formats — the plugin logs them as error records for review. You can see exactly which rows failed, why they failed, and correct them for re-import. No silent failures, no mystery data gaps. Every import produces a clear success/error report.

Multiple Import Methods

The plugin supports multiple import approaches to suit different business workflows. Direct Method for manual file upload, API Method for programmatic integration with external systems, and File Drop Method for automatic processing of files placed in a designated folder. Scheduled imports can run at specified intervals — even every minute — for businesses that need continuous data flow from external systems into AutoCount.

Default Value Settings

Configure default values for common fields — default account numbers, default AR/AP settings, default debtor/creditor details, default GL accounts, default stock settings. When your import file doesn't specify these fields, the plugin applies the defaults automatically. This simplifies file preparation and ensures consistent data across all imported records.

Who Should Buy AutoCount Universal Import Plugin?

Businesses Migrating to AutoCount

Companies switching from SQL Accounting, UBS, MYOB, Excel-based bookkeeping, or any other system to AutoCount. Export your existing data to Excel or CSV, map the columns, and import everything into AutoCount — debtors, creditors, items, opening balances, and historical transactions. The plugin turns a weeks-long migration project into a manageable operation.

Accounting Firms Setting Up New Client Books

Firms that onboard new clients and need to set up their AutoCount account books with existing master data and opening balances. Instead of keying in hundreds of debtors, creditors, and items manually for each new client, import them from the client's existing records.

Businesses Receiving Data from External Systems

Companies that receive sales data, stock data, or transaction records from external platforms — e-commerce systems, warehouse management systems, POS systems, or head office ERP — in Excel or CSV format. The Universal Import Plugin processes these files into AutoCount automatically, eliminating manual re-entry of externally generated data.

Businesses with High-Volume Data Entry Needs

Any Malaysian SME that regularly needs to enter large volumes of data into AutoCount — monthly stock opening balances, batch supplier invoices, bulk customer records, or mass item catalogue updates. If you're spending hours on repetitive data entry that originates from a spreadsheet, the plugin automates the transfer.

Multi-Branch Businesses Consolidating Data

Companies with multiple branches submitting data in Excel format to head office for consolidation in AutoCount. Each branch exports their transactions to a standard Excel template, and head office imports all branch data into the central AutoCount system using the plugin.

AutoCount Universal Import Plugin vs AutoCount Excel Import

AutoCount has a built-in Excel import function that uses a copy-paste method — manually copy data from Excel and paste into AutoCount's import screen. This requires exact column name matching, does not support column searching for missing fields, and does not store mapping preferences. The Universal Import Plugin is the advanced alternative — file upload instead of copy-paste, flexible column mapping with saved preferences, column searching to auto-fill missing data, error logging, and scheduled automated imports. If you import data occasionally with simple files, built-in Excel import may suffice. If you import data regularly, from non-standard file formats, or need automated processing, you need the Universal Import Plugin.

What's Included

✅ Excel (.xlsx) & CSV (.csv) File Import
✅ Master Data Import (Debtors, Creditors, Items, Accounts)
✅ Sales Document Import (QT, SO, DO, IV, CS, CN, DN, Consignment)
✅ Purchase Document Import (PO, PI, and Related Transactions)
✅ GL, AR, AP, Stock Data Import
✅ Column Mapping with Saved Preferences
✅ Column Searching (Auto-Fill Missing Fields)
✅ Master + Transaction Import in Single Process
✅ Error Record Logging & Review
✅ Multiple Import Methods (Direct, API, File Drop)
✅ Scheduled Automated Imports
✅ Default Value Configuration
✅ Compatible with AutoCount Accounting 2.2