Ok. This comes up from time to time. Others may chime in with additional pointers, but here's how I'd go about it.
1) I would change the date of the Opening Balance transaction to the day before your starting date (December 31, 2017 for example), and change the amounts of both lines in this transaction (i.e., both the debit and the credit) to reflect the amount on that date. So, if your checking account April 1 opening balance entry is $500, but your December 31 balance was $350, change the debit and credit amount in the Opening Balance transaction from $500 to $350 and set the date to December 31. 2) I would then enter every transaction in the gap period. 3) I would then take the hopeful step of pulling my *most recent* reconciled statement and trying to re-reconcile. Presumably, the only differences between the previous reconciliation and this pass will be the transactions you entered from the previous gap period, and when you select all these earlier transactions, it should balance out, and you can finish the reconciliation. If this works, then you are done with the process. If for some reason this doesn't work, you'd most likely have to de-reconcile everything then and work through month by month from bank statements, which would pinpoint the discrepancies and allow you to work them out. This, admittedly, is much more painful, and off the top of my head, I cannot think of a simple way to reset the reconcile tag. This is not to say it can't be done; just that I haven't really given it thought. If it were me, I'd probably take the data into an SQL backend, and figure out how to use SQL to change the reconcile flag for that account. Of course, that's a quick way to screw up you data permanently, so if you need to go that route, the usual warnings apply (Work on a backup, damages cannot be fixed by others, etc.) HTH, David T. -----Original Message----- From: Eric H. Bowen <e...@ehbowen.net> Sent: Saturday, July 6, 2019 9:20 AM To: D <sunfis...@yahoo.com>; Gnucash Users <gnucash-user@gnucash.org> Subject: Re: [GNC] Bulk export/import of transactions? My problem stems from the fact that I started the business in April, but was purchasing equipment for it from the beginning of the year. After I had the first few months (April to July) in and reconciled, I belatedly realized that I needed to go back and include my purchase transactions from the first of the year. But since I already had several months reconciled, when I added the earlier transactions I ended up with a mess. If there's any way to reverse the reconciliations as they stand now, I'm not aware of it. That would be preferable to starting over. Sent from my BlackBerry - the most secure mobile device Original Message From: sunfis...@yahoo.com Sent: July 5, 2019 10:14 PM To: e...@ehbowen.net; gnucash-user@gnucash.org Subject: Re: [GNC] Bulk export/import of transactions? Eric, In version 3, there is an export to csv that can be used, I believe. Before you do that however, perhaps you could explain why you say you cannot change or correct the problems? Maybe those problems aren't as intractable as you think. It's been my experience that most any problem can be fixed in Gnucash. David T. On July 6, 2019, at 7:05 AM, "Eric H. Bowen via gnucash-user" <gnucash-user@gnucash.org> wrote: I'm a fairly new GnuCash user, and last year I set up an account for a part-time business which i have doing video work. Unfortunately, being unfamiliar with GnuCash, I made some mistakes while reconciling accounts in the early months which I now cannot change or correct. I'd like to basically start over with a new worksheet, but I spent a lot of time entering split transactions and such in the old one to account for equipment costs and depreciation. I'd rather not re-invent the wheel. Is there a way to bulk export transactions from the old worksheet and then re-import them into the new worksheet which preserves split information and other notes? -- --------Eric H. Bowen e...@ehbowen.net <mailto:e...@ehbowen.net> _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.