.IMP file format details

Detailed information about the Sage 50 Accounting .IMP file format.

File layout

The import file consists of two parts: the header information and one or more transactions. Each part is in a pair of tags <>.

Header information

1. The header section is between two tags: <version> and </version>, and consists of the version number of the import file version, and the country code
2. For the version, enter 32101 (version 2025)
3. Country Code based on the status of your version of Sage 50 data file:
   • Canada Country Code = 1
   • USA Country Code = 2
   • French Country Code = 3
   • Australia Country Code = 5
   • International Country Code = 7
4. For example:
   <Version>
   "32101", "1"
   </Version>"

Transactions

1. The supported transaction types are as follows:
   • Purchase Invoice
   • Sales Invoice
   • Sales Order
   • Purchase Quote
   • Adding a Vendor
   • Adding a Customer
   • Timeslips
2. Each transaction has a pair of case-insensitive tags. The detail lines within the tags are comma-separated, and strings must be in "".
3. For all transactions other than adding customers and vendors:
   • The first line contains the vendor's or customer's information.
   • The second line contains transaction options followed by a list of one or more detailed lines.
4. All lines beginning with <! are comment lines.

Adding customers or vendors

1. To add customers and vendors, use the <customers> and <vendors> transaction types.
2. This consists of one or more customer/vendor lines.

For example:

<customers>
"Customer A", "0", "Contact", "A Street", "More Street Info", "A City", "A Prov", "V3M7Q3", "A Country", "6045558471", "", "6045559132", "[email protected]"
</customers>

Adding Purchase Invoices and Purchase Quotes

1. To add a purchase invoice, use the <purinvoice> transaction type.
2. To add a purchase quote, use the <purquote> transaction type.
3. Within the tags, there's one vendor line, one transaction option line, and one or more detail lines.

Purchase Invoice/Quote transaction options

Purchase Invoice/Quote detail lines

Sales Invoices

1. To add a sales invoice, use the <salinvoice> transaction type.
2. This consists of one customer line, one transaction option line, and one or more detail lines.

Sales Invoice transaction options

Sales Invoice detail lines

Sales Orders

1. To add a sales order, use the <salorder> transaction type.
2. This consists of one customer line, one transaction option line, and one or more detail lines.

Sales Order transaction options

Sales Order detail lines

Tax information

For each tax authority in the tax code

Timeslips

• To add a Time slip, use the <Timeslip> transaction type
• This consists of one employee line, one transaction option line and one or more detail lines

Employee line

Time Slip transaction options

Time Slip detail lines

Sample import file

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

<customers>
"name", "0", "Contact", "street", "street2", "city", "prov", "postal", "country", "phone", "phone2", "fax", "[email protected]"
"name2", "0", "Contact", "street", "street2", "city", "prov", "postal", "country", "phone", "phone2", "fax", "[email protected]"
</customers>

<vendors>
"name", "0", "Contact", "street", "street2", "city", "prov", "postal", "country", "phone", "phone2", "fax", "[email protected]"
"name2", "0", "Contact", "street", "street2", "city", "prov", "postal", "country", "phone", "phone2", "fax", "[email protected]"
</vendors>

<PurQuote>
< This is the vendor line "name"
"UNIVERSAL CONSTRUCTION"
< This is an option line.
<! "no. of details", "quote no.", "entry date", "ship date", "total amount", "discount rate",
<! "discount days", "net days", "freight amt", "tax information"
"1","203","3-15-2000", "69.98","2.00","30","60","10.00","GST","0","1","7.00","0.70"
<! This is a detail line.
<! "item no.", "quantity", "price", "amt", "tax information"
"C1020","20.0000","2.6000","52.00","GST","0","1","7.00","3.64","PST Charged","0","0","7.00","3.64"
</PurQuote>

<PurInvoice>
"UNIVERSAL CONSTRUCTION","0", "102 - 3701 Hastings Street", "Vancouver","British Columbia","V5C2H6","Canada"
"1", ,"27858","3-15-2001","1120.00","2.00","30","60","0.00"
,"0.0000","0.0000","1000.00","GST","0","1","5.00","50.00","PST","0","0","7.00","70.00"
</PurInvoice>

<SalInvoice>
"UNIVERSAL CONSTRUCTION"  "102-3701 East Hastings St.", "Vancouver","British Columbia","V5C2H6"
"2", "","3-15-2001", "3", "VISA", "67.84","0.00"
"C1020","2.0000","4.7500","9.50","GST","0","1","7.00","0.67","PST","0","0","7.00","0.67"
"H1020","2.0000","25.0000","50.00","GST","0","1","7.00","3.50","PST","0","0","7.00","3.50"
</SalInvoice>

<Timeslip>
“Sifnos, Janice”
“2”,”1242”,”3-15-2001”
“Customer5”,”C1020”,”02:00:00”
“Customer6”,”C1020”,”02:00:00”
</Timeslip>

 

How to import transactions using a .IMP format

How to import .CSV record data

Importing miscellaneous General Journal entries from a text file