Business View ibvFeesAndWIPTotals

Description

This view shows the summary movement and the balance figures by client and period covering both the WIP and fees information.

Views that combine fees and WIP information on a period basis only make sense if the periods on the time and fees ledger are aligned (i.e. there are the same number of periods per year on the two ledgers and the start and end dates of the periods on the two ledgers are the same).

For the variants of such views that are restricted by period (i.e. current, latest closed etc) it is the TIME ledger period status that is used. Thus, if the time ledger period has been closed, but the corresponding fees ledger one has not, the information presented will be the current information for that fees period.

You should also note that the information is associated with periods according to the individual postings on the ledgers. Thus if you post an invoice to (e.g.) period 2 on the fees ledger, but it actually writes out to period 3 on the time ledger, the fees invoicing details will appear under period 2 and the billed totals for WIP under period 3.

 

There are several ways that this can happen, for example:

If there is period alignment and most fee processing is straight forwards then it will normally be the case that the WIPBilled and InvoicedExVAT figures will be the same. This is not necessarily always true however. Obvious circumstances that can give rise to a difference are:

For use by

This view is suitable for any user wanting access to the time and fees totals.

 

Columns

ClientObjectType

The object type of the client job that the balance is for. (Person, Business or Trust).

ClientInternalId

The internal identifier of the client job that the balance is for.

Year

The year that the figures apply to (see notes above on the correspondence of periods on the time and fees ledgers).

Period

The period within the year that the figures apply to (see notes above on correspondence of periods on the time and fees ledgers).

InvoicedExVat

The invoiced total on the fees ledger with VAT elements removed. This is credit negative under fees ledger conventions - i.e. an invoice is positive.

Invoiced

The invoiced total on the fees ledger inclusive of VAT. This is credit negative under fees ledger conventions - i.e. an invoice is positive.

CreditNotesExVat

The credit note total on the fees ledger with VAT elements removed. This is credit negative under fees ledger conventions - i.e. a credit note is negative.

CreditNotes

The credit note total on the fees ledger inclusive of VAT. This is credit negative under fees ledger conventions - i.e. a credit note is negative.

Cash

Net cash flow on the fees account in the period. This is credit negative, so that a receipt appears negative.

There is no VAT information for receipts since it is not guaranteed that VAT information will be entered on posting.

OtherFees

This column totals any other postings made to the fees account in the period (credit negative). Examples of such postings are write offs and explicitly posted opening balances.

WIPAdded

The amount of WIP added during the period, credit negative (outstanding WIP appears positive).

WIPWrittenOut

The net amount of WIP written out by billing during the period, credit negative (outstanding WIP appears positive so billing (write out) is normally negative).

WIPWrittenOff

The net amount of WIP written off during the period, credit negative (outstanding WIP appears positive so write offs are normally negative).

WIPAdjusted

The total of other adjustments to WIP during the period, credit negative (outstanding WIP appears positive).

Examples of such adjustments are carried forwards over or under recoveries or over under recovery adjustments arising from credit notes.

WIPBilled

The billed amount logged against the time ledger for this period. This is ex VAT and reflects the total billed amount logged on time ledger instructions for that period (irrespective of how the actual WIP write out is split across periods).

The sign convention is that a normal bill posts as a positive amount to this figure.

See notes above with respect to the correspondence of this amount with the ex VAT invoiced amount from the fees ledger.

WIPCreditNote

The credit note amount logged against the time ledger for this period.

This is ex VAT and reflects the total credit note amount logged on time ledger instructions for that period (irrespective of how the actual WIP adjustmen is split across periods).

The sign convention is that a normal credit note posts as a negative amount to this figure.

FeesBalance

The balance on the fees ledger as at the end of the period (credit negative).

This is a VAT inclusive balance (see notes).

WIPBalance

The balance on the time ledger as at the end of the period (credit negative).

 

This view is directly inherited by the following views: