Corporate & partnership tax

T5013 · Partnership information return Excel working papers

One partnership. One connected file. A partnership information return file: trial balance to the T5013 schedules, partner allocations and slips, with the Québec TP-600 and RL-15 in the same workbook.

Inside the templateFictional sample
T5013.xlsm

v3.0 · 2025

Summary

SCH 125 — net income per the financial statements900,000
SCH 1 — net income (loss) for income tax purposes650,000
SUM box 009 — number of T5013 slips3

At a glance

Forms
T5013 · 19 CRA forms
Authorities
CRA · Québec TP-600 / RL-15
Software
Excel · Taxprep (CSV)
Edition
v3.0 · 2025

Information flow

Information flow
SourcesPrior-year Taxprep export
SourcesTrial balance & partner information
T5013 workbookT5013 · TP-600 · RL-15Allocations · ACB · Review checks
TaxprepImport & reconcile

Inputs and results require review.

See it work

    Zoom 80%
    Highlights only cells requiring practitioner input (dimming formulas, links, and prior-year fields).
    fx

    Loading preview…

    Browse every worksheet in the template explorer.

    75%
    Try

    Loading preview…

    Visual preview of the fictional sample. No formulas, macros or client data are sent to the browser.

    Inside the guide

    User guide preview

    Selected pages from the English user guide. Open an image to zoom. The complete PDF accompanies the purchased workbook.

    T5013 · English user guide, page 1: Cover
    T5013 · Cover · page 1 of 23
    T5013 · English user guide, page 3: Quick start
    T5013 · Quick start · page 3 of 23
    T5013 · English user guide, page 12: Diagnostic output
    T5013 · Diagnostic output · page 12 of 23

    CRA form inventory linked to this workbook

    The inventory includes calculations, manual-entry schedules and references. A listed form or tab does not mean every line is automated. Read the scope and exclusions for functional coverage.

    Partnerships 19

    • T5013Statement of Partnership Income
    • T5013FINPartnership Financial Return
    • T5013SCH100Balance Sheet Information - Schedule 100
    • T5013SCH125Income Statement Information - Schedule 125
    • T5013SCH141General Index of Financial Information (GIFI) – Additional Information
    • T5013SCH1Net Income (Loss) for Income Tax Purposes - Schedule 1
    • T5013SCH2Charitable Donations, Gifts, and Political Contributions - Schedule 2
    • T5013SCH5Allocation of Salaries and Wages, and Gross Revenue for Multiple Jurisdictions - Schedule 5
    • T5013SCH6Summary of Dispositions of Capital Property - Schedule 6
    • T5013SCH8Capital Cost Allowance (CCA) - Schedule 8
    • T5013SCH9List of Partnerships - Schedule 9
    • T5013SCH130Partnership Interest and Financing Expenses and Interest and Financing Revenues
    • T5013SCH74Clean Hydrogen Investment Tax Credit
    • T5013SCH75Clean Technology Investment Tax Credit
    • T5013SCH76Clean Technology Manufacturing Investment Tax Credit
    • T5013SCH78Carbon Capture, Utilization, and Storage Investment Tax Credit
    • T5013SCH12Resource-Related Deductions - Schedule 12
    • T5013SCH52Summary Information for Partnerships that Allocated Renounced Resource Expenses to their Members - Schedule 52
    • T5013SCH50Partner's Ownership and Account Activity - Schedule 50

    From the Template column of the CRA forms index.

    4% entered · 96% formula-derived & rollover

    Measured from the sample

    What the workbook changes in the file

    T5013 sample · fictional data · v3.0 · 2025. Counted from the sample’s cells by the workbook’s own colour legend.

    Save time

    236fields to Taxprep

    One button writes them to the CSV that Taxprep imports. Of these, 232 carry an amount or an answer and 4 are zeros. Last year’s export, pasted once, loads 98 prior-year fields.

    Type less

    4%of cells entered

    Of the colour-coded cells, only the yellow ones are entered; the other 96% are calculated or carried from last year.

    Better control

    199checks

    All on one tab, each stating what it tests and how serious a failure is. The list is worked until no ERROR remains.

    73 must clear before filing · 105 to review · 21 notes

    Standard and searchable

    52tabs in 5 numbered groups

    Filed under the same numbered groups, with the same Questionnaire, Checks, Import and Notes tabs, as every workbook previewed here. Labels, checks and notes are plain text in the same places, so next year’s preparer, a reviewer or an AI assistant given the file can search them.

    1. 1Prior year
    2. 2Fill in
    3. 3Review
    4. 4Taxprep
    5. 5Reference

    Forms & schedules

    Selected working papers, grouped by preparation area.

    Return & GIFIT5013 FIN · Sch. 100, 125, 141
    Income & assetsSch. 1, 2, 5, 6, 8, 9, 12, 130 (EIFEL)
    Partners & slipsSch. 50 · T5013 slips · ACB & at-risk amounts
    QuébecTP-600 · Schedules A, B, D, E, F · RL-15

    Full inventory & scope →

    What the workbook covers

    The T5013 FIN and 17 schedules — among them Schedules 1, 8, 50, 100, 125, 141 and 130 (EIFEL) — the T5013 slips, and the Québec TP-600 with its schedules A, B, D, E and F and the RL-15 slips.

    • Prior year Export
    • Fill in Questionnaire, TB, SCH 100, SCH 125, SCH 141, SCH 8, SCH 6, SCH 2, SCH 5, SCH 130, SCH 9, Received Slips, SCH 12, SCH 52, SCH 74, SCH 75, SCH 76, SCH 78, SCH 1, Partners, ACB & At-Risk, Slips, TP-600, TP-600 Sch F, TP-600 Sch A, TP-600 Sch B, TP-600 Sch D, TP-600 Sch E, RL-15 Slips, Carryforwards, Foreign Reporting
    • Review Summary, Slip View, SUM, FIN, RL-15 Summary, Capital Recon, Roll-Forward, Comparatives, Prior Year, Taxprep Comparison, Filing Calendar, Checks
    • Taxprep Import Map, Import
    • Reference Rates, Notes, GL Map, .Rules, Disclaimer

    Q&A

    Scope boundaries

    The T5013-1 (SIFT) and Schedules 58 and 63 are not prepared. The T106 and T1134 have their own workbooks; this edition does not prepare the T1135. The T5013 workbook records only whether each applies.

    Edition, price and licence

    In-house

    CAD $249

    One entity and its corporate group.

    Buy

    A perpetual licence for the purchased edition. A new tax year is a separate edition. Full licence

    Does the workbook file the return?

    No. It prepares and documents the figures; filing takes place in the tax software after the CSV import described on the import and export page.

    Does the workbook use macros?

    Yes. The .xlsm buttons resize the repeated row blocks to the counts entered, hide the tabs marked not applicable (and show them again) and write the Import tab to a CSV file beside the workbook. The edition guide identifies the available buttons.

    Is the .xlsm safe to open in a firm environment?

    In this workbook the macros act on the local file only: they resize the repeated row blocks to the counts entered, hide the tabs marked not applicable (and show them again) and write the Import tab to a CSV file beside the workbook. The CSV export uses one system object, WScript.Shell on Windows, only to find the Desktop folder when the CSV cannot be written beside the workbook. The macros make no external connection and the VBA project is left open for inspection. A file received by email or downloaded opens in Protected View until it is unblocked (file Properties, Unblock) or placed in a Trusted Location; with macros disabled, every schedule, check and formula still works and only the buttons are inactive.

    Are the formulas protected?

    Sheets are supplied without active protection. Cell lock flags allow protection to be enabled when needed.

    Which updates are included?

    Minor corrections to the purchased edition are included under the terms of sale. A new tax year is a separate edition.

    Can the workbook be purchased now?

    Yes, online; the price shown is for the in-house licence. Buy opens Stripe’s payment page, the contract documents are at the foot of this page, and the workbook follows by email.

    Contract

    T5013 · In-house licence · CAD $249 · 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]