[GNC] Partial use of reconciliation -- RESULTS

[Kalpesh Patel]

In the window that pops up when you click reconcile button, I normally ignore the opening balance, and just make sure that that closing balance and the closing date are correct. The opening balance may wander off because transactions may have had to be modified, even just to change the order of them which is a white space change, which I believe automagically changes it from reconciled to not. IMHO, the opening balance info is great to have if you are really religious down to letter of the spirit, but in practical world it is of little to no significance. Especially if you are hunting for a discrepancy as you can always re-reconcile an account to the same previously closed date and its corresponding closed balance. 

-----Original Message-----
From: Stan Brown (using GC 4.14) <stan+gc at fastmail.fm> 
Sent: Saturday, April 26, 2025 9:33 PM
To: gnucash-user at gnucash.org
Subject: Re: [GNC] Partial use of reconciliation -- RESULTS

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