Hi Christopher. sorry for not getting back to you sooner - we had a bank holiday weekend here in the UK and family life took over.
I'm on it now, adding bits to your template file. I think the report handles the reverse VAT etc OK - might need some extra subtotals exposing for boxes 2,8,9. I don't do it often, and when I do it has only been simple transactions. will be in touch later with a data file. Maf. On Monday, 6 May 2019 04:39:06 BST Christopher Lam wrote: > Just wondering -- barring the capital purchase issue (which is easily > resolved by expanding the sales/purchases account selection to *all* > account types), is the GST report able to handle EC VAT splits? I think it > does... > > Opinion welcome at > https://github.com/Gnucash/gnucash/pull/500#issuecomment-489482829 ... > > On Fri, 3 May 2019 at 02:13, Maf. King <m...@chilwell.net> wrote: > > Hi Christopher, > > thanks, I've just subscribed to -devel > > > > I can see no reason for anything other than GBP in a UK VAT return! > > sensible > > restriction. > > > > Maf. > > > > On Thursday, 2 May 2019 16:44:59 BST Christopher Lam wrote: > > > Maf's reply forwarded to devel. > > > > > > I think a sensible restriction to vat-report will be: all amounts *must* > > > > be > > > > > converted into a report-currency... which will then ensure there's only > > > 1 > > > currency for grand-total, therefore 1 heading + 1 grand-total = 1 csv > > > > row. > > > > > ---------- Forwarded message --------- > > > From: Maf. King <m...@chilwell.net> > > > Date: Thu, 2 May 2019 at 13:36 > > > Subject: Re: [GNC] UK VAT and "Making Tax Digital" > > > To: Christopher Lam <christopher....@gmail.com> > > > Cc: gnucash-devel <gnucash-devel@gnucash.org> > > > > > > > > > Hi Christopher, > > > > > > responses inline: > > > > > > On Thursday, 2 May 2019 12:36:06 BST Christopher Lam wrote: > > > > Are you referring to the Multicolumn report with multiple embedded > > > > > > reports? > > > > > > > This one would be very annoying to create CSV export from... each > > > > embedded > > > > > > report exposes its html output only. > > > > > > That was the report I was thinking of, not surprised that CSV would be > > > > hard > > > > > to > > > generate. > > > > > > > The links I attached earlier (replacing transaction.scm and > > > > income-gst-statement.scm) would enable CSV export, exposing the > > > > headers > > > > > > and > > > > > > > the grand-totals. > > > > > > Correct, that is what I see. but the totals are wrong because the > > > report > > > can't consider the asset purchases. > > > > > > > Meanwhile I'm rather more interested in generating a proper solution > > : > > :-) > > : > > > > For UK VAT I'd think the more complex requirements here would warrant > > > > a > > > > customised solution based on the existing VAT account structure, > > > > rather > > > > than to try shoehorn hacks on the existing report. > > > > > > Fair enough. I guess the GST report was written with Oz in mind and > > > then > > > generalised a bit. > > > > > > > If you can create a sample datafile based on the CoA as suggested by > > > > New-account wizard, > > > > > > No problem, will take your template file and try to get that sorted over > > > the > > > weekend or early next week. > > > > > > thanks, > > > Maf. > > > > -- > > 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
