How to Keep Daily Cash Positions for a Business in Excel

Monitoring the daily cash flow for your business is critical to its success. You can use an Excel spreadsheet to monitor your daily cash flow positions, or you can download a cash flow management template to make the calculations easier. You’ll need to track your starting cash position, daily expenditures and final cash position. Some templates allow you to monitor cash flow minimums and offer position projection and forecasting features.

Launch Microsoft Office and then create a new workbook by clicking on the “File” menu. Choose the “Blank Workbook” option if you want to design your own spreadsheet and formulae or select “From Template” to use the Microsoft Office cash flow template.

Go to the Microsoft Office Online website (link in Resources) and download the cash flow template if you selected the “From Template” option.

Enter your starting cash position and the date into your worksheet or template.

Enter your daily expenditure/outflow totals into the worksheet or template.

Input your revenue/inflows for the day into your worksheet or template.

Subtract the sum of your starting cash position plus your daily expenditure/outflows from your revenue/inflows to get your ending cash position. This will be your starting cash position for the following day. The template should perform the calculations for you. You'll have to type the formulae into the cells if you prefer to start with a blank worksheet.