Re: [GNC] Newbie Questions

2024-05-23 Thread David Cousens
Joe, The IIF format is a TSV (tab separated format see  https://quickbooks.intuit.com/learn-support/en-us/help-article/list-management/iif-overview-import-kit-sample-files-headers/L5CZIpJne_US_en_US ). You should be able to import them with the gnucash CSV importer which has provision for

Re: [GNC] Newbie Questions

2024-05-23 Thread Mark at Lorimark
Hi Joe, I'm likely stepping way out of my reach here, but, Gnucash will not import from IIF, but you might have success if you can convert your IIF file to a CSV file. Then you can import from that to GnuCash like you would if you had fetched a CSV file from your bank. The 'transaction

Re: [GNC] Newbie Questions

2024-05-23 Thread R Losey
On Thu, May 23, 2024 at 11:45 AM Joe Padavic wrote: > I have a few questions: > > Is there a way to reset the splash page? > I have Quickbook 2021 Pro. > There aren't any QIF files, but I can create IIF files. Can these be used > for importing into GNUCASH? > If so, should I create individual

[GNC] Newbie Questions

2024-05-23 Thread Joe Padavic
I have a few questions: Is there a way to reset the splash page? I have Quickbook 2021 Pro. There aren't any QIF files, but I can create IIF files. Can these be used for importing into GNUCASH? If so, should I create individual IIF files for each type of file to import or can I select all files

Re: [GNC] newbie question

2022-02-07 Thread davidcousens49
Shevach, I think you need to step back and understand the way in which double entry book keeping/accounting works. There is a section labellsed basic in the Tutorial and Concepts Guide which explains the basic concepts. https://www.gnucash.org/docs/v4/C/gnucash-guide/chapter_basics.html.

Re: [GNC] newbie question

2022-02-07 Thread Fred Bone
On 06 February 2022 at 22:32, Shevach Pepper said: > 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

Re: [GNC] newbie question

2022-02-07 Thread Alan A Holmes
vach Pepper Sent: 06 February 2022 20:32 To: gnucash-user@gnucash.org Subject: [GNC] newbie question 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

[GNC] newbie question

2022-02-06 Thread 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

Re: [GNC] Newbie question

2021-09-27 Thread Steve Welch via gnucash-user
switched to non-digest. Still getting used to the mail listserve. It’s been a minute since I was on one of these :) Steve > > -- > > Message: 2 > Date: Sat, 25 Sep 2021 21:59:34 -0400 > From: Steve Welch > To: gnucash-user@gnucash.org > Subjec

Re: [GNC] Newbie question

2021-09-26 Thread Steve Welch via gnucash-user
Thanks Michael! Yep, makes total sense (I do accounting work as part of my day job, so I understand double entry). I played around with making an opening balance entry, but things are still way off. Sigh. Now I’m gonna have to get creative and figure out what didn’t import correctly via

Re: [GNC] Newbie question

2021-09-26 Thread William Prescott
One quirk I noticed about opening balances is that that account seemed to be locked. When setting up a new account you could set the opening balances, but you couldn't change them later. I had to go into the account editor and unlock the opening balances account. Will On 2021 Sep 26, at 09-26

Re: [GNC] Newbie question

2021-09-26 Thread Jack Frillman via gnucash-user
Steve, I switched from Moneydance as you did about six months ago. The conversion went fine for me except the account balances were off. To correct for that I just went to each account that was off and entered an opening balance, at the very beginning of the ledger, for the amount that was

Re: [GNC] Newbie question

2021-09-26 Thread Fross, Michael
Hello Steve. Welcome to GnuCash! While I'm not an expert, in my experience, an opening balance is just a normal transaction. There are typically two splits. (1) is a deposit into the account, and (2) is a withdrawal from the Equity:Opening Balances account. Remember GnuCash used double entry

[GNC] Newbie question

2021-09-26 Thread Steve Welch via gnucash-user
Hi! I’m just getting started with GnuCash and have imported my QIF file from Moneydance. Excited to take it for a spin! My question is regarding beginning (opening) account balances. Moneydance has an opening balance field in the account setup window, but evidently that field isn’t

Re: [GNC] [newbie] Import transactions - column for both withdrawal and deposit?

2019-12-13 Thread David Cousens
Anton, The Deposit column generally works with bank account data with a single column and positive and negative values. GnuCash will import both the debits and credit information. David Cousens - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html

[GNC] [newbie] Import transactions - column for both withdrawal and deposit?

2019-12-13 Thread Anton Hughes
Hello I'm trying to import my bank transactions, and generally this is working well. However, in the import wizard, on Import Preview screen, I'm asked to "select a deposit or withdrawal column". The problem is, the csv provided from bank has a single column for both. A deposit is a positive

Re: [GNC] Newbie Q: match Description to Transfer

2019-09-08 Thread Adrien Monteleone
Run a transaction report on just that account. In Options > Sorting, set either the primary or secondary key to ‘Description’ and optionally show subtotals. Regards, Adrien > On Sep 8, 2019 w37d251, at 5:19 PM, Bitmancer > wrote: > > Thanks again, David. > > I am using v3.6 from the Arch

Re: [GNC] Newbie Q: some transactions imported to wrong category

2019-09-08 Thread Bitmancer
Thank you again, David. I fear I have taken a double dose of Stupid with my Brunch. I understand double-entry accounting, more or less. I will RTFM in the Loans area. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___

Re: [GNC] Newbie Q: match Description to Transfer

2019-09-08 Thread Bitmancer
Thanks again, David. I am using v3.6 from the Arch Linux distro. I finally figured out *almost everything* that I complained about. Now I would like to compare my expenses at two grocers. My Expenses:Groceries ledger combines them financially.

Re: [GNC] Newbie Q: match Description to Transfer

2019-09-08 Thread Bitmancer
Liz, I am using Arch Linux 5.2.10 with GnuCash 3.6 Build ID: 3.6+(2019-06-29) Regards, Bitmancer -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your

Re: [GNC] Newbie Q: match Description to Transfer

2019-09-07 Thread David Cousens
Liz, Bitmancer There are modifications to the import matcher docs in progress which have the double clicking to modify a transfer account incorporated in them. The behavior is the same as in the register for changing the account for a split. AFAIK the behavior hasn't changed since the early

Re: [GNC] Newbie Q: match Description to Transfer

2019-09-07 Thread Liz
On Sat, 7 Sep 2019 16:53:12 -0500 (CDT) Bitmancer wrote: > That did the trick. I split everything by month! > > Then I learned that by DOUBLE CLICKING on an account, I could change > it from > UNRECONCILED "Imbalanced-XXX" where XXX is a currency > to the correct Expense. > Nowhere in the

Re: [GNC] Newbie Q: some transactions imported to wrong category

2019-09-07 Thread David Cousens
In the screen shot both of the lines of the transaction (splits in Gnucash parlance) have accounts which are expense accounts. GnuCash is a double entry system so when you make a payment for a purchase money is taken out of your checking or savings account and given to the bank and this appears

Re: [GNC] Newbie Q: some transactions imported to wrong

2019-09-07 Thread Bitmancer
That was the solution to a previous problem as well! THANKS ChrisGood wrote > Message: 10 > Date: Sat, 7 Sep 2019 18:23:02 -0500 (CDT) > From: David Cousens > davidcousens@ > > To: > gnucash-user@ > Subject: Re: [GNC] Newbie Q: some transactions imported t

Re: [GNC] Newbie Q: some transactions imported to wrong category

2019-09-07 Thread Bitmancer
Thank you for your timely answer, David. Responses in context: David Cousens wrote > ..., it will open to display > both splits of the transaction on separate lines. If you click on the > account you wish to change a down arrow appears on the right handside and > clicking on that will open an

Re: [GNC] Newbie Q: some transactions imported to wrong

2019-09-07 Thread Chris Good
Message: 10 Date: Sat, 7 Sep 2019 18:23:02 -0500 (CDT) From: David Cousens To: gnucash-user@gnucash.org Subject: Re: [GNC] Newbie Q: some transactions imported to wrong category Message-ID: <1567898582174-0.p...@n4.nabble.com> Content-Type: text/plain; charset=us-ascii Bitmancer,

Re: [GNC] Newbie Q: some transactions imported to wrong category

2019-09-07 Thread David Cousens
Bitmancer, If you open the regster for the account to which you imported the transactions. If you set the preferences using Edit->Preferences->Register defaults and set the Auto-split register radio button when you click on a transaction line, it will open to display both splits of the

[GNC] Newbie Q: some transactions imported to wrong category

2019-09-07 Thread Bitmancer
All of my Natural Gas utility payments got imported to my Cell Phone category. One of my Mortgage Payments got imported to Auto Insurance category. How can I correct their categories in GnuCash? Thanks for any help. (I am semi-perl-literate, and can run perl scripts against xml extractions if

Re: [GNC] Newbie Q: match Description to Transfer

2019-09-07 Thread Bitmancer
That did the trick. I split everything by month! Then I learned that by DOUBLE CLICKING on an account, I could change it from UNRECONCILED to the correct Expense. Nowhere in the online docs that I read does it say to DOUBLE CLICK. I would recommend that we alter the docs to fix this! -- Sent

Re: [GNC] Newbie Q: match Description to Transfer

2019-09-04 Thread Ike Stoddard
I get it. I have to create a training session of sorts. January ought to do it. I will try that tomorrow. Thanks to both of you, David Carlson and Greg Feneis. On Tue, Sep 3, 2019 at 8:43 PM Greg Feneis wrote: > Perhaps, before importing, add a "Groceries" sub account to your expenses >

Re: [GNC] Newbie Q: match Description to Transfer

2019-09-03 Thread Greg Feneis
Perhaps, before importing, add a "Groceries" sub account to your expenses account. Then, instead of importing the entire checking account from your bank, just import a month's worth of records or so. In the matcher step, assign transfer accounts accordingly. Then import the remaining records for

Re: [GNC] Newbie Q: match Description to Transfer

2019-09-03 Thread David Carlson
Welcome to GnuCash and to the GnuCash-User Maillist. GnuCash is set by default to "remember" the transfer account assignment and to attempt to make the same assignment to similar looking transactions in future imports. It uses a process called Bayesian Matching, which is not perfect, but it

[GNC] Newbie Q: match Description to Transfer

2019-09-03 Thread Bitmancer
Just starting out to use GnuCash. Imports fine from my bank to my Checking account. Now I have to make sense of it all! In the Checking ledger, there are many different creditors. For example, "Kroger" in the Description field. How can I label all "Kroger" entries with "Expenses:Groceries" in

Re: [GNC] Newbie

2019-08-08 Thread Mike or Penny Novack
On 8/8/2019 6:47 AM, S. Sliackus wrote: Hi guys I am new to GnuCash. I came up with this piece of software by searching practical solution to couple of my charities and small business. I have quite mixed feelings about this program, I found some things over complicated (some invoicing aspects,

Re: [GNC] Newbie

2019-08-08 Thread Rich Shepard
On Thu, 8 Aug 2019, S. Sliackus wrote: As a new user, I didn't learned how to achieve certain tasks yet, so my feedback might not be relevant sometimes, but that is why I came here and I hope this will be right place to get and give an advice :-) Have you read the help/tutorial or guide?

[GNC] Newbie

2019-08-08 Thread S. Sliackus
Hi guys I am new to GnuCash. I came up with this piece of software by searching practical solution to couple of my charities and small business. I have quite mixed feelings about this program, I found some things over complicated (some invoicing aspects, customer list and search, transactions