It’s important for businesses to prepare regular profit & loss 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.
The team of 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.
This information is provided as a guide only and is not intended to constitute professional advice. You should obtain appropriate advice concerning your particular circumstances.
Australianbiz and its representatives disclaim all liability for any loss or damage to any person or organisation, whether a user of this site or not, for the consequences of anything done or omitted to be done by any such person relying on this information.