Re: [GNC] How to change size of register in Gnucash 3.4

2019-02-04 Thread Liz
On Tue, 5 Feb 2019 16:17:16 +1100
Liz  wrote:

> Debian Linux
> Build ID: 3.4+ (2018-12-30)
> 
> I had the registers set so that I could open 4 without overlapping on
> my screen.
> With Gnucash 3.4 they all got wider and now take up more screen space
> than I desire.
> 
> With the mouse pointer I can make wider still but I wish to make them
> narrower, and it doesn't wish to make it as narrow as I wish.
> 
> I've tried altering WindowGeometry in Account.gnucash.gcm but this
> doesn't seem to have any effect at all.
> 
> Liz
>
I found two versions of Account.gnucash.gcm
and the newer one does not pay attention to a lesser width, just opens
the same size, and rewrites the larger number on closing the register.

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


[GNC] How to change size of register in Gnucash 3.4

2019-02-04 Thread Liz
Debian Linux
Build ID: 3.4+ (2018-12-30)

I had the registers set so that I could open 4 without overlapping on
my screen.
With Gnucash 3.4 they all got wider and now take up more screen space
than I desire.

With the mouse pointer I can make wider still but I wish to make them
narrower, and it doesn't wish to make it as narrow as I wish.

I've tried altering WindowGeometry in Account.gnucash.gcm but this
doesn't seem to have any effect at all.

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


Re: [GNC] Transferring portion of mutual fund account to another fund account

2019-02-04 Thread Christopher Lam
Feel free to experiment your transactions; I'd recommend doing a simplified
transfer on a simple data file first and testing the output.

Please test the portfolio and advanced portfolio reports because they may
not handle these types of transfers, and file bugs on bugzilla if the
reports produce undesirable output.

On Tue., 5 Feb. 2019, 08:37 Harry Foerster  Hello I'm a recent user of Gnucash coming over from the Quicken world.
>
>
>
> I would like to get some guidance on how to properly transfer a portion of
> a
> mutual fund total units in account X into another mutual fund account Y.
> The
> transferred units from account X are taken out on a FIFO basis and into
> account Y maintaining the cost basis. This transfer is not a sale and
> purchase and as such does not involve capital gains or losses.  I've looked
> at the concept of lots and scrubbing but I'm uncertain on how the transfer
> gets into the other account.
>
>
>
> Thanks
>
> ___
> 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] Smarter dating of account reconcile

2019-02-04 Thread Liz
On Mon, 4 Feb 2019 11:19:24 -0600 (CST)
DGPickett via gnucash-user  wrote:

> It's be smart if, when I hit the reconcile button, it selected the
> date of the 1) oldest transaction 2) not in the future 3) n set to c
> or y.  After all, one cannot hope to reconcile the future, and why
> set the reconcile date any later than the last included transaction?
> 

If you want to have something like this, you can go to Bugzilla, enter
it as a "Request for Enhancement"
and feel free to code it ;)

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


Re: [GNC] Gnucash terminates immediately

2019-02-04 Thread Liz
On Mon, 4 Feb 2019 20:51:42 -0600
David Carlson  wrote:

> What version Gnucash? what os?
> 
> On Mon, Feb 4, 2019 at 8:27 PM Bostjan Vilfan 
> wrote:
> 
> > Hello,
> > I haven't used gnucash for some time, and when I tried to call the
> > program the splash screen appears, and the program immediately
> > terminates. Can someone help?
> > Regards,
> > bostjanv


Reading between the lines of the mail header, could be a linux distro.
If a linux distro you may have updated something else and lost a
dependency.

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


Re: [GNC] Gnucash terminates immediately

2019-02-04 Thread David Carlson
What version Gnucash? what os?

On Mon, Feb 4, 2019 at 8:27 PM Bostjan Vilfan  wrote:

> Hello,
> I haven't used gnucash for some time, and when I tried to call the program
> the splash screen appears, and the program immediately terminates. Can
> someone help?
> Regards,
> bostjanv
> ___
> 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] Gnucash terminates immediately

