[GNC] Moving from quicken

[Paras Desai]

In order to have tax report GNUCASH offers some options

1. If you are from USA, you can use GNUCASH inbuilt tax report

2. For non usa users, there are few work around, which i have adopted

A. Create income account and in its name add suffix taxable

Or

B. While posting income add "tax" in description.

Then run account or transaction report, in option menu filter "contains tax in 
description"

Or select account including child account which contains tax in its description.

All transactions or balance for the period selected will be there in the report 
generated.


This may need some practice or couple of attempts, but the report will be 
useful for knowing taxable income

Of course while posting you get to know which income is taxable and which is 
not.

Hope this helps

With regards

Paras

Get Outlook for Android
___
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 Failed

[sunfish62--- via gnucash-user]

The problem with that Wikipedia article is that it focuses solely on Quicken, 
but the QIF format has essentially become an open format that other 
applications use (and implement).

Since that article doesn't mention the designation of bracketed accounts as 
fitting in any particular category, it may be that some note on the wiki 
advising of that GnuCash interpretation *might* be in order. 

⁣David T.​

On Jan 8, 2024, 5:21 AM, at 5:21 AM, Geoff  wrote:
>Wikipedia has a confusing explanation here:
>
>When editing the QIF file, check for any transaction Category (the
>field 
>starting with 'L') for an account name contained in brackets, such as 
>[Checking Account]. The brackets reference another quicken account, and
>
>if left in place will post a transaction in that account in addition to
>
>the account being imported to, with potentially troublesome results. 
>Avoid this by removing the text including the brackets and replacing 
>with another category if desired. The only exception to this is an 
>opening balance transaction, identified by 'Opening Balance' in the 'P'
>
>field (POpening Balance). In this case, the brackets need to be left in
>
>place, and the account name between the brackets must exactly match the
>
>account name in the 'N' field.
>
>https://en.wikipedia.org/wiki/Quicken_Interchange_Format
>
>Geoff
>=
>
>On 8/01/2024 12:02 pm, Derek Atkins wrote:
>> This isn't a GnuCash thing. It's a QIf thing.
>> -derek
>> Sent using my mobile device. Please excuse any typos.
>> 
>> On January 7, 2024 19:58:30 Fred Tydeman 
>wrote:
>> 
>>> Thank you.
>>>
>>> Is that documented somewhere in Gnucash?
>>>
>>> On Sun, Jan 7, 2024 at 4:02 PM Derek Atkins >> > wrote:
>>>
>>> Indeed.  QIF treats the L[XX] as Asset/Liability account and LXX
>as an
>>> Income/Expense account (Category).
>>> -derek
>>>
>> 
>___
>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 Failed

[Geoff]

Wikipedia has a confusing explanation here:

When editing the QIF file, check for any transaction Category (the field 
starting with 'L') for an account name contained in brackets, such as 
[Checking Account]. The brackets reference another quicken account, and 
if left in place will post a transaction in that account in addition to 
the account being imported to, with potentially troublesome results. 
Avoid this by removing the text including the brackets and replacing 
with another category if desired. The only exception to this is an 
opening balance transaction, identified by 'Opening Balance' in the 'P' 
field (POpening Balance). In this case, the brackets need to be left in 
place, and the account name between the brackets must exactly match the 
account name in the 'N' field.


https://en.wikipedia.org/wiki/Quicken_Interchange_Format

Geoff
=

On 8/01/2024 12:02 pm, Derek Atkins wrote:

This isn't a GnuCash thing. It's a QIf thing.
-derek
Sent using my mobile device. Please excuse any typos.

On January 7, 2024 19:58:30 Fred Tydeman  wrote:


Thank you.

Is that documented somewhere in Gnucash?

On Sun, Jan 7, 2024 at 4:02 PM Derek Atkins > wrote:


Indeed.  QIF treats the L[XX] as Asset/Liability account and LXX as an
Income/Expense account (Category).
-derek




___
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] gnu-cash users to meet in person?

[Derek Atkins]

Amusingly I happen to be in Shelton for the next couple days...

-derek

