Re: [GNC] reconcile problem?

2022-02-27 Thread davidcousens49
When importing your checking account, if the item has already been imported as a
transaction to your credit card, then if GnuCash recognizes it the "A" column
will be unchecked and the record will not be imported and either the "U" column
will be checked  if the record being imported has additional information in
addition to that in the already imported record which will be updated with the
imported data or the "C" column will be checked which will mark the existing
record as "cleared" but otherwise will not import it. (Note: The "C" column was
labelled as "R" in older GnuCash versions).

GnuCash's automatic settings of these  3 flags should be overridden if the
matching procedure has made an incorrect decision. GnuCash gets about 80% of
these decisions right on most of my imports to my credit card. Unless the
checking account record has identifying information as to which credit card a
payment is made to, GnuCash has no way of making that decision. You will have to
do it manually. I would manually make a note of the dates, payment amounts and
the credit card they are for when I authorized the payments and then use that to
correctly assign the payments to the appropriate credit card account on import
if you can't persuade your bank to include that information.




On Sun, 2022-02-27 at 02:29 -0500, scum buster wrote:
> I understand no piece of software "thinks for you" 100% (maybe you did not
> intend it, but that comment feels condescending to me, but I
> digress)though I would argue that GC does indeed do just that in many
> ways...
> 
> I am just asking for help in dealing with this problem.problem being that
> the bank doesn’t differentiate between cards when posting the payment,
> therefore leading to GC not being able to differentiate.
> 
> How does deleting them help?  So you manually enter the payments transactions
> and also delete all the bank transactions from that bank during the import?
> 
> My concern is then you have to basically go out and double check you have them
> manually entered so they do appear.which basically I have done...
> 
> You said " when I import payments from by checking account, I allocate the
> payments to the correct card account." That is exactly what I am doing and
> where the problem arises.  I do not use the import function for the credit
> card accounts, I enter them manually in the credit card accounts.  I even use
> the same description as the bank does in my checking account"bankname
> payment".
> 
> It is when I am importing my checking account info that the issue comes
> up..there are three choices on import on what to do with the itemand
> none of them seem to do the trick.one option imports the item and ends up
> being aduplictaeanother doesn’t import it at allthe third I cant
> recall what it does but it messes up..and again I assume that is because
> GC cannot differentiate.  The SAME payment sometimes duplicates and also
> DIFFERENT payments to the same bank post to seemingly random accounts in GC
> for that bank.
> 
> Was just hoping that as powerful as GC seems to be (I haven’t tapped into more
> than 40% of what it can do I would guess.) there was a more elegant
> solution so GC routes the imported payment to the right bank card account and
> doesn’t duplicate the same ones.
> 
> 
> -Original Message-
> From: Dean Gibson [mailto:gnucash.st...@mailpen.com] 
> Sent: Friday, February 25, 2022 12:08 PM
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] reconcile problem?
> 
> Well, I have multiple multiple cards with the same bank, & it's no 
> trouble to detect the payments during import & deal with them in an 
> appropriate manner.  I n my case, I delete them from the import.  That 
> makes the reconciliation balance to the amount that was due.  Then, when 
> I import payments from by checking account, I allocate the payments to 
> the correct card account.
> 
> GNUcash is reasonable accounting software.  It just doesn't do thinking 
> for each individual's particular situation.
> 
> 
> On 2022-02-25 08:20, David Carlson wrote:
> > That came up in another thread a couple of weeks ago.  As far as I know,
> > the only solution is to be very careful in the matching step of the import.
> >You can help yourself when making the payments to be sure they have
> > different dates or amounts, or even paying out of different checking
> > accounts.
> > 
> > On Fri, Feb 25, 2022 at 8:11 AM scum buster  wrote:
> > 
> > > Sidebar question --- do any of you have more than one credit card with the
> > > same bank?   That is where I am running into issues when I i

Re: [GNC] reconcile problem?

2022-02-27 Thread Jim DeLaHunt

Hello, Scum Buster:

It seems to me that you are close to having this figured out, but that 
it maybe doesn't feel that way. Your night is darkest just before the dawn.


On 2022-02-26 23:29, scum buster wrote:

... I do not use the import function for the credit card accounts, I enter them manually 
in the credit card accounts.  I even use the same description as the bank does in my 
checking account"bankname payment"



Here's a chance to confirm your understanding. Do you see that, when you 
enter a transaction representing a payment in the credit card account, 
that this transaction also appears in the checking account?  And are you 
satisified that you understand why that happens (because this is 
double-entry bookkeeping)?


Good!



It is when I am importing my checking account info that the issue comes 
up..there are three choices on import on what to do with the itemand 
none of them seem to do the trick.
Yes. These three choices are described in the documentation, the "Help", 
6.16.7. Generic Transaction Import Matcher, 
. 
The three options are "A", "U+C", and "C". Give that section another 
read, then come back to the next paragraph.

one option imports the item and ends up being aduplictaeanother doesn’t 
import it at allthe third I cant recall what it does but it messes 
up..and again I assume that is because GC cannot differentiate.  The SAME 
payment sometimes duplicates and also DIFFERENT payments to the same bank post 
to seemingly random accounts in GC for that bank.


"A" means that GnuCash should Add this transaction. You already have the 
payment transaction in the checking account. Thus "A" creates a duplicate.


"C" means match to an existing transaction, and Clear its reconciliation 
status. That is what you want.


But also, the colour of each row in the Import Matcher window matters. 
You each row to be green. That means they are matched to an existing 
transaction (if "C" is checked) or will become a new transaction (if "A" 
is checked).


And, the final trick: double-click on each Import Matcher row which 
corresponds to a payment from checking account to credit card account. 
These should be matched to an existing transaction, so "C" will be 
checked.  When you double-click, a window "Select matching existing 
transaction" will appear. The top part of the window shows the 
transaction in the import file.  The bottom part of the window will have 
one or more rows corresponding to the plausible transactions which 
GnuCash might match.  You should see your various payment transactions 
from checking to the various credit cards here. Each will have a date 
and an amount listed. Based on those dates and amounts, find the correct 
payment transaction for the transaction you are matching, and click on it.


That selection is I think the final missing link in your search for a 
way to match your payment transactions.



Was just hoping that as powerful as GC seems to be (I haven’t tapped into more 
than 40% of what it can do I would guess.) there was a more elegant 
solution so GC routes the imported payment to the right bank card account and 
doesn’t duplicate the same ones.


The GnuCash UI does not make it clear that double-clicking on Import 
Matcher rows is a helpful thing to do, nor that it gives you a way to 
fix matching errors. When I finally learned it, it was a huge help to me.


So, try double-clicking on the Import Matcher rows, and see if that 
helps. Let us know.


The import matcher is also documented in the "Tutorial and Concepts 
Guide", 3.1.2 Import Matcher. You can read it at 
.


Good luck!
  —Jim DeLaHunt, Vancouver, Canada


___
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] reconcile problem?

2022-02-26 Thread scum buster
I understand no piece of software "thinks for you" 100% (maybe you did not 
intend it, but that comment feels condescending to me, but I digress)though 
I would argue that GC does indeed do just that in many ways...

I am just asking for help in dealing with this problem.problem being that 
the bank doesn’t differentiate between cards when posting the payment, 
therefore leading to GC not being able to differentiate.

How does deleting them help?  So you manually enter the payments transactions 
and also delete all the bank transactions from that bank during the import?

My concern is then you have to basically go out and double check you have them 
manually entered so they do appear.which basically I have done...

You said " when I import payments from by checking account, I allocate the 
payments to the correct card account." That is exactly what I am doing and 
where the problem arises.  I do not use the import function for the credit card 
accounts, I enter them manually in the credit card accounts.  I even use the 
same description as the bank does in my checking account"bankname payment".

It is when I am importing my checking account info that the issue comes 
up..there are three choices on import on what to do with the itemand 
none of them seem to do the trick.one option imports the item and ends up 
being aduplictaeanother doesn’t import it at allthe third I cant recall 
what it does but it messes up..and again I assume that is because GC cannot 
differentiate.  The SAME payment sometimes duplicates and also DIFFERENT 
payments to the same bank post to seemingly random accounts in GC for that bank.

Was just hoping that as powerful as GC seems to be (I haven’t tapped into more 
than 40% of what it can do I would guess.) there was a more elegant 
solution so GC routes the imported payment to the right bank card account and 
doesn’t duplicate the same ones.


-Original Message-
From: Dean Gibson [mailto:gnucash.st...@mailpen.com] 
Sent: Friday, February 25, 2022 12:08 PM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] reconcile problem?

Well, I have multiple multiple cards with the same bank, & it's no 
trouble to detect the payments during import & deal with them in an 
appropriate manner.  I n my case, I delete them from the import.  That 
makes the reconciliation balance to the amount that was due.  Then, when 
I import payments from by checking account, I allocate the payments to 
the correct card account.

GNUcash is reasonable accounting software.  It just doesn't do thinking 
for each individual's particular situation.


On 2022-02-25 08:20, David Carlson wrote:
> That came up in another thread a couple of weeks ago.  As far as I know,
> the only solution is to be very careful in the matching step of the import.
>You can help yourself when making the payments to be sure they have
> different dates or amounts, or even paying out of different checking
> accounts.
>
> On Fri, Feb 25, 2022 at 8:11 AM scum buster  wrote:
>
>> Sidebar question --- do any of you have more than one credit card with the
>> same bank?   That is where I am running into issues when I import and
>> "clear" (I have always called this "reconciling" but I guess there is a
>> difference?)
>>
>> The bank just has a line item "bankname payment"  , same for each card
>> account.
>>
>> That is where I run into issues trying to manually "clear" and that throws
>> my account balances in GC off
>>
>> -Original Message-
>> From: Adrien Monteleone [mailto:adrien.montele...@lusfiber.net]
>> Sent: Wednesday, February 23, 2022 2:15 PM
>> To:gnucash-u...@lists.gnucash.org
>> Subject: Re: [GNC] reconcile problem?
>>
>> Transactions won't reconcile themselves, but you can clear them either
>> manually or via an import.
>>
>> If you opened a backup by mistake, that would result in something
>> showing 'unreconciled' if the backup was before the reconciliation.
>>
>> The only way to get the 'y' to appear in the register is through a
>> reconciliation. Which means you in fact checked it off a previous time.
>>
>> You can re-do a reconciliation by changing all of the affected
>> transactions back to 'n' or 'c', and then trying again. Be sure to
>> remove any adjusting transactions you made during the last
>> reconciliation. You probably don't need them. (but can always re-create
>> if you do)
>>
>> Then proceed with this months reconciliation.
>>
>> In the future, if you ever notice transactions appearing 'c' or 'n' when
>> you know they should be 'y' means you've edited them in a manner that
>> will change the flag. (either in that register or one conn

Re: [GNC] reconcile problem?

2022-02-26 Thread scum buster
Yeah that was probably me….I never saw a solution…..may have missed it, been 
dealing with health stuff….

 

Thanks for the reply….they do have different dates and amounts but seems like 
no matter how I attempt to handle them during the clearing process, something 
always ends up goofy….the matching step is where I am having issues.

 

From: David Carlson [mailto:david.carlson@gmail.com] 
Sent: Friday, February 25, 2022 11:21 AM
To: scum buster
Cc: Adrien Monteleone; GnuCash List
Subject: Re: [GNC] reconcile problem?

 

That came up in another thread a couple of weeks ago.  As far as I know, the 
only solution is to be very careful in the matching step of the import.   You 
can help yourself when making the payments to be sure they have different dates 
or amounts, or even paying out of different checking accounts.

 

On Fri, Feb 25, 2022 at 8:11 AM scum buster  wrote:

Sidebar question --- do any of you have more than one credit card with the same 
bank?   That is where I am running into issues when I import and "clear" (I 
have always called this "reconciling" but I guess there is a difference?)

The bank just has a line item "bankname payment"  , same for each card account.

That is where I run into issues trying to manually "clear" and that throws my 
account balances in GC off

-Original Message-
From: Adrien Monteleone [mailto:adrien.montele...@lusfiber.net] 
Sent: Wednesday, February 23, 2022 2:15 PM
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] reconcile problem?

Transactions won't reconcile themselves, but you can clear them either 
manually or via an import.

If you opened a backup by mistake, that would result in something 
showing 'unreconciled' if the backup was before the reconciliation.

The only way to get the 'y' to appear in the register is through a 
reconciliation. Which means you in fact checked it off a previous time.

You can re-do a reconciliation by changing all of the affected 
transactions back to 'n' or 'c', and then trying again. Be sure to 
remove any adjusting transactions you made during the last 
reconciliation. You probably don't need them. (but can always re-create 
if you do)

Then proceed with this months reconciliation.

In the future, if you ever notice transactions appearing 'c' or 'n' when 
you know they should be 'y' means you've edited them in a manner that 
will change the flag. (either in that register or one connected to the 
transaction)

If you don't get warnings about this, go to Actions > Reset Warnings... 
and adjust as needed.

When you edit a transaction and the flag changes (or you discover it 
later) simply re-reconcile and clear the affected transaction(s). (and 
if you are editing amounts, double check you didn't make an adjusting 
entry, because again, you might no longer need it!)

Regards,
Adrien

On 2/23/22 9:33 AM, Paul Kinzelman wrote:
> That's a good question and I think that could be an explanation
> for the resurrection of the reconciled transactions which happened
> quite awhile ago when I was new to GC.
> 
> But that doesn't explain how a transaction could become
> reconciled on its own like the one that happened this month, which
> tipped me over the edge to post about it.




-- 
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

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



-- 

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] reconcile problem?

2022-02-25 Thread Dean Gibson
Well, I have multiple multiple cards with the same bank, & it's no 
trouble to detect the payments during import & deal with them in an 
appropriate manner.  I n my case, I delete them from the import.  That 
makes the reconciliation balance to the amount that was due.  Then, when 
I import payments from by checking account, I allocate the payments to 
the correct card account.


GNUcash is reasonable accounting software.  It just doesn't do thinking 
for each individual's particular situation.



On 2022-02-25 08:20, David Carlson wrote:

That came up in another thread a couple of weeks ago.  As far as I know,
the only solution is to be very careful in the matching step of the import.
   You can help yourself when making the payments to be sure they have
different dates or amounts, or even paying out of different checking
accounts.

On Fri, Feb 25, 2022 at 8:11 AM scum buster  wrote:


Sidebar question --- do any of you have more than one credit card with the
same bank?   That is where I am running into issues when I import and
"clear" (I have always called this "reconciling" but I guess there is a
difference?)

The bank just has a line item "bankname payment"  , same for each card
account.

That is where I run into issues trying to manually "clear" and that throws
my account balances in GC off

-Original Message-
From: Adrien Monteleone [mailto:adrien.montele...@lusfiber.net]
Sent: Wednesday, February 23, 2022 2:15 PM
To:gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] reconcile problem?

Transactions won't reconcile themselves, but you can clear them either
manually or via an import.

If you opened a backup by mistake, that would result in something
showing 'unreconciled' if the backup was before the reconciliation.

The only way to get the 'y' to appear in the register is through a
reconciliation. Which means you in fact checked it off a previous time.

You can re-do a reconciliation by changing all of the affected
transactions back to 'n' or 'c', and then trying again. Be sure to
remove any adjusting transactions you made during the last
reconciliation. You probably don't need them. (but can always re-create
if you do)

Then proceed with this months reconciliation.

In the future, if you ever notice transactions appearing 'c' or 'n' when
you know they should be 'y' means you've edited them in a manner that
will change the flag. (either in that register or one connected to the
transaction)

If you don't get warnings about this, go to Actions > Reset Warnings...
and adjust as needed.

When you edit a transaction and the flag changes (or you discover it
later) simply re-reconcile and clear the affected transaction(s). (and
if you are editing amounts, double check you didn't make an adjusting
entry, because again, you might no longer need it!)

Regards,
Adrien

On 2/23/22 9:33 AM, Paul Kinzelman wrote:

That's a good question and I think that could be an explanation
for the resurrection of the reconciled transactions which happened
quite awhile ago when I was new to GC.

But that doesn't explain how a transaction could become
reconciled on its own like the one that happened this month, which
tipped me over the edge to post about it.




--
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

___
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] reconcile problem?

2022-02-25 Thread David Carlson
That came up in another thread a couple of weeks ago.  As far as I know,
the only solution is to be very careful in the matching step of the import.
  You can help yourself when making the payments to be sure they have
different dates or amounts, or even paying out of different checking
accounts.

On Fri, Feb 25, 2022 at 8:11 AM scum buster  wrote:

> Sidebar question --- do any of you have more than one credit card with the
> same bank?   That is where I am running into issues when I import and
> "clear" (I have always called this "reconciling" but I guess there is a
> difference?)
>
> The bank just has a line item "bankname payment"  , same for each card
> account.
>
> That is where I run into issues trying to manually "clear" and that throws
> my account balances in GC off
>
> -Original Message-
> From: Adrien Monteleone [mailto:adrien.montele...@lusfiber.net]
> Sent: Wednesday, February 23, 2022 2:15 PM
> To: gnucash-u...@lists.gnucash.org
> Subject: Re: [GNC] reconcile problem?
>
> Transactions won't reconcile themselves, but you can clear them either
> manually or via an import.
>
> If you opened a backup by mistake, that would result in something
> showing 'unreconciled' if the backup was before the reconciliation.
>
> The only way to get the 'y' to appear in the register is through a
> reconciliation. Which means you in fact checked it off a previous time.
>
> You can re-do a reconciliation by changing all of the affected
> transactions back to 'n' or 'c', and then trying again. Be sure to
> remove any adjusting transactions you made during the last
> reconciliation. You probably don't need them. (but can always re-create
> if you do)
>
> Then proceed with this months reconciliation.
>
> In the future, if you ever notice transactions appearing 'c' or 'n' when
> you know they should be 'y' means you've edited them in a manner that
> will change the flag. (either in that register or one connected to the
> transaction)
>
> If you don't get warnings about this, go to Actions > Reset Warnings...
> and adjust as needed.
>
> When you edit a transaction and the flag changes (or you discover it
> later) simply re-reconcile and clear the affected transaction(s). (and
> if you are editing amounts, double check you didn't make an adjusting
> entry, because again, you might no longer need it!)
>
> Regards,
> Adrien
>
> On 2/23/22 9:33 AM, Paul Kinzelman wrote:
> > That's a good question and I think that could be an explanation
> > for the resurrection of the reconciled transactions which happened
> > quite awhile ago when I was new to GC.
> >
> > But that doesn't explain how a transaction could become
> > reconciled on its own like the one that happened this month, which
> > tipped me over the edge to post about it.
>
>
>
>
> --
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
>
> ___
> 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.
>


-- 
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] reconcile problem?

2022-02-25 Thread scum buster
Sidebar question --- do any of you have more than one credit card with the same 
bank?   That is where I am running into issues when I import and "clear" (I 
have always called this "reconciling" but I guess there is a difference?)

The bank just has a line item "bankname payment"  , same for each card account.

That is where I run into issues trying to manually "clear" and that throws my 
account balances in GC off

-Original Message-
From: Adrien Monteleone [mailto:adrien.montele...@lusfiber.net] 
Sent: Wednesday, February 23, 2022 2:15 PM
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] reconcile problem?

Transactions won't reconcile themselves, but you can clear them either 
manually or via an import.

If you opened a backup by mistake, that would result in something 
showing 'unreconciled' if the backup was before the reconciliation.

The only way to get the 'y' to appear in the register is through a 
reconciliation. Which means you in fact checked it off a previous time.

You can re-do a reconciliation by changing all of the affected 
transactions back to 'n' or 'c', and then trying again. Be sure to 
remove any adjusting transactions you made during the last 
reconciliation. You probably don't need them. (but can always re-create 
if you do)

Then proceed with this months reconciliation.

In the future, if you ever notice transactions appearing 'c' or 'n' when 
you know they should be 'y' means you've edited them in a manner that 
will change the flag. (either in that register or one connected to the 
transaction)

If you don't get warnings about this, go to Actions > Reset Warnings... 
and adjust as needed.

When you edit a transaction and the flag changes (or you discover it 
later) simply re-reconcile and clear the affected transaction(s). (and 
if you are editing amounts, double check you didn't make an adjusting 
entry, because again, you might no longer need it!)

Regards,
Adrien

On 2/23/22 9:33 AM, Paul Kinzelman wrote:
> That's a good question and I think that could be an explanation
> for the resurrection of the reconciled transactions which happened
> quite awhile ago when I was new to GC.
> 
> But that doesn't explain how a transaction could become
> reconciled on its own like the one that happened this month, which
> tipped me over the edge to post about it.




-- 
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

___
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] reconcile problem?

2022-02-23 Thread Paul Kinzelman
Thanks, but I don't think any of those instances apply in my case. I 
don't remember
ever reconciling one part of a split transaction, and didn't move the 
transaction

to another account.

On 2/23/2022 10:10 AM, David Carlson wrote:
A couple of other issues that could make GnuCash appear to be flakey 
when it is just eccentric are as follows:


One, while editing certain fields in a transaction that already 
contains one or more split lines that are already reconciled, GnuCash 
may unreconcile one or more of those reconciled splits.  The specific 
details of that behavior was changed a couple of times over several 
releases in the 3.x and 4.x series'.


Two, the first time GnuCash tries to do that it warns you and gives 
you an opportunity to change your mind, but it is very easy to click 
on the button to never remind me again about this.  Then, if you 
forget to go to Actions > Reset Warnings to get the warnings back, it 
is even easier to shoot yourself in the foot.


Last night I tested my skill at fixing a reconciliation error a few 
months earlier and I noted that GnuCash will give 'incorrect' values 
for the reconciliation if there are any 'future' [after the 
reconciliation date] non-zero value transactions that have already 
been reconciled.  In a way, this is a test for that sort of error.


There is a third possible issue that can create a 'future' reconciled 
transaction.  If a transaction was reconciled while it resided in 
account 'A', and subsequently was edited to reside in account 'B', 
GnuCash may not give the proper warning and un-reconcile that split 
line.  I think this only happens in older releases.


On Wed, Feb 23, 2022 at 9:34 AM Paul Kinzelman  wrote:

That's a good question and I think that could be an explanation
for the resurrection of the reconciled transactions which happened
quite awhile ago when I was new to GC.

But that doesn't explain how a transaction could become
reconciled on its own like the one that happened this month, which
tipped me over the edge to post about it.

On 2/23/2022 8:29 AM, Derek Atkins wrote:
> Are you possibly opening up a backup file when you start GnuCash?
>
> -derek
>
> On Wed, February 23, 2022 10:23 am, Paul Kinzelman wrote:
>> The latter is certainly possible, but it's strange that this
started with
>> gnucash, didn't happen with Quicken. But if nobody else has noticed
>> this, then maybe it is the latter. :-)
>>
>> And I have NEVER connected it to my account, as you suggested,
>> I ALWAYS enter everything by hand.
>>
>> Oh, and I'm using the Windows latest version.
>>
>> A while ago, I remember seeing a number of transactions which were
>> marked as reconciled become unreconciled as well, and it
balanced after
>> I checked them as reconciled again the next month.
>>
>> The real kicker was the one item I noticed that came up reconciled
>> this month as tho I had done it last month. And I couldn't have
done it
>> last month or else it would have been unbalanced. And the charge
>> was not on last month's statement.
>>
>> But if nobody else has seen anything like this, maybe it is
something
>> I'm doing. But it's strange that I never saw it with Quicken,
thus my
>> post.
>>
>> On 2/23/2022 7:51 AM, Derek Atkins wrote:
>>> HI,
>>>
>>> On Wed, February 23, 2022 9:35 am, Paul Kinzelman wrote:
 I always balance my accounts every month. I used to use
Quicken before
 they went to a rental model. Credit cards always balanced
every month
 for me.

 I've been using GC for several years now, and notice that I
sometimes
 can't
 get cards to balance, I have to add an imbalance amount. Then
this
 month, I noticed that a charge that was on this month's statement
 and not last month's statement was already marked as
reconciled in GC.

 Has anybody else noticed anything like this?

 I don't even know how to track this kind of thing down,
whether it's
 a bug, or I'm just getting older and senile. :-)
>>> without being rude, I would suggest the latter.
>>> How are you entering your transactions?
>>> I always enter them manually (I NEVER import), and when I have
a problem
>>> balancing I find it's *ALMOST ALWAYS* an error on my part
(especially
>>> with
>>> my wife's card, because I don't get receipts from any online
shopping
>>> she
>>> does).  When entering I find I sometimes swap digits, which
causes the
>>> result to be off.
>>> Every once in a while I have to cancel the reconcile and start
over and
>>> CAREFULLY watch the numbers to find where I entered something
>>> incorrectly.
>>>
>>> If you find you're off, then check again -- most likely
something was
>>> entered 

Re: [GNC] reconcile problem?

2022-02-23 Thread Adrien Monteleone
Transactions won't reconcile themselves, but you can clear them either 
manually or via an import.


If you opened a backup by mistake, that would result in something 
showing 'unreconciled' if the backup was before the reconciliation.


The only way to get the 'y' to appear in the register is through a 
reconciliation. Which means you in fact checked it off a previous time.


You can re-do a reconciliation by changing all of the affected 
transactions back to 'n' or 'c', and then trying again. Be sure to 
remove any adjusting transactions you made during the last 
reconciliation. You probably don't need them. (but can always re-create 
if you do)


Then proceed with this months reconciliation.

In the future, if you ever notice transactions appearing 'c' or 'n' when 
you know they should be 'y' means you've edited them in a manner that 
will change the flag. (either in that register or one connected to the 
transaction)


If you don't get warnings about this, go to Actions > Reset Warnings... 
and adjust as needed.


When you edit a transaction and the flag changes (or you discover it 
later) simply re-reconcile and clear the affected transaction(s). (and 
if you are editing amounts, double check you didn't make an adjusting 
entry, because again, you might no longer need it!)


Regards,
Adrien

On 2/23/22 9:33 AM, Paul Kinzelman wrote:

That's a good question and I think that could be an explanation
for the resurrection of the reconciled transactions which happened
quite awhile ago when I was new to GC.

But that doesn't explain how a transaction could become
reconciled on its own like the one that happened this month, which
tipped me over the edge to post about it.


___
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] reconcile problem?

2022-02-23 Thread Adrien Monteleone
There's no way to know without more detail why you're routinely off. And 
I'd probably never enter an adjusting transaction unless I'm absolutely 
certain of what it was.


Considering you found an already reconciled transaction this month, 
could you perhaps be simply checking everything off each time? (or at 
least checking off everything within a date range?)


Or maybe you just erroneously checked off that transaction, and you 
should not have, which is why you thought you needed to enter an adjustment.


I'd bet dimes to dollars that a more careful and thorough review of your 
reconciliations will allow you to delete most if not all of those 
adjusting transactions.


I second the comments of Derek and others. 99.% of the time, it 
is me, not GnuCash, making the mistake. Accounting is about being 
meticulous and methodical.


Regards,
Adrien

On 2/23/22 8:35 AM, Paul Kinzelman wrote:

I always balance my accounts every month. I used to use Quicken before
they went to a rental model. Credit cards always balanced every month
for me.

I've been using GC for several years now, and notice that I sometimes can't
get cards to balance, I have to add an imbalance amount. Then this
month, I noticed that a charge that was on this month's statement
and not last month's statement was already marked as reconciled in GC.

Has anybody else noticed anything like this?

I don't even know how to track this kind of thing down, whether it's
a bug, or I'm just getting older and senile. :-)
Ideas?


___
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] reconcile problem?

2022-02-23 Thread David Carlson
A couple of other issues that could make GnuCash appear to be flakey when
it is just eccentric are as follows:

One, while editing certain fields in a transaction that already contains
one or more split lines that are already reconciled, GnuCash may
unreconcile one or more of those reconciled splits.  The specific details
of that behavior was changed a couple of times over several releases in the
3.x and 4.x series'.

Two, the first time GnuCash tries to do that it warns you and gives you an
opportunity to change your mind, but it is very easy to click on the button
to never remind me again about this.  Then, if you forget to go to Actions
> Reset Warnings to get the warnings back, it is even easier to shoot
yourself in the foot.

Last night I tested my skill at fixing a reconciliation error a few months
earlier and I noted that GnuCash will give 'incorrect' values for the
reconciliation if there are any 'future' [after the reconciliation date]
non-zero value transactions that have already been reconciled.  In a way,
this is a test for that sort of error.

There is a third possible issue that can create a 'future' reconciled
transaction.  If a transaction was reconciled while it resided in account
'A', and subsequently was edited to reside in account 'B', GnuCash may not
give the proper warning and un-reconcile that split line.  I think this
only happens in older releases.

On Wed, Feb 23, 2022 at 9:34 AM Paul Kinzelman  wrote:

> That's a good question and I think that could be an explanation
> for the resurrection of the reconciled transactions which happened
> quite awhile ago when I was new to GC.
>
> But that doesn't explain how a transaction could become
> reconciled on its own like the one that happened this month, which
> tipped me over the edge to post about it.
>
> On 2/23/2022 8:29 AM, Derek Atkins wrote:
> > Are you possibly opening up a backup file when you start GnuCash?
> >
> > -derek
> >
> > On Wed, February 23, 2022 10:23 am, Paul Kinzelman wrote:
> >> The latter is certainly possible, but it's strange that this started
> with
> >> gnucash, didn't happen with Quicken. But if nobody else has noticed
> >> this, then maybe it is the latter. :-)
> >>
> >> And I have NEVER connected it to my account, as you suggested,
> >> I ALWAYS enter everything by hand.
> >>
> >> Oh, and I'm using the Windows latest version.
> >>
> >> A while ago, I remember seeing a number of transactions which were
> >> marked as reconciled become unreconciled as well, and it balanced after
> >> I checked them as reconciled again the next month.
> >>
> >> The real kicker was the one item I noticed that came up reconciled
> >> this month as tho I had done it last month. And I couldn't have done it
> >> last month or else it would have been unbalanced. And the charge
> >> was not on last month's statement.
> >>
> >> But if nobody else has seen anything like this, maybe it is something
> >> I'm doing. But it's strange that I never saw it with Quicken, thus my
> >> post.
> >>
> >> On 2/23/2022 7:51 AM, Derek Atkins wrote:
> >>> HI,
> >>>
> >>> On Wed, February 23, 2022 9:35 am, Paul Kinzelman wrote:
>  I always balance my accounts every month. I used to use Quicken before
>  they went to a rental model. Credit cards always balanced every month
>  for me.
> 
>  I've been using GC for several years now, and notice that I sometimes
>  can't
>  get cards to balance, I have to add an imbalance amount. Then this
>  month, I noticed that a charge that was on this month's statement
>  and not last month's statement was already marked as reconciled in GC.
> 
>  Has anybody else noticed anything like this?
> 
>  I don't even know how to track this kind of thing down, whether it's
>  a bug, or I'm just getting older and senile. :-)
> >>> without being rude, I would suggest the latter.
> >>> How are you entering your transactions?
> >>> I always enter them manually (I NEVER import), and when I have a
> problem
> >>> balancing I find it's *ALMOST ALWAYS* an error on my part (especially
> >>> with
> >>> my wife's card, because I don't get receipts from any online shopping
> >>> she
> >>> does).  When entering I find I sometimes swap digits, which causes the
> >>> result to be off.
> >>> Every once in a while I have to cancel the reconcile and start over and
> >>> CAREFULLY watch the numbers to find where I entered something
> >>> incorrectly.
> >>>
> >>> If you find you're off, then check again -- most likely something was
> >>> entered wrong.  Either that or you modified an existing, reconciled
> >>> transaction (from the other side) which caused a break in that starting
> >>> balance.
> >>>
>  Ideas?
> 
>  TIA!
>  Please remember to CC this list on all your replies.
>  You can do this by using Reply-To-List or Reply-All.
> >>> -derek
> >>>
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >> To 

