Microsoft KB Archive/153440

= Standard Financial Reports and Related Sub Reports =

Article ID: 153440

Article Last Modified on 8/17/2005

-

APPLIES TO


 * Microsoft Excel 95a
 * Microsoft Small Business Financial Manager for Excel for Windows 95

-



This article was previously published under Q153440



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 SBFM

Keywords: KB153440

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.