Re: [GNC] Exporting Data

[Rogier F. van Vlissingen]

Yes, that worked.

Thinking back, I believe I did that originally when I did it the first time
in v3.8.
Now I wonder why it took me so long to figure it out again, but this is the
way to go, one single opening split transaction and that makes it work, and
if you mess up the difference will show up in imbalance-USD, so you have an
instant check.

thanks.

On Thu, Dec 30, 2021 at 6:00 PM Stephen M. Butler <
stephen.m.butle...@gmail.com> wrote:

> I have never used the opening balances from the wizard.  I setup the COA
> and then enter one multi-split transaction to load all the balances as
> the first transaction in the file.  Looks like you would only have 8
> splits (I have 30-50 in my initial transaction).  Since the transaction
> balances all is good.
>
> Sorry I can't help with the Wizard.
> --Steve
>
> PS.  This also let's me adjust the opening transaction later if I messed
> up and missed an item or later decided to split an account retroactively.
>
> On 12/30/21 14:07, Rogier F. van Vlissingen wrote:
> > in the 3.8 version I had:
> >
> > My Opening balances transaction on 1/1/20 was
> >Debit
> > Credit
> > Assets: Current Assets Checking:$A
> > Assets: Current Assets Advance/Loan:$B
> > Equity: Opening Balances:   $C
> > Equity: Retained Earnings:   $D
> > Liabilities: Credit Card:   $E
> > Liabilities: Officer Loan 1:   $F
> > Liabilities: Officer Loan 2:   $G
> > Liabilities: Officer Loan 3:   $H
> > ---
> >
> > And it all balanced. That is just exactly how simple it is.
> >
> > in 4.9 I have not been able to recreate anything similar. for when you
> edit
> > the accounts, you can enter the opening balance, but not for Retained
> > Earnings.
> >
> >
> >
> >
> >
> > On Thu, Dec 30, 2021 at 4:54 PM Adrien Monteleone <
> > adrien.montele...@lusfiber.net> wrote:
> >
> >> There is nothing special about opening balances. They are just regular
> >> transactions that the fresh start wizard makes for you.
> >>
> >> You should be able to edit those transactions just like any other.
> >>
> >> But I don't understand what the problem is. Even the Retained Earnings
> >> account would have an 'opening balance' entry if you didn't start your
> >> books at zero. Thus the Opening Balance account would very likely
> >> include Retained Earnings. Why do you think it shouldn't?
> >>
> >> Regards,
> >> Adrien
> >>
> >> On 12/30/21 6:01 AM, Rogier F. van Vlissingen wrote:
> >>
> >>> However, now I end up with another problem to which I have yet to
> >> receive a
> >>> satisfactory solution. When setting up the opening balances, the
> retained
> >>> earnings is not allowing editing, so it ends up that the Opening
> Balance
> >>> account now holds the total of the actual opening balances plus an
> amount
> >>> that should be retained earnings. In 3.8 I was able to set this up
> >> properly
> >>> with one opening transaction, but in 4.9 I have not found the way. I
> >> posted
> >>> about it on the list, but so far no usable suggestions. Only another
> user
> >>> having the same problem.
> >>>
> >>> I used gnucash years ago without a problem for some small project, but
> at
> >>> this point , I feel like I am in a total Catch-22. I don't trust 3.8
> >>> anymore and so far 4.9 is letting me down.
> >>>
> >> ___
> >> 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.
> >>
> > ___
> > 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.
>
>
> --
> Stephen M Butler, PMP, PSM
> stephen.m.butle...@gmail.com
> kg...@arrl.net
> 253-350-0166
> ---
> GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
>
> ___
> 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 

Re: [GNC] Exporting Data

[Stephen M. Butler]

I have never used the opening balances from the wizard.  I setup the COA 
and then enter one multi-split transaction to load all the balances as 
the first transaction in the file.  Looks like you would only have 8 
splits (I have 30-50 in my initial transaction).  Since the transaction 
balances all is good.


Sorry I can't help with the Wizard.
--Steve

PS.  This also let's me adjust the opening transaction later if I messed 
up and missed an item or later decided to split an account retroactively.


On 12/30/21 14:07, Rogier F. van Vlissingen wrote:

in the 3.8 version I had:

My Opening balances transaction on 1/1/20 was
   Debit
