Financial Reports

The following is a list of reports available for MIP, along with a brief description of each report. Click each report to view more detailed information.

Report Name

Description

Reports>Quick Financial Statements>

 

Balance Sheet

This report is a pre-formatted balance sheet that contains balances for the general ledger segment. The general ledger accounts are automatically assigned to the appropriate section based on account type. It includes data beginning with the last open fiscal year begins date through the current System date or the Default Reporting Date, if one was set up (Options>Customize Workstation Settings>Reports tab). If the previous fiscal year has not been closed (Activities>Close Fiscal Year), this report includes data from current and prior years. Currency fields follow the formatting of the organization's functional currency.

Statement of Revenues and Expenditures

This report is a pre-formatted statement of revenues and expenditures that contains balances for your general ledger revenue and expenditure account balances. The general ledger accounts are automatically assigned to the appropriate section based on account type. It includes data beginning with the last open fiscal year begins date through the current System date or the Default Reporting Date, if one was set up (Options>Customize Workstation Settings>Reports tab). If the previous fiscal year has not been closed (Activities>Close Fiscal Year), this report includes data from current and prior years. Currency fields follow the formatting of the organization's functional currency.

Statement of Cash Flows

This report is a pre-formatted statement of cash flows that follows the indirect method. The general ledger accounts are automatically assigned to the appropriate section based on account type. It includes data beginning with the last open fiscal year begins date through the current System date or the Default Reporting Date, if one was set up (Options>Customize Workstation Settings>Reports tab). If the previous fiscal year has not been closed (Activities>Close Fiscal Year), this report includes data from current and prior years. Currency fields follow the formatting of the organization's functional currency.

Reports>Financial Statements>

 

Statement of Financial Position

This report prints the ASC 958 (FAS 117 superseded) balance sheet equivalent. To produce ASC 958 (FAS 117 superseded) compliant reports use the Segment Substitution feature to report the Net Asset section by Restriction (on the Options tab). To use this report the statement of financial position must first be set up using Reports>Financial Statements>Create Statement Formats.

Statement of Activities

This report print the ASC 958 (FAS 117 superseded) statement of revenues, expenditures, and changes in net assets equivalent. To produce ASC 958 (FAS 117 superseded) compliant reports use the Segment Substitution feature to report the Expense section by Functional Category (on the Options tab). It contains: Segment columns, which allow you to produce a comparative report by segment code. Assign a Type of Column (on the Contents tab) to one of the segments. Then, use the Column Totals tab to subtotal any combination of codes and to print those subtotals in a column on the report and the Drill Down feature, which allows you to view report data from the report balances level, down to the individual debits and credits that make up the balance. It is based on the financial statement formatting (Reports>Financial Statements>Create Statement Formats) and report setup criteria that was entered for this report. To use this report certain requirements must be followed for the Financial Statement Format when running the Statement of Activities and any Statement of Revenues and Expenditures type report. (The statement of activities was set up using Reports>Financial Statements>Create Statement Formats.) This will ensure that the Fund Balance/Net Assets section totals correctly.

Balance Sheet

This report displays a standard balance sheet. This report can be used to comply with ASC 958 (FAS 117 superseded)/GASB if the Segment Substitution feature is used to report the Net Asset section by Restriction (on the Options tab). To use this report a balance sheet must first be set up using Reports>Financial Statements>Create Statement Formats. This report contains: Additional items and filters if any user defined fields were created and the Drill Down feature, which allows you to view report data from the report balances level, down to the individual debits and credits that make up the balance. It is based on the financial statement formatting (Reports>Financial Statements>Create Statement Formats) and report setup criteria that was entered for this report.

Combining Balance Sheet

This report displays the balance sheet with a selected segment in columnar format across the page, for example, you can print the balance sheet for the grant segment with Grant amounts listed side by side in columnar format. To use this report, a balance sheet must first be set up using Reports>Financial Statements>Create Statement Formats. This report can be used to comply with ASC 958 (FAS 117 superseded)/GASB if the Segment Substitution feature is used to report the Net Asset section by Restriction (on the Options tab) and contains Segment columns, which allow you to produce a comparative report by segment code. Assign a Type of Column (on the Contents tab) to one of the segments. Then, use the Column Totals tab to subtotal any combination of codes and to print those subtotals in a column on the report.

Statement of Revenues and Expenditures

This report displays the standard statement of revenues and expenditures with budget to actual comparisons. This report is used to view your current budget position with previous years. To use this report certain requirements must be followed for the Financial Statement Format when running the Statement of Activities and any Statement of Revenues and Expenditures type report. (The statement of revenues and expenditures was set up using Reports>Financial Statements>Create Statement Formats.) This will ensure that the Fund Balance/Net Assets section totals correctly. It contains: Additional items and filters if any user defined fields were created; The Drill Down feature, which allows you to view report data from the report balances level, down to the individual debits and credits that make up the balance; The Chart Settings feature, which allows you to generate custom line, bar, column, or pie charts from reports; and The Custom Columns feature, which allows you to create report columns that are not provided by the system. These columns can be set up to override report dates or create custom formulas. Budget variance and percentage columns must be set up using custom columns.

