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.
