Re: : importing

[Dennis West]

Maybe I was just lucky, but I selected the first choice in the QIF 
export which was all accounts including categories and it did it all in 
one pass (and that was for a file that had 20 years of data, 3 banks 
with checking and savings in each and 4 credit cards).


I fully expected to have to break the file into several separate exports 
like you're referring to but figured it was worth a try. I've been using 
the result now for several months and have yet to discover any errors.


DW


On 3/11/2018 18:32, David Carlson wrote:

Welcome to GnuCash!

Since you have already found the qfx importer you are almost there.  Each
QIF file contains only transactions from one financial institution and
probably only for one or two accounts.

You simply follow the steps that appear after starting the importer.  It
will first ask you which account or accounts you want the transactions to
apply to if it has never seen a file from that bank, then it will create a
list of all the new transactions and try to get you to decide where you
want them to go.  Finally it will actually import them when you click ok.

If you are unsure which other account to assign, leave the transaction
unassigned so you can fix it later.

I always save my data just before any import so I can go back and try again
if I decide that I made a mistake.

Good luck!

David C

On Sun, Mar 11, 2018, 4:24 PM Beri Hull  wrote:


Hi, I am new to gnucash and want to import data from my various bank and
investment accounts that I have imported to finder as qfx files.  I  am
able to import  data as qfx  files that appear listed in a box titled
generic import transaction matcher.I need the transactions imported
into  my register.  I have tried dragging,  clicking and cannot figure out
how to get them there.   I have found not one instruction, forum discussion
or video that  explains how to get the transactions into the proper gnucash
accounts.  To do this  must be so simple that it has escaped me.


Neri
___
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: : importing

[Dennis West]

Maybe I was just lucky, but I selected the first choice in the QIF 
export which was all accounts including categories and it did it all in 
one pass (and that was for a file that had 20 years of data, 3 banks 
with checking and savings in each and 4 credit cards).


I fully expected to have to break the file into several separate exports 
like you're referring to but figured it was worth a try. I've been using 
the result now for several months and have yet to discover any errors.


DW


On 3/11/2018 18:32, David Carlson wrote:

Welcome to GnuCash!

Since you have already found the qfx importer you are almost there.  Each
QIF file contains only transactions from one financial institution and
probably only for one or two accounts.

You simply follow the steps that appear after starting the importer.  It
will first ask you which account or accounts you want the transactions to
apply to if it has never seen a file from that bank, then it will create a
list of all the new transactions and try to get you to decide where you
want them to go.  Finally it will actually import them when you click ok.

If you are unsure which other account to assign, leave the transaction
unassigned so you can fix it later.

I always save my data just before any import so I can go back and try again
if I decide that I made a mistake.

Good luck!

David C

On Sun, Mar 11, 2018, 4:24 PM Beri Hull  wrote:


Hi, I am new to gnucash and want to import data from my various bank and
investment accounts that I have imported to finder as qfx files.  I  am
able to import  data as qfx  files that appear listed in a box titled
generic import transaction matcher.I need the transactions imported
into  my register.  I have tried dragging,  clicking and cannot figure out
how to get them there.   I have found not one instruction, forum discussion
or video that  explains how to get the transactions into the proper gnucash
accounts.  To do this  must be so simple that it has escaped me.


Neri
___
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: : importing

[David Carlson]

Welcome to GnuCash!

Since you have already found the qfx importer you are almost there.  Each
QIF file contains only transactions from one financial institution and
probably only for one or two accounts.

You simply follow the steps that appear after starting the importer.  It
will first ask you which account or accounts you want the transactions to
apply to if it has never seen a file from that bank, then it will create a
list of all the new transactions and try to get you to decide where you
want them to go.  Finally it will actually import them when you click ok.

If you are unsure which other account to assign, leave the transaction
unassigned so you can fix it later.

I always save my data just before any import so I can go back and try again
if I decide that I made a mistake.

Good luck!

David C

On Sun, Mar 11, 2018, 4:24 PM Beri Hull  wrote:

> Hi, I am new to gnucash and want to import data from my various bank and
> investment accounts that I have imported to finder as qfx files.  I  am
> able to import  data as qfx  files that appear listed in a box titled
> generic import transaction matcher.I need the transactions imported
> into  my register.  I have tried dragging,  clicking and cannot figure out
> how to get them there.   I have found not one instruction, forum discussion
> or video that  explains how to get the transactions into the proper gnucash
> accounts.  To do this  must be so simple that it has escaped me.
>
>
> Neri
> ___
> 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: : importing

[Adrien Monteleone]

Does File > Import > Import OFX/QFX not work for you?

For instructions, visit gnucash.org. Click the documentation link on the left. 
Read over the Help Manual and the Tutorial & Concepts Guide.


