Re: [GNC] GnuCash wiki

2018-12-14 Thread Geert Janssens
Hi David,

Right now it is working for me. I believe it's temporarily hosted via a flakey 
internet connection so it may indeed be unreachable from time to time.

Regards,

Geert

Op zaterdag 15 december 2018 05:29:09 CET schreef David Cousens:
> Hi,
> 
> Does anyone know if the wiki is currently down? I am unable to access it to
> either view or edit but have no problem with other content or the main
> website.
> 
> 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.




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

2018-12-14 Thread David Cousens
Hi,

Does anyone know if the wiki is currently down? I am unable to access it to
either view or edit but have no problem with other content or the main
website.

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] Reconciling different periods?

2018-12-14 Thread David Cousens
Steve,

One way to locate entries like that is to open the reconcile window. Any 
unreconciled transactions before the start of
the current period being reconciled will normally appear at the start of the 
list on the reconciliation page which can
help loacting  some finger trouble entries.  These are usually in date order 
initially.  I had an entry by accident last
year which somehow was entered with 2015 as the year which showed up easily 
this way. The hard part is then verifying
that it wasn't a 2015 transaction.

David


On Fri, 2018-12-14 at 15:16 -0800, Stephen M. Butler wrote:
> On 12/14/18 2:39 PM, elvis wrote:
> > Bite sized chunks, bite sized chunks.
> > 
> > 
> > Sometimes I get a few months and hundreds of transactions behind. I'll 
> > go a few days at a time to get started then weeks. Trying to remember 
> > what you did 3 months ago is hard! :-) But finding an error in 5 
> > transactions is easy, finding it in 500 is hard.
> > 
> > Remember, you are never alone. There's you and the future-you trying 
> > to figure out what you did just now.
> > 
> 
> The worst feeling is knowing that the accounts were balanced before you 
> started the day.  Then finding that nothing balances all the way back to 
> January.  Turns out that the last transaction for November showed up in 
> January (my finger failed to stutter on the month number)!
> 
> Took awhile to track that one down and convince myself I wasn't going 
> crazy.  So, even byte sized chunks may be bigger than you expect.
> 
> > 
> > 
> > 
> > On 14/12/18 8:07 pm, Finbar Mahon wrote:
> > > No Michael, thank you for the comprehensive answer.
> > > 
> > > Like many others I suspect, Summer goes by quickly (in the Northern 
> > > Hemisphere) and doing the accounts falls by the wayside :-)
> > > 
> > > I am catching up and discovered that the reconciliation had strange 
> > > balances (negative) in the reconciliation of one particular account. 
> > > So, what I wanted to do was go back to the last 'good' reconciliation 
> > > that I had on the printed bank statements for that a/c and work 
> > > forward to discover where things had gone wrong. I suspect a date 
> > > anomaly, an entry on the wrong date, maybe even the wrong year, 
> > > finger problems :-)
> > > 
> > > So, the ideas on this thread indicate the way to do it is to ensure 
> > > the balance at the end of a good reconciliation is coincident with 
> > > the bank statement and look to see what income/expenditures are 
> > > listed in the attempt to reconcile after that date and may be wrong.
> > > 
> > > I haven't tried that (coming up to festivites, other priorities) but 
> > > I'll report here on the outcome. :-)
> > > 
> > > 
> > > 
> > > On 13/12/2018 23:57, Michael Hendry wrote:
> > > 
> > > > > On 13 Dec 2018, at 17:13, Finbar Mahon  wrote:
> > > > > 
> > > > > Thanks, Michael, I have been trying that using end March of this 
> > > > > year as the last 'OK' date but doing it up to latest balance seems 
> > > > > to catch other errors, so I  was wondering if I could 'stage' the 
> > > > > process.
> > > > > 
> > > > > Looks like D's reply indicates I could do it by varying the closing 
> > > > > balance to coincide with one I am happy with. Maybe a slight 
> > > > > problem if the closing balance is duplicated elsewhere? Maybe 
> > > > > unlikely.
> > > > > 
> > > > > In fact by a combination of the two replies I can go back to the 
> > > > > last 'good' situation and use the closing balance there as a 
> > > > > starting point?
> > > > > 
> > > > > I'll give the ending balance a try.
> > > > > 
> > > > > F
> > > > 
> > > > I’m not sure what you mean by “the ending balance” here.
> > > > 
> > > > Let’s consider a simple situation: you have one bank account - what 
> > > > we in the UK call a “current account”.
> > > > 
> > > > For this example, consider that your financial year starts on the 
> > > > 1st January 2018, and you have a bank statement for the period 
> > > > ending 31 December 2017. This will have a figure (say £x) for the 
> > > > balance on 31 December 2017.
> > > > 
> > > > When you create this bank account in GnuCash, you set it up with a 
> > > > starting balance of £x.
> > > > 
> > > > Throughout January and into February you enter every transaction 
> > > > that involves that account (payments into the account of cash and 
> > > > cheques, withdrawals in cash, by cheque, direct debit, and so on).
> > > > 
> > > > When your statement arrives for the month ending 31st January, go 
> > > > ahead with the reconciliation. Because there are sometimes delays in 
> > > > transactions hitting the bank account, Gnucash will have the correct 
> > > > starting balance, but may have calculated the ending balance for the 
> > > > month incorrectly - let’s say you issued a cheque on 28th January 
> > > > and the recipient hasn’t paid it into his bank account yet. You 
> > > > should enter the bank’s version of the final balance for January 
> > > > into the “Reconcile 

