Chart of Accounts Fields

Account number entered in the Maintain Chart of Accounts window. This field is an index and used to link other tables to the Chart of Accounts table. The field is unique and cannot change.

Account ID entered in the Maintain Chart of Accounts window. Account IDs are listed in the company's chart of accounts and general Ledger and referenced in many Sage 50 records and transactions.

The Account ID data field is unique and cannot change.

Account type selected for each account ID entered in the Maintain Chart of Accounts window. This field is used for two main purposes:

• If the account is an “income statement” type, then it is closed during posting.
• If it is the one and only Retained Earnings account, it gets all the closing amounts.

Also, financial statements are usually designed to depend on account types to format properly.

Valid account types include:

0 => Cash

1 => Receivable (Accounts Receivable)

2 => Inventory

3 => Unused1 (Do not select) OR

3 => Receivables Retainage (Sage 50 Quantum Accounting)

4 => OthCurAsset (Other Current Assets)

5 => FixedAsset (Fixed Assets)

6 => AccumDepr (Accumulated Depreciation)

7 => Unused2 (Do not select)

8 => OtherAssets (Other Assets)

9 => Unused4 (Do not select)

10 => Payable (Accounts Payable)

11 => Unused5 (Do not select) OR

11 => Payables Retainage (Sage 50 Quantum Accounting)

12 => OthCurLiability (Other Current Liabilities)

13 => Unused6 (Do not select)

14 => OthLiability (Long Term Liabilities)

15 => Unused7 (Do not select)

16 => EquityNoClose (Equity - Doesn't Close),

17 => Unused8 (Do not select)

18 => RetEarn (Equity - Retained Earnings

19 => EquityClose (Equity - Gets Closed))

20 => Unused9 (Do not select)

21 => Income

22 => Unused10 (Do not select)

23 => CostSales (Cost of Sales)

24 => Expense

Account description entered in the Maintain Chart of Accounts window.

The Inactive check box in the Maintain Chart of Accounts window. Valid choices include:

True = if the account record is inactive.

False = if the account record is active.

GUID (Globally Unique Identifier) used for linking the Chart table.

G/L balance debit total for the selected period. Period 0 = Beginning Balances; Period 1=Last Year, first period; Period 14 = Last Year's balances; Period 15 = This year, period 1;Period 29 = Next Year, Period 1.

About Last Year (Closed) Period Debit/Credit Totals: Closed periods have amounts in them for income statement accounts and the one and only retained earnings account.

G/L credit balance for the selected period. Period 0 = Beginning Balances; Period 1=Last Year, first period; Period 13 = for companies with 13 fiscal periods; Period 14 = Last Year's balances; Period 15 = This year, period 1; Period 29 = Next Year, Period 1.

G/L net total for the selected period. Period 0 = Beginning Balance; Period 1=Last Year, first period; Period 14 = Last Year's balances; Period 15 = This year, period 1; Period 29 = Next Year, Period 1.

Do not select or use this field. It is used by Sage 50 for internal reasons.

The next check number to be used in a print cycle for the selected G/L account ID. This field is usually only relevant for cash accounts.

Tells which types of 1099 payment types are set up to draw cash payments for the current account. These payment types are reflected on the 1099 Settings tab of Vendor Defaults.

Next cash receipt number for this cash account.

Last deposit ticket ID used for a deposit made in the Select for Deposit window.

Number of the next receipt emailed to a customer from the Sage 50 Receipts window.