Financial dashboard for entrepreneurs: Key performance indicators to track in Quebec

At a Glance. An entrepreneur’s financial dashboard includes 8 to 12 metrics tracked on a fixed schedule: available cash, 13-week cash flow forecast, accounts receivable collection period, gross margin, net margin, EBITDA, plus your GST (5%) and QST (9.975%) balances due and your source deductions (DAS). The most robust model is organized into three levels: weekly for cash flow, monthly for profitability, and quarterly for tax purposes. Your accountant can set it up in about three months, as part of a retainer whose median cost is around $3,000 per year, according to the Bankeo Fee Barometer.

Many Quebec entrepreneurs manage their businesses using two tools: their bank account balance and annual financial statements. The former changes too quickly to provide any meaningful insight, while the latter arrives months after the decisions it was meant to inform. In between, there’s the financial dashboard: one page, about ten metrics, a routine for reviewing it. This guide offers a practical template for Quebec: which KPIs to track, how often, with what alert thresholds, and how your accountant can set it up. It builds on our article about the Essential Financial Ratios for an SME, which details the formulas and benchmark values for each ratio.

Why use a dashboard when you already have financial statements?

These two documents don’t answer the same question. Financial statements tell you what happened; the dashboard tells you what’s happening now and what’s coming up.

• Financial statements look back. The balance sheet and income statement provide a snapshot of a completed fiscal year. They are used for tax returns, banking purposes, and reporting to partners, often several months after the end of the fiscal year.
• The dashboard looks ahead. Cash flow forecasts, order backlog, accounts receivable to be collected: it provides insight into the next 13 weeks, not the past 12 months.
• Frequency Makes All the Difference. A declining gross margin, detected in the second month, can be corrected by adjusting prices or costs. If discovered in the annual financial statements, it has already cost a year’s worth of business.
• The decision is based on facts. Hiring, investing in equipment, extending payment terms: every decision is based on a tracked metric, not on a hunch.

Level 1: Cash flow, monitor weekly

Cash flow is the only factor that can bring a profitable business to a halt. That’s why it’s the top section of the dashboard, and the only one you should review every week.

• Available Cash. Your consolidated bank balances, expressed in weeks of fixed expenses. Less than 4 weeks of reserves = caution zone.
• 13-week cash flow forecast. Week by week: projected cash inflows minus projected cash outflows (rent, payroll, suppliers, tax refunds). This tool helps you spot a cash flow shortfall before it happens.
• Accounts Receivable and Days Sales Outstanding (DSO). The average number of days between invoicing and payment. If it takes more than 45 days, sending reminders becomes a weekly task rather than a chore at the end of the quarter.
• Accounts Payable. What you owe and when. When managed effectively, this expense funds your operating cycle; when overlooked, it leads to surprises.

Level 2: Profitability, read this every month

Once cash flow is under control, the dashboard answers the second question: Is the business actually making money, and from what?

• Gross Margin. (Revenue minus cost of goods sold) divided by revenue. This is the first sign of a problem with pricing, costs, or product mix.
• Net Margin. Net income divided by revenue, compared to your industry benchmark.
• EBITDA. Earnings before interest, taxes, and depreciation (EBITDA) measures operating profitability, independent of financing. Two consecutive months of negative EBITDA call for action.
• Break-even point. The sales level that covers all your expenses. Knowing this figure transforms a vague sales goal into a quantified monthly target.
• Revenue Mix. Percentage of recurring revenue, revenue per customer, reliance on the three largest customers: the metrics that measure the strength of revenue.

The exact formulas and benchmark values for these ratios are detailed in our guide to Essential Financial Ratios for an SME. A prerequisite: up-to-date bookkeeping, with monthly bank reconciliations. Metrics calculated based on outdated records result in pretty graphs and poor decisions; our article on the Monthly Cost of Bookkeeping in Quebec Quantify this requirement.

Level 3: Tax and compliance, quarterly

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

• GST/QST balances due. Taxes collected minus input tax credits (ITC) and input tax refunds (ITR), depending on your filing frequency. Our GST/QST Guide for Businesses in Quebec covers registration and reporting.
• Tax instalments. For a corporation or self-employed individual, the CRA and Revenu Québec require payments throughout the year if income exceeds their thresholds. The dashboard displays the next due date and the corresponding estimated payment.
• Source deductions with every paycheck. Source deductions and employer contributions, due according to your payment schedule. A binary indicator: up to date or not.
• Tax Filing Deadlines. T2 and CO-17 for a corporation; T1 and TP1 for a self-employed individual (filed by June 15, balance due by April 30). Adding them to your dashboard helps you avoid last-minute rushes.