Re: [GNC] reconcile problem?

2022-02-23 Thread Stephen M. Butler

On 2/23/22 07:23, Paul Kinzelman wrote:

The latter is certainly possible, but it's strange that this started with
gnucash, didn't happen with Quicken. But if nobody else has noticed
this, then maybe it is the latter. :-)

And I have NEVER connected it to my account, as you suggested,
I ALWAYS enter everything by hand.

Oh, and I'm using the Windows latest version.

A while ago, I remember seeing a number of transactions which were
marked as reconciled become unreconciled as well, and it balanced after
I checked them as reconciled again the next month.

The real kicker was the one item I noticed that came up reconciled
this month as tho I had done it last month. And I couldn't have done it
last month or else it would have been unbalanced. And the charge
was not on last month's statement.

But if nobody else has seen anything like this, maybe it is something
I'm doing. But it's strange that I never saw it with Quicken, thus my 
post.


On 2/23/2022 7:51 AM, Derek Atkins wrote:

HI,

On Wed, February 23, 2022 9:35 am, Paul Kinzelman wrote:

I always balance my accounts every month. I used to use Quicken before
they went to a rental model. Credit cards always balanced every month
for me.

I've been using GC for several years now, and notice that I sometimes
can't
get cards to balance, I have to add an imbalance amount. Then this
month, I noticed that a charge that was on this month's statement
and not last month's statement was already marked as reconciled in GC.

Has anybody else noticed anything like this?

I don't even know how to track this kind of thing down, whether it's
a bug, or I'm just getting older and senile. :-)

without being rude, I would suggest the latter.
How are you entering your transactions?
I always enter them manually (I NEVER import), and when I have a problem
balancing I find it's *ALMOST ALWAYS* an error on my part (especially 
with
my wife's card, because I don't get receipts from any online shopping 
she

does).  When entering I find I sometimes swap digits, which causes the
result to be off.
Every once in a while I have to cancel the reconcile and start over and
CAREFULLY watch the numbers to find where I entered something 
incorrectly.


If you find you're off, then check again -- most likely something was
entered wrong.  Either that or you modified an existing, reconciled
transaction (from the other side) which caused a break in that starting
balance.


Ideas?

TIA!
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

-derek


For my CC purchases I do an OFX download of the transactions for the 
most recent statement once a month.  It automatically marks the 
transactions as cleared for me (so I don't have to check them off at 
reconcile time) and almost always balances.


This month was one of the rare exceptions and it appears that one of the 
transactions to which I had to assign an account was duplicated with the 
following transaction removed.  Can't prove it at this time so I'll be 
watching to see if I can catch it happening again (and this time I'll 
keep the import file around!)


--
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
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] reconcile problem?

2022-02-23 Thread Paul Kinzelman

That's a good question and I think that could be an explanation
for the resurrection of the reconciled transactions which happened
quite awhile ago when I was new to GC.

But that doesn't explain how a transaction could become
reconciled on its own like the one that happened this month, which
tipped me over the edge to post about it.

On 2/23/2022 8:29 AM, Derek Atkins wrote:

Are you possibly opening up a backup file when you start GnuCash?

-derek

On Wed, February 23, 2022 10:23 am, Paul Kinzelman wrote:

The latter is certainly possible, but it's strange that this started with
gnucash, didn't happen with Quicken. But if nobody else has noticed
this, then maybe it is the latter. :-)

And I have NEVER connected it to my account, as you suggested,
I ALWAYS enter everything by hand.

Oh, and I'm using the Windows latest version.

A while ago, I remember seeing a number of transactions which were
marked as reconciled become unreconciled as well, and it balanced after
I checked them as reconciled again the next month.

The real kicker was the one item I noticed that came up reconciled
this month as tho I had done it last month. And I couldn't have done it
last month or else it would have been unbalanced. And the charge
was not on last month's statement.

But if nobody else has seen anything like this, maybe it is something
I'm doing. But it's strange that I never saw it with Quicken, thus my
post.

On 2/23/2022 7:51 AM, Derek Atkins wrote:

HI,

On Wed, February 23, 2022 9:35 am, Paul Kinzelman wrote:

I always balance my accounts every month. I used to use Quicken before
they went to a rental model. Credit cards always balanced every month
for me.

I've been using GC for several years now, and notice that I sometimes
can't
get cards to balance, I have to add an imbalance amount. Then this
month, I noticed that a charge that was on this month's statement
and not last month's statement was already marked as reconciled in GC.

Has anybody else noticed anything like this?

I don't even know how to track this kind of thing down, whether it's
a bug, or I'm just getting older and senile. :-)

without being rude, I would suggest the latter.
How are you entering your transactions?
I always enter them manually (I NEVER import), and when I have a problem
balancing I find it's *ALMOST ALWAYS* an error on my part (especially
with
my wife's card, because I don't get receipts from any online shopping
she
does).  When entering I find I sometimes swap digits, which causes the
result to be off.
Every once in a while I have to cancel the reconcile and start over and
CAREFULLY watch the numbers to find where I entered something
incorrectly.

If you find you're off, then check again -- most likely something was
entered wrong.  Either that or you modified an existing, reconciled
transaction (from the other side) which caused a break in that starting
balance.


Ideas?

TIA!
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

-derek


___
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] reconcile problem?

2022-02-23 Thread Derek Atkins
Are you possibly opening up a backup file when you start GnuCash?

-derek

