Turn Google Sheets into an automated cash flow forecasting and financial modeling engine. Compass Forecasting seamlessly connects to Xero, automating data entry so you can build accurate rolling forecasts, track cash burn, and project business runway.

Easily generate fully-integrated 3-way financial models (Profit & Loss, Balance Sheet, and Cash Flow Statement) directly inside Google Sheets without fighting broken formulas or out-of-balance balance sheets.

KEY FEATURES

• Direct Xero Integration: Connect securely to your Xero account. Import your Chart of Accounts and up-to-date historical actuals with one click for real-time budget vs actuals tracking.
• Automated 3-Way Modeling: Generate mathematically linked P&L, Balance Sheet, and Cash Flow statements. Our built-in validation engine continuously checks that your balance sheet balances.
• What-If Scenario Planning: Compare Base Case, Best Case, and Worst Case scenarios side-by-side in your sandbox worksheet to stress-test cash flow under changing conditions.
• Interactive Cash Flow & Tax Engine: Easily model cash inflows and outflows. Adjust payment terms, allocate expenses, and calculate GST/VAT liabilities automatically.
• Advanced Debt Engine: Model new business loans, interest schedules, and principal repayments without manual spreadsheet gymnastics.

WHO IS THIS FOR?

Business owners, CFOs, fractional CFOs, accountants, bookkeepers, and financial advisors who need flexible FP&A (Financial Planning & Analysis) tools directly inside Google Sheets.

GET STARTED

A Xero account is required to use this add-on. We offer a 90-day free trial to connect your live Xero data. Alternatively, explore all features completely free with no time restrictions using our built-in Demo Company.