Skip to content
logo Knowledgebase
Page Language

How to import transactions using a .IMP format

Created on  | Last modified on 

Summary

There are 2 ways to import transactions using the .IMP format. Import from within the Sage 50 Accounting program or use an executable file.

Resolution

Notes on importing transactions using .IMP format

  1. You can only import using the Sage 50 Home Currency.
  2. You can import Time Slips, but not Payroll data.
  3. You can Import general journal entries.
  4. Import Timesheets.
  5. Detailed information about an .IMP file format.

Import transactions from Sage 50 Accounting

  1. Select File, Import/Export, Import Transactions.
  2. Choose Import Purchase Invoices, Purchase Quotes, Sales Invoices, Sales Orders or Time Slips.
  3. Select Next, create a Back Up..., then select Next again.
  4. Browse to the location of your.IMP file and select Open.
     NOTE: If your file has a .CSV extension, you’ll need to rename with a .IMP extension. 

Import transactions using an executable 

  1. Find the location where you have installed Sage 50 Accounting and double-click Sage_SA_import.exe. 
     NOTE: The default path is c:\Program Files (x86)\Sage 50 Edition).
  2. Browse to the location of your Sage 50 database file and select Open.
  3. OK and Open.
  4. If at least one of the filenames is missing, a dialog will prompt for the information. The syntax is as follows.
    • sage_sa_import.exe xxx.imp.xxx.sai
       NOTE: The first parameter is the import filename and path, and the second is the Sage 50 Company .SAI file. No quotation marks are necessary.