On Sun, January 7, 2024 9:28 pm, Steve Freeman wrote:
> Do any gnu-cash user groups meet in person? I'd like to meet and perhaps
> occasionally work with other gnu-cash users.
>
> If no groups exist, but any of you might care to meet with another user,
> please direct reply.
>
> I live in central Connecticut and would be happy to host a group.
>
> I travel occasionally to New York (especially Westchester), New Jersey,
> Philadelphia, Vermont and Boston and would be happy to meet with any users
> in any of these areas.
>
> Thanks, Steve
>
> ___
> 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] gnu-cash users to meet in person?

[Steve Freeman]

Do any gnu-cash user groups meet in person? I'd like to meet and perhaps
occasionally work with other gnu-cash users. 

If no groups exist, but any of you might care to meet with another user,
please direct reply. 

I live in central Connecticut and would be happy to host a group. 

I travel occasionally to New York (especially Westchester), New Jersey,
Philadelphia, Vermont and Boston and would be happy to meet with any users
in any of these areas.

Thanks, Steve 

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

[Derek Atkins]

This isn't a GnuCash thing. It's a QIf thing.
-derek
Sent using my mobile device. Please excuse any typos.
On January 7, 2024 19:58:30 Fred Tydeman  wrote:

Thank you.

Is that documented somewhere in Gnucash?

On Sun, Jan 7, 2024 at 4:02 PM Derek Atkins  wrote:
Indeed.  QIF treats the L[XX] as Asset/Liability account and LXX as an
Income/Expense account (Category).
-derek


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

[Fred Tydeman]

Thank you.

Is that documented somewhere in Gnucash?

On Sun, Jan 7, 2024 at 4:02 PM Derek Atkins  wrote:

> Indeed.  QIF treats the L[XX] as Asset/Liability account and LXX as an
> Income/Expense account (Category).
> -derek
>
>
___
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 Failed

[Derek Atkins]

Indeed.  QIF treats the L[XX] as Asset/Liability account and LXX as an
Income/Expense account (Category).
-derek

On Sun, January 7, 2024 6:53 pm, Geoff wrote:
> Hi Fred
>
> At a guess I think the problem is the square brackets "[]" surrounding
> the Account Names - try removing them.
>
> This:
>  > L[Expenses:fees]
>
> Should be:
>  > LExpenses:fees
>
>
> Regards
>
> Geoff
> =
>
> On 7/01/2024 2:01 pm, Fred Tydeman wrote:
>> Running GC 4.14 on Linux
>> During an import of a QIF file, I am getting "Failed" on the QIF Import
>> screen.
>> The message at the top of the box says there should be details shown
>> below
>> for my review.  However, there are no details about the failure.
>>
>> Suggestions on where I should look for the details of the failure?
>>
>> The entire QIF file is:
>>
>> !Account
>> NAssets:Investments
>> TInvst
>> ^
>> !Type:Invst
>> ^
>> D02/26/2021
>> NMiscExp
>> CX
>> T0.12
>> Mfee
>> L[Expenses:fees]
>> ^
>> D03/31/2021
>> NMiscExp
>> CX
>> T0.24
>> Mfee
>> L[Expenses:fees]
>> ^
>> D04/30/2021
>> NMiscExp
>> CX
>> T0.38
>> Mfee
>> L[Expenses:fees]
>> ^
>> D05/28/2021
>> NMiscExp
>> CX
>> T0.51
>> Mfee
>> L[Expenses:fees]
>> ^
>> D06/30/2021
>> NMiscExp
>> CX
>> T0.64
>> Mfee
>> L[Expenses:fees]
>> ^
>>
>> As an experiment,
>> I changed
>>   L[Expenses:fees]
>> to
>>   LFees
>>
>> and that imported just fine (although I had to pick the mapping of Fees
>> to
>> Expenses:Fees during the import process).
>> ___
>> 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.
>


-- 
   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] QIF import Failed

[Geoff]

Hi Fred

At a guess I think the problem is the square brackets "[]" surrounding 
the Account Names - try removing them.


This:
> L[Expenses:fees]

Should be:
> LExpenses:fees


Regards

Geoff
=

On 7/01/2024 2:01 pm, Fred Tydeman wrote:

