--- title: "Shareholder Loan Tracker (Free XLSX) | EverStone CPA" url: https://www.everstonecpa.com/shareholder-loan-tracker description: "A free spreadsheet tracking money moving between you and your corporation, with a running shareholder loan balance and which way it is leaning. Use it." type: tool updated: 2026-10-02 summary: "A free workbook recording every amount moving between an owner and their corporation in either direction, with a running balance. Knowing the shareholder loan balance during the year, rather than discovering it at year end, is what keeps the account from becoming a problem. No sign-up." faq_count: 4 publisher: EverStone CPA Inc., a Chartered Professional Accountant firm registered with CPA British Columbia and CPA Alberta service_area: British Columbia, Alberta, Ontario and Manitoba language: en-CA contact: info@everstonecpa.com · https://www.everstonecpa.com/book-online --- [Home](https://www.everstonecpa.com/) [Resources](https://www.everstonecpa.com/resources) Shareholder Loan Tracker Free Excel workbook # Shareholder Loan Tracker Updated 2 October 2026 Every dollar in and out between you and your corporation, with a running balance What this covers, at a glance. [Download the XLSX — free](https://www.everstonecpa.com/downloads/everstone-shareholder-loan-tracker.xlsx) Live formulas, one worked example · 8KB · Version 2026-07-26 · No sign-up required **Quick answer:** A free workbook recording every amount moving between an owner and their corporation in either direction, with a running balance. Knowing the [shareholder loan](https://www.everstonecpa.com/blog/shareholder-loans-canada-taking-money-out-of-corporation) balance during the year, rather than discovering it at year end, is what keeps the account from becoming a problem. No sign-up. ## What is in it - Date - Description - Direction - You → company - Company → you - Running balance - Who is owed Ships with one worked example row and live formulas — the totals recalculate as you add rows, and the example is labelled so you know to delete it. The shareholder loan account tracks money between you and your corporation: cash in, cash out, company expenses you paid, and company money spent personally. Its single balance can sit on either side. It matters more than its bookkeeping profile suggests, because the direction of the balance has tax consequences. When the corporation owes you, you can generally draw that money back without further tax. When you owe the corporation, an amount left outstanding too long can be brought into your personal income — and the rules there are unforgiving of loose record-keeping. Most shareholder loan problems are not planning failures. They are record-keeping failures: nobody wrote down which direction each transfer went, and at year-end the account is a single unexplained number. This sheet keeps a running balance and flags the direction, so you can see the position at any point rather than discovering it later. The discipline this sheet is really enforcing is writing down the reason. Direction and amount are usually recoverable from a bank statement; purpose is not, and purpose is what determines the tax treatment. A line that reads “e-transfer $4,000” tells you nothing two years on, while “paid supplier invoice personally, to be reimbursed” answers the question before it is asked. ## Want the updated version each year? Tax figures and filing dates move. Leave your email and we will send the refreshed copy when it changes. That is all we use it for. The download above works either way. ## Before you use it - A positive running balance means the company owes you. A negative one means you owe the company. - An amount you owe the company that stays outstanding too long can be included in your personal income. Watch the direction, not just the size. - Record the reason for every line. “Transfer” is not a reason, and in two years it will not be reconstructible. - Dividends and salary are NOT shareholder loan transactions. Keep them out of this sheet. ## Common questions about shareholder Loan Tracker **What is a shareholder loan account?** One account recording money moving between you and your corporation personally — cash you put in, cash you take out, expenses you paid on the company’s behalf, company money spent on personal things. Its balance can sit on either side. [Ask about your case →](https://www.everstonecpa.com/quick-question) **Why does the direction of the balance matter?** Because it has tax consequences. Money the corporation owes you can generally be drawn back without further tax. Money you owe it, left outstanding too long, can become personal income, and the rules punish loose records. **Should salary and dividends go in this sheet?** No. Dividends and salary are not shareholder loan transactions — keep them out of it. **What makes these accounts go wrong?** Not recording why. “Transfer” is not a reason, and in two years it will not be reconstructible. Most shareholder loan problems are record-keeping failures rather than planning failures. **General information, not tax advice.** This worksheet is a general aid for Canadian business owners. It does not account for your circumstances and does not create a professional relationship. Speak to a CPA before acting — [send an enquiry](https://www.everstonecpa.com/book-online?service=corporate-tax#enquiry-form). [CRA prescribed interest rates — 7% on overdue tax, 3% on shareholder loans](https://www.everstonecpa.com/tax-update/prescribed-interest-rates) [Financial statements for Vancouver companies with outside shareholders](https://www.everstonecpa.com/financial-statements-vancouver) [Shareholders agreements: what they should cover on tax](https://www.everstonecpa.com/blog/shareholders-agreement-tax-implications) [T5018 Subcontractor Tracker A free spreadsheet for construction businesses: log subcontractor payments as you make them and get the running per-subcontractor total the T5018 needs.](https://www.everstonecpa.com/t5018-subcontractor-tracker) [Corporate tax The guide behind this worksheet.](https://www.everstonecpa.com/corporate-tax-hub) [Talk to a CPA](https://www.everstonecpa.com/book-online?service=corporate-tax#enquiry-form) [All guides and resources](https://www.everstonecpa.com/resources) [Send an enquiry](https://www.everstonecpa.com/book-online?service=corporate-tax#enquiry-form) ## Talk to a CPA about this One CPA, start to finish. Fixed fees in writing before work begins, and no obligation. [Get My Fixed Quote](https://www.everstonecpa.com/book-online?service=corporate-tax#enquiry-form) [Ask a Free Question](https://www.everstonecpa.com/quick-question) Email info@everstonecpa.com ★★★★★ “Personal. Professional. Responsive. Plus he saved me a bundle!” Corrin Skalbeck · Google Local Guide --- Source: https://www.everstonecpa.com/shareholder-loan-tracker Prices: https://www.everstonecpa.com/pricing · Contact: info@everstonecpa.com · https://www.everstonecpa.com/book-online