Interest and penalties – federal and provincial
Penalties and interest Excel working papers
Prepare a working paper that shows the penalty step by step, the interest by month and the provisions behind the calculation. Six situations, from a late corporate return to late-filed slips, for the supported combinations.
CAD $149In-house licence
Microsoft 365 desktop Excel for Windows
English .xlsm files and user guide · Delivered by email
Included & licences
One entity and its corporate group · v1.0.2 · 2026 Q4 rates
- In-houseCAD $149
- PracticeQuote
- EnterpriseQuote
Included
- The workbook (.xlsm) and its user guide, in English
- 12 months of technical support by email, and released corrections
- The changelog, the scope and review guide and the accepted licence documents
Desktop Excel for Windows (Microsoft 365) · macros for the example chooser and the questions shown
Outputs are working papers: a person with suitable Canadian tax knowledge reviews the inputs, assumptions and material calculations before reliance. Scope and review guide
Orders online · Contract documents · No sales tax is charged. · Delivered by email
At a glance
- Workbook coverage
- Six situations: corporate tax and late slips
- Authorities
- CRA, Revenu Québec and Alberta where supported
- Software
- Microsoft 365 · Windows · .xlsm
- Edition
- 2026 · v1.0.2
Information flow
Inputs and results require review.
See it work
Results and interest by month →
The workbook
- Question 1 of the Questionnaire names the situation; the workbook then asks only that situation’s questions.
- Under every question a help line says what it means, where to find the answer and what to answer when unsure. Where the research record names the provision an answer rests on, the law sits beside the question.
- Suggested answers, worked out from the other answers, show in blue and can be typed over. Each answer carries a status: OK, Required or Invalid; questions that do not apply are marked “Not needed”.
- The Case summary sidebar on Questionnaire and Results shows interest, penalty, total owed and sign-off status. Results explains the calculation and the provisions applied.
- File › Print on Results produces a one-page Letter memo with the calculation, basis, next steps, signature lines and tickmark note.
- The blank file and the fictional SAMPLE both carry a Load an example chooser: seven worked examples, and “Blank: clear every answer” to return to an empty Questionnaire.
- Macros run the example chooser and hide the questions that do not apply. Without macros the workbook calculates the same figures; those questions stay visible, greyed and marked “Not needed”, and the chooser loads nothing. The macros use no file, network or shell function and set no password.
Situations
Six situations, one workbook
One workbook covers all six situations. Question 1 of the Questionnaire chooses the situation.
| Situation | Scope and limits |
|---|---|
| Situation 1 · Late corporate return | Supported filing penalty, related account interest and a separate proposed filing/payment calculation where supported. Check an assessment reviews a supported filing penalty; proposed dates remain separate from actual history. |
| Situation 2 · Unpaid corporate tax balance | Dated tax charges and payments, daily compound interest and a closing balance after the relevant return has been filed. Does not calculate a new offence penalty. The dated account history must be complete. |
| Situation 3 · Corporate tax instalments | Reviewed required amounts, actual payments, method comparisons, instalment interest and supported instalment penalties. Required amounts and eligibility need independent review. Incomplete periods or method comparisons remain blocked. |
| Situation 4 · Withholding and remittances | Separate paths for failure to withhold and late remittance of an amount actually withheld, for supported obligations. The actual failure, obligation, prior history and reviewed interest-start facts determine the supported path. |
| Situation 5 · Late slips, information returns and elections | Penalties and interest on late-filed information slips (CRA and Revenu Québec) and on a late T5013 partnership information return (ITA s. 162(7.1) and (8.1)), plus corporate electronic filing obligations and late elections, matched to a compatible authority and form. No general residual-form calculator; the T5013 return itself is prepared elsewhere. Election acceptance and chargeable months require reviewed facts. |
| Situation 6 · Interest on an assessed penalty | Documented tax, assessed penalty and payment events, daily interest and comparison with the authority’s notice. The assessed penalty is a manual debit; its legal validity is not independently established. A suppressed difference is not agreement with the notice. |
Penalties & interest estimator
Free online tool
Estimate interest, penalty and total owed for a supported CRA corporate account. Revenu Québec and Alberta calculators are included in the paid Excel template, along with step-by-step provisions and the printable working-paper memo.
Open free estimator ↓Close estimator ↑
- Interest—
- Penalty—
- Total owed—Calculated to —
- Buy the Excel template
Status: —
Inputs stay on this page. Nothing is submitted or saved. Estimate for a CRA account, at the prescribed rates published to 2026 Q4. Revenu Québec and Alberta calculations are in the workbook. Not advice; the workbook documents the calculation and its sources.
Q&A
Workflow and review limits
2026 · v1.0.2 · .xlsm · English workbook · Macros
One Canadian-resident corporation, tax authority, account and taxation year per file. CRA, Revenu Québec or Alberta only for supported combinations; the three authorities are not universally covered.
Date scope begins January 1, 2000. Rate history and penalty-rule history are separate. An unverified historical rule blocks the corresponding calculation. Rate snapshot: 2026 Q4; dates beyond published coverage remain blocked.
Delivery includes a blank workbook and a fictional SAMPLE, both macro-enabled English .xlsm workbooks, edition 1.0.2. Visible tabs: Cover, Guide, Questionnaire, Results, Interest by month, Sources and review, Tickmarks, Disclaimer.
Review the facts, authority, effective dates, historical rules and reconciliation to actual statements. Outputs require review by a person with suitable tax knowledge before reliance. Mechanical validation is not professional approval.
Known limits of edition 1.0.2
These describe how the workbook behaves in edition 1.0.2; none is a promise of a later fix.
- No CRA slip penalty is calculated for a registered charity, including under subsections 162(7.01) and (7.02) of the Income Tax Act.
- The 3% rate for a payroll remittance received on time but not at or through a financial institution (Income Tax Act s.227(9)(a)(i)) applies only to a payer required to pay that way (s.153(1); Income Tax Regulations s.110) and only to a payment received on the due day: one received at least a day early is deemed paid at a financial institution (s.153(1.4)). For other payers the rate is not established.
- T3 slips are not calculated and cannot be chosen; the T3 trust return and the T5013 partnership return are not covered.
- Alberta and 2020: the arrears-interest relief from 2020-03-18 to 2020-09-30 (Alberta TRA Special Notice Vol. 5 No. 59) is applied to Alberta income tax. The notices are silent on instalments due before 2020-03-18 and on interest on penalties, which are not relieved.
- A Revenu Québec account with income tax owing before the 2020 relief reads Blocked; a CRA electronic-filing penalty dated in the 2020 relief period may read Blocked when the account has no Tax row: an input requirement of the workbook, not a tax rule.
- Remittance deadlines: the regular remitter’s (the 15th of the following month, Income Tax Regulations s.108(1)) is derived; quarterly (s.108(1.12)), threshold 1 (s.108(1.1)(a)), threshold 2 (s.108(1.1)(b)) and Revenu Québec deadlines are typed by the preparer.
- Month ends: the month-end rule (a June 30 year end gives August 31) is applied to every authority. It is statutory for Revenu Québec’s balance-due day and the CRA’s practice for the federal filing date; for Alberta’s three-month CCPC date (Alberta Corporate Tax Act s.38(1.1)), the CRA balance-due day and the CO-17 date no authority states it. Deadlines are not moved off weekends or holidays.
- Interest is the annual prescribed rate ÷ 365 for each day, compounded daily, in leap years too. Taxprep matched it to the cent across 29 February 2024, but no CRA or Revenu Québec publication states the leap-year divisor.
- Thinner research: six rule variants are tested only against files; Revenu Québec’s start of interest on a penalty is an administrative position (LAF 28-5/R1); the start of interest on Alberta’s s.37(3) penalty is a reading of the statute.
- Presentation. Long typed answers are cut off. On a late return the penalty section keeps a gap under “Filing deadline”. The sample uses tickmark {a}. With no situation chosen, Results shows labels without figures. Without macros, 44 penalty rows read “Not applicable” and Excel prints smaller type to fit the unused memo rows on one page. After changing the facts, reopen with macros enabled so newly applicable lines can print.
- The full native and macro suites passed on the files sold in Microsoft 365 desktop Excel for Windows. Excel for Mac and LibreOffice are outside the supported setup.
- The rate snapshot is 2026 Q4; dates beyond the published rates are blocked, not estimated.
- CRA and 2020: a T2 otherwise due June to August 2020 is treated as due 2020-09-01, with no late-filing penalty when filed by 2020-09-30 (the CRA’s administrative relief); after that, the tax unpaid at 2020-09-01 and the months counted from it are the CRA’s position, not statute. The CRA’s earlier tier (due 2020-03-19 to 2020-05-31) and a return due 2020-09-01 to 2020-09-29 filed by 2020-09-30 show the ordinary penalty: review them. Only the statutory date is tested, and Revenu Québec’s CO-17 and Alberta’s AT1 2020 filing extensions are not applied.
- Alberta late-filing penalty: the 1% a month is calculated on the monthly base typed on the Questionnaire, not derived. Under the Alberta Corporate Tax Act s.37(1)(b) that base deducts only the royalty tax credit and s.38(8) payments, so it is wider than the 5% part’s; the month count stops at the earlier of filing and an assessment.
Contract
Penalties and interest · In-house licence · CAD $149 · No sales tax is charged.
Français : Conditions d’utilisation · Licence · Politique de soutien · Politique de remboursement · Politique de confidentialité · Télécharger l’ensemble (zip)
English version: Terms of Use · Licence · Support Policy · Refund Policy · Privacy Policy
Sold by Maxime Blais, operating as TaxWorkbooks · [email protected]