Re: [GNC] Accounting period on a per-file basis?

2023-08-05 Thread Adrien Monteleone 

Not yet. I think there is a bug filed for that change though.

Regards,
Adrien

On 8/5/23 4:34 PM, Stan Brown (using GC 4.14) wrote:

My own accounting period is the calendar year, but a nonprofit I'm
keeping books for uses a fiscal year ending July 31st. Accounting period
seems to be a per-user setting, not a per-book setting. Is there
actually a way to have different accounting periods for different books.
(Yes, I know I could create another Windows user, but that s4ems like a
lot of overhead.)

I'm on 4.14 now: I elected not to go to 5.3 since 5.4 is only a few
weeks away.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Accounting period on a per-file basis?

2023-08-05 Thread Stan Brown (using GC 4.14) 
My own accounting period is the calendar year, but a nonprofit I'm
keeping books for uses a fiscal year ending July 31st. Accounting period
seems to be a per-user setting, not a per-book setting. Is there
actually a way to have different accounting periods for different books.
(Yes, I know I could create another Windows user, but that s4ems like a
lot of overhead.)

I'm on 4.14 now: I elected not to go to 5.3 since 5.4 is only a few
weeks away.

And KUDOS on the speed: files open and save much, much faster than in
2.6. And my balance sheet comes up almost instantly, instead of taking
about a minute.

The Hidden column in the Accounts tab is a nice addition: A few days
ago, in 2.6, I was trying to find which accounts were hidden and that
meant clicking each account, then the Edit button. That was very
tedious, but now I can see the same information at a glance.

-- 
Stan Brown
Tehachapi, CA, USA
https://BrownMath.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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] finance quote not working

2023-08-05 Thread Bruce Schuck 

On 2023-08-04 at 20:16 EDT, Jim DeLaHunt wrote:


Paras:



On 2023-08-04 06:23, Paras Desai wrote:


So far, Mutual fund is concerned, following is an example of the 
fund


1. Axis Special Situation Fund , symbol for fetching price is 
INF846K01Y05


Excellent. That is helpful information. Next, try testing quote 
retrieval from the command line. If this succeeds, then your problem
is probably inside GnuCash. If this fails, then the problem is 
probably with the Finance::Quote software bundled with GnuCash, or

with the data source, or with the configRelauration.
The ISIN "INF846K01Y05" does not exist in the data used by the nseindia 
method.


The Finance::Quote module NSEIndia.pm module works by extracting data 
from a zipped CSV file retrieved from nseindia.com. Friday's file would 
have been 
https://archives.nseindia.com/content/historical/EQUITIES/2023/AUG/cm04AUG2023bhav.csv.zip


Reliance and INFY do exist, and F::Q's own example retrieval script will 
show (The example scripts are in the tarball CPAN downloads when 
installing the F::Q module):


bschuck@valhalla:~/tmp/finance-quote$ ./Examples/stockdump.pl nseindia 
INFY RELIANCE

$VAR1 = {
  'RELIANCElow' => '2471.6',
  'RELIANCEhigh' => '2516',
  'INFYexchange' => 'NSE',
  'RELIANCElast' => '2508',
  'INFYdate' => '08/04/2023',
  'RELIANCEmethod' => 'nseindia',
  'INFYlast' => '1377.9',
  'RELIANCEsuccess' => 1,
  'INFYmethod' => 'nseindia',
  'RELIANCEcurrency' => 'INR',
  'RELIANCEclose' => '2509.55',
  'INFYcurrency' => 'INR',
  'RELIANCEexchange' => 'NSE',
  'RELIANCEdate' => '08/04/2023',
  'INFYsymbol' => 'INFY',
  'RELIANCEisodate' => '2023-08-04',
  'RELIANCEprevclose' => '2475.9',
  'RELIANCEsymbol' => 'RELIANCE',
  'RELIANCEopen' => '2498.8',
  'INFYprevclose' => '1364.3',
  'INFYlow' => '1362',
  'INFYclose' => '1378.35',
  'INFYisodate' => '2023-08-04',
  'INFYhigh' => '1385.9',
  'INFYsuccess' => 1,
  'INFYopen' => '1368.9'
};


Why the data for INF846K01Y05 is not available from NSE India (did it 
perhaps stop trading?) is beyond the scope of both GnuCash and 
Finance::Quote. Sorry.


