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 _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.