SBFM: Standard Financial Reports and Related Sub Reports

ID: Q153440


The information in this article applies to:
  • Microsoft Excel for Windows 95, versions 7.0, 7.0a
  • Microsoft Small Business Financial Manager for Microsoft Excel 97 1.0

This article describes the four standard financial reports that are generated by the Report Wizard in Microsoft Small Business Financial Manager for Microsoft Excel (SBFM), and the related sub reports that are available for each report. The four standard financial reports that are generated by the Report Wizard are as follows: the Income Statement, the Balance Sheet, the Trial Balance, and the Statement of Change in Stockholders' Equity. These reports in turn have related sub reports.

INCOME STATEMENT

The Income Statement reports the profit (or loss) performance of a business entity for a specific period of time.

One Period & YTD Comparisons

Shows the company's financial performance during a designated period and includes year-to-date results

Rolling 12 Period Trend

Shows the company's financial performance for each of the last 12 months for comparative analysis.

Rolling 12 Period Trend with Projections

Shows the company's financial performance for each of the last 12 months for comparative analysis. Includes additional report columns containing formulas for projections

Rolling 4 Quarter Trend

Shows the company's financial performance for each of the last four quarters for comparative analysis.

Fiscal Year by Period

Shows the company's financial performance for each month of a designated fiscal year.

Fiscal Year by Period with Projections

Shows the company's financial performance for each month of a designated fiscal year. Includes additional report columns containing formulas for projections.

Fiscal Year by Quarter

Shows the company's financial performance for each quarter of a designated fiscal year.

Fiscal Year by Quarter with Projections

Shows the company's financial performance for each quarter of a designated fiscal year. Includes additional report columns containing formulas for projections.

One Period Income Statement with Scenarios

Shows the company's financial performance during a designated period, and includes the projected performance based on any existing What-If scenarios.

BALANCE SHEET

The Balance Sheet provides a snapshot of a company's financial health at a given point in time.

Balance Sheet

Shows the company's financial condition at the end of a designated time period.

Balance Sheet with Prior Year Comparisons

Shows financial condition at the end of a designated time period, and prior year's figures for comparison.

Balance Sheet with Scenarios

Shows financial condition at the end of a designated time period, and/or shows the projected condition based on existing What-If scenarios.

STATEMENT OF CHANGE IN STOCKHOLDERS' EQUITY

The Statement of Change in Stockholders' Equity provides a supporting schedule to the stockholders equity section of the Balance Sheet. During an accounting period, business owners/shareholders may withdraw or add funds to the contributed capital for the business. This schedule reflects the net effect of these transactions between the business owner(s) and the business entity.

One Period Activity

Analyzes changes to shareholders' equity for a specified time period.

Year to Date Activity

Analyzes changes to shareholders' equity for the year to date.

TRIAL BALANCE

The Trial Balance provides a full audit trail of the balance and net change for each account. It lists the titles of each account in the General Ledger, the debit or credit balance of each account, and the totals of the debit and credit balances. It is not a formal accounting statement.

One Period & YTD with Comparisons

Lists balances of all open accounts in the ledger. Includes the beginning balances and the net change for the designated year and period.

Trial Balance with Scenarios

Lists balances of open accounts in the ledger. Includes beginning balances and net change for designated year and period, and projected balances based on scenarios.

Cash Flows

A Cash Flow statement is a financial statement that shows a company's sources and uses of cash during an accounting period.

One Period & YTD with Comparisons

Shows cash provided and used by operating, investing, and financing activities during a designated period. Includes the prior year-to-date amounts for comparison.

Rolling 12 Period Trend

Shows the cash provided and used by operating, investing, and financing activities during a 12-month period.

Rolling 12 Period Trend with Projections

Shows the cash provided and used by operating, investing, and financing activities during a 12-month period. Additional report columns contain formulas for projections.

One Period Cash Flow Statement with Scenarios

Shows the cash provided and used by operating, investing, and financing activities during a designated period. Also shows the projected conditions based on existing What-If scenarios.

YTD Cash Flow Statement with Scenarios

Shows the cash provided and used by operating, investing, and financing activities for the year to date. Also shows the projected conditions based on existing What-If scenarios.

Additional query words: 7.00a

Keywords :
Version : 7.00 7.00a
Platform : WINDOWS
Issue type :


Last Reviewed: September 1, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.