2019-02-04 Thread Bostjan Vilfan
Hello,
I haven't used gnucash for some time, and when I tried to call the program
the splash screen appears, and the program immediately terminates. Can
someone help?
Regards,
bostjanv
___
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] Transferring portion of mutual fund account to another fund account

2019-02-04 Thread David Carlson
If you are in the US and both funds are within the same custodial account
the answer is trivial, just sell one and buy the other.  It only matters
when you withdraw cash.

If you are somehow moving shares from one custodian to another, that is
more complicated.

If they are non-custodial accounts ask your accountant.

David Carlson




On Mon, Feb 4, 2019, 6:37 PM Harry Foerster  Hello I'm a recent user of Gnucash coming over from the Quicken world.
>
>
>
> I would like to get some guidance on how to properly transfer a portion of
> a
> mutual fund total units in account X into another mutual fund account Y.
> The
> transferred units from account X are taken out on a FIFO basis and into
> account Y maintaining the cost basis. This transfer is not a sale and
> purchase and as such does not involve capital gains or losses.  I've looked
> at the concept of lots and scrubbing but I'm uncertain on how the transfer
> gets into the other account.
>
>
>
> Thanks
>
> ___
> 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] Transferring portion of mutual fund account to another fund account

2019-02-04 Thread Harry Foerster
Hello I'm a recent user of Gnucash coming over from the Quicken world.

 

I would like to get some guidance on how to properly transfer a portion of a
mutual fund total units in account X into another mutual fund account Y. The
transferred units from account X are taken out on a FIFO basis and into
account Y maintaining the cost basis. This transfer is not a sale and
purchase and as such does not involve capital gains or losses.  I've looked
at the concept of lots and scrubbing but I'm uncertain on how the transfer
gets into the other account.

 

Thanks 

___
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] Restricting expense report to single checking account

2019-02-04 Thread Steve Cohen

On 2/4/19 5:12 PM, Christopher Lam wrote:

I think only the Transaction Report will offer this flexibility.
Account/Accounts - Bank account
Account/Filter Type - "include"
Account/Filter By.. expense accounts.


On Tue, 5 Feb 2019 at 05:35, Steve Cohen > wrote:


I wish to make an expense report (pie chart, bar chart, not important
which) to track spending over the past two years, but restrict the
content to expenses paid out of a single checking account.  I make
selections that seem appropriate to this task in the dialog, but I can
see through the output that my intentions with regard to the single
account are not being followed.  I can see that certain expenses which
are entirely paid out of another checking account are included in my
totals.

Am I doing something wrong, and if so, how can I get the output I'm
looking for?
___
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.



Thanks, that works!  In fact, it also works in reverse, and maybe better 
that way:


Account/Accounts - all expense accounts
Account/Filter Type - "include"
Account/Filter By.. desired checking account.
Then do subtotals only.  Not sure that will work if you do it the other way.

It would be nice if this filtering mechanism could be extended to the 
graphs.


___
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] Fwd: Restricting expense report to single checking account

2019-02-04 Thread Christopher Lam
Sure you're welcome, but it's customary here to reply-all to list.

-- Forwarded message -
From: Steve Cohen 
Date: Tue, 5 Feb 2019 at 07:28
Subject: Re: [GNC] Restricting expense report to single checking account
To: Christopher Lam 


On 2/4/19 5:12 PM, Christopher Lam wrote:
> I think only the Transaction Report will offer this flexibility.
> Account/Accounts - Bank account
> Account/Filter Type - "include"
> Account/Filter By.. expense accounts.
>
>
> On Tue, 5 Feb 2019 at 05:35, Steve Cohen  > wrote:
>
> I wish to make an expense report (pie chart, bar chart, not important
> which) to track spending over the past two years, but restrict the
> content to expenses paid out of a single checking account.  I make
> selections that seem appropriate to this task in the dialog, but I can
> see through the output that my intentions with regard to the single
> account are not being followed.  I can see that certain expenses which
> are entirely paid out of another checking account are included in my
> totals.
>
> Am I doing something wrong, and if so, how can I get the output I'm
> looking for?
> ___
> 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.
>
Thanks, that works!  In fact, it also works in reverse:

Account/Accounts - all expense accounts
Account/Filter Type - "include"
Account/Filter By.. desired checking account.
Then do subtotals only.

It would be nice if this filtering mechanism could be extended to the
graphs.
___
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 handle bounced check

2019-02-04 Thread Mike Alexander
> On Feb 4, 2019, at 4:32 AM, Geert Janssens  wrote:
> 
> Back to the original question: I think gnucash will try its best to keep you 
> from adding a reverse payment to an already paid invoice. So what you did via 
> manual lot manipulation is probably the closest you can get to that outcome.
> 
> There is however yet another way to see this: if the check bounced it didn't 
> really pay for the invoice to start with.
> 
> So you could decouple the payment from the invoice (the easiest way is by 
> unposting and reposting the invoice). Then presuming you want to keep record 
> of the fact that you received a check, you can keep the payment around and 
> directly credit it via the Process Payment dialog to indicate it bounced. 
> That 
> is, you can select the payment only in that dialog and have gnucash "pay" for 
> that payment, which is to say gnucash would refund that payment.

Thanks for all the help, I learned a number of things.  What I ended up doing 
is use the “Add Reversing Transaction” command on the payment.  Somewhat to my 
surprise this did pretty much what I wanted to do.  It added a “reversed by” 
slot to the payment transaction and decoupled it from the invoice.  This left 
the invoice unpaid.  I created a new invoice for the late fee and used the 
customer’s replacement check to pay both the original invoice and this new one. 
 This seems to make the books reflect reality fairly well.  My main problem was 
that I had forgotten about the "Add Reversing Transaction” command so didn’t 
think to try it.

   Mike
 
___
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] Restricting expense report to single checking account

2019-02-04 Thread Christopher Lam
I think only the Transaction Report will offer this flexibility.
Account/Accounts - Bank account
Account/Filter Type - "include"
Account/Filter By.. expense accounts.


On Tue, 5 Feb 2019 at 05:35, Steve Cohen  wrote:

> I wish to make an expense report (pie chart, bar chart, not important
> which) to track spending over the past two years, but restrict the
> content to expenses paid out of a single checking account.  I make
> selections that seem appropriate to this task in the dialog, but I can
> see through the output that my intentions with regard to the single
> account are not being followed.  I can see that certain expenses which
> are entirely paid out of another checking account are included in my
> totals.
>
> Am I doing something wrong, and if so, how can I get the output I'm
> looking for?
> ___
> 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] Smarter dating of account reconcile

2019-02-04 Thread David G. Pickett via gnucash-user
Sorry, newest not oldest!
 
 
 
-Original Message-
From: Dale Alspach 
To: David G. Pickett 
Cc: geert.gnucash ; Gnucash Users 

Sent: Mon, Feb 4, 2019 3:37 pm
Subject: Re: [GNC] Smarter dating of account reconcile

> 1) oldest transaction 2) not in the future 3) n set to c or y.The oldest 
>transaction would presumably be the first transaction in the account so I 
>assume you mean the most recent transaction.If someone does not frequently 
>mark transactions c or y, the date you are advocating could be as early as the 
>previous reconcile date. Think of someone who examines the transactions only 
>when a new statement is received.In my case what you are advocating would 
>almost always be wrong. Currently the software usually suggests the same day 
>of the next month after the previous reconcile. That is often the correct 
>statement date for my accounts.
Dale
On Mon, Feb 4, 2019 at 1:23 PM David G. Pickett via gnucash-user 
 wrote:

 The statement date is also in the past, so the default date is pretty much 
