Analysing the Balance Sheet covers an area many business owners stay away from. Most entrepreneurs are familiar with the Profit & Loss or Income Statement. The Balance Sheet is less commonly used and many people find it mysterious and hard to understand. If you consider that it shows the position of your business at a point in time, it’s easier to make sense of it all.

While the Profit & Loss report shows how much money you’ve made over a period of time, the Balance Sheet (also known as the Statement of Financial Position) lists your assets, liabilities and equity as they are valued at a particular date. This blog What does a Balance Sheet Tell Us? provides a short but concise explanation to help better understand the balance sheet.


Balance Sheet Comparison Reports

It’s often hard to assess a balance sheet in isolation. Having something to compare it to is the key to understanding what’s happening and what’s changed. To make this easier, Calxa has several Balance Sheet reports that will help you understand your business better.


Balance Sheet with Prior Period

Understanding how your balance sheet has changed over time is a good way to gain an understanding of your business. There are so many questions to be answered:

  • Have your assets increased or decreased?
  • Which lines stay the same and rarely change?

Fixed assets such as buildings, equipment and vehicles are typically stable for many businesses while bank accounts, debtors and creditor accounts often change daily. For example, with this report you can choose to compare your current balance sheet against the previous month (to see short term changes). It starts off with comparing the financial year to the same month last year (which is great for the longer-term view).


Balance Sheet Actual vs Budget

Budgets are traditionally used for measuring performance in the Income and Expense areas, but they are also relevant to the Balance Sheet. The comparison is especially important in the fast-moving areas such as inventory levels. Having too much cash tied up in inventory will reduce what you have for other purposes so monitoring the inventory balance has its rewards.

The Balance Sheet budget in Calxa always starts with the balances from the beginning of the current financial year. Then, it applies the budgeted movements to them. In the case of accounts like bank, debtors, creditors and taxes, it’s the calculated movement. Making Sense of Balance Sheet Budgets is a good guide to work your way through this step-by-step.


Balance Sheet Forecast Reports

To see what your Balance Sheet is likely to look like in the future, there are 2 options. First, the Balance Sheet Forecast. This report starts from the balances at the end of last month and then projects each line forward into the future. This is a popular report with banks to supplement the Cash Flow Forecast.

Secondly, have a look at the Balance Sheet with Projected Total. This typically starts from the beginning of the financial year and shows Actuals for the completed months and projected balances for the future months.

3-Way Forecast - The Balance Sheet


Multi-Company Balance Sheet Reports

Any of the Balance Sheet reports in Calxa can be run for a consolidated group of companies. The ‘Balance Sheet Multi-Org Comparison’ shows each company side by side which is really helpful in giving an overview. In addition, use an Account Tree with a Header to group inter-company loan accounts to check that they all balance.


Other options for Balance Sheet Reporting

There are two other reports that include Balance Sheet information.

  1. The Bank Movement Report
  2. Where Did Our Money Go?

Where Did Our Money Go Report


The latter reconciles your Net Profit to the movement in your bank account by showing the changes in the Balance Sheet. These changes are grouped into ‘Where Our Money Came From’. Essentially, this is how we funded the business. The other changes are highlighted in ‘Where We’ve Spent Our Money’. Simply, this is what we’ve done with the funds.

The ‘Bank Movement’ is slightly different. Essentially, it starts from the opening balance of the bank account, shows your Profit & Loss accounts and then the movements in the Balance Sheet accounts. To finish it off, it ends with the closing bank.


Analysing the Balance Sheet for Business Insights

Your Balance Sheet contains a wealth of information about your organisation and you will learn a lot from reviewing it regularly. If that’s not something you are used to, start with one of the comparison reports or ‘Where Did Our Money Go?’. You’ll become familiar with the regular values and you’ll learn to quickly spot problem areas. To better understand the importance of balance sheet budgets have a read of our blog article Making Sense of Balance Sheet Budgets.

Above all, your accountant or bookkeeper is a great source of advice if you’re not sure on anything.


Next month we will look into Balance Sheet Analysis with KPIs. This article will dive into deep analysis of the balance sheet with ratios.