Chart of Accounts Fields (Import/Export)

How Do I...

The following table lists the fields available for import or export, with a brief description of the field and (when necessary) a character limit for the field. The Import? column identifies which fields are available for import (all are available for export).

Note: Chart of Account fields are exported using CHART.CSV as the default file name.

Field Name

Import?

Description of Field

Limit

Account ID

Y

Alphanumeric - General Ledger Account number

Up to 15 characters

Account Description

Y

Alphanumeric - General Ledger Account description

Up to 30 characters

Account Type

Y

Numeric (Whole) - Account types; valid numbers are: 0=Cash, 1=Accounts Receivable, 2=Inventory, 3=Receivable Retainage, 4=Other Current Assets, 5=Fixed Assets, 6=Accumulated Depreciation, 8=Other Assets, 10=Accounts Payable <more>

11=Payable Retainage, 12=Other Current Liabilities, 14=Long Term Liabilities, 16=Equity-doesn't close, 18=Equity-Retained Earnings, 19=Equity-gets closed, 21=Income, 23=Cost of Sales, 24=Expenses

Inactive

Y

Boolean - Inactive check box; valid choices are [True] or [False], where True=Inactive and False=Active.

Begin Yr Debit-Total

N

Numeric (Real) - Total debit amount per period. This field is used for exporting only.

Begin Yr Credit-Total

N

Numeric (Real) - Total credit amount per period. This field is used for exporting only.

Begin Yr Net-Total

N

Numeric (Real) - The net amount of the credit and debit per period. This field is used for exporting only.

Debit-Period End xx/xx/xx (There can be up to 13 periods, depending on your company setup.)

N

Numeric (Real) - Total debit amount per period. This field is used for exporting only.

Credit-Period End xx/xx/xx (There can be up to 13 periods, depending on your company setup.)

N

Numeric (Real) - Total credit amount per period. This field is used for exporting only.

Net-Period End xx/xx/xx. (There can be up to 13 periods, depending on your company setup.)

N

Numeric (Real) - The net amount of the credit and debit per period. This field is used for exporting only.

Previous Yr Debit-Total

N

Numeric (Real) - Total debit amount per period. This field is used for exporting only.

Previous Yr Credit-Total

N

Numeric (Real) - Total credit amount per period. This field is used for exporting only.

Previous Yr Net-Total

N

Numeric (Real) - The net amount of the credit and debit per period. This field is used for exporting only.

Debit-Period End xx/xx/xx (There can be up to 13 periods, depending on your company setup.)

N

Numeric (Real) - Total debit amount per period. This field is used for exporting only.

Credit-Period End xx/xx/xx (There can be up to 13 periods, depending on your company setup.)

N

Numeric (Real) - Total credit amount per period. This field is used for exporting only.

Net-Period End xx/xx/xx (There can be up to 13 periods, depending on your company setup.)

N

Numeric (Real) - The net amount of the credit and debit per period. This field is used for exporting only.

First Yr Debit-Total

N

Numeric (Real) - Total debit amount per period. This field is used for exporting only.

First Yr Credit-Total

N

Numeric (Real) - Total credit amount per period. This field is used for exporting only.

First Yr Net-Total

N

Numeric (Real) - The net amount of the credit and debit per period. This field is used for exporting only.

Debit-Period End xx/xx/xx (There can be up to 13 periods, depending on your company setup.)

N

Numeric (Real) - Total debit amount per period. This field is used for exporting only.

Credit-Period End xx/xx/xx (There can be up to 13 periods, depending on your company setup.)

N

Numeric (Real) - Total credit amount per period. This field is used for exporting only.

Net-Period End xx/xx/xx (There can be up to 13 periods, depending on your company setup.)

N

Numeric (Real) - The net amount of the credit and debit per period. This field is used for exporting only.

Tax Code

This field is reserved for future use by Sage 50.

Next Ref Number

Y

Holds the next check number if this account is used for writing checks.

Next Email Ref

Y

Holds the reference number of the next receipt to be emailed to a customer from the Receive Money window.

E-Pmt Bank

N

This field is no longer supported.

Up to 30 characters

E-Pmt Account

N

This field is no longer supported.

Up to 19 characters

E-Pmt RTN

N

This field is no longer supported.

Current Balance

N

The current balance of the account (as of the Sage 50 system date)

1099 Settings

Y

Numeric (Whole) - 1099 Settings set up in Vendor Defaults for each G/L account; valid numbers are:

0=INT Box 1 or MISC Box 7

1=1099-MISC, Box 7

2=1099-INT, Box 1

3=None

4=1099-MISC, Box 1

5=1099-MISC, Box 2

6=1099-MISC, Box 3

7=1099-MISC, Box 5

8=1099-MISC, Box 6

9=1099-MISC, Box 8

10=1099-MISC, Box 9

11=1099-MISC, Box 10

12=1099-MISC, Box 13

13=1099-MISC, Box 14