Combining Statement of Revenues and Expenditures

This report displays the statement of revenues and expenditures with a selected segment in columnar format across the page. For example, this report can be used to print the statement of revenues and expenditures for the department segment with Department amounts listed side by side in columnar format. To use this report certain requirements must be followed for the Financial Statement Format when running the Statement of Activities and any Statement of Revenues and Expenditures type report. (The statement of revenues and expenditures was set up using Reports>Financial Statements>Create Statement Formats.) This will ensure that the Fund Balance/Net Assets section totals correctly. This report contains: The Segment columns, which allow you to produce a comparative report by segment code and the Chart Settings feature, which allows you to generate custom line, bar, column, or pie charts from reports.

Statement of Revenues and Expenditures by Period

This report displays the posted balance information for any account combination desired. You can view the statement of revenues and expenditures with periods in columnar format across the page. The reporting periods can be viewed as monthly, quarterly, or yearly as defined on the Options tab. To use this report certain requirements must be followed for the Financial Statement Format when running the Statement of Activities and any Statement of Revenues and Expenditures type report. (The statement of revenues and expenditures was set up using Reports>Financial Statements>Create Statement Formats.) This will ensure that the Fund Balance/Net Assets section totals correctly. This report contains: The Chart Settings feature, which allows you to generate custom line, bar, column, or pie charts from reports and the Custom Columns feature, which allows you to create report columns that are not provided by the system. The columns in this report can be set up to use rolling dates, but cannot use a fixed report date. You can also create a column with custom formulas. Budget variance columns must be set up using custom columns.

Statement of Cash Flows

This report produces a statement of cash flows. The purpose of a statement of cash flows is to provide relevant information about the cash receipts and cash disbursements during a period and whether they stem from operating, investing, or financing activities. To use this report the statement of cash flows must first be set up using Reports>Financial Statements>Create Statement Formats. This format is where you will design the statement format to follow, either the direct or indirect method of reporting cash flows.

Combining Statement of Cash Flows

This report produces a statement of cash flows with the addition of totaling all Segment columns. The Segment columns allow you to produce a comparative report by segment code. Therefore, you need to assign a Type of Column (on the Contents tab) to one of the segments. Then, use the Column Totals tab to subtotal any combination of codes and to print those subtotals in a column on the report.

To use this report the statement of cash flows must first be set up using Reports>Financial Statements>Create Statement Formats.

Reports>GASB Reporting*>

 

GASB Statement of Activities*

This fixed-format report prints posted balance data. This report produces compliant Governmental Accounting Standards Board (GASB) reports. It formats the Statement of Activities so that function/program specific revenues and expenditures print across the page in pre-defined columns, while non-specific revenues are printed in the bottom section of the report. Please note that this report prints in a legal-landscape format. It consists of: Nine pre-defined columns, which cannot be changed: Expenses, Indirect Expenses Allocation, Charges for Services, Operating Grants and Contributions, Capital Grants and Contributions, Governmental Activities, Business-Type Activities, Total, and Component Units and Two row sections: the Functions/Programs section (which includes the Primary Government and Component Units) prints on the left of the statement, and the General Revenues section prints at the bottom of the statement. (After General Revenues, the report totals the Net Assets - Ending amount.) To use this report GASB Statement Formats must first be set up using Reports>GASB Reporting>Create GASB Statement Formats.

Reports>

 

990 Worksheet Part I

Use this report when completing the Form 990 Summary, Part I. The intent of the report is to mimic very closely the actual Part I - Summary section of the Form 990 Return of Organizations Exempt From Income Tax. This is a fixed report which prints in a letter-portrait format with margins set to .25. You cannot customize the columns in the report; the system has already determined them.

990 Worksheet Part VIII

Use this report when completing the Form 990 Statement of Revenue, Part VIII. The intent of the report is to mimic very closely the actual Part VIII - Statement of Revenue section of the Form 990 Return of Organizations Exempt From Income Tax. This is a fixed report which prints in a letter-portrait format with margins set to .25. You cannot customize the columns in the report; the system has already determined them.

990 Worksheet Part IX

Use this report to help when completing the Form 990 Statement of Functional Expenses, Part IX. The intent of the report is to mimic very closely the actual Part IX - Statement of Functional Expenses section of the Form 990 Return of Organizations Exempt From Income Tax. This is a fixed report which prints in a letter-portrait format with margins set to .25. You cannot customize the columns in the report; the system has already determined them.

990 Worksheet Part X

Use this report to help when completing the Form 990 Balance Sheet, Part X. The intent of the report is to mimic very closely the actual Part X - Balance Sheet section of the Form 990 Return of Organizations Exempt From Income Tax. This is a fixed report which prints in a letter-portrait format with margins set to .25. You cannot customize the columns in the report; the system has already determined them.

*This menu selection is only available with the GASB Reporting Module.