 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
|
This page lists our Excel Cash Flow templates. Our
40+ unique templates are listed on the following 6 template category pages:
|
|
- 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.
- 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 GST, income tax, payroll accruals & dividends
- Includes calculation of key financial ratios
|
- 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.
- 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 GST, income tax, payroll accruals & dividends
- Includes calculation of key financial ratios
|
- 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.
- 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
- Includes GST, income tax, payroll accruals & dividends
- Automated monthly Income statement, cash flow
statement & balance sheet
- Accommodates loan amortization or interest-only
loans
|
- 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.
- Includes the following features:
- Suitable for any business
- Includes 52 weekly periods with quarterly & annual totals
- 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 GST, income tax, payroll accruals & dividends
- Number of weeks that are included in each quarter can be specified by user
- Accommodates loan amortization or interest-only
loans
|
- 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.
- Includes the following features:
- Suitable for any business
- Includes 36 monthly periods
- 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
- Includes GST, income tax, payroll accruals & dividends
- Unique management report for comparing forecasted
and actual results
- Management report includes monthly and year-to-date
totals
|
- 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.
- Includes the following features:
- Suitable for any business
- Includes 52 weekly periods
- 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
- Includes GST, income tax, payroll accruals & dividends
- Unique management report for comparing forecasted
and actual results
- Management report includes weekly, quarterly and year-to-date
totals
|
- 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.
- 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
|
- 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.
- 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
|
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
|
|
This page lists our Excel Cash Flow templates. Our
40+ unique templates are listed on the following 6 template category pages:
|
|
|
|
|
|
|
|
|
|
|
|
|