How to Prepare a Daily Cash Flow Statement Format in Excel – 9 Steps

Prepare a Daily Cash Flow Statement Format in Excel: 9 Easy Steps

Step 1 – Create a Header and Input Company Information

• Create a header for the cash flow statement.

• Add an input section for company information as shown below.

Read More: Create Cash Flow Statement Format with Indirect Method in Excel

 Step 2 – Create a Date Row for Daily Cash Flow

• Create a section to enter the date of the day. Choose a  date format.

Read More: How to Create Cash Flow Statement Format in Excel

 Step 3 – Enter the Beginning Balance

• Add another section to enter the beginning balance.

Step 4 – Input Cash Receipts

• Enter all cash receipts. Apply the Accounting number format.

• Use the SUM function to get a total. Enter the following formula in C18 and drag the fill handle icon to the right.

• Use the following formula in H12 to get the total. Copy the formula down using the fill handle icon.

Read More: How to Create Weekly Cash Flow Statement Format in Excel

Step 5 – Enter Cash Payments

• Enter the daily cash payments for the cash flow statement: the cost of goods sold.

• Enter the daily operating expenses.

• Enter all the other daily additional expenses as shown below.

Step 6 – Calculate the Total Cash Payments

• Use the following formula.

• Enter the following formula in C66. Then drag the fill handle icon to the right.

Step 7 – Estimate Net Cash Change

• Net cash change is the difference between receipts and payments.

• Use the following formula in C68. Drag the fill handle icon to the right.

Step 8 – Calculate the Month Ending Cash Position

• The month-ending cash position follows the formula given below.

• Enter the following formula in C70. Drag the fill handle icon to the right.

Read More: How to Create Monthly Cash Flow Statement Format in Excel

Step 9 – Finalize the Daily Cash Flow Statement

• Enter a formula to calculate the beginning balance at the start of each day.
• Enter the cash on hand at the start of the first day in C9.
• Use the following formula in  D9. Drag the fill handle icon to the right.

• Do not enter data in column G (the column immediately before the Total column). Right-click it and insert a new column before it to enter more data for the coming days.

Download Sample Workbook

Download the free template.

Related Articles

• Cash Flow Statement Format in Excel for Construction Company
• Create Cash Flow Statement Format Using Direct Method in Excel

<< Go Back to Cash Flow Template | Finance Template | Excel Templates