Re: [GNC] GnuCash 3.2 Released

[DaveC49]

Stephen,

It is generally a good idea to remove the previous version before installing
a new one. Gnucash will generally overwrite any existing files of the same
name, but you may be left with unnecessary files in some cases. Going from
3.1 to 3.2 should be OK as there are unlikey to be major changes in the file
structure, but between major version could be problematical There are
instructions on the Wiki in the build instructions for Ubuntu 16.04 for
doing uninstalls in a variety of circumstances including manually deleting
all the files which will be the same for 18.04. I'll put a note in there re
uninstalling previous versionsbefore the build instructions to make it
clearer.

If you still have the 3.1 build directory:
 open a shell and cd to the build directory then type 
 sudo make uninstall

then do the install of V3.2

This uses a manifest created when Gnucash was installed to uninstall all of
the program files. It leaves user preference files untouched.

David



-
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] How to regularly use two currencies

[Geert Janssens]

Hi Norbert,

While you seem to think you want to account in multiple currencies, your 
replies so far all suggest you only want to track payments in multiple 
currencies.

I read these requirements:
Quote 1:
"I have to know - at the end of the  day - how many US$, and how many Riel, 
should be in the cash boxes."
Quote 2:
"But while I have to keep track of the actual cash in the cash boxes, at 
certain times (daily, weekly, monthly etc.) I also need to know "how we did as 
a business" and this should say something in US$ (for all the activities which 
did happen in both currencies)."

So essentially this says you want to keep track of two cash boxes: one in US$ 
and one in Riel. Yet in the end you estimate your business in US$.

So your income and expense accounts should only exist in US$, while in your 
assets you will can two cash accounts: one in US$ and one in Riel.

When a customer pays you in Riel, you make a transaction from your Riel cash 
box account to your single income account (which is in US$) and apply the 
exchange rate from Riel to US$ to that transaction. By default gnucash will 
ask you for this exchange rate. If a customer pays in US$ you create a 
transaction from your US$ cash box account to your income account. As the 
currencies match there's no conversion rate to apply.

The same goes if you pay for expenses or goods to a supplier. If you pay in 
Riel you create a transaction from the Riel cash box account to the 
appropriate expense account (which is always in US$). If you pay in US$ the 
money goes out of your US$ cash box account into the (same) US$ expense 
account.

That will give you all the information you request:
Do you want to know what's in your cash boxes ? Check the appropriate cash box 
account or generate a report over it.
Do you want to know how you did as a business ? Generate a report over your 
income/expense accounts which are in US$.

Unless you have other requirements you didn't mention I don't think you need 
the parent/multi-currency-subaccount structure in your income and expense 
accounts as you have currently set up. And it will probably simplify your 
accounting if you could do without.

Regards,

Geert

Op zaterdag 30 juni 2018 11:58:51 CEST schreef Norbert Klein:
> Thanks, Geert,
> 
> I will respond between the lines.
> 
> On 29.6.2018 17:58, Geert Janssens wrote:
> > Hi Norbert,
> > 
> > I don't know the accounting customs of your country,
> 
> There are no general accounting customs set - everybody does what seems
> to cover the needs of he place.
> 
> > so first a question:
> > Is it common in Cambodia to *account* in two currencies as well or only to
> > *pay* in two currencies ?
> 
> In daily life, we may *pay* in either of the two currencies - it is only
> customary to make payments in Riel for small and in US$ for larger
> amounts. But again, there is no general definition what is "larger" - it
> is easier to handle bigger "values" in US$, where 1 US$ corresponds to
> roughly 4000 Riels.
> 
> We may ask in our shop - as an example - for a price of US$ 4.00, but
> the person may hand over 16,000 Riel. Or the other way round. I do not
> know if there are many countries with such a situation. But here it is
> totally flexible - every person, for every purchase, may choose one way,
> and the next minute for another purchase the other way.
> 
> So the answer is: BOTH - we pay in two currencies, but we also have to
> account in two currencies.
> 
> So in the shop we have a Riel cash box, and a US$ cash box, and while we
> enter for each purchase an amount - and I have to enter the amount
> either into the "Cash in wallet $" or into the "Cash in wallet Riel" -
> because we have all the time changes in both cash boxes. And for the
> same purchase I enter the amount either into the sub-account "Vegetables
> $" or "Vegetables R" - both under ONE Placeholder account "Vegetables"
> (set for US$)
> 
> > Or put differently - do you want to track your income in the two
> > currencies or just in one (hence the placeholder account) ?
> 
> For the actual conducting of purchases, I am tracking the US$ purchases
> and the Riel purchases separately - but I put both under ONE placeholder
> because I am not only interested in individual purchases, but also in
> the overall income (or loss) situation. I had assumed to have a common
> placeholder would serve this purpose. Maybe this was wrong.
> 
> > But you do want to be able to
> > accept/make payments in the two currencies ?
> 
> Yes - it depends on the buyer - depending of which of the two currencies
> he of she has in their purse.
> 
> > If you only want to accept/make payments in two currencies but just track
> > it in one, the account structure would be slightly different.
> 
> "track it only in one" - for the actual operation of the shop this is
> not possible. I have to know - at the end of the  day - how many US$,
> and how many Riel, should be in the cash boxes.
> 
> > If you want to track your income in 

Re: [GNC] New Balsheet (and P report)

[Christopher Lam]

Latest iteration of balsheet-pnl
https://screenshots.firefox.com/SzeQeQcyTTTGtb1a/null

Rules:
1. All totals will now be shown by the parent account - i.e. the first row
"Asset" has all asset amounts combined.
2. Every account-with-children will be bold and annotated "Total for ..."
to indicate this is an aggregate amount. See "Total Broker 200FUND + $2000"
3. Every account-with-children-with-own-amounts will have that amount shown
underneath the above aggregate. See "Broker $2000"
4. Account without children will be shown similar as 3. See "Broker:Stock
200FUND"

I dare say this strategy is much clearer than the existing balance sheet
reports.
C

On 30 June 2018 at 17:03, Christopher Lam  wrote:

> Hi Dave
>
> On 28/06/18 17:24, DaveC49 wrote:
>
>> Christopher,
>>
>> " except that Placeholder accounts
>> can also contain transactions therefore must not necessarily accumulate
>> their children account amounts. "
>>
>> I have to disagree with the above from an accounting perspective.
>>
>
> I was not describing UI restrictions; I was describing Report format. How
> to report 'accounts' with children, but with their own amounts?
>
> ---Answer 1---
>
> I had a multilevel strategy which (to me) was more clever, but it would
> seem is not desired.
> 1. If account has children, just render its own amount (e.g.
> Expenses:Utilities:Home = $10)
> 2. Move on to its child accounts (e.g. Expenses:Utilities:Home:Electric =
> $35, Expenses:Utilities:Beachhouse:Electric = $40)
> 3. If we are moving to a *higher* level account, then start rendering all
> intermediate sublevels will be subtotals, e.g.
>
>   Expenses = $0
>   Expenses:Utilities = $0
>   Expenses:Utilities:Home = $10 <- note this is a parent account
> with own $10 amount, gets its own row
>   Expenses:Utilities:Home:Water = $40
>   Expenses:Utilities:Home:Electric = $35
>   TOTAL Expenses:Utilities:Home = $85
>
>   Expenses:Utilities:Beachhouse
>   Expenses:Utilities:Beachhouse:Electric = $40
>   Expenses:Utilities:Beachhouse:Water = $20
>   TOTAL Expenses:Utilities:Beachhouse = $60
>
>   TOTAL Expenses:Utilities = $145
>
> However this approach seems to be adding too much complexity so I've
> removed it.
>
> ---Answer 2---
>
> In my current draft balsheet-pnl I am specifically *not* querying the
> account's placeholder flag. As we know it is being used both as a
> 'grouping' account (e.g. Asset:Fixed) and as a 'disabled' account flag
> (e.g. Asset:Closed:MyOldBank:Current).
>
> So the above P will be rendered as follows:
>
>   Total Expenses:Utilities = $145
>
>   Total Expenses:Utilities:Home = $85
>   Expenses:Utilities:Home = $10<-- 'parent' account with own
> $10 amount
>   Expenses:Utilities:Home:Water = $40
>   Expenses:Utilities:Home:Electric = $35
>
>   Total Expenses:Utilities:Beachhouse = $60<- parent account
> without amount... it doesn't get its own row
>   Expenses:Utilities:Beachhouse:Electric = $40
>   Expenses:Utilities:Beachhouse:Water = $20
>
> This is the 'recursive-balance' strategy. In this one, the Totals will
> always be presented in the parent account.
>
> ---
>
> Both methods are suitable for the current placeholder strategy.
>
>
>
> If accounts are setup as Placeholders initially (i.e. the checkbox set in
>> New Account dialog when they are created) they are readonly hence you
>> cannot
>> select them as targets for transactions (Placeholders do not appear in the
>> list of target accounts for a transaction and if you open the account
>> register you are warned that it is read only and you cannot enter
>> transactions from it so they cannot accumulate any balance when they are
>> initially set as Placeholder accounts.
>>
>> If you change an existing account to be a Placeholder and it already has
>> transactions into it then its balance will contain the sum of those
>> transactions. If you then createa sub account of it and create
>> transactions
>> into the sub-account, then the balance of the parent placeholder account
>> balance is correctly the sum of the balances of any sub accounts plus the
>> sum of any transactions into it before it was changed to a placeholder.
>>
>> If it was initially a placeholder, a user could subsequently change it to
>> be
>> a non-placeholder account  allowing it to accumulate transactions into it
>> and subsequently change it back.
>>
>> In either of these two cases, the correct balance for the placeholder
>> account is always the balance of any transactions into the placeholder
>> account itself plus the sum of balances of it's sub-accounts. In most
>> accounting practice the balances of the subaccounts would be indented to
>> the
>> right.
>>
>> To maintain consistency with this practice, if it is possible you could
>> present the balance of any direct transactions to the placeholder account
>> indented in the same manner as the sub-accounts as if it was a sub-account
>> and then have the non-indented balance for the placeholder account being
>> the
>> sum of that 

Re: [GNC] How to regularly use two currencies

[Norbert Klein]

Thanks, Geert,

for you clear and specific suggestions.

I think they will result in what I need - I will try to implement it and 
will let you (and gnucash-user@gnucash.org) know after some days.


There will be - as far as I can see now - only one additional procedure 
necessary (and a short additional time) for every shop action: to do the 
transaction from Riel to US$. But that is OK if all the other results 
will be what we need.


Thanks again for thinking through our special Cambodian "regularly two 
currencies" situation.


Norbert

=


On 30.6.2018 17:56, Geert Janssens wrote:

Hi Norbert,

While you seem to think you want to account in multiple currencies, your
replies so far all suggest you only want to track payments in multiple
currencies.

I read these requirements:
Quote 1:
"I have to know - at the end of the  day - how many US$, and how many Riel,
should be in the cash boxes."
Quote 2:
"But while I have to keep track of the actual cash in the cash boxes, at
certain times (daily, weekly, monthly etc.) I also need to know "how we did as
a business" and this should say something in US$ (for all the activities which
did happen in both currencies)."

