LOADING
   
   
  View Special Offer View membership fees  
  This page lists all our Excel Cash Flow templates. Our 30+ unique templates are listed on the following template pages:  
 
  • 13 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
  • User input limited to basic template assumptions
  • Expense accounts can be customized & additional accounts can be added
  • Includes 12 monthly & 5 annual periods
  • 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)  
 
  • 14 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
  • User input limited to basic template assumptions
  • Expense accounts can be customized & additional accounts can be added
  • Includes 5 annual periods
  • 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 €17)  
 
  • 15 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
  • User input limited to basic template assumptions
  • Expense accounts can be customized & additional accounts can be added
  • Includes 36 monthly periods that are based on a user defined start date
  • 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 €17)  
 
  • 16 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
  • 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 36 monthly periods that are based on a user defined start date
  • 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)  
 
  • 17 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 €17)  
 
  • 18 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)  
 
  • 19 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 €17)  
  This page lists all our Excel Cash Flow templates. Our 30+ unique templates are listed on the following template pages: