Try Compass Forecasting with a 90-day free trial when you connect your Xero data!
NATIVE GOOGLE SHEETS™ ADD-ON FOR XERO

Automated 3-Way Xero Cash Flow Forecasting.
Right Inside Google Sheets™.

Stop flying blind or worrying about broken spreadsheet formulas. Sync live Xero data in minutes to generate dynamic 3-way cash flow models, multi-scenario comparisons, and executive dashboards, without leaving Google Sheets.

✓ Full 90-day free trial ✓ No credit card required ✓ Secure read-only Xero connection
Executive Overview Dashboard Scenario Matrix Dashboard Cash Flow and Runway Dashboard Revenue and Margins Dashboard
✨ Want to inspect the real numbers? Open the Live Sample Google Sheet™ ↗
💡 Tip: Once opened, click "File > Make a copy", install the Compass Forecasting add-on, and test-drive it yourself, or explore the Gemini-built Executive Dashboard right inside the sheet.

Seamlessly integrated with

Google Sheets™
Xero

Built for leaders and their advisors

Accountants & Bookkeepers

Guide your clients with "Smart Grid" Dashboards and export perfectly formatted data directly to Looker Studio or Power BI.

Virtual CFOs

Map out complex scenarios instantly using Holt-Winters Statistical Forecasting and a dynamic Working Capital engine.

Unbreakable Data Integrity (Zero Fragile Formulas)

Traditional spreadsheet models break the moment someone overwrites a cell or deletes a row. Compass calculates your entire 3-way P&L, Balance Sheet, and Cash Flow via our secure backend engine and writes clean, integrity-locked figures directly to your sheet: no fragile formulas or #REF! errors ever.

Clear direction for every financial scenario

Chart your course with confidence using our automated, perfectly balanced forecasting engines.

Live Xero API with 'Safe Anchor' Logic.

Bypass messy CSV exports. Direct, 1-click integration with Xero uses proprietary 'Safe Anchor' logic to ensure historical actuals are perfectly mapped without date truncation or sync errors. Go from a blank sheet to a fully populated baseline in seconds.

Compass Forecasting Worksheet Sidebar Options

Auto-Balancing 3-Way Forecast.

Built-in logic guarantees the Balance Sheet strictly balances to $0.00 variance and the Cash Flow ties perfectly to the bank. Eliminate spreadsheet stress and confidently present reports knowing the math is flawless.

Statement Cash Flows Report with Validation Screen

No-Access, Privacy-First Architecture.

Compass Forecasting is a Google Sheets™-native application with no external database. Your financial data is never extracted, transferred, or stored on third-party servers. Get SaaS power while maintaining 100% data sovereignty.

Privacy First Architecture Diagram

Unlimited 'What-If' Scenarios.

Spin up 'Base Case', 'Blue Sky', or 'Grey Sky' models in minutes. Answer complex questions instantly during live meetings using our visual comparison mode to demonstrate strategic choices to non-financial stakeholders.

Scenario screen showing Blue Sky, Grey Sky, and Base Case

See Compass in Action

We translate complex financial math into answers for your biggest business questions.

The "Inflation & Fuel" Scenario

The Question

"Fuel prices are surging, and my suppliers are raising their rates. How do I know if my business can absorb this, or if I need to raise my own prices?"

The Compass Answer

You don't have to guess. With Compass, you can instantly spin up a "High Inflation" scenario. Just adjust your expense driver up by 10%. Compass will instantly calculate how that ripples through your business over the next 12 months. You'll see exactly which month your cash flow drops into the red, giving you the hard data you need to confidently raise your prices today before it becomes a crisis.

UNLIMITED CUSTOMIZATION

Pretty Dashboards, Without the "Black Box" Limitations.

Competitors lock you into rigid templates that fail when your business has a unique edge case. Because Compass structures clean, script-verified 3-way financial data right inside Google Sheets™, you have four ways to visualize your numbers:

INCLUDED IN COMPASS

1-Click Dashboard Builder

Select the exact KPIs and charts you want inside the Compass sidebar, and automatically generate a clean visual dashboard inside your sheet.

AS SEEN IN OUR HERO ✨

Gemini in Google Sheets™

Have a Google Workspace Gemini subscription? Prompt Gemini right inside your sheet to build bespoke, interactive executive dashboards (like the one in our hero!) in seconds.

PLUG & PLAY BI FEED

Looker Studio, Power BI & Tableau

Connect your favorite BI tool directly to Compass's dedicated BI_Looker data tab for automated enterprise or multi-entity board reporting.

UNLIMITED FLEXIBILITY

100% Bespoke DIY Sheets

Have complex industry edge cases or custom bank covenants? Build your own custom tabs, charts, and calculations right alongside your automated Compass model.

💡 Why this matters: Standard forecasting tools force your business to fit their software. Compass adapts to your exact business rules, edge cases, and reporting style.

Under the hood: Advanced Calculation Engine

The precision math that keeps your forecast pointing true north, running silently in the background of your spreadsheet.

Advanced Forecasting

Set your forecast periods anywhere between 6 and 60 months! Our built-in Holt-Winters ETS forecasting automatically detects hidden seasonality and cyclic trends, taking the guesswork out of long-term planning.

Working Capital & Inventory

Use manual calculations or let the system calculate for you! Set trade debtors, creditors, and inventory based on average days and gross profit margins (periodic or perpetual). Not sure of your historical metrics? We'll calculate them for you automatically!

Overdraft & Loan Schedules

Never calculate interest manually again! We calculate overdraft interest dynamically based on average balances. Plus, use our built-in loan schedules to instantly generate amortisation schedules and insert them right into your forecast.

Global Tax & GST/VAT Engine

Calculate income tax on flat or marginal rates, adjust for opening/closing balances, and set custom payment months. Fully optimised for all Xero markets including Australia, New Zealand, US, Canada, UK, and South Africa!

Comprehensive Reporting

Generate out-of-the-box reports for tax reconciliations, assumptions, overdraft interest, and GST/VAT calculations. Plus, seamlessly connect your perfectly formatted forecast data to enterprise tools like Looker Studio or Power BI.

Built-in Integrity Monitor

The "Red Flag" system constantly scans background logic, acting as an automated auditor to ensure user customizations never silently break the underlying model.

See it in action

Frequently Asked Questions

Ready for professional-grade forecasting?

Join hundreds of finance professionals navigating the future with confidence right inside Google Sheets™.

✓ Full 90-day free trial  •  ✓ No credit card required  •  ✓ Secure read-only Xero sync