There’s new content in our Advanced Microsoft Excel Course about Excel Macros that automate the reformatting of database information, exported from Xero Accounting so it can easily be imported into MailChimp for email marketing.
If any of these words don’t make sense to you, you need to upskill to get up to speed because this terminology is becoming common in most workplaces.
We mentioned that Jerry should use his accounting software to determine whether his he’ll have the start-up capital required to fund his new venture for the next 12 months. The best way to do this is to create a cash flow forecast, and we’re going to show you how.
Cash flow is a better indicator of available funds
If you’re wondering why you wouldn’t create a profit forecast, it’s pretty simple. Cash flow represents money in the bank, after you’ve paid all your suppliers and staff and loan repayments and so forth, while profit just shows how much the business earned but doesn’t take into account any cash outlays.
Profit just shows how much the business earned but doesn’t take into account any cash outlays.
It’s important to understand that it’s not uncommon for businesses to be profitable; however due to cash outlays, these same businesses may not actually have enough money in the bank to fund investment, or in this case, a new venture.
Generating a cash flow report in Xero
Follow these steps in Xero to generate a cash flow report for your business:
Go to Reports, then click All Reports.
Under Financial, select Cash Summary.
Enter the following report settings:
Date — The latest finalised month
Period — 1 month
Compare With — Previous 11 Periods
Select the Include GST and Show YTD filters
Click Update to generate the report in Xero
At the bottom of the report, click Export and select Excel to download the report in Microsoft Excel format.
Set up formulas to forecast 12 months ahead
In Excel, you’ll need to create formulas that will show you the average cashflow of your business across the previous 12 month period, so you can then forecast ahead for the next 12 months.