Bruce S.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Use again GnuCash

2023-08-05 Thread William Prescott 
Another workaround is to keep the master copy on the iCloud drive, then use the 
Finder to copy it to a local folder before opening it, then copy it back to the 
iCloud drive after saving changes.

Will

On 5 Aug 2023, at 11:45, john  wrote:

Unfortunately the iCloud folder isn't available using Gtk's file chooser so 
it's not feasible to support it in GnuCash. Google Drive has implemented a 
similar arrangement so that it's also invisible to Gtk's file chooser. I don't 
know about other services.

I work around that limitation by keeping my GnuCash data in a dmg that lives in 
a Google Drive folder. I can mount the dmg and access it from /Volumes, which 
is visible to Gtk file chooser.

Regards,
John Ralls


> On Aug 5, 2023, at 07:54, Derek Atkins  > wrote:
> 
> Sorry, that's beyond my Mac knowledge.
> Hopefully a Mac user will be able to answer that for you.
> My GUESS is that you just need to File -> Save As and select your iCloud
> Drive Folder.  And then on the other computer File -> Open and select it.
> 
> Just be careful that only ONE computer has the file open at a time, and
> that you shut down GnuCash every time before you open it on another
> computer.
> 
> Also, I don't know what the cache coherency delay is on iCloud Drive, so
> you may need to wait for the files to sync every time you use them.
> 
> If you fail to wait, or if you fail to use it one-at-a-time, you can
> overwrite and lose data.
> 
> -derek
> 
> On Sat, August 5, 2023 9:34 am, Emma Larose wrote:
>> Thanks, I could open it.
>> How to save it on iCloud drive to be able to pen it from different
>> computers ?
>> 
>> Emma
>> 
>> 
>> Le 5 août 2023 à 15:23:02, Derek Atkins (de...@ihtfp.com) a écrit:
>> 
>> Hi,
>> 
>> On the Mac, you cannot double-click a file to get it to open. GnuCash
>> will always open the last file it used, regardless of what you click. On
>> a Mac, you need to open GnuCash and THEN you can use File -> Open to open
>> a desired file. Then, when you exit GnuCash, next time you restart it
>> will re-open that file (regardless of what you click on).
>> 
>> If you File -> Open and it says it cannot open the file, please tell us
>> what the error is.
>> 
>> -derek
>> 
>> On Sat, August 5, 2023 9:13 am, Emma Larose wrote:
>>> Hello,
>>> 
>>> I use again Gnucash after a no use of 3 years.
>>> When I open a file.gnucash it doesn’t open in Gnucash either on Mac 2,6
>>> version or a Mac 5,3 version.
>>> What dit I miss ? What would you suggest ?
>>> 
>>> Best regards,
>>> 
>>> Emma Larose
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>> 
>> 
>> 
>> --
>> Derek Atkins 617-623-3745
>> de...@ihtfp.com www.ihtfp.com
>> Computer and Internet Security Consultant
>> 
> 
> 
> -- 
>  Derek Atkins 617-623-3745
>  de...@ihtfp.com  
>  www.ihtfp.com 
>  Computer and Internet Security Consultant
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org  
> 
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Use again GnuCash

2023-08-05 Thread john 
Unfortunately the iCloud folder isn't available using Gtk's file chooser so 
it's not feasible to support it in GnuCash. Google Drive has implemented a 
similar arrangement so that it's also invisible to Gtk's file chooser. I don't 
know about other services.

I work around that limitation by keeping my GnuCash data in a dmg that lives in 
a Google Drive folder. I can mount the dmg and access it from /Volumes, which 
is visible to Gtk file chooser.

Regards,
John Ralls


> On Aug 5, 2023, at 07:54, Derek Atkins  wrote:
> 
> Sorry, that's beyond my Mac knowledge.
> Hopefully a Mac user will be able to answer that for you.
> My GUESS is that you just need to File -> Save As and select your iCloud
> Drive Folder.  And then on the other computer File -> Open and select it.
> 
> Just be careful that only ONE computer has the file open at a time, and
> that you shut down GnuCash every time before you open it on another
> computer.
> 
> Also, I don't know what the cache coherency delay is on iCloud Drive, so
> you may need to wait for the files to sync every time you use them.
> 
> If you fail to wait, or if you fail to use it one-at-a-time, you can
> overwrite and lose data.
> 
> -derek
> 
> On Sat, August 5, 2023 9:34 am, Emma Larose wrote:
>> Thanks, I could open it.
>> How to save it on iCloud drive to be able to pen it from different
>> computers ?
>> 
>> Emma
>> 
>> 
>> Le 5 août 2023 à 15:23:02, Derek Atkins (de...@ihtfp.com) a écrit:
>> 
>> Hi,
>> 
>> On the Mac, you cannot double-click a file to get it to open. GnuCash
>> will always open the last file it used, regardless of what you click. On
>> a Mac, you need to open GnuCash and THEN you can use File -> Open to open
>> a desired file. Then, when you exit GnuCash, next time you restart it
>> will re-open that file (regardless of what you click on).
>> 
>> If you File -> Open and it says it cannot open the file, please tell us
>> what the error is.
>> 
>> -derek
>> 
>> On Sat, August 5, 2023 9:13 am, Emma Larose wrote:
>>> Hello,
>>> 
>>> I use again Gnucash after a no use of 3 years.
>>> When I open a file.gnucash it doesn’t open in Gnucash either on Mac 2,6
>>> version or a Mac 5,3 version.
>>> What dit I miss ? What would you suggest ?
>>> 
>>> Best regards,
>>> 
>>> Emma Larose
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>> 
>> 
>> 
>> --
>> Derek Atkins 617-623-3745
>> de...@ihtfp.com www.ihtfp.com
>> Computer and Internet Security Consultant
>> 
> 
> 
> -- 
>   Derek Atkins 617-623-3745
>   de...@ihtfp.com  www.ihtfp.com 
> 
>   Computer and Internet Security Consultant
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org 
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] QIF Import Problem

2023-08-05 Thread David Carlson 
Brenda,

It appears that you are editing the QIF file incorrectly.  It should not
need to be edited at all if it is coming from a financial institution.  I
have not used that format for income accounts so I cannot tell you exactly
what is wrong in your case but I think that one side should be appearing in
an income account, and the other side in a bank account.  If you go to
https://en.wikipedia.org/wiki/Quicken_Interchange_Format you will see some
examples of how the format is used, but I think that it is not 100%
correct.  Try to find a more authoritative source for exact usage.
Also, I see that you are in a jurisdiction that has HST, which we do not
have in the US.  Others in this maillist may be able to better guide you.

On Sat, Aug 5, 2023 at 10:55 AM Brenda Leudke  wrote:

> Hi David:
>
> I was instructed to import into Assets. But I have tried everything –
> Bank, cash, accountsreceivable, accountspayable. The results are all the
> same.
>
> Here is my import (my last try I used AccountsPayable) as a last ditch
> attempt. I think I have tried everything else.
>
>
>
> !Type:Cash
>
> D07/29'23
>
> U0.00
>
> T0.00
>
> PCustomer1
>
> MCottage #4 Bkg 1047 07/29/2023-08/05/2023
>
> L
>
> SIncome:Business Income:Cottage Rental:Cottage #4
>
> ECottage #4 Bkg 1047 07/29/2023-08/05/2023
>
> $1300.00
>
> SIncome:Business Income:HST Collected
>
> ECottage #4 Bkg 1047 HST
>
> $169.00
>
> *SAPayable:Accounts Payable*
>
> ECottage #4 Bkg 1047 07/29/2023-08/05/2023
>
> $-1469.00
>
> ^
>
> D07/31'23
>
> U1469.00
>
> T1469.00
>
> PCustomer1
>
> MCottage #4 Bkg 1047 Payment bank draft
>
> L
>
> *SAPayable:Accounts Payable*
>
> ECottage #4 Bkg 1047 Payment bank draft
>
> $1469.00
>
> ^
>
>
>
> *From:* David Carlson 
> *Sent:* August 5, 2023 11:40 AM
> *To:* Gyle McCollam 
> *Cc:* Brenda Leudke ; gnucash-user@gnucash.org
> *Subject:* Re: [GNC] QIF Import Problem
>
>
>
> Brenda,
>
>
>
> GnuCash also supports QIF imports as they are exported from many financial
> institutions.  Is there a chance that one of your GnuCash accounts has an
> incorrect account type?
>
>
>
> On Sat, Aug 5, 2023 at 9:58 AM Gyle McCollam  wrote:
>
> Brenda,
> Are you using Quicken or QuickBooks?  The Quicken file import used by
> Gnucash is QFX, not QIF?  I don't know anything about the format of the
> import file, but I did a quick download of a QFX file and the layout looks
> very different.  I hesitated to respond, because I don't know much about
> how it works, I just know it works fine for me and the only difference was
> QIF vs QFX.  Gnucash will also import OFX and CSV files if you want to try
> a different format.  I didn't see any responses to your question, so I
> decided to offer what little help I could.
>
>
> Thank You,
>
> Gyle McCollam
>
> Gyle McCollam
>
> gmccol...@live.com   email
>
> 
> From: gnucash-user  on
> behalf of Brenda Leudke 
> Sent: Wednesday, August 2, 2023 3:12 PM
> To: gnucash-user@gnucash.org 
> Subject: [GNC] QIF Import Problem
>
> Good afternoon:
>
> I am a first time poster, long time user of gnucash...
>
> I am trying to import a QIF file into gnucash. Gnucash is entering
> everything as a debit. I can't verify this but am being told that it works
> with Quicken. Is there a problem with the file or is there a problem with
> gnucash? I would appreciate any help.
>
> Here is the qif file (an attachment is also included):
>
> !Type:Cash
>
> D06/10'23
>
> U0.00
>
> T0.00
>
> PCustomer1
>
> MCottage #3 Bkg 1032 06/10/2023-06/17/2023
>
> L
>
> SIncome:Cottage Rental:Cottage #3
>
> ECottage #3 Bkg 1032 06/10/2023-06/17/2023
>
> $1075.00
>
> SIncome:HST Collected
>
> ECottage #3 Bkg 1032 HST
>
> $139.75
>
> SAssets:TD Business
>
> ECottage #3 Bkg 1032 06/10/2023-06/17/2023
>
> $-1214.75
>
> ^
>
> D06/10'23
>
> U1214.75
>
> T1214.75
>
> PCustomer1
>
> MCottage #3 Bkg 1032 Payment etransfer
>
> L
>
>
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
>
>
> --
>
> David Carlson
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] QIF Import Problem

2023-08-05 Thread Brenda Leudke 
Hi David:

I was instructed to import into Assets. But I have tried everything – Bank, 
cash, accountsreceivable, accountspayable. The results are all the same.

Here is my import (my last try I used AccountsPayable) as a last ditch attempt. 
I think I have tried everything else.

 

!Type:Cash

D07/29'23

U0.00

T0.00

PCustomer1

MCottage #4 Bkg 1047 07/29/2023-08/05/2023

L

SIncome:Business Income:Cottage Rental:Cottage #4

ECottage #4 Bkg 1047 07/29/2023-08/05/2023

$1300.00

SIncome:Business Income:HST Collected

ECottage #4 Bkg 1047 HST

$169.00

SAPayable:Accounts Payable

ECottage #4 Bkg 1047 07/29/2023-08/05/2023

$-1469.00

^

D07/31'23

U1469.00

T1469.00

PCustomer1

MCottage #4 Bkg 1047 Payment bank draft

L

SAPayable:Accounts Payable

ECottage #4 Bkg 1047 Payment bank draft

$1469.00

^

 

From: David Carlson  
Sent: August 5, 2023 11:40 AM
To: Gyle McCollam 
Cc: Brenda Leudke ; gnucash-user@gnucash.org
Subject: Re: [GNC] QIF Import Problem

 

Brenda,

 

GnuCash also supports QIF imports as they are exported from many financial 
institutions.  Is there a chance that one of your GnuCash accounts has an 
incorrect account type?

 

On Sat, Aug 5, 2023 at 9:58 AM Gyle McCollam mailto:gmccol...@live.com> > wrote:

Brenda,
Are you using Quicken or QuickBooks?  The Quicken file import used by Gnucash 
is QFX, not QIF?  I don't know anything about the format of the import file, 
but I did a quick download of a QFX file and the layout looks very different.  
I hesitated to respond, because I don't know much about how it works, I just 
know it works fine for me and the only difference was QIF vs QFX.  Gnucash will 
also import OFX and CSV files if you want to try a different format.  I didn't 
see any responses to your question, so I decided to offer what little help I 
could.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   >   email