never right.  In a busy account, my date would match.  While the statement date 
might be later than the last included transaction, there is no value in the 
later date, since no transactions exist in the intervening time span.

I date my checking transactions to the check date, not the clearing date, as 
that is the earliest date for the life of that check.

I guess you are presenting some sort of CPA religion argument on dates in 
books, accounts.  I just want fewer motions in the process. 

-Original Message-
From: Geert Janssens 
To: gnucash-user ; DGPickett 
Sent: Mon, Feb 4, 2019 12:52 pm
Subject: Re: [GNC] Smarter dating of account reconcile

Op maandag 4 februari 2019 18:19:24 CET schreef DGPickett via gnucash-user:
> It's be smart if, when I hit the reconcile button, it selected the date of
> the 1) oldest transaction 2) not in the future 3) n set to c or y.  After
> all, one cannot hope to reconcile the future, and why set the reconcile date
> any later than the last included transaction?

Why? Because reconciling normally happens against a bank statement and the 
reconcile date should be the bank statement's date which is not necessarily 
the date of the last included transaction.

The current algorithm will calculate the number of days between the last and 
second to last reconcile and will project that period to guess the next 
statement date (and this logic has a couple of flaws so even this doesn't work 
reliably). This of course assumes bank statements are provided at regular 
intervals. That may be a completely flawed assumption, but now at least you 
know how it currently works.

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.

___
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] Restricting expense report to single checking account

2019-02-04 Thread Steve Cohen
I wish to make an expense report (pie chart, bar chart, not important 
which) to track spending over the past two years, but restrict the 
content to expenses paid out of a single checking account.  I make 
selections that seem appropriate to this task in the dialog, but I can 
see through the output that my intentions with regard to the single 
account are not being followed.  I can see that certain expenses which 
are entirely paid out of another checking account are included in my 
totals.


Am I doing something wrong, and if so, how can I get the output I'm 
looking for?

___
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] Smarter dating of account reconcile

2019-02-04 Thread David Carlson
On Mon, Feb 4, 2019 at 1:22 PM David G. Pickett via gnucash-user <
gnucash-user@gnucash.org> wrote:

>  The statement date is also in the past, so the default date is pretty
> much never right.  In a busy account, my date would match.  While the
> statement date might be later than the last included transaction, there is
> no value in the later date, since no transactions exist in the intervening
> time span.
>
> I date my checking transactions to the check date, not the clearing date,
> as that is the earliest date for the life of that check.
>
> I guess you are presenting some sort of CPA religion argument on dates in
> books, accounts.  I just want fewer motions in the process.
>
>
I do not see how the dates that are associated with any transactions are
useful in predicting the date of the next unreconciled statement beyond
possibly if there happens to be no unreconciled transactions with a posting
date before the predicted reconcile date the program might ask the user if
[s]he really wants to use that reconcile date.  That seems to me to be a
very weak reason to complicate things for the user.

If you are talking about whether to display 'new' unreconciled transactions
dated after the reconcile date in the reconcile dialog, it just seems very
easy to ignore them while reconciling and occasionally one of them should
have had an earlier date if the user forgot to backdate a missed
transaction when it was finally entered.

Since most banks post statements monthly on either the same date or very
close, it works fine for me as is except for the fourth month in
non-leap-years for some crazy reason.

David Carlson
___
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] Smarter dating of account reconcile

2019-02-04 Thread Dale Alspach
> 1) oldest transaction 2) not in the future 3) n set to c or y.
The oldest transaction would presumably be the first transaction in the
account so I assume you mean the most recent transaction.
If someone does not frequently mark transactions c or y, the date you are
advocating could be as early as the previous reconcile date. Think of
someone who examines the transactions only when a new statement is received.
In my case what you are advocating would almost always be wrong. Currently
the software usually suggests the same day of the next month after the
previous reconcile. That is often the correct statement date for my
accounts.

Dale

On Mon, Feb 4, 2019 at 1:23 PM David G. Pickett via gnucash-user <
gnucash-user@gnucash.org> wrote:

>  The statement date is also in the past, so the default date is pretty
> much never right.  In a busy account, my date would match.  While the
> statement date might be later than the last included transaction, there is
> no value in the later date, since no transactions exist in the intervening
> time span.
>
> I date my checking transactions to the check date, not the clearing date,
> as that is the earliest date for the life of that check.
>
> I guess you are presenting some sort of CPA religion argument on dates in
> books, accounts.  I just want fewer motions in the process.
>
> -Original Message-
> From: Geert Janssens 
> To: gnucash-user ; DGPickett 
> Sent: Mon, Feb 4, 2019 12:52 pm
> Subject: Re: [GNC] Smarter dating of account reconcile
>
> Op maandag 4 februari 2019 18:19:24 CET schreef DGPickett via gnucash-user:
> > It's be smart if, when I hit the reconcile button, it selected the date
> of
> > the 1) oldest transaction 2) not in the future 3) n set to c or y.
> After
> > all, one cannot hope to reconcile the future, and why set the reconcile
> date
> > any later than the last included transaction?
>
> Why? Because reconciling normally happens against a bank statement and the
> reconcile date should be the bank statement's date which is not
> necessarily
> the date of the last included transaction.
>
> The current algorithm will calculate the number of days between the last
> and
> second to last reconcile and will project that period to guess the next
> statement date (and this logic has a couple of flaws so even this doesn't
> work
> reliably). This of course assumes bank statements are provided at regular
> intervals. That may be a completely flawed assumption, but now at least
> you
> know how it currently works.
>
> 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.
>
___
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] Smarter dating of account reconcile

2019-02-04 Thread David G. Pickett via gnucash-user
 The statement date is also in the past, so the default date is pretty much 
never right.  In a busy account, my date would match.  While the statement date 
might be later than the last included transaction, there is no value in the 
later date, since no transactions exist in the intervening time span.

I date my checking transactions to the check date, not the clearing date, as 
that is the earliest date for the life of that check.

I guess you are presenting some sort of CPA religion argument on dates in 
books, accounts.  I just want fewer motions in the process. 
 
-Original Message-
From: Geert Janssens 
To: gnucash-user ; DGPickett 
Sent: Mon, Feb 4, 2019 12:52 pm
Subject: Re: [GNC] Smarter dating of account reconcile

Op maandag 4 februari 2019 18:19:24 CET schreef DGPickett via gnucash-user:
> It's be smart if, when I hit the reconcile button, it selected the date of
> the 1) oldest transaction 2) not in the future 3) n set to c or y.  After
> all, one cannot hope to reconcile the future, and why set the reconcile date
> any later than the last included transaction?

Why? Because reconciling normally happens against a bank statement and the 
reconcile date should be the bank statement's date which is not necessarily 
the date of the last included transaction.

The current algorithm will calculate the number of days between the last and 
second to last reconcile and will project that period to guess the next 
statement date (and this logic has a couple of flaws so even this doesn't work 
reliably). This of course assumes bank statements are provided at regular 
intervals. That may be a completely flawed assumption, but now at least you 
know how it currently works.

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] Smarter dating of account reconcile

2019-02-04 Thread Geert Janssens
Op maandag 4 februari 2019 18:19:24 CET schreef DGPickett via gnucash-user:
> It's be smart if, when I hit the reconcile button, it selected the date of
> the 1) oldest transaction 2) not in the future 3) n set to c or y.  After
> all, one cannot hope to reconcile the future, and why set the reconcile date
> any later than the last included transaction?

Why? Because reconciling normally happens against a bank statement and the 
reconcile date should be the bank statement's date which is not necessarily 
the date of the last included transaction.

The current algorithm will calculate the number of days between the last and 
second to last reconcile and will project that period to guess the next 
statement date (and this logic has a couple of flaws so even this doesn't work 
reliably). This of course assumes bank statements are provided at regular 
intervals. That may be a completely flawed assumption, but now at least you 
know how it currently works.

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.


