← 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

ColumnWhat goes in itNeeded?
entityThe corporation's name. Used to pick which one to import.Yes
tax_yearThe corporation's taxation year. The latest year is imported.Yes
grip_start, notesKept for your own record. The comparison does not use them and reports them as ignored.No
aaiiAdjusted 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_limitThe 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_closeGeneral rate income pool at year end. Caps the eligible dividend route.Yes
cda_closeCapital dividend account at year end. Caps the capital dividend route.If you have one
erdtoh_close, nrdtoh_closeEligible and non-eligible refundable dividend tax on hand at year end.Yes (2019 onward)
rdtoh_closeThe single combined pool used before 2019. Only read when the two columns above are empty.Old years only
puc_closePaid-up capital of your shares at year end. Caps the return-of-capital route. New in version 2.If you have PUC
acb_closeYour 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_closeWhat 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.