[GNC] Partial use of reconciliation -- RESULTS

[sunfish62 at yahoo.com]

Stan,  

Glad you worked this out. I'll note that it sounds as if you did all this in the register, based on your talking about setting the field to "c."

I'll note that if you were to use the Reconcile feature in GnuCash, you would find an interface that simplifies the selection of transactions to be reconciled. It would also make it easy to locate discrepancies of the sort you mentioned. Finally, were you to complete that process, GnuCash would set the Reconcile field to "y" for all those transactions, and the program would prompt you before allowing you to edit any of them in the future. It's an added assurance that past transactions stay the way you want them. (Note that this can be overridden)

Should you wish to have that result, you can rather quickly take your accounts now, click the Reconcile button, accept the defaults, and (assuming the numbers actually match) click finish in the ensuing dialog to change all transactions to "y." Then future reconciliations could be done against statements on a regular basis. 

⁣David T. ​

On Apr 27, 2025, 4:35 AM, at 4:35 AM, "Stan Brown (using GC 4.14)" <stan+gc at fastmail.fm> wrote:
>Thanks to those who answered my earlier question.
>
>When I went to reconcile everything in my checking account, there was a
>discrepancy of over $1,000 between what the reconciliation screen
>showed
>for new balance and what was in my account. (The starting value of the
>account was zero.) Rather than spend a lot of time tracking that down,
>I
>elected just to mark all the cleared items as cleared, i.e. change the
>n
>to c in the R column. This took less time than I expected: the fact
>that
>simply clicking on an n changes it to a c sped things up.
>
>At the end of that, "Cleared" in the footer line of the checking
>account
>was $112 off. I did a Find for Value = 112.00; there was only one
>transaction in the results pane, and it was the one. I changed its n to
>c, and then "Cleared" in the account footer matched today's cleared
>balance according to my bank.
>
>I repeated this for my GC account for my bank savings account, and
>"Cleared" matched my bank's figure the first time.
>
>I ran a Find for Reconciled = not cleared, and the only ones that came
>up were the bill-pay transactions that I had set up for future dates,
>just as should be.
>
>I've been using an Excel spreadsheet to keep track of cleared and
>transactions and uncleared (which includes future transactions). It's
>nice to bring that within GC and eliminate the duplicate work!
>
>Stan Brown
>Tehachapi, CA, USA
>https://BrownMath.com
>
>On 2025-04-24 11:36, Stan Brown (using GC 4.14) wrote:
>> I've never used reconciliation because I get real-time transactions
>from
>> all my credit cards and my bank, so if there's something wrong I deal
>> with it before the statement arrives.
>> 
>> But recently I realized there's one _piece_ of reconciliation I'd
>like
>> to use in my bank accounts: cleared (c) versus not cleared (n). I
>think
>> it would be useful to get a list of uncleared checks, deposits, and
>> transfers from time to time which I can do with a filter.
>> 
>> But ... I've got over 7 years of data in my book, so clearing all
>those
>> items individually would be quite a job. I know I can filter by date
>as
>> well as not-cleared status, but I wonder if there's any shortcut to
>> clearing a lot of transactions at once.
>> 
>> For instance, it looks like I can treat everything before this year
>as a
>> single statement and just bulk-reconcile it; that would leave me only
>> this year's transactions (about 100 of them) to mark as cleared. Any
>> reason not to take that approach, or is there a better way?
>> 
>_______________________________________________
>gnucash-user mailing list
>gnucash-user at gnucash.org
>To update your subscription preferences or to unsubscribe:
>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.