 |
 |
|
|
The Client WIP items report is a Time Ledger report displays WIP postings, producing a separate page per client.
To access reports ensure that the staff allowances 'can see WIP valuations of Time' and 'see Cost Valuations of Time' are enabled.
To produce a client WIP Items report complete the options, order, selection and columns tabs in sequence. (See report format topic).
To access the Client WIP items report:
Enter the Time Ledger.
From the menu select Reports.
Click Client reports, a sub menu displays.
Click WIP items.
The Options screen allows you to define the system constraints for the Client WIP items report.
The following options are available:
Select one of the following options to set the timescale for the Client WIP items report:
Outstanding items only - by selecting this option, the Client WIP items report will only display items that are unmatched.
Click here for the reference for Time Ledger matching.
Current Periods - when this option is selected posting made between the earliest and latest current periods will be displayed.
Click here for the reference for Time Ledger Periods.
Last periods up to - if you select this option the field to the right becomes available. Here you can enter the number of periods (prior to the most current period), that you wish to run the report for.
For example, if the number 2 is entered into the field, postings made into the current period and its preceding period will be displayed.
The minimum number of periods to be covered is 2.
Time Periods From - if this option is selected the fields 'from' and 'to' become available. Here you can enter the start and end of a period range that the report is to be run for.
Dates From - if this options is selected the fields 'from' and 'to become available. Here you can enter the start and end of a period range that the report is to be run for.
The following options are available:
Exclude clients with no items - exclude clients with no items all accounts that have not been posted to will be excluded from the report.
This option refers to clients not have any WIP postings within the timescale set in select WIP items.
Exclude clients with zero balances - exclude clients with zero balance, clients with a zero balance will be excluded.
This option will exclude clients with a zero WIP balance set in select WIP items.
Include Time - select to Time to include Time postings.
Includes Expenses - select to Expenses to include Expense postings.
Show subtotals only - every client that satisfies the Selection criteria will be included in the report. The information will be subtotalled by the first sort criteria selected under the Within client sort WIP items. For example, if the first sort criteria selected was Jobs, the values for all clients a partner is responsible for will be added together for each Column included on the report. One line of totals would then be printed for each of the partners registered on the system.
This section is used to defined the sorting of information that will be displayed on the report.
On the left of the screen, items suitable for sorting the report by are listed (the sort options differ between the reports, depending on the report subject matter).
When selecting the items you would like to Sort by, it is important to remember the order that the items are ticked will be the order of the sort. A good starting point is to remove all the ticks on the left of the screen before selecting the sort items.
For example, to group all the postings on the report by the staff identifier, place the first tick in Staff Identifier. This will be displayed on the display in the centre of the screen.
It is possible to sort the clients further within each staff identifier list, to achieve this tick a second sort item such as posting date. The posting date will then be displayed under Staff Identifier in the centre of the screen.
Be careful not to sort by too many items, also check the order the report will be sorted by looking at sort order on the right side of the screen.
A good rule to follow is to Sort by the item there are fewest of in the system first, up to the item there are most of in the system last, for example (the number in brackets shows the number of that item registered in the system):
First Sort: Partner (3)
Second Sort: Manager (6)
Third Sort: Client Name (1527)
This will provide you with a sensible report output.
The items selected to sort by have not relation to the information included in the report, this is defined under the Columns tab. You may sort by items that will not be included under the columns (for example, you may want to group clients by Partner responsible, but not include the partner column on the report).
On the right of the screen is the Sub-totals by column. Here it is possible to generate a subtotal for any item you have selected on the left of the screen under Within Client Sort WIP items by. The exceptions to this are the items such as date, because these are unique a subtotal for each would be unnecessary.
Usually a subtotal is not needed by the first item that has been Sorted by, be careful not to Sub-total by more than two items, this could create a confusing report (the system will warn you if this is likely).
If show subtotals only has been selected within the options section, only the lines containing the subtotal information for the first item you sort by will be included on the report. For example, if Job Type is selected as the first item within the Client Sort WIP items by section, job type is ticked within the Show sub-totals only section, and show subtotals only is selected within the options section, then one line will be included on the report for each job showing a subtotal of WIP.
To continue the Client WIP items reporting help topic click on the order tab at the top of the screen, and here for the topic for using the order tab settings.
Client WIP items reference
Reporting Overview
Reporting Format
Recommended reports
Memorised reports