Re: [GNC] How to handle multiple entries of multiply reconciled entries

[Jeff]

On 2/3/22 10:07 AM, Alan A Holmes wrote:

Hi Jeff,

Did you take a copy of the database before you upgraded to version 4.9. If so 
you could take a copy of this backup and open that in version 4.9, which might 
tell you if the corruption existed before upgrading to version 4.9.

Do you have anyway of finding out which version you had before version 4.9? Was 
it another flatpack version, or was it the version as part of Ubuntu 20.04 LTS? 
That version might still be available on your machine, or you could re-install 
that version, which would allow you to look at any backup copy before upgrading 
to version 4.9 in that version to see if the corruption existed.

You could also look at any/all backup copy taken automatically by version 4.9 
to see if the corruption exists. This depends on how many days of backups/logs 
you have specified should be kept in the settings. This might show when the 
corruption first started.

If you can find a backup copy that isn't corrupted then you could start with 
that copy and then either manually enter all transactions since then, or use 
the log files created since then to re-apply a subset of transactions (I think 
I remember a thread somewhere that said you can be selective in which 
transactions to re-apply).


Alan A Holmes

-Original Message-
From: gnucash-user  
On Behalf Of Jeff
Sent: 03 February 2022 07:43
To: Gnucash userlist 
Subject: [GNC] How to handle multiple entries of multiply reconciled entries

How I did this is beyond me, somehow I confused GNC to let it happen or had a 
data corruption when the journal was improperly saved (power outage, GNC lost a 
poker game, thought it was Quirken, etc).  I use uncompressed XML on Ubuntu 
20.04LTS.

I have discovered multiple (dozens) of transactions that are duplicates in 
several registers but; reconciled to the wrong accounts.  I am not sure of the 
easiest and proper way to correct them.

Example of the simplest ones are:  using Check 101, Cash, salary.

01/01/10 chk 101 -> Cash -> chk 101 reconciled

01/01/10 chk 101 -> salary -> salary reconciled

These are posted as 2 entirely separate transactions, in the same register, but 
are supposed to be only one transaction:

01/01/10 chk 101 -> salary -> both reconciled

As a result my current balance is now off by off by over $4,000.

And the real kicker, is that these errors now go back 3 years in this journal.  
I know these errors did not exist prior to FlatPak 4.9, not sure which version 
I upgraded from to 4.9.  Plus they would have shown up when I did reports for 
taxes and income expense statements last year.

Suggestions, besides burning more midnight oil than this old man has left, 
other than to delete all of them and enter all of them correctly as I find 
them.  I'm in tax time crunch here.

--
--JEffrey Black M.B.A.

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

.


I always make a backup before doing an upgrade, unfortunately I deleted 
it some time after upgrading as I believed that everything was working 
as it should.  I do not remember what version I used prior to FlatPak 
4.9.  I want to say 4.2 but I'd be lying if I said I knew that for sure.


As for the log copies I only keep 7 days worth and I have the bad habit 
of running GNC multiple times on any given day.  I could try loading the 
oldest one and see if the problem is still there.


It may be that I got the backups mixed up while trying to build 4.9 from 
source.  I have yet to successfully create a version that runs.


--
--JEffrey Black M.B.A.

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

[GNC] newbie question

[Shevach Pepper]

Hello there,
I have two accounts: income (n.ya.) and cash (my pocket)
I got payed $500 from n. ya. and the money is  now in "my pocket".
My problem is when I record in n. ya. charge $500 and in the transfer
column 'my pocket" it records it as a "spent" right hand column.
I just can't figure out why it is like this: According to my logic if it
goes out of income then it should be received by "my pocket"
Can someone help me to figure out my mistake?
Thanks a lot
Shevach
___
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.

[GNC] Flatpak 4.9-2 Online Quotes not working (name resolution issue?)

[Guille Lopez]

Hello,

Since I updated to GnuCash Flatpak 4.9-2 I cannot get the Online quote 
retrieval to work. Reverting to Flatpak 4.9-1 fixes de problem.

I tried to do a little bit of "debugging" starting the /bin/sh inside the 
Flatpak and running some network-related commands (not much is available though).

