• 16 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, operating expenses, 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.

• 17 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.

• 18 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.

• 19 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.

• 20 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.

• 21 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.

• 22 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.

• 23 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.

• 24 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.