Running GC 4.14 on Linux
During an import of a QIF file, I am getting "Failed" on the QIF Import
screen.
The message at the top of the box says there should be details shown below
for my review.  However, there are no details about the failure.

Suggestions on where I should look for the details of the failure?

The entire QIF file is:

!Account
NAssets:Investments
TInvst
^
!Type:Invst
^
D02/26/2021
NMiscExp
CX
T0.12
Mfee
L[Expenses:fees]
^
D03/31/2021
NMiscExp
CX
T0.24
Mfee
L[Expenses:fees]
^
D04/30/2021
NMiscExp
CX
T0.38
Mfee
L[Expenses:fees]
^
D05/28/2021
NMiscExp
CX
T0.51
Mfee
L[Expenses:fees]
^
D06/30/2021
NMiscExp
CX
T0.64
Mfee
L[Expenses:fees]
^

As an experiment,
I changed
  L[Expenses:fees]
to
  LFees

and that imported just fine (although I had to pick the mapping of Fees to
Expenses:Fees during the import process).
___
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] Moving from Quicken

[Fross, Michael]

I would also add that the ability to download from your bank is VERY
dependent on the bank's support of non-Quicken downloads.  My banks, for
example, no longer allow OFX (I'm in the US) downloads unless it's Quicken.

The good news is you can test all of this out in parallel before you
make your decision.  I left Quicken 9 years ago and have been much happier
in GNUCash, but your needs may differ.

Michael

On Sun, Jan 7, 2024 at 11:11 AM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

> But THESE are done differently in standard double entry bookkeeping.
>
> - allow me to assign a category to each transaction.
> - create categories (or import quicken categories) and assign each as tax
> deductible or not.
>
> You will be creating ACCOUNTS and these can be in a hierarchy. Thus under
> the account "expenses" you could have two children, "tax deductible" and
> "non-tax deductible". Under these you would create child accounts.
>
> I suggest at a minimum you read the tutorial about the basics of double
> entry bookkeeping. A standard "101" text would be even better. The issue is
> that there can be only ONE hierarchy of accounts (called the chart of
> accounts, aka CoA) so when you want the effect of a transaction being in
> more than one "category" you have to give the CoA a finer structure, and
> for reports on just a "category" you may need to to account selection*
>
> Michael D Novack
>
> * quicker/easier to just run the full report, export that, and edit the
> raw report data to discard what you don't want.
>
> milliken wrote:
> > I've been frustrated using Quicken for years.  Maybe GNUcash will do
> what I want.
> >
> > My list of functions is small:
> > I use Quicken for personal accounting, mainly to categorize transactions
> for tax reporting.
> > Can GNUcash do these things:
> > - import data from a Quicken QDF file as a starting point.
> > - allow downloads of transactions from my bank accounts and credit cards.
> > - allow me to assign a category to each transaction.
> > - create categories (or import quicken categories) and assign each as
> tax deductible or not.
> > - report and summarize tax deductible transaction at tax time.
> >
> > That's all I care about.
>
>
>
>
>
>
> ___
> 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] Moving from Quicken

[Ken Farley]

Others will likely help you get going on things like downloading bank 
transactions and the other things. As far as bringing Quicken data over 
to Gnucash, I did a big block of that a little over a year ago, because 
I wanted to have all the history available. Here's a regurgitation of a 
long message I wrote to a previous inquiry, detailing my process.



--- [ Past Message about Quicken Data Transfer ] ---

I just did this for about 12 years of old Quicken data. I've had dozens
of different accounts over the years, most of which are gone.

My technique was arrived at after trying a lot of different things,
reading the Wiki, etc.

First, I had to get my hands on an old computer that I could use to
install my Q 2011 (from CD, of all things).

I installed Quicken 2011 and plugged in a USB stick with all my old QDF
files.

After trying a lot of things, getting a massive mess of nonsense, etc. I
arrived at a method that worked really well for me.

I arbitrarily decided I'd tackle the data one year at a time.

I had Quicken spit out a QIF for the first year of interest, 2000, with
a complete set of data from its beginnings (in 1990s) until 2000-12-31.
I don't know about your previous software, but I found I had to
*explicitly* dictate the program to give me all the data. It defaulted to
just what it considered important, skipping stuff like securities and
other important stuff.

