The time to contemplate what to include in your end of year report has come.

It’s a time when we need to channel our inner Janus, the ancient Roman god of Beginnings, Transitions and Endings. Janus has two faces so he can look to the future and the past.

You can look to the future and the past through your financial reports. Certain reports will give you the information that you need to review how well your business has done. Whilst, others will document your plans for the future. The future is more uncertain than usual for many of us this year but that only reinforces the need to plan ahead.

You may need multiple plans to consider different scenarios but they will help you be prepared for whatever the world puts in front of you this year.


Your End of Year Report Kit


Reports for reviewing the past year:

  1. Budget Analysis
  2. Profit and Loss with Projected Total
  3. Where Did Our Money Go?
  4. 5-Year Overview


Reports for planning the year ahead:

  1. P&L with Projected Total
  2. Cash Flow Forecast & Cash Flow Scenarios
  3. Balance Sheet Forecast



EoY Reports to Review the Past Year

The combination of these four reports will give you more than enough information to review the past year.


1. Budget Analysis Report

A budget analysis report gives a good snapshot for the whole year. It compares actual to budget variances. During the year use Actual vs Budget reports, which have a bit more detail. Use an Account Tree to summarise the rows in your Budget Analysis Report. Because you’ve had the detail all year, a more concise version will do the job now. Run a budget analysis report for a consolidated group of entities, just one organisation, a project or group of projects depending on your audience.


Budget Analysis with Percentage Variance for End of Year Report



2. Profit & Loss Report with Projected Total

This is a great report to see each month column by column so you can review the trends in each line. Don’t forget to tick the “Use Actuals” option in Calxa when creating this report and add some KPIs to the bottom for deeper insights.


P&L with Projected Total for 12 Months Report



3. Where Did Our Money Go?

Run our popular Where Did Our Money Go report for a year and the Bank Movement Waterfall chart for a great overview of cash movements. Use Account Trees at level 1 or 2 for the Bank Movement so you don’t drown in the details.


Where Did Our Money Go Report for End of Year Reporting



4. 5-Year Overview

There’s no better time to take a long view of your business and 5 years is a good time-frame. There is a variant of the Profit & Loss with Projected Total Report that gives you 5 years (or 10 if you have that much data – and that could be 5 years in the past and 5 in the future).

For something a little different, show just KPIs and not accounts. An annual perspective on your KPIs can sometimes provide good insights.


P&L with Projected Total for 5 Years Report



EoY Reports to Plan for the Future

To plan for the future, it is now the time to run that famous “3-way forecast” that your accountant and bank manager love.


1. P&L with Projected Total

This is just like the one used to review the past year, but this time don’t show actuals, just budgets for the coming year. Use this report to communicate to the whole team what the plans are for your business moving forward.

For an alternative with a comparison to the previous year actuals, use the P&L vs Last Year report. That will show your forecast for the year compared to the actual result for the year just finished.

Tip: If you run this before the end of the year, set the start period as FY13 and use Actuals up to Relative 0.


3-Way Forecast - The Profit and Loss Statement



2. Cash Flow Forecast

It’s always cash flow forecasting time in our office but if it’s not one of your habits, this is a perfect time to start. Use a cash flow forecast to drive your business forward and make it a key part of your decision-making.


Small Business Cashflow Forecast


If you’re working on multiple scenarios for the next 12 months, use the Cashflow Scenario Chart to compare the possible effect on your bank.


Cashflow Scenarios Line Chart for End of Year Report



3. Balance Sheet Forecast

This completes the three reports of a 3-way forecast and will show your balance sheet movements for the next 12 months. The main question to ask when analysing this forecast is “Does it look reasonable?”. You’ll see where your debtors, creditors and other balance sheet accounts will change in the coming year.


Balance Sheet Forecast



End of Year Report Bundle

We recommend that you create a separate Report Bundle in Calxa for your end of year report. Simply include all the reports listed in this post for your end of year report. When you put all these reports into an end of year report bundle it then becomes effortless next time round you need it. Here is a Sample Report Bundle as shown in the webinar.


For more tips on how to create bundles, check out our Web Chat Recording.