[GNC] Smarter dating of account reconcile

2019-02-04 Thread DGPickett via gnucash-user
It's be smart if, when I hit the reconcile button, it selected the date of
the 1) oldest transaction 2) not in the future 3) n set to c or y.  After
all, one cannot hope to reconcile the future, and why set the reconcile date
any later than the last included transaction?



--
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] Help with Error While Setting Up Online Price Quotes

2019-02-04 Thread John Ralls



> On Feb 3, 2019, at 11:42 AM, James Lobash  wrote:
> 
> Help.  I was attempting to load the GnuCash Online Price retriever but
> received the following error message during the "Run gnc-fq-helper" program:
> ___
> Can't locate Date/Manip.pm in @INC (you may need to install the Date::Manip
> module) (@INC contains: C:/Perl64/site/lib C:/Perl64/lib) at gnc-fq-helper
> line 29.
> 
> BEGIN failed-compilation aborted at gnc-fq-helper line 29
> 
> 
> Am I missing a program in my installation program in order to get this to
> run, or is it something in my operating system?

You're missing a required module named Date::Manip. It's available from CPAN.

Regards,
John Ralls

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


Re: [GNC] Number Rounding

2019-02-04 Thread thecat131
hmmm - I closed gnuCash and reopened it
Seems the problem has been fixed

Sorry to trouble you all!
Cheers
thecat131



-
GNUCash V2.4.6
Mac OS X 10.5.8
--
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] Number Rounding

2019-02-04 Thread David T. via gnucash-user
So, you're saying that your transaction reads $5.26 in all its splits, but the 
reconcile window is showing it as $5.30? 
Are you sure you're looking at the same transaction, and not two similar 
transactions with different amounts?
Is there something else about this transaction that is odd? 
David

 
 
  On Mon, Feb 4, 2019 at 16:26, thecat131 wrote:   GnuCash 
V3.4
Mac OS V10.12.6
Currency:  Australian Dollars

I tried to reconcile an account but found:
the transaction has been keyed in as $5.26
the reconciliation window shows $5.30

I need the reconciliation window to show the data that was keyed in, not
round the data.

I went to Preferences > General > Force Prices to display as decimals and
ticked the box
Decimal Places set to 2
Didn't make a difference

I went to Tools Security Editor  > Currency > Australian Dollar
Everything is greyed out but the Fraction Traded window is set to 1/100

How do I stop the Reconciliation window from rounding?

Thanks in advance
thecat131








-
GNUCash V2.4.6
Mac OS X 10.5.8
--
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] Stock account type "child account" under Equity account type "parent account".

2019-02-04 Thread David Cousens
Jason,

"trades in its own stock"It is usually illegal for a company to hold its
own shares as assets of the company (except as Treasury stock which does not
have the rights of a shareholder
https://en.wikipedia.org/wiki/Treasury_stock). This is the case in
Australian and UK law
http://www.takeovers.gov.au/content/Resources/cslrc/cslrc_discussion_paper_no_5.aspx.
 

US law position is illustrated here
https://scholar.smu.edu/cgi/viewcontent.cgi?article=3793=smulr. and
is less clear cut.

This is distinct from issuing stock or a stock split to lower the market
value of the shares held by shareholders by issuing more shares in a
proportional manner.

AFAIK the stock split procedures described in GnuCash are implemented purely
from the point of view of the owner of the shares who wishes to record that
a company in which he owns shares has undertaken a stock split and he is
recording the effect of the stock split on those shares that he  he owns. 

I don't think this procedure however handles the accounting for a stock
split from perspective ofthe company who issues the stock split to its
shareholders. Derek will correct me if I am wrong on that. 

That was covered in outline in one of the articles I posted earlier. (In
practice you may have to account for costs associated with the stock
exchange requirements, issue of the securities etc. as well)  GnuCash can
certainly handle recording this from an accounting perspective, but its
business features don't extend to any automation of or calculations for the
process. All entries would be manual.

If you are seriously operating a company that is publicly floated or going
to be, you may need to look more closely at what your accounting needs will
be and take professional advice as to appropriate software. This will
particularly the case if you have significant payroll and/or inventory or
cost management requirements. GnuCash has no capability in these areas at
the moment and is unlikely to have in the near future. If you have a CFO in
mind, it would be wise to consult him/her about such decisions as well.

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] Question about display of reports

