How Are Finance and Accounting Teams at Mid-Size Calgary Companies Using AI?

Last updated: March 2026

Finance and accounting teams at mid-size Calgary companies sit at a unique intersection of AI opportunity and AI caution. They handle the most sensitive data in the organization (payroll, client billing, financial projections, tax records), which makes them legitimately wary of AI tools that might compromise data security. At the same time, they perform some of the most repetitive, pattern-driven work in any company: month-end reporting, variance analysis, invoice processing, and budget reconciliation. These are precisely the tasks where AI delivers the most immediate, measurable value. Across Solway's work with mid-size Alberta companies in manufacturing, professional services, and oilfield services, finance teams consistently emerge as both the most cautious adopters and the most enthusiastic once they see the tool applied to their actual workflows. This guide covers where the practical opportunities are, how to address the legitimate security concerns, and what Calgary-area finance teams are doing with AI right now.

Where AI Delivers Immediate Value for Finance Teams

The highest-value AI applications for mid-size finance teams are not the exotic ones. They are the mundane, daily tasks that consume hours every week and follow predictable patterns.

Excel: The Finance Team's AI Goldmine

Microsoft Copilot in Excel is the single most impactful AI tool for finance professionals. It transforms Excel from a powerful but manual tool into a conversational interface where you describe what you want in plain English and get results instantly.

Practical examples that Calgary finance teams are using today: asking Copilot to "create a pivot table showing revenue by client for Q1 versus Q1 last year" and getting the table built in seconds rather than the 10 minutes it takes to configure manually. Asking "what's driving the variance between actual and budget for operating expenses this month?" and getting Copilot to identify the line items with the largest deviations. Asking "write a formula that calculates the rolling 12-month average for each cost centre" and getting a working formula without needing to remember the exact AVERAGE, OFFSET, and INDIRECT syntax.

For the controller at a 75-person company who spends every month-end building the same reports from updated data, Copilot in Excel can reduce the mechanical portion of that work by 40-60%. The analysis, judgment, and presentation still require human expertise. The data manipulation and formula construction do not.

Accounts Payable and Receivable Tracking

A Calgary professional services firm we worked with identified accounts payable tracking as a significant time drain. The manual process of reconciling invoices, flagging overdue payments, and generating aging reports consumed several hours per week. Copilot can automate the data consolidation and pattern identification portions of this workflow: summarizing outstanding receivables by client, flagging accounts that have exceeded payment terms, and drafting follow-up communications for overdue invoices.

The human still reviews and approves every action. But the preparation work, which is where the hours go, is handled by AI.

Financial Reporting and Board Materials

Preparing monthly financial reports and quarterly board packages is one of the most time-intensive tasks for mid-size company finance teams. The data assembly, chart creation, variance commentary, and formatting consume days of work every cycle.

Copilot in Word and PowerPoint can draft variance commentary from Excel data, generate formatted charts and tables from raw numbers, and create presentation slides that follow your standard template and structure. A CFO at a Calgary manufacturing company described the transformation: the mechanical assembly of the board package dropped from two days to half a day, freeing the finance team to spend more time on the analysis and strategic commentary that the board actually values.

Job Costing and Price Guidance

For Calgary manufacturers and service companies, job costing is a critical finance function. A mid-size manufacturer with 16 years of ERP data and thousands of historical jobs has an extraordinary dataset for AI-assisted pricing. When 45% of incoming orders are repeat configurations that have been priced and costed before, AI can surface the historical pricing data, margin analysis, and relevant job comparisons in seconds rather than the manual search that currently takes 30 minutes or more per quote.

This is not a simple lookup. The AI can account for material cost changes, labour rate adjustments, and margin targets when surfacing comparable historical jobs. The pricing decision still sits with the sales team and finance, but the data foundation is assembled automatically.

Budget Forecasting and Scenario Analysis

Copilot in Excel enables natural language scenario modelling. A finance manager can ask "what happens to our cash position if revenue drops 15% and we maintain current headcount?" and get a modelled answer based on the data in the workbook. This makes scenario analysis accessible to teams that do not have dedicated FP&A analysts or complex modelling tools.

For mid-size Calgary companies navigating commodity price volatility (particularly in energy and oilfield services), the ability to run quick scenarios without building elaborate spreadsheet models is a meaningful operational advantage.

Addressing the Security Concern: Why Finance Teams Should Care About Which AI Tool They Use

Finance teams have legitimate concerns about AI and data security. The question is not whether those concerns are valid (they are) but whether they are being addressed in the right way.

The most common pattern Solway observes is this: the finance team is told AI is available, expresses concern about data security, and therefore does not adopt any AI tools. Meanwhile, individual team members quietly use consumer ChatGPT for specific tasks, pasting financial data into a tool with no enterprise data protection. The security concern that prevented official adoption actually created a worse security outcome.

