ArtBuild template ArtBuild template · All of Canada
Unpaid Invoice Tracker
Work out what is owed: invoices, credits, payments, holdback and disputes.
- Version
- 2026.1
- Last updated
- October 24, 2026
Prepared by ArtBuild to help you organise your paperwork. It is general information, not legal advice, and it has not been reviewed by a lawyer. Check the rules for your province or territory before you act.
Part of the Unpaid Construction Payment Recovery Kit: start with its guide, and download the whole kit there.
Download Excel workbook (.xlsx)
What this workbook is for
Work out what is owed: invoices, credits, payments, holdback and disputes.
How to use it
- Download the Excel workbook and save a copy for each project.
- Type only in the amber cells; grey cells calculate automatically. Formulas are protected so they cannot be overwritten by accident.
- On a phone, scroll sideways to see every column; nothing is frozen, so the whole screen is yours.
- Use the example sheet to see how a completed row looks; it uses fictional figures.
Amounts in CAD. Holdback and disputes are portions of the balance, not additional charges. Enter zero explicitly.
Columns in the workbook
- Invoice ID
- Invoice date
- Agreed due date
- Gross incl tax
- Credits
- Paid / allocated
- Retained holdback
- Disputed portion
- Ledger balance
- Excl holdback
- Days past due
- Review flag
- Evidence reference
Sheets
- Invoices
- Fictional examples
Before you act: this document is general information prepared by ArtBuild to help you organise facts and paperwork. It is not legal advice and has not been reviewed by a lawyer for your situation. Rules differ by province and territory and change over time. Check the official source for your project, and for deadlines, liens, court or insolvency steps, speak with a lawyer licensed where the project is located.