Regards,
Adrien

> On Mar 10, 2018, at 8:59 AM, Beri Hull  wrote:
> 
> Hi, I am new to gnucash and want to import data from my various bank and 
> investment accounts that I have imported to finder as qfx files.  I  am able 
> to import  data as qfx  files that appear listed in a box titled generic 
> import transaction matcher.I need the transactions imported  into  my 
> register.  I have tried dragging,  clicking and cannot figure out how to get 
> them there.   I have found not one instruction, forum discussion or video 
> that  explains how to get the transactions into the proper gnucash accounts.  
> To do this  must be so simple that it has escaped me.
> 
> 
> Neri
> ___
> 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: Save File to Dropbox

[Dave H]

If you're talking about not being able to see it under "Places"on the left
of the file open popup form, you have to build up the path manually in
Windows anyway :-)

Click on "Windows C:" under places, then double-click "Users" in the right
hand panel, then double-click your user name in the right hand panel - keep
doing this until you've navigated to Dropbox and whatever folder in Dropbox
you saved your data file in, select it and click open.

I have a similar setup using Dropbox on a number of laptops running
Windows, MacOS and Ubuntu, only I use a file synchroniser (FreeFileSync) to
sync only my GnuCash data file between pc's as I can't be bothered synching
all the log files etc that go with it.

I also sync my saved report configurations and preferences separately.

Cheers Dave H.


On 11 March 2018 at 06:29, EMDNP via gnucash-user 
wrote:

> I would like to save my GnuCash files to dropbox so I can edit across both
> my
> Macbook and my PC.
>
> Saving to Dropbox hasn't been a problem on my Macbook.  I am able to simply
> select the Dropbox folder in the file tree when opening or saving from
> GnuCash.  GnuCash on my PC does not show the same parent file list as my
> Macbook, Dropbox isn't on the list.  It only shows C: and shortcuts to
> desktop, etc.  I can clearly see dropbox in my normal Windows File Explorer
> but not GnuCash.
>
> How can I save to or open from Dropbox in GnuCash on PC?
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> 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: Updated Ubuntu / Mint repository

[Kurt Padilla]

Yes. Seems to work well on Ubuntu 17.10, although for all I know my book
just got uploaded to somewhere in eastern Europe. таке життя!

Kurt

On Wed, Mar 7, 2018, 17:27 Les  wrote:

> Has anyone tried this?
>
> Les
>
>
> On 03/06/2018 09:36 PM, Adrien Monteleone wrote:
> > Sweet!
> >
> > Very timely for me. Thanks.
> >
> >
> > Regards,
> > Adrien
> >
> >> On Mar 6, 2018, at 6:48 PM, Plutocrat  wrote:
> >>
> >> Your mileage may vary. Use at your own risk.
> >> Etc.
> >>
> >> ... but someone has produced a repo of the latest .19 release if anyone
> is feeling like experimenting.
> >>  https://launchpad.net/~ubuntuhandbook1/+archive/ubuntu/gnucash
> >>
> >> Builds for 16.04, 17.04, 17.10, and (presumably beta) 18.04
> >>
> >> P.
> >> ___
> >> 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.
>
-- 

Sent from the Google Inbox Android app. GnuPG encryption available upon
request.
___
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: Save File to Dropbox

[Nelson Handcock]

I use Dropbox for my GN file and I've had no trouble.

I installed the dropbox app for Windows 10, set up the account and
specified which dropbox folders to synch, and I could see the dropbox
folder in Windows Explorer and also the GN file - no problems at all.

Perhaps open the dropbox app on your Windows PC and check all the settings,
etc...

I usually open my GN file by just double-clicking on the Gnucash app - it
automatically opens the last file (which is my case is the one on the
dropbox folder). Occasionally I've had to open an archive file - and I just
double-click on the file in Windows Explorer.


HTH...

​
___
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: Income shows as negative

[Mike or Penny Novack]

On 3/11/2018 3:14 AM, D wrote:

Hello,

Although I am *not* an accountant, I understand that in standard accounting, 
income is shown as a negative balance. The Tutorial covers this.

There is a setting that allows you to display income accounts with reversed 
signs, if this bothers you.

"debit" and "credit" have the opposite sense in the same way as 
"positive" and "negative" do but are not the same thing UNLESS you have 
specified that. In traditional accounting "negative" refers to an 
account having a balance in the opposite sense of what is expected. For 
example, a credit balance in an account normally debit or a debit 
balance in an account normally credit.


An account of type "income" would normally have a credit balance.

Michael D Novack
___
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: Importing Quicken

[mahon . finbar]