The complete template: 10 KPIs, formulas, reporting frequencies, and alert thresholds

Here is the dashboard template that an accountant typically sets up for a Quebec-based SME. The alert thresholds are starting points: your accountant will adjust them based on your industry and seasonal trends.

The dashboard is monitored on an exception basis: as long as an indicator remains within its target range, you move on to the next one. Reaching a threshold triggers a specific, predefined action (following up on accounts receivable, adjusting a price, contacting the accountant). This is what distinguishes a dashboard from a simple report.

How your accountant sets up the dashboard

Implementation follows a proven process, typically spanning three months.

• Month 1: Ensuring data reliability. Up-to-date bookkeeping in cloud-based accounting software, a well-organized chart of accounts, and monthly bank reconciliation. Any reliable dashboard starts there.
• Month 2: Choose Metrics and Thresholds. 8 to 12 KPIs tailored to your business model: a service company monitors its billing rate, a retail business monitors its inventory, and a manufacturer monitors its production costs. Each KPI has its own alert threshold.
• Month 3: Establish a Routine. Monthly reports explained in plain language, quarterly meetings for key decisions, and real-time alerts on cash flow and tax deadlines.

Role-wise: The bookkeeper produces raw data, and the accountant transforms it into metrics and provides analysis. A CPA who is a member of the Ordre des CPA du Québec can go a step further when the need arises: financial forecasts, financial statements for the bank, and tax planning. You can also browse the Vetted accountants in the Bankeo network to compare profiles and areas of expertise.

When it comes to budgeting, this monitoring is part of an ongoing accounting engagement. The median cost is around $3,000 per year, and most businesses pay between $500 and $6,000 depending on the industry and the scope of the engagement, based on actual fees from 1,248 engagements secured through Bankeo (2024-2026), out of more than 15,000 requests received. The Bankeo Fee Barometer provides a breakdown of these ranges by department.

Frequently asked questions

Which financial KPIs should an entrepreneur prioritize?

Start with cash flow: available cash, a 13-week forecast, and accounts receivable collection period. Next, add three profitability metrics (gross margin, net margin, EBITDA), followed by your tax obligations: GST and QST balances due, source deductions, and tax instalments. A set of 8 to 12 metrics, reviewed at regular intervals, covers the essentials for a Quebec SME.

How often should you check your financial dashboard?

Three reporting cycles work well: weekly for cash flow (cash on hand, forecasts, accounts receivable), monthly for profitability (margins, EBITDA, break-even point), and quarterly for tax purposes (GST/QST, tax instalments), along with a meeting with your accountant. Consistency matters more than sophistication: a simple dashboard reviewed on a set schedule is better than a detailed report that no one ever opens.

What’s the difference between a dashboard and financial statements?

Financial statements summarize a completed fiscal year: they are prepared after the end of the year and are used for tax returns (T2 and CO-17 for a corporation, T1 and TP1 for a self-employed individual), for the bank, and for shareholders. The dashboard, on the other hand, looks ahead: it’s updated weekly or monthly and is used to make decisions (such as hiring, adjusting prices, or following up on accounts receivable). The two complement each other; they are not interchangeable.

Should GST, QST, and source deductions be included in your dashboard?

Yes. The 5% GST and 9.975% QST that you collect, just like payroll source deductions, are amounts you hold in trust for the CRA and Revenu Québec. Tracking them as KPIs in their own right, and setting aside funds in a dedicated account, ensures these amounts are available when it’s time to remit them and makes each due date predictable.

Can my accountant create and maintain my dashboard?

Yes, this is a common service: it starts by ensuring your bookkeeping is accurate, works with you to select 8 to 12 metrics tailored to your business model, sets alert thresholds, and then produces a monthly report with commentary. A CPA who is a member of the Ordre des CPA du Québec can take it a step further with forecasts or financial statements. Bankeo connects you for free with a vetted accountant who offers this type of service.

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

Tracking KPIs is generally part of a recurring accounting mandate (bookkeeping, reporting, tax matters). The median cost is around $3,000 per year, and most businesses pay between $500 and $6,000, based on actual fees from 1,248 engagements secured through Bankeo (2024-2026), out of more than 15,000 requests received. The Bankeo Fee Barometer provides a breakdown of these ranges by department and by sector.

Official sources

1. Revenu Québec, GST/HST, and QST: Collection and Filing
2. Revenu Québec, Employer Withholdings and Contributions
3. Canada Revenue Agency, Payroll Withholdings
4. Canada Revenue Agency, Corporate Income Tax
5. Ordre des CPA du Québec