[GNC] UK VAT and "Making Tax Digital"

[Maf. King]

Hi Christopher.

Finally got round to completing my final quarter VAT return with the manual 
error-prone process of typing 7 numbers into boxes on the HMRC website.

I'm now trying to make the Income & GST report give me sensible numbers that 
match my existing saved transaction reports and struggling with one thing.

It may well be how I've got my tree set up that's causing my problem.  The GST 
report doesn't allow to  include transactions to asset accounts.

Under UK tax law, if I buy something of lasting value, eg some machine, for 
example, it is not an expense but a transfer to Asset:CapitalEquipment.   But 
the VAT is claimable straight away and so the transaction (for the VAT return) 
should be included in the Net Purchases & Tax on Purchases column.

any advice?

is your CSV output intending to be made from the GST report codebase in some 
way?

The bridging spreadsheet I have will be quite happy to read from 
~/somewhere/somefile.csv

my test file is just :
Box1,1234.56
Box2, 0.00
(box 3 is calculated from box1+box2 so not included)
Box4, 321.98
etc to include box 6,7,8,9

and the spreadsheet will read that and populate new data into the fields each 
time it is run.

the only other thing that might be nice to include in the CSV output is the 
date period, but I haven't tested that for format etc yet.


I'm not signed up for the -devel list, can do so if you'd prefer to keep this 
off -user for now. 

thanks & best regards,
Maf.



On Thursday, 11 April 2019 11:08:27 BST Maf. King wrote:
> On Thursday, 11 April 2019 04:48:31 BST Christopher Lam wrote:
> > 3.5 is out and I promised to offer CSV output. Has anyone confirmed the
> > exact CSV (or JSON)  format desired by their *bridging* software?
> > 
> > Please be aware that direct communication to HMRC is best done by bridging
> > software outside gnucash. It'll be a nice project for anyone to do in
> > python or similar.
> 
> Hi Christopher,
> 
> Thanks for looking at this again.
> 
> I'll probably be looking at this next week or so.   I'll have to complete my
> lasts "traditional" VAT return by around the end of the month.  For the
> quarter ending 30th June, I'll report to HMRC towards the end of July, and
> be in the first tranche of submittors.
> 
> I plan to use a spreadsheet bridge that I found for Libre office.
> 
> seems that the sheet as presented requires linking cells from a source
> report spreadsheet.
> 
> User guide is here explaining how to do it
> 
> http://www.chm-software.co.uk/userguide/
> 
> (no relationship or recommendation implied)
> 
> I'm thinking that I might be able to adapt their sheet to directly take a
> CSV input to named cells in some way.  It is only about half a dozen
> numbers that are needed.
> 
> Of course, if any other users have come across a more elegant solution, feel
> free to chime in!
> 
> Maf.


-- 
Maf. King
PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7  2B7C E591 E8E1 0DE7 C542