LOADING
   
   
  View Special Offer View membership fees  
  This page lists all our Excel Cash Flow templates. Our 40+ unique templates are listed on the following template pages:  
 
  • 14 Cash Flow - Business Plan Forecast
This unique template enables users to create cash flow projections for a business plan which includes 12 monthly periods and 5 annual periods. The template includes a detailed income statement, cash flow statement and balance sheet. The cash flow projections are based on a number of default assumptions and the turnover amounts, gross profit percentages, expense amounts, capital expenditure amounts and loan amounts that are specified by the user. The monthly and annual reporting periods are all based on a single user defined start date. This template is ideal for trade based businesses but can also be used for service based businesses by simply entering a 100% value in the gross profit percentage input cells.
  • Includes the following features:
  • Suitable for any business
  • Includes 12 monthly & 5 annual periods
  • Reporting periods based on a single user input cell
  • User input limited to basic template assumptions
  • Expense accounts can be customized & additional accounts can be added
  • Automated income statement, cash flow statement & balance sheet
  • Accommodates loan amortization or interest-only loans
  • Includes calculation of key financial ratios
 
    business plan cash flow business plan forecast excel business plan business plan template  
  Return to Top File Size: 194KB File Size: 85KB File Size: 301KB File Size: 115KB ZAR300 ($29 £17 €21)  
 
  • 15 Cash Flow Projections - Annual
This template enables users to create annual cash flow projections for a five year period. The annual cash flow projections are calculated automatically based on the turnover, gross profit margins, expenses, working capital, capital expenditure and long term loan assumptions that are specified by the user. The turnover and expenses for subsequent years are determined by applying a user defined increase percentage to the appropriate amounts of the previous year. The template produces an annual income statement, cash flow report and balance sheet. The default list of expense accounts can be customized and additional accounts can be added by simply inserting the appropriate number of rows. A loan repayment amortization table is also included.
  • Includes the following features:
  • Suitable for any business
  • Includes 5 annual periods
  • User input limited to basic template assumptions
  • Expense accounts can be customized & additional accounts can be added
  • Automated annual income statement, cash flow statement & balance sheet
  • Accommodates loan amortization or interest-only loans
  • Includes calculation of key financial ratios
 
    excel cash flow templates cash flow templates excel cashflow templates cashflow templates  
  Return to Top File Size: 156KB File Size: 63KB File Size: 198KB File Size: 80KB ZAR250 ($24 £14 €18)  
 
  • 16 Cash Flow Projections - Monthly
This template enables users to compile monthly cash flow projections for a 36 month period. The monthly cash flow projections are calculated automatically based on the monthly turnover, gross profit margins, expenses, working capital, capital expenditure and loan amounts that are specified by the user and the reporting periods that are included in the monthly cash flow projections are determined based on the start date that is entered in a single input cell. The template automatically produces an income statement, cash flow statement and balance sheet. The default list of expense accounts can be customized and additional accounts can be added by simply inserting the appropriate number of rows. A loan repayment amortization table is also included.
  • Includes the following features:
  • Suitable for any business
  • Includes 36 monthly periods
  • Reporting periods based on a single user input cell
  • User input limited to basic template assumptions
  • Expense accounts can be customized & additional accounts can be added
  • Automated monthly Income statement, cash flow statement & balance sheet
  • Accommodates loan amortization or interest-only loans
 
    cash flow template excel cash flow cashflow template excel cashflow  
  Return to Top File Size: 198KB File Size: 95KB File Size: 348KB File Size: 136KB ZAR250 ($24 £14 €18)  
 
  • 17 Cash Flow Projections - Weekly
This template enables users to create weekly cash flow projections for any user defined 52 week period. The template includes a weekly income statement, cash flow statement and balance sheet with quarterly & annual totals. The cash flow projections are based on a number of default assumptions and the weekly turnover amounts, gross profit percentages, expense amounts, capital expenditure amounts and loan amounts that are entered by the user. The weekly reporting periods are based on a user defined start date and the number of weeks in each quarter can also be specified by the user. This template is ideal for trade based businesses but can also be used for service based businesses by simply entering a 100% value in the weekly gross profit percentage input cells.
  • Includes the following features:
  • Suitable for any business
  • Includes 52 weekly periods
  • Reporting periods based on a single user input cell
  • User input limited to basic template assumptions
  • Expense accounts can be customized & additional accounts can be added
  • Automated monthly Income statement, cash flow statement & balance sheet
  • Includes quarterly & annual totals
  • Number of weeks that are included in each quarter can be specified by user
  • Accommodates loan amortization or interest-only loans
 
    weekly cash flow model weekly cash flow weekly cashflow template excel weekly  
  Return to Top File Size: 223KB File Size: 92KB File Size: 554KB File Size: 141KB ZAR300 ($29 £17 €21)  
 
  • 18 Monthly Cash Flow - Forecast vs Actual Template
