Excel Add-in · Xero connected · No exports required

Stop preparing financial data.
Start analysing it.

Tejas connects to Xero, structures your trial balances, and delivers clean, mapped data into Excel — ready for your models the moment it arrives.

For fractional CFOs, finance consultants, and controllers who work across multiple SMEs.

Sound familiar?

If you work across Xero and Excel, you know the routine.

Tejas removes this entire step.

How it works

Three steps. No exports, no reformatting, no lost mapping files.

01

Connect to Xero

Standard Xero OAuth — takes 60 seconds. Tejas reads your data directly from Xero's API. Nothing is written back. You can disconnect at any time.

02

Map your accounts once

Assign each account a reporting category in the Mappings sheet. Your logic is stored on the server and applied on every future load — you never rebuild it from scratch.

03

Load any period, analyse immediately

Click 3 months, 6 months, or set a custom range. Each month lands in its own named TB sheet. P&L and Balance Sheet generate automatically. Your models work on the first run.

What changes

The time saved is real. So is the reduction in friction at the start of every engagement.

From days to under an hour

Data preparation that previously took 1–2 days — including the first time you set up a new client — now takes less than an hour. Load, map, done.

Write your mapping logic once

Account mappings are stored per Xero organisation. Load next month's data and they apply automatically. Update them any time — statements regenerate immediately.

Your existing models just work

Data lands in standard named Excel sheets. No proprietary formats, no locked reports. Formulas, pivot tables, and models you've already built work without modification.

Built for finance professionals who live in Excel

Tejas doesn't replace Excel expertise — it removes the work that comes before you can apply it.

Fractional CFOs

Managing multiple client organisations means repetitive monthly data work across different charts of accounts. Tejas stores independent mappings per organisation. Client switching is instant — the data pipeline is already built.

Finance consultants

Engagements often start with a data preparation phase that consumes the first few days. Tejas compresses that to under an hour, so you're in the analysis on day one — and the mapping work you do in week one carries forward automatically.

Controllers and management accountants

You know exactly how your chart of accounts should be structured. Tejas puts you in full control of the mapping layer — you define the categories, you approve every change, you edit the sheet directly if something needs adjusting.

What Tejas does

A structured data pipeline from Xero into Excel, with an optional analysis layer on top.

📄 Trial balance → named Excel sheets

One sheet per month (TB YYYY-MM), with account code, name, Xero type, debit/credit values, and your reporting category. Always sorted chronologically. Re-running a month replaces the sheet with fresh data.

🗺 Persistent mapping layer

A Mappings sheet stores your reporting categories. Fully visible, fully editable. New accounts from Xero are added automatically as unmapped rows — nothing falls through the gaps silently. Changes apply across all TB sheets and regenerate statements immediately.

📊 Automatic financial statements

P&L and Balance Sheet & Cash Flow are generated from your mappings automatically — no formulas to maintain, no manual layout to manage. Delete a month's sheet and they update instantly. The layout is data-driven: sections only appear when accounts with activity are present.

🤖 AI-assisted analysis (optional)

When you're ready to analyse, an AI layer can build charts, trend tables, variances, rolling averages, and margin ratios — writing directly to named Excel sheets. Every output is native Excel. The AI only acts when you ask, and every proposed change is reviewed before it's applied.

You stay in control

Designed for professionals who need to understand and trust the numbers they're working with.

Data comes directly from Xero

No intermediaries, no caching layer, no transformation you can't inspect. The TB sheets contain exactly what Xero returns.

Mapping logic is in a sheet you can read

Your reporting categories live in an Excel sheet. Edit a cell to change a mapping. The logic is not hidden in a database or a config file.

Nothing changes unless you ask

Loading data, saving mappings, and running analysis are all explicit actions. No background sync, no automatic overwrites.

All outputs are standard Excel

No proprietary formats. Charts, tables, and statements produced by Tejas are ordinary Excel objects — you can modify, delete, or copy them freely.

Each client is fully isolated

Mappings, AI instructions, and tokens are stored independently per Xero organisation. One client's data and config cannot affect another's.

Disconnect at any time

Revoking access removes the stored token. Your sheets remain exactly as they are — no data is deleted from Excel when you disconnect.

Xero integration

A secure OAuth 2.0 connection — the same standard used by every major Xero integration.

🔒 Secure by design

Tejas uses Xero's official OAuth 2.0 flow. You log in directly on Xero's website — we only receive a short-lived access token, which is refreshed automatically and stored server-side. Your Xero credentials never touch our servers. You can revoke access at any time from your Xero Connected Apps settings.

🏢 Multiple organisations

If your Xero account has access to more than one organisation, Tejas detects this automatically and shows an in-pane picker after login — no manual URL juggling. Each organisation gets its own independent mapping file and custom AI instructions. One login covers all your clients.

Up and running in four steps

No installation, no admin rights. All you need is Excel for Desktop and a Xero account.

