Cash flow 

The Cash flow Report enables you to track the cash movement in and out of your business over a specific period. It provides insights into your company’s liquidity, expenses, investment, and financial planning.  

Prerequisites 

1. Logicim XLGL version 5.0 or higher  
2. Microsoft Excel 2016 or higher 
3. Sage 50 US Edition (2021 and above) 

What the Report does

This Report enables you to break down cash transactions, analyze cash position through identifying trends in income and expenditures, and provide data to forecast future cash flow needs. 

How to use the Report 

1. Open the Report workbook. 
2. Go to the Cash flow sheet. 
3. Enter the Start date in cell E2. 
4. Enter the End date in cell E3. 
5. Review the sections: 
6. Operating activities: Shows cash from core business operations. 
7. Investing activities: Tracks cash from investments. 
8. Financing activities: Displays cash flow from debt, equity, and dividends. 

Customization options 

1. Adjust the date range in cells E2 and E3 for different periods. 
2. Expanding date ranges: To include an additional date range, copy column E and paste it into the desired column. Then, adjust the date parameters to reflect your preferred timeframe. 

Common use cases 

1. Monthly cash flow monitoring. 
2. Strategic budget planning and financial forecasting. 
3. Assessing financial stability before major investments. 

Troubleshooting 

1. Issue: The Report doesn’t update when a new date is entered.  
2. Solution: Ensure you are connected to your data source and refreshed. 

FAQs 

1. Q: Can I track cash flow for multiple date ranges simultaneously? 
2. A: Yes. You may set a new date range alongside the original by copying column E and pasting it into another column. 

1. Q: How do I know if my data source is connected? 
2. A: Go to the Logicim XLGL tab in Excel and check the connection status. Click the Refresh button to ensure the data is updated. 

Best practices 

Save a backup before making major adjustments to the Report structure.

Related articles

See also: Comparative income statement, Comparative balance sheet