More information

Chart of Accounts List

Access this report using Reports>Lists>Chart of Accounts.

Use this report to print a list of account codes currently set up for each segment, along with any grant information, user defined fields, designation codes, 990 line numbers, check number assignments, and required account assignments associated with the codes. These codes were entered using Maintain>Chart of Accounts Codes.

Additional items, columns, and filters are available if any user defined fields were created by the Administrator using Organization>Set Up User Defined Fields. Only user defined fields with a field type of String, Editable Drop-Down List, Non-Editable Drop-Down List, Date, or Yes/No are available in the Items by Page group box on the Content tab. User defined fields with a field type of Currency follow the formatting of the organization's functional currency.

The functional currency was determined when the organization was created by the Administrator (File>New Organization>Functional Currency panel).

Use this tab to assign a report name and determine whether or not to include it on the actual report. The report name can be printed in the header or the footer of the report.

Use this tab to determine what data to include in the report and to define the report layout.

By selecting Available Items, the data is divided onto separate pages. The report starts a new page for each item, and the item is printed in the page header of the report.
By selecting Available Columns, the data that appears in the body of the report is determined.

Column	Description
Segment Sequence	Designates the order of your segments. The Administrator can change the segment sequence using the Organization>Organization Information>Segments tab.
Segment Name	The name assigned to the segment. The report shows a segment name, such as Fund or GL.
Account Code	The account code, such as 201, 05, or 45001.
Account Title	The actual title assigned to the account code. The report prints the account title, such as Housing or Service Fees.
Account Short Title	Usually the first 15 characters of the Account Title. The report prints an account short title, such as Housing or Svc Fees.
Status	The status of the segment—Active, Inactive, or Discontinued. The report prints A, I, or D.
Account Type	Different types of General Ledger accounts. Valid account types include the following: Cash, Accounts Receivable-Customers, Accounts Receivable, Pledges Receivable, Interfund Receivable, Fixed Assets, Other Assets, Accounts Payable-Vendor, Accounts Payable, Interfund Payable, Other Liabilities, Net Assets/Equity, Revenues, Expenses/Expenditure, Interfund Transfers, and 3rd Party Inventory. The report shows CSH, AR, ARO, PLO, IFR, FAO, OA, AP, APO, IFP, OL, NAE, REV, EXP, IFT, or INV.
Designation Code	The code used to determine how to generate default financial statements formats and totals for the 990 Worksheet and to group for dashboards. Examples of designation codes include: CCE (Cash and Equivalents), STI (Short-term Investments), and any designation codes you create using the Reports>Assign Report Groups form.
Designation Description	The description for the designation code.
Form 990EZ Line Number	If Form 990EZ is selected by the Administrator, for the IRS Tax Form Preference on the Organization>Organization Information form, then this is the IRS Form 990EZ line number associated with an account code, such as 1Pt I (Contributions, gifts, grants, and similar amounts received) and 3 Pt I (Membership dues and assessments). Since the IRS Form 990EZ is a US Government report, this column is blank if the organization's functional currency is not USD (US Dollar).
Form 990 Line Number	If Form 990 is selected by the Administrator, for the IRS Tax Form Preference on the Organization>Organization Information form, then this is the IRS Full Form 990 line number associated with an account code, such as 1aPt VIII (Federated campaigns) and 4 Pt IX (Benefits paid to or for members). Since the IRS Form 990 is a US Government report, this column is blank if the organization's functional currency is not USD (US Dollar).
Last Check Number	The last check number assigned to a General Ledger cash type account.
Currency	The currency type associated with General Ledger cash accounts, such as USD, MXN, or CAD.
Currency Description	The description associated with the currency, such as US Dollar, Mexican Peso, or Canadian Dollar.
Required Account Assignments	Non-balancing or restriction type segments (except for Net Assets/Equity—NAE account types) required for balance sheet accounts, such as Sub Acct 1 and Restriction.
Stage	The stage of the grant—Pre-award, Post-award, or Close-out. This was selected on the Grant Administration tab.
Account Number	The account number assigned to your grant.
Project Director	The project director in your organization.
Award Type	An internal classification, such as Demonstration or Federal.
Notification Date	The date that your organization was informed that you were being awarded this grant.
Grant Period Start Date	The start date for the grant, such as 10/01/2003.
Grant Period End Date	The end date for the grant, such as 09/30/2004.
Extended Date	The date to which the grant has been extended, such as 12/31/2004.
Projected Award Amount	The amount of the grant.
Payment Method	The payment method—Advanced Payment or Reimbursement.
Cost Sharing Percentage	The percentage of the Projected Award Amount that your organization will incur, such as 50%.
Indirect Cost Rate	The percentage of the Projected Award Amount that the grantor will reimburse you, such as 16%.
Next Reporting Date	The next date a report is due to the grantor.
Last Reporting Date	The last date you submitted a report to the grantor.
Audit Required	A designation of Yes or No, depending on if the "Audit Required" box was selected on the Grant Administration tab.
Grant Sponsor	The agency that issued the grant to you, such as Department of Health and Human Services. This was entered on the Grantor Information tab.
Grantor ID	The ID assigned to the grant by the grantor.
Grant Official	The name of the person that administers the business aspects of the grant.
Position	The Grant Official's job title within the agency, such as Health Services Grant Administrator.
Voice Number	The person's voice telephone number.
Fax Number	The agency's fax number.
Address	The agency's street or post office address.
City	The city where the agency is located.
State/Prov.	The state or province where the agency is located.
Postal Code	The zip code or postal code for the designated city and state.
Country	The country where the agency is located.
Email	The email address for the Grant Official.
Program Official	The name of the person with specialized knowledge in the area related to the grant.
Customer ID	The ID assigned to the Customer, such as ABC Health.
Customer Name	The customer's name, such as ABC Home Health Services.
{User Defined Field} – {Segment Name} Code	A segment type user defined field and its data. There is a separate column for each field.

Use this tab to narrow down and more explicitly define the data to include in the report by selecting from the Available Filters.

Use this tab to change the font and page setup for a report.

Use this tab to secure the active report so that other users cannot save their changes to it. The user that selects the check box, and then saves the report, is the only user that can change or save it later. This check box cannot be cleared by any user other than the user that locked the report.