1

Download the manifest file

The manifest tells Excel where to find the add-in. It's a small XML file — no macros, no VBA, nothing that touches your workbook data.

⤓ Tejas4Excel-manifest.xml
2

Sideload it into Excel

Open Excel and go to Insert → My Add-ins → Upload My Add-in. Select the manifest file you just downloaded. Excel installs it immediately — no store, no approval queue.

3

Open the task pane

A Tejas button appears in the Home tab ribbon. Click it to open the task pane on the right side of your workbook.

4

Connect to Xero

Click Connect to Xero. A browser tab opens for the standard Xero OAuth login — grant access, close the tab, and the add-in detects the connection automatically. Your Xero data is now one click away.

Detailed walkthroughs

Step-by-step documentation for each capability. Expand any tutorial below.

1

Load trial balances & generate financial statements

Get 12 months of live Xero data into named Excel sheets — plus P&L and Balance Sheet — in one click.

Open the task pane and go to the Data tab. Click one of the quick-load buttons — 3 months, 6 months, or 12 months — or set a custom From / To range and click Load. A progress banner tracks each month as it loads; you can cancel mid-load at any time.

One dedicated sheet is created per month — TB 2025-01, TB 2025-02, and so on — each with Account Code, Account Name, Xero Account Type, Debit/Credit YTD, and Reporting Type columns. Sheets are always sorted chronologically and replaced on reload, so re-running always gives you fresh numbers.

Once loading completes, Tejas automatically runs the pipeline: it generates a P&L sheet and a BS & CF sheet from your account mappings. The summary bar updates instantly — ● 6 months · ✓ P&L · ✓ BS · 42/42 mapped — and goto buttons (→) appear next to each statement so you can jump to them immediately.

The pipeline reruns automatically whenever you delete or add a TB sheet — no manual refresh needed. If you have incomplete mappings, a warning banner tells you exactly how many accounts are unclassified and offers a one-click shortcut to open the Mappings overlay.

Pro tip: Load 12 months once, then refine your mappings as many times as you like — the TB sheets stay in place and the P&L / BS sheets regenerate immediately each time you save a mapping change.
2

Manage account mappings — manually & with AI

Assign every account a reporting category. Do it yourself in the sheet, or let the AI propose, apply, audit, or query in plain English.

Click Open mappings in the Data tab (or tap the mapped-count badge in the summary bar from anywhere). The Mappings overlay slides in — it shows the full account table and the AI chat side by side. A → button in the toolbar jumps directly to the Mappings sheet so you can edit cells without leaving the overlay.

Three pill counts at the top of the overlay show your progress at a glance: Mapped (green), Unmapped (red), and Excluded (grey). The Unmapped pill disappears when the count reaches zero. While any accounts remain unmapped, the Mappings section in the Data tab is highlighted in light red as a persistent reminder.

Manual edits: type directly in the Type Reporting column of the Mappings sheet. The Save button turns red within a few seconds to signal unsaved changes. Click Save to push changes to the server and immediately reapply them to all TB sheets — the P&L and BS regenerate in the same step, and the success banner shows a one-line change summary (e.g. "3 remapped, 1 newly mapped"). To exclude an account from all reporting, type [Excluded] in the Type Reporting column — typing just Exclude also works and is normalised automatically. Click ← Back without saving to see a banner with [Save] and [Discard] options. If AI proposals are pending when you click Back, a confirmation dialog prevents accidentally discarding them.

AI — propose mode: type something like "Map all salary and payroll accounts to Staff Costs". The AI reads your current mappings and returns a list of proposed changes with reasons. Unmapped accounts are automatically included in every AI request so the AI prioritises them without you having to ask. Each change gets an ✔ Apply and ✕ Skip button. Click ✔ Apply All to commit the whole batch at once — all buttons lock immediately so you can't accidentally double-apply.

AI — decision mode: when the AI needs your input (e.g. an account could fit two categories), it shows a decision card with clickable category buttons rather than a text question. Click the right category — the change is applied immediately without a round-trip to the AI.

AI — queries & audits: ask "Which accounts are still unmapped?" or "Audit mappings and flag inconsistencies". The AI returns a structured result — unmapped accounts, invalid categories, anomalies, materiality flags, and inconsistent patterns (each with a one-click ✔ Apply to all fix). No changes are made unless you explicitly confirm them.

Custom instructions (⚙): set standing rules — preferred terminology, category constraints, business context — that apply to every AI interaction without repeating them. Instructions are saved per organisation.

How it all connects: every time you apply a mapping change — via the sheet, via AI, or the Apply button — Tejas writes only the changed cells (column D) in the Mappings sheet, reapplies to all TB sheets, and regenerates P&L and BS. The Mappings sheet is re-sorted by nominal code after every save. The workbook is always in sync.
Good to know: mappings are stored server-side per Xero organisation. Each org gets its own independent mapping set — categorise differently for different clients without any overlap.
3