So essentially this says you want to keep track of two cash boxes: one in US$
and one in Riel. Yet in the end you estimate your business in US$.

So your income and expense accounts should only exist in US$, while in your
assets you will can two cash accounts: one in US$ and one in Riel.

When a customer pays you in Riel, you make a transaction from your Riel cash
box account to your single income account (which is in US$) and apply the
exchange rate from Riel to US$ to that transaction. By default gnucash will
ask you for this exchange rate. If a customer pays in US$ you create a
transaction from your US$ cash box account to your income account. As the
currencies match there's no conversion rate to apply.

The same goes if you pay for expenses or goods to a supplier. If you pay in
Riel you create a transaction from the Riel cash box account to the
appropriate expense account (which is always in US$). If you pay in US$ the
money goes out of your US$ cash box account into the (same) US$ expense
account.

That will give you all the information you request:
Do you want to know what's in your cash boxes ? Check the appropriate cash box
account or generate a report over it.
Do you want to know how you did as a business ? Generate a report over your
income/expense accounts which are in US$.

Unless you have other requirements you didn't mention I don't think you need
the parent/multi-currency-subaccount structure in your income and expense
accounts as you have currently set up. And it will probably simplify your
accounting if you could do without.

Regards,

Geert

Op zaterdag 30 juni 2018 11:58:51 CEST schreef Norbert Klein:

Thanks, Geert,

I will respond between the lines.

On 29.6.2018 17:58, Geert Janssens wrote:

Hi Norbert,

I don't know the accounting customs of your country,

There are no general accounting customs set - everybody does what seems
to cover the needs of he place.


so first a question:
Is it common in Cambodia to *account* in two currencies as well or only to
*pay* in two currencies ?

In daily life, we may *pay* in either of the two currencies - it is only
customary to make payments in Riel for small and in US$ for larger
amounts. But again, there is no general definition what is "larger" - it
is easier to handle bigger "values" in US$, where 1 US$ corresponds to
roughly 4000 Riels.

We may ask in our shop - as an example - for a price of US$ 4.00, but
the person may hand over 16,000 Riel. Or the other way round. I do not
know if there are many countries with such a situation. But here it is
totally flexible - every person, for every purchase, may choose one way,
and the next minute for another purchase the other way.

So the answer is: BOTH - we pay in two currencies, but we also have to
account in two currencies.

So in the shop we have a Riel cash box, and a US$ cash box, and while we
enter for each purchase an amount - and I have to enter the amount
either into the "Cash in wallet $" or into the "Cash in wallet Riel" -
because we have all the time changes in both cash boxes. And for the
same purchase I enter the amount either into the sub-account "Vegetables
$" or "Vegetables R" - both under ONE Placeholder account "Vegetables"
(set for US$)


Or put differently - do you want to track your income in the two
currencies or just in one (hence the placeholder account) ?

For the actual conducting of purchases, I am tracking the US$ purchases
and the Riel purchases separately - but I put both under ONE placeholder
because I am not only interested in individual purchases, but also in
the overall income (or loss) situation. I had assumed to have a common
placeholder would serve this purpose. Maybe this was wrong.


But you do want to be able to
accept/make payments in the two currencies ?

Yes - it depends on the buyer - depending 

[GNC] Wanted - translators

[Geert Janssens]

Hi all,

A few months back we reached a major milestone for the gnucash project. We 
released gnucash 3.0 which marked the first release in a new stable series.

It came with plenty of new features such as a much improved transaction report 
and several other new reports, a better csv importer, fine-grained control 
over import maps, integrated support for Alpha Vantage quotes retrieval, 
support for higher precision numbers, a renewed GUI, and so on.

Unfortunately the first few releases had some rough edges preventing many 
users from switching easily. With the release of gnucash 3.2 a few weeks back 
I dare say many of these wrinkles have been ironed out (admittedly not all of 
them).

All these improvements also come with new text messages and other strings, 
many of which currently only exist in English. This is fine for people that 
fluently speak English but it also excludes many people from fully benefiting 
from our fine application. Having these messages translated in the native 
languages of our users would greatly improve the user experience of many 
people.

So with this I'm sending out another request for volunteers to help in this 
area. A few languages are in pretty good shape, but others start to run 
behind.

If you think you can lend us a hand here, please contact us via the mailing 
lists or irc and we'll work out together what needs to be done and what you 
can do.

I expect to be flooded with replies, ok ? ;-)

Thanks in advance in name of the whole gnucash community,

Geert Janssens
GnuCash Developer


___
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] Windows strawberry perl and online prices

[David Carlson]

There has been some discussion in this list recently suggesting that
especially when changing between releases from the 2..6 series and 3.0, 3.1
or 3.2, one should uninstall the previous version manually.  In Windows,
the Control Panel uninstall feature should work.  If you did not do that
you may need to manually delete some files before installing a new
version.  I am not sure where to look for detailed instructions.

I think 3.2 or 2.6.21 are the preferred releases, depending on which works
better for you.

David C

On Sat, Jun 30, 2018 at 10:40 AM, Tim Kallmer  wrote:

> Has anyone using gnucash on windows had online prices stop working? For me
> the strawberry perl window opens and never finishes after hours of waiting.
> I eventually have to close the window and give up. I've tried
> un/reinstalling gnucash and perl. I've tried 3.1 and 3.2 and 2.6. I've
> double-checked my alphavantage key is correct. Any suggestions?
> ___
> 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] Change Reconcile Starting Balance

[John Ralls]

Are there really no other transactions in the account besides the opening 
balance?

Regards,
John Ralls


> On Jun 30, 2018, at 7:00 AM, Roger Miskowicz  wrote:
> 
> At the beginning of the account I did:
> 
> 2017-12-31  Opening Balance:  1,691.19
> 
> Then with no other transactions I Reconciled with end date 2018-01-01 which
> yielded the following result:
> 
> Statement Date: 2018-01-01
>Starting Balance:1,798.89
>  Ending Balance:   1,691.19
> Reconciled Balance:   1,798.89
>  Difference: -107.70
> 
> With only one entry shouldn't all the balances be identical?
> 
> Anyway, in this case I would like to be able to set the starting balance to
> 1,691.19 then I believe the reconcile might work as I expect?
> 
> Am I misunderstanding something?
> 
> On Sat, Jun 30, 2018 at 8:55 AM, D  wrote:
> 
>> Only manually, a transaction at a time.
>> 
>> What happens if you ignore the opening balance, enter the correct closing
>> balance, and reconcile then?
>> 
>> Often, if there's an inconsistency in the opening balance, you can proceed
>> with reconciling, mark your current transactions and any earlier ones that
>> were missed before (such as your opening balance transaction, say), and
>> they balance out.
>> 
>> David
>> 
>> On June 30, 2018, at 8:23 AM, Roger Miskowicz  wrote:
>> 
>> Thanks Colin.
>> 
>> Is there anyway I can clear all reconcilation of the the account and start
>> again from scratch?
>> 
>> Roger
>> 
>> On Sat, Jun 30, 2018 at 8:15 AM, Colin Law  wrote:
>> 
>>> The starting balance in the reconcile start dialog will be the nett
>>> balance of all reconciled transactions so far. Is this the first time
>>> you have reconciled it?  If not then it should be the same as the
>>> ending balance the last time you reconciled, unless you have editted a
>>> reconciled transaction.
>>> 
>>> Colin
>>> 
>>> On 30 June 2018 at 13:08, Roger Miskowicz  wrote:
 I am using GC Version 3.2 and trying to reconcile my Credit Card
>> Account
 which I started at the beginning of the year with an opening balance.
 
 I would like to reconcile the account from the opening balance but I
>>> don't
 know how to set the 'starting balance' which happens to be some number
>>> that
 doesn't seem relevant.
 
 Can the 'starting balance' in 'reconcile' be manuallly set, and if so,
>>> how?
 ___
 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.
>> 
> ___
> 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] Change Reconcile Starting Balance

[John Ralls]

I mean in the register that you’re trying to reconcile. How many transactions 
are in the register?
If it is more than one, are any of them reconciled?

Regards,
John Ralls

> On Jun 30, 2018, at 7:56 AM, Roger Miskowicz  wrote:
> 
> Not sure what you mean but here is the dialog box.
> 
> 
> 
> 
> Because there is a difference I have to cancel and start again.
> 
> Is there any that I can force all transactions in the account to be
> unreconciled?
> 
> On Sat, Jun 30, 2018 at 10:08 AM, Colin Law  > wrote:
> 
>> What did you see at the start of the reconcile?  You can cancel the
>> reconcile and start again.
>> 
>> Colin
>> 
>> On 30 June 2018 at 15:00, Roger Miskowicz  wrote:
>>> At the beginning of the account I did:
>>> 
>>> 2017-12-31  Opening Balance:  1,691.19
>>> 
>>> Then with no other transactions I Reconciled with end date 2018-01-01
>> which
>>> yielded the following result:
>>> 
>>> Statement Date: 2018-01-01
>>>Starting Balance:1,798.89
>>>  Ending Balance:   1,691.19
>>> Reconciled Balance:   1,798.89
>>>  Difference: -107.70
>>> 
>>> With only one entry shouldn't all the balances be identical?
>>> 
>>> Anyway, in this case I would like to be able to set the starting balance
>> to
>>> 1,691.19 then I believe the reconcile might work as I expect?
>>> 
>>> Am I misunderstanding something?
>>> 
>>> On Sat, Jun 30, 2018 at 8:55 AM, D  wrote:
>>> 
 Only manually, a transaction at a time.
 
 What happens if you ignore the opening balance, enter the correct
>> closing
 balance, and reconcile then?
 
 Often, if there's an inconsistency in the opening balance, you can
>> proceed
 with reconciling, mark your current transactions and any earlier ones
>> that
 were missed before (such as your opening balance transaction, say), and
 they balance out.
 
 David
 
 On June 30, 2018, at 8:23 AM, Roger Miskowicz 
>> wrote:
 
 Thanks Colin.
 
 Is there anyway I can clear all reconcilation of the the account and
>> start
 again from scratch?
 
 Roger
 
 On Sat, Jun 30, 2018 at 8:15 AM, Colin Law  wrote:
 
> The starting balance in the reconcile start dialog will be the nett
> balance of all reconciled transactions so far. Is this the first time
> you have reconciled it?  If not then it should be the same as the
> ending balance the last time you reconciled, unless you have editted a
> reconciled transaction.
> 
> Colin
> 
> On 30 June 2018 at 13:08, Roger Miskowicz  wrote:
>> I am using GC Version 3.2 and trying to reconcile my Credit Card
 Account
>> which I started at the beginning of the year with an opening
>> balance.
>> 
>> I would like to reconcile the account from the opening balance but I
> don't
>> know how to set the 'starting balance' which happens to be some
>> number
> that
>> doesn't seem relevant.
>> 
>> Can the 'starting balance' in 'reconcile' be manuallly set, and if
>> so,
> how?
>> ___
>> 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.
 
>>> ___
>>> 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 

[GNC] Windows strawberry perl and online prices

[Tim Kallmer]

Has anyone using gnucash on windows had online prices stop working? For me
the strawberry perl window opens and never finishes after hours of waiting.
I eventually have to close the window and give up. I've tried
un/reinstalling gnucash and perl. I've tried 3.1 and 3.2 and 2.6. I've
double-checked my alphavantage key is correct. Any suggestions?
___
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] GnuCash 3.2 Released

[Stephen M. Butler]

On 06/29/2018 12:43 AM, DaveC49 wrote:
> Stephen,
>
> It is generally a good idea to remove the previous version before installing
> a new one. Gnucash will generally overwrite any existing files of the same
> name, but you may be left with unnecessary files in some cases. Going from
> 3.1 to 3.2 should be OK as there are unlikey to be major changes in the file
> structure, but between major version could be problematical There are
> instructions on the Wiki in the build instructions for Ubuntu 16.04 for
> doing uninstalls in a variety of circumstances including manually deleting
> all the files which will be the same for 18.04. I'll put a note in there re
> uninstalling previous versionsbefore the build instructions to make it
> clearer.
>
> If you still have the 3.1 build directory:
>  open a shell and cd to the build directory then type 
>  sudo make uninstall

Sadly, I aggressively removed it when bringing in 3.2  :-(
So a learning experience that, hopefully, I can help others avoid.
>
> then do the install of V3.2
>
> This uses a manifest created when Gnucash was installed to uninstall all of
> the program files. It leaves user preference files untouched.
>
> David
>
>
>
> -
> 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.
>

___
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] Fwd: The two modules

[Stephen M. Butler]

On 06/28/2018 10:02 PM, DaveC49 wrote:
> Hi Stephen,
>
> I agree with your wife about not including the Income Statement inside a
> Balance Sheet. These serve different functions and it just makes a Balance
> Sheet more complicated than necessary. From an accounting perspective you
> should be able to evaluate a balance sheet fairly quickly and having a
> fairly uniform layout means comparison of balance sheets for different
> entities is much easier, which is the rational for trying to get the IFRS
> standards adopted world wide. My personal preference is for simple reports
> which meet one specific objective well and clearly.
>
> As I explained in a post to John, I don't necessarily require GnuCash to
> impose parent placholder accounts not to have transactions into them
> specifically, but it would be a nice feature to have an option to make
> adherence strict if the user requires it. It may however require
> considerable code mods to achieve that and I can achieve that by just
> removing any transactions which target an account i make a placeholder to a
> sub-account or another account. More difficult of course if you have a large
> number of such transactions. A lot of people use GnuCash for a lot of
> functions other than formal accounting so as David T pointed out some people
> use the placholder readonly functionality to meet other requirements. I
> can't think of a specific case but I am all for retaining as much
> flexibility in GnuCash as possible.  It may be just better documentation fof
> the Placholder setting may achieve that.
>
> Cheers
>
> David
>

It would be nice if there was a system wide preference flag (like the
current Trading Accounts setting) that a user could turn on that would
enforce that behavior. 

But, as you said, an individual can do the work to enforce it them-self.

Another question, do you set only the five top level accounts (Asset,
Expense, Equity (or Capital), Income and Expense) or do you have
multiple top level accounts in each of the designated types?

That is, do you do:
Assets  (asset type)
    Bank (bank type)
  Checking (bank)
  Savings (bank)
  etc
    Cash (cash)
    Home (asset)

Or,

Bank (asset)
   Checking (bank)
   Savings (bank)
   etc
Cash (asset)
Home (asset)

The first gives one top level Asset account, the second gives three top
level Asset accounts.

--Steve
___
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] Change Reconcile Starting Balance

[Roger Miskowicz]

Not sure what you mean but here is the dialog box.




Because there is a difference I have to cancel and start again.

Is there any that I can force all transactions in the account to be
unreconciled?

On Sat, Jun 30, 2018 at 10:08 AM, Colin Law  wrote:

> What did you see at the start of the reconcile?  You can cancel the
> reconcile and start again.
>
> Colin
>
> On 30 June 2018 at 15:00, Roger Miskowicz  wrote:
> > At the beginning of the account I did:
> >
> > 2017-12-31  Opening Balance:  1,691.19
> >
> > Then with no other transactions I Reconciled with end date 2018-01-01
> which
> > yielded the following result:
> >
> >  Statement Date: 2018-01-01
> > Starting Balance:1,798.89
> >   Ending Balance:   1,691.19
> > Reconciled Balance:   1,798.89
> >   Difference: -107.70
> >
> > With only one entry shouldn't all the balances be identical?
> >
> > Anyway, in this case I would like to be able to set the starting balance
> to
> > 1,691.19 then I believe the reconcile might work as I expect?
> >
> > Am I misunderstanding something?
> >
> > On Sat, Jun 30, 2018 at 8:55 AM, D  wrote:
> >
> >> Only manually, a transaction at a time.
> >>
> >> What happens if you ignore the opening balance, enter the correct
> closing
> >> balance, and reconcile then?
> >>
> >> Often, if there's an inconsistency in the opening balance, you can
> proceed
> >> with reconciling, mark your current transactions and any earlier ones
> that
> >> were missed before (such as your opening balance transaction, say), and
> >> they balance out.
> >>
> >> David
> >>
> >> On June 30, 2018, at 8:23 AM, Roger Miskowicz 
> wrote:
> >>
> >> Thanks Colin.
> >>
> >> Is there anyway I can clear all reconcilation of the the account and
> start
> >> again from scratch?
> >>
> >> Roger
> >>
> >> On Sat, Jun 30, 2018 at 8:15 AM, Colin Law  wrote:
> >>
> >> > The starting balance in the reconcile start dialog will be the nett
> >> > balance of all reconciled transactions so far. Is this the first time
> >> > you have reconciled it?  If not then it should be the same as the
> >> > ending balance the last time you reconciled, unless you have editted a
> >> > reconciled transaction.
> >> >
> >> > Colin
> >> >
> >> > On 30 June 2018 at 13:08, Roger Miskowicz  wrote:
> >> > > I am using GC Version 3.2 and trying to reconcile my Credit Card
> >> Account
> >> > > which I started at the beginning of the year with an opening
> balance.
> >> > >
> >> > > I would like to reconcile the account from the opening balance but I
> >> > don't
> >> > > know how to set the 'starting balance' which happens to be some
> number
> >> > that
> >> > > doesn't seem relevant.
> >> > >
> >> > > Can the 'starting balance' in 'reconcile' be manuallly set, and if
> so,
> >> > how?
> >> > > ___
> >> > > 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.
> >>
> > ___
> > 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] New Balsheet (and P report)

[Christopher Lam]

Hi Dave

On 28/06/18 17:24, DaveC49 wrote:

Christopher,

" except that Placeholder accounts
can also contain transactions therefore must not necessarily accumulate
their children account amounts. "

I have to disagree with the above from an accounting perspective.


I was not describing UI restrictions; I was describing Report format. 
How to report 'accounts' with children, but with their own amounts?


---Answer 1---

I had a multilevel strategy which (to me) was more clever, but it would 
seem is not desired.
1. If account has children, just render its own amount (e.g. 
Expenses:Utilities:Home = $10)
2. Move on to its child accounts (e.g. Expenses:Utilities:Home:Electric 
= $35, Expenses:Utilities:Beachhouse:Electric = $40)
3. If we are moving to a *higher* level account, then start rendering 
all intermediate sublevels will be subtotals, e.g.


  Expenses = $0
  Expenses:Utilities = $0
  Expenses:Utilities:Home = $10 <- note this is a parent 
account with own $10 amount, gets its own row

  Expenses:Utilities:Home:Water = $40
  Expenses:Utilities:Home:Electric = $35
  TOTAL Expenses:Utilities:Home = $85

  Expenses:Utilities:Beachhouse
  Expenses:Utilities:Beachhouse:Electric = $40
  Expenses:Utilities:Beachhouse:Water = $20
  TOTAL Expenses:Utilities:Beachhouse = $60

  TOTAL Expenses:Utilities = $145

However this approach seems to be adding too much complexity so I've 
removed it.


---Answer 2---

In my current draft balsheet-pnl I am specifically *not* querying the 
account's placeholder flag. As we know it is being used both as a 
'grouping' account (e.g. Asset:Fixed) and as a 'disabled' account flag 
(e.g. Asset:Closed:MyOldBank:Current).


So the above P will be rendered as follows:

  Total Expenses:Utilities = $145

  Total Expenses:Utilities:Home = $85
  Expenses:Utilities:Home = $10    <-- 'parent' account with 
own $10 amount

  Expenses:Utilities:Home:Water = $40
  Expenses:Utilities:Home:Electric = $35

  Total Expenses:Utilities:Beachhouse = $60    <- parent 
account without amount... it doesn't get its own row

  Expenses:Utilities:Beachhouse:Electric = $40
  Expenses:Utilities:Beachhouse:Water = $20

This is the 'recursive-balance' strategy. In this one, the Totals will 
always be presented in the parent account.


---

Both methods are suitable for the current placeholder strategy.