From: gnucash-user mailto:gmail@gnucash.org> > on behalf of Brenda Leudke mailto:leu...@gmail.com> >
Sent: Wednesday, August 2, 2023 3:12 PM
To: gnucash-user@gnucash.org   
mailto:gnucash-user@gnucash.org> >
Subject: [GNC] QIF Import Problem

Good afternoon:

I am a first time poster, long time user of gnucash...

I am trying to import a QIF file into gnucash. Gnucash is entering
everything as a debit. I can't verify this but am being told that it works
with Quicken. Is there a problem with the file or is there a problem with
gnucash? I would appreciate any help.

Here is the qif file (an attachment is also included):

!Type:Cash

D06/10'23

U0.00

T0.00

PCustomer1

MCottage #3 Bkg 1032 06/10/2023-06/17/2023

L

SIncome:Cottage Rental:Cottage #3

ECottage #3 Bkg 1032 06/10/2023-06/17/2023

$1075.00

SIncome:HST Collected

ECottage #3 Bkg 1032 HST

$139.75

SAssets:TD Business

ECottage #3 Bkg 1032 06/10/2023-06/17/2023

$-1214.75

^

D06/10'23

U1214.75

T1214.75

PCustomer1

MCottage #3 Bkg 1032 Payment etransfer

L





___
gnucash-user mailing list
gnucash-user@gnucash.org  
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.



-- 

David Carlson

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] QIF Import Problem

2023-08-05 Thread David Carlson 
Brenda,

GnuCash also supports QIF imports as they are exported from many financial
institutions.  Is there a chance that one of your GnuCash accounts has an
incorrect account type?

On Sat, Aug 5, 2023 at 9:58 AM Gyle McCollam  wrote:

> Brenda,
> Are you using Quicken or QuickBooks?  The Quicken file import used by
> Gnucash is QFX, not QIF?  I don't know anything about the format of the
> import file, but I did a quick download of a QFX file and the layout looks
> very different.  I hesitated to respond, because I don't know much about
> how it works, I just know it works fine for me and the only difference was
> QIF vs QFX.  Gnucash will also import OFX and CSV files if you want to try
> a different format.  I didn't see any responses to your question, so I
> decided to offer what little help I could.
>
>
> Thank You,
>
> Gyle McCollam
>
> Gyle McCollam
>
> gmccol...@live.com   email
>
> 
> From: gnucash-user  on
> behalf of Brenda Leudke 
> Sent: Wednesday, August 2, 2023 3:12 PM
> To: gnucash-user@gnucash.org 
> Subject: [GNC] QIF Import Problem
>
> Good afternoon:
>
> I am a first time poster, long time user of gnucash...
>
> I am trying to import a QIF file into gnucash. Gnucash is entering
> everything as a debit. I can't verify this but am being told that it works
> with Quicken. Is there a problem with the file or is there a problem with
> gnucash? I would appreciate any help.
>
> Here is the qif file (an attachment is also included):
>
> !Type:Cash
>
> D06/10'23
>
> U0.00
>
> T0.00
>
> PCustomer1
>
> MCottage #3 Bkg 1032 06/10/2023-06/17/2023
>
> L
>
> SIncome:Cottage Rental:Cottage #3
>
> ECottage #3 Bkg 1032 06/10/2023-06/17/2023
>
> $1075.00
>
> SIncome:HST Collected
>
> ECottage #3 Bkg 1032 HST
>
> $139.75
>
> SAssets:TD Business
>
> ECottage #3 Bkg 1032 06/10/2023-06/17/2023
>
> $-1214.75
>
> ^
>
> D06/10'23
>
> U1214.75
>
> T1214.75
>
> PCustomer1
>
> MCottage #3 Bkg 1032 Payment etransfer
>
> L
>
>
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] QIF Import Problem

2023-08-05 Thread Brenda Leudke 
Hi Gyle:

Thank u for the reply. I appreciate any help.

 

The program (Vacation Rent Pro - VRP) that I am using to generate the import
file only creates QIF files for Quicken or IIF files for Quickbooks. So I
have to use QIF files to import into gnucash.

Note: I use OFX files when downloading my banking transactions into gnucash
with no problem.

 

