(This article is Xero users only)
A realistic cash flow forecast is vital for all businesses, but it is generally very time-consuming work. CaFE can create a realistic cash flow forecast in very simple steps with few inputs, and it can be monitored in real-time without any extra inputs!
If you already have your budget in CaFE, you will promptly see the realistic cash flow forest. Just click here for the instruction.
If you have no budget yet, please follow the instructions below.
[Creating your budget]
(if you have already created one, just skip this part)
In this step, a monthly cash flow plan is created for the next 3, 6 or 12 months with automated simple steps.
- Just go to Reporting -> Budget Planner, then click "Create a new budget" button.
- Please input basic information in the following screen. If you have already created a budget in Xero, you may import it. Or you can create a new budget based on your past actual data. You may find more detail explanations by clicking a question mark.
- Then your draft budget, which consists of BS, PL and Cash Flow Plan, will be created by CaFE automatically based on your basic information.
- You can update the BS and PL, and cash flow plan in the edit screen.
- The due date of cash flows for each item can be set in the following screens, which appear when the gear icon on Cash Flow is clicked.
- Please click "Recalculate Budget" to reflect the change. Then authorise it, with above "Authorise" button.
[Monitoring your budget]
1. Select your budget to be monitored
In the Budget List, select any budget, which you want to monitor in the Cash Projections and Cash Short Predictor.
Multiple budgets can be monitored as the same time, as long as there is no overlapping period among them.
2. Monitor the budget(s) on the Cash Short Predictor
Go to Cash Management -> Cash Short Predictor, then click "Recalculate Projection" button. Then planned cash flows will be reflected in the report.
The cash flows from the budget(s) are shown with "Planned" status.
Planned cash flow amounts will be automatically adjusted by cash flow forecasts, which are already issued in the month. For example, if you have 120 GBP cash flow in July 2019 for Entertainment in your budget, and you have already spent 24 GBP (cash flow forecast) in the month, then remaining 96 GBP will be shown up as a planned cash flow in July 2019.
Planned cash flows will be generated each month. For example, even if you still have the remaining 96 GBP for Entertainment in July 2019, new cash flow with a full planned amount (120 GBP) will be created on 1st August 2019. The gap for July can be seen in the Budget Planner.
The due date for the "Planned" cash flow will be decided based on the Due Timing setting in the Cash Flow Setting in the Budget Planner. However, if the date is already passed, then today's date will be set. You can adjust the due date of each cash flow manually.
You can stop monitoring remaining amounts or stop monitoring all cash flows per cash flow item if you don't want to monitor any cash flows on the item any longer. Please see here.
[Changing how you monitor the budget]
1. Stop monitoring budget(s)
Simply uncheck the budget in the Budget List, then click "Recalculate Projection" in the Cash Short Predictor. You can set monitoring budget again, whenever you want.
2. Adjust due dates
- Click the small triangle on the left column in the "Planned" cash flow which you want to edit, then click the "Change Date" button.
- Simply select the date, then save.
- If you want to update the date of future cash flows for the same item too, check "Apply the...". In this case, the value date of all future cash flows also will be updated based on the selection. If you prefer the end of each month, then select "The last".
- When necessary changes are updated, please click "Recalculate Projection" button to refresh the cash projection.
3. Change the monitoring option for each cash flow
- If you do not want to see the remaining cash flow amount, please click "Stop Gap Tracking" button. Please note that the remaining cash flow amount for the item will not be monitored for the upcoming future cash flows too.
- If you do not want to monitor certain cash flow item, please click "Stop Monitoring" button. Please note that the cash flow amount for the item will not be monitored for the upcoming future cash flows too.
- Those settings can be done in the Budget Planner as well. Go to Reporting -> Budget Planner, and select the Cash Flow tab, then click the gear icon in the item which you want to update, then select the option. Please note that the settings will be shown only for the monitored budget(s).
- Contact is not available
- Currently, splitting a Planned Cash Flow into multiple ones inside a month is not possible
- Amount in a Planned Cash Flow cannot be manually adjusted. In order to do this, you need to copy the budget, adjust cash flow amount in the draft Cash Flow Plan, authorise it, then monitor it.