[GNC] Bulk export/import of transactions?

[sunfish62 at yahoo.com]

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 <eric at ehbowen.net> 
Sent: Saturday, July 6, 2019 9:20 AM
To: D <sunfish62 at yahoo.com>; Gnucash Users <gnucash-user at 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: sunfish62 at yahoo.com
Sent: July 5, 2019 10:14 PM
To: eric at ehbowen.net; gnucash-user at 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 at 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
eric at ehbowen.net <mailto:eric at ehbowen.net>