Reconcile the figures in the Cashflow panel on the Overview screen

This article explains how FreeAgent calculates the figures in the ‘Cashflow’ panel on the Overview screen.

The Cashflow panel on the Overview screen calculates the money coming in and going out of all your business's bank accounts in FreeAgent over different periods of time.

The totals include any daily currency revaluations (if you have multi-currency bank accounts) and transactions awaiting approval but exclude the opening balance of each bank account and any transfers between accounts. For more information, please see Find out more about the Cashflow panel.

Please note that the Cashflow panel on your Overview screen in FreeAgent is different to the software’s Cashflow functionality.

Follow the steps below to see how FreeAgent has calculated the figures on the Cashflow panel on the Overview screen.

1. Create a Show Transactions report using a custom date range

Navigate to the ‘Accounting’ tab at the top of the screen and select ‘Reports’ from the drop-down menu.

Select ‘Show Transactions’ in the ‘Detailed’ section.

Then, select 'Bank account' from the 'Account type' drop-down menu and ‘Custom date range’ from the 'Date range' drop-down menu.

Enter the ‘From’ and ‘To’ dates to match the date range in the ‘Cashflow’ panel and select ‘Apply’.

2. Export to a spreadsheet

Next, select 'Export Report' in the top-right and select 'CSV' from the drop-down menu. 

3. Filter the spreadsheet

Once all the bank transactions from all the bank accounts for the date range have been exported into the spreadsheet, you’ll need to apply a filter to the data.

Filter the ‘Description’ column and untick all options that include ‘Transfer from…’. This will exclude bank transactions that have been explained as transfers between bank accounts, as these are not included in the totals on the ‘Cashflow’ panel.

4. Sum the totals

Finally, use the subtotal formula on the ‘Money In’ and ‘Money Out’ columns, as this won’t include the transactions that have been filtered out in the totals.

The total amount of money that has come into all your bank accounts and the total amount of money that has gone out of all your bank accounts for that date range should match the totals on the ‘Cashflow’ panel on the Overview screen.