A **cash flow statement** shows the impact of the balance sheet and income statement on the cash and cash equivalents. Basically, this is relevant to the cash in and out of a particular company. In this article, we will show you how to create a **monthly cash flow statement** format in Excel in two ways. In the first method, we will create it manually, and in the final method, we will use a Microsoft template to do so.

## Download Practice Workbook

## 2 Handy Approaches to Create Monthly Cash Flow Statement Format in Excel

For better visualization, we will only show three months at a time. However, our template has twelve months in it. Moreover, this is the snapshot of the ultimate output of our monthly cash flow format. Lastly, we have used the direct method to create a **monthly cash flow statement**.

### 1. Creating Monthly Cash Flow Statement Format Manually

In this section, we will create a **monthly cash flow statement** format manually in Excel. We will use ** the SUM function** to

**find the net cash flows**for each segment.

**Steps:**

- Firstly, type the month names.
- Secondly, input the â€śBeginning Balanceâ€ť field.
- Thirdly, type the operating activities, which include:
- â€śCash Receipts from Customersâ€ť.
- â€śCash Paid for Inventoryâ€ť.
- â€śCash Paid for Selling & Administrative Expensesâ€ť.
- â€śCash Paid for Income Taxesâ€ť.

- Then, we will calculate the net cash flow from operating activities.

- Afterward, insert the values for your company. Everything is set up in the accounting format.

- Then, calculate the cash flow from the operating activities by typing this formula in cell
.*C11*

`=SUM(C7:C10)`

- Â Then, using the
,*Fill Handle*for the rest of the cells.*AutoFill this formula*

- Now, we will focus on the investing activities of the company.
- So, type the operating activities, which include:
- â€śSale of Property, Plant & Equipmentâ€ť.
- â€śSale of Long-term Investmentsâ€ť.
- â€śPurchase of Property, Plant & Equipmentâ€ť.
- â€śPurchase of Long-term Investmentsâ€ť.

- We will use these values to find the â€śNet Cash Flow from Investing Activitiesâ€ť.

- Then, type all the values for the corresponding account.
- After that, use the following formula in cell
to find the net cash flow from this activity.*C18*

`=SUM(C14:C17)`

- Then,
the formula into the rest of the cells.*AutoFill*

- Then, we will find the net cash flows from the financing activities.
- Type the financing activities that consist of these items:
- â€śIssuance of Bonds Payableâ€ť.
- â€śIssuance of Common Stockâ€ť.
- â€śRepaying Principal on Bonds Payableâ€ť.
- â€śPaying Dividendsâ€ť.

- Again, we will find the net cash flows from the financing activities using these values.

- Then, type all the values for the corresponding account.
- After that, use the following formula in cell
to find the net cash flow from this activity.*C25*

`=SUM(C21:C24)`

- Then,
the formula into the rest of the cells.*AutoFill*

- The details of the segments have been concealed for better visualization.
- Then, type this formula in cell
to find the net increase or decrease in our cash flow for the month of January 2021.*C27*

`=SUM(C11,C18,C25)`

- Afterward, fill in the formula for the rest of the month.

- Next, we will find the ending cash balance, which we calculate by adding the values of the beginning balance and the net increase in cash flow.
- So, type the following formula into cell
.*C29*

`=C5+C27`

- Now, the beginning balance of
**February**will be the ending balance of**January**. - So, type this formula in cell
to do that.*D5*

`=C29`

- After that, use that formula for the remaining months.

- Lastly, if you have successfully followed our steps, the last three months will look like this. This completes the manual way of creating a
**monthly cash flow statement**format in Excel.

**Read More: ****How to Calculate Operating Cash Flow in Excel (2 Easy Ways)**

### 2. Monthly Cash Flow Statement from Office Template

We will use an ** Office template** to create another

**monthly cash flow statement**format in Excel.

**Steps:**

- To begin with, download this
from the official Microsoft Office website.*monthly cash flow template*

- Next, open this downloaded template. This template has
**3**:*Sheets*- â€śCash Receiptsâ€ť.
- â€śCash Paid Outâ€ť.
- â€śCash Paid Out (Non P&L)â€ť.

- Now, the first
shows the monthly cash receipts.*Sheet*

- Then, the second
records the amount of cash disbursed.*Sheet*

- Lastly, the final
accounts for the items not included in the income (Profit & Loss) statement.*Sheet* - In conclusion, we can use this format to keep track of the
**monthly cash flow statement**of a company in Excel.

**Read More: ****Create Cash Flow Statement Format Using Direct Method in Excel**

## Practice Section

We have removed all the values but kept the formula in a ** Sheet **named â€ś

**format**â€ť. You can input values there and follow along with our guide.

## Conclusion

We have shown you **2** quick ways to create a **monthly cash flow statement** format in Excel. If you face any problems regarding these methods or have any feedback for me, feel free to comment below. Moreover, you can visit our site **ExcelDemy** for more Excel-related articles. Thanks for reading, keep excelling!

**Related Articles**

**How to Calculate Incremental Cash Flow in Excel (2 Examples)****Prepare Daily Cash Flow Statement Format in Excel****How to Apply Discounted Cash Flow Formula in Excel****Create Cash Flow Statement Format with Indirect Method in Excel****How to Calculate Payback Period in Excel (With Easy Steps)****Cash Flow Statement Format in Excel for Construction Company****How to Calculate Future Value of Uneven Cash Flows in Excel**