- In 4.9-1  "wget google.com" returns 200 OK
- In 4.9-1  "wget 172.217.18.110" return 200 OK
- in 4.9-2  "wget google.com" returns "unable to resolve host address 
‘google.com’"
- In 4.9-2  "wget 172.217.18.110" return 301 Moved permanently and then "unable to 
resolve host address ‘www.google.com’".
- In 4.9-2  "wget 192.168.X.Y(local network)" return 200 OK so the network 
seems to be working.

It looks to me that the name resolution is not working properly. Normally I 
would assume this to be a problem linked Flatpak installation rather than 
GnuCash but when I upgrade/downgrade for debugging only the GnuCash Flatpak is 
changing.

Does anyone have any idea about this issue? I am reluctant to raise a bug yet 
since I cannot really exclude my own environment here...

Thanks!
Guille
___
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.

[GNC] CPA recommendations for California S-corp

[Mark Hedges via gnucash-user]

Hi... apologies if it's not right to ask for recommendations.  The list FAQ
doesn't say it's prohibited.  Can anyone recommend a CPA experienced with
S-corporations and California tax returns who can use GnuCash?  I just got
a 50 hour/week gig so I'm going to fall even further behind than I was
before.  Thanks.
--
Mark Alan Hedges
CEO Weird Vibe Inc.
+1 (310) 487-7123
https://weirdvibe.media 
___
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] Starting a new file

[Tommy Trussell]

Another option is to let the start of each account correspond to the
NEAREST statement BEFORE the beginning of the year. For example, you might
have one statement that ends December 31st, but another that ends December
15th and yet another that ends December 12th.

Start each account at the beginning of the next relevant statement. The
first account is easy because you'll start January first, the next has all
transactions starting December 16th, and the final example has all
transactions starting on December 13th.  The latter two accounts will have
transactions duplicated in the old and the new data files.

You're the only one who will be seeing any of these so save yourself some
mental energy! As long as you have the opening balances correct, GnuCash
will do the right things regarding reports.

(The same is true for your old data file, which you are presumably
archiving; to enable you to validate all the final statements and run
reports you can put a few transactions into the next year and be certain
the statements reconcile. It's a small amount of double work, but depending
on your circumstances might avoid potential errors.)

Just be sure you name your files clearly so you don't accidentally keep
entering data into your archived file. You might also consider changing
permissions on the old data file or moving it to a read-only medium so you
won't accidentally change old transactions.

On Fri, Feb 4, 2022 at 2:47 PM Gyle McCollam  wrote:

> You will have to create your own ending balance for 2021.  Review the
> statement and find the balance on the statement at 12/31/2021or
> add/subtract the entries up to and including 12/31/2021 to arrive at the
> balance.  That number will become your starting balance for 2022 as well.
> You can use the ending balance on the statement when you reconcile 2022.
>
> 
> From: gnucash-user  on
> behalf of Seth Burgess 
> Sent: Friday, February 4, 2022 3:26 PM
> To: gnucash-user@gnucash.org 
> Subject: [GNC] Starting a new file
>
> I have been using GnuCash for about 10 years.  I am currently using
> Build ID: 4.6+(2021-06-26).  I have decided to start fresh with a new
> file and discontinue an old one with the same bank accounts starting on
> January 1, 2022.  I have one bank account that does not end the month on
> December 31st and one that does. For the account that does not end the
> month on December 31st, I have divided the statement that starts
> December 21st and ends January 20th so that the transactions are split
> between the old account file and the new one.  The transactions are
> correctly entered in each file, but the reconciliation of the statement
> does not balance using the statement ending balace, because some of the
> transactions are in the old file and some in the new file.  This means
> the reconciliations in each file cannot be finalized.  This will cause a
> problem going forward, particularly with the new file.  I don't know how
> to handle this.
>
> thanks in advance for ideas.
>


> -
> 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] Managing multiple vehicles

[Michael or Penny Novack]

