Automated 3-Way Xero Cash Flow Forecasting.
Right Inside Google Sheets™.
Not a fragile spreadsheet template. Compass runs an automated 3-way accounting engine directly inside Google Sheets™—giving you 1-click Xero rollovers, auto-balancing Balance Sheets, and instant scenario modeling with zero formulas to maintain.
Seamlessly integrated with
Spreadsheet flexibility. Software reliability.
Built for business leaders, accountants, and Virtual CFOs who have outgrown fragile manual models—without locking into rigid "black box" software.
Manual Spreadsheets
Flexible, but fragile
- Hours wasted on monthly Xero CSV exports
- One overwritten cell or deleted row breaks the model
- Manual, error-prone GST/VAT, tax, and loan schedules
- Static budgets go stale the moment actuals change
Standalone Forecasting Apps
Automated, but rigid
- Locked into rigid "black box" templates
- Hard to customize for unique business edge cases
- Data stored on external third-party servers
- Yet another separate login and UI for clients to learn
Compass Forecasting
Automated AND flexible
- Live 1-click Xero sync & automated monthly rollovers
- Backend engine locks & balances the Balance Sheet to $0.00
- Built-in Holt-Winters, Working Capital, Tax & Loan engines
- 100% native inside Google Sheets™ with zero external database
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.
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.
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.
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.
See Compass in Action
We translate complex financial math into answers for your biggest business questions.
The "Safe Dividends & Tax Reserves" Scenario
"We've had a strong year and there's $250,000 sitting in the bank. How much cash can the directors safely pull out as dividends today without getting caught short by upcoming company tax, GST, and seasonal dips?"
A healthy bank balance today hides tomorrow's tax and working capital commitments. Compass maps your exact upcoming GST/VAT, income tax instalments, loan repayments, and debtor cycles across the next 12 to 60 months. In seconds, you can test a dividend payout and see your true 'safe-to-distribute' cash floor - letting profitable owners extract wealth with complete confidence instead of guesswork.
Pretty Dashboards, Without the "Black Box" Limitations.
Because Compass writes clean, script-verified 3-way financials straight into Google Sheets™, you have four ways to visualize and customize your numbers:
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.
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.
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.
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