I started a new Gnucash file, cancelling out of the account creation it
starts with. I didn't want to set up any accounts, 'cause I learned it
was easier to rename and reorganize the stuff pulled in from the QIF
file than try to remember the admittedly unrefined organization I
implemented 20 years ago.

I imported the 2000 and earlier QIF file, taking everything it had. For
me, all the accounts except a few were brought into Gnucash as top
level. This is good I thought, because I was then able to move things
into the appropriate sub-accounts, like Assets, Expenses, and the like.

Now was the toughest part. Re-organizing. I created a "proper" structure
of top-level accounts and sub-accounts, in line with what I do in my
current Gnucash data files. I found in previous experimentation that it
was best if I moved virtually all the accounts created by the QIF import
into sub-accounts. For example, what came in as

"ABC Checking Account"

was now in

"Assets->Bank->Checking->ABC Checking Account"

Reorganizing let me take all the weird things Quicken does (it handles
stock splits in a goofy way, for example) and implement them in the
Gnucash fashion, which is really much more understandable. Quicken also
seems to have allowed me to make stupid mistakes that I was hopefully
able to correct during my review and reorganization.

Once I had that first years worth of stuff imported and fixed up, the
next steps were easier.

Read the next year's worth of data in. I don't know what you intend to
do, or currently do, but I keep my taxes, income, expenses in
sub-accounts for each year. Bringing in each year's data (from, for
example, 2001-01-01 to 2001-12-31) I could easily re-organize it into
the proper sub-account structure. It's a lot of editing and checking,
but hey, you've gotta have a hobby, right?

The two Gnucash program features that were amazingly helpful for this
task were:

(1) Editing accounts and changing their parent. This makes re-organizing
the structure incredibly easy.

(2) Being able to delete an account and move its transactions to another
account. This was how I got all the transactions for the year's data I
just read in to be included in the previous years' data. For example I
can delete the "ABC Checking Account" from the most recent year's data
and put all the transactions into the "Assets->Bank->Checking->ABC
Checking Account" one.


So, it's a tedious process, but you can work through it pretty quickly
once you get the knack. I'll say this, I'm amazed at how nice Gnucash is
to do this kind of massive data manipulation. Quicken gave me a lot of
"unspecified" stuff, probably my fault for entering it improperly, but
Gnucash let me clean it up pretty easily. And the aforementioned account
editing was a lifesaver.

Hopefully your previous software is available to let you export
sufficient data for import into Gnucash. If you want to have all that
historical data it is really nice. Plus, even with a file with hundreds
and hundreds of accounts and a decade of data, Gnucash is incredibly
fast to read it and let me navigate around. And I have all my old stuff
at hand, instead of buried in data files I honestly couldn't read anymore.
___
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] Moving from Quicken

[Michael or Penny Novack]

But THESE are done differently in standard double entry bookkeeping.

- allow me to assign a category to each transaction.
- create categories (or import quicken categories) and assign each as tax 
deductible or not.

You will be creating ACCOUNTS and these can be in a hierarchy. Thus under the account "expenses" 
you could have two children, "tax deductible" and "non-tax deductible". Under these you 
would create child accounts.

I suggest at a minimum you read the tutorial about the basics of double entry bookkeeping. A standard 
"101" text would be even better. The issue is that there can be only ONE hierarchy of accounts 
(called the chart of accounts, aka CoA) so when you want the effect of a transaction being in more than one 
"category" you have to give the CoA a finer structure, and for reports on just a 
"category" you may need to to account selection*

Michael D Novack

* quicker/easier to just run the full report, export that, and edit the raw 
report data to discard what you don't want.

milliken wrote:

I've been frustrated using Quicken for years.  Maybe GNUcash will do what I 
want.

My list of functions is small:
I use Quicken for personal accounting, mainly to categorize transactions for 
tax reporting.
Can GNUcash do these things:
- import data from a Quicken QDF file as a starting point.
- allow downloads of transactions from my bank accounts and credit cards.
- allow me to assign a category to each transaction.
- create categories (or import quicken categories) and assign each as tax 
deductible or not.
- report and summarize tax deductible transaction at tax time.

That's all I care about.







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