2019-02-04 Thread David T. via gnucash-user

Mark, 
Your problem stems from the fact that your accounts are in (Canadian?) dollars, 
while your locale may be in pounds. 
I am not versed in multi-currency situations. Maybe someone else can advise you 
on how to clear that up. 
David
 
 
  On Mon, Feb 4, 2019 at 13:54, Mark Stockwell wrote:   
Hi David
It appears to be in all reports that I run. Attached is an example of a balance 
sheet report where there are lots of zero balances showing on the right hand 
side that do not appear to represent anything and none of the totals add up to 
what I am expecting to see?
Thanks
Mark



On 3 Feb 2019, at 6:11 am, David T.  wrote:
And which report.


On Feb 3, 2019, at 9:42 AM, David Carlson  wrote:

Mark, you left out which version you are using.

On Sat, Feb 2, 2019 at 10:08 PM Mark Stockwell via gnucash-user <
gnucash-user@gnucash.org> wrote:


Hi

Whenever I run a report from my version of Gnucash, for every line
displaying balances, there is another ghost column to the right with zeros
all the way down the page. Please could you let me know how I can remove
this ghost column so that I can use the reporting for sending to my tax
adviser?

Thanks

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


[GNC] Number Rounding

2019-02-04 Thread thecat131
GnuCash V3.4
Mac OS V10.12.6
Currency:  Australian Dollars

I tried to reconcile an account but found:
the transaction has been keyed in as $5.26
the reconciliation window shows $5.30

I need the reconciliation window to show the data that was keyed in, not
round the data.

I went to Preferences > General > Force Prices to display as decimals and
ticked the box
Decimal Places set to 2
Didn't make a difference

I went to Tools Security Editor  > Currency > Australian Dollar
Everything is greyed out but the Fraction Traded window is set to 1/100

How do I stop the Reconciliation window from rounding?

Thanks in advance
thecat131








-
GNUCash V2.4.6
Mac OS X 10.5.8
--
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] postpone reconciliation broken: ignores my changes

2019-02-04 Thread Colin Law
On Mon, 4 Feb 2019 at 06:53, Jamestk  wrote:

> Yup, I can see the button - next time i will try the menu selection for
> postpone, it's no biggie as I rarely use it, only when getting tired and
> start making mistakes.
>

It is easy to test if it is still working, even if it is not time for a
reconcile.  Start a reconcile, accept the default values, tick the first
item, Postpone, open Reconcile again.  If the first one is no longer ticked
then it is obviously not working so you can just cancel and you are back
where you started.  If it is still ticked then it is working, then you can
clear that one and postpone again, and again you are back where you
started.  In fact if you are at all worried about the state of the file
then just close without saving.

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


Re: [GNC] Stock account type "child account" under Equity account type "parent account".

2019-02-04 Thread Liz
On Sun, 3 Feb 2019 20:35:22 -0600 (CST)
jason  wrote:

> Test
> 
> It seems my post did not deliver.
> 
> 
> 
> --
> 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.

Which post - there is one 24 minutes before this one.
Are there others?

You are posting from a gmail account. gmail thinks that you don't need
to see posts which you sent yourself.

Either check "All Mail" in gmail, or the list archives if need to know
if a post is missing.

Liz, 
Moderator Hat Today.
___
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 handle bounced check

