 |
 |
|
|
This view exposes the rows in TFPostTypeFigs that give totals of fees postings by Account, period and posting type.
This view also supports the overall ledger totals - with owning object type = 0
Because the Type column is simplified from the raw table data there may be more than one total row per account, period and type.
When considering accounting VAT on receipts (either on pure cash accounting or on the continuous service justification) care is needed.
For an invoice of 115 pounds the item total will be +115 (debit) and the VAT amount will be posted as -15 (credit). This may be posted to VAT or VAT reserved (depending on whether the invoice is proforma or not) but will still appear in the totals here.
For a receipt of 115 pounds the item total will be -115 (credit) but the VAT amount will still be posted as -15 (credit) because this is still a VAT liability. On the nominal ledger the control account will show -115 and the bank will show +115.
The -15 credit to the VAT account will be balanced by a +15 to the 'VAT not yet invoiced' account. Subsequent matching to a proforma invoice will journal between VAT reserve and VAT not yet invoiced - and not affect the VAT liability.
Therefore, these VAT amounts (since they don't distinguish 'which' VAT account the posting was made to) do not reflect true VAT liability (for that use idvFeesNominalPost). They are meant for the convenience of excluding VAT elements from practice figures.
Summing over the various totals by period must be done with care. receipt for 115 with a 15 VAT element. The VAT total will show +45 (nominal convention), the total movements will show +115 (sales convention) and the ex VAT movement will show +100, so adding the VAT to the ex VAT (even after adjusting for sign conventions) does not give the total.
The immediate reason for the apparent non-balancing is that the nominal posting to 'VAT not yet invoiced' does not appear in the totals anywhere. The Total figure represents genuine movement on the account (you really did put 115 in the bank). The ex VAT figure allows you to remove the effects of VAT from all postings when considering performance and profitability, but the VAT total is meant to indicate VAT liability.
Rows in this view are not guaranteed to cover all combinations of accounts and periods. In particular, if the period has no opening balance (for example, because the previous period is in reconciliation rather than closed), and there has been no activity on the account in the new period, then no row will be present for that account/period combination. Other circumstances that can give rise to absent rows include transient ones, such as an account being posted to at the time that the last close period was run.
Type = Base view suitable for advanced end user use
| ClientObjectType | The object type of the client object that the account is for |
| ClientInternalId | The internal id of the client object that the account is for |
| Year | The year part of the fees period |
| Period | The fees period number within the year |
| Type | The type of postings - see idvFeesPostingType |
| PostCategory | The category of posting - see idvFeesPostingCategory |
| Proforma | if the postings represent a proforma document then 'Y else 'N' |
| Interim | if the postings represent an interim document then 'Y else 'N' |
| StandingOrder | if the postings represent a standing order then 'Y else 'N' |
| DirectDebit | if the postings represent a direct debit then 'Y else 'N' |
| Total | The fees total for postings of this type for this account and period. This is VAT inclusive and follows fees conventions (i.e. invoice = DR, receipt = CR, credit negative). |
| ExVATTotal | As Total but with VAT elements removed. This column takes into account the subtleties of VAT accounting on receipts as detailed in the notes below |
| VATTotal | The VAT total on postings of this type. However this follows nominal conventions. |
| ItemCount | The number of items of this type for this account and period. |
This view is directly inherited by the following views: