Forecaster gives you a combined view of what will happen across all your bank accounts over the next 90 days. It is entirely forward looking. Column 1 is today, column 2 is tomorrow etc. There is also a column that shows overdue sales & purchases. That way you can do things like predict your cash balance when a customer pays an overdue invoice.
Best Practices and Tips
What transactions show up in Forecaster?
There are two rules that govern transactions that show up in Forecaster:
- If a transaction will hit a bank account then it will show up e.g. sale payment, journal, payroll.
- If a transaction is expected to hit a bank account in the future then it will show up on that expected date e.g. an unpaid sale, a pay run, a recurring purchase.
Forecaster includes all transaction types, with the exception of bank transfers.
- Unpaid sales/purchases (Including Orders but not Quotes or Opportunities)
- Sale/purchase payments
- Bank Transfers
- Recurring sales/purchases
- Pay runs but not individual payroll entries
Why does a transaction show up on that date?
Forecaster uses lots of logic behind the scenes depending on the transaction type. For example we will use the due date on an unpaid sale to begin with however we use many other rules to help get the best possible predicted date. This is our "secret sauce"!
Why can't I move those grey transactions?
There are two types of transactions that cannot be moved, actual and forecasted:
- Actual transactions such as payments, journals, payrolls. These have happened so they cannot be moved.
- Forecasted transactions such as recurring sales/purchase and pay runs. These are actuals in the future e.g. next weeks pays.
Remember Forecaster shows a future where predicted transactions have already happened. e.g. in Forecaster a recurring sale that will be created next week with a payment applied 3 days later has already happened. Therefore it shows up in Forecaster.
How can I use this to plan?
Forecaster is malleable. You can move one or more transactions to another date to see what will happen to your future cash position. This allows you to see what happens if you get paid late, if you pay someone late etc. Also remember you can change transactions like a recurring sale and we will reflect that updated setup in Forecaster instantly.
How do I exclude a bank account from Forecaster?
Navigate to the edit Bank Account screen and un-tick the option shown below. An example of an account you may want to exclude could be a Directors Loan account that you have setup as a bank account.
What makes up the forecast value?
The "you have" amount is the bank accounts opening balances for today plus the net of transactions for the day. So it's super important to have your bank accounts reconciled as close to today as possible.
Also all values are converted to the base currency of the file. This means that if your file is in the Australian tax zone all values will be AUD. If there are any foreign currency transactions they will be automatically converted to AUD providing you with a single understandable figure.
Can I access Cashflow Forecaster on the mobile app?
Yes. If you are using version 1.0.17 or higher of the iOS or Andriod apps you can view the Forecaster report for either 1 month or 3 months as a line graph. Any movement of predicted transactions will still need to take place on the web app.
Why am I getting "Access Denied"?
To access Forecaster you need to have FULL access to the following in your user role. We are using all of these to generate the forecast. Therefore we don't allow access unless you can see a complete forecast.
- Transactions: Sales
- Transactions: Purchase
- Transactions: Payroll
- Transactions: General Journal
- Reports: Forecaster
- Setup: Bank Accounts
- Advanced Payroll: Pay Group
- Automate: Automate Sale
- Automate: Automate Purchase