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

[Byron Bray]

Thank, Liz,

I will do that. I agree, time does have eroding effect on the memory of solutions we find for problems, particularly the knotty ones. I once put together a database for reconstructing the 1890 US census, the original records for which had been destroyed in a fire in Washington DC in 1921. To assemble those records, I used recordation of 1890-contemporary births, deaths, other vital records, land grant and other land records, cemetery records, newspaper articles, and 14 other data sources, which were housed in eight database tables. I then had to write a routine that would, when a query name was entered, browse all the tables, and present a list of all the possible found records for editing and possible addition of the queried individual into a “derived-census” record with those corroborating records as reference citations. That was back in 1989; had I not printed out all the code I wrote for that, I would probably never be able to reconstruct it.

Thanks for that advice I will work in small increments and will save versions as I go.

Thanks again,

- Byron

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

> On Mar 2, 2026, at 6:18 PM, Liz <edodd at billiau.net> wrote:
> 
> On Mon, 2 Mar 2026 17:14:40 -0800
> Byron Bray <byron at up-and-running.net> wrote:
> 
>> Derek,
>> 
>> I had thought of going back a few years, for the sake of expediency,
>> and then going further back as time allowed. It sounds as if I am
>> better off going back to the first transactions I ultimately want in
>> the GnuCash file and going forward from there. I can keep using
>> Quicken until that process is complete and reconcile the new
>> transactions last.
>> 
>> Thanks,
>> 
>> - Byron
> 
> 
> Byron
> All of this should be done in small quantities, none intended to be the
> main import, while you document what works and what does not.
> 
> You mention several times that you will go back to Quicken and
> unreconcile everything. I do not think that this will achieve anything,
> so please stop and allow all the offered options to sink in and then go
> forward.
> 
> I think the pertinent parts are
> 	Create your chart of accounts (whether imported or manual)
> 	Take a small amount of Quicken data (time wise) 
> 	Import this one account at once to take advantage of the
> 	Bayesian matching tool
> 
> 	Save every step, with a different name each time
> 	I guess its about 30 years since I moved my data, and once it
> 	is done we forget all the little tricks that helped.
> 
> 
> Liz
> _______________________________________________
> 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.