By Bronte Bay CPA Professional Corporation · 8 min read
Short answer: Xero is not just a bookkeeping tool — it is a revenue intelligence platform. When configured correctly for an incorporated Canadian business, Xero shows you exactly which clients generate the most profit, which services have the best margins, which invoices are slow to collect, and where your revenue is growing or declining. This guide covers the specific Xero features and reports that directly inform sales decisions — and how to connect Xero to Rotessa and Hubdoc to automate the full revenue cycle.
Most incorporated Canadian business owners use Xero for three things: bank reconciliation, HST filing, and producing the financial statements their CPA needs for the T2. These are important — but they represent less than half of what Xero can do for a business that uses it properly.
The features most directly connected to revenue growth — income by client, gross margin by service line, AR aging, repeating invoices, and pre-authorized debit collection — are available in every Xero subscription. Most clients never configure them. This guide shows exactly how to use them, and what decisions they enable.
Revenue by Client — Finding Your Most Valuable Relationships in Xero
The Xero Income by Contact report — available under Reports → Accounting → Income by Contact — shows total revenue ranked by client over any date range you specify. It is the fastest way to answer the question most incorporated business owners cannot answer from memory: exactly how much did each client generate last year, and how has that changed?
How to Use Income by Contact for Sales Decisions
- Identify your top 5 clients by revenue — run the report for the last 12 months. Your top 5 clients likely represent 60%–80% of total revenue. These are your highest-priority retention relationships. Are they growing, stable, or declining year-over-year? Compare the last 12 months against the prior 12 months using the date range filter.
- Identify clients with declining revenue — a client who generated $24,000 last year and $14,000 this year is a retention risk. The revenue decline may be visible in Xero months before the client leaves — giving you time to re-engage. Without this report, most business owners discover client losses only after the invoice stops arriving.
- Calculate revenue concentration — divide each client’s revenue by total revenue to get their percentage. Any client above 20% of total revenue represents a concentration risk. Any single client above 40% is an existential risk — Bronte Bay flags this in the monthly management report and initiates a diversification conversation immediately.
- Identify your lowest-revenue clients — sort the report ascending. Clients generating under $1,000 per year who still require relationship management, invoicing, and support may be consuming more resources than they return. This data enables a rational conversation about minimum engagement fees or client offboarding.
📋 CPA Note: Revenue concentration also affects your corporation’s value on a share sale. A buyer performing due diligence will discount the purchase price — and potentially the LCGE claim — if a significant portion of revenue is concentrated in one or two clients who may not transfer with the business. Diversified recurring revenue commands a higher EBITDA multiple and a cleaner QSBC share sale. Bronte Bay reviews revenue concentration quarterly for every Virtual CFO client.
Gross Margin by Service Line — What Is Actually Making Money
Revenue tells you what clients are paying. Gross margin tells you what is actually profitable after direct costs. For incorporated service businesses with multiple service lines — consulting, implementation, support, training — the revenue mix and the margin mix are frequently very different. The highest-revenue service is often not the highest-margin one.
How to Track Gross Margin by Service Line in Xero
Xero’s Tracking Categories feature allows you to tag every revenue and cost transaction with a category — service line, location, project, or department. When tracking categories are configured, the Profit and Loss report can be filtered by category — showing revenue and direct costs by service line, and therefore gross margin by service line.
- Set up tracking categories — go to Xero → Accounting → Advanced → Tracking Categories. Create a category called “Service Line” with options for each service your corporation offers. Bronte Bay configures this for every new client during onboarding.
- Tag revenue transactions — on every invoice, assign the applicable tracking category. A client paying for consulting should be tagged “Consulting.” A client paying for implementation should be tagged “Implementation.” This takes 5 seconds per invoice.
- Tag direct cost transactions — any subcontractor costs, direct labour, or materials should also be tagged to the corresponding service line. This gives you the cost side of each service’s margin calculation.
- Run P&L by Tracking Category — Reports → Profit and Loss → select tracking category filter. This shows revenue, direct costs, and gross margin for each service line side by side. The results are typically surprising — most incorporated service businesses find one service line generating 80% of the margin on 40% of the revenue.
What to do with this data: Focus your sales effort on the highest-margin services. Reprice or restructure low-margin services. Discontinue services where the margin does not justify the effort. These decisions cannot be made without the data — and the data lives in Xero.
AR Aging — Why Your Sales Numbers Lie Without Collections Data
A business can show strong sales revenue on the Xero P&L and simultaneously be running out of cash — because revenue is recognized when invoiced, not when collected. The Aged Receivables report in Xero shows the gap between what you have invoiced and what you have actually collected — broken down by how long each invoice has been outstanding.
| Invoice Age | Status | Sales Implication | Action |
|---|---|---|---|
| Under 30 days | ✅ Current | Normal — within payment terms | No action needed |
| 31–45 days | 🟡 Monitor | Slightly overdue — may indicate client cash flow issues | Friendly reminder with invoice attached |
| 46–60 days | 🟠 Concern | Actively overdue — cash flow impact growing | Phone call + email. Request payment date commitment. |
| 61–90 days | 🔴 Risk | Serious — consider pausing further work | Formal demand. Escalate to client director. |
| Over 90 days | 🔴 Critical | Potentially uncollectable — assess for bad debt write-off | Collections or Small Claims Court |
The AR aging report also reveals a client behaviour pattern that affects sales strategy: clients who consistently pay late are clients who are comfortable using your business as an interest-free lender. This pattern, visible in Xero, should inform decisions about whether to continue extending credit to those clients and whether to require deposits or pre-authorized debit on future engagements.
Access the report in Xero under Reports → Aged Receivables. Review it weekly. Bronte Bay includes it in the monthly management report for every client alongside the P&L and balance sheet.
Repeating Invoices and Rotessa — Automating the Revenue Cycle
The most common revenue leakage in incorporated Canadian service businesses is not lost clients or bad pricing — it is missed invoices and late collections. A retainer client who should be invoiced $3,000 on the 1st of every month generates $36,000 per year. If two invoices are forgotten or delayed by 30 days each due to manual processes, the effective annual revenue is $30,000 — and the cash flow impact is worse than that number suggests.
Repeating Invoices in Xero
For any client on a recurring fee — monthly retainer, quarterly engagement, annual subscription — set up a repeating invoice in Xero. Go to Accounts → Sales → Repeating. Configure the invoice amount, HST rate, billing frequency, and recipient. The invoice generates and sends automatically on the scheduled date — with no manual action required.
Benefits: every retainer client is invoiced on the same date every month without exception. The Xero AR aging report accurately reflects all outstanding amounts. The CPA can verify that every expected invoice was issued when reviewing the monthly books. Revenue is never understated because of a forgotten invoice.
Rotessa Pre-Authorized Debit — Collect Automatically
Repeating invoices solve the billing side. Rotessa solves the collection side. Rotessa is a Canadian pre-authorized debit platform that integrates directly with Xero. Once a client signs a one-time PAD agreement, Rotessa pulls the invoice amount directly from the client’s Canadian bank account on the due date — depositing it to your corporate account and automatically reconciling it against the Xero invoice.
Xero + Rotessa — The Automated Revenue Cycle
1st of month → Xero repeating invoice sends automatically
↓
Due date → Rotessa pulls payment from client’s bank account
↓
Payment deposited to your account → auto-reconciled in Xero
No reminder emails · No late payments · No manual reconciliation · $0.50/transaction
For a 10-client retainer business, Rotessa eliminates approximately 120 manual collection actions per year — reminder emails, follow-up calls, e-transfer confirmations, and manual payment matching in Xero. The time saving is significant. The cash flow improvement is more significant — every invoice is collected on its due date, not 15–30 days later. Visit Rotessa via Bronte Bay to set up your account.
HST on Sales — What the CRA Requires on Every Invoice
Every invoice issued by an HST-registered incorporated Canadian business must meet the CRA’s invoice requirements. A non-compliant invoice does not just create a CRA risk for your business — it invalidates your client’s Input Tax Credit claim, which damages the client relationship and may trigger a client dispute.
CRA Invoice Requirements by Amount
| Invoice Amount | Required Information |
|---|---|
| Under $30 | Supplier name · Date · Total amount · HST included statement |
| $30 – $149.99 | Above + HST registration number (RT0001) · HST amount or rate · Description of goods/services |
| $150 and over | Above + Recipient’s name or trading name · Terms of payment |
How Xero Handles HST Compliance Automatically
When Xero is correctly configured for your incorporated business, every invoice automatically includes: your corporation’s registered business name, HST registration number, invoice date, invoice number, itemized description with applicable HST rate (13% Ontario / 5% BC GST), HST amount, and total. Bronte Bay configures the Xero invoice template during onboarding to meet all CRA requirements.
The HST collected on every invoice is automatically tracked in Xero’s HST control account. When the quarterly HST return is due, Xero generates the return figures — HST collected minus ITCs on eligible expenses — in one click. This eliminates the manual HST calculation that creates errors in non-automated systems and ensures your quarterly remittance is always accurate.
📋 CPA Note: One of the most common CRA audit findings for incorporated service businesses is HST collected but not remitted — where the business owner did not realize how much HST had accumulated across all client invoices. In Xero, the HST control account balance is visible at all times on the balance sheet. Bronte Bay reviews this balance monthly and flags any significant build-up against the upcoming remittance date — so the quarterly HST bill is never a surprise.
The 5 Xero Reports That Directly Inform Sales Decisions
| Report | Where in Xero | Sales Decision It Enables |
|---|---|---|
| Income by Contact | Reports → Accounting → Income by Contact | Client revenue ranking, concentration risk, year-over-year client growth or decline |
| Aged Receivables | Reports → Aged Receivables | Outstanding invoice age by client — identifies slow payers and collection priorities |
| P&L by Tracking Category | Reports → Profit and Loss → filter by tracking category | Gross margin by service line — identifies most and least profitable offerings |
| Business Snapshot | Reports → Business Snapshot | Revenue trend, expense trend, cash position, and aged AR/AP in one dashboard view |
| Budget Variance | Reports → Budget Manager → Variance | Actual revenue vs budgeted revenue — identifies months where sales performance diverged from plan |
Bronte Bay configures all five of these reports for every incorporated client during onboarding — setting up tracking categories, budget templates, and the monthly management report that delivers Income by Contact, Aged Receivables, and Business Snapshot automatically by the 15th of each month. If you are not receiving a monthly management report that includes these reports, your bookkeeping is compliance-only — not revenue intelligence.
Hubdoc and Xero — Capturing Every Cost That Affects Your Margin
Gross margin is only accurate if every cost is captured. The most common margin distortion in incorporated Canadian service businesses is uncaptured expenses — subcontractor invoices paid by e-transfer without a receipt, software subscriptions charged to a personal card, or business travel expenses not submitted for weeks. These costs reduce actual margin but do not appear in Xero until they are entered — which means the P&L by Tracking Category report overstates margin until they are captured.
Hubdoc solves this. Hubdoc captures receipts via the mobile app (photograph a receipt at the point of purchase), email forwarding (receipts from supplier confirmation emails are automatically extracted), and direct supplier connections (Hubdoc connects to hundreds of Canadian suppliers and downloads invoices automatically). Every receipt is pushed to Xero as a draft transaction with the amount, supplier, date, and HST pre-populated. The source document is permanently attached to the Xero transaction — providing a fully auditable record with zero manual data entry.
For incorporated businesses tracking margin by service line, Hubdoc-to-Xero capture ensures every cost is in Xero on the day it is incurred — not three weeks later when the owner’s assistant processes the expense report. Real-time costs produce real-time margin data. Real-time margin data produces better pricing and sales decisions. Visit Hubdoc via Bronte Bay to get started.
Frequently Asked Questions
“Subhash is always able to advise us and share his insightful experience. He has an abundance of business experience and knowledge across industries and jurisdictions.”
— Managing Director, Lyra Marketing · Read full review on Clutch →
Is Your Xero Configured for Revenue Intelligence?
Bronte Bay configures Xero tracking categories, invoice templates, repeating invoices, Rotessa integration, and monthly management reports for every incorporated Canadian client. If your Xero is producing bank reconciliations but not revenue intelligence — book a consultation to see what your numbers could show you.
Toronto: 5000 Yonge Street, Suite 1901, North York, ON M2N 7E9 · Vancouver: 600-1285 West Broadway, BC V6H 3X8 · +1 416-439-4648
Related reading: Xero Accounting — Bronte Bay Certified Partner · Rotessa Pre-Authorized Debit · Hubdoc Receipt Capture · Cash Flow Management · Driving Revenue Through Repeat Clients · Bookkeeping for Incorporated Businesses