Import Transactions into Sage 50 Using .IMP File Format

Today below article is available with all the points and information about how to import transactions into Sage 50 using .IMP file format. Sage 50 is one of the biggest known accounting software for organizations.

While using the software most people think that how can they import the transactions to Sage 50 through a .IMP file.

Steps to Import Transactions into Sage 50 Using .IMP File Format

Follow above all steps to import.

Step 1: Import File from Sage 50

• Click on File >> import/export >> Import Transaction
• Select Import purchase invoice >> Purchase quotes >> sales invoices >> sales order and time slips
• Now click on next >> and create a backup and click on Next
• Locate the location of the .IMP file and click on Open.

Step 2: Import Transactions using an executable

• Go to the location where Sage 50 is installed and invoke the Sage _SA_import.exe
• Get the location of the Sage 50 database file and click on Open
• Click on ok to select yours .IMP import file and click on the “open” option.

May be helpful- Import Invoices into Sage 50

Import Transactions into Sage 50 Using .IMP File Format- Directly you Can’t Import the Payroll but yes you can Import Timeslips

File layouts
The import file consists of two parts, header information, and one or more transactions. Every part of the information is closed in <>.

Header Information

• The Header section is inserted between tags and contains a various number of import file versions and the country code
• Enter 12001 for the version
• Below are the country code based on the status of the version of Sage 50
1. Canada – 1
2. USA -2
3. French – 3
4. Australia – 5
5. International Country Code – 7
• Example –

<Version> 
"12001", "1"
</Version>""

Transactions

The Transactions which are Consultanted are mentioned below :

• Sales invoice
• Purchase invoice
• Sales order
• Adding a customer
• adding a vendor
• Purchase Quote

• Each part of the transaction is inserted in a pair of case-sensitive tags. The details lines with tags are separated by a comma and the string should be in”
• All the information except other than adding customers and vendors, the initial first lines contain the customer or vendor information and the second line consists of transactions options after that a list of one or more details line
• All the lines started with <! are the comments line

How to add customers or vendors

• You can add customers and vendors by using the transaction types
• It will contain one or more customer/vendor line.

Field	Format	Comments
Name	Max 52 Chars	Compulsory
OneTimeFlag	1 = one-time Customer or vendor, 0= Existing customer or vendor	Optional
Contact Name	Max 30 chars	Optional
Street 1	Max 50 chars	Optional
Street 2	Max 50 chars	Optional
City	Max 35 chars	Optional
Province/State	Max 20 chars	Optional
Country	Max 9 chars – unformatted	Optional
Phone 1	Max 30 chars	Optional
Phone 2	Max 25 chars – unformatted	Optional
Fax	Max 25 chars – unformatted	Optional
Email	Max 50 chars	Optional

How to Add Purchase Invoices and Purchase Quotes

• To add purchase voice, you can use the transaction type
• To add a purchase quote, you can use the transaction type
• Inside the tags, there is a single vendor line, one transaction option line, and one more details line

Sales Invoices

• To add a sales invoice you can use the transaction type
• It consists of one customer line, one transaction option line, and one or more detail line

Sales order

• Use the transaction type to add a sale order
• It consists of one customer line, one transaction option line, and one more details line

Timeslips

• use the transaction type to add the timeslips.
• it consists of one employee line, one transaction option line, and one or more details line.

For any help import data into Sage 50 using .IMP file format, get connected with the Sage team. The sage team is available 24*7 to assist you with the latest tools, information, and software. Experts are polite, professional, and quick listeners to solve all your queries in a given time with complete satisfaction. You can also email at [email protected] and soon one of the Sage 50 Consultant experts get back to you with the desired details.