Financial statement template

This accounting financial statement template in Excel allows you to take each of the steps from your trial balance to the financial statements - the balance sheet and income statement. 

How do I make a financial statement?

This Financial statement Excel template includes sections for their debits and credits, and pre-built formulas to calculate the total balances for each column.

A Financial Statement is used to show financial results over a period of time. This one is used to show revenue streams, costs and profit/loss during a specific period of time. The total sum of those revenues and expenses will state the net income or net profit. You may calculate it by totaling all of a business's revenue sources and subtracting from that all the business's expenses that are related to revenue. This Financial statement template includes sections for their debits and credits, and pre-built formulas to calculate the total balances for each column.

Revenue

• Sales revenue
• (Less sales returns and allowances)
• Service revenue
• Interest revenue
• Other revenue
• Total Revenues

Expenses

• Advertising
• Bad debt
• Commissions
• Cost of goods sold
• Depreciation
• Employee benefits
• Furniture and equipment
• Insurance
• Interest expense
• Maintenance and repairs
• Office supplies
• Payroll taxes
• Rent
• Research and development
• Salaries and wages
• Software
• Travel
• Utilities
• Web hosting and domains
• Other

Total Expenses

• Net Income Before Taxes
• Income tax expense

Income from Continuing Operations

Below-the-Line Items

• Income from discontinued operations
• Effect of accounting changes
• Extraordinary items

Net Income

The Excel worksheet is print ready and is fully editable so that you can adjust it to your own needs.