Re: [GNC] Gnucash fails to run after upgrade from Ubuntu 14.04 to 16.04

2019-08-07 Thread Colin Law
On Thu, 8 Aug 2019 at 07:44, James E  wrote:
>
> I  used to run  Gnucash 2.6.12  in Ubuntu 14.04 .
>
> I upgraded  to Ubuntu 16.04. During the upgrade  I was asked if I wanted
> to keep several Gnucash   files/piece of information – one of which was  the
> Alpha Advantage API key .  I replied that I did .
>
> The upgrade appeared to have finished successfully  . All of the
> programmes/applications worked   but  with  one exception – Gnucash.

What do these commands show?
which gnucash
apt-cache policy gnucash

Colin
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Gnucash fails to run after upgrade from Ubuntu 14.04 to 16.04

2019-08-07 Thread James E
I  used to run  Gnucash 2.6.12  in Ubuntu 14.04 .

I upgraded  to Ubuntu 16.04. During the upgrade  I was asked if I wanted
to keep several Gnucash   files/piece of information – one of which was  the
Alpha Advantage API key .  I replied that I did .

The upgrade appeared to have finished successfully  . All of the
programmes/applications worked   but  with  one exception – Gnucash.

The Gnucash loading screen and the tip of the day showed  up for a several
seconds 
and both disappeared  again. 

I  then decided to install  Gnucash  from the  Ubuntu Software centre –
hoping that this would be compatible with 16.04   . So I removed the
existing  Gnucash  using the Ubuntu Software centre and installed Gnucash  .   

This failed  in the same way - the Gnucash loading screen and the tip of the
day showed up for a several seconds  and both disappeared again. 

I found from research that Ubuntu repositories usually contain a version of
Gnucash that is a release or two behind the latest stable version and  that
Gnucash 2.6.12 is included in Ubuntu 16.04 –  this is the  same Gnucash
version as I was using   in Ubuntu  14.04 .


I give below  the terminal output  when I tried to run Gnucash :

