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 |