Re: [GNC-dev] [GNC] UK VAT and "Making Tax Digital"

2019-07-28 Thread Maf. King
it would, and I shall. but it will take a while, really hectic here at the moment. On Saturday, 27 July 2019 11:23:45 BST Christopher Lam wrote: > 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,

Re: [GNC-dev] [GNC] UK VAT and "Making Tax Digital"

2019-07-27 Thread Christopher Lam
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 wrote: > Hi Christopher, > > I've just submitted the first MTD VAT return using GC and the report you > very > kindly wrote. > > The only glitch

Re: [GNC-dev] [GNC] UK VAT and "Making Tax Digital"

2019-07-27 Thread Christopher Lam
Thanks for feedback. I think it will be sensible to modify the current GST-report to 1. instead of combined Sales/Purchases Accounts, request them separately. 2. add a tab "Format" -- this will be new new home for toggling sales/purchase/tax summaries or individual accounts 3. within "Format"

Re: [GNC-dev] [GNC] UK VAT and "Making Tax Digital"

2019-07-24 Thread Christopher Lam
Hi Maf, you're welcome; thanks for letting me know. The dates are printed via gnucash's date-printer and will probably obey the locale or general preferences setting. Try Preferences/Date I'm still considering how to incorporate the UK rules into the current merged report; I now know the

Re: [GNC-dev] [GNC] UK VAT and "Making Tax Digital"

2019-07-24 Thread Maf. King
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,

Re: [GNC-dev] [GNC] UK VAT and "Making Tax Digital"

2019-06-12 Thread Christopher Lam
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

Re: [GNC-dev] [GNC] UK VAT and "Making Tax Digital"

2019-06-12 Thread Maf. King
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

Re: [GNC-dev] [GNC] UK VAT and "Making Tax Digital"

2019-05-15 Thread Christopher Lam
Well done, we have a new builder :) The Transaction Report also had CSV output enabled (and also enables original-currency csv output), so, go ahead try break it :) On Wed, 15 May 2019 at 03:35, Maf. King wrote: > Gents, thanks! > > Cmake, make, make install all flawless. happily running > >

Re: [GNC-dev] [GNC] UK VAT and "Making Tax Digital"

2019-05-15 Thread John Ralls
> On May 15, 2019, at 2:16 AM, Geert Janssens > wrote: > > Op dinsdag 14 mei 2019 16:38:22 CEST schreef John Ralls: >> Maf, you need to delete your source directory and clone the repository. See >> https://wiki.gnucash.org/wiki/GnuCash_Sources#Developers_Source_Code >> >> This failure is

Re: [GNC-dev] [GNC] UK VAT and "Making Tax Digital"

2019-05-15 Thread Geert Janssens
Op dinsdag 14 mei 2019 16:38:22 CEST schreef John Ralls: > Maf, you need to delete your source directory and clone the repository. See > https://wiki.gnucash.org/wiki/GnuCash_Sources#Developers_Source_Code > > This failure is not at all odd. Building from a Github-generated tarball is >

Re: [GNC-dev] [GNC] UK VAT and "Making Tax Digital"