This template enables users to create a monthly cash flow forecast for any three year period and to compare the cash flow forecast to actual account balances. The cash flow forecast is created in exactly the same way as in the monthly cash flow projection template. Actual income statement and balance sheet account balances need to be entered and a unique, innovative management report can then be used to compare the forecasted and actual account balances on a monthly and year-to-date basis. The report includes an income statement, cash flow statement and balance sheet for both the cash flow forecast and the actual results and can be updated by simply selecting a month from the list box at the top of the sheet.
  • Includes the following features:
  • Suitable for any business
  • Includes 36 monthly periods
  • Reporting periods based on a single user input cell
  • Cash flow forecast automatically compiled from basic user assumptions
  • Actual balances can be entered or copied from our accounting templates
  • Expense accounts can be customized and additional accounts can be added
  • Includes monthly income statements, cash flow statements & balance sheets
  • Unique management report for comparing forecasted and actual results
  • Management report includes monthly and year-to-date totals
 
    excel cash forecast excel cash flow projections excel cash projection excel cashflow projections  
  Return to Top File Size: 328KB File Size: 138KB File Size: 491KB File Size: 184KB ZAR300 ($29 £17 €21)  
 
  • 19 Weekly Cash Flow - Forecast vs Actual Template
This template enables users to create a weekly cash flow forecast for any 52 week period and to compare the forecast to actual account balances. The cash flow forecast is created in exactly the same way as in the weekly cash flow projection template. Actual income statement and balance sheet account balances need to be entered and a unique management report can then be used to compare the forecasted and actual account balances on a weekly, quarterly and year-to-date basis. The report includes an income statement, cash flow statement and balance sheet for both the cash flow forecast and the actual results and can be updated by simply selecting a weekly period from the list box at the top of the sheet.
  • Includes the following features:
  • Suitable for any business
  • Includes 52 weekly periods
  • Reporting periods based on a single user input cell
  • Cash flow forecast automatically compiled from basic user assumptions
  • Actual balances can be entered or copied from our accounting templates
  • Expense accounts can be customized and additional accounts can be added
  • Includes weekly income statements, cash flow statements & balance sheets
  • Unique management report for comparing forecasted and actual results
  • Management report includes weekly, quarterly and year-to-date totals
 
    excel cash projection excel weekly cash flow forecast actual weekly cash flow excel forecast versus actual weekly  
  Return to Top File Size: 364KB File Size: 147KB File Size: 854KB File Size: 220KB ZAR300 ($29 £17 €21)  
 
  • 20 Cash Flow Statement Template
This template enables users to automatically compile a complete cash flow statement by simply entering basic income statement and balance sheet information. The template incorporates a current and comparative financial period and produces a cash flow statement in accordance with international accounting standards. The template is the ideal solution for accountants and financial managers and is guaranteed to save users a lot of time when compiling cash flow statements. The instructions cover each line item that is included on the cash flow statement and also assists users in developing an improved understanding of the calculations that need to be performed in order to compile a cash flow statement.
  • Includes the following features:
  • Suitable for any business
  • Simple layout for entering income statement & balance sheet information
  • Cash flow statement produced automatically from user input
  • Includes comparative year
  • Detailed explanation of all cash flow statement calculations
  • Includes cash flow statements for both direct and indirect methods
 
    cashflow statement template excel cash flow statement cash flow statement template excel cashflow statement  
  Return to Top File Size: 107KB File Size: 47KB File Size: 140KB File Size: 61KB ZAR250 ($24 £14 €18)  
 
  • 21 Cashbook & Bank Reconciliation Template
This template enables users to record deposit and withdrawal transactions for multiple bank accounts and automatically produces a monthly cashbook report and a bank reconciliation. The cashbook report can be compiled for any 12 month reporting period by simply entering the appropriate start date in a single input cell and the report can be viewed on an individual account or consolidated basis. The 30 default accounts that are included on the report can be customized and an unlimited number of additional accounts can be added if required. The template also accommodates petty cash transactions and sales tax calculations. Refer to our Excel Accounting templates if you require a comprehensive monthly accounting solution.
  • Includes the following features:
  • Suitable for any business
  • Record cashbook transactions for multiple bank accounts
  • Accommodates sales tax calculations and petty cash transactions
  • Customize default accounts and create unlimited additional accounts
  • Produces an automated monthly cashbook report for any 12 month period
  • Reporting period can be rolled forward or back by changing a single date
  • View report per individual bank account or consolidated
  • View report for only deposits or only withdrawals or all transactions
  • Includes an automated bank reconciliation
  • Reconciliation can be rolled forward or back by changing a single date
 
    cash flow template excel cash flow excel bank recon bank reconciliation  
  Return to Top File Size: 211KB File Size: 84KB File Size: 281KB File Size: 107KB ZAR300 ($29 £17 €21)  
 
  • 22 Petty Cash Template
This template enables users to control the expenses that are paid through any petty cash or cash float system. All petty cash expenses and reimbursements can be recorded by entering the appropriate transactions details and a monthly petty cash report is automatically produced. The monthly report includes a 12 month summary of expenses by account and also calculates the petty cash or cash float balance at the end of each monthly period. You can add as many accounts as required and the report can be rolled forward for subsequent periods by simply amending the start date of the report. The template also includes a general ledger journal summary which enables users to easily record petty cash or cash float expenses in any primary accounting system.
  • Includes the following features:
  • Suitable for any petty cash or cash float system
  • Record petty cash expense and reimbursement transactions
  • Produces an automated monthly petty cash expense report
  • Customize default accounts list and create additional accounts
  • 12 Month reporting period can be rolled forward by changing a single date
  • Automated calculation of monthly petty cash or cash float closing balance
  • Produces an automated general ledger journal summary
  • Automated calculation of sales tax on all petty cash transactions
 
    petty cash template excel petty cash cash float template excel cash float  
  Return to Top File Size:139KB File Size: 57KB File Size: 186KB File Size: 72KB ZAR250 ($24 £14 €18)  
  This page lists all our Excel Cash Flow templates. Our 40+ unique templates are listed on the following template pages: