Financial dashboard for entrepreneurs: KPIs to track in Quebec

En bref. Un tableau de bord financier d'entrepreneur réunit 8 à 12 indicateurs suivis à date fixe : encaisse disponible, prévision de trésorerie sur 13 semaines, délai de recouvrement des comptes clients, marge brute, marge nette, BAIIA, plus vos soldes de TPS (5 %) et de TVQ (9,975 %) à remettre et vos retenues à la source (DAS). Le modèle le plus robuste se lit en trois niveaux : hebdomadaire pour la trésorerie, mensuel pour la rentabilité, trimestriel pour le fiscal. Votre comptable peut l'installer en trois mois environ, dans un mandat dont la médiane tourne autour de 3 000 $ par année selon le Baromètre Bankeo.

Many Quebec entrepreneurs manage their businesses with two tools: the bank balance and annual financial statements. The former changes too quickly to tell a meaningful story, while the latter arrives months after the decisions it should have informed. Between the two lies the financial dashboard: one page, a dozen indicators, a routine for reading it. This guide offers a concrete model for Quebec: which KPIs to track, how often, with what alert thresholds, and how your accountant can implement it. It expands upon our article on essential financial ratios for SMEs , which details the formulas and benchmark values ​​for each ratio.

Why a dashboard when you already have financial statements?

The two documents do not answer the same question. The financial statements describe what has happened; the dashboard indicates what is happening and what is coming.

• Financial statements look back. The income statement and profit and loss statement describe a completed fiscal year. They are used for tax returns, by the bank, and by partners, often several months after the end of the year.
• The dashboard looks ahead. Cash flow forecast, order book, customer accounts to follow up: it illuminates the next 13 weeks, not the last 12 months.
• Frequency makes all the difference. A slipping gross margin, detected in the second month, can be corrected by adjusting prices or costs. Discovered in the annual accounts, it has already cost a year.
• The decision becomes factual. Hiring, investing in equipment, granting payment terms: each choice is based on a tracked figure, not on an impression.

Level 1: Cash flow, to be monitored weekly

Cash flow is the only item that can halt a profitable business. It is therefore the first level of the dashboard, and the only one that is reviewed weekly.

• Cash available. Your consolidated bank balances, expressed in weeks of fixed charges. Less than 4 weeks of reserves = area for concern.
• 13-week cash flow forecast. Week by week, projected cash inflows minus projected cash outflows (rent, payroll, suppliers, tax rebates). This tool shows a dip before it occurs.
• Customer accounts and Days Sales Outstanding (DSO). The average number of days between invoice and payment. Beyond 45 days, payment reminders become a weekly task, not an end-of-quarter chore.
• Accounts payable. What you owe and when. When properly managed, this item finances your operating cycle; when monitored poorly, it creates surprises.

Level 2: Profitability, to be read every month

Once cash flow is under control, the dashboard answers the second question: is the company actually making money, and on what?

• Gross margin. (Revenue minus cost of sales) divided by revenue. This is the first sign of a problem with pricing, costs, or product mix.
• Net margin. Net profit divided by revenue, to be compared to the benchmark for your sector.
• EBITDA. Earnings before interest, taxes, depreciation, and amortization (EBITDA) measures operating profitability, independent of financing. Two consecutive negative months require action.
• Break-even point. The sales level that covers all your expenses. Knowing it transforms a vague sales objective into a quantifiable monthly target.
• Revenue mix. Share of recurring revenue, revenue per customer, dependence on the three largest customers: the indicators that measure the strength of the turnover.

The exact formulas and benchmark values ​​for these ratios are detailed in our guide to essential financial ratios for SMEs . A prerequisite is up-to-date accounting records, with monthly bank reconciliations. Indicators calculated using outdated records produce attractive graphs but lead to poor decisions; our article on the monthly cost of bookkeeping in France quantifies this prerequisite.

Level 3: Tax and compliance, quarterly;

The third level of the dashboard tracks obligations to the CRA and Revenu Québec. These are amounts known in advance: if properly monitored, they never create an emergency.

• VAT balances to be remitted. Taxes collected less input tax credits (ITCs) and input tax refunds (ITRs), depending on your filing frequency. Our business VAT guide covers registration and filing.
• Instalment payments. For a corporation or self-employed individual, the IRS and Revenu Québec require payments during the year beyond their thresholds. The dashboard displays the next due date and the corresponding provision.
• DAS (Declaration of Annual Salaries) with each payroll. Withholding tax and employer contributions, to be paid according to your payment schedule. A binary indicator: updated or not.
• Filing deadlines: T2 and CO-17 for a incorporated company; T1 and TP1 for a sole trader (filed by June 15, balance due by April 30). Displaying them on the dashboard avoids last-minute scrambles.

