The Daily Cash Flow Forecast
The Daily Cash Report is used 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 report template is used best as a tactical, active cash management tool. Knowing your daily cash position as well as your weekly cash commitments will give you added impetus to collect money and/or to generate revenues. You can then take the information generated in the daily cash report and incorporate the information into another useful tool, the Flash Report!
Why use a daily cash report? Often CFO/Controllers when facing a cash crunch 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.
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.
The Daily Cash Report is updated daily and 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 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.
Note: Today’s Cash Position is really the ending cash position from yesterday.
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.)
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.
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. The total amount of cash inflows should be summed up together to obtain the Total Deposits.
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. This is fine so long as the overall report is kept simple and uncluttered. After all cash disbursements have been accounted for, they need to be summed 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.
All of these elements are then summed up 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 so long as the overall report is kept 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
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.
This is updated daily. However, give extra attention to planning at the beginning of the week to prioritize which vendors should be paid. Depending on the cash situation of the company, you may even need to start thinking of paying only a portion of what’s owed.
List of the vendor/suppliers and the amount to be paid. Finally, sum up the total amount. Vendor A + Vendor B + Vendor C = TOTAL
Monitor & Review
Monitor and review the Daily Cash 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, download the free 25 Ways to Improve Cash Flow whitepaper.