Credit
Assets: Current Assets Checking:$A
Assets: Current Assets Advance/Loan:$B
Equity: Opening Balances:   $C
Equity: Retained Earnings:   $D
Liabilities: Credit Card:   $E
Liabilities: Officer Loan 1:   $F
Liabilities: Officer Loan 2:   $G
Liabilities: Officer Loan 3:   $H
---

And it all balanced. That is just exactly how simple it is.

in 4.9 I have not been able to recreate anything similar. for when you edit
the accounts, you can enter the opening balance, but not for Retained
Earnings.





On Thu, Dec 30, 2021 at 4:54 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:


There is nothing special about opening balances. They are just regular
transactions that the fresh start wizard makes for you.

You should be able to edit those transactions just like any other.

But I don't understand what the problem is. Even the Retained Earnings
account would have an 'opening balance' entry if you didn't start your
books at zero. Thus the Opening Balance account would very likely
include Retained Earnings. Why do you think it shouldn't?

Regards,
Adrien

On 12/30/21 6:01 AM, Rogier F. van Vlissingen wrote:


However, now I end up with another problem to which I have yet to

receive a

satisfactory solution. When setting up the opening balances, the retained
earnings is not allowing editing, so it ends up that the Opening Balance
account now holds the total of the actual opening balances plus an amount
that should be retained earnings. In 3.8 I was able to set this up

properly

with one opening transaction, but in 4.9 I have not found the way. I

posted

about it on the list, but so far no usable suggestions. Only another user
having the same problem.

I used gnucash years ago without a problem for some small project, but at
this point , I feel like I am in a total Catch-22. I don't trust 3.8
anymore and so far 4.9 is letting me down.


___
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.


___
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.



--
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
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.

Re: [GNC] Exporting Data

[Rogier F. van Vlissingen]

in the 3.8 version I had:

My Opening balances transaction on 1/1/20 was
  Debit
Credit
Assets: Current Assets Checking:$A
Assets: Current Assets Advance/Loan:$B
Equity: Opening Balances:   $C
Equity: Retained Earnings:   $D
Liabilities: Credit Card:   $E
Liabilities: Officer Loan 1:   $F
Liabilities: Officer Loan 2:   $G
Liabilities: Officer Loan 3:   $H
---

And it all balanced. That is just exactly how simple it is.

in 4.9 I have not been able to recreate anything similar. for when you edit
the accounts, you can enter the opening balance, but not for Retained
Earnings.





On Thu, Dec 30, 2021 at 4:54 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> There is nothing special about opening balances. They are just regular
> transactions that the fresh start wizard makes for you.
>
> You should be able to edit those transactions just like any other.
>
> But I don't understand what the problem is. Even the Retained Earnings
> account would have an 'opening balance' entry if you didn't start your
> books at zero. Thus the Opening Balance account would very likely
> include Retained Earnings. Why do you think it shouldn't?
>
> Regards,
> Adrien
>
> On 12/30/21 6:01 AM, Rogier F. van Vlissingen wrote:
>
> > However, now I end up with another problem to which I have yet to
> receive a
> > satisfactory solution. When setting up the opening balances, the retained
> > earnings is not allowing editing, so it ends up that the Opening Balance
> > account now holds the total of the actual opening balances plus an amount
> > that should be retained earnings. In 3.8 I was able to set this up
> properly
> > with one opening transaction, but in 4.9 I have not found the way. I
> posted
> > about it on the list, but so far no usable suggestions. Only another user
> > having the same problem.
> >
> > I used gnucash years ago without a problem for some small project, but at
> > this point , I feel like I am in a total Catch-22. I don't trust 3.8
> > anymore and so far 4.9 is letting me down.
> >
>
> ___
> 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.
>
___
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.

Re: [GNC] Exporting Data

[Adrien Monteleone]

There is nothing special about opening balances. They are just regular 
transactions that the fresh start wizard makes for you.


You should be able to edit those transactions just like any other.

But I don't understand what the problem is. Even the Retained Earnings 
account would have an 'opening balance' entry if you didn't start your 
books at zero. Thus the Opening Balance account would very likely 
include Retained Earnings. Why do you think it shouldn't?


Regards,
Adrien

On 12/30/21 6:01 AM, Rogier F. van Vlissingen wrote:


However, now I end up with another problem to which I have yet to receive a
satisfactory solution. When setting up the opening balances, the retained
earnings is not allowing editing, so it ends up that the Opening Balance
account now holds the total of the actual opening balances plus an amount
that should be retained earnings. In 3.8 I was able to set this up properly
with one opening transaction, but in 4.9 I have not found the way. I posted
about it on the list, but so far no usable suggestions. Only another user
having the same problem.

