Feel free to replace the standard-report files with the following. Note they must both be replaced simultaneously. Ideally v3.5, may work on recent releases.
https://raw.githubusercontent.com/christopherlam/gnucash/maint-export-csv/gnucash/report/standard-reports/transaction.scm https://raw.githubusercontent.com/christopherlam/gnucash/maint-export-csv/gnucash/report/standard-reports/income-gst-statement.scm On Thu, 11 Apr 2019 at 03:48, Christopher Lam <christopher....@gmail.com> 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. > > On Tue., 19 Feb. 2019, 22:33 Christopher Lam, <christopher....@gmail.com> > wrote: > >> To all interested in beta-testing CSV export, for now I think it's safest >> to export CSV in carefully selected reports, because all reports do tables >> differently. >> >> After version 3.5 is out of the door (in a couple months) I'll provide >> some customized transaction.scm and income-gst-statement.scm which can >> export CSV, and could be finalised for 3.6 due mid-year. The current >> iteration of these reports depend heavily upon the supporting files which >> are undergoing heavy maintenance, and may not work for those using 3.4 >> releases. Alternatively anyone comfortable buildling from maint can beta >> test now :) >> >> C >> >> On Tue, 19 Feb 2019 at 19:42, ref...@gmx.net <ref...@gmx.net> wrote: >> >>> I am struggling to.understand at the moment the reporting language, >>> which I understand is a lisp variant. But what I can see from reading >>> the transaction report's source files, is that all logic is very >>> nicely >>> compartmentalized, which makes me wonder if a more general solution >>> would not be to have parallel to the html render output csv output for >>> all reports which rely upon it. This would then allow a much wider use >>> and remove the accusation by another member here on the list that I >>> (or >>> others) want something UK specific. >>> This would also improve in general interoperability on all kinds of >>> levels. >>> Peter >>> Sent from my mobile. Please forgive shortness, typos and weird >>> autocorrects. >>> >>> -------- Original Message -------- >>> Subject: Re: [GNC] UK VAT and "Making Tax Digital" >>> From: "Maf. King" >>> To: gnucash-u...@gnucash.org >>> CC: >>> >>> On Sunday, 17 February 2019 12:23:39 GMT Maf. King wrote: >>> > On Sunday, 17 February 2019 11:57:58 GMT Christopher Lam wrote: >>> > > I can amend Income-GST-statement, which is tailor-made for >>> periodic >>> > > GST/VAT returns, to output CSV or XML. But so far there's little >>> demand >>> > > nor willing beta-testers. >>> > >>> > *Raises Hand in the Air* I'll volunteer to test. With the caveat >>> that my >>> > VAT is not normally very complicated. >>> > >>> > The GST report I ran earlier this morning spat out numbers which >>> matched my >>> > last quarter's return (generated from customised options to >>> transaction >>> > reports), which is a good start! >>> > >>> > Maf. >>> Further to this, I've found and downloaded a bridging spreadsheet >>> for >>> LibreOffice (for free, without even having to register an email >>> address) from >>> https://filemyvatreturn.co.uk/download/ (seems to be a "trading >>> name" for CHM >>> software, https://www.chm-software.co.uk/companies where you do >>> have >>> to >>> register to download...) >>> No endorsement or recommendation to use them, I'm not even a >>> satisfied user >>> (yet). Seems that it will cost £7.50 for each VAT return to be >>> filed. But >>> gotta make a start somewhere. If anyone else knows of other options, >>> please >>> do chime into this thread. >>> According to their help file, all you need is a spreadsheet (or >>> sheets) that >>> contain the 7 relevant box totals that you link into the downloaded >>> sheet. It >>> may be possible to tweak it to (automagically) fill from a CSV file, >>> I'll need >>> to look at that next month when I have some more time. >>> I will note that depending on how orderly the exit from the EU ends >>> up, the 7 >>> box totals required may change - but we're not going to know how >>> that >>> particular cookie is going to crumble yet... >>> Christopher: what sort of timescale do you think you'll need to >>> tweak the GST >>> report etc to give CSV out? There is a clear workflow to export from >>> GC to >>> Calc and munge the totals there so it isn't especially critical, >>> despite the >>> first digital filings being due early August. But it seems to me >>> that if a new >>> workflow can be figured out in time, why tweak the old way first >>> then change a >>> quarter or two later? >>> I'm pretty busy the rest of this month, but will do more digging >>> into this in >>> March. >>> Maf. >>> _______________________________________________ >>> gnucash-user mailing list >>> gnucash-u...@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. >>> _______________________________________________ >>> gnucash-user mailing list >>> gnucash-u...@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. >>> >> _______________________________________________ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
