This view presents summary movement and balance figures by client and period covering both WIP and fees information for the latest close period plus all periods up to that one in the same year with comparative from the previous year.
The fees balance is VAT inclusive.
If the entire practice is on cash accounting and VAT is accurately entered on each receipt then, in principle, the ex VAT balance can be deduced by apportioning the unmatched amount on each posting according to the ratio of VAT, and then aggregating the postings
If all receipts are immediately matched when posted then the previous paragraph can be applied to just the invoices
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 (for example, 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 (for example, current, latest closed and so on) 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. For example, if you post an invoice to 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:
Because the time ledger period was closed and the write out had to be redirected to a later period
Because the fees ledger options say to write out on the basis of the invoice date, and the date does not lie within the actual fees period
Because the fees ledger options say to always write out to the current time ledger period irrespective of the fees ledger period or invoice date
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:
If there is a bill, or part of a bill that does not relate to WIP, and therefore does not write any out.
If a bill is posted directly to the time ledger, but is either not posted to the fees ledger, or is posted differently.
The client object type (person, business or trust) and internal id appear twice in this view, once as 'Client' and once as 'ClientCats'. This is purely for convenience of maintenance, and has no underlying subtle significance.
This view is suitable for any user wanting access to the time and fees totals.
This inherits columns from the following views: