[GNC] Difference in Present and Cleared Balance w/o any transaction uncleared

[hh8923]

Hi,

 

In the tab for the account, I can see the following at the bottom

 

Present $2,366.72

Future $2,366.72

Cleared $2,377.16

Reconciled $2,691.79

Projected Minimum $2,366.72

 

This is the result in the import from QIF.  However, I was unable to find
any transaction that's not cleared (not y or c).  How can I explain the
difference b/w Present and Cleared?

 

Thanks

___
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] The equivalent for Quicken Tag

[hh8923]

I turned on double line and can see Notes.  There is one more space next to it 
but it’s not editable. 

 

The example for Donation can be solved with several different approach.  It’s 
more challenge to solve the general problem.  For example, there are multiple 
sub-account under main Account “Travel”.  The Tag is used to select the travel 
destination.  This creates a 2-D setup where you can track different expense 
types for each destination.

 

Another question is when importing from Quicken export QIF, is there some way 
to map Tag?

 

Is there a conclusion that GnuCash should not support Tag (a feature can exist 
and people can choose not to use it as if it does not so it won’t create 
problem for them while others can choose to use the feature)?  Or is it matter 
of lack of development resources?  If it’s the latter, I wonder someone who 
wants this feature can add it?

 

Thanks

 

From: Jim Passmore  
Sent: Sunday, April 28, 2024 10:31 PM
To: hh8...@gmail.com
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] The equivalent for Quicken Tag

 

How about a sub-account for each charity, as Geoff suggested, and *zero* tags?  
Once you have the sub-accounts and use them, you can track the charity by 
running a transaction report.  Go to options, select Donations and all the sub 
accounts on the accounts tab, and set the desired  date range on the General 
tab.  Look at the other options while you're there to see if you want to change 
anything.

 

When I do the above, I get a report of all my donations, grouped and subtotaled 
by charity.

 

-- 

Jim 



 

 

On Sun, Apr 28, 2024 at 9:26 PM mailto:hh8...@gmail.com> > 
wrote:

Hi,

This means a sub category for each charity.

Now, if we have c categories and t tags, in Quicken we'd have c*t number of 
combination.  Creating 1 sub category for each tag under each category will be 
tedious.  In Stack Exchange, some suggested to use Note or Label.  But I could 
not seem to find them in the registry.  Is that possible?

Thanks

-Original Message-
From: Geoff mailto:cleanoutmys...@gmail.com> > 
Sent: Sunday, April 28, 2024 9:24 PM
To: gnucash-user@gnucash.org  ; 
hh8...@gmail.com  
Subject: Re: [GNC] The equivalent for Quicken Tag

Hi HH

There are several solutions to this scenario, here is one using the chart of 
accounts.

EXPENSES
--AUTOMOBILE
FUEL
REPAIRS
--DONATIONS
CHARITY01
CHARITY02
CHARITY03
--EDUCATION
BOOKS
FEES
etc etc

Hope this helps.

Regards

Geoff
=



On 29/04/2024 11:03 am, hh8...@gmail.com   wrote:
> Hi,
> 
>   
> 
> I'm new to GnuCash.  In Quicken, I use Tag a lot.  For example, I 
> create one tag for each charity and set a single category for Donation 
> and use Tag to track charity.  Search yielded discussion in 2017 as 
> the latest when it's not available.  What's the latest status?  If not 
> available, what would be the best way to handle the above example?
> 
>   
> 
> Thanks
> 
> ___
> 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] The equivalent for Quicken Tag

[hh8923]

Hi,

This means a sub category for each charity.

Now, if we have c categories and t tags, in Quicken we'd have c*t number of 
combination.  Creating 1 sub category for each tag under each category will be 
tedious.  In Stack Exchange, some suggested to use Note or Label.  But I could 
not seem to find them in the registry.  Is that possible?

Thanks

-Original Message-
From: Geoff  
Sent: Sunday, April 28, 2024 9:24 PM
To: gnucash-user@gnucash.org; hh8...@gmail.com
Subject: Re: [GNC] The equivalent for Quicken Tag

Hi HH

There are several solutions to this scenario, here is one using the chart of 
accounts.

EXPENSES
--AUTOMOBILE
FUEL
REPAIRS
--DONATIONS
CHARITY01
CHARITY02
CHARITY03
--EDUCATION
BOOKS
FEES
etc etc

Hope this helps.

Regards

Geoff
=



On 29/04/2024 11:03 am, hh8...@gmail.com wrote:
> Hi,
> 
>   
> 
> I'm new to GnuCash.  In Quicken, I use Tag a lot.  For example, I 
> create one tag for each charity and set a single category for Donation 
> and use Tag to track charity.  Search yielded discussion in 2017 as 
> the latest when it's not available.  What's the latest status?  If not 
> available, what would be the best way to handle the above example?
> 
>   
> 
> Thanks
> 
> ___
> 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.

[GNC] The equivalent for Quicken Tag

[hh8923]

Hi, 

 

I'm new to GnuCash.  In Quicken, I use Tag a lot.  For example, I create one
tag for each charity and set a single category for Donation and use Tag to
track charity.  Search yielded discussion in 2017 as the latest when it's
not available.  What's the latest status?  If not available, what would be
the best way to handle the above example?

 

