[GNC] Banking Account - Imported QIF data and Opening Balances

[Byron Bray]

Jim,

Thanks for those detailed remarks; you obviously put a good deal of time and thought into them.
>> Here's a question. Why are you performing a reconciliation in GnuCash, on an account which has transactions after the reconciliation period which are already marked "reconciled"?  This is an unusual situation. GnuCash's reconciliation tool is based on the assumption that you reconcile in chronological order, that you will reconcile January before you reconcile February.
>> 

I understand that to be the case but when you are importing a file you are, by the very nature of the import operation, adding records that have already entered and reconciled in the other application. The only way to avoid that condition, as far as I can see, would be to deliberately NOT reconcile the transactions in the "from" file, and then reconcile them once they are in GnuCash. This is the very condition I believe I need to contrive by the process of “un-reconciling" the transactions in my "from” file.

The original problem is that, once I import these transactions, already re-reconciled, into GnuCash, I find a starting balance of almost $1000 in the reconciliation window. This requires me to enter a balancing transaction of that amount in order to satisfy the reconciliation window. Unfortunately, that throws the running balance of the account off by almost $1000.


>> 3) (going through the hundreds of transactions to ferret out the problem) might be a good idea, because the whole point of reconciliation is to discover differences between your records and the bank's records. They should match. If they don't, there is a discrepancy. If there is a discrepancy, to a first approximation that is wrong and should get fixed.


I accept that in principle but it seems little different, to me, than simply un-reconciling everything and then reconciling them from scratch in GnuCash. I am certainly open to any other viable solution, but this approach, tedious though it is, would both result in accurate reconciliation and running balances, and would, by its nature, reveal any transactions that need to be edited or deleted. The transactions have been reconciled in Quicken and are displayed in its reconciliation window without any faulty transactions or discrepancies whatever.

> Are the transactions marked "reconciled" when you import them from the QIF data?  If so, then why do you need to reconcile them again?
> 

Yes. But, again, that results in a ≈$1,000 discrepancy between the Reconcile window's starting balance, and the running balance displayed in the register.

> But if you are going to reconcile them again, then mark all transactions from the period in question forward in time as unreconciled in GnuCash before attempting to reconcile.
> 
I have tried this but the GnuCash’s calculation of the "starting balance" as being the sum of all reconciled transactions in the account, means that it will always present me with this ≈ $1,000 discrepancy.

> Consider what you are trying to do with this reconciliation operation. Are you trying to identify errors? If so, the reconciliation discrepancy is trying to tell you that errors exist.  Or, is the data you are importing already reconciled?  If so, then why do you need to reconcile it again? Don't you trust the data to be correct already?
> 
I am trying to arrive at an accurate reconciliation " Starting Balance” and an accurate account running balance. As mentioned, the transactions are already reconciled. I absolutely trust the transactions entered in the Quicken file; they are reconciled and show no discrepancies or irregularities. Again, the problem is that when I import them into GnuCash, there is this ≈$1,000 discrepancy.



> One thing I have not heard said out loud is that the "opening balance" transaction in your GnuCash account is the summary of all activity in that account before the start of the transactions in GnuCash, and that this opening balance transaction should itself be reconciled. 
> 
Actually, as mentioned, I have entered an "opening balance" transaction in the exact amount of the balance of the account at the end of the month before the first month of imported transactions. That, however, has not affected the ≈$,1000 discrepancy in the "starting balance" field of the reconciliation window …  except by the exact amount of the opening balance transaction itself. I can reconcile that but it still leaves this discrepancy.

> Suppose that you are importing QIF data starting with January 2025, but the other bookkeeping program has reconcile records of transactions from 2024 and earlier. The amount of the opening balance transaction in GnuCash should be the value of that account as of just before the first transaction in your January 2025 records. And that transaction should be marked as "reconciled".
> 
That is the case. But it is still discrepant by ≈$1,000


Thanks again, Jim

==============

> On Mar 2, 2026, at 6:11 PM, Jim DeLaHunt <list+gnucash at jdlh.com> wrote:
> 
> Byron:
> 
> On 2026-03-02 17:41, Byron Bray wrote:
>> Very basically, my problem is that, once having imported the data from Quicken into GnuCash, the Starting Balance in the reconciliation window is almost $1,000. I cannot get the account to reconcile (the Finish button is disabled) unless I create a balancing transaction. If I create that transaction, the running balance, from that transaction onward, is discrepant from my actual balance by that ≈$1,000.
>> 
>> My current understanding is that can GnuCash derives that reconciliation Starting Balance by summing the reconciled transactions in the register regardless of date. 
> Correct, that is how GnuCash behaves.
>> If that is correct, it takes into account transactions months or years after that opening-date transaction. 
> Here's a question. Why are you performing a reconciliation in GnuCash, on an account which has transactions after the reconciliation period which are already marked "reconciled"?  This is an unusual situation. GnuCash's reconciliation tool is based on the assumption that you reconcile in chronological order, that you will reconcile January before you reconcile February.
> 
>> So, unless I am missing some better alternative (which I would be DELIGHTED to find out about), I am faced with with either:
>> 1) Accepting that the reconciliation numbers will never look right, even thought the running balance in the account is accurate OR 
>> 2) Accepting that the running balance will always be discrepant by the amount of the balancing transaction that the reconciliation process requires to complete OR
> 1) and 2) should not be necessary. You should be able to get GnuCash reconciliation to work without these compromises.
>> 3) Going through eh hundreds of extant transactions trying to find the transaction(s) that total this sum and are causing this discrepancy OR
> 3) might be a good idea, because the whole point of reconciliation is to discover differences between your records and the bank's records. They should match. If they don't, there is a discrepancy. If there is a discrepancy, to a first approximation that is wrong and should get fixed.
>> 4) Un-reconciling the Quicken transactions, exporting from Quicken, importing to GnuCash and then reconciling.
> Are the transactions marked "reconciled" when you import them from the QIF data?  If so, then why do you need to reconcile them again?
> 
> But if you are going to reconcile them again, then mark all transactions from the period in question forward in time as unreconciled in GnuCash before attempting to reconcile.
> 
>> Again, I would be so delighted to find that I was missing something, obvious or not, that would make a smother, quicker process possible. Please let me know if that is the case.
> Consider what you are trying to do with this reconciliation operation. Are you trying to identify errors? If so, the reconciliation discrepancy is trying to tell you that errors exist.  Or, is the data you are importing already reconciled?  If so, then why do you need to reconcile it again? Don't you trust the data to be correct already?
> 
> One thing I have not heard said out loud is that the "opening balance" transaction in your GnuCash account is the summary of all activity in that account before the start of the transactions in GnuCash, and that this opening balance transaction should itself be reconciled.
> 
> Suppose that you are importing QIF data starting with January 2025, but the other bookkeeping program has reconcile records of transactions from 2024 and earlier. The amount of the opening balance transaction in GnuCash should be the value of that account as of just before the first transaction in your January 2025 records. And that transaction should be marked as "reconciled".
> 
> I hope this helps,
>        —Jim DeLaHunt
> 
> 
>