How to Prepare Financial Statements
Allan Madan, CPA, CA
In this article called, “How to Prepare Financial Statements”, I am going to walk you through, step by step, how to prepare financial statements for your business or corporation.
Get Yourself Organized:
The first step in how to prepare your financial statements for a corporation is to get yourself organized. You can do this in three easy to follow sub-steps.
- Locate and sort all of your expense receipts by month. I have a habit of putting the expense receipts, by month, either in a folder or in an envelope, for easy storage and location afterward.
- Print all bank and credit card statements and sort them by month.
- Attach all receipts to the related credit card or bank statement. This makes it easy to identify how a particular expense was paid and when it was paid.
Prepare Your Expense Sheet:
The next step in preparing your business’s financial statements involves preparing the expenses spreadsheet. In the example I have given, I have used the business of an IT contractor/independent consultant. He has registered his corporation for HST and is collecting sales tax from customers. Notice in the spreadsheet that I have subdivided the expenses into three main categories. As your business is unique, your categories may be different from mine.
My categories are:
- Car
- Operating expenses, and
- Home office
I have further subdivided these categories by expense item. It is best practice to prepare this spreadsheet on a monthly basis as doing so can save you a lot in time, money, and effort. For home office expenses, I have only included the deductible portion of the spreadsheet. This percentage is equal to the size of the office relative to the size of the home. For example, my IT contractor’s den (to learn more about home office deductions, visit our resource on what can independent contractors deduct?) is 10% of the total size of his home. Therefore, he is only able to deduct 10% of home office expenses.
Let us look at a particular item on the spreadsheet, gas (highlighted in blue). The IT contractor spent a total of $2,627 on gas for his car. He paid for it by:
- VISA – $1,748
- Business bank account – $879
- Cash – $0
In the spreadsheet, there are subtotals at the bottom. The total amount spent by the IT contractor was $13,906.
Special Accounts:
The third step is to calculate the balances of the special accounts.
The first account we want to look at is HST payable. The IT contractor has HST payable to the Canada Revenue Agency of $11,301. We calculate HST payable as the total HST collected less the HST paid in the year. HST paid during the year is in respect of the business purchases shown in the expenses spreadsheet.
Income Taxes Payable
Next, we are going to look at the income tax payable. This has a total of $8,600. Income tax payable is equal to the income tax expense $13,600, less tax installments made by the contractor (which totals $5,000). You can either obtain your income tax expense from your accountant or calculate this amount using corporate tax return preparation software. For more information on corporate tax return preparation, please visit our resource Corporate Tax Return- Canada,
Accounts Receivable
Accounts Receivable is the next special account. Accounts receivable represents the total invoices issued during the year, less cash collected. The corporation has accounts receivable of $10,000.
Accounts Payable
Next, we have accounts payable. The corporation has unpaid invoices representing $3,256 dating back to 2012. This is the amount owing to vendors or suppliers.
Shareholder Drawings
The last special account is shareholder drawings (aka dividends paid). The IT contractor withdrew $73,796 from the corporation’s business checking account, but only contributed $4,000. Therefore, the net drawings or dividends paid during are $69,796. The net drawings are taxable to him.
Calculate Tax Depreciation:
The fourth step in business financial statement preparation involves calculating depreciation. For tax purposes, the CRA calls depreciation “capital cost allowance”. This represents the decline in the value of assets during the year. My client has three tangible assets, which I have shown on his spreadsheet under “expenses”:
- Desk – 20% depreciation rate
- Computer – 55% depreciation rate
- Software – 100% depreciation rate
You can obtain the depreciation rate for various asset types from the CRA website. In the year that you acquire them, you can only claim half the purchase price of the asset for depreciation. Here, the desk depreciation (or capital cost allowance) is only $70. We calculate this by multiplying the rate of 20% into #350. The consultant can claim a total of $352 for capital cost allowance on these three assets.
Income Statement:
The fifth step in corporation financial statement preparation is preparing the income statement. This represents the amount of profit earned during the year. In this case, we get a total of $73,541. To calculate profits, we take sales and subtract expenses and income taxes. If you don’t know what an income statement is, please visit Understanding The Income Statement.
Revenues
Revenues are $100,000, and they represent invoices issued during the year. Note that these do not necessarily represent cash collected, which the company can acquire later.
Depreciation Expense
I have linked the depreciation expense to the depreciation tab, and have shown it earlier by way of a formula.
Operating & Other Expenses
I have linked other expenses to the earlier spreadsheet. Observe that none of these includes HST, and that they do not include the tangible asset purchases.
Balance Sheet:
The sixth step in business financial statement preparation is setting up the balance sheet. This is arguably the most difficult statement to prepare, and it consists of three separate areas. These are assets, liabilities, and equity. If you are unfamiliar with balance sheets, please visit this resource on Balance Sheets.
Assets
The assets section (which totals $26,902) is equivalent to the sums of liabilities and equity added together. If you add up the total values for liabilities and equity and they are not equal to the total assets, you have made a miscalculation.
- We take Cash from the year-end bank statement.
- We link accounts receivable to the special accounts tab.
- We link physical (capital) assets to the depreciation tab.
- Accumulated amortization represents the depreciation taken since inception. In this case, the accumulated amortization is the same as the depreciation expense for the year. This is because it is the first year of the company’s operation.
Liabilities
We also get the liabilities from the special accounts tab.
Equity
Equity is a formula that represents the cash and assets retained in the business. It is equal to net income less the dividends. To arrive at this number for our example, we take $73, 541 (net income, taken from the income statement) and subtract $69,796 (dividends paid, taken from the special accounts tab). In doing this, we arrive at an equity amount of $3,745 for this company.
Disclaimer
The information provided on this page is intended to provide general information. The information does not take into account your personal situation and is not intended to be used without consultation from accounting and financial professionals. Allan Madan and Madan Chartered Accountant will not be held liable for any problems that arise from the usage of the information provided on this page.
very good article
Thank you
– Allan
Hi Allan
Where do I download the Download the Spreadsheet for Financial Statement Preparation?
It’s back up on the blog. Sorry for the inconvenience caused.
Allan Madan, CPA, CA
Tel: 905-268-0150
Is there a link you can provide me with that would explain some of these terms in detail? I understand most of them but would require more detail on what exactly would be considered an asset and what would be considered an operating expense.
hey allan i cant find the the link to download the spreadsheet!
Hey Allan,
I cant find the link to download the spreadsheet?
Thank you Allan for this timely video and example – GIFI.
Hi Allan,
I can not find the link to download the spreadsheet ?
Thank you,
Tony
Hi Tony,
In the article there is two hyperlinked text “How to prepare financial statements” (first paragraph), and there is another hyperlinked text “expenses spreadsheet”. You can click on either link and it will download the spreadsheet.
How we got HST-paid = 1699?
Expenses = 13,906
13,906 * 0.13 = 1808
or I miss something ?
HI Allan,
Thanks for the blog. It’s very helpful. I have one question. Can I hire one of the shareholders as a contractor to build our website? Can I treat the contract amount as our expense? As the corp has no payroll for now.
Thanks.
Hi Mike,
You can do this so long as the individual shareholder is acting in the capacity of an independent contractor and not an employee. An independent contractor normally has more than one client, pays for his own expenses, makes his own decisions independently and provides his own tools and equipment.
Hi – I have a balance sheet question. When you start a new quickbooks pro file for an existing company, you have to enter all the opening balances. Unfortunately quickbooks dumps a lot of items into the “opening balance equity” account.
1. Quickbooks instructions say to do a journal entry to transfer the balance of that account to “owner’s equity”. Does that make sense?
2. I figured before I create a new account and do that, I should ensure I know which GIFI code will be attached to it for the income tax return. I looked at the list and maybe CRA lists “owner equity” by a different name?
Thanks so much for your blog and videos…I have learned so much from your site.
Hi Clair, my responses are as follows:
1. Yes, you have to make an adjusting journal entry to re-allocate the items in the opening equity account to the appropriate accounts.
2. Use GIFI code 3541 for owners equity.
much appreciated. The article has a clarity in it and very easily understandable
Hello, i am filing the return for my second year. During the first year of my statement of income, my accountant has only considered Revenue earned as total amount earned during year minus the total expenses for the Net income. It doesn’t have the tax payable amount shown on the income statement. This amount was considered as closing balance for last year. As i paid the taxes last year after closing my account, so what should be the opening balance for this year, should it be closing balance of last year or closing balance of last year minus taxes paid for last year
Hi Nitish, it appears that your accountant did not accrue income tax expense on the financial statements in the company’s first year of operations. The correct approach is to record an income tax liability on the Balance Sheet and an income tax expense on the Income Statement.
You can either amend last year’s financial statements and corporate tax return to correct the error, or leave the error as is and make sure that you follow the current approach from now on. I prefer the second approach. As such, in the current year (i.e. year 2), make sure that the income tax liability on the balance sheet is equal to the current income tax expense less tax installments paid.
Is the near future of the accounting profession going to produce work mainly through artificial intelligence? Is an acct degree still worth it? What other business degrees are worth achieving today? Is an undergraduate degree sufficiant? What software is necessary to master for todays accountant/Bk?
Hi Rocco, technology has made accounting easier, and will continue to automate functions that are performed by humans now. However, where complex tax advice and tax planning is concerned, I strongly believe personal, professional advice is required.
This video and others has helped me prepare my tax. I understand how the input of taxes owing for the current year on the balance sheet is required as it reflects the current years balance. Why is it that you do not need to show the payment of the previous years tax anywhere. Is this because it was already shown on last years balance sheet so that the income and balance all work out ?
Thanks
Hi Joe,
The payment of the previous year’s tax balance should be posted to the tax lability account on the balance sheet. The payment will reduce the balance owing / liability.