[GNC] Production of UK VAT reports

[Christopher Lam]

The simple answer is there is no 'VAT-done' flag. You'd either book the 
VAT-able transaction using posted-date, or not... If a transaction is 
booked in error and already processed/reported to authorities, then do 
another reversing transaction (IMHO; if the accountant agrees) at a 
later date.


On 10/08/18 19:27, Edacc wrote:
> Hi,
>
> There is documentation on employing a Gnuash account hierarchy to produce
> special purpose gl codes for VAT, and that is extremely helpful. I can see
> that a report could be then run against them to produce the numbers to go
> into the various boxes of the return and first time round the return can be
> filtered by 'before the cut off date' so transactions belonging to a future
> quarter are not included.
>
> Next time the VAT report is required for the following period the 'before
> date' filter stops me including post date transactions again, but how do I
> not include transactions dated within the prior period, but not included in
> the prior return?
>
> This is a common situation, especially with input transactions which can get
> 'temporarily lost' and are posted to the books after preparation of a
> period's VAT return although they are dated within that period. The proper
> thing to do is then to include them in the next VAT return, and because they
> are inputs there is no cashflow loss to HMRC so no hassle.
>
> Other computerised and paper systems I have seen have a mechanism to also
> mark all transactions included in a VAT report and form with either a simple
> 'VAT done' flag, or an identifier for the specific VAT period return the
> transaction has been reported on. I am struggling to find anything
> equivalent to this in GnuCash (and there is so much other real good stuff).
>
> Similar considerations would apply to UK HMRC NRLT, CIS, IPT, MGD and many
> other statutory schemes both in relation to the taxes due/deductible and
> total inputs and outputs. In regards the VAT I am thinking about the
> standard arrangement, not cash accounting or fixed payment on account VAT
> arrangements.
>
> If VAT returns are being done with GNUCash I am presuming there is a simple
> answer.
>
> Many thanks
>