Did you know that you can use Excel’s SUMIF feature to automatically generate a Cashflow spreadsheet? The screen below shows the one I use for monitoring my business income and expenditure across the year:- The 3 fields (Range, Criteria and Sum_range) enable Excel to constantly monitor them for any changes. This means that I change … Continue reading Managing your money in Excel (Cashflow)