Cashflow 

Overview 

A report that outlines the inflow and outflow of cash during a specific period. It's a crucial financial statement that tracks the movement of money into and out of a company, providing a detailed breakdown of how cash is generated and used.

Reporting.

• The report will report on a financial year. 

• Columns will show each month in the financial year. 

• Each row show where money is coming from or where money is going to. 

Tech Note

The report consists of 3 sections. 

• Opening balance - Opening cash amounts. (this is a bank account in QE)

• Money In 

• Money Out. 

Money In

Cash that flows into a business from various sources during a specific period. 

• Debtors - Money paid by debtors in the date period. 

• Expected Debtors - Outstanding as of End of Month. 

• Roof Repairs (funding received) 

• Loan advances / Facilities.  - Check transaction that debit Loan accounts in set month. 

Money Out 

Cash that flows out of a business during the same period.

• Monthly payments per agreement/inv - General Payments/SINL in date period. 

• Monthly CODs (estimates as based on usage) - Get from supplier Age Analysis where supplier terms = COD as of end of month. 

• Monthly debit orders - Recurring Payment transactions??

• Monthly salaries & wages - Payments again salary and wages accounts in a set month. 

• Monthly creditors - Outstanding on Supplier age analysis excluding COD Suppliers. 

• Monthly approvals not yet invoiced. - SINL and SI that is not approved yet.

• Forecast/Budgeted cashflows for capex. - ?

• Vat - VAT Recon balance of Set Month.

• Dividend payments -?

• Working Capital repayments -?

• Savings -?