If accounts are setup as Placeholders initially (i.e. the checkbox set in
New Account dialog when they are created) they are readonly hence you cannot
select them as targets for transactions (Placeholders do not appear in the
list of target accounts for a transaction and if you open the account
register you are warned that it is read only and you cannot enter
transactions from it so they cannot accumulate any balance when they are
initially set as Placeholder accounts.

If you change an existing account to be a Placeholder and it already has
transactions into it then its balance will contain the sum of those
transactions. If you then createa sub account of it and create transactions
into the sub-account, then the balance of the parent placeholder account
balance is correctly the sum of the balances of any sub accounts plus the
sum of any transactions into it before it was changed to a placeholder.

If it was initially a placeholder, a user could subsequently change it to be
a non-placeholder account  allowing it to accumulate transactions into it
and subsequently change it back.

In either of these two cases, the correct balance for the placeholder
account is always the balance of any transactions into the placeholder
account itself plus the sum of balances of it's sub-accounts. In most
accounting practice the balances of the subaccounts would be indented to the
right.

To maintain consistency with this practice, if it is possible you could
present the balance of any direct transactions to the placeholder account
indented in the same manner as the sub-accounts as if it was a sub-account
and then have the non-indented balance for the placeholder account being the
sum of that plus the balances of any subaccounts.

Where you are trying to create a multicolumn/multiperiod type report, which
I have gathered is your objective, having to have indented sub-accounts will
make it very complex and difficult to fit on a fixed page size if you have
to preserve indenting of the sub-account structure.

I would like to plead that the current Balance and Income Statements and
other standard accounting reports not be replaced by a multiperiod report,
but that this become an additional optional report.


The multicolumns are only enabled if the period option allows it. It can 
easily be disabled, or made off by default.


The current balance sheet has the amounts indented in a completely 
unpredictable method. I cannot fix it, sorry...


Please beta test the report as it stands, or comment on the screenshots, 
especially https://screenshots.firefox.com/3AGgKiSkmdebjOsf/null ... 
your input is 

[GNC] Change Reconcile Starting Balance

[Roger Miskowicz]

I am using GC Version 3.2 and trying to reconcile my Credit Card Account
which I started at the beginning of the year with an opening balance.

I would like to reconcile the account from the opening balance but I don't
know how to set the 'starting balance' which happens to be some number that
doesn't seem relevant.

Can the 'starting balance' in 'reconcile' be manuallly set, and if so, how?
___
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] Change Reconcile Starting Balance

[Roger Miskowicz]

Thanks Colin.

Is there anyway I can clear all reconcilation of the the account and start
again from scratch?

Roger

On Sat, Jun 30, 2018 at 8:15 AM, Colin Law  wrote:

> The starting balance in the reconcile start dialog will be the nett
> balance of all reconciled transactions so far. Is this the first time
> you have reconciled it?  If not then it should be the same as the
> ending balance the last time you reconciled, unless you have editted a
> reconciled transaction.
>
> Colin
>
> On 30 June 2018 at 13:08, Roger Miskowicz  wrote:
> > I am using GC Version 3.2 and trying to reconcile my Credit Card Account
> > which I started at the beginning of the year with an opening balance.
> >
> > I would like to reconcile the account from the opening balance but I
> don't
> > know how to set the 'starting balance' which happens to be some number
> that
> > doesn't seem relevant.
> >
> > Can the 'starting balance' in 'reconcile' be manuallly set, and if so,
> how?
> > ___
> > 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] Fwd: The two modules

[DaveC49]

John,

I agree with you that making the accounts with child accounts have no
transactions is being unnecessarily restrictive and may not meet all
possible use cases but perhaps having the option of being able to restrict
it to that case if it suits an individual's purpose is a suitable
compromise. The other thing may be to issue a warning when you have made an
account with transactions a Placeholder account and that you may want to
transfer those transactions to a subaccount or another account entirely. At
the moment, I think it simply flags that you have made the account
read-only.  

I don't find the name Placeholder accounts too undescriptive of the function
of providing a higher level grouping of accounts with some commanality of
purpose/function. Adding an additional option to be able to in addition make
placeholder accounts strictly Placeholder (i.e. unable to accept
transactions into them) would be one way to go which would retain that
flexibility for those who have a need for Placholder accounts to be a target
for transactions. 

I personally can live with it as it is now and impose my own rules on my
usage for placeholders not to have transactions into them and just take
appropriate action to transfer existing transactions if you change an
account to a placeholder account. 

Perhaps all that is necessary is really to highlight the implications of
making an account a placeholder in the documentation/guide, perhaps in the
section of setting up the CoA. i haven't read that for several yers now so i
might check it out.

In either case, any reports have to be able to cope with the cases where a
placeholder account does have transactions directly into it or does no,t in
an appropriate manner.  My personal preference would be for 

If a parent has transactions put it twice: 
Once as aggregate account and once as an account on it's own. That would
meet 
both needs. The aggregate will total it's own transactions with those of its 
child accounts. Or put differently the aggregate account would treat itself
as 
a child account.

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] Fwd: The two modules

[DaveC49]

Hi Stephen,

I agree with your wife about not including the Income Statement inside a
Balance Sheet. These serve different functions and it just makes a Balance
Sheet more complicated than necessary. From an accounting perspective you
should be able to evaluate a balance sheet fairly quickly and having a
fairly uniform layout means comparison of balance sheets for different
entities is much easier, which is the rational for trying to get the IFRS
standards adopted world wide. My personal preference is for simple reports
which meet one specific objective well and clearly.

As I explained in a post to John, I don't necessarily require GnuCash to
impose parent placholder accounts not to have transactions into them
specifically, but it would be a nice feature to have an option to make
adherence strict if the user requires it. It may however require
considerable code mods to achieve that and I can achieve that by just
removing any transactions which target an account i make a placeholder to a
sub-account or another account. More difficult of course if you have a large
number of such transactions. A lot of people use GnuCash for a lot of
functions other than formal accounting so as David T pointed out some people
may find being able to make transactions to a parent account useful and also
use the placholder readonly functionality to meet other requirements. I
can't think of a specific case but I am all for retaining as much
flexibility in GnuCash as possible.  It may be just better documentation fof
the Placholder setting may achieve that.

Cheers

David



-
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] Change Reconcile Starting Balance

[Roger Miskowicz]

At the beginning of the account I did:

2017-12-31  Opening Balance:  1,691.19

Then with no other transactions I Reconciled with end date 2018-01-01 which
yielded the following result:

 Statement Date: 2018-01-01
Starting Balance:1,798.89
  Ending Balance:   1,691.19
Reconciled Balance:   1,798.89
  Difference: -107.70

With only one entry shouldn't all the balances be identical?

Anyway, in this case I would like to be able to set the starting balance to
1,691.19 then I believe the reconcile might work as I expect?

Am I misunderstanding something?

On Sat, Jun 30, 2018 at 8:55 AM, D  wrote:

> Only manually, a transaction at a time.
>
> What happens if you ignore the opening balance, enter the correct closing
> balance, and reconcile then?
>
> Often, if there's an inconsistency in the opening balance, you can proceed
> with reconciling, mark your current transactions and any earlier ones that
> were missed before (such as your opening balance transaction, say), and
> they balance out.
>
> David
>
> On June 30, 2018, at 8:23 AM, Roger Miskowicz  wrote:
>
> Thanks Colin.
>
> Is there anyway I can clear all reconcilation of the the account and start
> again from scratch?
>
> Roger
>
> On Sat, Jun 30, 2018 at 8:15 AM, Colin Law  wrote:
>
> > The starting balance in the reconcile start dialog will be the nett
> > balance of all reconciled transactions so far. Is this the first time
> > you have reconciled it?  If not then it should be the same as the
> > ending balance the last time you reconciled, unless you have editted a
> > reconciled transaction.
> >
> > Colin
> >
> > On 30 June 2018 at 13:08, Roger Miskowicz  wrote:
> > > I am using GC Version 3.2 and trying to reconcile my Credit Card
> Account
> > > which I started at the beginning of the year with an opening balance.
> > >
> > > I would like to reconcile the account from the opening balance but I
> > don't
> > > know how to set the 'starting balance' which happens to be some number
> > that
> > > doesn't seem relevant.
> > >
> > > Can the 'starting balance' in 'reconcile' be manuallly set, and if so,
> > how?
> > > ___
> > > 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.
>
___
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] Change Reconcile Starting Balance

[Colin Law]

What did you see at the start of the reconcile?  You can cancel the
reconcile and start again.

Colin

On 30 June 2018 at 15:00, Roger Miskowicz  wrote:
> At the beginning of the account I did:
>
> 2017-12-31  Opening Balance:  1,691.19
>
> Then with no other transactions I Reconciled with end date 2018-01-01 which
> yielded the following result:
>
>  Statement Date: 2018-01-01
> Starting Balance:1,798.89
>   Ending Balance:   1,691.19
> Reconciled Balance:   1,798.89
>   Difference: -107.70
>
> With only one entry shouldn't all the balances be identical?
>
> Anyway, in this case I would like to be able to set the starting balance to
> 1,691.19 then I believe the reconcile might work as I expect?
>
> Am I misunderstanding something?
>
> On Sat, Jun 30, 2018 at 8:55 AM, D  wrote:
>
>> Only manually, a transaction at a time.
>>
>> What happens if you ignore the opening balance, enter the correct closing
>> balance, and reconcile then?
>>
>> Often, if there's an inconsistency in the opening balance, you can proceed
>> with reconciling, mark your current transactions and any earlier ones that
>> were missed before (such as your opening balance transaction, say), and
>> they balance out.
>>
>> David
>>
>> On June 30, 2018, at 8:23 AM, Roger Miskowicz  wrote:
>>
>> Thanks Colin.
>>
>> Is there anyway I can clear all reconcilation of the the account and start
>> again from scratch?
>>
>> Roger
>>
>> On Sat, Jun 30, 2018 at 8:15 AM, Colin Law  wrote:
>>
>> > The starting balance in the reconcile start dialog will be the nett
>> > balance of all reconciled transactions so far. Is this the first time
>> > you have reconciled it?  If not then it should be the same as the
>> > ending balance the last time you reconciled, unless you have editted a
>> > reconciled transaction.
>> >
>> > Colin
>> >
>> > On 30 June 2018 at 13:08, Roger Miskowicz  wrote:
>> > > I am using GC Version 3.2 and trying to reconcile my Credit Card
>> Account
>> > > which I started at the beginning of the year with an opening balance.
>> > >
>> > > I would like to reconcile the account from the opening balance but I
>> > don't
>> > > know how to set the 'starting balance' which happens to be some number
>> > that
>> > > doesn't seem relevant.
>> > >
>> > > Can the 'starting balance' in 'reconcile' be manuallly set, and if so,
>> > how?
>> > > ___
>> > > 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.
>>
> ___
> 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] New Balsheet (and P report)