The complete model: 10 KPIs, formulas, frequencies and alert thresholds

Here is the dashboard template that an accountant typically sets up for a Quebec SME. The alert thresholds are starting points: your accountant adjusts them to your sector and seasonality.

The data is read by exception: as long as an indicator remains within its range, the next one is moved on. Crossing a threshold triggers a specific action, decided in advance (follow-up with customer accounts, price revision, contact with the accountant). This is what distinguishes a dashboard from a simple report.

How does your accountant set up the dashboard?

The implementation follows a proven sequence, generally over three months.

• Month 1: Ensure data reliability. Maintain up-to-date books in cloud accounting software, create a clean chart of accounts, and perform monthly bank reconciliations. Every reliable dashboard starts here.
• Month 2: Choose the indicators and thresholds. 8 to 12 KPIs adapted to your business model: a service company monitors its billing rate, a retailer its inventory, a manufacturer its production costs. Each KPI has its own alert threshold.
• Month 3: Establish a routine. Monthly report with clear commentary, quarterly meeting for substantive decisions, continuous alerts on cash flow and tax deadlines.

In terms of roles: the accountant produces their own data, transforms it into indicators, and analyzes it. A CPA who is a member of the Quebec CPA Order can go further when the need arises: financial forecasting, financial statements for the bank, tax planning. You can also browse the audited accountants in the Bankeo network to compare profiles and specializations.

Côté budget, ce suivi s'inscrit dans un mandat comptable récurrent. La médiane se situe autour de 3 000 $ par année et la plupart des entreprises paient entre 500 et 6 000 $ selon le secteur et l'étendue du mandat, basé sur les honoraires réels de 1 248 mandats conclus via Bankeo (2024-2026), sur plus de 15 000 demandes reçues. Le Baromètre Bankeo détaille ces fourchettes service par service.

Frequently asked questions

What financial KPIs should an entrepreneur prioritize?

Start with cash flow: available cash, 13-week forecast, and accounts receivable collection period. Next, add three profitability indicators (gross margin, net margin, EBITDA), followed by your tax obligations: VAT balances payable, withholding taxes, and provisional tax payments. A set of 8 to 12 indicators, reviewed at regular intervals, covers the essentials for a Quebec SME.

How often should you check your financial dashboard?

Three schedules work well: weekly for cash flow (cash on hand, forecasts, accounts receivable), monthly for profitability (margins, EBITDA, break-even point), and quarterly for tax (GST/VAT, advance payments), with a meeting at your accountant's office. Regularity matters more than sophistication: a simple spreadsheet reviewed on a fixed date beats a detailed report that no one ever opens.

What is the difference between a dashboard and financial statements?

Financial statements describe a completed fiscal year: they are produced after the year-end and are used for tax returns (T2 and CO-17 for a corporation, T1 and TP1 for a sole trader), for banking purposes, and for business partners. The dashboard, on the other hand, looks ahead: it is updated weekly or monthly and is used for decision-making (hiring, adjusting prices, following up on accounts receivable). The two complement each other; they do not replace one another.

Should VAT be included in the dashboard?

Yes. The 5% GST and 9.975% QST you collect, like payroll deductions, are amounts you hold for the CRA and Revenu Québec. Tracking them as key performance indicators (KPIs), with a provision in a dedicated account, keeps these amounts available at the time of remittance and makes each payment due predictable.

Can my accountant create and maintain my dashboard?

Yes, it's a standard engagement: it first ensures the accuracy of your bookkeeping, then works with you to select 8 to 12 key performance indicators (KPIs) tailored to your business model, sets alert thresholds, and finally produces a monthly report with commentary. A CPA who is a member of the Quebec CPA Order can go further with forecasts or financial statements. Bankeo connects you free of charge with an audited accountant who offers this type of service.

How much does it cost an accountant to set up and monitor a dashboard?

Le suivi des KPI s'inscrit en général dans un mandat comptable récurrent (tenue de livres, rapports, fiscalité). La médiane se situe autour de 3 000 $ par année et la plupart des entreprises paient entre 500 et 6 000 $, basé sur les honoraires réels de 1 248 mandats conclus via Bankeo (2024-2026), sur plus de 15 000 demandes reçues. Le Baromètre Bankeo détaille ces fourchettes par service et par secteur.

Official sources

1. Revenu Québec, VAT and VAT: collection and declarations;
2. Revenu Québec, Employer deductions and contributions;
3. Revenue Agency of the | Canada Salary deductions
4. Revenue Agency of the | Canada Corporate Income Tax
5. Quebec CPA Order