[GNC] Partial use of reconciliation -- RESULTS
Stan Brown (using GC 4.14)
stan+gc at fastmail.fm
Sat Apr 26 21:32:58 EDT 2025
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?
>
More information about the gnucash-user
mailing list