TemplatesAll templates
T5013Switch template

Back to category

In development · target launch November–December 2026

T5013 · TP-600 / RL-15

A partnership working-paper file built around allocations, partner continuity and review.

Enquire about the workbookDownload sample PDF

Workbook · .xlsx · Macro-free

Samples

Extracts from a fictional scenario, with the worksheet layout and figures preserved.

Download sample PDF

PDF · fictional data · 0.2 MB

Info: Partnership information, fictional T5013 workbook example
Partnership informationActual extract from the workbook. Select to enlarge.
SCH 50: Partner register and allocations, fictional T5013 workbook example
Partner register and allocationsActual extract from the workbook. Select to enlarge.
ACB & At-Risk: Partner continuity, fictional T5013 workbook example
Partner continuityActual extract from the workbook. Select to enlarge.
Control Checks: Reconciliation dashboard, fictional T5013 workbook example
Reconciliation dashboardActual extract from the workbook. Select to enlarge.
Open the illustrative calculation table

Illustrative preview

Follow the calculation and its references.

Preview figures are illustrative and do not recalculate. The sample gallery shows the actual workbook.

See actual workbook extracts →

Illustrative preview · T5013Illustrative figuresv2.0 · 2025
Preparer inputCalculationFrom another tabPartner register and allocation of net income
RowItemAmountReference
4Partner register
5Partner 1 — units held and profit share6,400 · 64.00%Sch 50
6Partner 2 — units held and profit share3,600 · 36.00%Sch 50
7Allocation of net income
8Allocated — partner 11,412,800box 116
9Allocated — partner 2794,700box 116
10Total allocated — agrees to the return2,207,500Sch 50
11Partner continuity
12At-risk amount — partner 21,940,000s.96(2.2)
13Adjusted cost base — closing, partner 22,182,100s.53
OKAllocations foot to the partnership's net income. Percentages sum to 100.

Partner register and allocation of net income

Workflow & instructions
  1. 01

    Establish the partnership file

    Read Index and the assumptions, then complete Info and the relevant Manual Input fields. Establish the reporting period and source information before allocating income.

    Index · Info · Manual Input

  2. 02

    Map the financial information

    Enter the trial balance in TB and review GL Map and the GIFI schedules. Use PY Extraction for filed comparative amounts where available.

    TB · GL Map · PY Extraction

  3. 03

    Review the partner allocations

    Complete the SCH 50 register, percentages and any supported special allocations. Review the resulting allocations alongside ACB & At-Risk and Capital Recon.

    SCH 50 · ACB & At-Risk · Capital Recon

  4. 04

    Clear the reconciliation points

    Follow Control Checks to each outstanding item, including allocation and capital reconciliations. Review the Québec schedules and compare the prepared return using Return Tie-Out.

    Control Checks · Return Tie-Out

  5. 05

    Transfer and sign off

    Review the Taxprep Import map before using the first Import sheet through the documented procedure. Reconcile transferred amounts and complete the schedule-level Sign-Off.

    Taxprep Import · Import · Sign-Off

T5013 · From partnership records to partner reporting

Preparation and review are performed by the purchaser’s engagement team. Filing and posting take place in the relevant external software.

T5013 · From partnership records to partner reporting. Detailed steps and review loops follow in the text version.

Open full-size flowchart

Flowchart steps and review loops
  1. 01

    Set up the partnership

    Period, partner information, agreement and source records.

    Prepare → step 2

  2. 02

    Import financial information

    Accounting system → TB: export and paste balances. Tax software → PY Extraction: paste prior-year export, where available.

    Imported balances → step 3

  3. 03

    Map and prepare schedules

    Review GL Map / GIFI; complete tax adjustments and supporting schedules.

    Supported income → step 4

  4. 04

    Establish partner allocations

    SCH 50: supported percentages and special allocations determined by the engagement team.

    Allocations → step 5

  5. 05

    Review partner continuities

    Compare allocations with ACB & At-Risk and Capital Recon.

    Continuities → step 6

  6. 06

    Reconcile federal and Québec reporting

    Review applicable TP-600 / RL-15 work and Control Checks.

    Review results → step 7

  7. 07

    Review points resolved?

    Document conclusions and resolve outstanding differences.

    No: correct preparation → step 3 · Yes → step 8

  8. 08

    Check and export return figures

    Review Taxprep Import and first Import sheet. Save .xlsx → tax-software import; CSV fallback if needed.

    Imported return → step 9

  9. 09

    Reconcile and sign off

    Return Tie-Out: compare transferred and recomputed figures. Complete schedule-level Sign-Off.

    Differences: correct and re-import → step 8 · Reconciled → step 10

  10. 10

    File and retain the support

    Transmit returns / slips in external software. Retain partner continuity information and working papers.

Read the import and export instructions →

Coverage and exclusions

This inventory describes the v2.0 demonstration workbook. The federal and Québec worksheets support one partnership file; the practitioner establishes which schedules and partner treatments apply.

Engagement and controls 7 tabs
  • Cover
  • Index
  • Control Checks
  • Info
  • Manual Input
  • Ref
  • PY Extraction
Financial information and GIFI 6 tabs
  • FIN
  • TB
  • SCH 125
  • SCH 100
  • SCH 141
  • GL Map
Income and supporting schedules 14 tabs
  • SCH 1
  • SCH 8
  • SCH 6
  • SCH 2
  • SCH 12
  • SCH 52
  • SCH 130
  • SCH 5
  • SCH 9
  • SCH 74
  • SCH 75
  • SCH 76
  • SCH 78
  • Comparatives
Partners and allocations 7 tabs
  • SCH 50
  • Slips
  • Slip (form)
  • SUM
  • Received Slips
  • ACB & At-Risk
  • Capital Recon
Québec return and slips 8 tabs
  • TP-600
  • TP600 A
  • TP600 B
  • TP600 D
  • TP600 E
  • TP600 F
  • RL-15 Slips
  • RL-15 SUM
Continuities and completion 10 tabs
  • Carryforwards
  • Roll-Forward
  • Assumptions
  • Foreign Reporting
  • Validation
  • Filing Calendar
  • Taxprep Import
  • Return Tie-Out
  • Import
  • Sign-Off
Federal & Québec notes

TP-600, its supporting schedules and RL-15 worksheets are part of the file. Review Québec-specific adjustments and reconcile the partner-level reporting across both jurisdictions.

Edition & updates

T5013 · v2.0 · 2025

The examples correspond to the demonstration files identified below. Launch is targeted for November–December 2026.

  • TaxWorkbooks_T5013_v2.0_2025_SAMPLE.xlsx

Published changes will be identified with the affected edition. Automated checks do not replace professional review.

Price and licence

A perpetual licence for the purchased edition, within its scope. A new tax year is a separate edition.

Read the full licence · Terms of sale

Practical questions

Does the workbook file the return?

No. The calculations support preparation; filing takes place through the appropriate process and software.

Are the formulas protected?

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

Does the workbook send data to a service?

The .xlsx file runs locally, without macros or external workbook links. No telemetry service is built into the workbook.

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.

Workbook extract