Fee Schedules

Purpose

This option allows a draw down schedule of dates and values to be entered for all tasks which are marked as invoiced using a fee schedule.

Use this option to:

▪Enter monthly fee values to be invoiced

▪Slip or advance the schedule

Operation

The initial page shows the current fee schedule for a three years from the start of the project. The span of the date range is fixed to three years, to access dates beyond three years, change the date and refresh the grid.

The list shows the following information:

Total Fee	Total fee entered for the task
Remain	Remaining fee left to schedule
Monthly schedule	The monthly schedule for each task and month. Cells shaded light blue indicate the duration of each task, ie the month lies within the target start and finish dates entered for the task. You are not restricted to these cells – you can entere monthly fees anywhere in the grid.
TOTALS	The totals for all tasks
INV	The total fee amounts invoiced
COSTS	The total time and expense costs spent

To enter data, click on the cell relating to the month and task you want to enter data for.

There are two ways to enter the monthly values:

▪As a lump sum per month and number of months (ie. £2,000 for 5 months)

▪As a total amount and number of months to spread (ie. £10,000 over 5 months)

Monthly Entry Option

Using this option you enter the amount you want for each month and the number of months to enter it for.

For example,

£5,000 for 5 months would enter £25,000 in total.

If the total fee available was less than the amount required, the remaining months would contain the remaining.

e.g. If only £21,000 was available and you entered £5,000 for 5 months you would get:

£5,000, £5,000, £5,000, £5,000, £1,000

The only cells edited are those within the span you’ve selected (5 in the above example)

Spread Total Option

Using this option you enter the total amount to spread and the number of months to spread it over. The total amount will be equally apportioned over the months, with any remaining pennies added to the last month.

For example,

£4,000.00 over 3 months will give £1,333.33, £1,333.33, £1,333.34

Selecting the Remaining Fee option will spread the remaining fee calculated from the cell you clicked in and spread that over the required number of months. This will first DELETE any existing schedules later than your starting month, and re-spread accordingly.

Slipping and Advancing

This option allows you to quickly slip or advance payments for one selected task or all tasks.

Slip means delay the payment to a later date.