Updated Checked by the Tax-Services.ca editorial team How we check
Data analytics in accounting means asking your books useful questions: which product line earns money, which invoices sit unpaid, where costs creep up. In Canada it all rests on records the CRA already expects you to keep, and it expects you to keep them for six years from the end of the last tax year they relate to.
What does data analytics in accounting look like for a small business?
Forget the big dashboards for a minute. For most owners it’s a spreadsheet or an accounting file and five honest questions. The table below pairs each question with the tool on this site that does the arithmetic.
| Question | What you pull from your books | Check it with |
|---|---|---|
| Which product line keeps more of each sale? | Price and direct cost per item | profit margin calculator |
| Does tax collected match sales? | Sales before tax, tax charged | GST/HST calculator |
| What does a pay run really cost? | Gross pay per period, number of staff | payroll remittance calculator |
| Did that purchase pay off? | Amount spent, value at the end, years held | ROI calculator |
Which numbers should you track first?
Margin per product. It’s the one that changes decisions, and it’s easy to get wrong.
Say line A costs you $40 and sells for $55. Line B costs $70 and sells for $88. The calculator gives A a gross margin of 27.3% (a markup of 37.5%) and B a margin of 20.5% (a markup of 25.7%). B earns $18 a sale against $15 for A, so it looks better in a sales report. It keeps less of every dollar that comes in, though, and that shows up the moment costs rise by a few percent.
Mixing up margin and markup is the classic slip. Margin is a share of the selling price. Markup is a share of the cost, so it always looks bigger. Pick one and use it in every report.
Next, reconcile sales tax. In Ontario a $100 sale carries $13.00 of HST, for a total of $113.00. If your tax collected for the month doesn’t land near 13% of your taxable sales, something is coded wrong, and finding that before you file is cheaper than finding it afterwards.
What about unpaid invoices?
Sort them by age. Take a small print shop in Moncton with ten open invoices. Seven are under 30 days old and normal. Two are at 60 days, and one is at 120. Nothing fancy, but that single list tells the owner who to call this week, and which customer to stop extending credit to. The same list, run monthly, shows whether late payers are getting rarer or more common. If the oldest invoices are never the same customers, it’s a collections habit. If they always are, it’s a customer problem.
How often should you look at the numbers?
Monthly is enough for most small businesses, as long as it’s the same day and the same short list. Margin by product, tax collected against sales, unpaid invoices by age, payroll cost. Four lines on one page. Quarterly, step back and ask what changed and why. If a few bucks of cost creep has quietly eaten a product’s margin, you’ll see it in two or three months instead of at year end, when it’s too late to reprice.
What do the CRA’s record rules say about your data?
The CRA describes records as anything that holds financial information: ledgers, journals, statements, returns, correspondence. That includes what your accounting software and point-of-sale system produce. You keep them for six years from the end of the last tax year they relate to, unless the CRA has agreed you can destroy them sooner.
A few points catch people out. Records sit at your Canadian residence or place of business unless the CRA has given permission for somewhere else. You have to hand over everything on request, including computerized records and anything a third party holds for you. And if your bookkeeper keeps the file, the responsibility is still yours.
The CRA’s page on acceptable formats and backing up electronic files adds that records created electronically must stay in a readable electronic format, even if you also have paper printouts. So export your reports, keep the export, and don’t rely on a subscription that might lapse. If you use a cloud tool, also read the CRA’s electronic records guidance on where the data may be stored before you decide.
Where does analytics go wrong?
Usually at the input. A report is only as tidy as the categories behind it, and “miscellaneous” eats more reports than any software bug. Personal spending mixed into the business file does the same.
The second trap is trusting a clean chart. A trend line can’t tell you why sales fell. A customer left, a price rose, or somebody forgot to post a week of invoices.
The third is forgetting tax. The ROI calculator ignores taxes and fees, so a 30% return on paper is less after the CRA and your advisor’s invoice have taken their share. Treat any analytics output as a question to check, not a finding.
No claims are made here about what any named software does or costs. Prices and features change too often to print.
Where this information comes from
The record rules come from the Canada Revenue Agency publication on keeping records and its electronic records memorandum. The margin, HST and ROI figures are plain arithmetic from the calculators on this site, using the 13% Ontario HST rate built into the tool. Nothing here reflects a link with the CRA or any government.
Frequently asked questions
How long must I keep accounting data for the CRA?
Six years from the end of the last tax year the records relate to, unless the CRA has agreed you can destroy them earlier. Electronic records must stay readable for the same period.
Do I need special software for data analytics in accounting?
No. A spreadsheet export from your accounting file can answer margin, sales tax and payroll questions. We couldn't verify the features or prices of any product, so we don't rate them.
What is the difference between margin and markup?
Margin is profit as a share of the selling price. Markup is profit as a share of cost, which makes it the larger figure. A $40 cost and $55 price gives 27.3% and 37.5%.
Can my bookkeeper keep the records instead of me?
Yes, but you stay responsible for having adequate records. The CRA can ask for records held by third parties.
Does a dashboard replace a review of my books?
No. It only shows what was coded into the file. Check categories and sales tax totals before you trust a trend.
All family and benefits calculators
- Self-employed taxes in Canada: income, CPP and GST
How tax works when you are self-employed in Canada: reporting income and expenses, paying both halves of CPP, instalments and when to register for GST