[GNC] Bulk export/import of transactions?

[Geert Janssens]

Op zaterdag 6 juli 2019 08:01:30 CEST schreef sunfish62--- via gnucash-user:
> 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.

That's actually really simple: you click on each "Y" in the reconcile column 
to unreconcile a transaction. You will get a warning for what you are about to 
undo. If you have many to unreconcile, save your choice for the current 
session so the warning will not continue to pop up while you're resetting.

If you don't get this warning and instead can't unreconcile, that probably 
means you have in the past told gnucash to not carry on with the action and 
remember that decision for the future. That warning can then be reset via 
Actions->Reset warnings.

Do note that this may give unexpected starting balances on the next 
reconciliation action. Normally whatever gnucash proposes a starting balance 
should be kept. Only the ending balance on the reconcile date should be set to 
what is on the bank statements.

Regards,

Geert