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.
If you work across Xero and Excel, you know the routine.
Tejas removes this entire step.
Three steps. No exports, no reformatting, no lost mapping files.
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.
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.
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.
The time saved is real. So is the reduction in friction at the start of every engagement.
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.
Account mappings are stored per Xero organisation. Load next month's data and they apply automatically. Update them any time — statements regenerate immediately.
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.
Tejas doesn't replace Excel expertise — it removes the work that comes before you can apply it.
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.
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.
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.
A structured data pipeline from Xero into Excel, with an optional analysis layer on top.
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.
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.
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.
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.
Designed for professionals who need to understand and trust the numbers they're working with.
No intermediaries, no caching layer, no transformation you can't inspect. The TB sheets contain exactly what Xero returns.
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.
Loading data, saving mappings, and running analysis are all explicit actions. No background sync, no automatic overwrites.
No proprietary formats. Charts, tables, and statements produced by Tejas are ordinary Excel objects — you can modify, delete, or copy them freely.
Mappings, AI instructions, and tokens are stored independently per Xero organisation. One client's data and config cannot affect another's.
Revoking access removes the stored token. Your sheets remain exactly as they are — no data is deleted from Excel when you disconnect.
A secure OAuth 2.0 connection — the same standard used by every major Xero integration.
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.
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.
No installation, no admin rights. All you need is Excel for Desktop and a Xero account.
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.xmlOpen 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.
A Tejas button appears in the Home tab ribbon. Click it to open the task pane on the right side of your workbook.
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.
Step-by-step documentation for each capability. Expand any tutorial below.
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.
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.
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.
Download the manifest, sideload it into Excel, and connect to Xero in under five minutes.