Insights — one-click packages & AI-driven analysis

Run a full monthly review, trend analysis, or cost drill-down with one click. Or describe exactly what you want and let the AI build it.

Switch to the Insights tab (unlocks once TB data is loaded and statements are generated). Choose a package from the dropdown — each is a pre-configured set of analyses tuned for a specific use case:

Monthly Review — P&L variance vs prior month, top 10 accounts by spend, and a cash movement chart. Ideal for your monthly management pack.

Trend Analysis — revenue & cost trend charts, month-on-month changes, and a reporting-type breakdown. Best for spotting directional shifts over time.

Year End — full-year P&L trend, pivot by reporting type, equity movement, and gross/PAT margin ratios. Covers the key year-end narratives in one pass.

Cost Drill-Down — top 20 cost accounts, cost composition by reporting type, and an account-level variance. Use when you need to understand where costs are moving.

Free-form — full access to all tools. Describe exactly what you want: "Create a stacked column chart of revenue by reporting type for the last 6 months" or "Show me a rolling 3-month average of Overheads".

Click the button next to the package selector to execute all analyses in the selected package at once — no LLM round-trip, no waiting. All tools run in sequence and write their output directly to a sheet named after the package. The ▶ button is disabled when Free-form is selected.

For custom requests, type in the chat and press Send. The AI reads the current output sheets (their titles, column headers, and existing charts) before responding — so it knows whether to create a new chart or modify an existing one. It responds with a one-line confirmation and a ▶ Run button. Click it to write the result to your workbook. Once done, the button is replaced by a green ✓ Done.

Multiple outputs stack automatically on the output sheet — each block has a bold title, a blue-headed data table, and (where applicable) a chart immediately below. No manual layout needed.

What Analysis AI can produce: bar, column, line, stacked, area, pie, doughnut and combo charts · convert existing charts in place · month-on-month change tables with Δ and Δ% · two-period variance · top-N account rankings · pivot by reporting type · rolling averages (3 / 6 / 12 months) · ratio calculations (gross margin, current ratio, PAT margin) · AI narrative analysis of any sheet.
Before using Insights: load at least one month of trial balance data and let the pipeline generate the P&L and BS & CF sheets. Analysis AI reads directly from those sheets — no extra Xero calls needed once the data is in the workbook.
Available tools (9)
  • create_chart Chart from any data source. Renders a bar, column, line, stacked column, stacked bar, area, pie, doughnut, or combo (bar + line) chart from TB, P&L, or BS & CF data. Filter by reporting type, account, or row label. Group series by reporting type, account, period, or row label. Create a stacked column chart of revenue and cost of sales by month from the P&L for the last 6 months.
  • convert_chart Change the type of an existing chart. Modifies a chart already on a named sheet without touching the underlying data. Targets by sheet name and chart index (0 = first chart on the sheet). Convert the chart on the Monthly Review sheet to a horizontal bar chart.
  • create_mom_change Month-on-month change table. Outputs actual values for each period alongside absolute Δ and Δ% columns for every consecutive pair of months. Works with TB, P&L, and BS sources. Optionally renders a delta-only chart. Show me how overheads have changed month on month over the last 4 months, and add a column chart of the deltas.
  • create_variance Two-period variance. Compares exactly two periods with columns for each value, the absolute difference (Δ), and the percentage change (Δ%). Works with TB, P&L, and BS sources. Compare this month's P&L against last month — gross profit, operating expenses and profit after tax with the variance.
  • create_top_n Top-N account ranking. Aggregates TB values across all selected periods and ranks accounts by absolute metric value. N is configurable. What are the top 10 cost accounts by total spend across all loaded months?
  • create_pivot_by_type Pivot by reporting type. Builds a matrix of TB values with reporting types as rows and periods as columns, plus a TOTAL column. Unmapped accounts appear in an (unmapped) row. Give me a pivot of the trial balance by reporting type across all months.
  • create_rolling_avg Rolling average. Pairs each period's actual value with its N-month rolling average (window: 3, 6, or 12 months). Works with TB, P&L, and BS sources. Show me actual vs 3-month rolling average for staff costs.
  • create_ratio Ratio calculation. Computes a per-period ratio from two sets of rows — numerator ÷ denominator — and outputs a Period · Numerator · Denominator · Ratio table. Common uses: gross margin, PAT margin, current ratio. Calculate gross margin percentage each month using Gross Profit divided by Total Revenue from the P&L.
  • analyse_data AI narrative analysis of an existing sheet. Reads the data from a named Excel sheet, parses its tables, and returns a formatted narrative — trends, anomalies, key observations — directly in the chat. Nothing is written to Excel. Analyse the Monthly Review sheet and tell me what stands out about revenue this month.

Ready to cut your data prep time?

Download the manifest, sideload it into Excel, and connect to Xero in under five minutes.