I used gnucash years ago without a problem for some small project, but at
this point , I feel like I am in a total Catch-22. I don't trust 3.8
anymore and so far 4.9 is letting me down.



___
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.

Re: [GNC] Exporting Data

[Rogier F. van Vlissingen]

Hi, thanks sofar, I have tried literally everything along those lines, and
nothing is doing it, and at this point it is all about ending with
everything right, since I need to do 2021 urgently.

My good luck is that this is about a business that was more or less dormant
for a while, so, I can do the whole year in a long evening, but now I need
to get ready for a better 2022, and I need to get 2020 and 2021 100% right,
plus be sure my accounting system will hold up for a busier 2022. For now,
this is not wanting to happen as I have ended up in a catch-22.

I switched to 4.9, assuming that whatever caused my problem in v 3.8 might
have been fixed. Evidently other users had had the same problem of
reconciliations coming unglued. As I said before, my main problem was not
having exited the program after each reconciliation, for if I had, I would
have had a monthly backup. I did the whole year in one session. Ideally
this time, I would redo it and and exit after every month was reconciled to
have backups throughout.
However, now I end up with another problem to which I have yet to receive a
satisfactory solution. When setting up the opening balances, the retained
earnings is not allowing editing, so it ends up that the Opening Balance
account now holds the total of the actual opening balances plus an amount
that should be retained earnings. In 3.8 I was able to set this up properly
with one opening transaction, but in 4.9 I have not found the way. I posted
about it on the list, but so far no usable suggestions. Only another user
having the same problem.

I used gnucash years ago without a problem for some small project, but at
this point , I feel like I am in a total Catch-22. I don't trust 3.8
anymore and so far 4.9 is letting me down.



On Mon, Dec 27, 2021 at 11:05 PM  wrote:

> Rogier,
>
> Have to agree with Adrien and David Carlson that redoing everything from
> Dec2020
> is the hard way to fix the problem.  If you can identify the transaction(s)
> which were incorrect at that time and then fix then they will be
> unreconciled
> but will appear in the reconciliation window panes at the start and if you
> select them they can be reconciled either to the last reconciled date and
> the
> ending balance at that date or the next period you reconcile. It will mean
> the
> starting balance will be out by the amount of the transactions which were
> unreconciled.
>
> David Cousens
>
>
> On Mon, 2021-12-27 at 18:08 -0500, Rogier F. van Vlissingen wrote:
> > If I want to redo a year, is the only way to redo it to export the data
> and
> > set it up all over again?
> >
> > Or is there another way of rolling back all my reconciliations.
> >
> > Reason is, I seem to have a corruption in my last December (2020), and
> > there appears to be no way to fix it, so it seems I have to redo the
> year.
> > I had no monthly backups as I did the whole year in one session.
> >
> > If this approach is indeed the right one then how do I lose the
> > reconciliations when I export? Do I have to manually fix them when it's
> in
> > .CSV format?
> >
> > Also, I thought I saw somewhere how to export a chart of accounts, but I
> > cannot find it now?
> >
> > <
> >
> http://rogierfentenervanvlissingen.me?promo=email_sig&utm_source=product&utm_medium=email_sig&utm_campaign=gmail_api&utm_content=thumb
> > >
> > Rogier Fentener van Vlissingen 
> >
> > <
> >
> http://rogierfentenervanvlissingen.me?promo=email_sig&utm_source=product&utm_medium=email_sig&utm_campaign=gmail_api&utm_content=thumb
> > >
> > ___
> > 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.
>
> ___
> 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.
>
___
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.

Re: [GNC] Exporting Data

[davidcousens49]

Rogier,

Have to agree with Adrien and David Carlson that redoing everything from Dec2020
is the hard way to fix the problem.  If you can identify the transaction(s)
which were incorrect at that time and then fix then they will be unreconciled
but will appear in the reconciliation window panes at the start and if you
select them they can be reconciled either to the last reconciled date and the
ending balance at that date or the next period you reconcile. It will mean the
starting balance will be out by the amount of the transactions which were
unreconciled.

David Cousens


