Financial Statement Format List Report

To access this report, go to Reports > Lists > Financial Statement Format List

Use this report to print a list of financial statement formats. This report not only prints each format's account assignments, it also prints the accounts which are not assigned in each format. The Create Statement Formats form was used to prepare the financial statements as one of the following types:

Statement of Financial Position
Statement of Activities
Balance Sheet
Statement of Revenues and Expenditures
Statement of Cash Flows

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
Statement Type	The statement type selected using the Reports>Financial Statements>Create Statement Formats form. Valid statement types are S/P, R/E, C/F, B/S, and S/A (Statement of Financial Position, Statement of Revenues and Expenditures, Statement of Cash Flows, Balance Sheet, and Statement of Activities).
Format Name	The format name, such as Monthly Board Report.
Statement Title	The statement title, such as Balance Sheet.
Section Title 1	The first level section title.
Section Title 2	The second level section title.
Section Title 3	The third level section title.
Account Code	The account code assigned to the section title, such as 11000.
Account Title	The title of the account code, such as Payroll Cash Account.
Print Detail	A designation of Y (Yes) or N (No), depending on if the "Print Detail" box was selected on the Create Statement Formats>Assign Accounts tab.
Segment Substitution	A designation of Y (Yes) or N (No), depending on if the "Segment selected at report time" option was selected on the Assign Accounts tab.
Position on Page	A designation of L (Left) or C (Center), depending on which option was selected on the Create Statement Formats>Create Outline>Section Options form.
Section Account Category	The system prints an A, L, FB, FL, R, E, CF, F, I, O, or C (Asset, Liability, Fund Balance or Net Asset, Liability and Fund Balance, Revenue, Expense, Changes Fund Balance or Net Asset, Financing, Investing, Operating, or Cash), depending on which section account category was selected on the Section Options form and which financial statement type was selected on the Select Format tab. For more information about the account categories for each type of financial statement, see using the Report Builder Setup Tab for adjusting Financial Statement Formats.
Section Type	A designation of A (All Others) or T (Total), depending on which section type was selected on the Section Options form.
Create Totals from Section	The section title selected on the Create Totals tab.
Total Underline	A designation of S (Single), D (Double), or N (None), depending on which option was selected on the Section Options form.

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.