Thanks

___
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] Identify error transaction in QIF import

[hh8923]

Some quick check shows some account balance does not match – including credit 
card or banking.  This is a bad situation as I have to manually find what’s 
missing.  When the conversion finished, it only has warning of stock symbols.  
What can I do to find what transaction was missed?

 

Thanks

 

From: hh8...@gmail.com  
Sent: Sunday, April 28, 2024 8:42 PM
To: 'Christopher Lam' 
Cc: gnucash-user@gnucash.org
Subject: RE: [GNC] Identify error transaction in QIF import

 

Good news.  The last stable build Apr 28 could import the full QIF file.  It 
took 9 hours but finished with some warning (those stocks that no longer 
exists).

 

Now my question is whether I should wait for a released version – otherwise if 
the build has some bugs it would be very difficult to go back and redo it.

 

 

From: Christopher Lam mailto:christopher@gmail.com> > 
Sent: Sunday, April 28, 2024 10:44 AM
To: Hao Huang mailto:hh8...@gmail.com> >
Cc: gnucash-user@gnucash.org  
Subject: Re: [GNC] Identify error transaction in QIF import

 

Please pick a recent build from https://code.gnucash.org/builds/win32/stable/

 

On Sun, 28 Apr 2024 at 21:54, Hao Huang mailto:hh8...@gmail.com> > wrote:

Hi,

The original problem was "The erroneous transaction seems to be the last of 
those imported". If that's the case, it won't apply. What is shown in my case 
is there is no investment transaction on that day and it's somewhere in the 
middle of all the dates.

Also, in Quicken I can't find any transaction on any investment accounts.

Is there an experiment build available to test the theory?

Thanks

Apr 28, 2024 09:35:40 Geoff mailto:cleanoutmys...@gmail.com> >:

> Hello HH
> 
> Please read this:
> 
> https://lists.gnucash.org/pipermail/gnucash-user/2024-April/111431.html
> 
> Regards
> 
> Geoff
> =
> 
> On 28/04/2024 9:43 pm, hh8...@gmail.com   wrote:
>> Hi,
>>  
>> Thanks for the advice.  I run Quicken -> Validate and Repair File and it 
>> reported a few errors that I fixed.
>>  
>> However, I still get the same error message
>>  
>> Missing QIF investment action for transaction dated 9/19/2019
>> 
>> I opened the QIF in text editor and searched for 9/19’19.  There are about 
>> 10 instances in a few banking accounts.  Then all others are !Type:Prices
>>  
>> I have more than 20 years of records and more than 100 accounts.  It will be 
>> very difficult to do this one by one.
>>  
>> Is it possible for the error message to be more specific and pointing to 
>> exact transaction?
>>  
>> Thanks
>>  
___
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] Identify error transaction in QIF import

[hh8923]

Good news.  The last stable build Apr 28 could import the full QIF file.  It 
took 9 hours but finished with some warning (those stocks that no longer 
exists).

 

Now my question is whether I should wait for a released version – otherwise if 
the build has some bugs it would be very difficult to go back and redo it.

 

 

From: Christopher Lam  
Sent: Sunday, April 28, 2024 10:44 AM
To: Hao Huang 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Identify error transaction in QIF import

 

Please pick a recent build from https://code.gnucash.org/builds/win32/stable/

 

On Sun, 28 Apr 2024 at 21:54, Hao Huang mailto:hh8...@gmail.com> > wrote:

Hi,

The original problem was "The erroneous transaction seems to be the last of 
those imported". If that's the case, it won't apply. What is shown in my case 
is there is no investment transaction on that day and it's somewhere in the 
middle of all the dates.

Also, in Quicken I can't find any transaction on any investment accounts.

Is there an experiment build available to test the theory?

Thanks

Apr 28, 2024 09:35:40 Geoff mailto:cleanoutmys...@gmail.com> >:

> Hello HH
> 
> Please read this:
> 
> https://lists.gnucash.org/pipermail/gnucash-user/2024-April/111431.html
> 
> Regards
> 
> Geoff
> =
> 
> On 28/04/2024 9:43 pm, hh8...@gmail.com   wrote:
>> Hi,
>>  
>> Thanks for the advice.  I run Quicken -> Validate and Repair File and it 
>> reported a few errors that I fixed.
>>  
>> However, I still get the same error message
>>  
>> Missing QIF investment action for transaction dated 9/19/2019
>> 
>> I opened the QIF in text editor and searched for 9/19’19.  There are about 
>> 10 instances in a few banking accounts.  Then all others are !Type:Prices
>>  
>> I have more than 20 years of records and more than 100 accounts.  It will be 
>> very difficult to do this one by one.
>>  
>> Is it possible for the error message to be more specific and pointing to 
>> exact transaction?
>>  
>> Thanks
>>  
___
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] Identify error transaction in QIF import

[hh8923]

Hi,

 

Thanks for the advice.  I run Quicken -> Validate and Repair File and it 
reported a few errors that I fixed.

 

