AutoCount Plugin: Universal Import Plugin
Simplify and Automate Data Imports from Excel/CSV Files into AutoCount
The AutoCount Universal Import Plugin is a powerful data import tool designed to help you upload large volumes of structured data — such as customers, suppliers, transactions, stock, and accounting records — from Excel or CSV files directly into AutoCount without manual entry. Unlike the standard Import by Excel tool (copy-paste), this plugin uses file upload, header mapping, and column searching to make bulk data import faster, more accurate, and flexible.
AutoCount Universal Import Plugin Video Guide
Core Features
Wide Range of Supported Data Types
The Universal Import Plugin lets you import data across many modules, including:
- Default AccNo: Account numbers for transactions.
- Default ARAP: Accounts receivable and payable.
- Default Debtor Creditor: Details of debtors and creditors.
- Default GL: General ledger entries.
- Default Purchase: Transactional records.
- Default StockItem
- Default Stock: Inventory details.
- Default General Maintenance: Other administrative data.
- Default Sales
- Default Item and Itempackage
It accommodates commonly used formats such as Excel (.xlsx) and CSV (.csv) files. Hence, ensuring flexibility and compatibility with existing systems.
Flexible File Upload
- Upload Excel (.xlsx) or CSV files directly into AutoCount.
- No need for exact template headers if mapping is configured — the system lets you match your Excel headers to the AutoCount fields.
Excel Header Mapping
- Header mapping enables you to align your file’s column names (e.g., “CustomerName”) with AutoCount field names (e.g., “DebtorCode”).
- Mappings can be saved for future use, reducing setup time for recurring imports.
Column Searching
- When a required field (like DebtorCode) is missing in your file, the plugin can look up and fill it from other reference columns (e.g., use Company Name to find the corresponding DebtorCode).
- This intelligent fill‑in feature ensures completeness of imported data without manual editing.
Error Handling & Validation
- Before final import, the plugin checks uploaded files for errors.
- You can export error records, review, and correct them before re‑importing.
Why Use Universal Import Plugin?
Save Time
Automate bulk data entry and eliminate repetitive manual input.
Integration Ready
Ideal for importing data from other systems (POS, ERP, WMS, etc.).
Reduce Errors
Header mapping and lookup features minimize human errors.
Supports Large Data Sets
Efficiently handles large transactional data during system setup or migration.
Download & Prepare Templates
- Go to the plugin or your website to download template Excel files for the data you want to import.
- These templates show correct columns/headers expected by AutoCount.
Fill or Map Excel Headers
- Populate your Excel file with data, matching the template header names where possible.
- If your header names differ, you’ll configure header mapping
Configure Import Settings
Before importing, set configuration options like:
- Sheet Name — match the worksheet name in your Excel file.
- Truncate settings — adjust long text fields (e.g., address) to prevent errors.
Import the File
- In the plugin interface, choose the data type (e.g., Customer, Supplier, Sales Invoice).
- Click Browse and select your prepared file.
- The plugin will check the file.
- Click Import to start.
Review Results & Errors
The system will display:
- Success imports
- Error records (if any)
Export error records to a file, fix issues, and re-import.
Confirm Imported Data
After import, verify the imported records in AutoCount:
- Sales invoices appear correctly
- Customers, stock records, transaction entries match your source data
This confirmation ensures accuracy and completeness.
Quick Reminder: Prepare Your Excel/CSV File
- Ensure your data is complete and in a structured format.
- Save it as .xlsx or .csv.
- If needed, use consistent headers for key fields like codes and names.
Quick Reminder: Install and Open the Plugin
- Go to Tools → Plug‑In Manager in AutoCount and install the Universal Import Plugin.
- Once installed, navigate to Universal Import > Import in the menu.
Quick Reminder: Set Access Rights
- Only users with the correct access rights can run the plugin.
- Go to General Maintenance → Access Right Maintenance, and enable access for your user role.
Use Cases
Large invoice imports
Auto‑upload monthly sales from external systems
Stock data migration
Import inventory units and opening balances
Third-party integration
Bring in data exported from POS, ERP, or PMS systems
System migration
Move legacy data into AutoCount quickly
Multi-format imports
Use CSV or Excel files interchangeably
Conclusion
The AutoCount Universal Import Plugin is a versatile, flexible, and powerful solution to automate and accelerate your data import tasks. Whether you’re migrating systems, importing daily transactions, or syncing with other platforms, this plugin helps you maintain accuracy while saving significant manual effort.
Frequently Asked Questions
What formats does the plugin support?
It supports Excel (.xlsx) and CSV formats, ensuring compatibility with common data exports.
Can I import customer or supplier details?
Yes — the plugin supports master data like Debtor (customers), Creditor (suppliers), and even GL and stock item records.
What if my column headers don’t match AutoCount fields?
You can use header mapping to match your file’s names to AutoCount’s required fields.
What happens if required data is missing?
The plugin can use column searching to infer missing codes based on reference fields in your file.
How do I fix errors during import?
Export the “error records” file from the error screen, correct the problems in your source file, and re‑import.
Interested in Getting AutoCount for your Business?
Contact our sales team today to explore pricing options and get started with the perfect solution for you.