Automated where you want it.
Surgical control where you need it.

While our automated engines handle the heavy lifting for standard cash flow, sometimes small businesses run into "curly" accounting situations that require finesse. Because CompassForecasting uses a unique hybrid architecture, you can model almost any real-world financial event.

How to handle complex scenarios

See how our Worksheet balancing tricks and powerful engines solve the hardest forecasting challenges.

How do I handle an ATO / Tax Payment Arrangement?

The Scenario

You have a historical tax debt that you are paying off at a fixed rate of $X per month, separate from your current, ongoing tax obligations.

The Compass Solution

Do not try to manually adjust your active GST/VAT account, as our Tax Engine completely controls it to ensure your *current* obligations are calculated perfectly. Instead:
  1. In Xero, do a manual journal to move the historical debt out of the active tax account and into a new "ATO Payment Arrangement" liability account.
  2. In the Compass Wizard, create a Loan Schedule for that new account. Set the interest rate to 0% (or whatever the ATO is charging) and set your fixed monthly payment.
  3. The Loan Engine will take over, automatically projecting those fixed cash outflows until the debt is gone, leaving your main Tax Engine free to handle your ongoing operations without confusion!

How do I forecast buying an asset (like a truck) that is 100% financed by a loan?

The Scenario

You are buying a $50k vehicle next month, fully financed by a bank. Because no cash physically leaves your bank account on day one, how do you get the asset and the loan onto your forecasted balance sheet?

The Compass Solution

  1. In the Worksheet, go to the month of the purchase and enter -50,000 in your Fixed Assets row (Asset increases).
  2. In the exact same month, enter +50,000 in your New Loan liability row (Liability increases).
  3. The net effect on your forecasted bank balance is exactly $0!
  4. Finally, use the Wizard's Loan Engine to set up the ongoing monthly principal and interest cash repayments.

I have one massive supplier I pay in 90 days, but everyone else gets paid in 30 days. How do I model this?

The Scenario

Our Accounts Payable engine automatically assumes all of your P&L expenses are paid on a standard 30-day timeline. How do you push out the cash flow for a specific, massive 90-day supplier?

The Compass Solution

Let the AP engine do its normal 30-day calculation, but use the Worksheet to surgically "move" the cash:
  1. Month 2 (The 30-day mark): The AP engine assumes you paid the supplier and takes the cash out of the forecast. Go to a generic Liability row in your Worksheet and enter a positive amount (e.g., +10,000). This instantly puts the cash back into your forecasted bank balance.
  2. Month 4 (The 90-day mark): Go to that same Liability row and enter -10,000. The cash now officially leaves your forecasted bank account at the correct 90-day mark!

How do I forecast taking personal drawings or paying dividends?

The Scenario

The business owner takes irregular cash drawings, which don't show up on the Profit & Loss statement as standard operating expenses.

The Compass Solution

Ensure your "Owner Drawings" or "Dividends Paid" Equity accounts are included in your Worksheet view. Simply type negative numbers (e.g., -5,000) into the months where you plan to pull cash out. The system knows this is an equity account and will strictly treat it as a pure cash outflow without impacting your operating profit.

How do I forecast an annual upfront payment (like Insurance) when my accountant amortizes it monthly?

The Scenario

You pay a $12,000 insurance premium in July in cash, but your accountant spreads it across the P&L as a $1,000 expense every month.

The Compass Solution

If you let the engine run normally, it will assume you pay $1,000 in cash every month. To fix this, use your Prepayments (Asset) account:
  1. In the Worksheet, enter -12,000 in the Prepayments row in July. (This hits your cash flow immediately for the full amount).
  2. Enter +1,000 in the Prepayments row for every subsequent month. This perfectly mimics the cash leaving the bank in July, while slowly unwinding the asset as the $1,000 P&L expense occurs each month.

Can the system handle Balloon Payments or complex loan terms?

The Scenario

You have a commercial loan with a massive residual "balloon" payment due at the end of the term, rather than a standard amortization.

The Compass Solution

Yes. Unlike simple percentage-based tools, our Loan Engine relies on comprehensive actuarial logic. When setting up a loan in the Wizard, you have access to Present Value (PV), Interest Rate, Number of Periods (NPER), Payment Amount (PMT), and Future Value (FV). By entering your required balloon payment into the FV field, the engine will automatically calculate the correct split of principal and interest over the life of the loan to ensure the liability hits that exact balloon target at the end of the term.

How do I model Invoice Factoring (Debtor Finance)?

The Scenario

You "sell" an invoice to a factoring company to get cash today, rather than waiting 60 days for the customer to pay.

The Compass Solution

Because this breaks normal "Days Sales Outstanding" logic, you need to bypass the automated Debtors engine for these specific funds. In the Worksheet, use a generic Liability or Clearing account to manually enter the cash injection today (+Cash). Then, enter a negative amount (-Cash) in the future month when the engine thinks the customer was going to pay you. This prevents the system from double-counting the cash injection!

Can I use CompassForecasting for multi-entity consolidation?

The Scenario

You have a corporate group with multiple subsidiaries and want to roll them all up into a single consolidated forecast.

The Compass Solution

Currently, no. CompassForecasting is laser-focused on providing the deepest, most surgically precise 3-way forecasting for single, complex entities. While other enterprise tools focus on 'going wide' by rolling up high-level data across dozens of subsidiaries, our architecture is dedicated to 'going deep'—giving you the manual worksheet control required to model the complex, granular scenarios (like detailed loan amortization, bespoke tax planning, and invoice factoring) that happen within a single operating business.

Ready for professional-grade forecasting?

Join the waitlist to get early access to CompassForecasting.