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,
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 d
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" tab
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&Time.
I'm still considering how to incorporate the UK rules into the current
merged report; I now know the s
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, th
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
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
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 du
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
>
> Ve
> 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 not
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
> guaranteed
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
th
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, bu
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 BST
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
i
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.
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 a
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 in
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 w
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 "clo
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 migh
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 a
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 se
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
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.
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 "VAT"
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 loo
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 Acc
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 Thursday
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
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.
The links I attached earlier (replacing transaction.scm and
income-gst-statement.scm) would enable CSV export,
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.github
32 matches
Mail list logo