Importing a File Formatted for Sage Simply Accounting

Column	Format	Comments
1 - Account number	Number  - 4 digits	Required - unique. Can be more than 4 digits in Sage Simply Accounting Premiumor 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 - State	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 - E-mail 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 - State	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 - E-mail 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 - State	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 - SSN 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
14 - Federal Allowance	Number	Optional
15 - Federal status ***	Text	Required
16 - State Allowance	Number	Optional
17 - State Status ****	Text	Required - on some
18 - Dependents	Number	optional

* Tax table can be:

Alabama, Alaska, Arizona, Arkansas, California, Colorado,Connecticut, Delaware, Dist. of Columbia, Florida, Georgia, Hawaii, Idaho,Illinois, Indiana, Iowa, Kansas, Kentucky, Louisiana, Maine, Maryland,Massachusetts, Michigan, Minnesota, Mississippi, Missouri, Montana, Nebraska,Nevada, New Hampshire, New Jersey, New Mexico, New York, North Carolina,North Dakota, Ohio, Oklahoma, Oregon, Pennsylvania, Rhode Island, SouthCarolina, South Dakota, Tennessee, Texas, Utah, Vermont, Virginia, Washington,West Virginia, Wisconsin, or Wyoming.

** Pay period can be: 1, 2, 12, 24, 26, 52.

*** Federal status can be Single or Married

**** Depending on the state, the State Status can be as follows:

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 (Premium)).

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

 

---

Online Knowledgebase and Chat Assistance

|

Contact Sage Simply Accounting