On Mon, 2021-12-27 at 18:08 -0500, Rogier F. van Vlissingen wrote:
> If I want to redo a year, is the only way to redo it to export the data and
> set it up all over again?
> 
> Or is there another way of rolling back all my reconciliations.
> 
> Reason is, I seem to have a corruption in my last December (2020), and
> there appears to be no way to fix it, so it seems I have to redo the year.
> I had no monthly backups as I did the whole year in one session.
> 
> If this approach is indeed the right one then how do I lose the
> reconciliations when I export? Do I have to manually fix them when it's in
> .CSV format?
> 
> Also, I thought I saw somewhere how to export a chart of accounts, but I
> cannot find it now?
> 
> <
> http://rogierfentenervanvlissingen.me?promo=email_sig&utm_source=product&utm_medium=email_sig&utm_campaign=gmail_api&utm_content=thumb
> >
> Rogier Fentener van Vlissingen 
> 
> <
> http://rogierfentenervanvlissingen.me?promo=email_sig&utm_source=product&utm_medium=email_sig&utm_campaign=gmail_api&utm_content=thumb
> >
> ___
> 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.

___
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.

Re: [GNC] Exporting Data

[Adrien Monteleone]

First: File > Export > Export Account Tree in CSV is what you were 
looking for.


Second: if you have a backup as of 12/31/20 then make it your current 
file and start 2021 over again.


I've never had to do this, so not sure if the reconcile column flag is 
in the transaction CSV, but I suspect it is.


Simply open it in a spreadsheet and select that column and do a 
Find/Replace or a Fill-Down operation and change every transaction to 
'n'. Then when you do your import, they won't be marked reconciled.


Even if they stay marked that way, if you import into a backup copy of 
the 2020 book, it will be missing the actual reconciliations performed, 
so they may come in as simply 'cleared'. ('c')


And I'd suggest importing one month at a time, doing reconciliations, 
making a backup copy for just in case, then proceeding. (in that same 
book) At least then if you mess up again, you don't have to start over 
from 1/1/21.


Third: I can't fathom a case where you can't 'fix' an errant previous 
reconciliation. Did you find the offending transactions yet? What is the 
problem with them?


Regards,
Adrien

On 12/27/21 5:08 PM, Rogier F. van Vlissingen wrote:

If I want to redo a year, is the only way to redo it to export the data and
set it up all over again?

Or is there another way of rolling back all my reconciliations.

Reason is, I seem to have a corruption in my last December (2020), and
there appears to be no way to fix it, so it seems I have to redo the year.
I had no monthly backups as I did the whole year in one session.

If this approach is indeed the right one then how do I lose the
reconciliations when I export? Do I have to manually fix them when it's in
.CSV format?

Also, I thought I saw somewhere how to export a chart of accounts, but I
cannot find it now?


___
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.

Re: [GNC] Exporting Data

[David Carlson]

Usually GnuCash will allow any change to previous transactions, although
some are more difficult if they reside in accounts marked hidden or
placeholder, which may require extra steps or voided transactions also need
to be unvoided.  Almost the only thing that cannot be undone would ba a
transaction or account deletion.  So I cannot envision a need for the
radical surgery that you are proposing.  Even if you need to re-reconcile a
transaction from several months back, sometimes there is a work-around that
will save a lot of labor.  The easiest, of course, would be to simply
reconcile in the next monthly reconcile, allowing the reconciliation date
error to exist, but if there is a need to make that date correct, there are
a couple of ways to do it.  Both ways that I can think of are too complex
for this short email, and I have not actually tried either one.

If you can describe what you need to fix in more detail, someone here may
have a suggestion.

On Mon, Dec 27, 2021 at 5:09 PM Rogier F. van Vlissingen 
wrote:

> If I want to redo a year, is the only way to redo it to export the data and
> set it up all over again?
>
> Or is there another way of rolling back all my reconciliations.
>
> Reason is, I seem to have a corruption in my last December (2020), and
> there appears to be no way to fix it, so it seems I have to redo the year.
> I had no monthly backups as I did the whole year in one session.
>
> If this approach is indeed the right one then how do I lose the
> reconciliations when I export? Do I have to manually fix them when it's in
> .CSV format?
>
> Also, I thought I saw somewhere how to export a chart of accounts, but I
> cannot find it now?
>
> <
> http://rogierfentenervanvlissingen.me?promo=email_sig&utm_source=product&utm_medium=email_sig&utm_campaign=gmail_api&utm_content=thumb
> >
> Rogier Fentener van Vlissingen 
>
> <
> http://rogierfentenervanvlissingen.me?promo=email_sig&utm_source=product&utm_medium=email_sig&utm_campaign=gmail_api&utm_content=thumb
> >
> ___
> 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.
>


-- 
David Carlson
___
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.