Please visit our COVID-19 Resources page for useful payroll and reference information. During this time, when many companies are forced to telework, AccountEdge Hosted may be a good option. Host your company file to be accessed remotely from any device, for as long as you need. You can go back to your regular setup when you no longer need remote accessibility. If you’d like to discuss that or any other teleworking solution with a product specialist, please call 800.322.6962. Be safe.

2. Convert Account Data

Export Accounts From Sage

Before you can begin importing your account information into AccountEdge, you have to gather your existing data from your Sage file.

  • 1. Open your Sage file, click on Lists from the top menu bar and then select Chart of Accounts.
  • 2. Select the Settings button to access the available fields.
  • 3. Move the fields you would like to export from Sage to the ‘Select Columns’ area and select Ok.
  • 4. Select Send To > Excel. Select Create a new Microsoft Excel workbook and select Ok. Excel will launch automatically and display your account information.

NOTE: We suggest that you import your Account Number, Account Name, and Opening Balance into AccountEdge. The Account Number field is required to import a new account.

Take a look at how AccountEdge formats the Account Number by account type:

Account Number Account Type
1-XXXX Asset
2-XXXX Liability
3-XXXX Equity
4-XXXX Income
5-XXXX Cost of Goods
6-XXXX Expense
8-XXXX Other Income
9-XXXX Other Expense

For more information about Accounts in AccountEdge, click here.

Look at your list of Account Numbers and make sure that they follow the AccountEdge format for Account Numbers and Account Type. All account numbers must be unique; you can not have duplicate account numbers.

  • 5. Your account numbers will most likely have seven digits in the following format: ‘XXXXX-XX’. You will need to change your account number to only have five digits using only numbers.
  • For accounts that end in ‘XXXXX-00’, you can remove the ‘-00’ to make the account number compatible with AccountEdge.
  • For accounts that end in a specific number and not zeros, like ‘XXXXX-01’, you can edit your account number to be ‘XXX01’.
  • 6. Save the Excel file in a Tab-Delimited Text format.

Import Account Data into AccountEdge

Now that your accounts are formatted, they are ready to be imported into AccountEdge.

  • 1. Open your new AccountEdge Company File, click on File from the top menu bar, select Import Data > Accounts > Account Information.
  • 2. Select the following:
  • Import File Format: Tab-delimited
  • First Record is: Header Record
  • Duplicate Records: Reject Them
  • 3. The Open File window appears, select the tab-delimited file you saved in step 6 from the Export From Sage section. Select Open.
  • 4. Next, you will match your old Sage fields to your new AccountEdge fields. Select the field on the left and then select the field you would like to match it to on the right. Continue this process until all desired fields have been matched appropriately. Select Import.

NOTE: If you rename your account header fields to match the ones exported from the AccountEdge Sample Company File, you can select Automatch to automatically match import fields to the fields listed in the Fields column.

  • 5. After your import is complete, a pop-up window will appear letting you know how many records were imported without errors, skipped, or imported with warnings.
  • If it says all your records imported without errors, you have completed importing your Sage accounts into your AccountEdge company file. Take a look at your new Accounts List in AccountEdge and make sure all the information is correct. Continue to the next section and import your customer information.
  • If the window shows some records were skipped, or that some records were imported with warnings continue to the Import Log section.

Account Import Log

The AccountEdge Import Log will list any errors that occurred during the import process. The errors and warnings that occurred during the import process are listed at the bottom of the log. Those error codes will correspond to the number in front of each record.

Import Accounts

Open the AccountEdge Import Log (found in the same folder that contains your AccountEdge Company File). Open Import Log.txt with a spreadsheet program for easier viewing.

Open the tab-delimited or comma-separated text file you saved to import your data and make the corrections needed based on the error messages. Then, re-import the file.

NOTE: Make sure to select Duplicate Records > Update Existing Record when you re-import the file.

Continue that process until all records have been imported successfully.