Excel-Skills.com

Which financial statements template fits your entity?

All five financial statements templates follow IFRS for SMEs and are built the same way: you map your trial balance to reporting classes, and the template produces the financial statements and notes. Multiple years are kept in one workbook, and you roll forward to the next year by changing a single cell.

What differs is the type of entity, which changes the equity section, some of the statements and the reports that accompany them.

Quick answer: which template should you choose?

Feature comparison

Feature Financial Statements - CompanyFinancial Statements - Sole ProprietorFinancial Statements - TrustFinancial Statements - CCFinancial Statements - Non-Profit
Format based on IFRS for SMEs ✓Yes ✓Yes ✓Yes ✓Yes ✓Yes
Uses your own chart of accounts (trial balance mapping) ✓Yes ✓Yes ✓Yes ✓Yes ✓Yes
Statement of cash flows ✓Yes ✓Yes ✓Yes ✓Yes ✓Yes
Notes to the financial statements ✓Yes ✓Yes ✓Yes ✓Yes ✓Yes
Equity section Share capital Owner's capital and drawings Trust capital and beneficiary loans Members' contributions Retained surplus
Multiple years in one workbook ✓Yes ✓Yes ✓Yes ✓Yes ✓Yes
Roll forward or back from one cell ✓Yes ✓Yes ✓Yes ✓Yes ✓Yes

The templates in detail

Financial Statements - Company Template

Annual financial statements for companies.

Best for:
Accountants and companies preparing IFRS for SMEs annual financial statements from a trial balance
Not suitable for:
Other entity types (separate versions exist for sole proprietors, trusts, CCs and non-profits) or businesses without a trial balance

View the Financial Statements - Company template

Financial Statements - Sole Proprietor Template

Annual financial statements for sole proprietors.

Best for:
Sole proprietors and their accountants preparing IFRS for SMEs annual financial statements from a trial balance
Not suitable for:
Companies, trusts, CCs or non-profits (separate versions exist) or businesses without a trial balance

View the Financial Statements - Sole Proprietor template

Financial Statements - Trust Template

Annual financial statements for trusts.

Best for:
Trustees and accountants preparing IFRS for SMEs trust financial statements with a trustees' report
Not suitable for:
Companies, sole proprietors, CCs or non-profits (separate versions exist) or trusts without a trial balance

View the Financial Statements - Trust template

Financial Statements - CC Template

Annual financial statements for closed corporations.

Best for:
Close corporations and their accountants preparing IFRS for SMEs annual financial statements
Not suitable for:
Companies, sole proprietors, trusts or non-profits (separate versions exist) or CCs without a trial balance

View the Financial Statements - CC template

Financial Statements - Non-Profit Template

Annual financial statements for non-profit organizations.

Best for:
Non-profit organisations and their accountants preparing IFRS for SMEs financial statements with a board members' report
Not suitable for:
Companies, sole proprietors, trusts or CCs (separate versions exist) or organisations without a trial balance

View the Financial Statements - Non-Profit template

Frequently Asked Questions

Which financial statements template do I need?
Choose the template for your type of entity: company, sole proprietor, trust, close corporation (CC) or non-profit organisation. They all work the same way; the differences are in the equity section, some statements and the accompanying reports.
Do I need accounting software to use the financial statements templates?
You need a trial balance. You can export it from any accounting software, or produce it with one of our Excel accounting templates, and then link each account to a reporting class.
Can I prepare financial statements for a new business with no prior year?
Yes. Enter only the current year's trial balance. The comparative year then shows zero values, which you can hide by formatting them as white text before printing.
Can I use one template for several clients or businesses?
Yes. Save a separate copy of the template for each business. Each copy keeps that business's trial balances for multiple years.
Can I add or remove notes?
Yes. Hide the rows of any note you don't need rather than deleting them, and add notes or lines by copying the existing formulas within the same note.