I have discussed this with the VRP support person and he says that the QIF
file works properly for Quicken. So he says it's a gnucash problem.

 

When I import the data (as shown by my example), the payment as well as the
income both enter as a debit. Then I have to manually change the income
entries to a credit.

 

I would be open to doing some type of conversion of the qif file before it
gets imported (to reduce the amount of manual effort). Not aware of a qif
conversion to ofx or qfx. But that would be a "good enough" workaround, if
there is no other solution.

 

Brenda

 

From: Gyle McCollam  
Sent: August 5, 2023 10:58 AM
To: Brenda Leudke ; gnucash-user@gnucash.org
Subject: Re: [GNC] QIF Import Problem

 

Brenda,

Are you using Quicken or QuickBooks?  The Quicken file import used by
Gnucash is QFX, not QIF?  I don't know anything about the format of the
import file, but I did a quick download of a QFX file and the layout looks
very different.  I hesitated to respond, because I don't know much about how
it works, I just know it works fine for me and the only difference was QIF
vs QFX.  Gnucash will also import OFX and CSV files if you want to try a
different format.  I didn't see any responses to your question, so I decided
to offer what little help I could.

 

Thank You,   

Gyle McCollam

Gyle McCollam

  gmccol...@live.com   email

  _  

From: gnucash-user mailto:gnucash-user-bounces+gylemc=gmail@gnucash.org> > on behalf of
Brenda Leudke mailto:leu...@gmail.com> >
Sent: Wednesday, August 2, 2023 3:12 PM
To: gnucash-user@gnucash.org 
mailto:gnucash-user@gnucash.org> >
Subject: [GNC] QIF Import Problem 

 

Good afternoon:

I am a first time poster, long time user of gnucash...

I am trying to import a QIF file into gnucash. Gnucash is entering
everything as a debit. I can't verify this but am being told that it works
with Quicken. Is there a problem with the file or is there a problem with
gnucash? I would appreciate any help.

Here is the qif file (an attachment is also included):

!Type:Cash

D06/10'23

U0.00

T0.00

PCustomer1

MCottage #3 Bkg 1032 06/10/2023-06/17/2023

L

SIncome:Cottage Rental:Cottage #3

ECottage #3 Bkg 1032 06/10/2023-06/17/2023

$1075.00

SIncome:HST Collected

ECottage #3 Bkg 1032 HST

$139.75

SAssets:TD Business

ECottage #3 Bkg 1032 06/10/2023-06/17/2023

$-1214.75

^

D06/10'23

U1214.75

T1214.75

PCustomer1

MCottage #3 Bkg 1032 Payment etransfer

L

 

 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] QIF Import Problem

2023-08-05 Thread Gyle McCollam 
Brenda,
Are you using Quicken or QuickBooks?  The Quicken file import used by Gnucash 
is QFX, not QIF?  I don't know anything about the format of the import file, 
but I did a quick download of a QFX file and the layout looks very different.  
I hesitated to respond, because I don't know much about how it works, I just 
know it works fine for me and the only difference was QIF vs QFX.  Gnucash will 
also import OFX and CSV files if you want to try a different format.  I didn't 
see any responses to your question, so I decided to offer what little help I 
could.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email


From: gnucash-user  on 
behalf of Brenda Leudke 
Sent: Wednesday, August 2, 2023 3:12 PM
To: gnucash-user@gnucash.org 
Subject: [GNC] QIF Import Problem

Good afternoon:

I am a first time poster, long time user of gnucash...

I am trying to import a QIF file into gnucash. Gnucash is entering
everything as a debit. I can't verify this but am being told that it works
with Quicken. Is there a problem with the file or is there a problem with
gnucash? I would appreciate any help.

Here is the qif file (an attachment is also included):

!Type:Cash

D06/10'23

U0.00

T0.00

PCustomer1

MCottage #3 Bkg 1032 06/10/2023-06/17/2023

L

SIncome:Cottage Rental:Cottage #3

ECottage #3 Bkg 1032 06/10/2023-06/17/2023

$1075.00

SIncome:HST Collected

ECottage #3 Bkg 1032 HST

$139.75

SAssets:TD Business

ECottage #3 Bkg 1032 06/10/2023-06/17/2023

$-1214.75

^

D06/10'23

U1214.75

T1214.75

PCustomer1

MCottage #3 Bkg 1032 Payment etransfer

L





___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Use again GnuCash

2023-08-05 Thread Derek Atkins 
Sorry, that's beyond my Mac knowledge.
Hopefully a Mac user will be able to answer that for you.
My GUESS is that you just need to File -> Save As and select your iCloud
Drive Folder.  And then on the other computer File -> Open and select it.

Just be careful that only ONE computer has the file open at a time, and
that you shut down GnuCash every time before you open it on another
computer.

Also, I don't know what the cache coherency delay is on iCloud Drive, so
you may need to wait for the files to sync every time you use them.

If you fail to wait, or if you fail to use it one-at-a-time, you can
overwrite and lose data.

-derek

On Sat, August 5, 2023 9:34 am, Emma Larose wrote:
> Thanks, I could open it.
> How to save it on iCloud drive to be able to pen it from different
> computers ?
>
> Emma
>
>
> Le 5 août 2023 à 15:23:02, Derek Atkins (de...@ihtfp.com) a écrit:
>
> Hi,
>
> On the Mac, you cannot double-click a file to get it to open. GnuCash
> will always open the last file it used, regardless of what you click. On
> a Mac, you need to open GnuCash and THEN you can use File -> Open to open
> a desired file. Then, when you exit GnuCash, next time you restart it
> will re-open that file (regardless of what you click on).
>
> If you File -> Open and it says it cannot open the file, please tell us
> what the error is.
>
> -derek
>
> On Sat, August 5, 2023 9:13 am, Emma Larose wrote:
>> Hello,
>>
>> I use again Gnucash after a no use of 3 years.
>> When I open a file.gnucash it doesn’t open in Gnucash either on Mac 2,6
>> version or a Mac 5,3 version.
>> What dit I miss ? What would you suggest ?
>>
>> Best regards,
>>
>> Emma Larose
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
>
> --
> Derek Atkins 617-623-3745
> de...@ihtfp.com www.ihtfp.com
> Computer and Internet Security Consultant
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Use again GnuCash

2023-08-05 Thread Emma Larose 
Thanks, I could open it.
How to save it on iCloud drive to be able to pen it from different
computers ?

Emma


Le 5 août 2023 à 15:23:02, Derek Atkins (de...@ihtfp.com) a écrit:

Hi,

On the Mac, you cannot double-click a file to get it to open. GnuCash
will always open the last file it used, regardless of what you click. On
a Mac, you need to open GnuCash and THEN you can use File -> Open to open
a desired file. Then, when you exit GnuCash, next time you restart it
will re-open that file (regardless of what you click on).

If you File -> Open and it says it cannot open the file, please tell us
what the error is.

-derek

On Sat, August 5, 2023 9:13 am, Emma Larose wrote:
> Hello,
>
> I use again Gnucash after a no use of 3 years.
> When I open a file.gnucash it doesn’t open in Gnucash either on Mac 2,6
> version or a Mac 5,3 version.
> What dit I miss ? What would you suggest ?
>
> Best regards,
>
> Emma Larose
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
Derek Atkins 617-623-3745
de...@ihtfp.com www.ihtfp.com
Computer and Internet Security Consultant
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Use again GnuCash

2023-08-05 Thread Derek Atkins 
Hi,

On the Mac, you cannot double-click a file to get it to open.  GnuCash
will always open the last file it used, regardless of what you click.  On
a Mac, you need to open GnuCash and THEN you can use File -> Open to open
a desired file.  Then, when you exit GnuCash, next time you restart it
will re-open that file (regardless of what you click on).

If you File -> Open and it says it cannot open the file, please tell us
what the error is.

-derek

On Sat, August 5, 2023 9:13 am, Emma Larose wrote:
> Hello,
>
> I use again Gnucash after a no use of 3 years.
> When I open a file.gnucash it doesn’t open in Gnucash either on Mac 2,6
> version or a Mac 5,3 version.
> What dit I miss ? What would you suggest ?
>
> Best regards,
>
> Emma Larose
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Use again GnuCash

2023-08-05 Thread Emma Larose 
Hello,

I use again Gnucash after a no use of 3 years.
When I open a file.gnucash it doesn’t open in Gnucash either on Mac 2,6
version or a Mac 5,3 version.
What dit I miss ? What would you suggest ?

Best regards,

Emma Larose
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.