AI
Build Your 2027 Budget With AI in One Afternoon
Most owners I talk to in Burnaby don't actually hate budgeting. They hate the blank spreadsheet. November is when it starts to nag. The year's almost over, your accountant wants a forecast, and you're still guessing what rent, wages and supplier costs will look like in 2027.
AI won't know your business better than you do. It can take the grunt work off your plate, though: cleaning exports, sorting categories, writing formulas, and asking the awkward what if questions you've been putting off. Here's how to get a working draft in one afternoon, plus honest notes on where it falls apart.
What to pull before you start
Export two full years of monthly profit and loss as a CSV from QuickBooks, Xero or whatever you use. Then write a short list of the changes you already know about for 2027. A lease renewal. A planned hire. The price increase you keep pushing back. That list matters more than any software.
Next, clean the file. Delete customer names, employee names and anything else that points to a person. In December 2023 the federal privacy commissioner and its provincial and territorial counterparts published joint Principles for responsible, trustworthy and privacy-protective generative AI technologies. Their advice to organizations using these tools is plain: where it's possible and reasonable, use anonymized or de-identified information in prompts, and only enter personal information when you're authorized to. A budget almost never needs a name. Change a payroll line that names your barista to something like Barista 2 and you lose nothing useful.
The afternoon, step by step
Block off about four hours. Here's a schedule that works:
- 1:00, sort. Upload the cleaned CSV and ask the assistant to group every line into 10 to 15 categories and flag anything that looks miscategorized. Check each flag yourself. You know the one time charge that only looks like a monthly one.
- 1:45, baseline. Ask for trailing 12 month totals by category and a month by month seasonality view. This is where most owners spot their first surprise.
- 2:30, assumptions tab. Give it your list of known changes. Tell it to put every assumption in its own labelled cell on a separate tab, so changing one number updates the whole budget. Don't accept numbers typed straight into formulas.
- 3:15, three scenarios. Base, tight and growth. Name the drivers for each: revenue growth, cost of goods, wages, rent.
- 4:00, stress test. Ask questions like: if revenue drops 15% in the first quarter, which month does cash get tight? What's the smallest price increase that covers the new lease?
- 4:30, verify. Pick five numbers and recalculate them yourself. Ask the assistant to list every formula it used in plain English. If it can't explain one, delete it.
Here's an illustrative example, not a client result. Picture a hypothetical New Westminster bakery averaging $40,000 a month in revenue. In the tight scenario it assumes sales down 10% and flour costs up 8%. The useful output isn't the final total. It's seeing that the squeeze lands in February, when sales are already seasonally low, which tells the owner to build a cash cushion in December. That's the kind of insight an afternoon can produce.
Picking a tool, and what it costs
You don't need anything custom for this. As of November 2026, Anthropic's help article Create and edit files with Claude says code execution and file creation is available on every plan, Free through Enterprise. It can produce Excel files with working formulas, formatting and charts, and it accepts CSV and TSV uploads for analysis. The maximum is 30MB per file. ChatGPT, Microsoft Copilot and Google Gemini offer similar features, but check their current data terms yourself before uploading financials. I haven't covered them here.
On cost, as of November 2026 Anthropic's pricing page lists Pro at $20 a month billed monthly, or $17 a month on an annual plan. Team Standard seats are $25 a month billed monthly or $20 billed annually, for 2 to 150 seats. Check the currency shown at checkout.
The detail that matters more than price is training. The same page lists model training as opt out on Free, Pro and Max, and none by default on Team and Enterprise. So if you're on a personal plan, go into your settings and opt out before you upload your books.
One more warning from that help article is worth taking seriously. It says malicious instructions hidden in external files or websites can trick Claude into sending information from its context to third parties, and it recommends you watch it work and stop it if it touches data unexpectedly. Practically, that means uploading your own exports, not a random budget template you downloaded from a forum.
Who's actually doing this
You're not late. Statistics Canada's Analysis on artificial intelligence use by businesses in Canada, second quarter of 2025 found 12.2% of businesses had used AI to produce goods or deliver services in the previous 12 months, up from 6.1% a year earlier. Among those users, 26.4% used it for data analytics. Adoption was uneven: 31.7% in professional, scientific and technical services, but only 1.5% in accommodation and food services. And 89.4% of AI using businesses reported no change in employment levels.
Plans are rising slowly. StatCan's third quarter 2025 analysis found 14.2% of businesses with 1 to 4 employees planned to use AI in the next 12 months. Of the businesses with no plans, 78.1% said AI wasn't relevant to their goods or services, 8.1% cited privacy or security concerns, and 7.6% said it isn't mature enough yet. Those numbers are from 2025, so treat them as a snapshot, not today's figures.
Where this doesn't apply
Be honest with yourself about these limits:
Messy books give you a messy budget. If your categories have drifted for two years, the AI will sort them confidently and sometimes wrongly. Spend the afternoon cleaning up with your bookkeeper instead.
Generative tools can state wrong numbers with total confidence. NIST published its Generative AI Profile in July 2024 as a voluntary companion to its AI Risk Management Framework, to help organizations manage risks like this one. That's why the verify step isn't optional.
Don't ask a chatbot about GST, PST, payroll remittances or what you can deduct. Rules change, and those answers belong with your accountant.
If you run a very simple operation, a basic spreadsheet template might be faster. Some of the 78.1% in StatCan's survey are probably right.
A lender or investor will want a budget your accountant has reviewed. Your AI draft is a starting point, not the version you hand over.
And if your whole 2027 hinges on one unknown, like a big contract that may or may not renew, precision is pointless. Spend your time on the scenarios.
Sources
- Statistics Canada, Analysis on artificial intelligence use by businesses in Canada, second quarter of 2025, 2025. https://www150.statcan.gc.ca/n1/pub/11-621-m/11-621-m2025008-eng.htm
- Statistics Canada, Analysis on expected use of artificial intelligence by businesses in Canada, third quarter of 2025, 2025. https://www150.statcan.gc.ca/n1/pub/11-621-m/11-621-m2025011-eng.htm
- Office of the Privacy Commissioner of Canada, Principles for responsible, trustworthy and privacy-protective generative AI technologies, 2023. https://www.priv.gc.ca/en/privacy-topics/technology/artificial-intelligence/gd_principles_ai/
- National Institute of Standards and Technology, Artificial Intelligence Risk Management Framework: Generative Artificial Intelligence Profile (NIST AI 600-1), 2024. https://www.nist.gov/publications/artificial-intelligence-risk-management-framework-generative-artificial-intelligence
- Anthropic, Claude pricing, accessed November 2026. https://claude.com/pricing
- Anthropic, Create and edit files with Claude (help article), accessed November 2026. https://support.claude.com/en/articles/12111783-create-and-edit-files-with-claude
If you'd like a hand setting this up, or want a budget assistant that refreshes your forecast every month without the afternoon, book a free call with Autana Solutions. We're based in Burnaby and New Westminster and work with owners across Metro Vancouver. We'll tell you honestly if a spreadsheet is all you need.
Want an AI employee for your business?
We install a 24/7 AI worker for businesses in Vancouver, Burnaby, and beyond. Book a free Discovery Call.
Book a call →

