Cash Flow Analysis Error

Cash flow analysis requires an opening balance sheet

Updated over a week ago


What's causing this error?

For the Cash Flow Statement and Cash Flow Analysis tool, Fathom utilises an 'indirect method' by calculating movements in accounts from the P&L and Balance Sheet to determine cash flows.

As such, Fathom requires a closing balance from the previous period and a balance for the current period in order to calculate changes in balance sheet items to display the impact on cash flow.

When viewing results for the earliest period that you have imported, Fathom isn't able to find an opening balance sheet from prior period data and will always return the following error message:

โ— Sorry, we can't load this chart.

Cash flow analysis / statement requires an opening balance sheet

Example: You have financials imported for 2015-2019, including both P&L and Balance Sheet. You try to create a cash flow statement for the year 2015 (the earliest period imported you've imported in Fathom). You will then receive the above error message, as there is no closing balance from 2014.

How to resolve the error

In order to update the opening balance, you will be required to import balance sheet data for the month prior to the current earliest imported month.

For those companies imported from Xero or QuickBooks, it is possible to change the company start date to an earlier period.

Unfortunately, for companies imported from MYOB or via Excel, it is not possible to change the start date to an earlier period after a company has already been imported. You will need to delete and reimport the company to your account.

Alternate Workaround

For companies imported from Xero, you can change the start date in the Xero file to the first of the month. For example, when you change the start date to April 1st in Xero, the conversion balances for 31 March are all set to zero automatically.

By deleting the file in Fathom and then re-importing it in 'Step 1' of the company settings, the 31 March zero balances are recognised, and the cash flow will work correctly.

For companies imported from QuickBooks Online, importing a prior period will fix the issue.

Additional knowledge & common questions

Did this answer your question?