|Daily Cash Flow Spread Sheet:
are picture example links to the following:
Fixed Costs, Forecast
Sales Setup, Calendar
- Shows your daily balance at the
- Each cell works like Microsoft
Excel. Figures can be entered or removed directly on the
worksheet for convenient day by day, week by week or month by
- Fixed Costs -
Customized to your companies estimated costs in an easy to use
form. Enter either an amount or a percentage of sales with
a selection of Daily, Weekly, Monthly
or Once off, payment
choices and a frequency modifier for Bi-Monthly or other
- Creditors take on -
Your companies existing creditors when the Programme is first
started with a choice of Monthly percentages of creditors
payable or individual creditors entered separately or a
combination of both.
- Monthly Purchases Budget
- Creates a Purchasers Budget depending on your monthly or
yearly gross profit. Automatically calculated from your sales
forecasts, capable of being individually changed.
- Requisition - Actual
purchases entered with an easy to use Purchases Requisition form
or can be entered as a total for the month, or through an
individual creditors form. Automatically deducts actual
purchases from the purchases budget leaving an "open to
buy" amount. The Programme automatically flags a warning if
actual purchases exceed budgeted purchases.
- Debtors Take On - Your
companies existing Debtors, taken on when the Programme is first
started. Automatically calculates the correct collection figure
based on ageing - current, 30 days, 60 days etc. A choice of
entering either as a monthly percentage or individually or both.
- Debtors - Individual
debtors entered, will automatically be deducted from the balance
of Sales Forecast for that month.
- Forecast Sales -
Your Budget of Debtors sales Figures for coming months, entered
in an easy to use sales forecast form.
- Cash Sales -
Expected monthly cash sales entered as a choice of Daily,
Weekly or Monthly.
- Calendar - An easy
to set up calendar, blanking out, at your choice, any days of
the week, holidays, or days when your business is closed. No
figures will be put on the spread sheet on these selected days.
- Totals - Monthly
totals of all expenses and incomes.