However, I still get the same error message

 

Missing QIF investment action for transaction dated 9/19/2019



I opened the QIF in text editor and searched for 9/19’19.  There are about 10 
instances in a few banking accounts.  Then all others are !Type:Prices

 

I have more than 20 years of records and more than 100 accounts.  It will be 
very difficult to do this one by one.

 

Is it possible for the error message to be more specific and pointing to exact 
transaction?

 

Thanks

 

From: Joseph Keithley  
Sent: Sunday, April 21, 2024 11:47 AM
To: hh8...@gmail.com
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Identify error transaction in QIF import

 

The first thing I did before I exported my 150mb Quicken file to a qif was to 
run the Validate and Repair in the File menu under File Operations.  Sometimes 
the Quicken data file gets corrupted and you have to repair transactions.  That 
may help you track down if the issue is with your Quicken file or GnuCash.

 

I tried to export my Quicken file as a single qif and then import it into 
GnuCash.  That approach was a complete disaster.  I assume that since my 
Quicken file was so large, GnuCash couldn't really handle the conversion 
directly.  

 

In order for me to finally get my Quicken file imported into GnuCash, after ten 
different attempts, I exported one account at a time, one year at a time, until 
I had all the data exported. Then I imported each into GnuCash.  I then had to 
make a number of manual edits and corrections to the GnuCash file but that was 
largely due to my unfamiliarity with GnuCash.

 

The bottom line is, one way to make the import easier is to stick to 
exporting/importing one account at a time.  When you then import the next 
account, matching up transactions will be much easier.  I also found that 
having the account structure already setup in GnuCash, mimicing the same 
account names and categories in Quicken, made the import task much easier.  
Otherwise each time you import a file that wants to add a new account or 
category to GnuCash for any undefined transaction account/category gets 
extremely confusing.

 

 

 

On Sun, Apr 21, 2024 at 8:49 AM mailto:hh8...@gmail.com> > 
wrote:

One more thing.  In Quicken, I can't find any investment transaction on that
date.  They are credit card or banking transactions.



From: hh8...@gmail.com   mailto:hh8...@gmail.com> > 
Sent: Sunday, April 21, 2024 8:37 AM
To: gnucash-user@gnucash.org  
Subject: Identify error transaction in QIF import



Hi,



I'm a long time Quicken user and trying to migrate to GnuCash.  I've
exported my entire Quicken file to QIF and then try to import into GnuCash.
Here is what I noted during the attempt.



Load QIF files

Line 627318: Could not parse price line: "#C093280",," 5/ 4'21"



Match payees/memos to GnuCash accounts

It listed about 10 that maps to Unspecified and I kept them as New selected



Tradable commodities

There are many and I did not review them.  Exchange or abbreviation type
appear to be NONCURRENCY for all of them



New Book Options

I did not change any settings



QIF Import - Failed

Missing QIF investment action for transaction dated 9/19/2019



I have many accounts and many transactions.  Searching the QIF file find
many with this date.  How can I get the details on what to fix?  Is there a
log file of import?



Thanks



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




 

-- 

iii

___
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] Identify error transaction in QIF import

[hh8923]

One more thing.  In Quicken, I can't find any investment transaction on that
date.  They are credit card or banking transactions.

 

From: hh8...@gmail.com  
Sent: Sunday, April 21, 2024 8:37 AM
To: gnucash-user@gnucash.org
Subject: Identify error transaction in QIF import

 

Hi,

 

I'm a long time Quicken user and trying to migrate to GnuCash.  I've
exported my entire Quicken file to QIF and then try to import into GnuCash.
Here is what I noted during the attempt.

 

Load QIF files

Line 627318: Could not parse price line: "#C093280",," 5/ 4'21"

 

Match payees/memos to GnuCash accounts

It listed about 10 that maps to Unspecified and I kept them as New selected

 

Tradable commodities

There are many and I did not review them.  Exchange or abbreviation type
appear to be NONCURRENCY for all of them

 

New Book Options

I did not change any settings

 

QIF Import - Failed

Missing QIF investment action for transaction dated 9/19/2019

 

I have many accounts and many transactions.  Searching the QIF file find
many with this date.  How can I get the details on what to fix?  Is there a
log file of import?

 

Thanks

 

___
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] Identify error transaction in QIF import

[hh8923]

Hi,

 

I'm a long time Quicken user and trying to migrate to GnuCash.  I've
exported my entire Quicken file to QIF and then try to import into GnuCash.
Here is what I noted during the attempt.

 

Load QIF files

Line 627318: Could not parse price line: "#C093280",," 5/ 4'21"

 

Match payees/memos to GnuCash accounts

It listed about 10 that maps to Unspecified and I kept them as New selected

 

Tradable commodities

There are many and I did not review them.  Exchange or abbreviation type
appear to be NONCURRENCY for all of them

 

New Book Options

I did not change any settings

 

QIF Import - Failed

Missing QIF investment action for transaction dated 9/19/2019

 

I have many accounts and many transactions.  Searching the QIF file find
many with this date.  How can I get the details on what to fix?  Is there a
log file of import?

 

Thanks

 

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