![]() |
The Job Partner / Staff outstanding WIP report is a Time Ledger report that displays WIP balances at job 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 Job Partner / Staff Outstanding WIP report complete the options, order, selection and columns tabs in sequence. (See report format topic).
To load the job partner / staff outstanding WIP report:
Log into the Time Ledger.
From the menu click Reports.
Click Job reports, a submenu displays.
Click Partner / Staff Outstanding WIP report.
The Options screen allows you to define the system constraints for the Partner / Staff Outstanding WIP report.
The following options are available:
Select one of the three options below to display the WIP balances as at period end, a select period, or a date range:
End of current Period - select to display the job WIP balances for the latest current.
Selecting this option for a memorised report will always show the latest WIP balance details.
End of period - select and the field to the right will become available. Type in a period number in the space available to display job WIP balances up until that period.
This option is often used to display historical WIP balances.
Date - click and the field to the right will become available. Type in the calender date in the space available to display WIP balances up until that date.
This option will not show historical WIP balances. WIP balances displayed will show items that are currently unmatched but were posted before the date entered.
The Level of detail option relates to the first sort criteria that is selected under the Order tab. On the Job Partner / Staff Outstanding WIP report there are two options:
One line per account - each job 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 (that is, 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 omit job accounts from the report select from either of the two options below:
Exclude accounts where all figures are zero - select to exclude jobs that do not have any WIP balance. For example, if a client does not have a balance for either partners or staff postings.
Exclude accounts with a zero WIP balance - select to exclude jobs with a zero WIP balance.
The difference between these options are the 'exclude accounts where all figures are zero' can include clients with a zero WIP balance. For example, if partner time is £200 and staff time is -£200 then the job has WIP balances, but the overall WIP balance is zero.
To continue the Partner / Staff Outstanding WIP reporting topic click the Order tab at the top of the screen, and here for the topic for using the order tab settings.
Job Partner / staff outstanding WIP report reference
Reporting Overview
Reporting Format
Recommended reports
Memorised reports