Re: [GNC-dev] Fwd: [GNC] UK VAT and "Making Tax Digital"
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 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 > > > Date: Thu, 2 May 2019 at 13:36 > > > Subject: Re: [GNC] UK VAT and "Making Tax Digital" > > > To: Christopher Lam > > > Cc: gnucash-devel > > > > > > > > > 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
Re: [GNC-dev] Fwd: [GNC] UK VAT and "Making Tax Digital"
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 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 > > Date: Thu, 2 May 2019 at 13:36 > > Subject: Re: [GNC] UK VAT and "Making Tax Digital" > > To: Christopher Lam > > Cc: gnucash-devel > > > > > > 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 > > > > > > ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Re: [GNC-dev] Fwd: [GNC] UK VAT and "Making Tax Digital"
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 > Date: Thu, 2 May 2019 at 13:36 > Subject: Re: [GNC] UK VAT and "Making Tax Digital" > To: Christopher Lam > Cc: gnucash-devel > > > 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 ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
[GNC-dev] Fwd: [GNC] UK VAT and "Making Tax Digital"
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 Date: Thu, 2 May 2019 at 13:36 Subject: Re: [GNC] UK VAT and "Making Tax Digital" To: Christopher Lam Cc: gnucash-devel 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. ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel