[GNC] After a long hiatus I'm trying to restart using GNC for my accounting/tax needs. I have some old GNC files, but can't open them correctly.

2020-04-12 Thread John Clark via gnucash-user
I had tediously entered in my checking account transactions, into a 2016 file, 
save it with the ‘log’ files, etc. but now when I open Gnucash, I only see a 
2018 file, which I only had a few entries, I tried ‘importing’ from *.log, but 
that only did one limited thing, resulting in ‘orphan’ label.

How does one recover using the log files, or why isn’t there some ‘master' file 
at some point, of which the incremental log files are just updates?

John Clark.

___
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] Credits and Debits

2019-04-16 Thread John Clark via gnucash-user

> On Apr 15, 2019, at 11:17 PM, AEG via gnucash-user  
> wrote:
> 
> The concept of Credits and Debits confuses most newcomers to GnuCash (it did
> me), so I devised a way to remember which goes where.
> Given that transactions involve the movement of money from one account to
> another...
> 
> (C)redits belong to the (C)ontributing accounts. 
> (D)ebits belong to the (D)estination accounts.
> 
> It has always worked for me.

The labels at the top of my GNC transaction pages are labeled ‘Deposit’ and 
“Withdrawal”. Money comes into the ‘deposit’ column, money ‘disappears’ in the 
‘withdrawal’ column.

When I go to the bank I ‘deposit’ money in my account there, when I withdraw 
money from there, it disappears from my bank account.

I don’t need to change my sense of the ‘names’ depending on the account.

In the case of the credit card accounts, there are Payments (left column, 
putting money in) and Charges( taking money out).

Again the terms all in terms of my view, which is the important view for ‘my 
books’. 

How a bank or a credit card wants to view things, may be different or the 
columns reversed etc, but that need not be my view. And even if the credit card 
company is trying to
sock me for ‘charges’ I didn’t make… or the bank has ‘lost’ money out of my 
account, they need to explain it in terms of ‘my’ view.

I’m pretty thankful GNC did not use ‘debit/credit’ terms and the attendant 
confusion of contextual ‘meaning’, which may be exactly opposite their Latin 
root meanings, at least from
my point of view.



___
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] Need help with a Savings account

2019-04-15 Thread John Clark via gnucash-user

> On Apr 15, 2019, at 4:10 PM, Adrien Monteleone 
>  wrote:
> 
> I wrote a longer reply, but let’s get this out of the way first:
> 
> What makes you think ‘losing money’ = ‘debit’?

Because these terms ‘never make sense’, as seen by this example. It is far more 
simpler to just say, money coming in, on the left, money going out on the 
right… or is the other way around...

I will of course note that I was kicked out of highschool accounting class for 
this and a few other reasons, namely I could give a rats ass about a few cents 
of difference between the right and left columns, whatever the convention.

In the case of the bank, when I put money into ‘my’ account that is an 
increase, and when the bank, at least in the olden days of savings accounts, 
put in interest, again an increase from my perspective, and hence a credit to 
that account for the bank’s ‘use’ of the money.

And if I dispatch dealing with banks, I sure don’t ‘owe’(debit) a cookie jar to 
store my cash, and when I take money out, it sure is no ‘credit’ to the cookie 
jar.


> 
> 
> Regards,
> Adrien
>> 
>> Hi Adrian,
>> 
>> So, when I deposit something to the bank, I am actually
>> losing money (giving it to someone else), so it is a debit?
>> 
>> So I should switch my opening balance to a negative number?
>> 
>> I think I might be going insane.  :'(
>> 
>> Thank you for all your patience with this!
>> 
>> -T
> 
> ___
> 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.


[GNC] Problems importing credit card transactions via CSV formatted file.

2018-06-13 Thread John Clark via gnucash-user
One of the problems I’ve found with gnucash is in the area of importing CSV 
formatted transactions. I figured out how to do it reasonably well for my
bank statements, and now I’m turning my attention to my credit card accounts.

I’m trying to enter in data that spans several years, and I have a collection 
of CSV files. In most cases I don’t have the ability to go back and get 
the data in a different format, such as some sort of Quicken file.

When I import the translations, I use the following selection for columns.

DATE, DESCRIPTION, DEPOSIT (or WITHDRAWAL, I’ve done both)

After the file has been processed, and the screen comes up to commit the 
transactions, there are lines that are Green and Yellow. Some have the 
“Liability:Credit Card:XXX” some have “unbalanced USD” designation.

But worse, there are some numbers that are negative, and some which are 
positive. And when I do import the results, the numbers, negative or positive, 
end up scattered between Payment and Credit columns.

Since I’m trying to import 100s of transactions it is very tedious to even 
think about going through each item and correcting the negative sign, etc.

Since there does not seem to be a ‘bulk’ process for selecting a large number 
of transactions and happing the same transaction assignment on all of the 
selected items, this is a major hiccup in 
using gnucash for me.

Any assistance would be appreciated.

John Clark.

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