Import Datato AutoCount Accounting Using Excel
- Quick Start Guide
Download Template
Get the pre-formatted Excel template
Prepare Data
Import
Overview & Benefits
AutoCount Accounting allows you to import various types of data directly from Excel spreadsheets, saving time and reducing manual data entry errors.
Time Saving
Automatically calculate salaries, Reduce data entry time by up to 70% with bulk imports.
Accuracy
Minimize human errors with standardized import templates.
Consistency
Maintain data consistency across your accounting records.
Historical Data
Easily import historical data when migrating to AutoCount.
Before You Begin: Prerequisites
Ensure you have the following ready before starting the import process:
- AutoCount Accounting software installed and running
- Microsoft Excel (2007 or later) installed
- Appropriate user permissions in AutoCount
- Backup of your current AutoCount data
- Data organized according to AutoCount requirements
Step-By-Step Process
Step 1: Prepare Your Excel File
Proper preparation of your Excel file is crucial for a successful import.
Key points to remember:
- Use the provided template or ensure column headers match AutoCount requirements
- Do not alter, delete, or rearrange column headers
- Ensure data formats match (dates, currencies, etc.)
- Remove any empty rows between your data
- Save your file in .xlsx or .xls format
Step 2: Import Data into AutoCount
Follow these steps to import your prepared Excel file into AutoCount Accounting.
AutoCount’s data import interface
- Open AutoCount Accounting and navigate to the appropriate module (e.g., Accounts, Inventory, Contacts)
- Click on File > Import > From Excel
- Select the Excel file you prepared in Step 1
- Map the columns from your Excel file to the corresponding AutoCount fields
- Review the import summary and click Import to proceed
Step 3: Verify Imported Data
After importing, it’s important to verify that all data has been correctly transferred.
Verifying imported data in AutoCount
Verification checklist:
- Check the import log for any errors or warnings
- Verify that the record count matches your Excel file
- Spot-check several records for accuracy
- Test functionality with the newly imported data
- Run reports to ensure data integrity
Complete Video Guide
Watch this comprehensive video tutorial that walks you through the entire import process from start to finish.
Templates & Resources
Download these resources to help with your data import process.
Excel Import Template
Pre-formatted Excel template for easy data import into AutoCount Accounting.