2019-05-14 Thread Maf. King
Gents, thanks! Cmake, make, make install all flawless. happily running Version: 3.5 Build ID: git 2.6.17b-4197-gbeef587e6+(2019-05-12) will test the VAT report in the next few days (but not tomorrow as I've got meetings all day). So far so good, in that it produces sensible CSV output on

Re: [GNC-dev] [GNC] UK VAT and "Making Tax Digital"

2019-05-14 Thread John Ralls
Maf, There are instructions for enough git in the wiki, linked from the Developers_Source_Code section I gave you earlier. Regards, John Ralls > On May 14, 2019, at 9:37 AM, Maf. King wrote: > > Ok, understood. > > I actually downloaded a zip, not a tarball, which I thought sligthly odd,

Re: [GNC-dev] [GNC] UK VAT and "Making Tax Digital"

2019-05-14 Thread Maf. King
Ok, understood. I actually downloaded a zip, not a tarball, which I thought sligthly odd, but that's what the green download button gave... /me goes off to learn some git. just enough to be dangerous thanks chaps, will report back in due course. Maf. On Tuesday, 14 May 2019 15:38:22

Re: [GNC-dev] [GNC] UK VAT and "Making Tax Digital"

2019-05-14 Thread John Ralls
Maf, you need to delete your source directory and clone the repository. See https://wiki.gnucash.org/wiki/GnuCash_Sources#Developers_Source_Code This failure is not at all odd. Building from a Github-generated tarball is guaranteed to fail because it's not pre-swigged and our buildsystem only

Re: [GNC-dev] [GNC] UK VAT and "Making Tax Digital"

2019-05-14 Thread Geert Janssens
Hmm, that's odd. And your source directory is a git clone ? Or did you download the tarball from git ? Regards, Geert Op dinsdag 14 mei 2019 10:25:03 CEST schreef Maf. King: > On Tuesday, 14 May 2019 09:18:02 BST Maf. King wrote: > > Geert, > > > > No Problem. > > > > swig was not installed.

Re: [GNC-dev] [GNC] UK VAT and "Making Tax Digital"

2019-05-14 Thread Maf. King via gnucash-devel
On Tuesday, 14 May 2019 09:18:02 BST Maf. King wrote: > > Geert, > > No Problem. > > swig was not installed. (suse build-deps error?) > > have installed it and cmake is running at the moment...will report back > cmake failed again - i think identically, but haven't looked closely. there

Re: [GNC-dev] [GNC] UK VAT and "Making Tax Digital"

2019-05-14 Thread Maf. King
On Tuesday, 14 May 2019 08:45:09 BST Geert Janssens wrote: > Maf, > > Can you also share the full output of the cmake command ? > > The error looks like you are missing the swig command on your system, but > I'd like to see how cmake reports this. > > Geert Geert, No Problem. swig was not

Re: [GNC-dev] [GNC] UK VAT and "Making Tax Digital"

2019-05-14 Thread Geert Janssens via gnucash-devel
Maf, Can you also share the full output of the cmake command ? The error looks like you are missing the swig command on your system, but I'd like to see how cmake reports this. Geert Op dinsdag 14 mei 2019 09:35:32 CEST schreef Maf. King: > On Sunday, 12 May 2019 01:54:16 BST Christopher Lam

Re: [GNC-dev] [GNC] UK VAT and "Making Tax Digital"

2019-05-14 Thread Maf. King
On Sunday, 12 May 2019 01:54:16 BST Christopher Lam wrote: > Good luck creating a build. Branch at > https://github.com/christopherlam/gnucash/tree/maint-csv-export Hi Christopher, Tried to build GC last night. CMake failed with many errors. I downloaded the zip source file using the green

Re: [GNC-dev] [GNC] UK VAT and "Making Tax Digital"

2019-05-12 Thread Christopher Lam
On Sun, 12 May 2019 at 09:03, Maf. King wrote: > the flexibility is good, but why A/R by default? the other side to those > txns > would generally be an income a/c & VAT collected split? > I don't think loans into the business would have a VAT component. But who > knows what the gubberment

Re: [GNC-dev] [GNC] UK VAT and "Making Tax Digital"

2019-05-12 Thread Maf. King
On Sunday, 12 May 2019 01:54:16 BST you wrote: > Good luck creating a build. Branch at > https://github.com/Gnucash/gnucash/pull/500 or > https://github.com/christopherlam/gnucash/tree/maint-csv-export Morning, I pulled your maint-csv-export branch the other day, but haven't got round to doing

Re: [GNC-dev] [GNC] UK VAT and "Making Tax Digital"

2019-05-11 Thread Christopher Lam
Good luck creating a build. Branch at https://github.com/Gnucash/gnucash/pull/500 or https://github.com/christopherlam/gnucash/tree/maint-csv-export I've amended the report options to be simpler; only 3 accounts selections are needed: - sales accts - default to income and A/Receivable, can also

Re: [GNC-dev] [GNC] UK VAT and "Making Tax Digital"

2019-05-10 Thread Maf. King
Hi Christopher, Thanks. The sample report output looks good. Haven't tried to build GC since 1.6 ish days ( a long time ago) so I'm not sure how that will go. From the list, it seems a lot more simple than it used to be. Will have a go and see what happens. thanks, Maf. On Thursday, 9

Re: [GNC-dev] [GNC] UK VAT and "Making Tax Digital"

2019-05-09 Thread Christopher Lam
See sample report output. Branch as of https://github.com/christopherlam/gnucash/tree/maint-export-csv -- note there are infrastructure changes which will require build rather than copy-into-3.5 It will require careful selection of accounts. Not sure if it is applicable to countries other than UK.

Re: [GNC-dev] [GNC] UK VAT and "Making Tax Digital"

2019-05-08 Thread Maf. King
On Wednesday, 8 May 2019 14:27:03 BST you wrote: > > It would seem the way forward would be a tailored report, requesting the 7 > source accounts as above, and they will by default select accounts > according to the UK VAT template accounts. e.g. (1) preselected to accounts > with substrings

Re: [GNC-dev] [GNC] UK VAT and "Making Tax Digital"

2019-05-08 Thread Maf. King
Hi, Yes, I believe you are correct. IANAA, of course. Box 5 may of course be negative to get a refund from the HMRC. the only change I made to the UK VAT accounts structure was to add the contra boxes as per the Aus. BAS accounts. Keeps the "claimed" payment bits out of the way. shame it

Re: [GNC-dev] [GNC] UK VAT and "Making Tax Digital"

2019-05-08 Thread Christopher Lam
Ok checking understanding: Report options for tailored UK VAT report should request following source accounts: (1) Output VAT (on Sales) [Liability] (2) Output VAT (Reverse EC Purchases) [Liability] (3) Input VAT (on Purchases) [Asset] (4) Sales Accounts [any type, default Income] (5) Purchase

Re: [GNC-dev] [GNC] UK VAT and "Making Tax Digital"

2019-05-07 Thread Maf. King
Hi Christopher. updated VAt accounts for your attention. I'd be happy to fill in the return with these numbers: Box1 220 Box 2 40 Box 3 260 Box 4 109 Box 5 151 Box 6 1475 Box 7 545 box 8 100 Box 9 200 the GST report is close, subject to including the asset purchases. thanks, Maf. On

Re: [GNC-dev] [GNC] UK VAT and "Making Tax Digital"

2019-05-03 Thread Maf. King
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

Re: [GNC-dev] [GNC] UK VAT and "Making Tax Digital"

2019-04-11 Thread Christopher Lam
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