Standard Reports

Delivery Advice

The delivery advice report displays information about vehicles on order in a format that is suitable for sharing with clients.

It is grouped and sorted by Client, Division, Cost Centre and Registration.

Report Filters

Supplier - the report can be limited to displaying Fuel information for one supplier.
Manager - each client is allocated to an A/C Manager in the Clients / Contact screen. Thus, A/C Managers can run a particular report for all the clients they manage.
Client Group - the report can be limited to select only Clients from a particular Group.
Client - the report can be limited to select only a particular Client.
Division - the report can be limited to select only a particular Division.
Cost Centre - the report can be limited to select only a particular Cost Centre.
Contract Type - the report can be limited to select only a particular Contract Type.
Page Break - check ON or OFF to incorporate Page Breaks.

Report Content

Group Name
Client Name
Client Code
As at Date
Contract ID
Driver Name
Description
Colour
Date Ordered
Expected Delivery
Supplier Name
Comments (shows Vehicle Options)

Depreciation

The depreciation report calculates an assets depreciation using the diminishing value method or the prime cost method (straight line).

It is grouped by Group, Client and Cost Centre.

It is sorted by Cost Centre and Registration.

It is totaled by Cost Centre, Client, Group and Grand Total (all clients).

The Cost Centre that is used for grouping is the one that is active on the contract when the report is run. I.e. the current cost centre is always used.

The report can also be generated at Contract level on the Contracts / Finance page.

The calculations used in the report are shown in the attached spreadsheet.

NOTE: Depreciation calculations will cease when a Sold Date is entered in Contract screen or on the Detail screen for Sale Management.
This report is accessible by Admin and senior_manager roles only.

Report Filters

Date to - defaults to today's date. This can be edited. The report start period is one day after the clients Financial Year End from the Clients / Contact screen
Client Group - the report can be limited to select only clients from a particular group.
Client - the report can be limited to select only a particular client.
Cost Centre - the report can be limited to select only a particular Cost Centre.
Contract Type - the report can be limited to select only a particular Contract Type or a range. Use the SHIFT key to select a range, or the CTRL key to select non-adjacent entries.

NOTE: Contracts where Depreciation Start date is greater than report date (Date to) will not appear in report.

Data Selection

All vehicles active at any point in the report date range are selected (see report filters above).

Report Content

Report Field	Screen Field	Screen	Comments
Report Date (Start)	Financial Year End	Clients/Contact	July is assumed to be the start of the Depreciation Period if "Financial Year End" is blank for the selected client. This will use the July or month after "Financial Year End" that precedes the entered "Date To". E.g. if 30/06/2011 is entered as "Date To", the Report Date (Start) will be 01/07/2010.
Report Date (End)	Date To	Standard Reports/Depreciation	Date entered in report screen.
Group Name
Client Name
Client Code
Contract ID	Contract ID
Rego	Reg Number	Contracts/Contract
Asset No	Asset No	Contracts/Contract
Financier	Financier	Contracts/Finance	Located at the top left of the screen.
Finance Ref	Finance Ref	Contracts/Finance	Located at the top left of the screen. Depreciation Start Depreciation Start Contracts/Finance
Depreciation Start	Depreciation Start	Contracts/Finance	If this field is blank, the report will display the "Depreciable Amount" of the contract, but no depreciation will be calculated. If the date is after the "Date To" of the report, the contract will not appear on the report.
Depreciable Amt	Depreciable Amount	Contracts/Finance	Located on the bottom left of the screen.
Method	Depreciation Method	Contracts/Finance	Located at the top right of the screen.
Days
Rate	Depreciation Rate	Contracts/Finance	Entered value located at the top right of the screen.
Depreciation			Calculation of the depreciation that falls within the report's Date Range.
Book Value			Calculated value of the Book Value for the Report End Date. (Opening WDV - Depreciation = Book Value)
Sold Date	Sold Date	Contracts/Contract	If a "Sold Date" is entered, the report "Days" and "Depreciation" values are reduced accordingly.
Sale Price Net	(Sale Price - GST)	Contracts/Contract	Displays the calculated net sale value of a sold vehicle.
Profit/Loss			Displays the calculated Profit/Loss of a sold vehicle. (Sale Price Net - Book Value)

Outputs

The report can be output as PDF, XLS or CSV.

Leased Vehicle

Use this report to get a summary of vehicles that includes their estimated end of lease (EOL) odometer value.

Vehicles forecasted to travel below or beyond a specified variance are highlighted in the PDF report.

The default variance for highlighting is + 5,000 Km. This can be changed by Catch-e support staff.

It is grouped and sorted by Client, Division, Cost Centre and Registration.

Report Filters

Filter	Type	Description
Column One
As at date	Date	Populated with the last day of the previous month by default. Change this by editing the date or using the Calendar picker to choose a new date. Contracts that start on or before this date are included in the report. Contracts suspended on or before this date are excluded.
Manager	Lookup	Use the lookup to select a user. Reports will only generated for clients where this user is recorded as their Clients / Contact "A/C Manager". An Account Manger can use this field run reports for all the clients they manage.
Client Group	Text	Enter or lookup the "Group code" to report on. Leave this field blank to report on all contracts.
Client	Text	Enter or lookup the "Client Code" to report on. Leave this field blank to report on all contracts.
Division	Text	Enter the Division you want to report on. Leave this blank to report on all contracts.
Cost Centre	Text	Enter the Cost Centre you want to report on. Leave this blank to report on all contracts.
Contract Type	Lookup	Enter or lookup the Contract Type you want to report on. Leave this blank to report on all contracts.
Report Queue	Check box	Uncheckecd by default. The report will be generated for you on this screen for downloading when complete. Select this checkbox if you want to send the report to the Report Queue screen to be downloaded later. If configured, you will receive an email when the report has been processed and is ready to be downloaded. If the report take takes a long time to run and exceeds the allowable time, then the report will be sent to the Report Queue. You will be alerted if this is going to happen.
Column Two
Page Break	Check box	Check on page break if you want to add a page break to the PDF report on the filter. E.g. Division, Cost Centre

Output Options

Select from PDF, Office(xlsx) or Text(CSV).

If an Office(xlsx) report is generated and contains more than 65,500 individual rows, then it will be automatically converted to Text(CSV) format.

Action Buttons

Button	Description
Print Button	Select the report output you want and then click to print.
Cancel Button	Cancel to discard a report you have started to print.

Report Content

Group Name
Client Name
Client Code
At Date
Division
Cost Centre
Reg No
Asset Number
Driver Name
Description
Contract Start
Contract End
Term/Kms
Months Remaining
Latest Odometer Reading (over the contract life)
Estimated EOL Odo (go to Estimated Odometer Calculation for details of the three calculations we use to produce this value)
State (XLS or CSV output only)
Contract Type (XLS or CSV output only)

Highlighting

If Estimated EOL Odo exceeds the allowable variance, then the Estimated EOL Odo value will be highlighted. Contract Kms + 5,000 is the default allowable value.

If the vehicle does not have enough odometer readings to calculate an Estimated EOL Odo, the Contract km method is used. This reflects the Contract Kms and no highlighting will occur in these cases.

Set-up Notes

Setup / Reference Data → gb_controls

Module

Name

Comment

Default Value

excess_km_limit

Used to identify vehicles for review on the Leased Vehicle Report.

Vehicles are highlighted if the difference between the "Contract Kms" and the "Estimated EOL Odo" is greater than the limit set here.

Update the value to suit your business as required.

5000