SmartHelping / Accounting / Excel & Google Sheets
Financial Statement Generator
Enter business transactions in a database-style tab and generate an income statement, balance sheet and cash flow statement. Use accrual- or cash-basis accounting, with monthly, quarterly and annual reports for up to 20 years.
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
See the template in action
Follow the transactions into the financial statements.
Watch the walkthrough to see the transaction-entry process and financial reports. Open the screenshots below to preview the spreadsheet.
What the template includes
Turn transaction entries into financial reports.
The spreadsheet connects predefined transaction types to the formulas that populate the financial statements.
Three financial statements
Generate an income statement, balance sheet and cash flow statement from the transactions you enter.
Monthly, quarterly and annual reports
Review financial activity across three reporting intervals.
Up to 20 years
Create reports for a period of up to 20 years.
Accrual and cash basis
Use the supported accounting basis and the corresponding transaction examples for your reporting needs.
Database-style transaction entry
Enter activity in a database-style tab. Each supported transaction type has its own logic for populating the reports.
61 supported transaction types
Work with entries for revenue, inventory, expenses, capital assets, taxes, debt, equity, dividends and securities.
Excel and Google Sheets versions
Start blank or learn from the worked examples.
The package includes three file configurations: a blank starter, an accrual-basis example and a cash-basis example. Excel and Google Sheets versions are provided.
Blank starter file
Use the blank file to enter transactions for your own business.
Accrual-basis examples
Review example situations showing how the supported accrual-basis transaction types affect the financial statements.
Cash-basis examples
Review the cash-basis example file to see how the supported cash-basis entries are recorded.
Access to future updates
With the one-time purchase, return to check for template updates and access them at no extra charge.
Google Sheets version
Find transaction types and review the entries behind a category.
The Google Sheets version includes additional tools for selecting and checking transactions.
Category audit view
Select a category to display its transactions sorted with the most recent date first.
Transaction-name checks
The spreadsheet flags transaction names that do not match the supported list, helping identify spelling errors or unrecognized entries.
Searchable dropdowns
Start typing a transaction type to narrow the available options in the Google Sheets dropdown.
Supported transaction catalog
Explore all 61 transaction types.
Open a category to see the available entries. The included example files show how to use the transaction types and any related entries together.
Revenue and receivables · 12 transaction types
Sales
Record sales collected in the period earned. For cash-basis entries, use this type when customer cash is collected.
Sales on Account
Record an accrual-basis sale invoiced to a customer before payment is received.
Receipts from Sales on Account
Record collections against sales previously entered on account.
Contra Revenue
Reduce revenue for items such as refunds, discounts or returns.
Deferred Revenue
Record cash collected before the related goods or services are provided.
Recognized Revenue
Recognize previously deferred revenue as earned, without a new cash receipt.
Other Income
Record income outside the business’s normal operating activity.
Dividend Receivable
Record a dividend declared by a company whose stock the business holds.
Receipt of Dividends
Record receipt of a dividend previously declared.
Bad Debt Expense
Enter your estimate of uncollectible sales made on account.
Writing Off Doubtful Accounts
Record a receivable that is considered unrecoverable.
Recovery of Doubtful Account
Record a recovery of funds from an account previously written off.
Cost of goods sold and inventory · 7 transaction types
COGS Non Inventory
Record non-inventory cost of goods sold incurred and paid in the same period.
COGS Non Inventory on Account
Record non-inventory cost of goods sold incurred before payment.
Payments for COGS Non Inventory on Account
Record payment of non-inventory COGS previously entered on account.
Inventory Purchases
Record an inventory purchase paid at the time of purchase.
Inventory Purchases on Account
Record inventory purchased on account.
Payments for Inventory on Account
Record payment for inventory previously purchased on account.
COGS Inventory
Record the cost of inventory sold.
Operating expenses and prepayments · 12 transaction types
General and Administrative Expense
Record G&A expenses incurred and paid in the same period.
General and Administrative Expense on Account
Record G&A expenses incurred before payment.
Payments for General and Administrative Expense on Account
Record payment of previously accrued G&A expenses.
Sales and Marketing Expense
Record sales and marketing expenses incurred and paid in the same period.
Sales and Marketing Expense on Account
Record sales and marketing expenses incurred before payment.
Payments for Sales and Marketing Expense on Account
Record payment of previously accrued sales and marketing expenses.
Research and Development Expense
Record R&D expenses incurred and paid in the same period.
Research and Development Expense on Account
Record R&D expenses incurred before payment.
Payments for Research and Development Expense on Account
Record payment of previously accrued R&D expenses.
Prepaid Expense Account
Record an expense paid in advance for use in later periods.
Prepaid Expense
Recognize the portion of a prepaid expense used during the period.
Other Expense
Record expenses outside the business’s regular operating activity.
Capital assets and depreciation · 7 transaction types
Depreciation Expense
Record depreciation expense for capital assets.
Accumulated Depreciation
When an asset is sold, enter its total accumulated depreciation using the disposal example as a guide.
Capital Asset Purchase
Record cash paid for a capital asset purchase.
Capital Asset Purchase on Account
Record a capital asset purchased on account.
Payment of Capital Asset on Account
Record payments for a capital asset previously purchased on account.
Sale of Capital Assets
Enter the asset’s original purchase cost to remove that cost when it is sold, alongside the accumulated-depreciation entry.
Proceeds from Sale of Capital Asset
Record the cash proceeds from an asset sale. Use the example to account for the difference between proceeds and net book value.
Taxes · 6 transaction types
Income Tax Expense
Record income-tax expense in the income statement.
Income Tax Payable
Record income taxes owed.
Deferred Tax Liability
Record the template’s deferred-tax adjustment for differences between tax expense and tax payable.
Payment of Income Tax
Record income-tax payments.
Sales Tax Payable
Record sales tax collected from customers.
Payment of Sales Tax
Record remittance of sales tax collected from customers.
Loans and debt payments · 4 transaction types
Loan Proceeds
Record funds borrowed from a bank or other lender.
Principal Payment on Loan
Record loan principal repayments.
Interest Expense
Record interest expense.
Payment of Interest Expense
Record payment of interest.
Stock issuance and dividends · 4 transaction types
Common Stock
Record common stock issued to investors for cash.
Additional Paid in Capital
Record the amount paid above the stock’s par value.
Declare Dividend
Record a dividend declared for payment later.
Pay Dividend
Record payment of a previously declared dividend.
Short- and long-term securities · 8 transaction types
Stock or Other Security Investment
Record a purchase of stock or other securities.
Unrealized Gain/Loss from Trading Securities
Record a market-value adjustment for trading securities.
Sale of Trading Securities
Record the sale of trading securities using the provided example.
Proceeds from Sale of Trading Securities
Record cash proceeds from the sale of trading securities.
Long-term Stock or Other Security Investment
Record a purchase of long-term stock or other securities.
Unrealized Gain/Loss from Long-term Trading Securities
Record a market-value adjustment for long-term trading securities.
Sale of Long-term Trading Securities
Record the sale of long-term trading securities using the provided example.
Proceeds from Sale of Long-term Trading Securities
Record cash proceeds from the sale of long-term trading securities.
Gains and losses on sale · 1 transaction type
Gain/Loss on Sale
Record gains or losses when selling capital assets or securities, following the relevant example.
How to use the template
Learn from the examples, then enter your business activity.
Review the relevant example file
Choose the accrual-basis or cash-basis example and follow the transaction scenarios before entering your own activity.
Start with the blank file
Use the blank template for your business and the accounting basis you need.
Enter and categorize transactions
Record business activity in the database-style tab using the supported transaction names. Use the examples for transactions that require related entries.
Review the reports
Check the income statement, balance sheet and cash flow statement by month, quarter or year. In Google Sheets, use the category audit view and transaction-name checks to review entries.
Who this template is for
For business reporting and learning transaction flows.
Business owners and bookkeepers
Organize supported business transactions and review the resulting financial statements in a spreadsheet.
Accounting learners and educators
Use the worked examples to follow transaction effects through the reports. Contact Jason about licensing before distributing copies to students.
Also available in these bundles
Need more accounting and financial-analysis tools?
This template is included in the Accounting Trackers and Tools bundle and the Super Smart Bundle.
Accounting Trackers & Tools
Explore spreadsheets for bookkeeping, cash planning, financial reporting, inventory, costing and operational tracking.
View the Accounting bundleSuper Smart Bundle
Access the complete public SmartHelping template collection across industries and financial-analysis needs.
View the Super Smart BundleLicensing, more templates and related reading
Find supporting resources or discuss classroom use.
Browse All Financial Models
Browse the complete SmartHelping template directory. General volume discounts apply automatically in the cart.
Browse all templatesStudent Licensing & Suggestions
Contact Jason about licenses and bulk discounts based on student count. You can also suggest additional account types for consideration.
Contact JasonRolling Revenue Forecast
Explore a separate rolling-revenue forecasting tool for SaaS businesses.
Explore the templateGeneral Rental Business Model
Explore a separate model for a business that earns revenue from renting assets.
Explore the templateDividend Investing
Read the article discussing dividend-investing strategies.
Read the articleStartup Marketing
Read the discussion of approaching marketing as a startup.
Read the articleQuestions before you buy
A few useful details.
Which statements and reporting periods are included?
The template produces an income statement, balance sheet and cash flow statement, with monthly, quarterly and annual reports for up to 20 years.
Does it support both accrual and cash basis?
Yes. The package supports accrual- and cash-basis accounting and includes example files for both.
What files come with the purchase?
The package includes a blank starter file, an accrual-basis example file and a cash-basis example file, with Excel and Google Sheets versions.
Which features are specific to Google Sheets?
The Google Sheets version includes searchable transaction dropdowns, a category audit view sorted by most recent date, and checks for transaction names that do not match the supported list.
Can I access later updates?
Yes. The one-time purchase lets you return to check for updates and access them at no extra charge. Suggestions for additional account types are welcome.
Can I distribute the files to students?
Contact Jason first to discuss student licenses and a possible bulk discount based on the number of students.
Connect business transactions to the reports
Build your financial statements from the activity you record.
Get the Financial Statement Generator for $45, with Excel and Google Sheets versions, a blank starter and worked examples for accrual and cash basis.
