Cash Blow Budget
It’s important for businesses to prepare regular profit & loss and cash flow budgets to forecast the operating performance of the business and more importantly to assess the impact that these projections have on the future cash flow of the business.
Key benefits that businesses can gain from a budget
- A budget provides targets to aim for each month.
- A regularly reviewed budget provides a tool for making comparisons against actual performance which helps to quickly identify where any remedial action needs to be taken.
- Preparing a budget provides an opportunity to review expenditure and set limits for the business owner and staff.
- A budget is usually required for financing purposes and demonstrates good financial management.
Linked Profit & Loss Budget & Cash Flow Budget Calculator
The team of practising accountants at Australianbiz have developed a sophisticated and user friendly profit & loss and cash flow budget to assist our subscribers to more accurately forecast profitability and their future cash flow position.
Click here to subscribe to the site.
The two budgets are linked and have a number of inbuilt features including:
- The profit & loss budget contains a column for separating income and expenses that include GST or have no GST.
- The cash flow budget automatically calculates the GST by prompting users to select either monthly or quarterly GST reporting and whether GST is paid on either a cash or accruals basis.
- Operating expenses on the profit & loss budget are amortised evenly during the 12 month period and the cash flow budget automatically records these payments on either a monthly or quarterly basis. For example, it is assumed that rates & taxes, insurance, light & power, and fringe benefits tax are paid quarterly, whilst all other operating expenses are paid monthly.
- By entering an interest rate, the profit & loss budget can automatically calculate interest paid each month on the overdraft, or interest received where the account is in credit at the end of the month.
- Opening balances (e.g. bank overdraft/credit balance, GST liability/refund, debtors & creditors) can be entered on the cash flow budget.
- The collection and payment percentage rates for debtors and creditors (e.g. current, 30 days, etc) can be entered to better reflect the impact of sales/fees and purchases on the cash flow budget.
The cash flow budget has columns for entering the most common items such as PAYG instalments/income tax, loan repayments, plant & equipment purchases, dividends, and loans made to the business.
The budgets have been designed for manufacturers, wholesalers and retailers, although they can be equally used by both professional practices (e.g. architects) and other businesses (e.g. electrical contractors).
To make the two budgets more user friendly, the blue columns are where amounts can be input. Enter amounts on the profit & loss statement on a GST-exclusive basis, and on a GST-inclusive basis on the cash flow budget. Don’t include commas.
The cash flow budget assumes that the GST on either a monthly or quarterly basis is paid/refunded in the following month and that no special arrangements apply.
Note that the two budgets contain a large amount of background code, therefore they will take a few seconds to load, calculate, print and save.
You can choose to prepare the Budgets on either a financial year or calendar year basis by selecting the appropriate dates below. If you have previously saved data, please choose an item from the list below. You will need to click on "calculate" when you go back into a saved file for all the data to appear.
Alternatively, please contact us if you would like to purchase the Budgets in a Microsoft Excel file for a one-off cost of $396.00 GST inclusive. Click here to view a sample of the Excel file.
The Cash Flow Budget Calculator is only available to our members.
Please enter your username and password below to gain access.
Click here to become a member.