Please note : We are in the process of improving this tool, so you may see some things not mentioned here! There is more detailed documentation in the works.
AccountingSuite’s Data Import module allows you to import customers, vendors, items, chart of accounts, checks, deposits, journal entries and classes. Here are instructions on importing – if you have questions or need assistance, please contact us – we’ll help you import the data.
To Import Data :
- Export the data from your current application and save it as a CSV (Comma Separated Value) file.
- Open the cvs file using Microsoft Excel or a similar spreadsheet program. Look at the data to see if what is in each column makes sense to you based on the column heading (i.e. for a column named First Name, data in the column looks like first names)
- Download the Import Templates attached below. For each column that you wish to import from your export, make sure there is a matching column in the import template. Please note: Columns in red are required. If your export template does not have a column with the data in the red column, you must add it before importing.
- In AccountingSuite, Navigate to Admin Panel → Data Import.
- Click the item that you’d like to import from the list.
- Check the box if your data has header rows.
- Choose how you’d like to handle duplicate records.
In the pane on the bottom (which represents the field in AccountingSuite) double click each row and a pop-up menu will appear. Select the column from your imported data to match with this field. Repeat for each field that will be imported
- Only the fields marked required are required. If the same value will be used for each imported row, enter the value in the default column and the field mapping may be skipped.
- If you have headers, check the checkbox above the mapping grid.
- Choose how you’d like to handle duplicates.
- After mapping all of the desired fields, click Prepare Data.
- Uncheck any rows to exclude them from import (like the header row).
- Click Check Data.
- The data is checked. Fix any errors.
- Click Import Data.
- You may wish to remove any columns that you don’t wish to import from the exported file during step 2. This makes the mapping process easier.
- You may need to add some columns to the data that you exported.
- Please limit uploads to 1000 records at a time.
Notes on Import Order
The order that you import your data is very important. Many things are dependent on other data being in the software before being imported. Here is a general order of operations when importing data.
- Import / enter list items: Payment methods, payment terms, item categories, price levels, shipping carriers, sales people, units of measure sets, sales tax agencies, sales tax rates.
- Import the Chart of Accounts.
- Import Customers and Vendors
- Import Locations.
- Import Items.
- Import Quotes
- Import Sales Orders
- Import Purchase Orders
- Import Items Receipts
- Import Bills
- Import Bill Payments
- Enter Assembly Builds
- Import Shipments
- Import Sales Invoices
- Import Cash Receipts
- Import Cash Sales
- Import Purchase Returns
- Import Credit Memos
- Import Payments.