Cash Flow Planner
- 8'946 Downloads
- 5.8 Mb File Size
- January 3, 2022 Updated
- 4 Number of comments
Company Cash Flow Planner spreadsheet is a spreadsheet to plan more detail about your company cash flow. It fits small business companies who manage their tight cash flow where their expenses rely upon their income monthly. This spreadsheet should complement your cash flow budget spreadsheet. Cash flow budget spreadsheet usually doesn’t have details on exact income and expenses dates. You may see its balance is positive but in reality you have to spend your money before getting paid at the end of particular month.
This company cash flow planner spreadsheet will solve your payment timing issues. You can break your income and expenses down into dates and days. You can put exact invoice and purchase order payment dates as well as other regular expenses, like salaries, office rentals, electricity etc. With exact dates and days, you can push your customers to pay on time or set earlier due dates. You can negotiate payment with your suppliers as well.
This spreadsheet has monthly and weekly cash flow summary in calendar view style. You can set your threshold values to see your company financial situations daily. Also, if your company has weekly positive balance policy, you can organize all of your payment easily.
The template comes with 4 files:
- Monthly Cash Flow Planner V25 - Blank.xlsx
- Monthly Cash Flow Planner V25 - with Samples.xlsx
- Weekly Cash Flow Planner V26 - Blank.xlsx
- Weekly Cash Flow Planner V26 - with Samples.xlsx
With recurring dates and days features, you don’t have to type your recurring income and expenses each week or month. You type them once, and the excel formula will help you distribute it to the whole months automatically. To complement that feature, you can put exception dates and days for particular transaction. For example, your customer pay your invoice 3 times within 3 months, you can separate it by typing different dates and amount on particular dates. You can apply it for your company expenses. In addition, you can set it on weekly bases as well. For example, if you have to pay your part time employees weekly, you may put recurring payment days, like Friday and move it earlier if national holiday falls on Friday.
This company cash flow planner spreadsheet fits company that :
- has tight cash flow situation
- needs to manage recurring income and expenses
- wants to see their monthly and weekly financial profile
HOW TO USE COMPANY CASH FLOW PLANNER SPREADSHEET
To use this spreadsheet, you can start by setting your company financial year period in Payment Planner worksheet to prepare all tables for one full year. You can separate your recurring transaction in Monthly and Weekly tables.
This is the worksheet where you can put your income and expenses details. All data in this worksheet will be sorted and placed in particular dates in Weekly worksheet. There are maximum 30 items in each date columns. As a result, you can see summary of all transactions in calendar view model where you can see your cash flow performance in blue, red, orange and yellow colors. You can set reference values for those colors. You can see your company’s cash flow performance in weekly tables next to monthly calendar table. There are 53 weeks. Amount from dates before and after current year period won’t be calculated although you might see it in Weekly worksheet. You can always fine tune your transaction inputs in payment planner worksheet.
In conclusion, there are three big parts where you can work and review your company’s financial transactions. Those are :
- Income and expenses entry data area to put all of your company financial transactions. You can input maximum 200 transaction item per income/expenses table.
- Five weeks financial transaction view. You can see maximum 30 rows per date/day.
- Daily, weekly and monthly cash flow summary.
Monthly personal cash flow planner will organize transaction in monthly calendar view as you can see below. All shown worksheets are fully editable.
We are sorry 🙁
Help us improve!
How we can improve this template?
Rimzan ( )
Thank you for sharing the template.
Is there a version or any way to increase the number of income and expenses for similar days (more than 6)?
Highly appreciate any help.
Radu ( )
Thank you for sharing this. I need to add several line in the income section from the Payment Planner sheet. When I add these new lines, they are not taken into account (in the Weekly) sheet. I tried to backtrace the algorithm and to extend the function for the new lines, but the file is locked. Could you please help me?
Irina Luca ( )
Thanks for sharing the template “Weekly Cash Flow Planner V26”.
I use it at my company, but I need more lines to fill in.
How can we increase the number of income and expenses? Can you provide a template with more lines? E.g. 400 lines for Expenses by Month, 400 lines Expenses by Week, also for Income.
Gabriel ( )
I am having an issue where the weekly expenses I am putting in are not being figured. Is there a known issue or am I possibly doing something wrong?