Re: Default account structure for different locales

2014-01-30 Thread Ngewi Fet
Oh that's a bummer. :(
I want to have the GUIDS and in addition, the import functionality
currently built into the app handles only actual Gnucash account structure
files.

That means I need people to actually export the Gnucash account files and
send to me after all. Right? Gnucash seems locked down to my computer
locale, so I cannot generate all the files myself for different locales.

Would everyone be so kind as to do this (as described in the first mail in
this thread) and send me the file together with your country and language?

Please I need the files to be in the actual locale language and currency,
so if, for example, you are in Germany and using Gnucash in English then
you don't need to send it.

Thanks!
On Jan 29, 2014 11:56 PM, "Derek Atkins"  wrote:

> Note that you won't get GUIDs from the xea files. GnuCash, when it sees
> the "new" keyword generates a new GUID for the accounts. This way every
> account tree is unique.
>
> The only way to get the GnuCash account GUIDs is to read in the actual
> data file.
>
> -derek
>
> Sent from my HTC smartphone
>
>
> - Reply message -
> From: "Ngewi Fet" 
> To: "Frank H. Ellenberger" 
> Cc: "GNUCASH devel" 
> Subject: Default account structure for different locales
> Date: Wed, Jan 29, 2014 5:35 PM
>
>
> Thanks for the input Frank.
> It's not really much effort for me since the functionality for importing
> the files is already there. I just need to copy the account structure files
> over.
>
> Also, upon first launch of the app, users have the option to create some
> default accounts. I might as well just create a proper GnuCash tree there.
> This would match the desktop accounts right down to the account IDs and may
> spare the work of exporting your account structure and importing it again.
>
> Cheers
> Ngewi
>
> > On 29.01.2014, at 20:23, "Frank H. Ellenberger" <
> frank.h.ellenber...@gmail.com> wrote:
> >
> > Hi Ngewi,
> >
> > Am 29.01.2014 14:05, schrieb Ngewi Fet:
> >> Hello everyone,
> >> I am working on generating the default GnuCash account structure in the
> >> Android app without having to export from desktop and then import. For
> this
> >> to happen, I need the account structure file for different locales.
> > :
> >
> > I am not shure that is worth the effort. From what I saw, most common
> > templates are a plain translation of C. Their translators were not brave
> > enough to do a real localization. So the users still needs to adjust
> > them. And that is likely easier done in GnuCash. Eventually you should
> > inform them in some way about this?
> >
> > OTOH it might be a good fallback, if the user didn't use GnuCash before
> > or with to use the app with another program.
> >
> >> Ngewi Fet
> >>
> >> PS: Please reply to the list not me directly so that anyone else from
> your
> >> local who was thinking of doing the same can spare themselves some
> effort.
> >
> > Just my 2ยข
> > Frank
> >
>
> ___
> gnucash-devel mailing list
> gnucash-devel@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel


custom report - link to search results

2014-01-30 Thread Samuel Cox
Hi,

First, sorry for cross-posting.  However, I realized after posting to users
that my question was more dev related.

I'm trying to make a custom version of the budget report where each actual
amount serves as a link to the transactions contributing to that amount.

I'm thinking a search with appropriate values would be the best route.  It
took me several hours just to figure out how to replace the actual value
with a link to the account using Scheme.  However, I can't find a way to
spawn a search from the link.

Is there a way to link to (i.e. launch) a search from a report?  If not, do
you have any other ideas or ways to start?

Many thanks.
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel


Re: Default account structure for different locales

2014-01-30 Thread John Ralls

On Jan 30, 2014, at 1:25 AM, Ngewi Fet  wrote:

> Oh that's a bummer. :(
> I want to have the GUIDS and in addition, the import functionality
> currently built into the app handles only actual Gnucash account structure
> files.
> 
> That means I need people to actually export the Gnucash account files and
> send to me after all. Right? Gnucash seems locked down to my computer
> locale, so I cannot generate all the files myself for different locales.
> 
> Would everyone be so kind as to do this (as described in the first mail in
> this thread) and send me the file together with your country and language?
> 
> Please I need the files to be in the actual locale language and currency,
> so if, for example, you are in Germany and using Gnucash in English then
> you don't need to send it.

