RE: budgeting is very slow

[Dave & Tracy E via gnucash-user]

Wow.  That’s too bad.

 

Every entry and change on the budget takes about 30 seconds.

 

Dave

 

From: Christopher Lam [mailto:christopher@gmail.com] 
Sent: Tuesday, December 12, 2017 12:50 PM
To: Dave & Tracy E 
Cc: gnucash-user@gnucash.org
Subject: Re: budgeting is very slow

 

This is nothing to do with your hardware, it's a known issue with budgeting on 
windows and so far no one has been able to diagnose why.

 

On 12 Dec 2017 11:56 AM, "Dave & Tracy E via gnucash-user" 
 > wrote:

Hi.



* The budgeting window on GnuCash 2.6.18 is extremely slow. Every step takes
several seconds. It's quite frustrating to add numbers to it or makes
adjustments.



* I have 12 months in my budget. The last two budgets always extend off the
screen to the right.  I can't view all the months plus TOTALS on the same
screen. I try to drag the first column to the left but it moves only 2 mm's.
How do I format the screen so I can see all of it at once.  It neither fits
on my 14 inch laptop screen not on my external monitor which is quite wide.



I wish the budgeting worked better.



Dave



ThinkPad T430s is about 4.5 years old

Windows 10

Processor i5-3320M CPU @ 2.60GHz, 2601 Mhz, 2 Core(s), 4 Logical
Processor(s)

Installed Physical Memory (RAM) 16.0 GB

Available Physical Memory  8.81 GB

___
gnucash-user mailing list
gnucash-user@gnucash.org  
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: budgeting is very slow

[Christopher Lam]

This is nothing to do with your hardware, it's a known issue with budgeting
on windows and so far no one has been able to diagnose why.

On 12 Dec 2017 11:56 AM, "Dave & Tracy E via gnucash-user" <
gnucash-user@gnucash.org> wrote:

> Hi.
>
>
>
> * The budgeting window on GnuCash 2.6.18 is extremely slow. Every step
> takes
> several seconds. It's quite frustrating to add numbers to it or makes
> adjustments.
>
>
>
> * I have 12 months in my budget. The last two budgets always extend off the
> screen to the right.  I can't view all the months plus TOTALS on the same
> screen. I try to drag the first column to the left but it moves only 2
> mm's.
> How do I format the screen so I can see all of it at once.  It neither fits
> on my 14 inch laptop screen not on my external monitor which is quite wide.
>
>
>
> I wish the budgeting worked better.
>
>
>
> Dave
>
>
>
> ThinkPad T430s is about 4.5 years old
>
> Windows 10
>
> Processor i5-3320M CPU @ 2.60GHz, 2601 Mhz, 2 Core(s), 4 Logical
> Processor(s)
>
> Installed Physical Memory (RAM) 16.0 GB
>
> Available Physical Memory  8.81 GB
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: GnuCash: Docs: Where to document?

[John Ralls]

> On Dec 11, 2017, at 4:41 PM, Charles Sliger  wrote:
> 
> 
> On Mon, 2017-12-11 at 16:01 -0800, John Ralls wrote:
>> 
>>> On Dec 11, 2017, at 2:27 PM, Charles Sliger  wrote:
>>> 
>>> I'm starting to migrate from QuickBooks to GnuCash.
>>> I'm working my way through the integration issues with
>>> Gnucash - Python - Postgresql
>>> How would the GnuCash team prefer that I document this for the benefit
>>> of others?
>>> 
>>> I've got about 30 years of unix/database/network systems engineering
>>> under my belt and without that to draw on I don't think I would be able
>>> to work my way through this as the documentation seems rather sparse and
>>> fractured.
>>> 
>>> I'll have to document it for my own purposes anyway so let me know if
>>> there's interest.
>>> 
>> Chaz,
>> 
>> Can you outline what you propose to document? Integration with QuickBooks 
>> doesn’t really make sense to me and SQL servers have plenty of documentation 
>> themselves as well as hundreds of books and websites teaching how to 
>> administer them. Repeating any of that in our documentation would be 
>> pointless.
>> 
>> Regards,
>> John Ralls
>> 
>> 
> John,
> What I will be documenting is the actual nuts and bolts process for
> using GnuCash, Python, and Postgresql together.  Integration is probably
> too strong a word right now but I see these three as being very
> complementary.  While it might be true that all of the information is
> out there somewhere, I have had to make a number of educated guesses in
> the process of just getting GnuCash and Postgresql working together.
> This was after purchasing and reading all three books on GnuCash and
> spending a good deal of time with on-line research.  Most people are not
> going to have the time to become dba's in order to reap the benefits of
> an RDBMS such as Postgresql.  I find they can benefit from having the
> documentation for something like this pulled together in a single
> narrative.  Given that the average PC today can easily handle running a
> combination like this, it seems natural to leverage the capabilities of
> a database like Postgresql.
> S...  I just thought I'd ask if there was a place put this kind of
> information and a process for getting it there.

It seems to me that your personal blog might be a good place to document the 
“process”. I think that anything involving coding is not of major interest to 
99 and 44/100% of our user base. That’s not to say that you can’t write useful 
articles about it for the wiki, but the wiki’s general style is more 
descriptive than narrative. 

As for most people not having the time to learn to be DBAs, I agree. What I 
disagree about is that they should set up a DB server anyway. With your 30 
years of experience you might think that maintaining a DB server and ensuring 
that it’s secure and that the data is properly backed up is trivial, but for 
nearly all users that’s far from being the case. If it’s possible to write “How 
to be a competent DBA in 30 minutes” then there are a dozen books and 100+ 
websites out there already. I haven’t found them and I don’t think it’s 
possible, but if I’m wrong then far better to put some pointers in the wiki 
than to create the 137th version.

It is possible, even simple, to enjoy the benefits of SQL without messing 
around with being a server DBA. SQLite3 creates a very usable SQL database in a 
single file that can be easily copied for backup, no administration 
required--in fact, nothing much to administer.

One more point: You perhaps misunderstand how GnuCash uses the database 
backends. It is not (yet, nor will it be in 2.8) a database application. It 
uses the database as a data store, reading the whole thing into memory at the 
beginning of the session. After that the only queries are updates and inserts.

To answer your final question, the place in the GnuCash infrastructure to put 
it would be the wiki, https://wiki.gnucash.org/wiki 
. Thanks to spammers we have had to insert human 
approval into the account creation process. Just say something about what you 
want to write so that we know that you’re not a spam-bot or someone who thinks 
they need a wiki account to use the program and your request will be quickly 
approved. After that there’s a one-week waiting period for your account to be 
blessed for editing. There might be an issue about creating pages after that; 
if you have a problem best to bring it up on IRC 
(https://wiki.gnucash.org/wiki/IRC ).

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Accounts using mySQL stuck in Read-only mode

[Graham Reeves]

I have been using Gnucash with mySQL for about as long as such things 
were possible on both Windows and Ubuntu clients to a mySQL server 
running on a Ubuntu server.
Occasionally the connection between the client and mySQL server would be 
lost. This was a nuisance but not a great problem. All that was needed 
was to close down the client. The connection would be re-established 
when Gnucash was relaunched.


Recently however the connection appeared to be re-established but no 
changes could be saved. An error message 'Unable to save to database' 
was given. That was on a Windows laptop. We then tried to access the 
same set of accounts on a Xubuntu machine. This worked for a couple of 
weeks but then suffered the same problem.


Throughout this time I could still access the accounts from other 
Windows and Xubuntu machines but I feared the malaise would spread.


I managed to recover the use of the Windows laptop by uninstalling 
Gnucash, deleting the .gnucash folder, and reinstalling.


I tried to completely remove Gnucash from the Xubuntu client machine 
using the --purge flag, deleting the .gnucash folder and cleaning gconf 
using ' gconftool-2 --recursive-unset /apps/gnucash ' but I must have 
missed something. When I reinstalled and ran Gnucash it went straight 
into loading the last used accounts and would still not save changes.


The question is, what have I missed?

In still have access to these accounts from another Windows machine and 
another Xubuntu machine so that suggests the database is OK. I run two 
other sets of accounts, one with mySQL and the other with SQLite. Both 
mySQL accounts are affected, the SQLite accounts are not.


Any help would be appreciated.

Graham Reeves

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

budgeting is very slow

[Dave & Tracy E via gnucash-user]

Hi.

 

* The budgeting window on GnuCash 2.6.18 is extremely slow. Every step takes
several seconds. It's quite frustrating to add numbers to it or makes
adjustments.

 

* I have 12 months in my budget. The last two budgets always extend off the
screen to the right.  I can't view all the months plus TOTALS on the same
screen. I try to drag the first column to the left but it moves only 2 mm's.
How do I format the screen so I can see all of it at once.  It neither fits
on my 14 inch laptop screen not on my external monitor which is quite wide.

 

I wish the budgeting worked better.

 

Dave

 

ThinkPad T430s is about 4.5 years old

Windows 10

Processor i5-3320M CPU @ 2.60GHz, 2601 Mhz, 2 Core(s), 4 Logical
Processor(s)

Installed Physical Memory (RAM) 16.0 GB

Available Physical Memory  8.81 GB

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: GnuCash: Docs: Where to document?

[David T. via gnucash-user]

Chaz,
Seems like that sort of write up might go on the wiki. I'll note that neither 
python nor the sql aspects of gnucash are consistently available to the average 
user, so your write up may have limited utility.
Python is only available to Mac users if they compile gnucash themselves, for 
example.
The sql back ends require similar additional installation. On top of that, the 
sql functionality does not match most users' expectations, especially with 
regard to multi user access. The structures for gnucash data are not 
normalized, either. 
These issues have been discussed in the lists at length, but a write up on the 
wiki might help. 
David

 
 
  On Tue, Dec 12, 2017 at 5:42, Charles Sliger wrote:   
On Mon, 2017-12-11 at 16:01 -0800, John Ralls wrote:
> 
> > On Dec 11, 2017, at 2:27 PM, Charles Sliger  wrote:
> > 
> > I'm starting to migrate from QuickBooks to GnuCash.
> > I'm working my way through the integration issues with
> > Gnucash - Python - Postgresql
> > How would the GnuCash team prefer that I document this for the benefit
> > of others?
> > 
> > I've got about 30 years of unix/database/network systems engineering
> > under my belt and without that to draw on I don't think I would be able
> > to work my way through this as the documentation seems rather sparse and
> > fractured.
> > 
> > I'll have to document it for my own purposes anyway so let me know if
> > there's interest.
> > 
> Chaz,
> 
> Can you outline what you propose to document? Integration with QuickBooks 
> doesn’t really make sense to me and SQL servers have plenty of documentation 
> themselves as well as hundreds of books and websites teaching how to 
> administer them. Repeating any of that in our documentation would be 
> pointless.
> 
> Regards,
> John Ralls
> 
> 
John,
What I will be documenting is the actual nuts and bolts process for
using GnuCash, Python, and Postgresql together.  Integration is probably
too strong a word right now but I see these three as being very
complementary.  While it might be true that all of the information is
out there somewhere, I have had to make a number of educated guesses in
the process of just getting GnuCash and Postgresql working together.
This was after purchasing and reading all three books on GnuCash and
spending a good deal of time with on-line research.  Most people are not
going to have the time to become dba's in order to reap the benefits of
an RDBMS such as Postgresql.  I find they can benefit from having the
documentation for something like this pulled together in a single
narrative.  Given that the average PC today can easily handle running a
combination like this, it seems natural to leverage the capabilities of
a database like Postgresql.
S...  I just thought I'd ask if there was a place put this kind of
information and a process for getting it there.

Regards,
-- 
-chaz
Charles Sliger
"No matter where you go... There you are... Buckaroo Banzai"


___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Cannot edit opening balance

[DaveC49]

My bad John, 

I replied to the wrong post.  

David



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: GnuCash: Docs: Where to document?

[Charles Sliger]

On Mon, 2017-12-11 at 16:01 -0800, John Ralls wrote:
> 
> > On Dec 11, 2017, at 2:27 PM, Charles Sliger  wrote:
> > 
> > I'm starting to migrate from QuickBooks to GnuCash.
> > I'm working my way through the integration issues with
> > Gnucash - Python - Postgresql
> > How would the GnuCash team prefer that I document this for the benefit
> > of others?
> > 
> > I've got about 30 years of unix/database/network systems engineering
> > under my belt and without that to draw on I don't think I would be able
> > to work my way through this as the documentation seems rather sparse and
> > fractured.
> > 
> > I'll have to document it for my own purposes anyway so let me know if
> > there's interest.
> > 
> Chaz,
> 
> Can you outline what you propose to document? Integration with QuickBooks 
> doesn’t really make sense to me and SQL servers have plenty of documentation 
> themselves as well as hundreds of books and websites teaching how to 
> administer them. Repeating any of that in our documentation would be 
> pointless.
> 
> Regards,
> John Ralls
> 
> 
John,
What I will be documenting is the actual nuts and bolts process for
using GnuCash, Python, and Postgresql together.  Integration is probably
too strong a word right now but I see these three as being very
complementary.  While it might be true that all of the information is
out there somewhere, I have had to make a number of educated guesses in
the process of just getting GnuCash and Postgresql working together.
This was after purchasing and reading all three books on GnuCash and
spending a good deal of time with on-line research.  Most people are not
going to have the time to become dba's in order to reap the benefits of
an RDBMS such as Postgresql.  I find they can benefit from having the
documentation for something like this pulled together in a single
narrative.  Given that the average PC today can easily handle running a
combination like this, it seems natural to leverage the capabilities of
a database like Postgresql.
S...  I just thought I'd ask if there was a place put this kind of
information and a process for getting it there.

Regards,
-- 
-chaz
Charles Sliger
"No matter where you go... There you are... Buckaroo Banzai"


___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: GnuCash: Docs: Where to document?

[John Ralls]

> On Dec 11, 2017, at 2:27 PM, Charles Sliger  wrote:
> 
> I'm starting to migrate from QuickBooks to GnuCash.
> I'm working my way through the integration issues with
> Gnucash - Python - Postgresql
> How would the GnuCash team prefer that I document this for the benefit
> of others?
> 
> I've got about 30 years of unix/database/network systems engineering
> under my belt and without that to draw on I don't think I would be able
> to work my way through this as the documentation seems rather sparse and
> fractured.
> 
> I'll have to document it for my own purposes anyway so let me know if
> there's interest.
> 
Chaz,

Can you outline what you propose to document? Integration with QuickBooks 
doesn’t really make sense to me and SQL servers have plenty of documentation 
themselves as well as hundreds of books and websites teaching how to administer 
them. Repeating any of that in our documentation would be pointless.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Cannot edit opening balance

[John Ralls]

> On Dec 11, 2017, at 2:51 PM, DaveC49  wrote:
> 
> John,
> 
> That is exactly what the Opening Balance dialog actually does in Gnucash (it
> creates those entries) and once the entries have been created they are
> easily edited either from the Opening Balances register or from the register
> for the account for which you set the opening balance,  just as you can edit
> any other transaction. 

Yes, Dave, I know. But the OP said that he didn’t use the Opening Balance tab 
of the new account dialog, he created an Opening Balance transaction by hand 
afterwards. Since he didn’t use the dialog it’s possible he made a mistake and 
I instructed him how he might check for one and repair it if he needs to.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Cannot edit opening balance

[DaveC49]

John,

That is exactly what the Opening Balance dialog actually does in Gnucash (it
creates those entries) and once the entries have been created they are
easily edited either from the Opening Balances register or from the register
for the account for which you set the opening balance,  just as you can edit
any other transaction. 

David



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Cannot edit opening balance

[Adrien Monteleone]

Not true at all.

You can edit it to your hearts content. I have on several occasions.

If you’ve reconciled it though, you’ll get a warning asking if you are sure you 
want to change it, and of course, doing so might throw off a reconciliation.

There’s nothing special about the opening balance entry when starting GnuCash 
for the first time. It’s just an entry between a particular account and an 
account called Equity:Opening Balances.

Regards,
Adrien

> On Dec 10, 2017, at 11:48 PM, John R. Sowden  
> wrote:
> 
> My suggestion is to never use the opening balance in an accounting system.  
> Instead, I create a series of General Journal entries, each with about 5-6 
> transaction pairs, to cover all of the asset, liability and equity accounts.  
> Works well.  I have learned over the decades that the programmer does not 
> want the user to edit the beginning balance once it is entered.
> 
> John
> 
> 
> 
> On 12/10/2017 02:01 PM, Carmelo Pagán wrote:
>> Hello All,
>> 
>>  
>> I’ve been trying to reconcile my Checking account, but I’m running into a
>> problem.  The reconcile window displays a negative amount as the opening
>> balance. I didn’t enter an opening balance when  creating the account. After
>> obtaining my bank’s statement and gathering the open balance as stated. I
>> went to enter an opening balance in the” Equity:Opening Balances” account
>> and it accepted the entry just fine. I then checked the opening balance in
>> my checking account and it displayed the opening balance as I entered in the
>> equity account.  When I go to reconcile the Checking account, the reconcile
>> window displays my opening balance as a different amount than the one I
>> entered, and there is no option (that I can find, and yes I did RTFM)to
>> alter the opening Balance.
>> 
>>  
>> Why doesn’t a user have the option to correct an opening balance in the
>> reconcile window? This issues messes up every reconcile operation that
>> follows. I hope you (the community) can help
>> 
>>  
>> OS: Windows10
>> 
>> GC version: 2.6.18
>> 
>> Build: git rev 3a9fbb8+ on 2017-10-08
>> 
>>  
>> Sincerely,
>> 
>> Carmelo Pagan
>> 
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> 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
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

mac os high sierra issues

[Pam Dooner]

Hi. I just upgraded to High Sierra and while gnucash opens and is usable,
trying to open the scheduled transaction editor crashes the editor and
gnush has to be force-quit. I get a parsing error on opening if there are
any scheduled transactions run since last opened so I wanted to edit the
transactions as the program no longer accepts the full stop as a decimal
separator since my locale is in euros. I then thought I'd just create new
scheduled transactions but that crashes too. After the parsing error
message the program opens but the amount of the entry is blank and it keeps
repeating this each time I open the program. It means I have to enter each
of my scheduled transactions manually, which is a bit of pain to say the
least, since I have 2 separate bank accounts! Any solution, workaround?

*Pam Dooner*
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: What does "Update and Reconcile" update?

[D via gnucash-user]

U+R "updates and reconciles" the information in the transaction with the 
information in the OFX entry. If you like your information ( like the 
description), then choose R only. I usually prefer the latter.

David

On December 10, 2017, at 9:57 PM, Donald Pellegrino 
 wrote:

When importing transactions, the "Generic import transaction matcher"
dialog provides "A," "U+R," and "R" columns. These columns each contain
check-marks but are mutually exclusive in their selection. It is not clear
to me which fields of the transaction will be changed, and in which ways,
when "U+R" (Update and Reconcile) is selected instead of just "R"
(Reconcile).

For reference, I found an old post discussing the topic at
https://lists.gnucash.org/pipermail/gnucash-user/2011-November/042039.html.
However, I was unable to find a definitive documentation of the full
process. As with the author of that old post, I am nervous to lose the
Description content that I have entered.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Cannot edit opening balance

[John Ralls]

> On Dec 10, 2017, at 10:17 PM, Carmelo Pagán  wrote:
> 
> I tried the suggestion to no avail.  So if I understand this correctly, there 
> no remedy to recover from user error in the Reconcile function Hm  
> Machine restricts user.  Something out of whack with that IMHO.  Humans are 
> imperfect and will make mistakes.  Shouldn't the software be robust enough to 
> handle something like this?

Errors can be fixed, though generally not in the reconcile window. It isn’t 
modal: You can switch back-and-forth between it and the register and any 
changes you make in the register will be reflected in the reconcile window.

If you’ve reconciled transactions in error just unreconcile them in the 
register. It’s the single-letter column between transfer account and deposit; 
it has three values, ’n’ for “no”, ‘c’ for “cleared”, and ‘y’ for “yes”, 
meaning reconciled. Just click on all of the ones marked ‘y’. GnuCash will ask 
if you’re sure. You can speed it up a bit by checking the “don’t ask again this 
session” box.

The next thing to check is that all of your transactions are in the right 
direction and that the dates are correct; in particular the opening balance 
transaction should be the earliest one.

If you’re still stuck you’ll need to provide more information, perhaps a screen 
shot or two showing the register and the reconcile window. If you’re paranoid 
you can fuzz out transaction descriptions and transfer accounts, but do leave 
the other columns visible.

Regards,
John Ralls

> 
> -Original Message-
> From: gnucash-user 
> [mailto:gnucash-user-bounces+c.pagan=sbcglobal@gnucash.org] On Behalf Of 
> Carmelo Pagan
> Sent: Monday, December 11, 2017 12:43 AM
> To: John Ralls 
> Cc: gnucash-user@gnucash.org
> Subject: Re: Cannot edit opening balance
> 
> Thank you Mr. Ralls. I will give it a try
> 
> Sincerely ,
> Carmelo Pagán 
> 
>> On Dec 10, 2017, at 6:02 PM, John Ralls  wrote:
>> 
>> 
>> 
>>> On Dec 10, 2017, at 2:01 PM, Carmelo Pagán  wrote:
>>> 
>>> Hello All,
>>> 
>>> 
>>> 
>>> I’ve been trying to reconcile my Checking account, but I’m running 
>>> into a problem.  The reconcile window displays a negative amount as 
>>> the opening balance. I didn’t enter an opening balance when  creating 
>>> the account. After obtaining my bank’s statement and gathering the 
>>> open balance as stated. I went to enter an opening balance in the” 
>>> Equity:Opening Balances” account and it accepted the entry just fine. 
>>> I then checked the opening balance in my checking account and it 
>>> displayed the opening balance as I entered in the equity account.  
>>> When I go to reconcile the Checking account, the reconcile window 
>>> displays my opening balance as a different amount than the one I 
>>> entered, and there is no option (that I can find, and yes I did RTFM)to 
>>> alter the opening Balance.
>>> 
>>> 
>>> 
>>> Why doesn’t a user have the option to correct an opening balance in 
>>> the reconcile window? This issues messes up every reconcile operation 
>>> that follows. I hope you (the community) can help
>> 
>> Could you clarify what you mean? The Reconcile Window (in English, anyway) 
>> doesn't use the term "Opening Balance". It has "Starting Balance", "Ending 
>> Balance", and "Reconciled Balance". The first is the balance of reconciled 
>> transactions (including the account's opening balance *if that has been 
>> reconciled*) at the beginning of the reconcile session, the second is the 
>> balance that you entered in the little dialog box at the beginning of the 
>> process; you should have entered the ending balance from your bank statement 
>> in there, and the third starts off the same as starting balance and adjusts 
>> as you mark new transactions reconciled in the reconcile window. When it 
>> matches the ending balance the green Finished button lights up and you're 
>> done.
>> 
>> The starting balance can't be edited because it's calculated from what 
>> you've already reconciled in the account.
>> 
>> If this is your very first time reconciling this account the starting 
>> balance should be 0 as there shouldn't be any reconciled transactions yet. 
>> If it's a negative number that suggests that you might have reconciled some 
>> transactions before creating the opening balance transaction; since it's not 
>> reconciled yet it's not included in the starting balance. If that's the only 
>> problem and you reconcile it--and only it--in the reconcile window the 
>> reconciled balance should match the starting balance on your statement.
>> 
>> Regards,
>> John Ralls
>> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 

Re: Cannot edit opening balance

[Mike or Penny Novack]

On 12/11/2017 3:17 AM, David T. via gnucash-user wrote:

I would suggest reading section 4.4 of the tutorial, where the issue regarding 
handling starting balance problems is addressed directly.
David

  
I would also suggest learning how to CORRECT errors, which in formal 
accounting is not done by changing/editing existing errors.


Let me give an example. Suppose you did set up your books using 
"starting balance" << as others have pointed out, some of us would NOT 
have done that but would have manually entered the initial transactions 
with a date before the start of the first period, usually the day before >>


Dec 31, 2016
Cash on hand db$500
 Equity cr $500   (this probably part of a split 
amount if :starting balance was used --- a single entry for the total of 
all assets minus all liabilities)


Now on June 25th 2017 you discovered a jar squirreled away that had $100 
dollars in it. How do you correct the starting balance? You can enter a 
transaction with a date of Dec 31, 2016

Cash on hand db $100
  Equitycr  $100  (I don't know what equity sub 
accounts the "starting balance" might have created since I never have 
used that, but if a sub account was created, use that)
Your description for this entry would be something like "correction of 
starting balance because of money found in jar"


Michael D Novack



Michael D Novack
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

RE: entries

[Christine via gnucash-user]

Hi Adrien
Thanks so much that's sorted it

-Original Message-
From: gnucash-user 
[mailto:gnucash-user-bounces+cmaloney4=talktalk@gnucash.org] On Behalf Of 
Adrien Monteleone
Sent: 11 December 2017 03:04
To: gnucash-user@gnucash.org
Subject: Re: entries

Christine,

Following what Michael said, with the register in question, or the main account 
tree open, open GnuCash preferences. (location depends on operating system; 
Mac, look under the GnuCash menu; Linux, try either the Tools or Edit menu; 
Windows, likely the Edit menu)

Go to the Accounts tab in the preferences pop-up.

Play with the setting for “Reverse Balanced Accounts” till the display suits 
your taste. (I have mine set to ‘Credit accounts’)

It’s just a matter of what you ‘think’ should normally be negative or not. Use 
the one that works best for you. You can change it again at any time.

Note, I never enter anything as a negative. (doing so just moves it to the 
other column anyway) I keep straight whether or not in order to ‘increase’ an 
account balance, I am supposed to debit or credit it. I enter everything as a 
positive amount. The Dr & Cr columns never show as negatives for me, only the 
balances do where appropriate. (which in this case is only those accounts 
without a ‘normal’ balance.)

Regards,
Adrien

> On Dec 10, 2017, at 6:33 PM, Christine via gnucash-user 
>  wrote:
> 
> Whenever I have a DR and a CR the summary shows that although it 
> balances all the amounts are showing as negative. Does anyone know 
> what I have done wrong here as I cant work it out.
> 
> Christine
> 
> 
> 
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Cannot edit opening balance

[David T. via gnucash-user]

I would suggest reading section 4.4 of the tutorial, where the issue regarding 
handling starting balance problems is addressed directly. 
David

 
 
  On Mon, Dec 11, 2017 at 11:48, John R. Sowden 
wrote:   My suggestion is to never use the opening balance in an accounting 
system.  Instead, I create a series of General Journal entries, each 
with about 5-6 transaction pairs, to cover all of the asset, liability 
and equity accounts.  Works well.  I have learned over the decades that 
the programmer does not want the user to edit the beginning balance once 
it is entered.

John



On 12/10/2017 02:01 PM, Carmelo Pagán wrote:
> Hello All,
>
>  
>
> I’ve been trying to reconcile my Checking account, but I’m running into a
> problem.  The reconcile window displays a negative amount as the opening
> balance. I didn’t enter an opening balance when  creating the account. After
> obtaining my bank’s statement and gathering the open balance as stated. I
> went to enter an opening balance in the” Equity:Opening Balances” account
> and it accepted the entry just fine. I then checked the opening balance in
> my checking account and it displayed the opening balance as I entered in the
> equity account.  When I go to reconcile the Checking account, the reconcile
> window displays my opening balance as a different amount than the one I
> entered, and there is no option (that I can find, and yes I did RTFM)to
> alter the opening Balance.
>
>  
>
> Why doesn’t a user have the option to correct an opening balance in the
> reconcile window? This issues messes up every reconcile operation that
> follows. I hope you (the community) can help
>
>  
>
> OS: Windows10
>
> GC version: 2.6.18
>
> Build: git rev 3a9fbb8+ on 2017-10-08
>
>  
>
> Sincerely,
>
> Carmelo Pagan
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.