On Wed, February 23, 2022 10:23 am, Paul Kinzelman wrote:
> The latter is certainly possible, but it's strange that this started with
> gnucash, didn't happen with Quicken. But if nobody else has noticed
> this, then maybe it is the latter. :-)
>
> And I have NEVER connected it to my account, as you suggested,
> I ALWAYS enter everything by hand.
>
> Oh, and I'm using the Windows latest version.
>
> A while ago, I remember seeing a number of transactions which were
> marked as reconciled become unreconciled as well, and it balanced after
> I checked them as reconciled again the next month.
>
> The real kicker was the one item I noticed that came up reconciled
> this month as tho I had done it last month. And I couldn't have done it
> last month or else it would have been unbalanced. And the charge
> was not on last month's statement.
>
> But if nobody else has seen anything like this, maybe it is something
> I'm doing. But it's strange that I never saw it with Quicken, thus my
> post.
>
> On 2/23/2022 7:51 AM, Derek Atkins wrote:
>> HI,
>>
>> On Wed, February 23, 2022 9:35 am, Paul Kinzelman wrote:
>>> I always balance my accounts every month. I used to use Quicken before
>>> they went to a rental model. Credit cards always balanced every month
>>> for me.
>>>
>>> I've been using GC for several years now, and notice that I sometimes
>>> can't
>>> get cards to balance, I have to add an imbalance amount. Then this
>>> month, I noticed that a charge that was on this month's statement
>>> and not last month's statement was already marked as reconciled in GC.
>>>
>>> Has anybody else noticed anything like this?
>>>
>>> I don't even know how to track this kind of thing down, whether it's
>>> a bug, or I'm just getting older and senile. :-)
>> without being rude, I would suggest the latter.
>> How are you entering your transactions?
>> I always enter them manually (I NEVER import), and when I have a problem
>> balancing I find it's *ALMOST ALWAYS* an error on my part (especially
>> with
>> my wife's card, because I don't get receipts from any online shopping
>> she
>> does).  When entering I find I sometimes swap digits, which causes the
>> result to be off.
>> Every once in a while I have to cancel the reconcile and start over and
>> CAREFULLY watch the numbers to find where I entered something
>> incorrectly.
>>
>> If you find you're off, then check again -- most likely something was
>> entered wrong.  Either that or you modified an existing, reconciled
>> transaction (from the other side) which caused a break in that starting
>> balance.
>>
>>> Ideas?
>>>
>>> TIA!
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>> -derek
>>
>
> ___
> 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.
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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] reconcile problem?

2022-02-23 Thread Paul Kinzelman

The latter is certainly possible, but it's strange that this started with
gnucash, didn't happen with Quicken. But if nobody else has noticed
this, then maybe it is the latter. :-)

And I have NEVER connected it to my account, as you suggested,
I ALWAYS enter everything by hand.

Oh, and I'm using the Windows latest version.

A while ago, I remember seeing a number of transactions which were
marked as reconciled become unreconciled as well, and it balanced after
I checked them as reconciled again the next month.

The real kicker was the one item I noticed that came up reconciled
this month as tho I had done it last month. And I couldn't have done it
last month or else it would have been unbalanced. And the charge
was not on last month's statement.

But if nobody else has seen anything like this, maybe it is something
I'm doing. But it's strange that I never saw it with Quicken, thus my post.

On 2/23/2022 7:51 AM, Derek Atkins wrote:

HI,

On Wed, February 23, 2022 9:35 am, Paul Kinzelman wrote:

I always balance my accounts every month. I used to use Quicken before
they went to a rental model. Credit cards always balanced every month
for me.

I've been using GC for several years now, and notice that I sometimes
can't
get cards to balance, I have to add an imbalance amount. Then this
month, I noticed that a charge that was on this month's statement
and not last month's statement was already marked as reconciled in GC.

Has anybody else noticed anything like this?

I don't even know how to track this kind of thing down, whether it's
a bug, or I'm just getting older and senile. :-)

without being rude, I would suggest the latter.
How are you entering your transactions?
I always enter them manually (I NEVER import), and when I have a problem
balancing I find it's *ALMOST ALWAYS* an error on my part (especially with
my wife's card, because I don't get receipts from any online shopping she
does).  When entering I find I sometimes swap digits, which causes the
result to be off.
Every once in a while I have to cancel the reconcile and start over and
CAREFULLY watch the numbers to find where I entered something incorrectly.

If you find you're off, then check again -- most likely something was
entered wrong.  Either that or you modified an existing, reconciled
transaction (from the other side) which caused a break in that starting
balance.


Ideas?

TIA!
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

-derek



___
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] reconcile problem?

2022-02-23 Thread William Prescott
Ditto to Derek's comment. I've been using Gnucash since 2011, somewhat 
regularly (I wish it was monhtly) balancing some 20 odd accounts, checking, 
savings, investment and credit cards. Whenever I've run into problems it always 
turned out to be something I screwed up. 

The only one I regularly have problems with is a cash account. Balancing it 
with the cash in my pockets is often off and that is clearly because I forget 
to record a cash expense.

Good luck,
Will

On 2022 Feb 23, at 02-23 08:51:57, Derek Atkins  wrote:

HI,

On Wed, February 23, 2022 9:35 am, Paul Kinzelman wrote:
> I always balance my accounts every month. I used to use Quicken before
> they went to a rental model. Credit cards always balanced every month
> for me.
> 
> I've been using GC for several years now, and notice that I sometimes
> can't
> get cards to balance, I have to add an imbalance amount. Then this
> month, I noticed that a charge that was on this month's statement
> and not last month's statement was already marked as reconciled in GC.
> 
> Has anybody else noticed anything like this?
> 
> I don't even know how to track this kind of thing down, whether it's
> a bug, or I'm just getting older and senile. :-)

without being rude, I would suggest the latter.
How are you entering your transactions?
I always enter them manually (I NEVER import), and when I have a problem
balancing I find it's *ALMOST ALWAYS* an error on my part (especially with
my wife's card, because I don't get receipts from any online shopping she
does).  When entering I find I sometimes swap digits, which causes the
result to be off.
Every once in a while I have to cancel the reconcile and start over and
CAREFULLY watch the numbers to find where I entered something incorrectly.

If you find you're off, then check again -- most likely something was
entered wrong.  Either that or you modified an existing, reconciled
transaction (from the other side) which caused a break in that starting
balance.

> Ideas?
> 
> TIA!

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
  Derek Atkins 617-623-3745
  de...@ihtfp.com  www.ihtfp.com 

  Computer and Internet Security Consultant

___
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] reconcile problem?

2022-02-23 Thread Derek Atkins
HI,

On Wed, February 23, 2022 9:35 am, Paul Kinzelman wrote:
> I always balance my accounts every month. I used to use Quicken before
> they went to a rental model. Credit cards always balanced every month
> for me.
>
> I've been using GC for several years now, and notice that I sometimes
> can't
> get cards to balance, I have to add an imbalance amount. Then this
> month, I noticed that a charge that was on this month's statement
> and not last month's statement was already marked as reconciled in GC.
>
> Has anybody else noticed anything like this?
>
> I don't even know how to track this kind of thing down, whether it's
> a bug, or I'm just getting older and senile. :-)

without being rude, I would suggest the latter.
How are you entering your transactions?
I always enter them manually (I NEVER import), and when I have a problem
balancing I find it's *ALMOST ALWAYS* an error on my part (especially with
my wife's card, because I don't get receipts from any online shopping she
does).  When entering I find I sometimes swap digits, which causes the
result to be off.
Every once in a while I have to cancel the reconcile and start over and
CAREFULLY watch the numbers to find where I entered something incorrectly.

