Daily Cash Flow Forecast
Daily Cash Flow Forecast

See Also:
Cash Flow Statement
Steps to Track Money In and Out of a Company
How to Create Cash Flow Projections
Thirteen Week Cash Flow Report

Daily Cash Flow Forecast

Use the Daily Cash  Flow Report to report on the daily cash balance and to help manage cash on a weekly basis. This tool is especially useful when entering a situation where active cash management is required for your daily cash flow. The daily cash flow report template is used best as a tactical, active cash management tool. Knowing your daily cash position as well as your weekly cash commitments gives you added impetus to collect money and/or to generate revenues. You can then take the information generated in the daily cash flow report and incorporate the information into another useful tool, the Flash Report!
Why use a daily cash report? When facing a cash crunch, CFO/Controllers often manage cash by reviewing the online bank balance. Though easy to do, this number is not accurate. It does not take into consideration outstanding checks. Another symptom of a cash crunch is that accounting falls behind in processing information. By preparing this daily cash flow forecast or projection you force the accounting department to stay current with posting transactions.


NOTE: Want the 25 Ways To Improve Cash Flow? It gives you tips that you can take to manage and improve your company’s cash flow in 24 hours! Get it here!

[button link=”https://strategiccfo.com/25-ways-to-improve-cash-flow?utm_source=wiki&utm_medium=button%20cta” bg_color=”#eb6500″]Download The 25 Ways to Improve Cash Flow[/button]


Use in Conjunction With the 13-Week Cash Flow Report

This tool is also helpful when used in conjunction with the Thirteen Week Cash Flow Projection. It is helpful to think of the 13-Week Cash Flow Report as giving you the strategic big picture needs, while the Daily Cash Flow Report provides a more tactical level measure of your firm’s cash position. You can tie a week’s worth of cash receipts and cash disbursements as reported in the Daily Cash Report to the 13- Week Cash Flow Report.
Update the Daily Cash Report daily; remember, this process should not take more than thirty minutes to prepare. However, there is some element of planning involved insofar as weekly cash commitments are concerned. If the company is in a severe cash crunch, you may need to negotiate with vendors about partial payments.
The Daily Cash Report format should be set up and managed by the CFO/controller. However, it can be outsourced to a staff member in accounting to keep up on a daily basis. There are 3 sections to the Daily Cash Report: Today’s Cash Position, Weekly Cash Position and Payables Detail.
Prepare the daily cash flow report in the morning of each workday. Use the information on the report to help you manage cash for the day that you prepare it.
[box]Note: Today’s Cash Position is really the ending cash position from yesterday. [/box]

Daily Cash Position

This purpose of this section is to give you the cash position at the start of the day as per the G/L balance. The cash position for the start of today is the same as the ending cash balance from the last business day. Hence, the report you update and start off with at the beginning of today will be on the information from the last business day. (Reminder: this report is prepared the following day of the reporting period.)

Starting Balance

If the report you are preparing for today is based on information from the last business day, then it is important to capture all the cash flow events that happened during the course of the last business day. To do so, we need to have several anchors. First, you need a starting balance. This starting balance is the beginning cash balance per G/L and any outstanding checks from last business day (usually yesterday). This beginning cash balance is the same as the ending cash balance from two business days ago. Both the cash balance and outstanding check balance should be summed together to a Reconciled Balance. Click here for more information on account reconciliation.

Cash Inflows

After obtaining the starting balance for the last business day, we need to capture cash inflows. Examples of cash inflows include cash payments, lockbox payments, credit card payments, and any checks received through the mail. Again, these cash inflows and deposits are from the last business day. Add up the total amount of cash inflows together to obtain the Total Deposits.
[box]Managing your cash flow is vital to a business’s health. If you haven’t been paying attention to your cash flow, access the free 25 Ways to Improve Cash Flow whitepaper to learn how to can stay cash flow positive in tight economies. Click here to access your free guide![/box]

Cash Disbursements

The third piece of financial information you need to obtain is information on cash disbursements from the last business day. Cash disbursements include payroll checks, A/P checks. Your firm may prefer to have a separate line item for certain significant cash disbursements. As long as you keep the overall report simple and uncluttered, this is fine. After all cash disbursements have been accounted for, sum up together to obtain Total Disbursements. Enter the cash disbursements as negative numbers. The report is intended for non-accountants who think in terms of expenses being negative.
Sum up all of these elements together to obtain the ending cash balance for the last business day:

Reconciled Balance + Total Deposits – Total Disbursements = Cash Balance.

Incoming monies from yesterday Disbursements (Insert Date from 1 business day ago)- Payroll Fees – AP Checks – Other Disbursements = Total Disbursements

ENDING CASH BALANCE AS OF : This is also the Beginning Cash Balance for TODAY. Reconciled Balance + Total Deposits – Total Disbursements.

Weekly Cash Position

The weekly cash position gives management an estimate of how much incoming cash and cash disbursements the company expects to have for the entire week. Remember, this is an estimate only. Update this estimate periodically so that the company improves on the estimate. Your company may prefer to have a separate line item for certain significant cash disbursements. This is acceptable as long as you keep the overall report as simple as possible.
A template follows as below:

Estimated Deposits for the week ending: Lockbox/Mail + Credit Cards = Total Estimated Deposits

Estimated Disbursements for the week ending: Hourly Payroll + Salary Payroll + A/P Checks Committed + A/P Checks Expenses = Total Estimated Disbursements

Managing Payables

The CFO/controller will need to list the different vendor/suppliers that the company intends to pay for the week. During times of extreme cash shortage, it may be helpful to make a note of which vendor/suppliers are of high priority.
Update daily. However at the beginning of the week, plan to give extra attention to prioritize which vendors should be paid. Depending on the cash situation of the company, try to think of paying only a portion of what’s owed.
List of the vendor/suppliers with the amount needed to be paid. Finally, sum up the total amount. Vendor A + Vendor B + Vendor C = TOTAL

Monitor & Review

Monitor and review the Daily Cash Flow Report on a daily basis in situations where cash management is big key part of company survival. A key part to focus on is the estimate of weekly cash deposits. Monitoring and reviewing the cash deposits will improve the accuracy of the estimates. For more ways to improve your cash flow like this one, download the free 25 Ways to Improve Cash Flow whitepaper.

Daily Cash Flow forecast
[box]Strategic CFO Lab Member Extra
Access your Strategic Pricing Model Execution Plan in SCFO Lab. The step-by-step plan to set your prices to maximize profits.

Click here to access your Execution Plan. Not a Lab Member?
Click here to learn more about SCFO Labs[/box]

Daily Cash Flow forecast

Originally published by Jim Wilkinson on July 23, 2013.

ARTICLES YOU MIGHT LIKE

The Dreaded “F” Word

See Also: What is Factoring Receivables Accounting for Factored Receivables Journal Entries for Factored Receivables Can Factoring Be Better Than a Bank Loan? History of Factoring How Factoring Can Make or Save Money Factoring is Not for My Company The What, When, and Where About Factoring Working Capital Factoring: The Dreaded “F” Word The dreaded

Read More »

Strategy for Managing Cash

Does your company have a strategy for managing cash?  Many companies have established procedures for purchasing materials, collecting customer payments, and paying vendors. But often people either do not communicate these procedures or simply don’t follow them consistently. Even when everyone is aware of and follows the established protocol, your system may be flawed. Before we show an example, you need to know how to manage cash flow.  Know How to Manage

Read More »

Why You Need to Have a 13-Week Cash Flow Report

Have you ever been in a cash flow crisis? You aren’t able to make payroll. You can’t pay your vendors. There is simply not enough cash. BUT sales are rocketing. So in theory, there should be enough cash… Wrong. I say this during every Office Hours I host for our SCFO Lab members… “You need to

Read More »

JOIN OUR NEXT SERIES

Financial Leadership Workshop

MARCH 28TH-31ST 2022

THE ART OF THE CFO®

Financial Leadership Workshop

Days
Hours
Min

September 12-15th 2022

Days
Hours
Min
SHARE THIS ARTICLE

JOIN THE NEXT STRATEGIC CFO™ WORKSHOP SERIES

Strategic CFO™ Financial Leadership Workshop
The Art Of The CFO®

Days
Hours
Min

February 27 - March 2, 2023

Skip to content