Re: [GNC] Reconciling different periods?

2018-12-14 Thread elvis


On 15/12/18 9:16 am, Stephen M. Butler wrote:

On 12/14/18 2:39 PM, elvis wrote:

Bite sized chunks, bite sized chunks.


Sometimes I get a few months and hundreds of transactions behind. 
I'll go a few days at a time to get started then weeks. Trying to 
remember what you did 3 months ago is hard! :-) But finding an error 
in 5 transactions is easy, finding it in 500 is hard.


Remember, you are never alone. There's you and the future-you trying 
to figure out what you did just now.




The worst feeling is knowing that the accounts were balanced before 
you started the day.  Then finding that nothing balances all the way 
back to January.  Turns out that the last transaction for November 
showed up in January (my finger failed to stutter on the month number)!


Took awhile to track that one down and convince myself I wasn't going 
crazy.  So, even byte sized chunks may be bigger than you expect.



I used to have that problem, starting off from something that balanced 
last time but was now out.



I just do 1 or 0 transactions to start with, if you are reconciling with 
the same balance you had last time, it makes it easier to find something 
that has been unreconciled by mistake or a transaction moved about...  
hopefully it would just balance again, but leave the out of place 
transaction unreconciled on its own in the window.










On 14/12/18 8:07 pm, Finbar Mahon wrote:

No Michael, thank you for the comprehensive answer.

Like many others I suspect, Summer goes by quickly (in the Northern 
Hemisphere) and doing the accounts falls by the wayside :-)


I am catching up and discovered that the reconciliation had strange 
balances (negative) in the reconciliation of one particular account. 
So, what I wanted to do was go back to the last 'good' 
reconciliation that I had on the printed bank statements for that 
a/c and work forward to discover where things had gone wrong. I 
suspect a date anomaly, an entry on the wrong date, maybe even the 
wrong year, finger problems :-)


So, the ideas on this thread indicate the way to do it is to ensure 
the balance at the end of a good reconciliation is coincident with 
the bank statement and look to see what income/expenditures are 
listed in the attempt to reconcile after that date and may be wrong.


I haven't tried that (coming up to festivites, other priorities) but 
I'll report here on the outcome. :-)




On 13/12/2018 23:57, Michael Hendry wrote:


On 13 Dec 2018, at 17:13, Finbar Mahon  wrote:

Thanks, Michael, I have been trying that using end March of this 
year as the last 'OK' date but doing it up to latest balance seems 
to catch other errors, so I  was wondering if I could 'stage' the 
process.


Looks like D's reply indicates I could do it by varying the 
closing balance to coincide with one I am happy with. Maybe a 
slight problem if the closing balance is duplicated elsewhere? 
Maybe unlikely.


In fact by a combination of the two replies I can go back to the 
last 'good' situation and use the closing balance there as a 
starting point?


I'll give the ending balance a try.

F


I’m not sure what you mean by “the ending balance” here.

Let’s consider a simple situation: you have one bank account - what 
we in the UK call a “current account”.


For this example, consider that your financial year starts on the 
1st January 2018, and you have a bank statement for the period 
ending 31 December 2017. This will have a figure (say £x) for the 
balance on 31 December 2017.


When you create this bank account in GnuCash, you set it up with a 
starting balance of £x.


Throughout January and into February you enter every transaction 
that involves that account (payments into the account of cash and 
cheques, withdrawals in cash, by cheque, direct debit, and so on).


When your statement arrives for the month ending 31st January, go 
ahead with the reconciliation. Because there are sometimes delays 
in transactions hitting the bank account, Gnucash will have the 
correct starting balance, but may have calculated the ending 
balance for the month incorrectly - let’s say you issued a cheque 
on 28th January and the recipient hasn’t paid it into his bank 
account yet. You should enter the bank’s version of the final 
balance for January into the “Reconcile information” in the box 
marked “Ending Balance”.


Now press OK, and work your way through the reconciliation 
procedure, ticking the box against each transaction on the screen 
that matches one on the bank statement, which you should mark as 
reconciled in pencil.


Once you have ticked all the transactions on the statement you 
should have a “Difference” at the bottom right of the Reconcile 
window of £0.00.


If there is a discrepancy (i.e. “Difference” is non-zero), you have 
a problem which you need to resolve NOW, because in my experience 
banks and computers can add or subtract quite accurately, and 
you’ve just ticked the computer’s and the bank’s versions of the 
same transactions and 

Re: [GNC] gnucash 3.x crash on startup windows 10

2018-12-14 Thread Florian
Florian wrote
> I have the same problem and isntalled gdb with chocolatey (3rd party
> Windows
> package manager).
> 
> Unfortunately, gdb says no stack found. The complete output is as follows:

Ok, so I set a proper breakpoint and now, I got this:

(gdb) b exit
Breakpoint 1 at 0x74c67165 (6 locations)
(gdb) run
Starting program: C:\Program Files (x86)\gnucash\bin\gnucash.exe
[New Thread 1932.0x920]
[New Thread 1932.0x1be0]
[New Thread 1932.0xf2c]
[New Thread 1932.0x1b18]
[New Thread 1932.0x1f68]
[New Thread 1932.0x1354]
[New Thread 1932.0x4d8]
[New Thread 1932.0x1e88]

Thread 1 hit Breakpoint 1, 0x74c67755 in msvcrt!exit () from
C:\WINDOWS\System32\msvcrt.dll
(gdb) bt
#0  0x74c67755 in msvcrt!exit () from C:\WINDOWS\System32\msvcrt.dll
#1  0x707b9f23 in scm_boot_guile (argc=1, argv=0x5f25e38, main_func=0x4034b4
, closure=0x0)
at C:/gcdev64/gnucash/releases/src/guile-2.0.14/libguile/init.c:330
#2  0x00403b94 in main ()
(gdb) bt full
#0  0x74c67755 in msvcrt!exit () from C:\WINDOWS\System32\msvcrt.dll
No symbol table info available.
#1  0x707b9f23 in scm_boot_guile (argc=1, argv=0x5f25e38, main_func=0x4034b4
, closure=0x0)
at C:/gcdev64/gnucash/releases/src/guile-2.0.14/libguile/init.c:330
res = 
c = {main_func = 0x4034b4 , closure = 0x0, argc = 1,
argv = 0x5f25e38}
#2  0x00403b94 in main ()
No symbol table info available.
(gdb) c
Continuing.
[Thread 1932.0xf2c exited with code 1]
[Thread 1932.0x1e88 exited with code 1]
[Thread 1932.0x1be0 exited with code 1]
[Thread 1932.0x4d8 exited with code 1]
[Thread 1932.0x1f68 exited with code 1]
[Thread 1932.0x1b18 exited with code 1]
[Thread 1932.0x1354 exited with code 1]
[Inferior 1 (process 1932) exited with code 01]
(gdb)




--
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] Reconciling different periods?

2018-12-14 Thread Stephen M. Butler

On 12/14/18 2:39 PM, elvis wrote:

Bite sized chunks, bite sized chunks.


Sometimes I get a few months and hundreds of transactions behind. I'll 
go a few days at a time to get started then weeks. Trying to remember 
what you did 3 months ago is hard! :-) But finding an error in 5 
transactions is easy, finding it in 500 is hard.


Remember, you are never alone. There's you and the future-you trying 
to figure out what you did just now.




The worst feeling is knowing that the accounts were balanced before you 
started the day.  Then finding that nothing balances all the way back to 
January.  Turns out that the last transaction for November showed up in 
January (my finger failed to stutter on the month number)!


Took awhile to track that one down and convince myself I wasn't going 
crazy.  So, even byte sized chunks may be bigger than you expect.






On 14/12/18 8:07 pm, Finbar Mahon wrote:

No Michael, thank you for the comprehensive answer.

Like many others I suspect, Summer goes by quickly (in the Northern 
Hemisphere) and doing the accounts falls by the wayside :-)


I am catching up and discovered that the reconciliation had strange 
balances (negative) in the reconciliation of one particular account. 
So, what I wanted to do was go back to the last 'good' reconciliation 
that I had on the printed bank statements for that a/c and work 
forward to discover where things had gone wrong. I suspect a date 
anomaly, an entry on the wrong date, maybe even the wrong year, 
finger problems :-)


So, the ideas on this thread indicate the way to do it is to ensure 
the balance at the end of a good reconciliation is coincident with 
the bank statement and look to see what income/expenditures are 
listed in the attempt to reconcile after that date and may be wrong.


I haven't tried that (coming up to festivites, other priorities) but 
I'll report here on the outcome. :-)




On 13/12/2018 23:57, Michael Hendry wrote:


On 13 Dec 2018, at 17:13, Finbar Mahon  wrote:

Thanks, Michael, I have been trying that using end March of this 
year as the last 'OK' date but doing it up to latest balance seems 
to catch other errors, so I  was wondering if I could 'stage' the 
process.


Looks like D's reply indicates I could do it by varying the closing 
balance to coincide with one I am happy with. Maybe a slight 
problem if the closing balance is duplicated elsewhere? Maybe 
unlikely.


In fact by a combination of the two replies I can go back to the 
last 'good' situation and use the closing balance there as a 
starting point?


I'll give the ending balance a try.

F


I’m not sure what you mean by “the ending balance” here.

Let’s consider a simple situation: you have one bank account - what 
we in the UK call a “current account”.


For this example, consider that your financial year starts on the 
1st January 2018, and you have a bank statement for the period 
ending 31 December 2017. This will have a figure (say £x) for the 
balance on 31 December 2017.


When you create this bank account in GnuCash, you set it up with a 
starting balance of £x.


Throughout January and into February you enter every transaction 
that involves that account (payments into the account of cash and 
cheques, withdrawals in cash, by cheque, direct debit, and so on).


When your statement arrives for the month ending 31st January, go 
ahead with the reconciliation. Because there are sometimes delays in 
transactions hitting the bank account, Gnucash will have the correct 
starting balance, but may have calculated the ending balance for the 
month incorrectly - let’s say you issued a cheque on 28th January 
and the recipient hasn’t paid it into his bank account yet. You 
should enter the bank’s version of the final balance for January 
into the “Reconcile information” in the box marked “Ending Balance”.


Now press OK, and work your way through the reconciliation 
procedure, ticking the box against each transaction on the screen 
that matches one on the bank statement, which you should mark as 
reconciled in pencil.


Once you have ticked all the transactions on the statement you 
should have a “Difference” at the bottom right of the Reconcile 
window of £0.00.


If there is a discrepancy (i.e. “Difference” is non-zero), you have 
a problem which you need to resolve NOW, because in my experience 
banks and computers can add or subtract quite accurately, and you’ve 
just ticked the computer’s and the bank’s versions of the same 
transactions and they don’t match!


Occasionally, you’ll discover that there’s a missing transaction in 
your records, leaving an unticked transaction in the bank statement. 
This could be a fraudulent transaction, but is more likely to be a 
standing order you’d forgotten to enter.


Unless your bank account has very little in the way of transactions, 
you’ll almost certainly have several transactions recorded in GC 
which haven’t been ticked - like the unpresented cheque.


Once you’ve cleaned up the 

Re: [GNC] gnucash 3.x crash on startup windows 10

2018-12-14 Thread Florian
I have the same problem and isntalled gdb with chocolatey (3rd party Windows
package manager).

Unfortunately, gdb says no stack found. The complete output is as follows:

PS C:\Program Files (x86)\gnucash\bin> gdb gnucash.exe
GNU gdb (GDB) 8.1
Copyright (C) 2018 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later

This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.  Type "show copying"
and "show warranty" for details.
This GDB was configured as "x86_64-w64-mingw32".
Type "show configuration" for configuration details.
For bug reporting instructions, please see:
.
Find the GDB manual and other documentation resources online at:
.
For help, type "help".
Type "apropos word" to search for commands related to "word"...
Reading symbols from gnucash.exe...done.
(gdb) run
Starting program: C:\Program Files (x86)\gnucash\bin\gnucash.exe
[New Thread 4540.0x191c]
warning: `C:\WINDOWS\SYSTEM32\ntdll.dll': Shared library architecture
i386:x86-64 is not compatible with target architecture i386.
warning: `C:\WINDOWS\System32\wow64.dll': Shared library architecture
i386:x86-64 is not compatible with target architecture i386.
warning: `C:\WINDOWS\System32\wow64win.dll': Shared library architecture
i386:x86-64 is not compatible with target architecture i386.
warning: `C:\WINDOWS\System32\wow64cpu.dll': Shared library architecture
i386:x86-64 is not compatible with target architecture i386.
[New Thread 4540.0x1a40]
[New Thread 4540.0x1d30]
[New Thread 4540.0x17d0]
[New Thread 4540.0x2368]
[New Thread 4540.0x1f98]
[New Thread 4540.0x21a8]
[New Thread 4540.0x1fc0]
[Thread 4540.0x1f98 exited with code 1]
[Thread 4540.0x21a8 exited with code 1]
[Thread 4540.0x2368 exited with code 1]
[Thread 4540.0x1d30 exited with code 1]
[Thread 4540.0x17d0 exited with code 1]
[Thread 4540.0x1a40 exited with code 1]
[Thread 4540.0x1fc0 exited with code 1]
[Inferior 1 (process 4540) exited with code 01]
(gdb) bt
No stack.
(gdb)




--
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] Reconciling different periods?

2018-12-14 Thread elvis

Bite sized chunks, bite sized chunks.


Sometimes I get a few months and hundreds of transactions behind. I'll 
go a few days at a time to get started then weeks. Trying to remember 
what you did 3 months ago is hard! :-) But finding an error in 5 
transactions is easy, finding it in 500 is hard.


Remember, you are never alone. There's you and the future-you trying to 
figure out what you did just now.





On 14/12/18 8:07 pm, Finbar Mahon wrote:

No Michael, thank you for the comprehensive answer.

Like many others I suspect, Summer goes by quickly (in the Northern 
Hemisphere) and doing the accounts falls by the wayside :-)


I am catching up and discovered that the reconciliation had strange 
balances (negative) in the reconciliation of one particular account. 
So, what I wanted to do was go back to the last 'good' reconciliation 
that I had on the printed bank statements for that a/c and work 
forward to discover where things had gone wrong. I suspect a date 
anomaly, an entry on the wrong date, maybe even the wrong year, finger 
problems :-)


So, the ideas on this thread indicate the way to do it is to ensure 
the balance at the end of a good reconciliation is coincident with the 
bank statement and look to see what income/expenditures are listed in 
the attempt to reconcile after that date and may be wrong.


I haven't tried that (coming up to festivites, other priorities) but 
I'll report here on the outcome. :-)




On 13/12/2018 23:57, Michael Hendry wrote:


On 13 Dec 2018, at 17:13, Finbar Mahon  wrote:

Thanks, Michael, I have been trying that using end March of this 
year as the last 'OK' date but doing it up to latest balance seems 
to catch other errors, so I  was wondering if  I could 'stage' the 
process.


Looks like D's reply indicates I could do it by varying the closing 
balance to coincide with one I am happy with. Maybe a slight problem 
if the closing balance is duplicated elsewhere? Maybe unlikely.


In fact by a combination of the two replies I can go back to the 
last 'good' situation and use the closing balance there as a 
starting point?


I'll give the ending balance a try.

F


I’m not sure what you mean by “the ending balance” here.

Let’s consider a simple situation: you have one bank account - what 
we in the UK call a “current account”.


For this example, consider that your financial year starts on the 1st 
January 2018, and you have a bank statement for the period ending 31 
December 2017. This will have a figure (say £x) for the balance on 31 
December 2017.


When you create this bank account in GnuCash, you set it up with a 
starting balance of £x.


Throughout January and into February you enter every transaction that 
involves that account (payments into the account of cash and cheques, 
withdrawals in cash, by cheque, direct debit, and so on).


When your statement arrives for the month ending 31st January, go 
ahead with the reconciliation. Because there are sometimes delays in 
transactions hitting the bank account, Gnucash will have the correct 
starting balance, but may have calculated the ending balance for the 
month incorrectly - let’s say you issued a cheque on 28th January and 
the recipient hasn’t paid it into his bank account yet. You should 
enter the bank’s version of the final balance for January into the 
“Reconcile information” in the box marked “Ending Balance”.


Now press OK, and work your way through the reconciliation procedure, 
ticking the box against each transaction on the screen that matches 
one on the bank statement, which you should mark as reconciled in 
pencil.


Once you have ticked all the transactions on the statement you should 
have a “Difference” at the bottom right of the Reconcile window of 
£0.00.


If there is a discrepancy (i.e. “Difference” is non-zero), you have a 
problem which you need to resolve NOW, because in my experience banks 
and computers can add or subtract quite accurately, and you’ve just 
ticked the computer’s and the bank’s versions of the same 
transactions and they don’t match!


Occasionally, you’ll discover that there’s a missing transaction in 
your records, leaving an unticked transaction in the bank statement. 
This could be a fraudulent transaction, but is more likely to be a 
standing order you’d forgotten to enter.


Unless your bank account has very little in the way of transactions, 
you’ll almost certainly have several transactions recorded in GC 
which haven’t been ticked - like the unpresented cheque.


Once you’ve cleaned up the reconciliation for January, wait for the 
February bank statement and reconcile that with GC.


If you’re catching up on reconciliation a month or two late, don’t 
rush it! Complete one reconciliation by correcting any errors before 
you move on to the next one.


Pardon me if I have misjudged your situation and made you feel you’re 
being patronised,


Michael








___
gnucash-user mailing list

Re: [GNC] how to track Future and Options

2018-12-14 Thread John Ralls


> On Dec 14, 2018, at 10:51 AM, Christian Pinedo Zamalloa 
>  wrote:
> 
> Hi,
> 
> I would like your experience to track Futures and Options with gnucash.
> - Any special account to use? It is not a mutual fund, stock...
> - Advice?
> 
> In the case of Futures which I am more interested in we could have an
> "active" or "bank" account:
> - day 0: ingress of the guarantee, i.e., 1000 €
> - day 1: earnings or loss 1st day, i.e., -100 €
> - day 2: earnings or loss 2nd day, i.e., +123 €
> - ...
> - final day: earnings or loss last day, i.e., +50 €
> 
> I am sure if the advanced portfolio report would include this account...
> 

As far as GnuCash is concerned an option is a stock. You need to learn the 
rules in your jurisdiction about whether individual investors are required to 
"mark to market"; they generally aren't. If you're not required to, then for 
accounting purposes there are only two events with an option: Buying and 
selling; expiration of an unexercised option is a sale at 0, one loses one's 
whole investment. If you are required to mark-to-market then you probably want 
a more sophisticated accounting program than GnuCash; in GnuCash you'd have to 
manually post the gain or loss daily, and no, I don't think the APR knows how 
to deal with mark-to-market transactions. 

You also need to learn the rules for when you exercise an option: In the US you 
add the cost of the option to the basis for the purchased stock for a call or 
deduct it from the proceeds for a put. If you're the one writing the option 
then it's the other way around.

Futures are just options for tangible goods or currency, same rules.

Regards,
John Ralls


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

[GNC] how to track Future and Options

2018-12-14 Thread Christian Pinedo Zamalloa
Hi,

I would like your experience to track Futures and Options with gnucash.
- Any special account to use? It is not a mutual fund, stock...
- Advice?

In the case of Futures which I am more interested in we could have an
"active" or "bank" account:
- day 0: ingress of the guarantee, i.e., 1000 €
- day 1: earnings or loss 1st day, i.e., -100 €
- day 2: earnings or loss 2nd day, i.e., +123 €
- ...
- final day: earnings or loss last day, i.e., +50 €

I am sure if the advanced portfolio report would include this account...

Thanks,

-- 
Christian
___
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 do you print the check register?

2018-12-14 Thread David Carlson
Chris,

By Check Register do you mean a list of transactions in one ban account?
To do that, open the Account window for that bank account, Click on View >
Filter By..., choose the date range that you want to print out, then choose
Reports > Account Report, and print it out.  Note that you may see lines
split at the bottom of the pages.  If  you do, try Exporting the report as
HTML and using a web browser to print it.

David C

On Fri, Dec 14, 2018 at 10:37 AM Chris Tsuji  wrote:

>
>
> Hi
> I have to print the check register for an financial review.
> How do I do it?
> Thanks in advance.
> Chris Tsuji
>
> ___
> 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 do you print the check register?

2018-12-14 Thread Chris Tsuji


