Data Import & Export
Guides for importing and exporting data in AccuArk including inventory, customers, vendors, employees, accounting records, and more.
Handling Large CSV Files During Import
Tips and best practices for importing large CSV files into AccuArk, including batch processing behavior, performance expectations, Excel pitfalls, file encoding, and strategies for very large datasets.
Resolving Column Mapping Issues
How to fix column mapping problems during import, including unrecognized headers, incorrect auto-mapping, missing required fields, and duplicate mappings.
Troubleshooting Common Import Errors
A comprehensive guide to the most common import errors in AccuArk and how to resolve each one, including lookup failures, numeric formatting issues, missing fields, and file problems.
How Do I Back Up My Data Using Export?
You can export each data type as a CSV file to create a convenient backup of your current data. Store exported files in a safe location for easy recovery.
Can I Import Employees and Set Up Their Access?
Yes, you can import employee records including names, usernames, positions, and salary information. Passwords are not imported for security reasons.
How Do I Import Opening Balances for My Accounts?
Use the Opening Balances import in the Data Exchange Center to set your starting account balances when migrating to AccuArk. Requires Super Admin permission.
What Permissions Are Needed for Data Import and Export?
Each data type in the Data Exchange Center requires its own permission. If a card appears grayed out, you do not have the required access level.
Can I Import Invoices with Multiple Line Items?
Yes. The Outstanding Invoices import uses a multi-row format where multiple CSV rows with the same invoice number are grouped into a single invoice.
How Do I Create a Template for Importing Data?
Use the Export feature in the Data Exchange Center to generate a ready-made CSV template with the correct column headers for any data type.
What Happens If My Import Fails Halfway Through?
AccuArk uses batch processing with database transactions to protect your data during imports. Learn how failures are handled safely.
Can I Import Data from QuickBooks or Other Software?
Yes, you can import data from QuickBooks, Sage, or other business software as long as you can export it to CSV format first.
How Do I Fix Import Errors?
Import errors are shown during the validation step of the wizard. Learn about common errors and how to resolve them.
Can I Update Existing Records Using Import?
Yes, many data types in AccuArk support upsert behavior, which means the import can update existing records instead of creating duplicates.
What File Format Does AccuArk Require for Imports?
AccuArk requires CSV (Comma-Separated Values) files for all data imports. Learn how to create a CSV from Excel or Google Sheets.
Can I Import My Existing Inventory into AccuArk?
Yes, AccuArk supports importing your existing inventory items from a CSV file using a guided five-step wizard.