Forecast profit and loss

How to forecast profit and loss

Do you have an idea of how much money your business will bring in over the next year? Likewise, are you aware of all the expenses you face during the coming 12 months? Use our profit and loss template to accurately forecast the year ahead.


A profit and loss forecast is used to predict profit and losses over the coming financial year. Begin by focusing on next month - enter your predicted sales for the upcoming month, any sales returns you usually have, and any discounts you usually give. Continue inputting any additional income streams you may have.The template will automatically make the calculations for you, so enter each amount as a positive number.

Cost of goods sold

Next, enter your stock level at the start of the month and add stock purchases plus other costs associated with your goods. Input your predicted stock level for the end of the month.The template will calculate the total cost of goods sold and your gross profit for the month.

Use our profit and loss template to accurately forecast the year ahead.



The bottom half of the template deals with expenses - your selling, administrative and finance expenses. Navigate down the list entering all relevant expenses, which will be calculated by the template.

Input any interest expenses and hire purchase charges to calculate your profit before tax. Lastly, enter the estimated tax you’ll pay for the month and your net profit will be calculated at the bottom.

Move on to the next month and repeat the above steps. Continue estimating your sales and expenses for the next 6 or 12 months.

The last column will total all your monthly sales, expenses, interest and tax data into a half-year or annual amount.


Important information Show more

Australia and New Zealand Banking Group Limited ABN 11 005 357 522 (ANZ). ANZ's colour blue is trade mark of ANZ. This site contains general information only. Its content is for information purposes only, is subject to change and is not a substitute for commercial judgement or professional advice. This material does not take into account your personal and financial needs and/or circumstances, and you should seek appropriate advice (which may include property, legal, financial and/or taxation advice) before making any decisions or acting on any of the information contained in this material. To the extent permitted by law, all members of the ANZ group of companies disclaim liability or responsibility to any person for any direct or indirect loss or damage that may result from relying on the information contained or this site, or any act, omission or error, by any person in relation to the material contained on this site. For further information, see the Small Business Hub Terms of Use.