Chart of Accounts List Report

To access this report, go to Reports > Lists > Chart of Accounts List

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 Maintenance > Chart of Accounts.

Tip: If you're not familiar with the MIP Cloud Report Builder interface, see Report Builder for an introduction.

You can choose to use the report as-is by selecting Export or View, or make edits to the report by selecting Edit.

If you choose to make edits to the report, the Report Builder page will display. From this page, use the Setup tab to choose the columns you'd like to appear on the report. You can rename the columns under the Column Heading.

The following columns are available to include in the report:

Column	Description
Segment Sequence	Designates the order of your segments.
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 Report Builder Setup Tab.
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, 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 the Filter tab to narrow down and define the data using the available filters.

Use the Options tab to Summarize Amounts on the report, implement security features, and more.

Select "Summarize Amounts" to add amounts together and display one line item with the total amount. All document information must be identical for the system to add items together.

Select "Do Not Allow Changes to this Report" to secure the report so that other users cannot save their changes to it. This option can only be undone by the user that locked the report.
Select "Year End Adjustments" to include year end adjustments on the report. This entry type was designated during transaction entry.
Select "Open Entries in Detail" to include opening balances (system or user opening entries) in detail.
Select "Replace total debits and credits with Balance" to show the net amount for each segment where totals have been requested. Otherwise, the report displays the total debits and total credits for each segment.
Select "Suppress Lines with All Zeros" so that documents with zero amounts do not print. This eliminates records having zero in all amount columns. If it is not selected, every line prints, even if it has a zero value.

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