[DaveC49]

Christopher,

" except that Placeholder accounts 
can also contain transactions therefore must not necessarily accumulate 
their children account amounts. "

I have to disagree with the above from an accounting perspective.

If accounts are setup as Placeholders initially (i.e. the checkbox set in
New Account dialog when they are created) they are readonly hence you cannot
select them as targets for transactions (Placeholders do not appear in the
list of target accounts for a transaction and if you open the account
register you are warned that it is read only and you cannot enter
transactions from it so they cannot accumulate any balance when they are
initially set as Placeholder accounts.

If you change an existing account to be a Placeholder and it already has
transactions into it then its balance will contain the sum of those
transactions. If you then createa sub account of it and create transactions
into the sub-account, then the balance of the parent placeholder account
balance is correctly the sum of the balances of any sub accounts plus the
sum of any transactions into it before it was changed to a placeholder.

If it was initially a placeholder, a user could subsequently change it to be
a non-placeholder account  allowing it to accumulate transactions into it
and subsequently change it back.

In either of these two cases, the correct balance for the placeholder
account is always the balance of any transactions into the placeholder
account itself plus the sum of balances of it's sub-accounts. In most
accounting practice the balances of the subaccounts would be indented to the
right. 

To maintain consistency with this practice, if it is possible you could
present the balance of any direct transactions to the placeholder account
indented in the same manner as the sub-accounts as if it was a sub-account
and then have the non-indented balance for the placeholder account being the
sum of that plus the balances of any subaccounts.

Where you are trying to create a multicolumn/multiperiod type report, which
I have gathered is your objective, having to have indented sub-accounts will
make it very complex and difficult to fit on a fixed page size if you have
to preserve indenting of the sub-account structure. 

I would like to plead that the current Balance and Income Statements and
other standard accounting reports not be replaced by a multiperiod report,
but that this become an additional optional report.

Gnucash is used in many different jurisdictions not all of which have as yet
adopted the IFRS produced by the IASB. (The US while moving towards the IFRS
uses a GAAP which is not yet compliant). Even if this were the case, many
jurisdictions still have local divergences from strict IFRS adherence
because of the need to be consistent with other laws in their jurisdiction.
Having fairly plain vanilla single period reports which users can then
produce customised versions  for their specific requirements is fairly
essential to meet the need to operate across many jurisdictions, which is
one of GnuCash's strengths. That may be more difficult to do with a
multiperiod report.

A cautious user would hopefully not create the situation where placeholder
accounts have transactions into them, but Murphy's law applies and if it can
happen it no doubt will and does. 

The case where after a given date company or reporting policy requires a
more detailed breakdown with sub-accounts but prior to that date there was
only a single account is one situation where transactions to a parent
account might occur. I personally would treat that by creating a sub-account
for all transactions into the original account prior to that date to which
all existing transactions could be transferred along with the sub-accounts
for the future reporting structure for future transactions. At some point in
the future that sub-account with the original parent account transactions
could possibly be hidden, but the data is still preserved.

It would be ideal perhaps if Gnucash on creation of a subaccount required
the parent account to be made a placeholder and any existing transactions
transferred to either that subaccount (or another appropriate account) but
that is not built in currently. There may be other use cases where this is
not desirable however.

regards

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] Dark theme on Windows

[DaveC49]

Geert,

I tried this on Linux Mint 18.3  but had no changes from the default theme. 

David



-
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] How to regularly use two currencies

[Norbert Klein]

Thanks, Geert,

I will respond between the lines.

On 29.6.2018 17:58, Geert Janssens wrote:

Hi Norbert,

I don't know the accounting customs of your country,
There are no general accounting customs set - everybody does what seems 
to cover the needs of he place.

so first a question:
Is it common in Cambodia to *account* in two currencies as well or only to
*pay* in two currencies ?
In daily life, we may *pay* in either of the two currencies - it is only 
customary to make payments in Riel for small and in US$ for larger 
amounts. But again, there is no general definition what is "larger" - it 
is easier to handle bigger "values" in US$, where 1 US$ corresponds to 
roughly 4000 Riels.


We may ask in our shop - as an example - for a price of US$ 4.00, but 
the person may hand over 16,000 Riel. Or the other way round. I do not 
know if there are many countries with such a situation. But here it is 
totally flexible - every person, for every purchase, may choose one way, 
and the next minute for another purchase the other way.


So the answer is: BOTH - we pay in two currencies, but we also have to 
account in two currencies.


So in the shop we have a Riel cash box, and a US$ cash box, and while we 
enter for each purchase an amount - and I have to enter the amount 
either into the "Cash in wallet $" or into the "Cash in wallet Riel" - 
because we have all the time changes in both cash boxes. And for the 
same purchase I enter the amount either into the sub-account "Vegetables 
$" or "Vegetables R" - both under ONE Placeholder account "Vegetables" 
(set for US$)

Or put differently - do you want to track your income in the two currencies or
just in one (hence the placeholder account) ?
For the actual conducting of purchases, I am tracking the US$ purchases 
and the Riel purchases separately - but I put both under ONE placeholder 
because I am not only interested in individual purchases, but also in 
the overall income (or loss) situation. I had assumed to have a common 
placeholder would serve this purpose. Maybe this was wrong.

But you do want to be able to
accept/make payments in the two currencies ?
Yes - it depends on the buyer - depending of which of the two currencies 
he of she has in their purse.

If you only want to accept/make payments in two currencies but just track it
in one, the account structure would be slightly different.
"track it only in one" - for the actual operation of the shop this is 
not possible. I have to know - at the end of the  day - how many US$, 
and how many Riel, should be in the cash boxes.

If you want to track your income in multiple currencies as you have set up,
you'll need to make sure you have entries in your price database for
conversion rates between USD and Cambodia Riel.
In my former mail, I had said: "(In Tools, Price Editor, I have set 
Khmer Riels as the second currency in addition to US$.)" - saying that 1 
US$ corresponds to 4000 Riel, with hardly any fluctuation. Any more to do?


But while I have to keep track of the actual cash in the cash boxes, at 
certain times (daily, weekly, monthly etc.) I also need to know "how we 
did as a business" and this should say something in US$ (for all the 
activities which did happen in both currencies).

Or more generally between your
book's currency and the foreign currencies you trade in.
Well, I do not feel that "we trade in a foreign currency" - both 
currencies co-exist here in everybody's wallet. Te bill from the 
electricity company comes in Riel, the bill from the ISP comes in US$ - etc.


So what else can you please suggest to me to do?

Really many thanks,

Norbert

Regards,

Geert




Op vrijdag 29 juni 2018 12:28:00 CEST schreef Norbert Klein:

How to regularly use two currencies

I would very much appreciate if somebody could help me to solve a problem.

In GnuCash 2.6.19,on a Windows 10 computer, I made the following
arrangements – but maybe my assumptions were wrong, as I cannot see the
results I had hope for. I do not have much experience, so I dare to ask
for advice and help.

I live in Cambodia, where it is usual all over the country to use two
currencies regularly: the Cambodian Riel, and the US$ (at normally 4000
Riel per Dollar).

(In Tools, Price Editor, I have set Khmer Riels as the second currency
in addition to US$.)

I live on a farm, where, among other things, we produce, sell, and buy
vegetables.

Under Income, I created an account FARM, and under FARM an account SHOP,
and under shop a Placeholder account VEGETABLES (currency USD). Under
VEGETABLES I created a VEG$ sub-account for business in US dollars, and
another sub-account VEGR for business in Riels.

Now I enter all business actions into VEG$ or VEGR, either as Income or
Charge, according to the currency used.

After some entries, I can see the calculated result (gain or loss) in
US$ in the Placeholder account VEGETABLES.

I had hoped that the entries in VEGR would be transferred into US$ and
also be part of the reported results in 

Re: [GNC] Change Reconcile Starting Balance

[D via gnucash-user]

Only manually, a transaction at a time.

What happens if you ignore the opening balance, enter the correct closing 
balance, and reconcile then?

Often, if there's an inconsistency in the opening balance, you can proceed with 
reconciling, mark your current transactions and any earlier ones that were 
missed before (such as your opening balance transaction, say), and they balance 
out.

David

On June 30, 2018, at 8:23 AM, Roger Miskowicz  wrote:

Thanks Colin.

Is there anyway I can clear all reconcilation of the the account and start
again from scratch?

Roger

On Sat, Jun 30, 2018 at 8:15 AM, Colin Law  wrote:

> The starting balance in the reconcile start dialog will be the nett
> balance of all reconciled transactions so far. Is this the first time
> you have reconciled it?  If not then it should be the same as the
> ending balance the last time you reconciled, unless you have editted a
> reconciled transaction.
>
> Colin
>
> On 30 June 2018 at 13:08, Roger Miskowicz  wrote:
> > I am using GC Version 3.2 and trying to reconcile my Credit Card Account
> > which I started at the beginning of the year with an opening balance.
> >
> > I would like to reconcile the account from the opening balance but I
> don't
> > know how to set the 'starting balance' which happens to be some number
> that
> > doesn't seem relevant.
> >
> > Can the 'starting balance' in 'reconcile' be manuallly set, and if so,
> how?
> > ___
> > 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.
___
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] Upgrading GC under Ubuntu

[Colin Law]

Ubuntu 18.04 is currently ahead of getdeb, at version 2.6.19

Colin