Ngewi,

I think you're missing that GnuCash generates a *new* GUID *when it creates the 
account*. Any GUIDs are valid only for the account file from which they came. 
Try this yourself: Turn off compression or use SQLite and make two new files 
using the default "common accounts" template, then compare the account entries: 
Everything will be the same except the GUIDs.

If I send you an exported accounts structure, the GUIDs will apply only to the 
file from which I exported it.

There's more: The example files in the accounts directories do have GUIDs: They 
need them in order to have a hierarchy. The only difference aside from the 
actual GUID is that the act:id type element is "new" in the XEA file and "guid" 
in the exported file. I've illustrated this below.

Unless you're on a Mac, you can change the locale of your Gnucash instance by 
uncommenting and then changing the "LANG" entry in etc/gnucash/environment (on 
Windows that's c:\Program Files (x86)\gnucash\etc\gnucash\environment).

Regards,
John Ralls

Account Export

  Assets
  b2c27b8aa3c89ea4c6d4843530f0c23f
  ASSET
  
ISO4217
USD
  
  100
  Assets
  

  placeholder
  true

  
  f70a1d3a15cb57738bec7fdb9dffd78e


Account XEA

  Assets
  98f262dfab9a2b99ac42919dcf58d304
  ASSET
  
ISO4217
USD
  
  Assets
  1972cce2e2364f95b2b0bc014502661d
  

  placeholder
  true

  

___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel


Re: Default account structure for different locales

2014-01-30 Thread Ngewi Fet
Thanks for that clarification John.
Intuitively I expected the GUIDs to be generated each time. But once I
tried to import two files from different locales (and different machines)
and had the GUIDs all coincide.
That surprised me and got me wondering if GnuCash hardcodes the GUIDs
somehow (which I don't think makes sense). But good to know that it's
generated each time.

The GUIDs are not too critical for me though, (QIF doesn't use them the
GnuCash desktop doesn't check them for OFX). It was more of a
future-proofing thing.

However I cannot use the XEA files because they do not have any XML
namespaces declared in them. Also, although I noticed the similarity, I
don't know what else could be
different between an XEA file and an exported account structure file.

If the only difference is the lack of XML namespaces and the "new" instead
of "guid" attribute, then I can change all that myself and use the files
as-is.
Can you confirm that this is the case?

Cheers,


On Thu, Jan 30, 2014 at 4:20 PM, John Ralls  wrote:

>
> On Jan 30, 2014, at 1:25 AM, Ngewi Fet  wrote:
>
> > Oh that's a bummer. :(
> > I want to have the GUIDS and in addition, the import functionality
> > currently built into the app handles only actual Gnucash account
> structure
> > files.
> >
> > That means I need people to actually export the Gnucash account files and
> > send to me after all. Right? Gnucash seems locked down to my computer
> > locale, so I cannot generate all the files myself for different locales.
> >
> > Would everyone be so kind as to do this (as described in the first mail
> in
> > this thread) and send me the file together with your country and
> language?
> >
> > Please I need the files to be in the actual locale language and currency,
> > so if, for example, you are in Germany and using Gnucash in English then
> > you don't need to send it.
>
> Ngewi,
>
> I think you're missing that GnuCash generates a *new* GUID *when it
> creates the account*. Any GUIDs are valid only for the account file from
> which they came. Try this yourself: Turn off compression or use SQLite and
> make two new files using the default "common accounts" template, then
> compare the account entries: Everything will be the same except the GUIDs.
>
> If I send you an exported accounts structure, the GUIDs will apply only to
> the file from which I exported it.
>
> There's more: The example files in the accounts directories do have GUIDs:
> They need them in order to have a hierarchy. The only difference aside from
> the actual GUID is that the act:id type element is "new" in the XEA file
> and "guid" in the exported file. I've illustrated this below.
>
> Unless you're on a Mac, you can change the locale of your Gnucash instance
> by uncommenting and then changing the "LANG" entry in
> etc/gnucash/environment (on Windows that's c:\Program Files
> (x86)\gnucash\etc\gnucash\environment).
>
> Regards,
> John Ralls
>
> Account Export
> 
>   Assets
>   b2c27b8aa3c89ea4c6d4843530f0c23f
>   ASSET
>   
> ISO4217
> USD
>   
>   100
>   Assets
>   
> 
>   placeholder
>   true
> 
>   
>   f70a1d3a15cb57738bec7fdb9dffd78e
> 
>
> Account XEA
> 
>   Assets
>   98f262dfab9a2b99ac42919dcf58d304
>   ASSET
>   
> ISO4217
> USD
>   
>   Assets
>   1972cce2e2364f95b2b0bc014502661d
>   
> 
>   placeholder
>   true
> 
>   
> 
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel


Re: Default account structure for different locales

2014-01-30 Thread Derek Atkins
Ngewi Fet  writes:

> Thanks for that clarification John.
> Intuitively I expected the GUIDs to be generated each time. But once I tried
> to import two files from different locales (and different machines) and had
> the GUIDs all coincide.
> That surprised me and got me wondering if GnuCash hardcodes the GUIDs somehow
> (which I don't think makes sense). But good to know that it's generated each
> time.

That is surprising.  It is possible that some of the translated versions
have 'type="guid"' instead of 'type="new"'.  And indeed a quick grep
shows this is the case.  E.g.:

grep 'act:id' accounts/de_DE/*-xea | grep -v 'type="new"

We should fix that, and all the others.

-derek

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel


Re: Default account structure for different locales

2014-01-30 Thread John Ralls

On Jan 30, 2014, at 7:31 AM, Ngewi Fet  wrote:

> Thanks for that clarification John.
> Intuitively I expected the GUIDs to be generated each time. But once I tried 
> to import two files from different locales (and different machines) and had 
> the GUIDs all coincide.
> That surprised me and got me wondering if GnuCash hardcodes the GUIDs somehow 
> (which I don't think makes sense). But good to know that it's generated each 
> time. 
> 
> The GUIDs are not too critical for me though, (QIF doesn't use them the 
> GnuCash desktop doesn't check them for OFX). It was more of a future-proofing 
> thing. 
> 
> However I cannot use the XEA files because they do not have any XML 
> namespaces declared in them. Also, although I noticed the similarity, I don't 
> know what else could be 
> different between an XEA file and an exported account structure file. 
> 
> If the only difference is the lack of XML namespaces and the "new" instead of 
> "guid" attribute, then I can change all that myself and use the files as-is. 
> Can you confirm that this is the case?
> 

The XEA file has a description element for the new account assistant. The 
exported accounts in the exported file have an element act:commodity-scu which 
you can see in the example in my previous message. The XEA example may have 
different encoding from the exported one, and the root element in the XEA is 
gnc-account-example while it's gnc-v2 in the export. You can check this 
yourself simply by diffing an XEA with the example that results from creating 
an empty file with it and exporting it.

Regards,
John Ralls



___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel


Re: custom report - link to search results

2014-01-30 Thread Derek Atkins
Hi,

Samuel Cox  writes:

> Hi,
>
> First, sorry for cross-posting.  However, I realized after posting to users
> that my question was more dev related.
>
> I'm trying to make a custom version of the budget report where each actual
> amount serves as a link to the transactions contributing to that amount.
>
> I'm thinking a search with appropriate values would be the best route.  It
> took me several hours just to figure out how to replace the actual value
> with a link to the account using Scheme.  However, I can't find a way to
> spawn a search from the link.
>
> Is there a way to link to (i.e. launch) a search from a report?  If not, do
> you have any other ideas or ways to start?

You can link to an account, but I don't think there is any way
specifically to link to a "search result".  Adding something like that
would be somewhat challenging, because searches aren't "stored" so there
is no way to actually reference it (i.e. a search has no GUID to
reference).

> Many thanks.

-derek

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel


Re: custom report - link to search results

2014-01-30 Thread Phil Longstaff
It's been a long time since I used quicken, but I seem to remember than it
did have a drill-down type feature where clicking on a number in a report
took you to a ledger display showing what went into that number.  For a
balance sheet, that would be the full account ledger with all transactions.
 For a budget report for a month, that would be just the transactions for
that month.

I wonder what would be required to generalize that in the reports.  Click
on a value and be taken to a list of transactions, a line in the budget
entry display, customer info, list of invoices, ...

Phil


On Thu, Jan 30, 2014 at 11:34 AM, Derek Atkins  wrote:

> Hi,
>
> Samuel Cox  writes:
>
> > Hi,
> >
> > First, sorry for cross-posting.  However, I realized after posting to
> users
> > that my question was more dev related.
> >
> > I'm trying to make a custom version of the budget report where each
> actual
> > amount serves as a link to the transactions contributing to that amount.
> >
> > I'm thinking a search with appropriate values would be the best route.
>  It
> > took me several hours just to figure out how to replace the actual value
> > with a link to the account using Scheme.  However, I can't find a way to
> > spawn a search from the link.
> >
> > Is there a way to link to (i.e. launch) a search from a report?  If not,
> do
> > you have any other ideas or ways to start?
>
> You can link to an account, but I don't think there is any way
> specifically to link to a "search result".  Adding something like that
> would be somewhat challenging, because searches aren't "stored" so there
> is no way to actually reference it (i.e. a search has no GUID to
> reference).
>
> > Many thanks.
>
> -derek
>
> --
>Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>Member, MIT Student Information Processing Board  (SIPB)
>URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
>warl...@mit.eduPGP key available
> ___
> gnucash-devel mailing list
> gnucash-devel@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel


Re: Default account structure for different locales

2014-01-30 Thread John Ralls

On Jan 30, 2014, at 8:16 AM, Derek Atkins  wrote:

> Ngewi Fet  writes:
> 
>> Thanks for that clarification John.
>> Intuitively I expected the GUIDs to be generated each time. But once I tried
>> to import two files from different locales (and different machines) and had
>> the GUIDs all coincide.
>> That surprised me and got me wondering if GnuCash hardcodes the GUIDs somehow
>> (which I don't think makes sense). But good to know that it's generated each
>> time.
> 
> That is surprising.  It is possible that some of the translated versions
> have 'type="guid"' instead of 'type="new"'.  And indeed a quick grep
> shows this is the case.  E.g.:
> 
> grep 'act:id' accounts/de_DE/*-xea | grep -v 'type="new"
> 
> We should fix that, and all the others.

find -exec sed to the rescue!

r23780.

Regards,
John Ralls


___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel


Re: Default account structure for different locales

2014-01-30 Thread Derek Atkins
John Ralls  writes:

>> grep 'act:id' accounts/de_DE/*-xea | grep -v 'type="new"
>> 
>> We should fix that, and all the others.
>
> find -exec sed to the rescue!
>
> r23780.

Looks like you missed accounts/fr_CA/acctchrt_cdmarchemon.gnucash-xea
but I can verify that all the rest are fixed.

> Regards,
> John Ralls

-derek

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel


Re: Creating Non-US Tax Reports

2014-01-30 Thread Carsten Rinke

Hi,

just to make you aware, I am working on something similar:
*Bug 710873*  -New 
Tax Declaration Info Report - multi-national, multi-purpose (private, 
business, ...)


Right now it can be run in parallel to the TXF Code editor.
I am basically finished with what can be called "feature 
implementation", and now turn to bug fixing - meaning: I am going to 
apply it for my own tax declaration this year.
If nothing serious comes up, I might have something to publish by mid of 
the year (incl. documentation).


Kind regards,
Carsten


On 01/29/2014 06:41 PM, Alex Aycinena wrote:

-- Forwarded message --
From: "Clint Redwood" 
To: "gnucash-devel@gnucash.org" 
Cc:
Date: Wed, 29 Jan 2014 16:29:03 +
Subject: Creating Non-US Tax Reports
Hi!

Apologies if this has been done to death but googling found nothing
relevant.

Is there any way of setting up custom tax codes against accounts, and to
use the tax reports to do UK personal and corporation tax. It doesn't
appear to be able to be done inside the application but I wondered if there
is a configuration file I could modify to enable me to use this report
effectively, rather than just showing US forms and boxes. Clearly the
export isn't going to be relevant, but just having the report would be
useful.

Any suggestions or pointers welcome.

Thanks!

Yours,

Clint Redwood

Screwtape Limited, Registered 06663232, Babington House, 26 College Road,
Chilwell, Nottingham NG9 4AS


There is no easy way to use the existing US-based report for non-US income

tax reporting. Of course it can be done with a bunch of re-programming.

I maintain this part of gnucash and plan in the future to make changes that
actually would allow this. For the US, since the current system is based on
'txf' codes, the maintenance of which is dormant, the system is gradually
getting stale; I would like to make the 'txf' code not the key but an
attribute of a hidden key so that new codes could be added even if no
'txf'' code exists for an item. If I do this in a fairly generalized way,
then it could be used to support multiple taxing jurisdictions (within the
US and outside of the US) simultaneously. If in an even more generalized
way, it could support user-managed tagging of accounts, transactions, and
splits, a feature which has also been asked for and I would like to use
personally. But this will take a bit of effort and time to accomplish.

Alex
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel



___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel


Re: Default account structure for different locales

2014-01-30 Thread John Ralls

On Jan 30, 2014, at 9:08 AM, Derek Atkins  wrote:

> John Ralls  writes:
> 
>>> grep 'act:id' accounts/de_DE/*-xea | grep -v 'type="new"
>>> 
>>> We should fix that, and all the others.
>> 
>> find -exec sed to the rescue!
>> 
>> r23780.
> 
> Looks like you missed accounts/fr_CA/acctchrt_cdmarchemon.gnucash-xea
> but I can verify that all the rest are fixed.

Huh. Something in that file chokes sed. The type="guid" fixed in r23781.

Regards,
John Ralls

___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel


Re: [MAINT] GnuCash server migration Feb 1-2

2014-01-30 Thread Derek Atkins
Just a reminder that this is still happening this weekend.
However, I'm still not 100% sure on the exact time it will happen.
I'll PROBABLY be starting around 1pm US/ET (1800 UTC) on Saturday, but
don't quote me on that.  :)

I'll send out an email before I start, push a news article to www, and
I'll be on IRC for questions and updates.

-derek

Derek Atkins  writes:

> Hi,
>
> I'm going to migrate 'code.gnucash.org' (our "everything" server) to a
> new VM/OS install on the weekend of February 1-2.  I expect this move
> will take several hours, during which time all access to email, email
> archives, wiki, svn, trac, IRC logs, etc will all be unavailable.  This
> is necessary because the services must be disabled on the old server to
> move the data behind them to the new OS.  Most of the data has already
> been migrated so the majority of time is going to be testing and running
> "update" scripts to make sure everything is back up correctly.
>
> I don't have an exact Time of Day yet when I expect this migration to
> take place.  When I have a better idea I'll send email.  That choice
> will probably happen last-minute due to family obligations.
>
> I'll be in the #gnucash IRC chat room during the migration and will be
> able to provide status updates there.
>
> A few notes (mostly for developers):
>
> 1) The new server will not have Subversion access.  If it turns out that
>we *need* read-only svn access I can turn it on, but I'm hoping we
>don't need it.  SVN has also been blocked for writing; again, if we
>need to change that we can work on it.
>
> 2) As of this server migration we'll also be migrating to GIT as our
>primary push repository.  Make sure you're familiar.  You should be
>able to at least "pull" from the git service on the current "code".
>
> 3) I'm taking the opportunity to refresh the SSH keys on the server.
>This means all developers with commit access will need to manually
>refresh your ~/.ssh/known_hosts file, otherwise ssh will complain.
>The new host has two new keys with the following fingerprints:
>
>256 a0:35:2a:54:ce:df:1b:b8:82:5e:11:83:73:50:47:55   (ECDSA)
>2048 20:23:3d:df:f3:13:34:c1:32:ca:11:77:24:21:98:01   (RSA)
>
> Let me know if you have any questions!
>
> Thanks,
>
> -derek

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel


Re: Default account structure for different locales

2014-01-30 Thread Ngewi Fet
John, thanks for the tip about changing the locale. I got all the files I
need.
Cheers,
On Jan 30, 2014 9:10 PM, "John Ralls"  wrote:

>
> On Jan 30, 2014, at 9:08 AM, Derek Atkins  wrote:
>
> > John Ralls  writes:
> >
> >>> grep 'act:id' accounts/de_DE/*-xea | grep -v 'type="new"
> >>>
> >>> We should fix that, and all the others.
> >>
> >> find -exec sed to the rescue!
> >>
> >> r23780.
> >
> > Looks like you missed accounts/fr_CA/acctchrt_cdmarchemon.gnucash-xea
> > but I can verify that all the rest are fixed.
>
> Huh. Something in that file chokes sed. The type="guid" fixed in r23781.
>
> Regards,
> John Ralls
>
>
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel


Re: Creating Non-US Tax Reports

2014-01-30 Thread Bob Gustafson

On 01/29/2014 11:41 AM, Alex Aycinena wrote:

-- Forwarded message --
From: "Clint Redwood" 
To: "gnucash-devel@gnucash.org" 
Cc:
Date: Wed, 29 Jan 2014 16:29:03 +
Subject: Creating Non-US Tax Reports
Hi!

Apologies if this has been done to death but googling found nothing
relevant.

Is there any way of setting up custom tax codes against accounts, and to
use the tax reports to do UK personal and corporation tax. It doesn't
appear to be able to be done inside the application but I wondered if there
is a configuration file I could modify to enable me to use this report
effectively, rather than just showing US forms and boxes. Clearly the
export isn't going to be relevant, but just having the report would be
useful.

Any suggestions or pointers welcome.

Thanks!

Yours,

Clint Redwood

Screwtape Limited, Registered 06663232, Babington House, 26 College Road,
Chilwell, Nottingham NG9 4AS


There is no easy way to use the existing US-based report for non-US income

tax reporting. Of course it can be done with a bunch of re-programming.

I maintain this part of gnucash and plan in the future to make changes that
actually would allow this. For the US, since the current system is based on
'txf' codes, the maintenance of which is dormant, the system is gradually
getting stale; I would like to make the 'txf' code not the key but an
attribute of a hidden key so that new codes could be added even if no
'txf'' code exists for an item. If I do this in a fairly generalized way,
then it could be used to support multiple taxing jurisdictions (within the
US and outside of the US) simultaneously. If in an even more generalized
way, it could support user-managed tagging of accounts, transactions, and
splits, a feature which has also been asked for and I would like to use
personally. But this will take a bit of effort and time to accomplish.

Alex

Thanks much for your effort and future efforts.

Perhaps if you started with the idea of a user-managed tagging of 
accounts, transactions, and splits - it would be flexible enough to be 
useful without a lot of extra user keyboard effort.


I myself don't yet use GnuCash, but I would like to use it to centralize 
the storage of my (minimal) keystrokes and and be able to generate 
useful reports. My records are in various bank on-line bill paying 
systems that don't really record what I would like to record (such as 
the actual payee and why). If I dump these bank records (US banks), I 
only get 'CHECK 2014', '20.47'. Pretty dismal.


Many years ago, I was quite happy with Quicken for the Mac. Using the 
Checkfree feature, I could pay my bills and have good data stored on my 
own computer. But Quicken for the Mac has been gutted by Intuit and 
somehow the bill pay feature doesn't work the same way. Until recently, 
I was writing out checks by hand and mailing them.


I do have records downloaded from German accounts that are wonderful in 
their completeness (MT940 in UTF-8 character set). I process these using 
a program developed over a number of years. The key feature is a set of 
patterns which categorize all of the transactions. The MT940 files also 
have enough redundancy to give me some confidence in my own program. My 
balance equals the bank balance regularly over the past couple of years.


The categorization patterns require maintenance as the bank changes 
their standards over the years - the character set was only recently 
standardized on utf-8. Also, even though umlauts are possible in the 
character set (and my patterns..) the bank has recently chosen to use 
'UE' instead of the u with two dots over it. Thus my collection of 
patterns has many umlaut variations (as well as detecting infrequent 
mispelled data). The pattern file is currently 495 lines long. Bank data 
stretches back to 2006.


If your user-managed tagging could incorporate user-written regular 
expression patterns, I think it could go a long way toward satisfying a 
big range of GnuCash users.


Best regards

Bob G


___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel