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