Actually I just stumbled on another problem, maybe you could clear
something for me?
>From what I can tell,  I'll place COGS of a certain fixed asset that were
payed in cash under expenses on GnuCash, like "expenses:cow feed" for
example. And these expenses would constitute a transaction listed on that
specific asset account, say Cows. Am I right?


No, and this means not understanding accounting basics. I'll start by 
explaining that the cow feed would be an expense and NOT under a fixed 
asset account for "cows". But to make this less involved with 
complications, let's for the moment stick with a fixed asset that cannot 
reproduce.


You buy a tractor. That is not immediately and expense (in accounting) 
but buying a fixed asset (exchange of one kind of asset, cash, for 
another, tractor). The tractor has a finite useful life, wears out over 
time, so it depreciates. The depreciation is how what you paid for the 
tractor becomes an expense, only over time. The rate at which you 
depreciate the tractor in your books will be determined by the tax laws 
of your jurisdiction as applied to farming, not the reality of its 
useful life.



As for the other part of your answer, about CoA hierarchy, I might be
fundamentally wrong, but from my point of view having an expenses account
for "gas" or "auto:gas" makes a lot more sense than making one for each of
the 10 vehicles, as I would have 30 different gas accounts when they are
the same thing, and isn't that what I need from an accounting point of
view, gas expenses? Now from a managerial point of view, I'd be interested
in knowing each car expenses on gas. That's why I mentioned categories (or
tags, etc...), In a sense that I would have a much cleaner CoA and still be
able to get the information I need for managerial purposes.


EXACTLY --- how you structure your CoA depends on what information you 
want/need appearing on reports. If you have the fuel expense broken down 
by vehicle you can have that information. You can report all the expense 
for a vehicle if you have all its expenses grouped that way and you can 
report on all your fuel use reported if grouped that way. Your CoA can 
have only one hierarchy structure but your reports (say an 
income/expense report) can produce a report for say "all fuel expense" 
(include JUST the fuel accounts) or "just expenses for tractorA" 
(include just those accounts).


I'm sorry, but you are just at the start. You are going to need to get 
"accounting 101" knowledge and then "as applied to farms" knowledge. An 
accounting package like gnucash can automate much of the data entry and 
we can give you "how to" advice but not the "what to do" advice about 
how to set up your books for farming and what reports you will need for 
your jurisdiction. Or, you need the professional services of an 
accountant who does farms (there is a lot that is different from other 
businesses -- for example, fixed assets in almost all other businesses 
cannot reproduce and the few exceptions like "timber land management" 
also have special rules).


Michael D Novack


--
There is no possibility of social justice on a dead planet except the equality 
of the grave.

___
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] Managing multiple vehicles

[Fernando Castro]

Thanks David, I believe I just send a message talking about this, but you
summed it up perfectly.

I wasn't subscribed at the time I wrote my forst question so I wasn't
getting any of your answers. Still getting the hang of this mail list...

Fernando Castro
___
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] Managing multiple vehicles

[Fernando Castro]

Thanks for the answer Michael.

Yes I have been reading about accounting and farm specifics and will
continue to do so as I know I need a better understanding of both.

I'll definitely look into creating fixed assets accounts for the vehicles.
Actually I just stumbled on another problem, maybe you could clear
something for me?
>From what I can tell,  I'll place COGS of a certain fixed asset that were
payed in cash under expenses on GnuCash, like "expenses:cow feed" for
example. And these expenses would constitute a transaction listed on that
specific asset account, say Cows. Am I right?
If so, how would that relate to my "cash" account? I mean, the money did
come out of there. And more important, what if these expenses were payed
from 2 different accounts?

As for the other part of your answer, about CoA hierarchy, I might be
fundamentally wrong, but from my point of view having an expenses account
for "gas" or "auto:gas" makes a lot more sense than making one for each of
the 10 vehicles, as I would have 30 different gas accounts when they are
the same thing, and isn't that what I need from an accounting point of
view, gas expenses? Now from a managerial point of view, I'd be interested
in knowing each car expenses on gas. That's why I mentioned categories (or
tags, etc...), In a sense that I would have a much cleaner CoA and still be
able to get the information I need for managerial purposes.

Regards,

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