 |
 |
|
|
This view represents the recovery on staff time as a result of billing. There is one row per combination of original bill and staff member whose time is written out by it.
The view also includes write off postings and write back postings (the latter of which may be as a result of credit notes).
Year and period in this view represent the time ledger periods in which the actual write out/off/back postings occur, not the periods in which the original WIP was incurred. The posting may occur in a later period than the original billing (or write off) instruction if, for example, later manual matching is done.
Figures for this view are the result of apportionment, and hence are subject to rounding errors. It therefore does not follow that adding up the individual amounts for a bill will get back to the original bill total. Apportionment arises:
As the billed amount on the original instruction is apportioned across multiple write outs according to the magnitude of the write out. (This will only occur if extra matching is done after the initial bill is executed. The corollary of this is that matching in a later period will change the view of profitability in the earlier period.)
As (already apportioned) billed amount on the posting is apportioned across the staff members whose time is written out (according to the amount of time written out to each). This apportionment is by WIP value, rather than time measured in minutes.
Pending postings are not included in the results.
Cancelled and contra postings are included in the results. This is primarily because the contra may be in a different period to the cancelled posting, and the cancelled posting might have been included in last month's figures before it was cancelled. If we now didn't show the contra it would be difficult to reconcile.
This view is restricted to the latest closed ledger period plus earlier periods in same ledger year.
Type = End user business view, incorporating business logic
Inherits columns from view ibvStaffCategorisation plus:
JobInternalId |
The internal identifier of the client job that the posting is for. |
Year |
The time ledger year in which the write out/off/back posting is made |
Period |
The time ledger period within year in which the write out/off/back posting is made |
Posting |
The posting number of the write out/off/back posting within time ledger year and period |
Date |
The date of the write out/off/back posting |
Type |
The type of the write out/off/back posting (see idvTimePostingType) |
PostTypeDesc |
The type of the write out/off/back posting in human readable form |
Contra |
'Y' if the posting is a contra. This allows you to distinguish between a bill and a bill cancellation for example (other than by the sign of the amount). |
Reference |
Any reference on the posting |
Narrative |
Any narrative on the posting |
TotalWriteOut |
The write out/off/back posting amount as credit positive (i.e. a write out or off is positive, a write back is negative) |
TotalMatched |
The amount currently matched to the write out/off/back posting (same sign convention as the posting amount) |
TotalBilled |
The billed amount currently matched to the write out/off/back posting (same sign convention as the posting amount). This is derived from the originating instruction, apportioned by write out value if there is more than one write out. |
StaffPostingAmount |
The total posting amount of staff postings matched to this write out/off/back. In general this column is best regarded as documentary, since each of these postings could, in principle, be matched to other write outs. |
StaffMatched |
The amount of WIP matched from this write out/off/back to postings for this staff member. This is positive for a normal write out, but will be negative for a cancellation. |
StaffBilled |
The apportioned billed amount for postings for this staff member (apportioned according to the amount written out to that staff member). This is positive for a bill, negative for a credit note. |
StaffRecovery |
The apportioned billed amount less the time written out. Zero is neutral recovery, positive is profit beyond that built into charge rates, negative is eating into the charge rate profit. |