Hi
I have to print the check register for an financial review.
How do I do it?
Thanks in advance.
Chris Tsuji
 
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Account Balance Changes When View Filter Is Applied

2018-12-14 Thread John Ralls



> On Dec 13, 2018, at 7:00 AM, John Diaz  wrote:
> 
> When I apply the filter to hid the reconciled transactions, the balance shown 
> on the account ledger changes.  The correct balance shows on the 'Accounts' 
> tab.  Just noticed this behavior after reconciling my checkbook this morning.
> 

You mean the balance in the summary bar at the bottom of the register page, 
right? What version of GnuCash are you using?

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] Reconciling different periods?

2018-12-14 Thread Finbar Mahon

No Michael, thank you for the comprehensive answer.

Like many others I suspect, Summer goes by quickly (in the Northern 
Hemisphere) and doing the accounts falls by the wayside :-)


I am catching up and discovered that the reconciliation had strange 
balances (negative) in the reconciliation of one particular account. So, 
what I wanted to do was go back to the last 'good' reconciliation that I 
had on the printed bank statements for that a/c and work forward to 
discover where things had gone wrong. I suspect a date anomaly, an entry 
on the wrong date, maybe even the wrong year, finger problems :-)


So, the ideas on this thread indicate the way to do it is to ensure the 
balance at the end of a good reconciliation is coincident with the bank 
statement and look to see what income/expenditures are listed in the 
attempt to reconcile after that date and may be wrong.


I haven't tried that (coming up to festivites, other priorities) but 
I'll report here on the outcome. :-)




On 13/12/2018 23:57, Michael Hendry wrote:


On 13 Dec 2018, at 17:13, Finbar Mahon  wrote:

Thanks, Michael, I have been trying that using end March of this year as the 
last 'OK' date but doing it up to latest balance seems to catch other errors, 
so I  was wondering if  I could 'stage' the process.

Looks like D's reply indicates I could do it by varying the closing balance to 
coincide with one I am happy with. Maybe a slight problem if the closing 
balance is duplicated elsewhere? Maybe unlikely.

In fact by a combination of the two replies I can go back to the last 'good' 
situation and use the closing balance there as a starting point?

I'll give the ending balance a try.

F


I’m not sure what you mean by “the ending balance” here.

Let’s consider a simple situation: you have one bank account - what we in the 
UK call a “current account”.

For this example, consider that your financial year starts on the 1st January 
2018, and you have a bank statement for the period ending 31 December 2017. 
This will have a figure (say £x) for the balance on 31 December 2017.

When you create this bank account in GnuCash, you set it up with a starting 
balance of £x.

Throughout January and into February you enter every transaction that involves 
that account (payments into the account of cash and cheques, withdrawals in 
cash, by cheque, direct debit, and so on).

When your statement arrives for the month ending 31st January, go ahead with 
the reconciliation. Because there are sometimes delays in transactions hitting 
the bank account, Gnucash will have the correct starting balance, but may have 
calculated the ending balance for the month incorrectly - let’s say you issued 
a cheque on 28th January and the recipient hasn’t paid it into his bank account 
yet. You should enter the bank’s version of the final balance for January into 
the “Reconcile information” in the box marked “Ending Balance”.

Now press OK, and work your way through the reconciliation procedure, ticking 
the box against each transaction on the screen that matches one on the bank 
statement, which you should mark as reconciled in pencil.

Once you have ticked all the transactions on the statement you should have a 
“Difference” at the bottom right of the Reconcile window of £0.00.

If there is a discrepancy (i.e. “Difference” is non-zero), you have a problem 
which you need to resolve NOW, because in my experience banks and computers can 
add or subtract quite accurately, and you’ve just ticked the computer’s and the 
bank’s versions of the same transactions and they don’t match!

Occasionally, you’ll discover that there’s a missing transaction in your 
records, leaving an unticked transaction in the bank statement. This could be a 
fraudulent transaction, but is more likely to be a standing order you’d 
forgotten to enter.

Unless your bank account has very little in the way of transactions, you’ll 
almost certainly have several transactions recorded in GC which haven’t been 
ticked - like the unpresented cheque.

Once you’ve cleaned up the reconciliation for January, wait for the February 
bank statement and reconcile that with GC.

If you’re catching up on reconciliation a month or two late, don’t rush it! 
Complete one reconciliation by correcting any errors before you move on to the 
next one.

Pardon me if I have misjudged your situation and made you feel you’re being 
patronised,

Michael








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