On 29 June 2018 at 21:33, David Carlson  wrote:
> Before 'rolling your own' GnuCash, check out Getdeb.net.  They may not have
> 3 series yet, but they are up to 2.6.17 at least, if not later.
>
> David C
>
> On Fri, Jun 29, 2018 at 2:50 PM, Stephen M. Butler  wrote:
>
>> On 06/29/2018 11:45 AM, John R. Sowden wrote:
>> > It seems that GC is a very popular accounting program, and
>> > Ubuntu/Linux is a very popular Operating System, yet when there is an
>> > upgrade in GC, I cannot find a straightforward method of updating GC
>> > under Ubuntu/Linux.
>> >
>> > I understand that there is a delay before the new version of GC is in
>> > the Ubuntu Software download system.  That is internal to Ubuntu.  But
>> > there are alternatives, such as an alternative repository and self
>> > compiling.  Oh yes, what about pre-compiled binaries like Windows and
>> > Mac?
>> >
>> > Each could have clear concise instructions on how to perform the task.
>> >
>> > One could direct the user with specific commands to go th the
>> > repository that gets the upgrade first.
>> >
>> > A script could be written and published with copious comments, testing
>> > for dependencies, loading them, doing a security check of the
>> > downloaded files, compiling and testing.
>> >
>> > Google has not turned out to be my friend, otherwise I would not be
>> > writing this.  There are articles years old, no install scripts, no
>> > suggestions of repositories with instructions.
>> >
>> > Feel free to prove me wrong, I have spent a couple of hours searching
>> > with many selected key words,
>> >
>> > John
>> >
>> Having just done a download and compile to my Ubuntu 18.04, let me share
>> with you what I did.  Sometimes reading the web sites leaves one (at
>> least me) scratching their head vigorously -- in my case not a good idea
>> with the hair I have left!
>>
>> 1.  Read this page:  https://wiki.gnucash.org/wiki/BuildUbuntu16.04
>>  It works for 18.04 also.
>>
>> You didn't say which version of Ubuntu so I am presuming either
>> 16.04 or 18.04
>> You may need to install a bunch of libraries.  I found that a couple
>> or more were already on my box.
>>
>> My box had some old libraries hanging around that I had to manually
>> remove in /usr/src:
>> sudo rm -rf /usr/src/gtest /usr/src/gmock
>>
>> See this note:
>> https://larry-price.com/blog/2013/10/13/installing-gtest-
>> and-gmock-libs-in-ubuntu-13-dot-04/
>> But don't worry.  Just remove the above two entries (if they exist)
>> and the install of googletest and googlemock will work.
>> I ended up uninstalling the two packages on my way to figuring out
>> what had happened. sudo apt-get install build-essential
>>
>> sudo apt-get install cmake
>> sudo apt-get install libtool libltdl-dev
>> sudo apt-get install libglib2.0 libglib2.0-dev   #glib2 > v2.40.0
>> sudo apt-get install icu-devtools libicu-dev
>> sudo apt-get install libboost-all-dev# boost > 1.50.0 -
>> requires locale and regex built with ICU support
>> sudo apt-get install guile-2.0 guile-2.0-dev # guile >=2.0.0
>> sudo apt-get install swig3.0 # swig >2.0.10 *(swig3.0
>> on Ubuntu18.04)* not required if building from
>> tarball,
>>
>> sudo apt-get install googletest
>> sudo apt-get install googlemock
>> sudo apt-get install libgtest-dev
>> # but from any version
>> control system
>> sudo apt-get install libxml2 libxml++2.6-dev
>> sudo apt-get install libxslt1.1 libxslt1-dev
>> sudo apt-get install xsltproc
>> sudo apt-get install texinfo # required for makeinfo
>>
>>
>> sudo apt-get install gtk+3.0
>> sudo apt-get install libgtk-3-dev
>> sudo apt-get install libwebkit2gtk-4.0-37# > webkit2gtk-3.0
>> sudo apt-get install libwebkit2gtk-4.0-dev
>>
>> sudo apt-get install libdbi1 libdbi-dev # > v0.8.3
>>
>> # one of the following three if you want a database backend option:
>> sudo apt-get install libdbd-pgsql# PostgreSQL database
>> sudo apt-get install libdbd-mysql# MySQL database
>> sudo apt-get install libdbd-sqlite3  # Sqlite database
>>
>> sudo apt-get install libofx-dev
>>
>> sudo apt-get install aqbanking-tools libaqbanking-dev   # > v4.0.0
>> sudo apt-get install gwenhywfar-tools libgwenhywfar60 libgwenhywfar60-dev
>> sudo apt-get install ktoblzcheck libktoblzcheck1-dev
>>
>> sudo apt-get install python3-pytest
>>
>> As noted above, my box had many of these already so apt-get skipped the
>> install for them and told me I already had the latest.
>>
>>
>> 2.  Download this source code from:
>> https://sourceforge.net/projects/gnucash/files/gnucash%20%28stable%29/3.2/
>> gnucash-3.2.tar.gz/download
>>
>> 3.  Move the file to where you want to house your source:   I made mine
>> $HOME/Projects/GnuCash.
>> mkdir -p $HOME/Projects/GnuCash
>> cd Downloads
>> mv 

Re: [GNC] The two modules

[DaveC49]

John,

Just to clarify. While I have accounting qualifications, I am not a
practising accountant and my judgement is primarily an opinion based on my
formal studies and my accounting experience in a small business in my
particular country. We all need to keep in mind that accounting, while
adhering to broad general principles, is also subject to local legislation
and different tax laws which varies considerably and even cultural
practices. Some processes may not always be treated the same way and there
may not always be one unique way to approach representing particular
transactions. Fortunately the move towards consistent international
standards has gathered considerable momentum making the task easier in the
longer term. 

I'm happy i did describe the Placeholder operation correctly. My early
training as a physicist in working out what is in black boxes still comes in
handy.

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] Upgrading GC under Ubuntu

[DaveC49]

John,

The GnuCash wiki Installation instructions now link to the build
instructions for Ubuntu (and derivative distrubutions like Linux Mint)
https://wiki.gnucash.org/wiki/Building which in turn has a link specifically
for building V3 on on Ubuntu16.04, 18.04 and derivatives which now hopefully
should be fairly comprehensive. If you have any difficulties with these
instructions or variations for a particular system please mention it on the
forum. I'm a Linux Mint user so my system is not straight Ubuntu 16.04 so I
appreciate any feedback for specific Ubuntu versions. You can also edit the
Wiki pages directly if you request an account to do so.

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] GnuCash 3.2 Released

[Geert Janssens]

Op vrijdag 29 juni 2018 09:43:59 CEST schreef DaveC49:
> Stephen,
> 
> It is generally a good idea to remove the previous version before installing
> a new one. Gnucash will generally overwrite any existing files of the same
> name, but you may be left with unnecessary files in some cases. Going from
> 3.1 to 3.2 should be OK as there are unlikey to be major changes in the
> file structure,

Unfortunately one file change did slip through in the report files between 3.1 
and 3.2. If not uninstalling it would leave two .scm files and two .go files 
from the 3.1 installation that conflict with the new files in 3.2.

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] Dark theme on Windows

[Geert Janssens]

Op zaterdag 30 juni 2018 02:17:55 CEST schreef DaveC49:
> Geert,
> 
> I tried this on Linux Mint 18.3  but had no changes from the default theme.
> 
I think it will only work if the theme itself supports light and dark 
variants. Gtk's default theme, Adwaita, does. But I don't know about others.

What is the default theme on Linux Mint ?

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] Change Reconcile Starting Balance

[Colin Law]

The starting balance in the reconcile start dialog will be the nett
balance of all reconciled transactions so far. Is this the first time
you have reconciled it?  If not then it should be the same as the
ending balance the last time you reconciled, unless you have editted a
reconciled transaction.

Colin

On 30 June 2018 at 13:08, Roger Miskowicz  wrote:
> I am using GC Version 3.2 and trying to reconcile my Credit Card Account
> which I started at the beginning of the year with an opening balance.
>
> I would like to reconcile the account from the opening balance but I don't
> know how to set the 'starting balance' which happens to be some number that
> doesn't seem relevant.
>
> Can the 'starting balance' in 'reconcile' be manuallly set, and if so, how?
> ___
> 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] Rethinking the placeholder account concept (was: Re: Fwd: The two modules)

[Christian Kluge]

Am 30.06.2018 um 22:52 schrieb John Ralls:
> 
> 
>> On Jun 30, 2018, at 12:00 PM, Christian Kluge  wrote:
>>
>> Am 30.06.2018 um 05:37 schrieb John Ralls:
>>>
>>>
 On Jun 29, 2018, at 3:26 PM, Christian Kluge  
 wrote:

 Hi,

 Am 29.06.2018 um 19:26 schrieb John Ralls:
>
>
>> On Jun 29, 2018, at 9:52 AM, Geert Janssens  
>> wrote:
>>
>> Op vrijdag 29 juni 2018 16:59:07 CEST schreef John Ralls:
>>> Stock accounts need to have a parent denominated the currency in which 
>>> the
>>> stock trades in order for the asset roll-up to work correctly on the
>>> Accounts page. Three-commodity transactions are possible using trading
>>> accounts, but I haven’t dealt with that stuff in a while and the details
>>> have gone fuzzy on me.
>>>
>>> Stock accounts aside, let’s not conflate different purposes. We *should*
>>> have an account type to accommodate the European Passive account with
>>> Liability and Equity children, so let’s create that. We’ll need to tweak
>>> some of the reports a bit to accommodate it, but otherwise it won’t have
>>> much impact. It should, of course, be what we now call a placeholder 
>>> and it
>>> should be able to have only Root as a parent and only one each Liability
>>> and Equity placeholder children.
>>>
>> I was in fact deliberately trying to come up with a solution that's more 
>> flexible than fitting the currently known use cases. The European 
>> Passive 
>> account was just one example.
>>
>> However we may be spending more time on it than necessary. I checked in 
>> the 
>> current version of the commercial accounting package* I also have to 
>> deal with 
>> and it doesn't define a Passive type at all. "Passive" it doesn't even 
>> appear 
>> on its default balance sheet. That is a bit uncommon though as the 
>> reports I 
>> get from my accountant do have a passive section. However just like 
>> gnucash 
>> this package is targeting a worldwide audience (though with country 
>> specific 
>> extensions). That may explain why they didn't bother adding the Passive 
>> section.
>>
>> Let me add that contrary to other accounting packages I have played with 
>> in 
>> gnucash the chart of accounts takes a very central place. So whether or 
>> not we 
>> want our own Passive type to group liabilities and equity hierarchically 
>> on 
>> the chart of accounts as well is up for debate.
>>
>>> I don’t think that creating a generic placeholder type account that can 
>>> have
>>> children of any type is a good idea,
>>
>> Here's another example: a household that wants to  track its finances, 
>> but 
>> would want to keep separate account hierarchies per family member. 
>> Standard 
>> response: create two files. However they would benefit from common 
>> reporting 
>> which is cumbersome with two separate files. So what if we would allow 
>> to 
>> create two independent account hierarchies in one file. With a view type 
>> account one could create two top-levels ("Husband" and "Wife") and 
>> create a 
>> independent hierarchy for each. While this could also be solved if we 
>> would 
>> allow multiple root accounts and make that root visible I'm using it 
>> here to 
>> illustrate there are use cases we are not covering well.
>>
>> I borrowed the idea of a view type account from an old version of the 
>> commercial package* we have to use. Looking more closely it turns out 
>> the 
>> current version has dropped view accounts and instead is organizing 
>> charts/
>> reports using a combination of account type (roughly like we do) and 
>> hierarchical account numbers. So I must admit perhaps the idea was not 
>> so 
>> bright after all :)
>>
>> The package also doesn't have a hierarchical account tree. It's flat and 
>> hierarchy is only added in reports as explained above. So there is no 
>> such 
>> thing as a parent account in that package and hence no restriction on 
>> which 
>> account type a certain account can be.
>>
>> Again in gnucash the chart of accounts is very central and visible so we 
>> probably shouldn't drop its hierarchical structure just yet.
>>
>> The downside of this hierarchical structure is then of course we have to 
>> think 
>> about issues like  whether or not we should allow accounts to have any 
>> type of 
>> child or not. I believe parts of gnucash rely on this (I seem to 
>> remember a 
>> relatively recent issue in the export code that it didn't find all 
>> liability 
>> accounts if they had a non-liability parent or such).
>>
>>> and I think that we already have too
>>> many overlapping account types with subtle behavior 

