[GNC] Reconciliation anomaly

Jim Passmore jim at passmore4.com
Tue Mar 31 10:05:40 EDT 2026


David,
First, to clarify...are you comparing the
Present/Future/Cleared/Reconciled/Projected Minimum numbers at the
bottom to the last running total number on the right side of the
register (blue boxes in attached files)?  If so, I would expect a
match only rarely.  I wonder if you're mis-interpreting the running
total.  When the register is filtered, it doesn't recalculate those
numbers--they still show the same numbers as they did before
unreconciled transactions were filtered out.  In the red box of my
screenshot, you can see that after a $13 payment my balance went up
almost $500--obviously it's not doing the math.  If I find those same
transactions in an unfiltered view, I see there was a $500 deposit
between the transactions.

If I rephrase your question as
> "What can make the reconciled value shown at the
> bottom of the register (which also seems to be the starting value for a
> reconciliation.) about $24,000 less than the *running* [not sum] total of all the
> [reconciled--word deleted] transactions in the account?"

then the answer is unreconciled transactions.

On the other hand, if I run a transaction report and filter to show
only reconciled, it *does* match the $484.94 along the bottom of my
register.

Maybe this helps?


--
Jim Passmore





On Mon, Mar 30, 2026 at 5:22 PM David Carlson
<david.carlson.417 at gmail.com> wrote:
>
> I have a bank account that I have not reconciled since May of 2024 and now
> I want to play catchup.  Now I don't remember all the things that could be
> out of whack but I have some issues with this account.
>
> I am doing this in GnuCash release 5.14 on a Windows 10 machine.
> Interestingly, if I select to show only reconciled transactions the ending
> balance matches the statement balance for May 20, 2024, but if I show all
> transactions in this register, the cleared and reconciled totals at the
> bottom of the register are between 16,000 and 18,000 negative.  If I show
> all transactions dated before today, those values do not change.  If I
> start a reconciliation, the starting value for the reconciliation is equal
> to the negative reconciled balance shown at the bottom of the register and
> the ending value is the register value displayed for June 20, 2024
>
> So my first question is "What can make the reconciled value shown at the
> bottom of the register (which also seems to be the starting value for a
> reconciliation.) about $24,000 less than the sum total of all the
> reconciled transactions in the account?"
>
>
> --
> David Carlson
> _______________________________________________
> 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.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: bottom.png
Type: image/png
Size: 35814 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20260331/d23c3c49/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: running total.png
Type: image/png
Size: 173919 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20260331/d23c3c49/attachment-0003.png>


More information about the gnucash-user mailing list