2019-02-04 Thread Geert Janssens
Op zaterdag 2 februari 2019 09:37:02 CET schreef Wm via gnucash-user:
> On 02/02/2019 04:24, Mike Alexander wrote:
> > A few weeks ago I received a check in payment for an invoice I had sent to
> > a customer.  I recorded the payment and deposited the check.  A couple of
> > weeks later I got notice from my bank that the check had bounced.  My
> > question is how to record this.  I want to “unpay” the invoice and charge
> > the amount back to the customer, but I can’t find a good way to do this.
> > 
> > I tried entering a transaction to debit Accounts Receivable and credit the
> > bank account after which I manually added the split in A/R to the lot for
> > that invoice.
> my opinion is you are overthinking this
> 
>  >This sort of worked, but the invoice is still marked paid in the
> 
> customer report.  I can, however, select it in the “Process Payment”
> dialog to pay it again and it shows up as unpaid in the receivables
> aging report.  Can I do better than this?
> 
> The accounting is ordinary, the customer owes you the money from the
> original date.
> 
> The invoice, payment, bounce sequence is a record of events.  I think
> this should show in your accounts, other people think it shouldn't,
> dunno why, it is a reflection of the person that didn't pay, not you.
> 
> Ordinary solution?  Make a new invoice and let the person know you
> expect it to be paid.

In double accounting that would create a mismatch between the document flow 
and the money flow:
- you'd have two documents claiming you are to receive money
- you have entered one payment and one refund
Summing all of those together it would seem you should still receive two 
payments.

You could balance this by writing an internal credit note to cater for the 
bounced check and then write a new invoice (which you could send to the 
customer to inform them of a bounced check).

Back to the original question: I think gnucash will try its best to keep you 
from adding a reverse payment to an already paid invoice. So what you did via 
manual lot manipulation is probably the closest you can get to that outcome.

There is however yet another way to see this: if the check bounced it didn't 
really pay for the invoice to start with.

So you could decouple the payment from the invoice (the easiest way is by 
unposting and reposting the invoice). Then presuming you want to keep record 
of the fact that you received a check, you can keep the payment around and 
directly credit it via the Process Payment dialog to indicate it bounced. That 
is, you can select the payment only in that dialog and have gnucash "pay" for 
that payment, which is to say gnucash would refund that payment.

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] Question about display of reports

2019-02-04 Thread Mark Stockwell via gnucash-user
Hi David

It appears to be in all reports that I run. Attached is an example of a balance 
sheet report where there are lots of zero balances showing on the right hand 
side that do not appear to represent anything and none of the totals add up to 
what I am expecting to see?

Thanks

Mark



> On 3 Feb 2019, at 6:11 am, David T.  wrote:
> 
> And which report.
> 
>> On Feb 3, 2019, at 9:42 AM, David Carlson  
>> wrote:
>> 
>> Mark, you left out which version you are using.
>> 
>> On Sat, Feb 2, 2019 at 10:08 PM Mark Stockwell via gnucash-user <
>> gnucash-user@gnucash.org> wrote:
>> 
>>> Hi
>>> 
>>> Whenever I run a report from my version of Gnucash, for every line
>>> displaying balances, there is another ghost column to the right with zeros
>>> all the way down the page. Please could you let me know how I can remove
>>> this ghost column so that I can use the reporting for sending to my tax
>>> adviser?
>>> 
>>> Thanks
>>> 
>>> Mark
>>> ___
>>> 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.


[GNC] Help with Error While Setting Up Online Price Quotes

2019-02-04 Thread James Lobash
Help.  I was attempting to load the GnuCash Online Price retriever but
received the following error message during the "Run gnc-fq-helper" program:
___
Can't locate Date/Manip.pm in @INC (you may need to install the Date::Manip
module) (@INC contains: C:/Perl64/site/lib C:/Perl64/lib) at gnc-fq-helper
line 29.

BEGIN failed-compilation aborted at gnc-fq-helper line 29


Am I missing a program in my installation program in order to get this to
run, or is it something in my operating system?


Thanks for the help,
___
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.