Re: [GNC] Rethinking the placeholder account concept (was: Re: Fwd: The two modules)

[Christian Kluge]

Am 30.06.2018 um 05:37 schrieb John Ralls:
> 
> 
>> On Jun 29, 2018, at 3:26 PM, Christian Kluge  wrote:
>>
>> Hi,
>>
>> Am 29.06.2018 um 19:26 schrieb John Ralls:
>>>
>>>
 On Jun 29, 2018, at 9:52 AM, Geert Janssens  
 wrote:

 Op vrijdag 29 juni 2018 16:59:07 CEST schreef John Ralls:
> Stock accounts need to have a parent denominated the currency in which the
> stock trades in order for the asset roll-up to work correctly on the
> Accounts page. Three-commodity transactions are possible using trading
> accounts, but I haven’t dealt with that stuff in a while and the details
> have gone fuzzy on me.
>
> Stock accounts aside, let’s not conflate different purposes. We *should*
> have an account type to accommodate the European Passive account with
> Liability and Equity children, so let’s create that. We’ll need to tweak
> some of the reports a bit to accommodate it, but otherwise it won’t have
> much impact. It should, of course, be what we now call a placeholder and 
> it
> should be able to have only Root as a parent and only one each Liability
> and Equity placeholder children.
>
 I was in fact deliberately trying to come up with a solution that's more 
 flexible than fitting the currently known use cases. The European Passive 
 account was just one example.

 However we may be spending more time on it than necessary. I checked in 
 the 
 current version of the commercial accounting package* I also have to deal 
 with 
 and it doesn't define a Passive type at all. "Passive" it doesn't even 
 appear 
 on its default balance sheet. That is a bit uncommon though as the reports 
 I 
 get from my accountant do have a passive section. However just like 
 gnucash 
 this package is targeting a worldwide audience (though with country 
 specific 
 extensions). That may explain why they didn't bother adding the Passive 
 section.

 Let me add that contrary to other accounting packages I have played with 
 in 
 gnucash the chart of accounts takes a very central place. So whether or 
 not we 
 want our own Passive type to group liabilities and equity hierarchically 
 on 
 the chart of accounts as well is up for debate.

> I don’t think that creating a generic placeholder type account that can 
> have
> children of any type is a good idea,

 Here's another example: a household that wants to  track its finances, but 
 would want to keep separate account hierarchies per family member. 
 Standard 
 response: create two files. However they would benefit from common 
 reporting 
 which is cumbersome with two separate files. So what if we would allow to 
 create two independent account hierarchies in one file. With a view type 
 account one could create two top-levels ("Husband" and "Wife") and create 
 a 
 independent hierarchy for each. While this could also be solved if we 
 would 
 allow multiple root accounts and make that root visible I'm using it here 
 to 
 illustrate there are use cases we are not covering well.

 I borrowed the idea of a view type account from an old version of the 
 commercial package* we have to use. Looking more closely it turns out the 
 current version has dropped view accounts and instead is organizing charts/
 reports using a combination of account type (roughly like we do) and 
 hierarchical account numbers. So I must admit perhaps the idea was not so 
 bright after all :)

 The package also doesn't have a hierarchical account tree. It's flat and 
 hierarchy is only added in reports as explained above. So there is no such 
 thing as a parent account in that package and hence no restriction on 
 which 
 account type a certain account can be.

 Again in gnucash the chart of accounts is very central and visible so we 
 probably shouldn't drop its hierarchical structure just yet.

 The downside of this hierarchical structure is then of course we have to 
 think 
 about issues like  whether or not we should allow accounts to have any 
 type of 
 child or not. I believe parts of gnucash rely on this (I seem to remember 
 a 
 relatively recent issue in the export code that it didn't find all 
 liability 
 accounts if they had a non-liability parent or such).

> and I think that we already have too
> many overlapping account types with subtle behavior differences that are
> neither documented nor easily discoverable in code.
>
 I'm all for clearing this up. If we can reduce the number of account types 
 that would be great. 
 For reference this is the list of 17 account types supported by the 
 commercial 
 package*:
 Receivable, payable, bank and cash (one type), current assets, non-current 
 

Re: [GNC] Windows strawberry perl and online prices

[Tim Kallmer]

​I actually did uninstall strawberry perl and the leftover strawberry
folder when I went to 3.2, and when I went back to 2.6. It didn't make a
difference.​


On Sat, Jun 30, 2018 at 12:00 PM, David Carlson  wrote:

> There has been some discussion in this list recently suggesting that
> especially when changing between releases from the 2..6 series and 3.0, 3.1
> or 3.2, one should uninstall the previous version manually.  In Windows,
> the Control Panel uninstall feature should work.  If you did not do that
> you may need to manually delete some files before installing a new
> version.  I am not sure where to look for detailed instructions.
>
> I think 3.2 or 2.6.21 are the preferred releases, depending on which works
> better for you.
>
> David C
>
> On Sat, Jun 30, 2018 at 10:40 AM, Tim Kallmer  wrote:
>
>> Has anyone using gnucash on windows had online prices stop working? For me
>> the strawberry perl window opens and never finishes after hours of
>> waiting.
>> I eventually have to close the window and give up. I've tried
>> un/reinstalling gnucash and perl. I've tried 3.1 and 3.2 and 2.6. I've
>> double-checked my alphavantage key is correct. Any suggestions?
>> ___
>> 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] Rethinking the placeholder account concept (was: Re: Fwd: The two modules)

[John Ralls]

> On Jun 30, 2018, at 12:00 PM, Christian Kluge  wrote:
> 
> Am 30.06.2018 um 05:37 schrieb John Ralls:
>> 
>> 
>>> On Jun 29, 2018, at 3:26 PM, Christian Kluge  wrote:
>>> 
>>> Hi,
>>> 
>>> Am 29.06.2018 um 19:26 schrieb John Ralls:
 
 
> On Jun 29, 2018, at 9:52 AM, Geert Janssens  
> wrote:
> 
> Op vrijdag 29 juni 2018 16:59:07 CEST schreef John Ralls:
>> Stock accounts need to have a parent denominated the currency in which 
>> the
>> stock trades in order for the asset roll-up to work correctly on the
>> Accounts page. Three-commodity transactions are possible using trading
>> accounts, but I haven’t dealt with that stuff in a while and the details
>> have gone fuzzy on me.
>> 
>> Stock accounts aside, let’s not conflate different purposes. We *should*
>> have an account type to accommodate the European Passive account with
>> Liability and Equity children, so let’s create that. We’ll need to tweak
>> some of the reports a bit to accommodate it, but otherwise it won’t have
>> much impact. It should, of course, be what we now call a placeholder and 
>> it
>> should be able to have only Root as a parent and only one each Liability
>> and Equity placeholder children.
>> 
> I was in fact deliberately trying to come up with a solution that's more 
> flexible than fitting the currently known use cases. The European Passive 
> account was just one example.
> 
> However we may be spending more time on it than necessary. I checked in 
> the 
> current version of the commercial accounting package* I also have to deal 
> with 
> and it doesn't define a Passive type at all. "Passive" it doesn't even 
> appear 
> on its default balance sheet. That is a bit uncommon though as the 
> reports I 
> get from my accountant do have a passive section. However just like 
> gnucash 
> this package is targeting a worldwide audience (though with country 
> specific 
> extensions). That may explain why they didn't bother adding the Passive 
> section.
> 
> Let me add that contrary to other accounting packages I have played with 
> in 
> gnucash the chart of accounts takes a very central place. So whether or 
> not we 
> want our own Passive type to group liabilities and equity hierarchically 
> on 
> the chart of accounts as well is up for debate.
> 
>> I don’t think that creating a generic placeholder type account that can 
>> have
>> children of any type is a good idea,
> 
> Here's another example: a household that wants to  track its finances, 
> but 
> would want to keep separate account hierarchies per family member. 
> Standard 
> response: create two files. However they would benefit from common 
> reporting 
> which is cumbersome with two separate files. So what if we would allow to 
> create two independent account hierarchies in one file. With a view type 
> account one could create two top-levels ("Husband" and "Wife") and create 
> a 
> independent hierarchy for each. While this could also be solved if we 
> would 
> allow multiple root accounts and make that root visible I'm using it here 
> to 
> illustrate there are use cases we are not covering well.
> 
> I borrowed the idea of a view type account from an old version of the 
> commercial package* we have to use. Looking more closely it turns out the 
> current version has dropped view accounts and instead is organizing 
> charts/
> reports using a combination of account type (roughly like we do) and 
> hierarchical account numbers. So I must admit perhaps the idea was not so 
> bright after all :)
> 
> The package also doesn't have a hierarchical account tree. It's flat and 
> hierarchy is only added in reports as explained above. So there is no 
> such 
> thing as a parent account in that package and hence no restriction on 
> which 
> account type a certain account can be.
> 
> Again in gnucash the chart of accounts is very central and visible so we 
> probably shouldn't drop its hierarchical structure just yet.
> 
> The downside of this hierarchical structure is then of course we have to 
> think 
> about issues like  whether or not we should allow accounts to have any 
> type of 
> child or not. I believe parts of gnucash rely on this (I seem to remember 
> a 
> relatively recent issue in the export code that it didn't find all 
> liability 
> accounts if they had a non-liability parent or such).
> 
>> and I think that we already have too
>> many overlapping account types with subtle behavior differences that are
>> neither documented nor easily discoverable in code.
>> 
> I'm all for clearing this up. If we can reduce the number of account 
> types 

