Monthly Cash Flow Dashboard
Originally published: 19/04/2018 10:09
Last version published: 19/04/2018 10:11
Publication number: ELQ-56236-2
View all versions & Certificate
certified

Monthly Cash Flow Dashboard

Allowing you to enter cash inflows and outflows weekly so that you can see your cash position at the end of a week/month

Description
If you're familiar with the weekly cash flow dashboard, this tool is very similar, however just for a month. You will find a 'dashboard builder' and a 'rapid dashboard.' The rapid dashboard is a back of the envelope dashboard that is a really quick way for you to figure out the cash you're going to have at the end of the month. The columns represent weeks and the rows are separated into beginning cash, cash inflow, cash outflow, and ending cash. So if you're in retail or run a restaurant business, for example, your weeks can be pretty consistent with income. Note: the last column is always a short week because it's not always seven days. There is no detail needed in this dashboard, but if you're looking for a more helpful dashboard, it is recommended that you look at the dashboard builder.

There are 4 steps in this calculator:

1. Beginning cash
2. Sales
3. Payroll
4. Detail bills

The video included in this tool shows you the model using a screen-sharing methods so that you can be aware of all of its capabilities as well as learn how to use it.

This Best Practice includes
1 Monthly Cash Flow Dashboard in Excel, 1 Video File

Acquire business license for $35.00

Add to cart

Add to bookmarks

Discuss


3.0 / 5 (1 votes)

please wait...