Me too. I closed off 2017 in Q and used bank balances etc., to start Gnucash on 
1.1.2018. 

No issues. 

On March 11, 2018 10:27:29 AM GMT+01:00, keithwjones  
wrote:
>Edward Ingram-2 wrote
>> My Quicken files are stored in .QDF format, not .QIF. (Quicken 2017)
>> How can I import these? 
>
>I found it easier to just start again with GnuCash instead of importing
>data
>that I did not require. You then have a nice new clean set of accounts.
>
>
>Keith
>
>
>
>
>-
>GnuCash 2.6.19 - Windows 10
>--
>Sent from:
>http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
>___
>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.

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
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.

Save File to Dropbox

[EMDNP via gnucash-user]

I would like to save my GnuCash files to dropbox so I can edit across both my
Macbook and my PC.  

Saving to Dropbox hasn't been a problem on my Macbook.  I am able to simply
select the Dropbox folder in the file tree when opening or saving from
GnuCash.  GnuCash on my PC does not show the same parent file list as my
Macbook, Dropbox isn't on the list.  It only shows C: and shortcuts to
desktop, etc.  I can clearly see dropbox in my normal Windows File Explorer
but not GnuCash.  

How can I save to or open from Dropbox in GnuCash on PC?



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.

: importing

[Beri Hull]

Hi, I am new to gnucash and want to import data from my various bank and 
investment accounts that I have imported to finder as qfx files.  I  am able to 
import  data as qfx  files that appear listed in a box titled generic import 
transaction matcher.I need the transactions imported  into  my register.  I 
have tried dragging,  clicking and cannot figure out how to get them there.   I 
have found not one instruction, forum discussion or video that  explains how to 
get the transactions into the proper gnucash accounts.  To do this  must be so 
simple that it has escaped me.


Neri
___
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: Income shows as negative

[Stan Brown]

On 2018-03-10 22:48, am wrote:
> I just finished setting up gnuCASH and found that after entering 
> income (and other date ie expenses, etc) it shows up as negative(in
> parenthesis). This would mean a negative income? Why would it not
> show as expected - POSITIVE income since there was no loss. Is this
> how accounting works? What am I missing?
Accounting as you learned it sounds like I learned it:
Debits = Credits (or Debits - Credits = 0)
Assets + Expenses = Liabilities + Equities + Income
Most transactions increase the values of the accounts. For example, if
you buy something for $100 on credit, both Assets and Liabilities
increase by $100.

But GnuCash, instead of having a balance like that, instead sets up
Debits + Credits = 0
Assets + Expenses + Liabilities + Equities + Income = 0
If you buy something on credit, Assets increase by $100 and Liabilities
decrease by $100 -- i.e, Liabilities become more negative, and -400 is
less than -300.

You can make this go away, mostly, in Edit » Preferences » Accounts.
Under "Reverse Balance Accounts", select "credit accounts".

You'll get used to this after a while.

Unfortunately, some reports don't honor this preference, or their
treatment of it is buggy, so they will show credit accounts as negative
after you make this change. Income Statement and Balance Sheet reports
get it right; the General Ledger report (as opposed to the General
Ledger tool) puts the wrong sign on totals.

-- 
Regards,
Stan Brown
Tompkins County, New York, USA
http://BrownMath.com
http://OakRoadSystems.com

___
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: Importing Quicken

[keithwjones]

Edward Ingram-2 wrote
> My Quicken files are stored in .QDF format, not .QIF. (Quicken 2017)
> How can I import these? 

I found it easier to just start again with GnuCash instead of importing data
that I did not require. You then have a nice new clean set of accounts. 

Keith




-
GnuCash 2.6.19 - Windows 10
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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: GnuCash 2.6.19: balances incorrect in customer overview

[Geert Janssens]

Op zondag 11 maart 2018 08:02:58 CET schreef curmudgeon:
> I just upgraded to v2.6.19 (on OSX High Sierra) and now the balances in the
> Customer Overview screen are incorrect.  Receivable Ageing and Customer
> Reports are correct.
> 
> It looks like random old transactions are not included in the balances (e.g.
> some invoices from 2015 or 2016 but not their payments) but I couldn't be
> sure without further investigation.
> 
> Has anyone else seen this problem?  Anyone know how to fix it?  Do I need to
> start a new file for the new year?
> 
> Thanks

The most likely cause is these transactions were not entered via the business 
features, but perhaps via an import or directly manually.

The solution would be to tell gnucash these payments should be linked to the 
proper invoices.

How to do this is explained here:
https://wiki.gnucash.org/wiki/
Business_Features_Issues#How_can_I_see_which_transactions.
2Fsplits_are_ignored_by_the_business_features_.3F

Regards,

Geert


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