Re: [GNC] Windows strawberry perl and online prices

[David Carlson]

Actually, I have a very similar problem which I have not had time to track
down yet.  I think that it is somewhere in the Finance:Quote configuration,
but I am not sure.

David C

On Sat, Jun 30, 2018 at 3:24 PM, Tim Kallmer  wrote:

> ​I actually did uninstall strawberry perl and the leftover strawberry
> folder when I went to 3.2, and when I went back to 2.6. It didn't make a
> difference.​
>
>
> On Sat, Jun 30, 2018 at 12:00 PM, David Carlson <
> david.carlson@gmail.com> wrote:
>
>> There has been some discussion in this list recently suggesting that
>> especially when changing between releases from the 2..6 series and 3.0, 3.1
>> or 3.2, one should uninstall the previous version manually.  In Windows,
>> the Control Panel uninstall feature should work.  If you did not do that
>> you may need to manually delete some files before installing a new
>> version.  I am not sure where to look for detailed instructions.
>>
>> I think 3.2 or 2.6.21 are the preferred releases, depending on which
>> works better for you.
>>
>> David C
>>
>> On Sat, Jun 30, 2018 at 10:40 AM, Tim Kallmer  wrote:
>>
>>> Has anyone using gnucash on windows had online prices stop working? For
>>> me
>>> the strawberry perl window opens and never finishes after hours of
>>> waiting.
>>> I eventually have to close the window and give up. I've tried
>>> un/reinstalling gnucash and perl. I've tried 3.1 and 3.2 and 2.6. I've
>>> double-checked my alphavantage key is correct. Any suggestions?
>>> ___
>>> 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.

[GNC] How To Record an In-Kind Charitable Donation?

[Eric H. Bowen via gnucash-user]

I performed some design work and provided custom-printed envelopes and
materials for a local 501c3 charitable ministry. I am not charging them
money for the items, but I would like to receive credit for their fair
market value as an in-kind charitable donation. The ministry's treasurer
said to send him an invoice for the material and he would acknowledge
its receipt as a donation. Am I able to use Gnucash to track this
donation and, if so, what is the proper way to record the activity?

-- 

Eric H. Bowen
e...@ehbowen.net 


smime.p7s
Description: S/MIME Cryptographic Signature
___
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] How To Record an In-Kind Charitable Donation?

[David Carlson]

I am not an accountant, so this is not an official recommendation.  When I
make a contribution to a qualified charity, I put the acknowledgement in a
folder to hand to my accountant at tax time.  In GnuCash I enter a
transaction to record the transfer of some (usually) cash asset to
Charity.  For your case, I would probably use an income account for the
value of the work that was donated to charity.  However, that is probably
not report able as taxable income so I would identify the account as
non-taxable income.

David C



On Sat, Jun 30, 2018 at 2:10 PM, Eric H. Bowen via gnucash-user <
gnucash-user@gnucash.org> wrote:

> I performed some design work and provided custom-printed envelopes and
> materials for a local 501c3 charitable ministry. I am not charging them
> money for the items, but I would like to receive credit for their fair
> market value as an in-kind charitable donation. The ministry's treasurer
> said to send him an invoice for the material and he would acknowledge
> its receipt as a donation. Am I able to use Gnucash to track this
> donation and, if so, what is the proper way to record the activity?
>
> --
>
> Eric H. Bowen
> e...@ehbowen.net 
>
> ___
> 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] How To Record an In-Kind Charitable Donation?

[Rich Shepard]

On Sat, 30 Jun 2018, Mike or Penny Novack wrote:

The proper way is the way your tax lawyer/accountant tells you to. Once THAT 
has been settled, we can then tell you "how in gnucash".


  FWIW, I make non-cash donations to Goodwill several times each year. What
I did (and my accountant confirmed is appropriate, at least for Oregon and
the feds) is set up two accounts: an asset account, 'Goodwill,' and an
expense account, 'Donations (non-cash).' If I donate time and effort to a
non-profit other than Goodwill I'll add another asset account and use that
to offset the non-cash donation.

Regards,

Rich
___
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] How To Record an In-Kind Charitable Donation?

[Mike or Penny Novack]

On 6/30/2018 3:10 PM, Eric H. Bowen via gnucash-user wrote:

I performed some design work and provided custom-printed envelopes and
materials for a local 501c3 charitable ministry. I am not charging them
money for the items, but I would like to receive credit for their fair
market value as an in-kind charitable donation. The ministry's treasurer
said to send him an invoice for the material and he would acknowledge
its receipt as a donation. Am I able to use Gnucash to track this
donation and, if so, what is the proper way to record the activity?
The proper way is the way your tax lawyer/accountant tells you to. Once 
THAT has been settled, we can then tell you "how in gnucash".


I lack the "qualifications" to give this sort of advice, especially as 
there are two parts to it. The "materials" part of it is easy, a debit 
to donations and a credit to your materials inventory. The "design work" 
part of it I would not be willing to hazard a guess. Maybe somebody on 
this list who donates professional services might answer.


Michael D Novack
___
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] Rethinking the placeholder account concept (was: Re: Fwd: The two modules)

[DaveC49]

Stephen John, Geert

In accounting terms there are really only 3 basic account types:
  Asset
  Liability
  Equity

These all *must *satisfy the basic accounting equation Assets=Liabilities
+Equity.   

The two sides of this equation are what the German /European system defines
as Activa and Passiva but these groupings are primarily reporting
requirements not account heirarchy. Is there really a need to have an
additional placeholder category as the reporting grouping can be readily
defined from the existing basic account heirarchy structure?

Each type can have function specific sub-types which impose functional
restrictions for that subtype and where the children but these subtypes are
always one of the above basic types. Children of the types and sub-types
must conform to the restriction that they have the same type or subtype as
the parent E.g.

Asset
Top level placeholder
   Current  
placeholder
 Bank
 Accounts-Receivable 
business - no children
 Stock
 Trading
   Non-current   
placeholder

Liability 
Top level placeholder
Accounts payable   
business functionality-no children
Equity   
Top  level placeholder
Income 
Current period revenue placeholder
Expenses  
Current period expenditure placholder

My experimentation and what I have understood of the code is this is already
what GnuCash imposes in its account heirarchy with the exception perhaps
that Income and Expenses are treated as their own types and the Equity type
is enforced in any end of period closing operations and/or in the reporting
and the expanded version of the accounting equation is enforced in the code.

Assets=Liabilities + Equity + Income - Expenses

For business purposes it is usually a requirement that each legal entity
should have it's own set of books.   I handle the situation where I need to
separate different individual contributions within an entity in the manner
John suggested (e.g. a household or a partnership) with labelled subaccounts
within each type as defined above. If there really is a need to fully
separate the individuals in terms of separately recording assets,
liabilities and equity, then it is appropriate to run a separate set of
books.

I think it would be useful/nice to clearly document somewhere, perhaps the
wiki, what the existing account structure is at this point and what
attributes accounts currently have and what their intended purpose is from
the developers point of view as well as the other unintended uses that the
user base can come up with. That could then provide a basis for looking at
restructuring those attributes. Something like the design documents that
were produced at times in the past. This would also give the documenters a
chance to reflect that in the documentation.

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] GnuCash 3.2 Released

[DaveC49]

Hi John,

If GnuCash is not built with Ninja, there is a cmake_uninstall.cmake file in
the top level of the build directory which seems to read the
install_manifest.txt file. The Makefile in the same level produced by CMake
has an uninstall target - not sure how it executes the commands in the
cmake_uninstall.cmake file but it appears to. 

Executing "make uninstall" ( prefixed with sudo if installed in a system
location) in the build directory does remove all of the GnuCash files
installed in the  specified to cmake. (GnuCash V3.2 from the
SourceForge tarball on Linux Mint 18.3 built using Cmake, make and - should
be the same for Ubuntu).

Not sure that happens if it is built with Ninja rather than make though.

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] Change Reconcile Starting Balance

[D via gnucash-user]

I'm glad you've fixed it.

On June 30, 2018, at 3:04 PM, Roger Miskowicz  wrote:

I have fixed my account but not sure about the root cause.


I fixed it by manually, item-by-item, clearing all reconciles which set the  
Starting Balance  to zero.  After which I was able to reconcile producing 
results I expected.


Thanks for helping me fix it.


Roger


P.S.  A nice feature would be the abililty to select a bunch of items to set or 
clear reconciles.



On Sat, Jun 30, 2018 at 8:55 AM, D  wrote:

Only manually, a transaction at a time.

What happens if you ignore the opening balance, enter the correct closing 
balance, and reconcile then?

Often, if there's an inconsistency in the opening balance, you can proceed with 
reconciling, mark your current transactions and any earlier ones that were 
missed before (such as your opening balance transaction, say), and they balance 
out.

David


On June 30, 2018, at 8:23 AM, Roger Miskowicz  wrote:

Thanks Colin.

Is there anyway I can clear all reconcilation of the the account and start
again from scratch?

Roger

On Sat, Jun 30, 2018 at 8:15 AM, Colin Law  wrote:

> The starting balance in the reconcile start dialog will be the nett
> balance of all reconciled transactions so far. Is this the first time
> you have reconciled it?  If not then it should be the same as the
> ending balance the last time you reconciled, unless you have editted a
> reconciled transaction.
>
> Colin
>
> On 30 June 2018 at 13:08, Roger Miskowicz  wrote:
> > I am using GC Version 3.2 and trying to reconcile my Credit Card Account
> > which I started at the beginning of the year with an opening balance.
> >
> > I would like to reconcile the account from the opening balance but I
> don't
> > know how to set the 'starting balance' which happens to be some number
> that
> > doesn't seem relevant.
> >
> > Can the 'starting balance' in 'reconcile' be manuallly set, and if so,
> how?
> > ___
> > 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.


___
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.