Job WIP Balance Report (Options)

The Job WIP balance report is a Time Ledger report that displays WIP balances at client 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 WIP balances report complete the options, order, selection and columns tabs in sequence. (See report format topic).

To load the Job WIP Balances report:

Log into the Time Ledger.
From the menu select Reports.
Click on Job reports, a sub menu displays.
Click WIP balances.

The Options screen allows you to define system constraints for the WIP balances report.

The following options are available:

Omit Accounts with Net WIP Balance less than...

If you select this option the field to the right becomes available, here you can enter a value of WIP. Any client job with a Net WIP less than this value will be excluded from this report.

If you enter 0.01 in this field, all credit balances will also be excluded from the report. If you only want to exclude zero balances do not select this options but select Omit accounts with zero WIP balance (see below).

Omit Accounts with Zero Net WIP Balance

By selecting Omit accounts with zero net WIP balance all job accounts with a net WIP balance which is not zero (the balance may be debit or credit) will be included (providing the option to Omit accounts with net WIP balance less than... is not selected).

Omit clients with net WIP balance less than...

By selecting this option the field to the right becomes available, where a value of WIP can be entered. Any client with a Net WIP less than this value will be excluded from the report.

If you enter 0.01 in this field, all credit balances will also be excluded from the report. If you only want to exclude zero balances do not select this options but select Omit accounts with zero WIP balance (see below).

Level of Detail

The Level of detail option relates to the first sort criteria that is selected under the Order tab.

On the Client WIP Balances report there are two options:

One line per time account

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 sub totalled 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.

Balance/Year To Date

The Job WIP Balances report can be run for all WIP currently on the Time Ledger or WIP at a certain period end.

If the option Up to date (period) is selected, WIP values at the moment will be reported on, if As at end of period is selected WIP at the end of the selected period will be included in the report, all WIP or instructions posted in later periods will be excluded.

To change the period end at which WIP is being reported, on this screen either:

Select As at end of period.
Type the year and period identifier in the field.

or, if the period is not know:

Select As at end of period.
Click the magnifying glass to the right of the field.
Highlight the period you would like to use.
Click Select.
It is important you do not click OK at this point, doing so will run the report with the options you have set on this page and those retained from the last time the report was run for the other pages.