If you find you're off, then check again -- most likely something was
entered wrong.  Either that or you modified an existing, reconciled
transaction (from the other side) which caused a break in that starting
balance.

> Ideas?
>
> TIA!

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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] reconcile problem?

2022-02-23 Thread Paul Kinzelman

I always balance my accounts every month. I used to use Quicken before
they went to a rental model. Credit cards always balanced every month
for me.

I've been using GC for several years now, and notice that I sometimes can't
get cards to balance, I have to add an imbalance amount. Then this
month, I noticed that a charge that was on this month's statement
and not last month's statement was already marked as reconciled in GC.

Has anybody else noticed anything like this?

I don't even know how to track this kind of thing down, whether it's
a bug, or I'm just getting older and senile. :-)
Ideas?

TIA!

___
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] Reconcile Problem

2018-06-08 Thread Gareth Davies via gnucash-user
Hi Ron, and thank you for the welcome.

Thanks to the messages I received from you and Derek I was able to find out 
where my problem was.

As I mentioned in my post I am still trying to get my head around the program, 
and no doubt this will not be the last of my posts.

Gareth

-Original Message-
From: gnucash-user 
[mailto:gnucash-user-bounces+gareth.davies.1=ntlworld@gnucash.org] On 
Behalf Of Ronal B Morse
Sent: 07 June 2018 14:01
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Reconcile Problem

Hi Gareth.  Welcome to the list.

With the account register open, click on the "view" item in the menu bar, then 
in the dialog that opens click on "filter by". Then click on "status" in that 
menu bar which opens a selection dialog. Clear the checks from all but 
"Reconciled". Then click on OK.

Putting a check in the "save filter" box will make the selection persistent 
from session to session, otherwise the filter will revert to the default (all 
categories selected) the next time you open the account register.

You'll have to set the filter for each account register individually.

Ron Morse.


On 06/07/2018 01:50 AM, Gareth Davies via gnucash-user wrote:
> Hi,
>
>   
>
> This is my first post so hopefully I am doing things correctly.
>
>   
>
> I have been appointed as Treasurer to a Club and have been handed the 
> accounts from the previous treasurer who used Gnucash.
>
>   
>
> The problem I am having is how can I see the previous reconciled 
> transactions, I have looked in the preference settings but can't find 
> any tick box that would allow me to do this.
>
>   
>
> Any help much appreciated.
>
>   
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

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


Re: [GNC] Reconcile Problem

2018-06-07 Thread Ronal B Morse

Hi Gareth.  Welcome to the list.

With the account register open, click on the "view" item in the menu 
bar, then in the dialog that opens click on "filter by". Then click on 
"status" in that menu bar which opens a selection dialog. Clear the 
checks from all but "Reconciled". Then click on OK.


Putting a check in the "save filter" box will make the selection 
persistent from session to session, otherwise the filter will revert to 
the default (all categories selected) the next time you open the account 
register.


You'll have to set the filter for each account register individually.

Ron Morse.


On 06/07/2018 01:50 AM, Gareth Davies via gnucash-user wrote:

Hi,

  


This is my first post so hopefully I am doing things correctly.

  


I have been appointed as Treasurer to a Club and have been handed the
accounts from the previous treasurer who used Gnucash.

  


The problem I am having is how can I see the previous reconciled
transactions, I have looked in the preference settings but can't find any
tick box that would allow me to do this.

  


Any help much appreciated.

  


___
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] Reconcile Problem

2018-06-07 Thread Derek Atkins

Hi,
I'm not sure I understand your issue here.
Gnucash will show you all your transactions, reconciled or not, unless you 
View - > Filter to turn it off.


Perhaps your data file does not have earlier transactions?

-derek
Sent using my mobile device. Please excuse any typos.
On June 7, 2018 9:51:51 AM Gareth Davies via gnucash-user 
 wrote:



Hi,



This is my first post so hopefully I am doing things correctly.



I have been appointed as Treasurer to a Club and have been handed the
accounts from the previous treasurer who used Gnucash.



The problem I am having is how can I see the previous reconciled
transactions, I have looked in the preference settings but can't find any
tick box that would allow me to do this.



Any help much appreciated.



___
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] Reconcile Problem

2018-06-07 Thread Gareth Davies via gnucash-user
Hi, 

 

This is my first post so hopefully I am doing things correctly.

 

I have been appointed as Treasurer to a Club and have been handed the
accounts from the previous treasurer who used Gnucash.

 

The problem I am having is how can I see the previous reconciled
transactions, I have looked in the preference settings but can't find any
tick box that would allow me to do this.

 

Any help much appreciated.

 

___
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: Reconcile problem

2018-02-02 Thread DaveC49
If its any help the reconcile dialog should allow you to change both the date
and the ending balance. The observed behaviour on Gnucash 2.6.18 ( and it
hasn't changed for me since changing from  2.6.16 or from previous versions
over the last 2-3 years) on Linux Mint 18.3 (Ubuntu 16.04) is that if you
change the date, the initial reconcile dialog updates the ending balance to
what the account record indicate it to beat that date. If your external
record shows a different balance at that date then you can enter that
balance  and hit enter. It then opens the main reconcile window with the
ending balance set to the value you have just entered.

A mouseover of the icons on the toolbar also brings up the tooltips and
again that behaviour was the same in previous Gnucash versions for the past
4-5 years. 

If you are not seeing the tooltips, perhaps it may be a problem/difference
with the library versions installed on your operating system. As far as I
know dpkg works on SUSE so it may be worth doing dpkg -l and comparing the
loaded libraries against the dependency list for 2.6.16. If there is an
older than recommended library, that may be a possible explanantion.



-
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: Reconcile problem

2018-01-31 Thread Colin Law
On 30 January 2018 at 22:22, oldpopsie  wrote:

> I used to be able to changetheending balance when I set up a reconcile for
> a
> month. All ofa sudden, i have a new version/build of Gnucash and it won'
> t let me change the ending balance i am trying to reconcile to. Instead, it
> insists on entering the exact register balance for the reconcile date. This
> produces an unreconciled amount when I have accounted for everything that
> has cleared the bank, as it does not allow for outstanding items (uncleared
> checks). Is this a setting problem? If so, what do I change? If not, how do
> I get an accurate reconcile?
>

Which version of gnucash are you using, on what operating system, and how
did you install or build it?

When you say it won't let you change it, what happens if you type into the
appropriate field on the reconcile dialog?

Colin


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