Importing a File Formatted for Sage 50 Accounting

Column	Format	Comments
1 - Account number	Number  - 4 digits	Required - unique. Can be more than 4 digits in Sage 50 Premium Accounting or higher.
2 - Account name	Text - up to 35 characters	Required - unique if not showing account numbers.
3 - Account type *	Text - 1 character	Required
4 - Account class **	Text	Optional
5 - Currency Code	Text - up to 3 characters	Optional
6 - GIFI Code	Number - 4 digits	Optional (Canadian only)

* Account type can be:

H - Group Heading

A - Subgroup Account

G - Group Account

S - Subgroup Total

T - Group Total

** Account class can be asset , liability, equity, revenue or expense:

• Asset account class can be:

Asset, Cash, Bank, Credit Card Receivable, Cash Equivalents, Marketable Securities, Accounts Receivable, Other Receivables, Allowance for Bad Debts, Inventory, Current Asset, Other Current Asset, Long Term Receivables, Other Long Term Investments, Capital Asset, Accum. Amort. & Depreciation, Other Non-Current Asset, Other Asset.

• Liability account class can be:

Liability, Cash, Bank, Credit Card Payable, Accounts Payable, Other Payable, Sales Tax Payable, Payroll Tax Payable, Employee Deductions Payable, Income Tax Payable, Short Term Debt, Current Liability, Other Current Liability, Other Non-Current Liability, Debt, Deferred Revenue, Long Term Debt, Deferred Income Taxes, Long Term Liability, Other Liability.

• Equity account class can be:

Equity, Cash, Bank, Credit Card Payable, Owner/Partner Contributions, Owner/Partner Withdrawals, Share Capital, Dividends, Retained Earnings, Current Earnings.

• Revenue account class can be:

Revenue, Operating Revenue, Non-Operating Revenue, Farming Revenue, Gain, Extraordinary Gain.

• Expense account class can be:

Expense, Cost of Goods Sold, Operating Expense, General & Admin. Expense, Amort./Depreciation Expense, Bad Debt Expense, Employee Benefits, Payroll Expense,Interest Expense, Income Tax Expense, Non-Operating Expense, Loss, Extraordinary Loss.

Column	Format	Comments
1 - Vendor name	Text - up to 52 characters	Required - unique
2 - Contact name	Text - up to 30 characters	Optional
3 - Street 1	Text - up to 50 characters	Optional
4 - Street 2	Text - up to 50 characters	Optional
5 - City	Text - up to 35 characters	Optional
6 - Province	Text - up to 20 characters	Optional
7 - Country	Text - up to 20 characters	Optional
8 - Postal / Zip code	Text - up to 9 characters	Optional
9 - Phone 1	Text - up to 25 characters	Optional
10 - Phone 2	Text - up to 25 characters	Optional
11 - Fax	Text - up to 25 characters	Optional
12 - Email address	Text - up to 50 characters	Optional
13 - Web site	Text - up to 50 characters	Optional
14 - Currency Code *	Text - up to 3 characters	Optional
15 - Tax ID	Text - up to 20 characters	Optional

*  If no currency code, then use the home currency.

Column	Format	Comments
1 - Customer name	Text - up to 52 characters	Required - unique
2 - Contact name	Text - up to 30 characters	Optional
3 - Street 1	Text - up to 50 characters	Optional
4 - Street 2	Text - up to 50 characters	Optional
5 - City	Text - up to 35 characters	Optional
6 - Province	Text - up to 20 characters	Optional
7 - Country	Text - up to 20 characters	Optional
8 - Postal / Zip code	Text - up to 9 characters	Optional
9 - Phone 1	Text - up to 25 characters	Optional
10 - Phone 2	Text - up to 25 characters	Optional
11 - Fax	Text - up to 25 characters	Optional
12 - Email address	Text - up to 50 characters	Optional
13 - Web site	Text - up to 50 characters	Optional
14 - Currency Code*	Text - up to 3 characters	Optional
15 - Customer type **	Text	Optional

*  If no currency code, then use the home currency.

**  Customer type can be Regular or Preferred.

Column	Format	Comments
1 - Employee name	Text - up to 52 characters	Required - unique
2 - Street 1	Text - up to 50 characters	Optional
3 - Street 2	Text - up to 50 characters	Optional
4 - City	Text - up to 35 characters	Optional
5 - Province	Text - up to 20 characters	Optional
6 - Postal / Zip code	Text - up to 9 characters	Optional
7 - Phone 1	Text - up to 25 characters	Optional
8 - Phone 2	Text - up to 25 characters	Optional
9 - SIN number	Text - up to 9 characters	Optional
10 - Date of birth	Date	Required
11 - Date of hire	Date	Optional
12 - Tax table *	Text	Required
13 - Pay period **	Number	Required

Column	Format	Comments
1 - Item number	Text - up to 13 characters	Required - unique, case sensitive
2 - Item name	Text - up to 35 characters	Optional
3 - Item type *	Text	Required
4 - Stocking unit	Text - up to 15 characters	Optional
5 - Regular selling price	Number	Optional
6 - Preferred selling price	Number	Optional
7 - Asset link account	Number - 4 digits	Required - inventory only
8 - Revenue link account	Number - 4 digits	Required -  activity only
9 - COGS / Expense  link account	Number - 4 digits	Required - inventory only
10 - Variance link account	Number - 4 digits	Optional - inventory only

*  Item type can be Inventory, or Service, (or Activity (Sage 50 Premium Accounting)).

Column	Format	Comments
1 - Project name	Text up to 52 characters	Required - unique
2 - Start date	Date	Required