How to Develop Daily Cash Report

How to Develop Daily Cash Report

See Also:
Cash Flow Statement
Track Money In and Out of a Company
Cash Flow Projections
Cash is in Your Business
Thirteen Week Cash Flow Report

The Daily Cash Report

The Daily Cash Report is used to report on the daily cash balance and to help manage cash on a weekly basis. When entering a situation where active cash management is required for your daily cash flow, this tool is especially helpful. Use the daily cash report template 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.

Cash Flow Forecast

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. Conversely, 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.
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.


Managing your cash flow is vital to a business’s health. If you haven’t been paying attention to your cash flow, then access the free 25 Ways to Improve Cash Flow whitepaper to learn how to can stay cash flow positive in tight economies.

[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]


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.)
After obtaining the starting balance for the last business day, we need to capture cash inflows. The third piece of financial information you need to obtain is information on cash disbursements from the last business day.
Sum up 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. It should be updated periodically so that the company improves on the estimate. Your company may prefer to have a separate line item for certain significant cash disbursements. As long as you keep the overall report as simple as possible, this is acceptable.
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.

Daily Cash Report Monitor & Review

The Daily Cash Report should be monitored and reviewed 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.
Daily Cash Report
[box]Strategic CFO Lab Member Extra
Access your Cash Flow Tuneup Execution Plan in SCFO Lab. This tool enables you to quantify the cash unlocked in your company.
Click here to access your Execution Plan. Not a Lab Member?
Click here to learn more about SCFO Labs[/box]
Daily Cash Report

ARTICLES YOU MIGHT LIKE

Does your Accounting Department Produce Net Income?

Coaching the Entrepreneur: Learn how to know what you don’t know. How much should I spend on accounting for my company?     I have been in the accounting profession for 32 years, and for the last 6 years, I’ve owned my own consulting firm to assist companies with accounting challenges. There is one common theme that I

Read More »

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 »

JOIN OUR NEXT SERIES

Financial Leadership Workshop

MARCH 28TH-31ST 2022

THE ART OF THE CFO®

Financial Leadership Workshop

Days
Hours
Min

August 7-10th, 2023

SHARE THIS ARTICLE
WIKI CFO® - Browse hundreds of articles
Skip to content