← Back to the payout comparison
T2 ledger template
One row per corporation per tax year, in Excel. The payout comparison reads the latest year for the corporation you choose and fills in its pool balances, paid-up capital and shareholder loan. You keep the workbook as your record; this tool never writes to it.
1. Copy the template into Excel
In a new sheet, click cell A1 and paste. Replace the example row with your own. Keep the first line
(schema_version=2) and the header row exactly as they are.
2. Bring your rows back
Select your rows in Excel, header row included, copy, and paste them into the box under Inputs → Import tracker CSV on the comparison page, then choose the corporation. Or save the sheet as CSV and choose the file. Your numbers stay in your browser: nothing is sent anywhere.
The columns
| Column | What goes in it | Needed? |
|---|---|---|
entity | The corporation's name. Used to pick which one to import. | Yes |
tax_year | The corporation's taxation year. The latest year is imported. | Yes |
grip_start, notes | Kept for your own record. The comparison does not use them and reports them as ignored. | No |
aaii | Adjusted aggregate investment income for the year (Schedule 7 of the T2). The latest year's figures of every corporation in the file are added up for the Surplus tab's “Investment income of associated corporations last year”; applied on the Surplus tab, the corporation you pick is left out (it is the professional corporation itself). A negative or unreadable figure is not counted, and the import says so. | For the Surplus tab |
business_limit | The small business limit used on that year's T2. Fills “Small business limit of the paying corporation this year” as a starting point: check this year's figure. | No |
grip_close | General rate income pool at year end. Caps the eligible dividend route. | Yes |
cda_close | Capital dividend account at year end. Caps the capital dividend route. | If you have one |
erdtoh_close, nrdtoh_close | Eligible and non-eligible refundable dividend tax on hand at year end. | Yes (2019 onward) |
rdtoh_close | The single combined pool used before 2019. Only read when the two columns above are empty. | Old years only |
puc_close | Paid-up capital of your shares at year end. Caps the return-of-capital route. New in version 2. | If you have PUC |
acb_close | Your adjusted cost base of those shares. A return of PUC above the ACB is a deemed capital gain. If left empty the tool assumes the ACB equals the PUC and says so. New in version 2. | Recommended with PUC |
shareholder_loan_close | What the corporation owes you, the shareholder, at year end. Caps the tax-free loan repayment. New in version 2. | If you have one |
Version 1 files (without the last three columns) still import. This is a planning aid, not tax or legal advice; check the balances with your accountant.