Cash Flow SpreadsheetA Cash Flow Spreadsheet is used to show and calculate the amount of cash flowing into and out of a business, and the balance between the two, showing either a positive cash flow or a negative cash flow. The Cash Flow Spreadsheet can also be used to forecast future cash flow by including future expected figures for the amount of money being spent and the expected income. This is called a cash flow forecast or cash flow projection. This can help a business to plan it's financial strategy, provide insight into future performance over time, and to assist potential investors to understand the structure of a company's spending and income.

The cash flow spreadsheet will contain rows for all the cash coming onto the business, cash receipts, and all the cash being paid out of the business, which includes all stock or raw material purchases, payroll, office supplies and running costs, building costs in rent or mortgage, insurance and taxes. The columns of the spreadsheet will show time that can be any length but monthly would be typical. The cash flow forecast starts with the amount of cash on hand, or available to the business.

The image below shows an example of a cash flow spreadsheet and the typical rows and columns.

Cash Flow Spreadsheet

After the initial cash on hand balance, there will be rows with various categories that may be specific to individual businesses. Some example rows are:

Cash Receipts

  • Cash Sales
  • Collections fm CR accounts
  • Loans
  • Total Cash Receipts

Cash Paid Out

  • Purchases
  • Gross wages
  • Payroll
  • Outside Services
  • Supplies
  • Repairs & Maintenance
  • Advertising
  • Car, Delivery & Travel
  • Accounting & Legal
  • Rent
  • Telephone
  • Utilities
  • Insurance
  • Taxes
  • Interest
  • Other Expenses
  • Miscellaneous
  • Total Cash Paid Out 

Other Articles in Template Types

Welcome to our comprehensive guide on Spreadsheet Templates! In today's digital world, spreadsheet software like Excel and OpenOffice has be...
Spreadsheet templates are a great tool for those who use spreadsheets often. They can be used in many different ways, and they can save you time and e...
Whether you work as an accountant, bookkeeper, or another type of finance professional, your day-to-day responsibilities likely include using accounti...
When you’re just starting a business, it can be difficult to determine how best to allocate your resources. You need to make sure that every dollar is...
When managing a project, there’s a lot of information to track and keep organized. Without the right tools, it’s easy for details to fall through the ...
When you start a business, something as small as the process of creating your first invoice can feel like a big hurdle. There are a lot of documents t...
There are many spreadsheet templates available for small businesses, but some of the most popular and useful ones include: Budget template: This ...
Introduction to Pivot Tables: Enhancing Your Spreadsheet Skills Welcome to the world of pivot tables! As a versatile and powerful tool in spreadsheet...

Text and images Copyright © Spreadsheet Templates

Use of this website is under the conditions of our Terms of Service.

Privacy is important and our policy is detailed in our Privacy Policy.

See the Spreadsheet Templates Cookie Policy for our use of cookies and the user options available.