 |
 |
|
|
The Client Aged WIP report is a Time Ledger report that groups current WIP balances into user defined ages at client at level.
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 Aged WIP report complete the options, order, selection and columns tab in sequence. (See reporting formats topic).
To access the Client Aged WIP report:
Log into the Time Ledger.
From the menu select Reports.
Click .Client reports
Select Aged WIP.
The options screen allows you to define the system constraints for the Client Aged WIP report.
The following options are available:
The 'Age in' option controls the way the WIP balances are going to be aged. First, select one of the format of aging (by either period, months, or days), then enter in the three fields available how to group the aged WIP. Click here for further details of how these three fields operate
Select one of the following options:
Periods from selected period
Select Periods from selected Period and the 3 fields to the right become available. In each field enter a number to determine how the WIP figures are going to be aged. For example, 1,2,3.
Click here for further details.
The period that the aging will commence is dependant on the selection entered within the date / period to age from section. For example, WIP can be aged by either the current Time Ledger period, or by entering a previous period.
To include a WIP balance column ensure WIP is aged by periods from selected period.
Calender months from date
Select Calender months from date and the 3 fields to the right become available. In each field enter a number to determine how the WIP figures are to be aged. For example, 1,2,3.
By selecting this option, the aging of WIP balances will be grouped into the calender month the postings was made into. For example, group unmatched WIP into January, February, March
Click here for further details.
The month that the aging will commence is dependant on the selection entered within the date / period to age from section. For example, WIP can be aged from todays date, or from a historical month.
Days from date
Select Days from date and the 3 fields to the right become available. In each field enter a number to determine how the WIP figures are going to be aged. For example, 30,60,90.
By selecting this option, the aging of WIP balances will group into the days from date the . For example, group unmatched WIP by 30 days, 60 days and 90 days, regardless of the month the days lay in.
The aging will commence upon the selection entered within the date / period to age from section. For example, WIP can be aged from todays date, or from a historical date.
The exclude option omits client to produce a more concise report.
The following options are available:
Any Line where all amounts are zero
Select this option to exclude the clients without any WIP in the aging fields.
Accounts with balance less than
Select this option and the field to the right become available, here you can enter the value of WIP. Any client with a WIP balance less than this value will be excluded.
This exclude option refers to the value on the balance column for each client. This balance column (and so this exclude option) is not available when the report is run historically for calender month or period.
Accounts with zero balance
Select this option to exclude clients with a zero WIP balance. The WIP balance figures are taken from the WIP balance column.
This exclude option refers to the value on the balance column for each client. This balance column (and so this exclude option) is not available when the report is run historically for calender month or period.
Lines with no entries before column (2-4)
If you select this option the field to the right becomes available, where the number of a column can be enter (2-4).Lines with no entries before this column will be excluded.
Type 2 to exclude all client with a zero WIP balance in column 1 of the Aged report
Type 3 to exclude all client without a WIP balance in either columns 1 & 2 of the Aged WIP report
Type 4 to exclude client without a balance in columns 1,2, or 3 of the Aged WIP report
Click here for further details on the columns of the Aged WIP.
The aged / Period to age from option is used to set when the aging is going to begin. This can be set to display the aging of WIP upon up-to-date figures, or upon an alternate period or date.
Use Current Period or today
Select this option to display up-to-date aging of WIP balances. If you are aging by period (see age in section) the aging of WIP will be based upon the latest current Time Ledger Period
If you are aging by calender months from date, or days from date, (see age in section) the aging of WIP will be based upon the date the report is running.
Supply a period or date
Select this option to start the aging of WIP from a specified date or period.
If you are aging by period (see age in section), select the period you would like to commence the aging from
If you are aging by either calender month, or days from date (see age in section), enter the date the aging to begin
If you have supplied a date for historical aging, the WIP balance column cannot be displayed.
The detail option relates to the first sort criteria that is selected under the Order tab.
On the Client Aged WIP report there are two options:
Normal
Each client that satisfies the Selection criteria will be displayed on a separate line on the report.
Summary 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 Order tab. For example, if the first sort criteria selected was Partner, 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.
If you select Summary subtotals only, only include Columns that can be added up (i.e. those that contain figures). See the Columns section of this topic for more information, columns that can be added up are marked with a *.
To continue to reporting topic click on the Order Tab at the top of the screen, and here for the topic on using the Order tab settings.
Client Aged WIP reference
Reporting Overview
Reporting Format
Recommended reports
Memorised reports