AutoCount import tools / Malaysia

AutoCount Excel vs Universal Import Plugin

Which approach is a better fit for your business? Compare spreadsheet preparation, import methods and column mapping before bringing data into AutoCount.

Malaysian accounts team preparing spreadsheet files for AutoCount data import
The key decision

Choose the import method that suits your source data

Both methods help move prepared data into AutoCount. Your best starting point depends on whether the spreadsheet already follows the required format or needs mapping to AutoCount fields.

01 / STANDARD FORMAT

AutoCount Excel

Useful when your team can prepare rows and columns in the structure required by the available Excel import function.

  • Copy and paste prepared spreadsheet data
  • Follow required column formats and values
  • Confirm import types supported by your version

View Excel import user guide

02 / FLEXIBLE MAPPING

Universal Import Plugin

Useful when source headers need a configurable mapping to supported AutoCount fields or the workflow uses file-based importing.

  • Load Excel files using configured mappings
  • Match source column headers to destination fields
  • Use supported lookup rules where configured

View Universal Import user guide

Side by side

AutoCount Excel vs Universal Import Plugin: differences

Malaysian finance team reviewing data import methods
Illustration: review source data and import requirements before selecting a method
What mattersAutoCount ExcelUniversal Import Plugin
Import methodCopy and paste prepared dataLoad an Excel file using configured import mapping
Column preparationUse required spreadsheet column structureMap source headers to destination fields
Import coverageAvailable master-data and financial import optionsMaster-data and transaction imports, subject to supported types
Lookup requirementsPrepare required codes and values before importingConfigured column searching can help resolve supported references
SetupConfirm template and required fieldsConfigure and test mappings; advanced lookups may require assistance
Good starting pointData already organised into the required formatSource files requiring more flexible mapping
Important: Import mapping does not automatically correct wrong debtor codes, item codes or transaction values. Validate a small sample first, and confirm supported document types against your installed AutoCount version and plugin configuration.
Conceptual illustration of spreadsheet field matching before data import
Getting the mapping right

Prepare your spreadsheet before importing

Match fields: Align source headings with the corresponding AutoCount fields.

Check references: Review customer, item and other master-data identifiers.

Test samples: Import a small test dataset before committing to a larger file.

Review outcomes: Compare imported data against the source and investigate any errors.

Genuine AutoCount references

From Excel columns to AutoCount records

These existing screenshots show spreadsheet preparation and the Universal Import interface. Select an image to view the original details.

Excel spreadsheet headers for AutoCount import including debtor, date and item fields
Excel import source columns — review the required headers and values.
Real AutoCount Universal Import interface with file loading and import status
Universal Import interface — verify the mapping and import status.
Video demonstrations

Watch both import approaches in action

Preserved from the original article: a demonstration of Excel importing and a Universal Import walkthrough.

EXCEL IMPORT / 中文

Import data by Excel

UNIVERSAL IMPORT / 中文

Universal Import Plugin

Frequently asked questions

Questions before you import

Which import tool is better for my company?

Start with your document types and source file format. AutoCount Excel can suit structured data; Universal Import is worth exploring when configured column mapping is important.

Can I reuse my existing Excel file?

Possibly. Check the required fields and values first. Universal Import mapping may connect different source headers, but the data still needs to meet destination requirements.

Will Universal Import correct wrong data automatically?

No. Mapping matches fields; it does not automatically fix incorrect customer codes, dates or amounts. Review samples before importing a full file.

Can AutoCount imports be scheduled automatically?

Scheduling is a separate requirement. Discuss the AutoCount Integrator Plugin and the compatibility of your specific workflow with your consultant.

More consistent data importing

Choose a practical AutoCount import workflow

Review the Excel import guide and Universal Import guide before selecting a process for your company.

Import checklist

Prepare the source file, confirm supported document types, test mappings and reconcile the results.