140 likes | 283 Views
Cash Flow Management System. What every business should do to monitor its cash resources. Why do you need a cash flow management system?. It helps you see where your money is going. It helps you plan your outflows of money in advance. It helps you keep a tight control over your cash reserves.
E N D
Cash Flow Management System What every business should do to monitor its cash resources
Why do you need a cash flow management system? • It helps you see where your money is going. • It helps you plan your outflows of money in advance. • It helps you keep a tight control over your cash reserves. • Gives you peace of mind by monitoring your future cash movements.
Features of our Cash Flow Management System • Runs under the popular spreadsheet program ExcelÒ. • Lets you plan up to 9 weeks ahead. • You can enter automatic monthly, bi-weekly or weekly payments. • Helps you calculate your average collection of receivables.
Vendor payments also come from other sheet Previous balance plus inflows minus outflows yield total cash at the end of the week! (available for next week) The second portion shows all expected outflows These come from another sheet This type of inflows are entered in this sheet First part includes all cash inflows The AR information comes from another sheet This is the Main Screen of the program. It takes information from 3 other sheets These entries give the total available cash for the week Features Click here to advance
Up to nine weeks in the future! Every cash movement can be forecasted for future weeks Features Click here to advance
Once a week is complete, this button moves all figures up one week. Features Click here to advance
In this sheet you enter every monthly fixed expense. First you write the amount of the expense The system then allocates the expense to the corresponding week. and the day it is usually paid Features Click here to advance
In this sheet you can enter all weekly or bi-weekly fixed expenses Features Click here to advance
You can use these buttons to add additional lines as needed! Features Click here to advance
or you can enter each vendor invoice individually (as it appears in your AP aging). In this sheet you enter all vendor payments (usually merchandise or raw materials vendors) You can either program weekly amounts based on your AP aging and the days you usually take to pay. Features Click here to advance
These are your only entries or you can enter each customer invoice individually (as it appears in your AR aging). In this sheet is where you program your cash inflows, here too, you have two methods available. By calculating your average collection of receivables based on actual sales and AR balances You can automatically simulate your expected weekly cash inflows. Features Click here to advance
As you can see, our Cash Flow Management System is: • Very easy to use. • Saves time by automatically forecasting recurring outflows and inflows of cash. • It can let you plan ahead and know where your cash is going. • It helps you monitor your cash resources. Thank you