Microsoft Copilot within Microsoft 365 operates within your organization's existing security boundary. Data processed by Copilot is not used to train Microsoft's models, is not accessible to other tenants, and is governed by the same compliance and data residency policies that apply to your Microsoft 365 environment. For a Calgary finance team handling Canadian financial data, this means Copilot operates under the same data sovereignty framework as the rest of your Microsoft infrastructure.

The practical recommendation is not to avoid AI. It is to ensure your team uses the enterprise-grade tool you are already paying for rather than the consumer alternative that offers no data protection guarantees.

The CAPG Grant for Finance Team Training

For Alberta employers, the Canada-Alberta Productivity Grant (CAPG) reimburses eligible external training costs. A Copilot Foundations Workshop tailored to your finance team's specific workflows is CAPG-eligible. There is no minimum hour requirement, so even a half-day session qualifies.

The ROI calculation for finance team AI training is particularly straightforward because the time savings are directly measurable. If your three-person finance team saves a collective 10 hours per week on reporting, data manipulation, and administrative tasks, the annualized value of that recovered time significantly exceeds the cost of the training.

A Finance-Specific 60-Day AI Adoption Plan

Weeks 1-2: Baseline and Policy

Survey your finance team on current tool usage, including any consumer AI tools being used informally. Establish or update your AI policy with finance-specific guidelines: what financial data can be processed through Copilot, what requires additional review, and what must never be entered into any AI tool (specific client details in certain contexts, access credentials, etc.).

Weeks 3-4: Structured Training

Deliver a Copilot Foundations Workshop tailored specifically to finance workflows. The session should cover Copilot in Excel (formulas, pivot tables, data analysis, natural language queries), Copilot in Outlook (email drafting, thread summarization for client communications), and Copilot in Word (report drafting, variance commentary). The custom prompt library should include prompts for your specific reporting templates, analysis formats, and communication standards.

Weeks 5-8: Applied Practice and Measurement

Apply AI to one complete reporting cycle (month-end close, board package preparation, or quarterly review). Track time spent versus previous cycles. Use office hours with the training provider to troubleshoot prompts that are not delivering useful results. By the end of the second month, your team will have concrete data on the time savings and can make an informed decision about expanding adoption.

What Solway Offers

Solway is a Calgary-based AI strategy and engineering lab. We deliver Copilot Foundations Workshops tailored to specific functional teams, including finance and accounting. Our workshops include pre-workshop discovery, a baseline survey, hands-on training in the specific M365 applications your team uses daily, and a custom prompt library built from your actual workflows.

We have worked with finance teams at manufacturers, professional services firms, oilfield services companies, and hospitality operators across Alberta. We understand both the opportunity and the sensitivity of AI in a finance context.

Frequently Asked Questions

Is it safe to use AI with financial data?

Microsoft Copilot within Microsoft 365 processes data within your organization's security boundary. Your financial data is not used to train models and is not accessible to other organizations. This is fundamentally different from consumer AI tools like free ChatGPT. The key is ensuring your team uses the enterprise-grade tool rather than consumer alternatives.

What Excel tasks can Copilot actually do well?

Copilot in Excel excels at formula generation from natural language descriptions, pivot table creation and configuration, data summarization and pattern identification, chart creation, and "what-if" scenario modelling. It is less reliable for complex multi-step financial models that require nuanced judgment about assumptions and methodology. The human expertise remains essential for interpretation and decision-making.

How much time can a finance team realistically save?

Based on Solway's experience with mid-size Alberta companies, a three-to-five person finance team typically saves 8-15 hours per week collectively on reporting, data analysis, and communication tasks after structured AI training. The savings are most pronounced in month-end and quarter-end cycles where repetitive data manipulation is concentrated.

Can AI replace our accountant or bookkeeper?

No. AI handles the mechanical portions of finance work: data assembly, formula construction, report formatting, and pattern identification. The judgment, compliance interpretation, client advisory, and strategic analysis that define professional accounting work require human expertise. The practical effect of AI in finance is not fewer people but the same people spending more time on the work that requires their professional judgment.

What if our ERP system is old or our data is messy?

AI works best with well-structured data, but it can also help clean and organize messy datasets. Copilot in Excel can identify duplicates, flag formatting inconsistencies, and standardize data layouts. The key is setting realistic expectations: AI will not magically fix 16 years of inconsistent data entry, but it can significantly accelerate the process of bringing order to historical records.

Does the CAPG grant cover finance-specific AI training?

Yes. The CAPG grant covers eligible external training regardless of the department or function. A Copilot Foundations Workshop tailored to your finance team's workflows qualifies. Contact alberta.ca/CAPG for eligibility details.