PS it would be worth documenting your process of exporting CSV and importing into MTD software into the wiki?
On Wed, 24 Jul 2019 at 10:39, Maf. King <m...@chilwell.net> wrote: > Hi Christopher, > > I've just submitted the first MTD VAT return using GC and the report you > very > kindly wrote. > > The only glitch discovered in actual production use is that the dates > exported > by the report in to the CSV file and hence read by the bridging > spreadsheet > need to have a 4-digit year, the export is presently only 2 digits. > > I had no EU transactions this quarter > > but otherwise, no problems, the numbers all matched up to my old custom > reports. > > so thank you very much for the time to make this work. > > best regards, > Maf. > > > > > On Wednesday, 12 June 2019 15:30:15 BST Christopher Lam wrote: > > Hi > > > > I think it'll be reasonable for now to merge some infrastructure work in > > the transaction-report engine to allow CSV export. > > > > uk-vat-report.scm would be a custom-report, added onto standard-reports > or > > possibly config-user.scm on request, with caveat that the > > accounts-selection is not yet set in stone. > > > > Ultimately it may be an idea to add onto the Tax-Info dialog to tag > > accounts, but I don't know how to do that. > > > > C > > > > On Wed, 12 Jun 2019 at 11:07, Maf. King <m...@chilwell.net> wrote: > > > Hi Christopher, > > > > > > thanks for the gentle prod. I've been very busy for the last couple of > > > weeks, > > > and I apologise for not getting back to you sooner. > > > > > > so far, the VAT report seems to work for me, I haven't spotted any > glaring > > > problems, although I appreciate the limitations on the account > selections > > > that > > > you mention, and I haven't explored deeply with anything other than my > > > normal > > > files. > > > > > > it seems that MTD hasn't gone away (unfortunately) and would be a > shame to > > > miss the release bundle, although I accept that this is still code > which > > > is > > > beta-ish in nature, and I don't know the GC policy on including code > which > > > may > > > still need some polish in a finished release. However, I would also > > > counter > > > that the first real complete test of the workflow has to wait for July > and > > > the > > > first return being prepared. > > > > > > best regards, > > > Maf. > > > > > > On Sunday, 9 June 2019 15:53:26 BST Christopher Lam wrote: > > > > Any final views on enabling CSV export of subtotals and VAT report? > 3.6 > > > > will be in preparation soon... > > > > > > > > The VAT report is rather UK-specific regarding EC sales and I don't > know > > > > rules for other EC countries. It'll be a shame to limit it to UK > only, > > > > which means any other EC VAT report will need to duplicate and amend > the > > > > report. > > > > > > > > And while the selection of Sales/Purchases/VAT accounts is IMHO > > > > satisfactory, the tagging of EC accounts via account-description is > > > > > > rather > > > > > > > hackish, but possibly the easiest one available so far, unless we > reuse > > > > > > the > > > > > > > Tax-Info dialog. > > > > > > > > Unless the above questions are not finalised I wouldn't think it's > > > > appropriate to merge VAT-report. > > > > > > -- > > > Maf. King > > > PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7 2B7C E591 E8E1 0DE7 > C542 > > > -- > Maf. King > PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7 2B7C E591 E8E1 0DE7 C542 > > > > > > _______________________________________________ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