jm@jm-OptiPlex-9020:~$ gnucash
;;; note: auto-compilation is enabled, set GUILE_AUTO_COMPILE=0
;;;   or pass the --no-auto-compile argument to disable.
;;; compiling /usr/share/gnucash/scm/gnucash/business-gnome.scm
;;; compiling /usr/share/gnucash/scm/gnucash/report/business-reports.scm
;;; WARNING: compilation of
/usr/share/gnucash/scm/gnucash/report/business-reports.scm failed:
;;; ERROR: In procedure #: Unbound variable:
gnc:menuname-business-reports
;;; WARNING: compilation of
/usr/share/gnucash/scm/gnucash/business-gnome.scm failed:
;;; ERROR: In procedure #: Unbound variable:
gnc:menuname-business-reports
Backtrace:
In ice-9/boot-9.scm:
 157: 11 [catch #t # ...]
In unknown file:
   ?: 10 [apply-smob/1 #]
   ?: 9 [call-with-input-string "(gnc:report-menu-setup)" ...]
In ice-9/boot-9.scm:
2401: 8 [save-module-excursion #]
In ice-9/eval-string.scm:
  44: 7 [read-and-eval # #:lang ...]
  37: 6 [lp (gnc:report-menu-setup)]
In gnucash/report/report-gnome.scm:
 155: 5 [gnc:report-menu-setup]
In unknown file:
   ?: 4 [gnc-hook-run "hook_report" ()]
In ice-9/eval.scm:
 387: 3 [eval # #]
 387: 2 [eval # #]
 393: 1 [eval # #]
In unknown file:
   ?: 0 [memoize-variable-access! # #]

ERROR: In procedure memoize-variable-access!:
ERROR: Unbound variable: gnc:menuname-business-reports
jm@jm-OptiPlex-9020:~$

 



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Improvements on tooltips and help sections.

2019-08-07 Thread Frank H. Ellenberger
Hi all,

I am putting this on the user list to get some broader input of
opinions and suggestions.

It started with
https://lists.gnucash.org/pipermail/gnucash-de/2019-August/010704.html,
were a user reported problems about the usage of counter formats. I
watched several issues with our tooltips and the related help
sections.

The related snippets:
https://github.com/Gnucash/gnucash/blob/maint/gnucash/gtkbuilder/dialog-invoice.glade#L728:
The invoice ID number. If left blank a reasonable number will be
chosen for you.

I see in this example 3 different issues:
1. The first sentence is no sentence. That makes it almost impossible
to translate it.

2. It does not tell when formating will happen. (only if kept empty on
the automatic generated number).

3. In most cases the user should leave it empty to use the built in
counter and format. That info  is missing and heightens the treshold
for new users.This is a typical case, where extensions, here: allow
overriding of autogenerated numbers, are neutral documented and not
well marked as exemptions.

The related help section
https://github.com/Gnucash/gnucash-docs/blob/maint/help/C/Help_ch_Business.xml#L533
ff:
Invoice Information - Invoice ID - the
identification number of this invoice. This is your internal number
for this invoice. If you leave it blank, an invoice number will be
generated automatically. See 
for more info

and the referenced Counters have their explanation in
https://github.com/Gnucash/gnucash-docs/blob/maint/help/C/Help_ch_Customize.xml#L1622

I assume it will be similar for the other business objects.

Any suggestions to improve it are welcome.

Regards
Frank
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Setting up a new accounting scheme in GnuCash

2019-08-07 Thread Adrien Monteleone
Ah, thanks for the clarification.

Regards,
Adrien

> On Aug 7, 2019, at 4:10 PM, Frank H. Ellenberger 
>  wrote:
> 
> Hi Adrien,
> 
> part of the confusion might be:
> Frank asked for the account type to create a few, which you tried to answer.
> I saw, the requested accounts were already defined in the template and
> referenced the group containing them, not the type itself.
> 
> Am Mi., 7. Aug. 2019 um 21:54 Uhr schrieb Adrien Monteleone
> :
>> 
>> 
>> 
>>> On Aug 7, 2019, at 2:41 PM, Frank H. Ellenberger 
>>>  wrote:
>>> 
>>> 
>>> 
>>> 7 Kostpijs rekeningen   (Cost price bills?)
> This is where I book my bikes if I buy them from my supplier during the 
> year. It will raise my Assets I suppose.
 
 These are the invoices from the supplier or the value of the bikes 
 themselves? If the bikes, that would be inventory above, if the invoices, 
 that would be Accounts Payable - a liability.
>>> 
>>> Not quite, while buying they increase VOORADEN, on sale they move to
>>> INKOOPWARDE VAN DE UMZET.
>> 
>> So Cost of Goods Sold? That would be an expense account. Curious that NL 
>> mixes purchases (inventory) with COGS rather than separating them out.
> 
> No, it is the same:
> VOORADEN/Inventory: Activa/assets
> INKOOPWARDE VAN DE UMZET/Cost of Goods Sold: Kosten/expense
> UMZET/Goods Sold: Opbrengsten/income
> 
>> Regards,
>> Adrien
> 
> Regards
> Frank


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Setting up a new accounting scheme in GnuCash

2019-08-07 Thread Frank H. Ellenberger
Hi Adrien,

part of the confusion might be:
Frank asked for the account type to create a few, which you tried to answer.
I saw, the requested accounts were already defined in the template and
referenced the group containing them, not the type itself.

Am Mi., 7. Aug. 2019 um 21:54 Uhr schrieb Adrien Monteleone
:
>
>
>
> > On Aug 7, 2019, at 2:41 PM, Frank H. Ellenberger 
> >  wrote:
> >
> >
> >
> > 7 Kostpijs rekeningen   (Cost price bills?)
> >>> This is where I book my bikes if I buy them from my supplier during the 
> >>> year. It will raise my Assets I suppose.
> >>
> >> These are the invoices from the supplier or the value of the bikes 
> >> themselves? If the bikes, that would be inventory above, if the invoices, 
> >> that would be Accounts Payable - a liability.
> >
> > Not quite, while buying they increase VOORADEN, on sale they move to
> > INKOOPWARDE VAN DE UMZET.
>
> So Cost of Goods Sold? That would be an expense account. Curious that NL 
> mixes purchases (inventory) with COGS rather than separating them out.

No, it is the same:
VOORADEN/Inventory: Activa/assets
INKOOPWARDE VAN DE UMZET/Cost of Goods Sold: Kosten/expense
UMZET/Goods Sold: Opbrengsten/income

> Regards,
> Adrien

Regards
Frank
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Setting up a new accounting scheme in GnuCash

2019-08-07 Thread Adrien Monteleone



> On Aug 7, 2019, at 2:41 PM, Frank H. Ellenberger 
>  wrote:
> 
> 
> 
> 7 Kostpijs rekeningen   (Cost price bills?)
>>> This is where I book my bikes if I buy them from my supplier during the 
>>> year. It will raise my Assets I suppose.
>> 
>> These are the invoices from the supplier or the value of the bikes 
>> themselves? If the bikes, that would be inventory above, if the invoices, 
>> that would be Accounts Payable - a liability.
> 
> Not quite, while buying they increase VOORADEN, on sale they move to
> INKOOPWARDE VAN DE UMZET.

So Cost of Goods Sold? That would be an expense account. Curious that NL mixes 
purchases (inventory) with COGS rather than separating them out.

Regards,
Adrien
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Setting up a new accounting scheme in GnuCash

2019-08-07 Thread Frank H. Ellenberger
Am Mi., 7. Aug. 2019 um 18:47 Uhr schrieb Adrien Monteleone
:
> > On Aug 7, 2019, at 7:51 AM, Frank ter Braak  wrote:
> > I did ask my question in the dutch mailing list but it does not seem to be 
> > very busy there :-(

Keep in mind, the dutch list has not so many members as the english
list. And then on all  lists most users a no business users. So you
can not expect to get the answer in less than 24h.

> > I did start of with the GrootboekSchema 1.1 but this list has no clear 
> > types for these 4 accounts:

Frank, it seems the grouping of your starting standard is slightly
different from RGS 1.1.
Tip, you should sort the CoA by Rekeningsnummer instead of
Rekeningnaam to have similar accounts together.

> >
> >>> 2 Tussenrekeningen  (suspense accounts?)
> > One example is “Kruisposten” where I book money that goes from one bank to 
> > another bank or my cashregister. It should add up to ZERO at the end.
>
> A current asset account. It would be assigned type ‘asset’ and you can put it 
> where ever you want/need in your asset part of the tree. If you prefer a top 
> level, that is okay as well.

Right, Kruisposten is already there below LIQUIDE MIDDELEN.

> >>> 3 Voorraadrekeningen(Stock accounts?)
> > This is where I put all of my stock (bikes and parts in my shop) at the 
> > start of my year in the opening balance.
> This would be ‘inventory’ in English. Just another current asset account 
> here. Give it type ‘asset’ and place it where you want/need.

Right, see VOORADEN

> >>> 7 Kostpijs rekeningen   (Cost price bills?)
> > This is where I book my bikes if I buy them from my supplier during the 
> > year. It will raise my Assets I suppose.
>
> These are the invoices from the supplier or the value of the bikes 
> themselves? If the bikes, that would be inventory above, if the invoices, 
> that would be Accounts Payable - a liability.

Not quite, while buying they increase VOORADEN, on sale they move to
INKOOPWARDE VAN DE UMZET.

> >>> 9 Financiële baten en lasten(Financial income and 
> >>> expenses?)
> > Some strange accounts like the one for booking cash diferences of unusual 
> > income of loss.
> If I’m understanding this right, this would be miscellaneous income/expenses 
> or non-operating income/expenses correct?

How about FINANCIELE BATEN EN LASTEN?

> You could have a miscellaneous expense account (and sub accounts under that 
> if desired) for when they are expenses and the same under income. Use the 
> correct one for each case, or have only one account or set of accounts under 
> whichever is the usual case and occasionally you’ll have the other side of 
> the transaction there.
>
> Also note, you can assign account numbers to each account and you can display 
> that column on the account tab and sort the account tab by account number if 
> you prefer.
>
> Once the numbers are assigned, you can also type the numbers instead of the 
> names when entering transactions.
>
> Regards,
> Adrien

Regards
Frank
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Account Hirarchy with different currencies cause online quotes to fail in some cases

2019-08-07 Thread Frank H. Ellenberger
Am Mi., 7. Aug. 2019 um 19:34 Uhr schrieb Ove Grunnér :
>
> No Problem, John, thanks for helping,
>
> Anyone else got this working somehow?
>
> br Ove.

The answer would depend on your book cuurrency, which I could not find
in your description. Then I would assume, the report currency and what
you want to see are the same?

Then it is obvisious, you should fetch the rates between your book
currency and the foreign currencies...

Regards
Frank
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Proposed change of "U+R" and "R" in the Import main matcher.

2019-08-07 Thread Adrien Monteleone
David & Geert,

Thanks for the explanation!

While I haven’t had the need (yet) to use the importer, I agree that U+M/M 
would be more clear.

Regards,
Adrien

> On Aug 7, 2019, at 7:01 AM, David Cousens  wrote:
> 
> Adrien,
> 
> Even if it has been reconciled in another program I think you would want to
> check the reconciliation to make sure the importer had imported everything
> completely. The reconciliation process should be very quick if the import
> has been correct.
> 
> I think as Geert mentoins in another post, GnuCash data can be exported with
> the reconcilation status and in that case one might want to import the
> reconcilation status. Eg if shifting historical records to another book to
> keep the file size small for those who do that. The purpose of the U+R and R
> in the import matcher itself is really to indicate the satus of the match
> and AFAIK it doesn't even use the reconciled status information in a
> transaction in the matching process, at least in the code I have looked
> through so far.
> 
> It was why I initially proposed U+M and M as an alternative to make clear
> that it really is the status of the match and nothing to do with the actual
> reconciliataion status of the transaction. Even using "U+C" and "C" in the
> importer could in principle lead new users to confusing the status of the
> match with the reconciliation status. In the case where the status of an
> imported transaction was reconciled, it may make some sense to override the
> "c" setting on import. But since reconciliation is about checking the data
> in the book it is being imported to, I personally would prefer that it be
> imported as cleared and then set to reconciled in a proper reconciliation
> process not the  import process which might contain errors.
> 
> Another option could be to have an option to either import or ignore the
> reconciliation status on import if it exists in the import as a future
> enhancement.
> 
> David Cousens

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Account Hirarchy with different currencies cause online quotes to fail in some cases

2019-08-07 Thread Ove Grunnér
No Problem, John, thanks for helping,

Anyone else got this working somehow?

br Ove.



On Tue, 6 Aug 2019 at 21:55, John Ralls  wrote:

>
>
> > On Aug 6, 2019, at 11:06 AM, Ove  wrote:
> >
> > Thanks very much for that John.
> >
> > I did as you suggested, and it fixed the original problem but exposed a
> > different one.
> >
> > I get two currency quotes, EUR/SEK & EUR/USD from the online quote
> function.
> >
> > However since there is no SEK/USD quote , the total of my SEK Asset does
> not
> > include the USD ammounts, e.g.
> >
> > Assets:€xxx (Correct, equivalent of Kr70 + $12 + €1 in
> Euro)
> >   Brokerage:  Kr70  (missing the USD amount)
> >USD Assets:  $12
> >   USD Cash $4
> >   USD Stocks:  $8
> >  AMZN 1 Amazon
> >SEK Assets: Kr70
> >   SEK Cashkr40
> >   SEK Stocks:Kr20
> >  AZN.STO  1 AstraZeneca
> >   SEK Mutual Funds:  kr10
> >  Handelsbanken Multiasset 50 1 Handelsbanken
> >   Bank Account (EUR) €1.
> >
> > In order to try to reset it:
> > I Deleted all currency quotes,
> > I un-ticked currency quotes in the Security Editor, and then re-Ticked
> them
> > I have tried only having USD & SEK ticked, and I have tried having USD &
> SEK
> > & EUR ticked.
> > however I only receive the online quotes for EUR/USD & EUR/SEK.
> > If I insert a manual quote for USD/SEK it will add up correctly.
> >
> > Is there a way to get Triangle quotes like this via online quotes, or is
> > there another way to achieve what I want to do.
> >
> > Possibly also worth mentioning, when I get the two quotes for EUR/USD &
> > EUR/SEK the window in Price Database looks like this:
> > +Currency
> >EUR(Euro)
> > where + denotes the drop down triangle
> > Note that there is no triangle to expand to look at what is under the EUR
> > quote.
> >
> > Rather than what I would have expected:
> > +Currency
> >+SEK (Swedish Krona)
> >   SEK (Swedish Krona)EUR (Euro)  06/08/19
> > Finance::Quote Last  0.093101
> >+USD (US Dollar)
> >   USD (US Dollar)   EUR (Euro)  06/08/19
> > Finance::Quote Last  0.892777
> >
> >
> > when I look at the gnucash XML, it looks like this:
> >
> > 
> >  CURRENCY
> >  EUR
> >  
> >
> >  auto_quote_control
> >  false
> >
> >  
> > 
> > 
> >  CURRENCY
> >  SEK
> >  
> >  currency
> >  
> > 
> > 
> >  CURRENCY
> >  USD
> >  
> >  currency
> >  
> > 
> >
> > and the resulting quotes:
> > 
> >  
> >9724d1f0b2cc4c709cba5026a8a01928
> >
> >  CURRENCY
> >  EUR
> >
> >
> >  CURRENCY
> >  SEK
> >
> >
> >  2019-08-06 18:53:19 +0100
> >
> >Finance::Quote
> >last
> >10741/1000
> >  
> >  
> >60e4902beaab4a8f8dbf6e5227257336
> >
> >  CURRENCY
> >  EUR
> >
> >
> >  CURRENCY
> >  USD
> >
> >
> >  2019-08-06 18:53:19 +0100
> >
> >Finance::Quote
> >last
> >11201/1
> >  
> >  
> >
> >
> > Many thanks in advance.
>
> Sorry, I don't know the answer to that and I haven't found a good answer
> in the relevant code.
>
> Regards,
> John Ralls
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Proposed change of "U+R" and "R" in the Import main matcher.

2019-08-07 Thread Patrick
> The csv import can import reconciliation info so in principle you could
import
reconciled transactions.

Sorry for the somewhat tangential comment, but since it is I think somewhat
relevant, and I thought it might be of interest to someone - when importing
transactions from a csv, GnuCash didn't seem to allow the first split in a
multi-split transaction to import as anything other than the "c" (cleared)
state, regardless of what the csv contents were. I ended up modifying the
source code to allow this, but maybe it is possible another way, and I just
couldn't find it. The bug linked below suggested to me that there might not
be a way.

References
https://bugs.gnucash.org/show_bug.cgi?id=796890
https://lists.gnucash.org/pipermail/gnucash-user/2019-July/085876.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Setting up a new accounting scheme in GnuCash

2019-08-07 Thread Adrien Monteleone


> On Aug 7, 2019, at 7:51 AM, Frank ter Braak  wrote:
> 
> I did ask my question in the dutch mailing list but it does not seem to be 
> very busy there :-(
> 
> I did start of with the GrootboekSchema 1.1 but this list has no clear types 
> for these 4 accounts:
> 
> 
>>> 2 Tussenrekeningen  (suspense accounts?)
> One example is “Kruisposten” where I book money that goes from one bank to 
> another bank or my cashregister. It should add up to ZERO at the end.

A current asset account. It would be assigned type ‘asset’ and you can put it 
where ever you want/need in your asset part of the tree. If you prefer a top 
level, that is okay as well.
> 
>>> 3 Voorraadrekeningen(Stock accounts?)
> This is where I put all of my stock (bikes and parts in my shop) at the start 
> of my year in the opening balance.
This would be ‘inventory’ in English. Just another current asset account here. 
Give it type ‘asset’ and place it where you want/need.

> 
> 
>>> 7 Kostpijs rekeningen   (Cost price bills?)
> This is where I book my bikes if I buy them from my supplier during the year. 
> It will raise my Assets I suppose.

These are the invoices from the supplier or the value of the bikes themselves? 
If the bikes, that would be inventory above, if the invoices, that would be 
Accounts Payable - a liability.
> 
> 
>>> 9 Financiële baten en lasten(Financial income and 
>>> expenses?)
> Some strange accounts like the one for booking cash diferences of unusual 
> income of loss.
If I’m understanding this right, this would be miscellaneous income/expenses or 
non-operating income/expenses correct?

You could have a miscellaneous expense account (and sub accounts under that if 
desired) for when they are expenses and the same under income. Use the correct 
one for each case, or have only one account or set of accounts under whichever 
is the usual case and occasionally you’ll have the other side of the 
transaction there.

Also note, you can assign account numbers to each account and you can display 
that column on the account tab and sort the account tab by account number if 
you prefer.

Once the numbers are assigned, you can also type the numbers instead of the 
names when entering transactions.

Regards,
Adrien
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] QIF Import Problem

2019-08-07 Thread Christopher Lam
For completion, Colin sent me 2 QIF files from 2 different bank accounts.
Some lines indicated transfer from 1st QIF acct to 2nd QIF acct.

The solution is tedious. Importing QIF acct will require careful mapping of
QIF account/category, and when importing the 2nd QIF account, the importer
*will* *(very slowly)* attempt to find duplicates if the account names are
correctly chosen, and allow you to correctly match transfers. Matched
transfers are skipped thereby avoiding duplicates.

The good news is the QIF account/category -> GnuCash account mapping is
saved between imports.

Thus it'sa good idea to import accounts in short date periods; the mapping
will thus be preserved inbetween.

The next release *will* feature a much faster duplicate finder.

On Sun, 4 Aug 2019 at 19:52, Colin McLellan 
wrote:

> Hi,
>
> I'm trying to switch to GnuCash from Quicken 2016 and I'm running into a
> problem where all transfers between accounts are duplicated after the QUF
> import.  I am aware that this is not a new problem and I have read meany
> threads on here going back at least ten years about this.
>
> I tried exporting just one month of my chequing and savings accounts to
> separate QIF files and then importing them into GnuCash simultaneously and
> separately.  In each case, 100% of the time all transfers between the
> accounts are duplicated in each account.  Whatever is supposed to be
> flagging these duplicates is not working.  If I do them separately, I do
> get the option to select the duplicates, but ultimately I want to import
> the past 15 years of transaction level detail, and I am not willing to go
> the manual route.
>
> My question is: Is there any new information about a solution to this
> problem?
>
> Thanks,
>
> Colin
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Setting up a new accounting scheme in GnuCash

2019-08-07 Thread Frank ter Braak
I did ask my question in the dutch mailing list but it does not seem to be very 
busy there :-(

I did start of with the GrootboekSchema 1.1 but this list has no clear types 
for these 4 accounts:


>> 2 Tussenrekeningen  (suspense accounts?)
One example is “Kruisposten” where I book money that goes from one bank to 
another bank or my cashregister. It should add up to ZERO at the end.

>> 3 Voorraadrekeningen(Stock accounts?)
This is where I put all of my stock (bikes and parts in my shop) at the start 
of my year in the opening balance.


>> 7 Kostpijs rekeningen   (Cost price bills?)
This is where I book my bikes if I buy them from my supplier during the year. 
It will raise my Assets I suppose.


>> 9 Financiële baten en lasten(Financial income and 
>> expenses?)
Some strange accounts like the one for booking cash diferences of unusual 
income of loss.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Proposed change of "U+R" and "R" in the Import main matcher.

2019-08-07 Thread David Cousens
Adrien,

Even if it has been reconciled in another program I think you would want to
check the reconciliation to make sure the importer had imported everything
completely. The reconciliation process should be very quick if the import
has been correct.

I think as Geert mentoins in another post, GnuCash data can be exported with
the reconcilation status and in that case one might want to import the
reconcilation status. Eg if shifting historical records to another book to
keep the file size small for those who do that. The purpose of the U+R and R
in the import matcher itself is really to indicate the satus of the match
and AFAIK it doesn't even use the reconciled status information in a
transaction in the matching process, at least in the code I have looked
through so far.

It was why I initially proposed U+M and M as an alternative to make clear
that it really is the status of the match and nothing to do with the actual
reconciliataion status of the transaction. Even using "U+C" and "C" in the
importer could in principle lead new users to confusing the status of the
match with the reconciliation status. In the case where the status of an
imported transaction was reconciled, it may make some sense to override the
"c" setting on import. But since reconciliation is about checking the data
in the book it is being imported to, I personally would prefer that it be
imported as cleared and then set to reconciled in a proper reconciliation
process not the  import process which might contain errors.

Another option could be to have an option to either import or ignore the
reconciliation status on import if it exists in the import as a future
enhancement.

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Proposed change of "U+R" and "R" in the Import main matcher.

2019-08-07 Thread David T. via gnucash-user

Building on Christopher's comment, my experience was that if a transaction to 
be imported has the flag set, Gnucash imports that value. I'm not sure the 
exact mechanics or heuristics (and it was a long time ago that I migrated to 
Gnucash), but I know I didn't have to reconcile my imported transactions all 
over again. 

This is another reason (probably a significant one) not to tinker with the 
reconcile values, BTW. Someone would have to rewrite every incoming transaction 
to use 'R' instead of the 'Y' from other apps.

David
 
 
  On Wed, Aug 7, 2019 at 13:38, Christopher Lam 
wrote:   Hi Geert
Wish to add a small contribution:

On Wed., 7 Aug. 2019, 15:43 Geert Janssens, 
wrote:

>
> For the other importers, this isn't implemented. The idea is that you
> typically import from bank statements in qif/ofx/csv format and banks
> don't
> have reconcilation information. The other acounting application I use can
> also
> import bank statements, but won't reconcile them either.
>

The qif importer does have ability to set a split's reconciliation status.
The qif C line may specify * cleared X reconciled ! budgeted (unused by
importer) transactions, but I guess only quicken exports should have this
information.



>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Setting up a new accounting scheme in GnuCash

2019-08-07 Thread Frank H. Ellenberger
Hello Frank,

I had hoped one of the native speakers had answered, but it seems they
are currently all in their caravans. ;-)

How about using the Referentie GrootboekSchema, versie 1.1, which we
are shipping with Gnucash?
You should see it after downgrading your Gnucash Mac version as
written before on the Dutch list in Bestand->Nieuw Bestand on the "Aan
the maken Rekeningen selecteren" page.

If there are issues with the template the should be discussed on the
dutch list, but you can CC me.

Regards
Frank

The problem with your approach below is

Am Mi., 7. Aug. 2019 um 10:13 Uhr schrieb Frank ter Braak
:
>
> Dear GnuCash friends,
>
> I want to switch from an old accounting program to GnuCash and the first 
> requirement is to set up a good accounting plan.
>
> Now I know what I used for years and also what is used as standard in the 
> Netherlands, but how does that match the format that GnuCash uses? Who helps 
> me with some insight and understanding.
>
>
> A standard classification of the headings within the accounting scheme in NL 
> (Eng?) looks as follows:
>
> 0 Vaste activa en passiva   (Fixed assets and 
> liabilities?)
>
> 1 Vlottende activa en passiva   (Current assets and 
> liabilities?)
>
> 2 Tussenrekeningen  (suspense accounts?)
>
> 3 Voorraadrekeningen(Stock accounts?)
>
> 4 Kostenrekeningen  (Expense?)
>
> 7 Kostpijs rekeningen   (Cost price bills?)
>
> 8 Omzet rekeningen  (Income?)
>
> 9 Financiële baten en lasten(Financial income and 
> expenses?)
>
>
>
>
> But GnuCash knows ACCOUNT TYPE and I assume that it must match the right way 
> because otherwise the whole program will go wild :-( GnuCash therefore uses 
> this classification (without numbers).
>
> • Asset (Activa)
> • Cash  (Contant)
> • Bank  (Bank)
> • Currency  (Handelsportefeuille)
> • Stock (Aandelen)
> • Mutual fund   (Beleggingsfondsen)
> • Liability (Passiva/Vreemdvermogen)
> • Credit Card   (Creditcard)
> • Income(Opbrengsten/Baten)
> • Expence   (Kosten)
> • Equity(Eigen vermogen)
>
> (Are these translations actually correct? I am struggling with the NL and Eng 
> versions.)
>
>
> Question:
>
> How may, can or should I enter the above format in the account types of 
> GnuCash.
>
> Where do these belong:
> 2 suspense accounts
> 3 Stock accounts
> 7 Cost price bills
> and
> 9 Financial income and expenses
>
> I can't just choose that freely, can I?
>
> Who can show me something here because unfortunately I don't see much in this 
> direction online.
>
>
> Kind regards,
> Frank ter Braak
> Tourslaan 33
> 5627 KW Eindhoven
> 040-2424368
> 06-33700816
>
>
>
>
> QUESTION DUTCH ORIGINAL (mailed without succes to the NL mailinglist)
>
> Beste GnuCash vrienden,
>
> Ik wil overstappen van een oud boekhoudprogramma naar GnuCash en de eerste 
> vereiste is om een goed rekeningschema op te zetten.
>
> Nu weet ik wat ik jaren gebruikte en ook wat zo ongeveer in Nederland als 
> standaard gebruikt wordt maar hoe matcht dat met de indeling die GnuCash 
> gebruikt? Wie helpt me daar met wat inzicht en begrip.
>
>
> Een standaard indeling van de rubrieken binnen het rekeningschema ziet er in 
> NL bv als volgt uit:
>
> 0 Vaste activa en passiva
>
> 1 Vlottende activa en passiva
>
> 2 Tussenrekeningen
>
> 3 Voorraadrekeningen
>
> 4 Kostenrekeningen
>
> 7 Kostpijs rekeningen
>
> 8 Omzet rekeningen
>
> 9 Financiële baten en lasten
>
>
> Maar GnuCash kent ACCOUNT TYPE en in neem aan dat ik dat juist matchen moet 
> omdat anders heel het programma in de soep loopt. GnuCash dus hanteert deze 
> indeling (nog zónder nummers).
>
> • Asset (Activa)
> • Cash  (Contant)
> • Bank  (Bank)
> • Currency  (Handelsportefeuille)
> • Stock (Aandelen)
> • Mutual fund   (Beleggingsfondsen)
> • Liability (Passiva/Vreemdvermogen)
> • Credit Card   (Creditcard)
> • Income(Opbrengsten/Baten)
> • Expence   (Kosten)
> • Equity(Eigen vermogen)
>
> (kloppen deze vertalingen trouwens, ik worstel wat met de NL en Eng versies.)
>
>
> VRAAG:
>
> Hoe mag, kan of moet ik de bovenstaande indeling invoeren in de 
> rekeningsoorten van GnuCash.
>
> Waar horen bv deze:
> 2 tussenrekeningen
> 3 Voorraadrekeningen
> 7 Kostpijs rekeningen
> en
> 9 Financiële baten en lasten
>
> Dat kan ik niet zomaar vrij indelen toch!?!?
>
> Wie kan me hier wat wegwijs maken want online zie ik helaas nog weinig in 
> deze richting.
>
>
>
> Vriendelijk groetend,
> Frank ter Braak
> Tourslaan 33
> 5627 KW Eindhoven
> 040-2424368
> 06-33700816
>
>
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https:/

Re: [GNC] Proposed change of "U+R" and "R" in the Import main matcher.

2019-08-07 Thread Geert Janssens
Op woensdag 7 augustus 2019 10:06:45 CEST schreef Christopher Lam:
> Hi Geert
> Wish to add a small contribution:
> 
> On Wed., 7 Aug. 2019, 15:43 Geert Janssens, 
> 
> wrote:
> > For the other importers, this isn't implemented. The idea is that you
> > typically import from bank statements in qif/ofx/csv format and banks
> > don't
> > have reconcilation information. The other acounting application I use can
> > also
> > import bank statements, but won't reconcile them either.
> 
> The qif importer does have ability to set a split's reconciliation status.
> The qif C line may specify * cleared X reconciled ! budgeted (unused by
> importer) transactions, but I guess only quicken exports should have this
> information.

Thanks for correcting me :)

Geert


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Setting up a new accounting scheme in GnuCash

2019-08-07 Thread Frank H. Ellenberger
Am Mi., 7. Aug. 2019 um 10:24 Uhr schrieb Liz :
>
> On Wed, 7 Aug 2019 10:09:05 +0200
> Frank ter Braak  wrote:
:
> > QUESTION DUTCH ORIGINAL (mailed without succes to the NL mailinglist)
> >
> > Beste GnuCash vrienden,
> >
> > Ik wil overstappen van een oud boekhoudprogramma naar GnuCash en de
> > eerste vereiste is om een goed rekeningschema op te zetten.
> >
> > Nu weet ik wat ik jaren gebruikte en ook wat zo ongeveer in Nederland
> > als standaard gebruikt wordt maar hoe matcht dat met de indeling die
> > GnuCash gebruikt? Wie helpt me daar met wat inzicht en begrip.
> >
> >
> > Een standaard indeling van de rubrieken binnen het rekeningschema
> > ziet er in NL bv als volgt uit:
> >
> > 0 Vaste activa en passiva
> >
> > 1 Vlottende activa en passiva
> >
> > 2 Tussenrekeningen
> >
> > 3 Voorraadrekeningen
> >
> > 4 Kostenrekeningen
> >
> > 7 Kostpijs rekeningen
> >
> > 8 Omzet rekeningen
> >
> > 9 Financiële baten en lasten
> >
> >
> > Maar GnuCash kent ACCOUNT TYPE en in neem aan dat ik dat juist
> > matchen moet omdat anders heel het programma in de soep loopt.
> > GnuCash dus hanteert deze indeling (nog zónder nummers).
> >
> > • Asset   (Activa)
> > • Cash(Contant)
> > • Bank(Bank)
> > • Currency(Handelsportefeuille)
> > • Stock   (Aandelen)
> > • Mutual fund (Beleggingsfondsen)
> > • Liability   (Passiva/Vreemdvermogen)
> > • Credit Card (Creditcard)
> > • Income  (Opbrengsten/Baten)
> > • Expence (Kosten)
> > • Equity  (Eigen vermogen)
> >
> > (kloppen deze vertalingen trouwens, ik worstel wat met de NL en Eng
> > versies.)
> >
> >
> > VRAAG:
> >
> > Hoe mag, kan of moet ik de bovenstaande indeling invoeren in de
> > rekeningsoorten van GnuCash.
> >
> > Waar horen bv deze:
> > 2 tussenrekeningen
> > 3 Voorraadrekeningen
> > 7 Kostpijs rekeningen
> > en
> > 9 Financiële baten en lasten
> >
> > Dat kan ik niet zomaar vrij indelen toch!?!?
> >
> > Wie kan me hier wat wegwijs maken want online zie ik helaas nog
> > weinig in deze richting.
> >
> >
> >
> > Vriendelijk groetend,
> > Frank ter Braak
>
> Frank, I started to think about this, and then remembered that there is
> a mailing list which might be able to help you
>
> https://lists.gnucash.org/mailman/listinfo/gnucash-nl

Liz, please compare above snippet with with
https://lists.gnucash.org/pipermail/gnucash-nl/2019q3/000356.html
;-)

> Liz

Frank
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Setting up a new accounting scheme in GnuCash

2019-08-07 Thread Liz
On Wed, 7 Aug 2019 10:09:05 +0200
Frank ter Braak  wrote:

> Dear GnuCash friends,
> 
> I want to switch from an old accounting program to GnuCash and the
> first requirement is to set up a good accounting plan.
> 
> Now I know what I used for years and also what is used as standard in
> the Netherlands, but how does that match the format that GnuCash
> uses? Who helps me with some insight and understanding.
> 
> 
> A standard classification of the headings within the accounting
> scheme in NL (Eng?) looks as follows:
> 
> 0 Vaste activa en passiva (Fixed assets and
> liabilities?)
> 
> 1 Vlottende activa en passiva (Current assets
> and liabilities?)
> 
> 2 Tussenrekeningen(suspense accounts?)
> 
> 3 Voorraadrekeningen  (Stock accounts?)
> 
> 4 Kostenrekeningen(Expense?)
> 
> 7 Kostpijs rekeningen (Cost price
> bills?)
> 
> 8 Omzet rekeningen(Income?)
> 
> 9 Financiële baten en lasten  (Financial income
> and expenses?)
> 
> 
> 
> 
> But GnuCash knows ACCOUNT TYPE and I assume that it must match the
> right way because otherwise the whole program will go
> wild :-( GnuCash therefore uses this classification (without numbers).
> 
> • Asset   (Activa)
> • Cash(Contant)
> • Bank(Bank)
> • Currency(Handelsportefeuille)
> • Stock   (Aandelen)
> • Mutual fund (Beleggingsfondsen)
> • Liability   (Passiva/Vreemdvermogen)
> • Credit Card (Creditcard)
> • Income  (Opbrengsten/Baten)
> • Expence (Kosten)
> • Equity  (Eigen vermogen)
> 
> (Are these translations actually correct? I am struggling with the NL
> and Eng versions.)
> 
> 
> Question:
> 
> How may, can or should I enter the above format in the account types
> of GnuCash.
> 
> Where do these belong:
> 2 suspense accounts
> 3 Stock accounts
> 7 Cost price bills
> and
> 9 Financial income and expenses
> 
> I can't just choose that freely, can I?
> 
> Who can show me something here because unfortunately I don't see much
> in this direction online.
> 
> 
> Kind regards,
> Frank ter Braak
> Tourslaan 33
> 5627 KW Eindhoven
> 040-2424368
> 06-33700816
> 
> 
> 
> 
> QUESTION DUTCH ORIGINAL (mailed without succes to the NL mailinglist)
> 
> Beste GnuCash vrienden,
> 
> Ik wil overstappen van een oud boekhoudprogramma naar GnuCash en de
> eerste vereiste is om een goed rekeningschema op te zetten.
> 
> Nu weet ik wat ik jaren gebruikte en ook wat zo ongeveer in Nederland
> als standaard gebruikt wordt maar hoe matcht dat met de indeling die
> GnuCash gebruikt? Wie helpt me daar met wat inzicht en begrip.
> 
> 
> Een standaard indeling van de rubrieken binnen het rekeningschema
> ziet er in NL bv als volgt uit:
> 
> 0 Vaste activa en passiva
> 
> 1 Vlottende activa en passiva
> 
> 2 Tussenrekeningen
> 
> 3 Voorraadrekeningen
> 
> 4 Kostenrekeningen
> 
> 7 Kostpijs rekeningen
> 
> 8 Omzet rekeningen
> 
> 9 Financiële baten en lasten
> 
> 
> Maar GnuCash kent ACCOUNT TYPE en in neem aan dat ik dat juist
> matchen moet omdat anders heel het programma in de soep loopt.
> GnuCash dus hanteert deze indeling (nog zónder nummers). 
> 
> • Asset   (Activa)
> • Cash(Contant)
> • Bank(Bank)
> • Currency(Handelsportefeuille)
> • Stock   (Aandelen)
> • Mutual fund (Beleggingsfondsen)
> • Liability   (Passiva/Vreemdvermogen)
> • Credit Card (Creditcard)
> • Income  (Opbrengsten/Baten)
> • Expence (Kosten)
> • Equity  (Eigen vermogen)
> 
> (kloppen deze vertalingen trouwens, ik worstel wat met de NL en Eng
> versies.)
> 
> 
> VRAAG:
> 
> Hoe mag, kan of moet ik de bovenstaande indeling invoeren in de
> rekeningsoorten van GnuCash. 
> 
> Waar horen bv deze:
> 2 tussenrekeningen 
> 3 Voorraadrekeningen
> 7 Kostpijs rekeningen
> en
> 9 Financiële baten en lasten
> 
> Dat kan ik niet zomaar vrij indelen toch!?!?
> 
> Wie kan me hier wat wegwijs maken want online zie ik helaas nog
> weinig in deze richting.
> 
> 
> 
> Vriendelijk groetend,
> Frank ter Braak

Frank, I started to think about this, and then remembered that there is
a mailing list which might be able to help you

https://lists.gnucash.org/mailman/listinfo/gnucash-nl

Liz
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Setting up a new accounting scheme in GnuCash

2019-08-07 Thread Frank ter Braak
Dear GnuCash friends,

I want to switch from an old accounting program to GnuCash and the first 
requirement is to set up a good accounting plan.

Now I know what I used for years and also what is used as standard in the 
Netherlands, but how does that match the format that GnuCash uses? Who helps me 
with some insight and understanding.


A standard classification of the headings within the accounting scheme in NL 
(Eng?) looks as follows:

0 Vaste activa en passiva   (Fixed assets and liabilities?)

1 Vlottende activa en passiva   (Current assets and 
liabilities?)

2 Tussenrekeningen  (suspense accounts?)

3 Voorraadrekeningen(Stock accounts?)

4 Kostenrekeningen  (Expense?)

7 Kostpijs rekeningen   (Cost price bills?)

8 Omzet rekeningen  (Income?)

9 Financiële baten en lasten(Financial income and expenses?)




But GnuCash knows ACCOUNT TYPE and I assume that it must match the right way 
because otherwise the whole program will go wild :-( GnuCash therefore uses 
this classification (without numbers).

• Asset (Activa)
• Cash  (Contant)
• Bank  (Bank)
• Currency  (Handelsportefeuille)
• Stock (Aandelen)
• Mutual fund   (Beleggingsfondsen)
• Liability (Passiva/Vreemdvermogen)
• Credit Card   (Creditcard)
• Income(Opbrengsten/Baten)
• Expence   (Kosten)
• Equity(Eigen vermogen)

(Are these translations actually correct? I am struggling with the NL and Eng 
versions.)


Question:

How may, can or should I enter the above format in the account types of GnuCash.

Where do these belong:
2 suspense accounts
3 Stock accounts
7 Cost price bills
and
9 Financial income and expenses

I can't just choose that freely, can I?

Who can show me something here because unfortunately I don't see much in this 
direction online.


Kind regards,
Frank ter Braak
Tourslaan 33
5627 KW Eindhoven
040-2424368
06-33700816




QUESTION DUTCH ORIGINAL (mailed without succes to the NL mailinglist)

Beste GnuCash vrienden,

Ik wil overstappen van een oud boekhoudprogramma naar GnuCash en de eerste 
vereiste is om een goed rekeningschema op te zetten.

Nu weet ik wat ik jaren gebruikte en ook wat zo ongeveer in Nederland als 
standaard gebruikt wordt maar hoe matcht dat met de indeling die GnuCash 
gebruikt? Wie helpt me daar met wat inzicht en begrip.


Een standaard indeling van de rubrieken binnen het rekeningschema ziet er in NL 
bv als volgt uit:

0 Vaste activa en passiva

1 Vlottende activa en passiva

2 Tussenrekeningen

3 Voorraadrekeningen

4 Kostenrekeningen

7 Kostpijs rekeningen

8 Omzet rekeningen

9 Financiële baten en lasten


Maar GnuCash kent ACCOUNT TYPE en in neem aan dat ik dat juist matchen moet 
omdat anders heel het programma in de soep loopt. GnuCash dus hanteert deze 
indeling (nog zónder nummers). 

• Asset (Activa)
• Cash  (Contant)
• Bank  (Bank)
• Currency  (Handelsportefeuille)
• Stock (Aandelen)
• Mutual fund   (Beleggingsfondsen)
• Liability (Passiva/Vreemdvermogen)
• Credit Card   (Creditcard)
• Income(Opbrengsten/Baten)
• Expence   (Kosten)
• Equity(Eigen vermogen)

(kloppen deze vertalingen trouwens, ik worstel wat met de NL en Eng versies.)


VRAAG:

Hoe mag, kan of moet ik de bovenstaande indeling invoeren in de rekeningsoorten 
van GnuCash. 

Waar horen bv deze:
2 tussenrekeningen 
3 Voorraadrekeningen
7 Kostpijs rekeningen
en
9 Financiële baten en lasten

Dat kan ik niet zomaar vrij indelen toch!?!?

Wie kan me hier wat wegwijs maken want online zie ik helaas nog weinig in deze 
richting.



Vriendelijk groetend,
Frank ter Braak
Tourslaan 33
5627 KW Eindhoven
040-2424368
06-33700816





___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Proposed change of "U+R" and "R" in the Import main matcher.

2019-08-07 Thread Christopher Lam
Hi Geert
Wish to add a small contribution:

On Wed., 7 Aug. 2019, 15:43 Geert Janssens, 
wrote:

>
> For the other importers, this isn't implemented. The idea is that you
> typically import from bank statements in qif/ofx/csv format and banks
> don't
> have reconcilation information. The other acounting application I use can
> also
> import bank statements, but won't reconcile them either.
>

The qif importer does have ability to set a split's reconciliation status.
The qif C line may specify * cleared X reconciled ! budgeted (unused by
importer) transactions, but I guess only quicken exports should have this
information.



>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Proposed change of "U+R" and "R" in the Import main matcher.

2019-08-07 Thread Geert Janssens
Op woensdag 7 augustus 2019 04:41:02 CEST schreef Adrien Monteleone:
> Just curious here,
> 
> So, if a user has years (decades even) of historical transactions that have
> already long ago been officially reconciled, the GnuCash importer does not
> offer the option of importing this historical data as reconciled but only
> ‘cleared’?
> 
> Thus, someone coming to GnuCash and wanting to import historical records for
> continuity (taking advantage of reporting that GnuCash offers which other
> software may not) the user has to re-reconcile each and every period for
> their entire historical import? Really?
> 
Yes and no.

The csv import can import reconciliation info so in principle you could import 
reconciled transactions.

For the other importers, this isn't implemented. The idea is that you 
typically import from bank statements in qif/ofx/csv format and banks don't 
have reconcilation information. The other acounting application I use can also 
import bank statements, but won't reconcile them either.

Note that correctly imported data is very easy to reconcile: You can just run 
a reconcile once at the date of the last imported transaction. The reconcile 
process will automatically select each cleared transaction (split actually) 
for reconciliation. So assuming there were no errors in the import process, 
the user could simply complete the reconciliation by clicking the finish 
button.

Regards,

Geert


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.