"Cash Flow Worksheet Template"

When operating a business, it is important to use a Cash Flow Worksheet to understand what money you are expecting to receive in the coming weeks or months, what payments you will be making in that same time period, and how much available (liquid) cash you will have on hand. These factors can be tracked using a monthly Cash Flow Worksheet.

Alternate Names:

  • Cash Flow Analysis Worksheet;
  • Cash Flow Statement Worksheet.

By tracking these variables you will be better able to predict your business's funds further into the future and make investments in the business based on accurate information. A printable Cash Flow Worksheet template can be downloaded below.

ADVERTISEMENT

How to Prepare a Cash Flow Worksheet?

To prepare a Cash Flow Worksheet, follow the steps below in a spreadsheet software program:

  1. You will want to title each spreadsheet with your business's name and the week or month the worksheet represents. You can create a spreadsheet that covers a full calendar year.
  2. Each week or month will have separate columns for projected and annual income, it can be helpful to have these highlighted in separate colors.
  3. You will also want to have an annual column for total cash flow at the end of the spreadsheet.
  4. Create rows for the following sections:
    • Numbers relating to each week or month's total cash available (both projected and actual).
    • Earned income sources (such as sales, partnerships, etc) and unrestricted contributions to the business.
    • Any weekly or monthly restricted cash releases (such as agreements with another business or partner, or donations if you operate a non-profit).
    • All expenses and cash spent for items such as employees or personnel, rent, purchase receipts, interest related to debt, professional fees, and any other expenses incurred for operating the business.
    • It is a good idea to have a row representing the total expenses beneath the list of expenses.
    • A separate set of rows representing any non-operating cash statements, such as long-term debt, contributions to benefits for employees (such as healthcare or retirement accounts).
    • Below these rows you will want to create a separate row representing the total amount of money needed for the list of non-operating cash statements.
    • If you have any restrictions related to your business's cash flow you will need to create a section of rows representing this information. Restrictions can include any temporary restrictions placed on your business through a bank or lender, utility service (such as electricity or water), or by the property management if your business owes back rent. You can also include a note stating the predicted date these restrictions will be lifted.
    • Below the rows for temporary restrictions you will want to include a row representing the total amount of money to allocate to temporary restrictions.
  5. At the bottom of the spreadsheet you will have a total amount of cash flow taken from the difference between the income and expenses associated with your business. These amounts will represent the net cash your business has on hand on a weekly or monthly basis.

Haven't found the template you're looking for? Take a look at the related templates and samples below:

ADVERTISEMENT

Download "Cash Flow Worksheet Template"

Download PDF

Fill PDF online

Rate (4.8 / 5) 9 votes
Cash Flow Worksheet
________________________________________
Company Name
For the Year Ending 12/31/2019
Cash at Beginning of Year
(15 700)
Operations
Cash receipts from
Customers
(693 200)
Other operations
Cash paid for
Inventory purchases
(264 000)
General operating expenses
(112 000)
Wage expenses
(123 000)
Interest
(13 500)
Income taxes
(32 800)
Net Cash Flow From Operations
(147 900)
Investing Activities
Cash receipts from
Sale of property and equipment
(33 600)
Collection of principal on loans
Sale of investment securities
Cash paid for
Purchase of property and equipment
(75 000)
Making loans to other entities
Purchase of investment securities
Net Cash Flow From Investing Activities
(41 400)
Financing Activities
Cash receipts from
Issuance of stock
Borrowing
Cash paid for
Repurchase of stock (treasury stock)
Repayment of loans
(34 000)
Dividends
(53 000)
Net Cash Flow from Financing Activities
(87 000)
Net Increase in Cash
(19
500)
Cash at End of Year
(
35
200)
© TEMPLATEROLLER.COM
Cash Flow Worksheet
________________________________________
Company Name
For the Year Ending 12/31/2019
Cash at Beginning of Year
(15 700)
Operations
Cash receipts from
Customers
(693 200)
Other operations
Cash paid for
Inventory purchases
(264 000)
General operating expenses
(112 000)
Wage expenses
(123 000)
Interest
(13 500)
Income taxes
(32 800)
Net Cash Flow From Operations
(147 900)
Investing Activities
Cash receipts from
Sale of property and equipment
(33 600)
Collection of principal on loans
Sale of investment securities
Cash paid for
Purchase of property and equipment
(75 000)
Making loans to other entities
Purchase of investment securities
Net Cash Flow From Investing Activities
(41 400)
Financing Activities
Cash receipts from
Issuance of stock
Borrowing
Cash paid for
Repurchase of stock (treasury stock)
Repayment of loans
(34 000)
Dividends
(53 000)
Net Cash Flow from Financing Activities
(87 000)
Net Increase in Cash
(19
500)
Cash at End of Year
(
35
200)
© TEMPLATEROLLER.COM