Cash flow statement format for businesses in India

Cash flow statement format for businesses in India

What is a cash flow statement?

A cash flow statement is a financial report that shows how much money your business received and spent over a period of time. This stream of money in and out is called cash flow.

The goal of the cash flow statement is to see whether your business has good liquidity, in other words, to see how your income and expenses stack up against each other.

A cash flow statement reviews numbers from the past month, quarter, or year, while a cash flow forecast predicts cash flow in the upcoming month, quarter or year.

What is a cash flow statement?
Why is a cash flow statement format important?

A cash flow statement is a very important financial document. It helps you

  • see when you have cash shortages, for example a specific month or time of year, and lets you plan ahead to avoid payment issues.
  • create budgets for the upcoming month, quarter, or year.
  • review your expenses, to see whether you need to cut costs, and what’s eating up most of your cash.

Some businesses are also required to submit their cash flow statement as part of their annual report

Why is a cash flow statement format important?

Advantages of using a cash flow statement format

Get an important overview

See how your business did, review costs and income, and plan for the future!

Quick and easy to set up

With a ready-made template, you only have to fill out your past receipts and payments.

Fully customisable

Tailor the cash flow statement template to suit your business and your reporting needs.

Download the free cash flow statement format

Cash flow statement format for Excel and Google Sheets

Cash flow statement for Excel download

How to set up a cash flow statement format

  1. Decide on your timeframe, whether that’s a weekly, monthly or annual statement.
  2. Add the opening balance at the top of the document. This is the closing balance for the previous period—if you don’t have cash flow statement for the previous period, this is the balance in your bank account combined with the cash you have in hand.
  3. Add all the money you earn under receipts, for example payments from customers and earnings from interest.
  4. Add all the money you spend under payments, such as payments to suppliers, payments on loans and labor costs.
  5. The receipts and payments will be tallied up automatically, and either added to your opening balance or subtracted from it.
  6. At the bottom of the cash flow statement, you can see whether your balance has increased or decreased.


Cash flow statement format example

This is a simple cash flow statement example, covering a year:

Opening balance120 000
RECEIPTS
Customer receipts100 000
Other receipts15 000
Total receipts115 000
PAYMENTS
Vendor payments70 000
Purchase of fixed assets3 500
Additional operating expenses1 200
Total payments74 700
Net cash flow40 300
Closing balance160 300
FAQ

Frequently asked questions about the cash flow statement format

How to do a simple cash flow statement?

You can set up a simple cash flow statement by downloading the free cash flow statement format and filling in the fields. All you need to do is add your opening balance, your receipts, and your payments. The template will work out the total amounts for you.

If you need a more thorough cash flow statement, for example if you need to submit it as part of your annual report, we recommend speaking to an accountant.

What is cash flow for dummies?

In short, cash flow is used to describe the stream of money going in and out of your business. If you have more money going out than coming in, it’s called negative cash flow. This is a bad thing in the long term. If you have more money coming in than going out, it’s called positive cash flow. That’s a healthy sign.

You can have negative cash flow for a short while—for example just after you’ve expanded your business, hired more employees, moved to new offices, and so on—but you should avoid operating this way for too long.

Send invoices for free

Everything you need to invoice:

  • Unlimited invoices
  • Unlimited clients, products, and services
  • Upload your logo
  • Send directly to your clients
“Conta has made invoicing a breeze with its ease of use and all-in-one tracking, simplifying my invoice management tasks and keeping everything super organized.”
Lamha BijiliGame designer
auth image
ratings 4.5 on Google