Re: [GNC] Feature request: Import assistant, room for big improvements

[Christopher Lam]

On Tue, 16 Jan 2024, 2:13 pm David Cousens, 
wrote:

>
> I haven't yet imported anything under v5.5. but will be catching up in a
> few
> days. Being able to edit/add data to the description and or memo fields
> would be
> something I would find useful too as the imported bank data often has
> limited
> info about what the purchase was for


(Bis) have you tried right click the transaction(s) during the import
matching process?


>
>
> David Cousens
>
>
>
>
> On Mon, 2024-01-15 at 22:48 -0600, David Carlson wrote:
> > Which import assistant is being discussed here?  The Generic assistant
> > behind the OFX and QIF imports is quite limited in placing new
> transactions
> > into the desired account or in matching incoming transactions to correct
> > pre-existing transactions, but the new CSV transaction importer is
> better,
> > if harder to configure optimally.  Also, I think they all have changed in
> > recent GnuCash releases, so tell us which release you are currently
> using.
> >
> > I doubt that the Generic assistant can be improved very much unless it is
> > completely rewritten.
> >
> >
> > On Mon, Jan 15, 2024 at 10:26 PM Phyllis Bruce 
> wrote:
> >
> > > 
> > >
> > >
> > > > On Jan 15, 2024, at 10:17 PM, Derek Atkins  wrote:
> > > >
> > > > 
> > > > No, I would call that the description.
> > > > -derek
> > > > Sent using my mobile device. Please excuse any typos.
> > > >
> > > > > On January 15, 2024 23:06:07 Phyllis Bruce 
> wrote:
> > > > >
> > > > > Thanks, David.  I think I am being unclear.  My research provides
> what
> > > you
> > > > > call the transfer account for unmatched items.  That's all good.
> It is
> > > the
> > > > > memo field which I use to remind me of what I did that is not
> available
> > > in
> > > > > the reconciliation screen.  For instance I want to remember that I
> paid
> > > > > Amazon for *smart plugs*, or Sandi paid me $70 for *her share of
> > > groceries
> > > > > at Christmas*.  Would you call that the "action"?
> > > > >
> > > > > On Mon, Jan 15, 2024 at 3:21 PM David Cousens <
> davidcousen...@gmail.com
> > > >
> > > > > wrote:
> > > > >
> > > > > > Ulrich,
> > > > > >
> > > > > > There is nothing to stop you supplying the transfer account
> > > information in
> > > > > > an
> > > > > > import record if it is available. There is a header which can be
> > > assigned
> > > > > > to the
> > > > > > appropriate column of your input file for the transfer account.
> > > > > >
> > > > > > The first time you import with a given account name in he record
> you
> > > will
> > > > > > be
> > > > > > asked to specify the internal GnuCash account to which it
> corresponds.
> > > > > > After
> > > > > > that it will be matched to that account.
> > > > > >
> > > > > > The Bayesian process only assigns a probable account in cases
> where
> > > > > > the
> > > > > > import
> > > > > > record does not specify the  transfer account.
> > > > > >
> > > > > > David Cousens
> > > > > >
> > > > > > > On Mon, 2024-01-15 at 20:17 +0100, Ulrich Grün wrote:
> > > > > > > Hello fellow GnuCash users,
> > > > > > >
> > > > > > > I wonder if there are plans on improving the import filter, for
> > > importing
> > > > > > > bank transfers.
> > > > > > > The situation now is, that some hidden engine tries to learn
> from
> > > doing.
> > > > > > > But the truth is, that even after one year of importing bank
> > > transfers, I
> > > > > > > have to check every single transaction, since errors keep
> occurring.
> > > If I
> > > > > > > miss an error, this transaction is put in the wrong ledger
> account.
> > > > > > >
> > > > > > > E-boekhouden.nl uses an import assistant where you can specify
> a
> > > ledger
> > > > > > > account number, other keywords and/or amounts of money. The
> import
> > > > > > > assistant puts the transactions into the right ledger account,
> with
> > > far
> > > > > > > less errors than with GnuCash. In fact, only where a specific
> > > > > > > keyword,
> > > > > > > leger number or amount is missing, or where no import rule is
> made
> > > for a
> > > > > > > specific payment, the transaction has to be placed into the
> right
> > > general
> > > > > > > ledger by hand.
> > > > > > >
> > > > > > > Have a nice day!
> > > > > > >
> > > > > > > --
> > > > > > > नमस्ते (Namasté),
> > > > > > > Ulrich
> > > > > > >
> > > > > > >
> > > > > >
> > >
> ¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸
> > > ,ø
> > > > > > > ¤º°`°º¤ø
> > > > > > >
> > > > > > > " Can't talk to you without talking to me; we're guilty of the
> same
> > > old
> > > > > > > thing.
> > > > > > >   Thinking a lot about less and less, and forgetting the Love
> we
> > > > > > > bring "
> > > > > > >[Grateful Dead, in: 'Althea']
> > > > > > >
> > > > > > >
> > > > > >
> > >
> ¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸
> > > ,ø
> > > > > > > ¤º°`°º¤ø
> > > > > > >  Mijn blog: ✡ 

Re: [GNC] Feature request: Import assistant, room for big improvements

[David Cousens]

From memory David the import matcher process is common to all the front ends to
read different file formats. It's been a while since I went through the code
after Geert rewrote the CSV front end but I doubt that it has changed all that
much. I have found the Bayesian matcher works fairly well apart from a few
specific transactions where there is insufficient information in the data record
to correctly assign. I typically only have to manually assign may be 10 records
out of more than 50-60 records imported for my credit card account each month.

I haven't yet imported anything under v5.5. but will be catching up in a few
days. Being able to edit/add data to the description and or memo fields would be
something I would find useful too as the imported bank data often has limited
info about what the purchase was for 
 

David Cousens




On Mon, 2024-01-15 at 22:48 -0600, David Carlson wrote:
> Which import assistant is being discussed here?  The Generic assistant
> behind the OFX and QIF imports is quite limited in placing new transactions
> into the desired account or in matching incoming transactions to correct
> pre-existing transactions, but the new CSV transaction importer is better,
> if harder to configure optimally.  Also, I think they all have changed in
> recent GnuCash releases, so tell us which release you are currently using.
> 
> I doubt that the Generic assistant can be improved very much unless it is
> completely rewritten.
> 
> 
> On Mon, Jan 15, 2024 at 10:26 PM Phyllis Bruce  wrote:
> 
> > 
> > 
> > 
> > > On Jan 15, 2024, at 10:17 PM, Derek Atkins  wrote:
> > > 
> > > 
> > > No, I would call that the description.
> > > -derek
> > > Sent using my mobile device. Please excuse any typos.
> > > 
> > > > On January 15, 2024 23:06:07 Phyllis Bruce  wrote:
> > > > 
> > > > Thanks, David.  I think I am being unclear.  My research provides what
> > you
> > > > call the transfer account for unmatched items.  That's all good.  It is
> > the
> > > > memo field which I use to remind me of what I did that is not available
> > in
> > > > the reconciliation screen.  For instance I want to remember that I paid
> > > > Amazon for *smart plugs*, or Sandi paid me $70 for *her share of
> > groceries
> > > > at Christmas*.  Would you call that the "action"?
> > > > 
> > > > On Mon, Jan 15, 2024 at 3:21 PM David Cousens  > > 
> > > > wrote:
> > > > 
> > > > > Ulrich,
> > > > > 
> > > > > There is nothing to stop you supplying the transfer account
> > information in
> > > > > an
> > > > > import record if it is available. There is a header which can be
> > assigned
> > > > > to the
> > > > > appropriate column of your input file for the transfer account.
> > > > > 
> > > > > The first time you import with a given account name in he record you
> > will
> > > > > be
> > > > > asked to specify the internal GnuCash account to which it corresponds.
> > > > > After
> > > > > that it will be matched to that account.
> > > > > 
> > > > > The Bayesian process only assigns a probable account in cases where
> > > > > the
> > > > > import
> > > > > record does not specify the  transfer account.
> > > > > 
> > > > > David Cousens
> > > > > 
> > > > > > On Mon, 2024-01-15 at 20:17 +0100, Ulrich Grün wrote:
> > > > > > Hello fellow GnuCash users,
> > > > > > 
> > > > > > I wonder if there are plans on improving the import filter, for
> > importing
> > > > > > bank transfers.
> > > > > > The situation now is, that some hidden engine tries to learn from
> > doing.
> > > > > > But the truth is, that even after one year of importing bank
> > transfers, I
> > > > > > have to check every single transaction, since errors keep occurring.
> > If I
> > > > > > miss an error, this transaction is put in the wrong ledger account.
> > > > > > 
> > > > > > E-boekhouden.nl uses an import assistant where you can specify a
> > ledger
> > > > > > account number, other keywords and/or amounts of money. The import
> > > > > > assistant puts the transactions into the right ledger account, with
> > far
> > > > > > less errors than with GnuCash. In fact, only where a specific
> > > > > > keyword,
> > > > > > leger number or amount is missing, or where no import rule is made
> > for a
> > > > > > specific payment, the transaction has to be placed into the right
> > general
> > > > > > ledger by hand.
> > > > > > 
> > > > > > Have a nice day!
> > > > > > 
> > > > > > --
> > > > > > नमस्ते (Namasté),
> > > > > > Ulrich
> > > > > > 
> > > > > > 
> > > > > 
> > ¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸
> > ,ø
> > > > > > ¤º°`°º¤ø
> > > > > > 
> > > > > > " Can't talk to you without talking to me; we're guilty of the same
> > old
> > > > > > thing.
> > > > > >   Thinking a lot about less and less, and forgetting the Love we
> > > > > > bring "
> > > > > >    [Grateful Dead, in: 'Althea']
> > > > > > 
> > > > > > 
> > > > > 
> > 

Re: [GNC] Feature request: Import assistant, room for big improvements

[Steve Butler]

I do it every OFX import.  Works well.  Ubuntu 23.10.  GnC 5.4-117.

Need anything else?  BTW, works fine, the right click.


On Mon, Jan 15, 2024, 21:12 Christopher Lam 
wrote:

> Has anyone tried right click the relevant transaction(s) in the ofx or csv
> import assistant?
>
> On Tue, 16 Jan 2024, 12:49 pm David Carlson, 
> wrote:
>
> > Which import assistant is being discussed here?  The Generic assistant
> > behind the OFX and QIF imports is quite limited in placing new
> transactions
> > into the desired account or in matching incoming transactions to correct
> > pre-existing transactions, but the new CSV transaction importer is
> better,
> > if harder to configure optimally.  Also, I think they all have changed in
> > recent GnuCash releases, so tell us which release you are currently
> using.
> >
> > I doubt that the Generic assistant can be improved very much unless it is
> > completely rewritten.
> >
> >
> > On Mon, Jan 15, 2024 at 10:26 PM Phyllis Bruce 
> > wrote:
> >
> > > 
> > >
> > >
> > > > On Jan 15, 2024, at 10:17 PM, Derek Atkins  wrote:
> > > >
> > > > 
> > > > No, I would call that the description.
> > > > -derek
> > > > Sent using my mobile device. Please excuse any typos.
> > > >
> > > >> On January 15, 2024 23:06:07 Phyllis Bruce 
> > wrote:
> > > >>
> > > >> Thanks, David.  I think I am being unclear.  My research provides
> what
> > > you
> > > >> call the transfer account for unmatched items.  That's all good.  It
> > is
> > > the
> > > >> memo field which I use to remind me of what I did that is not
> > available
> > > in
> > > >> the reconciliation screen.  For instance I want to remember that I
> > paid
> > > >> Amazon for *smart plugs*, or Sandi paid me $70 for *her share of
> > > groceries
> > > >> at Christmas*.  Would you call that the "action"?
> > > >>
> > > >> On Mon, Jan 15, 2024 at 3:21 PM David Cousens <
> > davidcousen...@gmail.com
> > > >
> > > >> wrote:
> > > >>
> > > >>> Ulrich,
> > > >>>
> > > >>> There is nothing to stop you supplying the transfer account
> > > information in
> > > >>> an
> > > >>> import record if it is available. There is a header which can be
> > > assigned
> > > >>> to the
> > > >>> appropriate column of your input file for the transfer account.
> > > >>>
> > > >>> The first time you import with a given account name in he record
> you
> > > will
> > > >>> be
> > > >>> asked to specify the internal GnuCash account to which it
> > corresponds.
> > > >>> After
> > > >>> that it will be matched to that account.
> > > >>>
> > > >>> The Bayesian process only assigns a probable account in cases where
> > the
> > > >>> import
> > > >>> record does not specify the  transfer account.
> > > >>>
> > > >>> David Cousens
> > > >>>
> > >  On Mon, 2024-01-15 at 20:17 +0100, Ulrich Grün wrote:
> > >  Hello fellow GnuCash users,
> > > 
> > >  I wonder if there are plans on improving the import filter, for
> > > importing
> > >  bank transfers.
> > >  The situation now is, that some hidden engine tries to learn from
> > > doing.
> > >  But the truth is, that even after one year of importing bank
> > > transfers, I
> > >  have to check every single transaction, since errors keep
> occurring.
> > > If I
> > >  miss an error, this transaction is put in the wrong ledger
> account.
> > > 
> > >  E-boekhouden.nl uses an import assistant where you can specify a
> > > ledger
> > >  account number, other keywords and/or amounts of money. The import
> > >  assistant puts the transactions into the right ledger account,
> with
> > > far
> > >  less errors than with GnuCash. In fact, only where a specific
> > keyword,
> > >  leger number or amount is missing, or where no import rule is made
> > > for a
> > >  specific payment, the transaction has to be placed into the right
> > > general
> > >  ledger by hand.
> > > 
> > >  Have a nice day!
> > > 
> > >  --
> > >  नमस्ते (Namasté),
> > >  Ulrich
> > > 
> > > 
> > > >>>
> > >
> >
> ¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø
> > >  ¤º°`°º¤ø
> > > 
> > >  " Can't talk to you without talking to me; we're guilty of the
> same
> > > old
> > >  thing.
> > >    Thinking a lot about less and less, and forgetting the Love we
> > >  bring "
> > > [Grateful Dead, in: 'Althea']
> > > 
> > > 
> > > >>>
> > >
> >
> ¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø
> > >  ¤º°`°º¤ø
> > >   Mijn blog: ✡ theskepticaltheist.eu ✡
> > >  ___
> > >  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.
> > >  

Re: [GNC] Feature request: Import assistant, room for big improvements

[Christopher Lam]

Has anyone tried right click the relevant transaction(s) in the ofx or csv
import assistant?

On Tue, 16 Jan 2024, 12:49 pm David Carlson, 
wrote:

> Which import assistant is being discussed here?  The Generic assistant
> behind the OFX and QIF imports is quite limited in placing new transactions
> into the desired account or in matching incoming transactions to correct
> pre-existing transactions, but the new CSV transaction importer is better,
> if harder to configure optimally.  Also, I think they all have changed in
> recent GnuCash releases, so tell us which release you are currently using.
>
> I doubt that the Generic assistant can be improved very much unless it is
> completely rewritten.
>
>
> On Mon, Jan 15, 2024 at 10:26 PM Phyllis Bruce 
> wrote:
>
> > 
> >
> >
> > > On Jan 15, 2024, at 10:17 PM, Derek Atkins  wrote:
> > >
> > > 
> > > No, I would call that the description.
> > > -derek
> > > Sent using my mobile device. Please excuse any typos.
> > >
> > >> On January 15, 2024 23:06:07 Phyllis Bruce 
> wrote:
> > >>
> > >> Thanks, David.  I think I am being unclear.  My research provides what
> > you
> > >> call the transfer account for unmatched items.  That's all good.  It
> is
> > the
> > >> memo field which I use to remind me of what I did that is not
> available
> > in
> > >> the reconciliation screen.  For instance I want to remember that I
> paid
> > >> Amazon for *smart plugs*, or Sandi paid me $70 for *her share of
> > groceries
> > >> at Christmas*.  Would you call that the "action"?
> > >>
> > >> On Mon, Jan 15, 2024 at 3:21 PM David Cousens <
> davidcousen...@gmail.com
> > >
> > >> wrote:
> > >>
> > >>> Ulrich,
> > >>>
> > >>> There is nothing to stop you supplying the transfer account
> > information in
> > >>> an
> > >>> import record if it is available. There is a header which can be
> > assigned
> > >>> to the
> > >>> appropriate column of your input file for the transfer account.
> > >>>
> > >>> The first time you import with a given account name in he record you
> > will
> > >>> be
> > >>> asked to specify the internal GnuCash account to which it
> corresponds.
> > >>> After
> > >>> that it will be matched to that account.
> > >>>
> > >>> The Bayesian process only assigns a probable account in cases where
> the
> > >>> import
> > >>> record does not specify the  transfer account.
> > >>>
> > >>> David Cousens
> > >>>
> >  On Mon, 2024-01-15 at 20:17 +0100, Ulrich Grün wrote:
> >  Hello fellow GnuCash users,
> > 
> >  I wonder if there are plans on improving the import filter, for
> > importing
> >  bank transfers.
> >  The situation now is, that some hidden engine tries to learn from
> > doing.
> >  But the truth is, that even after one year of importing bank
> > transfers, I
> >  have to check every single transaction, since errors keep occurring.
> > If I
> >  miss an error, this transaction is put in the wrong ledger account.
> > 
> >  E-boekhouden.nl uses an import assistant where you can specify a
> > ledger
> >  account number, other keywords and/or amounts of money. The import
> >  assistant puts the transactions into the right ledger account, with
> > far
> >  less errors than with GnuCash. In fact, only where a specific
> keyword,
> >  leger number or amount is missing, or where no import rule is made
> > for a
> >  specific payment, the transaction has to be placed into the right
> > general
> >  ledger by hand.
> > 
> >  Have a nice day!
> > 
> >  --
> >  नमस्ते (Namasté),
> >  Ulrich
> > 
> > 
> > >>>
> >
> ¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø
> >  ¤º°`°º¤ø
> > 
> >  " Can't talk to you without talking to me; we're guilty of the same
> > old
> >  thing.
> >    Thinking a lot about less and less, and forgetting the Love we
> >  bring "
> > [Grateful Dead, in: 'Althea']
> > 
> > 
> > >>>
> >
> ¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø
> >  ¤º°`°º¤ø
> >   Mijn blog: ✡ theskepticaltheist.eu ✡
> >  ___
> >  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] Idiot 101 question

[Adrien Monteleone]

I was referring to the process of turning a running Windows installation 
into a VM from within that running installation. I know VMWare has such 
a tool, and I think Virtualbox does as well. (other virtualization 
solutions might too, and still yet, there might be 3rd party tools to 
accomplish the job)


Otherwise, you could create a VM for each OS, but don't install an OS 
into it, then simply point the boot device to the desired physical drive 
and boot the VM. It *should* boot up the drive as if it were running 
bare metal as the main OS. (but within the VM of course)


If you can plug in more than one drive to the working machine at a time, 
I'd do so, and set the Ubuntu drive as the first and only boot device. 
Then see if from within Ubuntu, you can see and mount the other drives. 
You might have to get dirty with command line tools though as some of 
the GUI apps for this don't always play nice. From the command line, you 
can also possibly run SMART tests on the offending (or every) drive. 
(The drive has to support SMART, but most drives made in the last 25 
years do, though maybe not the full spec.) Look into smartmontools for 
more on this.


Another option is to get an external drive caddy as you may have a 
problem with one or more of your internal SATA ports. (could be a bad 
data cable, or power cable too - so many things to try...)


And don't toss or destroy those drives. You might still be able to save 
them yet.


Best of luck.

Regards,
Adrien

On 1/15/24 9:47 PM, Jeff wrote:
I do not fully understand yet what has happened.  My "NEW" old tower 
recognized all of my drives I pulled from the blown up computers, then 
poof, the new computer suddenly doesn't recognize them anymore (all of 
the ssd boot drives).  I got lucky tonight and found the drive for my 
Ubuntu server or I would not be responding.


If I cannot get the sata drive from my laptop back up and running then I 
am screwed for taxes (Stupid me I forgot to backup 2022). I can still do 
the book keeping from here if I can keep Ubuntu up and running (except 
that some of the financial institution ID an passwords that are on a 
windowze drive).  Much easier under__Ubuntu and a work station. 
Unfortunately for me, the tax software is on a windozs drive that I can 
no longer access.

_
_I have not tried using a VM, as this tower suddenly decided that 
several of my drives no longer exist.


How would I move it to a VM?



___
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] Feature request: Import assistant, room for big improvements

[David Carlson]

Which import assistant is being discussed here?  The Generic assistant
behind the OFX and QIF imports is quite limited in placing new transactions
into the desired account or in matching incoming transactions to correct
pre-existing transactions, but the new CSV transaction importer is better,
if harder to configure optimally.  Also, I think they all have changed in
recent GnuCash releases, so tell us which release you are currently using.

I doubt that the Generic assistant can be improved very much unless it is
completely rewritten.


On Mon, Jan 15, 2024 at 10:26 PM Phyllis Bruce  wrote:

> 
>
>
> > On Jan 15, 2024, at 10:17 PM, Derek Atkins  wrote:
> >
> > 
> > No, I would call that the description.
> > -derek
> > Sent using my mobile device. Please excuse any typos.
> >
> >> On January 15, 2024 23:06:07 Phyllis Bruce  wrote:
> >>
> >> Thanks, David.  I think I am being unclear.  My research provides what
> you
> >> call the transfer account for unmatched items.  That's all good.  It is
> the
> >> memo field which I use to remind me of what I did that is not available
> in
> >> the reconciliation screen.  For instance I want to remember that I paid
> >> Amazon for *smart plugs*, or Sandi paid me $70 for *her share of
> groceries
> >> at Christmas*.  Would you call that the "action"?
> >>
> >> On Mon, Jan 15, 2024 at 3:21 PM David Cousens  >
> >> wrote:
> >>
> >>> Ulrich,
> >>>
> >>> There is nothing to stop you supplying the transfer account
> information in
> >>> an
> >>> import record if it is available. There is a header which can be
> assigned
> >>> to the
> >>> appropriate column of your input file for the transfer account.
> >>>
> >>> The first time you import with a given account name in he record you
> will
> >>> be
> >>> asked to specify the internal GnuCash account to which it corresponds.
> >>> After
> >>> that it will be matched to that account.
> >>>
> >>> The Bayesian process only assigns a probable account in cases where the
> >>> import
> >>> record does not specify the  transfer account.
> >>>
> >>> David Cousens
> >>>
>  On Mon, 2024-01-15 at 20:17 +0100, Ulrich Grün wrote:
>  Hello fellow GnuCash users,
> 
>  I wonder if there are plans on improving the import filter, for
> importing
>  bank transfers.
>  The situation now is, that some hidden engine tries to learn from
> doing.
>  But the truth is, that even after one year of importing bank
> transfers, I
>  have to check every single transaction, since errors keep occurring.
> If I
>  miss an error, this transaction is put in the wrong ledger account.
> 
>  E-boekhouden.nl uses an import assistant where you can specify a
> ledger
>  account number, other keywords and/or amounts of money. The import
>  assistant puts the transactions into the right ledger account, with
> far
>  less errors than with GnuCash. In fact, only where a specific keyword,
>  leger number or amount is missing, or where no import rule is made
> for a
>  specific payment, the transaction has to be placed into the right
> general
>  ledger by hand.
> 
>  Have a nice day!
> 
>  --
>  नमस्ते (Namasté),
>  Ulrich
> 
> 
> >>>
> ¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø
>  ¤º°`°º¤ø
> 
>  " Can't talk to you without talking to me; we're guilty of the same
> old
>  thing.
>    Thinking a lot about less and less, and forgetting the Love we
>  bring "
> [Grateful Dead, in: 'Althea']
> 
> 
> >>>
> ¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø
>  ¤º°`°º¤ø
>   Mijn blog: ✡ theskepticaltheist.eu ✡
>  ___
>  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.
> >
> >
> ___
> gnucash-user mailing list
> 

Re: [GNC] Feature request: Import assistant, room for big improvements

[Adrien Monteleone]

And I would call 'Amazon' the Description as Payee, and the Memo as the 
item/reason for a particular split. I use Notes for info pertaining to 
the entire transaction.


Would a multi-line CSV per transaction allow for inserting Memos?

Regards,
Adrien

On 1/15/24 10:17 PM, Derek Atkins wrote:

No, I would call that the description.
-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] Idiot 101 question

[David Carlson]

I would recommend taking a few weeks learning how VM's work before doing it
yourself,but for a person knowledgeable about VM's it would be
straightforward if you can install or otherwise attach a physical drive to
your computer then configure a VM to use it as it's primary drive.  I
recommend having a knowledgeable friend do it.  I have been 'playing' with
VM's for a couple of years now and I have been burned several times while
learning how they work.  I still do not do anything serious solely in a VM.

On Mon, Jan 15, 2024 at 9:48 PM Jeff  wrote:

> On 1/11/24 10:10 AM, Adrien Monteleone wrote:
> > If their drives with OS installations are intact, perhaps converting
> > them to VM images might suffice for now.
> >
> > As for Windows software, have you given the latest Wine a spin with
> > it? It may not work 100% out of the box, but you might get close
> > enough with some fiddling.
> >
> > Regards,
> > Adrien
> >
> > On 1/11/24 2:15 AM, Jeff wrote:
> >> I'm just trying to get back to gnc and unfortunately a windows
> >> program, H@r Block.  Without at least 2 computers this almost
> >> difficult task unless you have a way to run H@r Block windows version
> >> 2023 under ubuntu?
> >>
> >> And right now I have only one computer.  A surge supseror exploded
> >> and fried all of my computers.  I have a temporary replacement for
> >> the network server but not any workstations.
> >
> > ___
> > 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.
>
> Adrien:
>
> I do not fully understand yet what has happened.  My "NEW" old tower
> recognized all of my drives I pulled from the blown up computers, then
> poof, the new computer suddenly doesn't recognize them anymore (all of
> the ssd boot drives).  I got lucky tonight and found the drive for my
> Ubuntu server or I would not be responding.
>
> If I cannot get the sata drive from my laptop back up and running then I
> am screwed for taxes (Stupid me I forgot to backup 2022). I can still do
> the book keeping from here if I can keep Ubuntu up and running (except
> that some of the financial institution ID an passwords that are on a
> windowze drive).  Much easier under__Ubuntu and a work station.
> Unfortunately for me, the tax software is on a windozs drive that I can
> no longer access.
> _
> _I have not tried using a VM, as this tower suddenly decided that
> several of my drives no longer exist.
>
> How would I move it to a VM?
>
> --
> --JEffrey Black M.B.A.
> ___
> 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] Feature request: Import assistant, room for big improvements

[Phyllis Bruce]




> On Jan 15, 2024, at 10:17 PM, Derek Atkins  wrote:
> 
> 
> No, I would call that the description. 
> -derek
> Sent using my mobile device. Please excuse any typos.
> 
>> On January 15, 2024 23:06:07 Phyllis Bruce  wrote:
>> 
>> Thanks, David.  I think I am being unclear.  My research provides what you
>> call the transfer account for unmatched items.  That's all good.  It is the
>> memo field which I use to remind me of what I did that is not available in
>> the reconciliation screen.  For instance I want to remember that I paid
>> Amazon for *smart plugs*, or Sandi paid me $70 for *her share of groceries
>> at Christmas*.  Would you call that the "action"?
>> 
>> On Mon, Jan 15, 2024 at 3:21 PM David Cousens 
>> wrote:
>> 
>>> Ulrich,
>>> 
>>> There is nothing to stop you supplying the transfer account information in
>>> an
>>> import record if it is available. There is a header which can be assigned
>>> to the
>>> appropriate column of your input file for the transfer account.
>>> 
>>> The first time you import with a given account name in he record you will
>>> be
>>> asked to specify the internal GnuCash account to which it corresponds.
>>> After
>>> that it will be matched to that account.
>>> 
>>> The Bayesian process only assigns a probable account in cases where the
>>> import
>>> record does not specify the  transfer account.
>>> 
>>> David Cousens
>>> 
 On Mon, 2024-01-15 at 20:17 +0100, Ulrich Grün wrote:
 Hello fellow GnuCash users,
 
 I wonder if there are plans on improving the import filter, for importing
 bank transfers.
 The situation now is, that some hidden engine tries to learn from doing.
 But the truth is, that even after one year of importing bank transfers, I
 have to check every single transaction, since errors keep occurring. If I
 miss an error, this transaction is put in the wrong ledger account.
 
 E-boekhouden.nl uses an import assistant where you can specify a ledger
 account number, other keywords and/or amounts of money. The import
 assistant puts the transactions into the right ledger account, with far
 less errors than with GnuCash. In fact, only where a specific keyword,
 leger number or amount is missing, or where no import rule is made for a
 specific payment, the transaction has to be placed into the right general
 ledger by hand.
 
 Have a nice day!
 
 --
 नमस्ते (Namasté),
 Ulrich
 
 
>>> ¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø
 ¤º°`°º¤ø
 
 " Can't talk to you without talking to me; we're guilty of the same old
 thing.
   Thinking a lot about less and less, and forgetting the Love we
 bring "
[Grateful Dead, in: 'Althea']
 
 
>>> ¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø
 ¤º°`°º¤ø
  Mijn blog: ✡ theskepticaltheist.eu ✡
 ___
 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.
> 
> 
___
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] Feature request: Import assistant, room for big improvements

[Derek Atkins]

No, I would call that the description.
-derek
Sent using my mobile device. Please excuse any typos.
On January 15, 2024 23:06:07 Phyllis Bruce  wrote:


Thanks, David.  I think I am being unclear.  My research provides what you
call the transfer account for unmatched items.  That's all good.  It is the
memo field which I use to remind me of what I did that is not available in
the reconciliation screen.  For instance I want to remember that I paid
Amazon for *smart plugs*, or Sandi paid me $70 for *her share of groceries
at Christmas*.  Would you call that the "action"?

On Mon, Jan 15, 2024 at 3:21 PM David Cousens 
wrote:


Ulrich,

There is nothing to stop you supplying the transfer account information in
an
import record if it is available. There is a header which can be assigned
to the
appropriate column of your input file for the transfer account.

The first time you import with a given account name in he record you will
be
asked to specify the internal GnuCash account to which it corresponds.
After
that it will be matched to that account.

The Bayesian process only assigns a probable account in cases where the
import
record does not specify the  transfer account.

David Cousens

On Mon, 2024-01-15 at 20:17 +0100, Ulrich Grün wrote:
> Hello fellow GnuCash users,
>
> I wonder if there are plans on improving the import filter, for importing
> bank transfers.
> The situation now is, that some hidden engine tries to learn from doing.
> But the truth is, that even after one year of importing bank transfers, I
> have to check every single transaction, since errors keep occurring. If I
> miss an error, this transaction is put in the wrong ledger account.
>
> E-boekhouden.nl uses an import assistant where you can specify a ledger
> account number, other keywords and/or amounts of money. The import
> assistant puts the transactions into the right ledger account, with far
> less errors than with GnuCash. In fact, only where a specific keyword,
> leger number or amount is missing, or where no import rule is made for a
> specific payment, the transaction has to be placed into the right general
> ledger by hand.
>
> Have a nice day!
>
> --
> नमस्ते (Namasté),
> Ulrich
>
>
¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø
> ¤º°`°º¤ø
>
> " Can't talk to you without talking to me; we're guilty of the same old
> thing.
> Thinking a lot about less and less, and forgetting the Love we
> bring "
>  [Grateful Dead, in: 'Althea']
>
>
¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø
> ¤º°`°º¤ø
>Mijn blog: ✡ theskepticaltheist.eu ✡
> ___
> 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.


___
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] Feature request: Import assistant, room for big improvements

[Phyllis Bruce]

Thanks, David.  I think I am being unclear.  My research provides what you
call the transfer account for unmatched items.  That's all good.  It is the
memo field which I use to remind me of what I did that is not available in
the reconciliation screen.  For instance I want to remember that I paid
Amazon for *smart plugs*, or Sandi paid me $70 for *her share of groceries
at Christmas*.  Would you call that the "action"?

On Mon, Jan 15, 2024 at 3:21 PM David Cousens 
wrote:

> Ulrich,
>
> There is nothing to stop you supplying the transfer account information in
> an
> import record if it is available. There is a header which can be assigned
> to the
> appropriate column of your input file for the transfer account.
>
> The first time you import with a given account name in he record you will
> be
> asked to specify the internal GnuCash account to which it corresponds.
> After
> that it will be matched to that account.
>
> The Bayesian process only assigns a probable account in cases where the
> import
> record does not specify the  transfer account.
>
> David Cousens
>
> On Mon, 2024-01-15 at 20:17 +0100, Ulrich Grün wrote:
> > Hello fellow GnuCash users,
> >
> > I wonder if there are plans on improving the import filter, for importing
> > bank transfers.
> > The situation now is, that some hidden engine tries to learn from doing.
> > But the truth is, that even after one year of importing bank transfers, I
> > have to check every single transaction, since errors keep occurring. If I
> > miss an error, this transaction is put in the wrong ledger account.
> >
> > E-boekhouden.nl uses an import assistant where you can specify a ledger
> > account number, other keywords and/or amounts of money. The import
> > assistant puts the transactions into the right ledger account, with far
> > less errors than with GnuCash. In fact, only where a specific keyword,
> > leger number or amount is missing, or where no import rule is made for a
> > specific payment, the transaction has to be placed into the right general
> > ledger by hand.
> >
> > Have a nice day!
> >
> > --
> > नमस्ते (Namasté),
> > Ulrich
> >
> >
> ¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø
> > ¤º°`°º¤ø
> >
> > " Can't talk to you without talking to me; we're guilty of the same old
> > thing.
> > Thinking a lot about less and less, and forgetting the Love we
> > bring "
> >  [Grateful Dead, in: 'Althea']
> >
> >
> ¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø
> > ¤º°`°º¤ø
> >Mijn blog: ✡ theskepticaltheist.eu ✡
> > ___
> > 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] Idiot 101 question

[Jeff]

On 1/11/24 10:10 AM, Adrien Monteleone wrote:
If their drives with OS installations are intact, perhaps converting 
them to VM images might suffice for now.


As for Windows software, have you given the latest Wine a spin with 
it? It may not work 100% out of the box, but you might get close 
enough with some fiddling.


Regards,
Adrien

On 1/11/24 2:15 AM, Jeff wrote:
I'm just trying to get back to gnc and unfortunately a windows 
program, H@r Block.  Without at least 2 computers this almost 
difficult task unless you have a way to run H@r Block windows version 
2023 under ubuntu?


And right now I have only one computer.  A surge supseror exploded 
and fried all of my computers.  I have a temporary replacement for 
the network server but not any workstations.


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


Adrien:

I do not fully understand yet what has happened.  My "NEW" old tower 
recognized all of my drives I pulled from the blown up computers, then 
poof, the new computer suddenly doesn't recognize them anymore (all of 
the ssd boot drives).  I got lucky tonight and found the drive for my 
Ubuntu server or I would not be responding.


If I cannot get the sata drive from my laptop back up and running then I 
am screwed for taxes (Stupid me I forgot to backup 2022). I can still do 
the book keeping from here if I can keep Ubuntu up and running (except 
that some of the financial institution ID an passwords that are on a 
windowze drive).  Much easier under__Ubuntu and a work station.  
Unfortunately for me, the tax software is on a windozs drive that I can 
no longer access.

_
_I have not tried using a VM, as this tower suddenly decided that 
several of my drives no longer exist.


How would I move it to a VM?

--
--JEffrey Black M.B.A.
___
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] Deferred Income << the general case is "imputed income"

[R Losey]

That is a good point... I just want to try to do things "properly", but as
you point out, in a practical sense, it (probably) doesn't matter.  Plus,
it is helping my understanding and knowledge to grow, and I consider that a
good thing.


On Mon, Jan 15, 2024 at 8:49 PM Jediator  wrote:

> I am not an accountant, so please excuse my ignorance.  I was wondering
> is it really necessary to create a separate deferred income account when
> you could just do a transaction report on your IRA account to see how
> much distribution you had in a year or a month?  -- JC
>
> On 1/15/24 5:33 PM, Michael or Penny Novack wrote:
> > On 1/15/2024 4:02 PM, R Losey wrote:
> >> Thank you; this is helpful.
> >>
> >> I never really thought about recording Deferred Income previously
> >> because the investment people track it and let me know what has been
> >> taken out every year.  But after the discussion in this list last
> >> year, I thought it might be good to track, at least the taxable
> >> withdrawals.
> >>
> >> I see that Deferred Income should have been recorded, but it wasn't.
> >> Instead of using "Opening Balance" when they were set up, the amount
> >> should have been more appropriately credited to Deferred Income, right?
> >
> >
> > The fact that the government considers the TRANSFER of assets between
> > two asset accounts (the IRA and checking) to be a taxable event even
> > though no new money coming in can be considered as special case if
> > "imputed income" and you COULD simply treat all imputed income
> > situations the same.
> >
> > For example --- you might have as an employee benefit employer paid
> > group term insurance and your employer might even offer options like 5
> > years salary. Now the US government considers up to $50,000 face value
> > a non-taxable benefit but the premium for coverage above that amount
> > as "imputed income". In other words, this will appear on your pay stub
> > as part of your total taxable income even though you didn't actually
> > receive that as money.
> >
> > Well in the big split where you enter your salary you could handle
> > that little piece using equity for the other side. As I have already
> > noted, NOT actually changing total equity to both debit and credit
> > equity by the same amount (the credit side being an income account,
> > but both income and expense accounts "really: of type equity and the
> > net of all unclosed income and expense accounts appearing with equity
> > as "retained gains (or losses)"
> >
> > Some of us had to deal with other "imputed income". Thus if we had a
> > "split dollar" insurance benefit* the premium for that amount of term
> > coverage would show as an "imputed income" amount.
> >
> > Michael D Novack
> >
> > * The employer buys a cash value type policy on your life, and pays
> > the premium. You get the right to name the beneficiary and the option
> > (if you leave) to either buy and keep the policy (pay the employer for
> > those premiums) or have the policy surrendered and keep the difference
> > (after several years the policy should be worth more than the sum of
> > the premiums paid in). In other words, you have a favorable "adverse
> > choice" situation <>
> >
> > ___
> > 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.
>


-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
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] Deferred Income << the general case is "imputed income"

[Jediator]

I am not an accountant, so please excuse my ignorance.  I was wondering 
is it really necessary to create a separate deferred income account when 
you could just do a transaction report on your IRA account to see how 
much distribution you had in a year or a month?  -- JC


On 1/15/24 5:33 PM, Michael or Penny Novack wrote:

On 1/15/2024 4:02 PM, R Losey wrote:

Thank you; this is helpful.

I never really thought about recording Deferred Income previously 
because the investment people track it and let me know what has been 
taken out every year.  But after the discussion in this list last 
year, I thought it might be good to track, at least the taxable 
withdrawals.


I see that Deferred Income should have been recorded, but it wasn't.  
Instead of using "Opening Balance" when they were set up, the amount 
should have been more appropriately credited to Deferred Income, right?



The fact that the government considers the TRANSFER of assets between 
two asset accounts (the IRA and checking) to be a taxable event even 
though no new money coming in can be considered as special case if 
"imputed income" and you COULD simply treat all imputed income 
situations the same.


For example --- you might have as an employee benefit employer paid 
group term insurance and your employer might even offer options like 5 
years salary. Now the US government considers up to $50,000 face value 
a non-taxable benefit but the premium for coverage above that amount 
as "imputed income". In other words, this will appear on your pay stub 
as part of your total taxable income even though you didn't actually 
receive that as money.


Well in the big split where you enter your salary you could handle 
that little piece using equity for the other side. As I have already 
noted, NOT actually changing total equity to both debit and credit 
equity by the same amount (the credit side being an income account, 
but both income and expense accounts "really: of type equity and the 
net of all unclosed income and expense accounts appearing with equity 
as "retained gains (or losses)"


Some of us had to deal with other "imputed income". Thus if we had a 
"split dollar" insurance benefit* the premium for that amount of term 
coverage would show as an "imputed income" amount.


Michael D Novack

* The employer buys a cash value type policy on your life, and pays 
the premium. You get the right to name the beneficiary and the option 
(if you leave) to either buy and keep the policy (pay the employer for 
those premiums) or have the policy surrendered and keep the difference 
(after several years the policy should be worth more than the sum of 
the premiums paid in). In other words, you have a favorable "adverse 
choice" situation <>


___
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] Importing from one gnucash file to another

[Jim DeLaHunt]

James:

On 2024-01-15 03:59, James Wilde wrote:
I am rationalising my accounting in Gnucash and have previously had 
one instance of Gnucash for each year.  I now would like to load an 
[earlier year's data] into the current year.  I have exported the 
earlier year as a csv file (I have used semi-colons instead of commas) 
but when I go to the current year to import it does not seem to be a 
possibility. It appears as though I must in some way edit the exported 
file in order to import it


Interesting.

I imagine that some more specifics about what you are observing might 
help others on the list get you through the next step.


You say, "when I go to the current year to import it does not seem to be 
a possibility."


You have run GnuCash and opened the book file for the current year, the 
file which will receive the earlier file's data, correct?


You are selecting the menu item, File -- Import -- Import Transactions 
from CSV, correct?


Does the Transaction Import Assistant appear?

Are you able to get past the first page of the Assistant? Does the 
"Select File for Import" page appear?


In the "Select File for Import" page, are you able to locate the CSV 
file which has the earlier data?


Is the name of that CSV file displayed as regular (black) text, or is it 
greyed-out text?


If you click on the name of the CSV, and click the "Next" button? Does 
the "Import Preview" page appear?


Do you encounter any problems on the "Import Preview" page? Are you able 
to click "Next"? Does the "Match Import and GnuCash accounts" page appear?


(and so on…)

I am using GnuCash in English. If you are using GnuCash in Swedish, and 
my English-language names do not translate easily to yours, I apologise 
for the confusion.


Both the earlier year and the current year have the same account list. 
I am using Build ID: 4.12+(2022-09-24).


Thank you for supplying those important facts. What computer OS are you 
using? Windows 11?


Best regards,
 —Jim DeLaHunt


___
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] A bit of an irritation.

[David Carlson]

I am not sure if this is new behavior or if it is an artifact of a recent
change of my habits.  I am currently using release 4.8 in a couple of
different computers running various flavors of Linux, mostly variations on
Ubuntu 22.04.  I sometime multitask on the same computer while leaving
GnuCash running in the background, leaving it set to remind me if I forget
to do an interim save after so much time, but never letting GnuCash
actually do the save because it might save something that my cat entered
while walking across the keyboard.

Anyway, now when GnuCash reminds me to save it interrupts whatever I am
doing in whatever program, be it Libre Office or a Zoom meeting.  Has it
always been that odtrusive?

-- 
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] Deferred Income << the general case is "imputed income"

[Michael or Penny Novack]

On 1/15/2024 4:02 PM, R Losey wrote:

Thank you; this is helpful.

I never really thought about recording Deferred Income previously 
because the investment people track it and let me know what has been 
taken out every year.  But after the discussion in this list last 
year, I thought it might be good to track, at least the taxable 
withdrawals.


I see that Deferred Income should have been recorded, but it wasn't.  
Instead of using "Opening Balance" when they were set up, the amount 
should have been more appropriately credited to Deferred Income, right?



The fact that the government considers the TRANSFER of assets between 
two asset accounts (the IRA and checking) to be a taxable event even 
though no new money coming in can be considered as special case if 
"imputed income" and you COULD simply treat all imputed income 
situations the same.


For example --- you might have as an employee benefit employer paid 
group term insurance and your employer might even offer options like 5 
years salary. Now the US government considers up to $50,000 face value a 
non-taxable benefit but the premium for coverage above that amount as 
"imputed income". In other words, this will appear on your pay stub as 
part of your total taxable income even though you didn't actually 
receive that as money.


Well in the big split where you enter your salary you could handle that 
little piece using equity for the other side. As I have already noted, 
NOT actually changing total equity to both debit and credit equity by 
the same amount (the credit side being an income account, but both 
income and expense accounts "really: of type equity and the net of all 
unclosed income and expense accounts appearing with equity as "retained 
gains (or losses)"


Some of us had to deal with other "imputed income". Thus if we had a 
"split dollar" insurance benefit* the premium for that amount of term 
coverage would show as an "imputed income" amount.


Michael D Novack

* The employer buys a cash value type policy on your life, and pays the 
premium. You get the right to name the beneficiary and the option (if 
you leave) to either buy and keep the policy (pay the employer for those 
premiums) or have the policy surrendered and keep the difference (after 
several years the policy should be worth more than the sum of the 
premiums paid in). In other words, you have a favorable "adverse choice" 
situation <>


___
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] Feature request: Import assistant, room for big improvements

[David Cousens]

Ulrich,

There is nothing to stop you supplying the transfer account information in an
import record if it is available. There is a header which can be assigned to the
appropriate column of your input file for the transfer account.

The first time you import with a given account name in he record you will be
asked to specify the internal GnuCash account to which it corresponds. After
that it will be matched to that account.

The Bayesian process only assigns a probable account in cases where the import
record does not specify the  transfer account.

David Cousens

On Mon, 2024-01-15 at 20:17 +0100, Ulrich Grün wrote:
> Hello fellow GnuCash users,
> 
> I wonder if there are plans on improving the import filter, for importing
> bank transfers.
> The situation now is, that some hidden engine tries to learn from doing.
> But the truth is, that even after one year of importing bank transfers, I
> have to check every single transaction, since errors keep occurring. If I
> miss an error, this transaction is put in the wrong ledger account.
> 
> E-boekhouden.nl uses an import assistant where you can specify a ledger
> account number, other keywords and/or amounts of money. The import
> assistant puts the transactions into the right ledger account, with far
> less errors than with GnuCash. In fact, only where a specific keyword,
> leger number or amount is missing, or where no import rule is made for a
> specific payment, the transaction has to be placed into the right general
> ledger by hand.
> 
> Have a nice day!
> 
> -- 
> नमस्ते (Namasté),
> Ulrich
> 
> ¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø
> ¤º°`°º¤ø
> 
> " Can't talk to you without talking to me; we're guilty of the same old
> thing.
>     Thinking a lot about less and less, and forgetting the Love we
> bring "
>  [Grateful Dead, in: 'Althea']
> 
> ¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø
> ¤º°`°º¤ø
>    Mijn blog: ✡ theskepticaltheist.eu ✡
> ___
> 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] Deferred Income

[R Losey]

Thank you; this is helpful.

I never really thought about recording Deferred Income previously because
the investment people track it and let me know what has been taken out
every year.  But after the discussion in this list last year, I thought it
might be good to track, at least the taxable withdrawals.

I see that Deferred Income should have been recorded, but it wasn't.
Instead of using "Opening Balance" when they were set up, the amount should
have been more appropriately credited to Deferred Income, right?

Your example of an IRA Balance brings up another question:

Suppose the IRA in your example paid a dividend of $2,000 each month...
should the Deferred Income be credited?  This, it would be read like:
Assests: Investments:  IRA  debit  $2,000
Equity: Deferred Income  credit $2,000

And thus, when I take a withdrawal, I debit "Deferred Income" and credit
"taxable income"?

Is that correct?



On Mon, Jan 15, 2024 at 1:09 PM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

> Let me ask you a question (that should make it obvious what one* of your
> problems is --- and yes, this has been discussed before)
>
> HOW did you record this deferred income when it was received? Or since
> it might have been received before you began using gnucash, how did you
> enter the accumulated deferred income when you started with gnucash?
> Forget for just a moment that the term "deferred income" in it << you
> might not be using an account of type "income" to track it --- types
> income and expense are temporary accounts of fundamental type equity and
> would be zeroed out IF you did an actual "close the books" -- you
> presumably want this amount in a standing account, one that persists
> through a "close the books"
>
> Hint --- suppose I were starting to use gnucash and I had an IRA balance
> of $500,000 and all of that is "deferred income" (not taxed yet, so will
> be when withdrawals taken). HOW did I record that starting balance? NOT
> by using the "starting balance tool". I would have an account under
> equity with a name like ":deferred income" and I would enter a
> transaction debit   Assets:Investments"IRA and credit Equity:Deferred
> Income << in other words, it IS part of my equity, just kept separate >>
>
> Now we are taking a distribution (your transaction)  You would have the
> first two lines right but that would be a CREDIT to Income:Taxable:IRA
> distributions and a DEBIT to Equity:Deferred IncomeAnd no, you
> are NOT decreasing your total equity (because an account of type income
> is a temporary account of fundamental type equity --- so no net change
> to equity)
>
> Michael D Novack
>
> PS: IF you never kept the accumulated deferred income as a separate part
> of equity don't try to go back and fix that. Just use equity itself for
> the second debit.
>
> * The other is that you don't seem to understand the "sense" of an
> account of type "income". That's where your wrong sign comes from
>
>
>
>
> On 1/15/2024 11:52 AM, R Losey wrote:
> > Last year, there was a discussion here about tracking taxable
> distributions
> > from IRAs which included a deferred income account. I had not been
> tracking
> > taxable income, and thought that this would be good, so I tried to do
> this
> > last year, but I think I did it incorrectly. I wanted to avail myself of
> > the knowledge and wisdom here.
> >
> > I have "Deferred Income" as an "Income" account. When I take out, say,
> > $1000.00, I made the following split:
> >
> > Assets: Investments: IRA credit $1000.00
> > Assets: Current Assets: Checking:   debit $1000.00
> > Income: Taxable: IRA Distribution debit $1000.00
> > Income: Deferred Income credit $1000.00
> >
> > I suspect that I have the last two entries reversed because the IRA
> > Distribution balance is negative, and all other income accounts are
> > positive.
> >
> > I don't remember if I created the "Deferred Income" account; perhaps it
> > should not be under "Income"?
> >
> > Many thanks!
> >
>
> --
> There is no possibility of social justice on a dead planet except the
> equality of the grave.
>
> ___
> 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.
>


-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
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] Feature request: Import assistant, room for big improvements

[Phyllis Bruce]

Since the subject has been raised I'll add my wish:

For unmatched items I often have to do some research such as checking
Amazon to see just what it is that came in.  Then I know what expense it
belongs to.  However; I am not able to specify the item until I approve the
import - by which time I've forgotten what the darn thing was.  It would be
so nice if I could create a memo while still in the reconciliation process.

My work around has been to just approve the import and then work on the
Imbalanced transactions.  Yuk

Regards!  Po

On Mon, Jan 15, 2024 at 2:35 PM Ulrich Grün  wrote:

> Hello fellow GnuCash users,
>
> I wonder if there are plans on improving the import filter, for importing
> bank transfers.
> The situation now is, that some hidden engine tries to learn from doing.
> But the truth is, that even after one year of importing bank transfers, I
> have to check every single transaction, since errors keep occurring. If I
> miss an error, this transaction is put in the wrong ledger account.
>
> E-boekhouden.nl uses an import assistant where you can specify a ledger
> account number, other keywords and/or amounts of money. The import
> assistant puts the transactions into the right ledger account, with far
> less errors than with GnuCash. In fact, only where a specific keyword,
> leger number or amount is missing, or where no import rule is made for a
> specific payment, the transaction has to be placed into the right general
> ledger by hand.
>
> Have a nice day!
>
> --
> नमस्ते (Namasté),
> Ulrich
>
>
> ¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø
>
> " Can't talk to you without talking to me; we're guilty of the same old
> thing.
> Thinking a lot about less and less, and forgetting the Love we
> bring "
>  [Grateful Dead, in: 'Althea']
>
>
> ¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø
>Mijn blog: ✡ theskepticaltheist.eu ✡
> ___
> 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] Deferred Income

[R Losey]

Thank you; I'm pretty sure that I have the Deferred Income incorrectly
under "Income"; it's not marked taxable - it's just an account.

On Mon, Jan 15, 2024 at 1:08 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> I'm not familiar with the use case, but if you want income to 'go up'
> that is, show you received it, then it should be a credit.
>
> I'll hazard a guess that since you have a 'Taxable' account, which you
> are supposed to show receipt of income, then that one should be a credit.
>
> If the Deferred Income account is truly the other side of that income
> recognition, then it should be a debit. (and shouldn't be marked taxable
> as it is for tracking what you deferred, and is no longer deferred -
> you've moved it from deferred to realized.)
>
> Note, that's just basic accounting with respect to Income type accounts.
> Get official advice though.
>
> Regards,
> Adrien
>
> On 1/15/24 10:52 AM, R Losey wrote:
> > Last year, there was a discussion here about tracking taxable
> distributions
> > from IRAs which included a deferred income account. I had not been
> tracking
> > taxable income, and thought that this would be good, so I tried to do
> this
> > last year, but I think I did it incorrectly. I wanted to avail myself of
> > the knowledge and wisdom here.
> >
> > I have "Deferred Income" as an "Income" account. When I take out, say,
> > $1000.00, I made the following split:
> >
> > Assets: Investments: IRA credit $1000.00
> > Assets: Current Assets: Checking:   debit $1000.00
> > Income: Taxable: IRA Distribution debit $1000.00
> > Income: Deferred Income credit $1000.00
> >
> > I suspect that I have the last two entries reversed because the IRA
> > Distribution balance is negative, and all other income accounts are
> > positive.
> >
> > I don't remember if I created the "Deferred Income" account; perhaps it
> > should not be under "Income"?
> >
> > Many 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.
>


-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
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] Feature request: Import assistant, room for big improvements

[Ulrich Grün]

Hello fellow GnuCash users,

I wonder if there are plans on improving the import filter, for importing
bank transfers.
The situation now is, that some hidden engine tries to learn from doing.
But the truth is, that even after one year of importing bank transfers, I
have to check every single transaction, since errors keep occurring. If I
miss an error, this transaction is put in the wrong ledger account.

E-boekhouden.nl uses an import assistant where you can specify a ledger
account number, other keywords and/or amounts of money. The import
assistant puts the transactions into the right ledger account, with far
less errors than with GnuCash. In fact, only where a specific keyword,
leger number or amount is missing, or where no import rule is made for a
specific payment, the transaction has to be placed into the right general
ledger by hand.

Have a nice day!

-- 
नमस्ते (Namasté),
Ulrich

¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø

" Can't talk to you without talking to me; we're guilty of the same old
thing.
Thinking a lot about less and less, and forgetting the Love we
bring "
 [Grateful Dead, in: 'Althea']

¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø
   Mijn blog: ✡ theskepticaltheist.eu ✡
___
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] Importing from one gnucash file to another

[James Wilde]

I am rationalising my accounting in Gnucash and have previously had one 
instance of Gnucash for each year.  I now would like to load an eyara 
into the current year.  I have exported the earlier year as a csv file 
(I have used semi-colons instead of commas) but when I go to the current 
year to import it does not seem to be a possibility. It appears as 
though I must in some way edit the exported file in order to import it.


Both the earlier year and the current year have the same account list.  
I am using Build ID: 4.12+(2022-09-24).


I'd appreciate a hint on what I might be missing.

Regards

James Wilde
___
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] Deferred Income

[Michael or Penny Novack]

Let me ask you a question (that should make it obvious what one* of your 
problems is --- and yes, this has been discussed before)


HOW did you record this deferred income when it was received? Or since 
it might have been received before you began using gnucash, how did you 
enter the accumulated deferred income when you started with gnucash? 
Forget for just a moment that the term "deferred income" in it << you 
might not be using an account of type "income" to track it --- types 
income and expense are temporary accounts of fundamental type equity and 
would be zeroed out IF you did an actual "close the books" -- you 
presumably want this amount in a standing account, one that persists 
through a "close the books"


Hint --- suppose I were starting to use gnucash and I had an IRA balance 
of $500,000 and all of that is "deferred income" (not taxed yet, so will 
be when withdrawals taken). HOW did I record that starting balance? NOT 
by using the "starting balance tool". I would have an account under 
equity with a name like ":deferred income" and I would enter a 
transaction debit   Assets:Investments"IRA and credit Equity:Deferred 
Income << in other words, it IS part of my equity, just kept separate >>


Now we are taking a distribution (your transaction)  You would have the 
first two lines right but that would be a CREDIT to Income:Taxable:IRA 
distributions and a DEBIT to Equity:Deferred Income    And no, you 
are NOT decreasing your total equity (because an account of type income 
is a temporary account of fundamental type equity --- so no net change 
to equity)


Michael D Novack

PS: IF you never kept the accumulated deferred income as a separate part 
of equity don't try to go back and fix that. Just use equity itself for 
the second debit.


* The other is that you don't seem to understand the "sense" of an 
account of type "income". That's where your wrong sign comes from





On 1/15/2024 11:52 AM, R Losey wrote:

Last year, there was a discussion here about tracking taxable distributions
from IRAs which included a deferred income account. I had not been tracking
taxable income, and thought that this would be good, so I tried to do this
last year, but I think I did it incorrectly. I wanted to avail myself of
the knowledge and wisdom here.

I have "Deferred Income" as an "Income" account. When I take out, say,
$1000.00, I made the following split:

Assets: Investments: IRA credit $1000.00
Assets: Current Assets: Checking:   debit $1000.00
Income: Taxable: IRA Distribution debit $1000.00
Income: Deferred Income credit $1000.00

I suspect that I have the last two entries reversed because the IRA
Distribution balance is negative, and all other income accounts are
positive.

I don't remember if I created the "Deferred Income" account; perhaps it
should not be under "Income"?

Many thanks!



--
There is no possibility of social justice on a dead planet except the equality 
of the grave.

___
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] Deferred Income

[Adrien Monteleone]

I'm not familiar with the use case, but if you want income to 'go up' 
that is, show you received it, then it should be a credit.


I'll hazard a guess that since you have a 'Taxable' account, which you 
are supposed to show receipt of income, then that one should be a credit.


If the Deferred Income account is truly the other side of that income 
recognition, then it should be a debit. (and shouldn't be marked taxable 
as it is for tracking what you deferred, and is no longer deferred - 
you've moved it from deferred to realized.)


Note, that's just basic accounting with respect to Income type accounts. 
Get official advice though.


Regards,
Adrien

On 1/15/24 10:52 AM, R Losey wrote:

Last year, there was a discussion here about tracking taxable distributions
from IRAs which included a deferred income account. I had not been tracking
taxable income, and thought that this would be good, so I tried to do this
last year, but I think I did it incorrectly. I wanted to avail myself of
the knowledge and wisdom here.

I have "Deferred Income" as an "Income" account. When I take out, say,
$1000.00, I made the following split:

Assets: Investments: IRA credit $1000.00
Assets: Current Assets: Checking:   debit $1000.00
Income: Taxable: IRA Distribution debit $1000.00
Income: Deferred Income credit $1000.00

I suspect that I have the last two entries reversed because the IRA
Distribution balance is negative, and all other income accounts are
positive.

I don't remember if I created the "Deferred Income" account; perhaps it
should not be under "Income"?

Many 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] How do you record the rounding of your netpay?

[Adrien Monteleone]

That sounds like an accrual situation.

If they are consistently owing you, then use an asset account.

If you are consistently owing them, use a liability account.

You could name it 'Payroll Rounding Accrual' or something similar.

If the rounding bounces back and forth between asset and liability, then 
just pick one. If it ever ends up in the opposite normal sign for the 
balance, then you know at that point in time, it is a reverse balance 
account and effectively the other 'type'. This matters little from 
paycheck to paycheck, and probably doesn't even matter on an annual 
basis either.


Regards,
Adrien

On 1/14/24 12:37 AM, Oleander via gnucash-user wrote:

Hello everyone,

my netpay each month is rounded up to the next integer. This
rounding in my paycheck is indicated under the voice "Actual rounding" then it 
is
charged in the paycheck of the following month under the voice "Previous
rounding" and the netpay, in turn, rounded up to the next integer again.

Thus my net pay is gross pay minus deductions minus the amount of the "Previous 
rounding".

How would you record "Previous Rounding" and "Actual Rounding"?

I'd be inclined to use these accounts plus what is needed to calculate the 
rounding:

Assets:Bank1:Checking €
Income:Salary

Expenses:Taxes:State €
Expenses:Taxes:Regional €
Expenses:Taxes:Municipal €
Expenses:Taxes:Social Security €
Assets:Bank1:Checking


___
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] List of fields checked by importer when matching transactions

[John Haiducek]

Thanks, Etienne. Thankfully, my CSV only has one row per transaction.

On Sat, Jan 13, 2024 at 5:04 AM GNUCash  wrote:

> John,
> Yes the description had to match the tranfer memo. To clarify.
> In my transaction CSV I had 3 rows belonging to 1 transaction.
> Description on all 3 rows: “Order 1234”
> Receivables and deposit rows where identical in all fields (memo, transfer
> memo, description).
> But the third row contained the transaction fee.
> So I had in the transfer memo: “Order 1234; payment cost”. Then the
> importer failed to match it to the first 2 rows.
>
> Etienne
> On 12 Jan 2024 at 12:43 +0100, GNUCash via gnucash-user <
> gnucash-user@gnucash.org>, wrote:
>
> Perhaps related to your question.
> I did notice as I was closing last quarter that in the GNU Cash latest
> version something seems to have changed with the importer matching.
> I create my own CSV files in Python based on the export from
> suppliers/payments.
> I had to change the Transfer memo field I believe, to match either the
> Memo field or the description field. Else transactions no longer matched.
> Before, I could have different texts there.
>
> Etienne
> On 11 Jan 2024 at 18:01 +0100, John Haiducek , wrote:
>
> Checking "Clear" (or "Update+Clear") doesn't work in my case. When I check
> those it says "Match missing!", even for cases where every imported field
> is identical to an existing transaction.
>
> On Thu, Jan 11, 2024 at 11:44 AM Gyle McCollam  wrote:
>
> I've been having the same issue with qfx/ofx files, but I find when I
> click on the clear check box it finds the matching transaction. You might
> want to try that.
>
>
>
> Sent from Samsung Galaxy smartphone.
>
>
>
>  Original message 
> From: John Haiducek 
> Date: 1/11/24 10:43 AM (GMT-05:00)
> To: GNU Cash User 
> Subject: [GNC] List of fields checked by importer when matching
> transactions
>
> Hi,
>
> Is there a list somewhere of what fields are checked by the importer when
> matching transactions? I'm trying to import a CSV file that contains
> already-existing transactions and the importer is failing to detect them
> (there are hundreds so I don't want to manually de-select them all).
>
> John
> ___
> 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.
>
>
___
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] Install Finance::Quotes

[Kalpesh Patel]

While I am not on Mac, I recall that the SSL portion of LWP was very hard to 
compile/install on the *NIX side, especially the needed SSLeay module for older 
Perl versions which used to be a separate and standalone build.

From below SUDO command, it looks you are trying to build for all three 
architecture types so I am SUSPECTING that SSLeay for ARM may not be available 
for Perl 5.3 version. 

-Original Message-
From: Gustavo Taouil  
Sent: Sunday, January 14, 2024 2:58 PM
To: gnucash-user@gnucash.org
Subject: [GNC] Install Finance::Quotes

Hi Guys, please help me!

I have MacBook Pro m3 with macOS Sonome. I followed the instructions in wiki 
page of Gnucash to install the Finance::Quote. I use this command in terminal :

sudo ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64' 
/Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-update

The command installs several packages in pearl 5.3 folder but didn’t install 
Finance::Quote. Debugging the code I found that I can’t install the package 
LWP::Protocol::https.


Has anyone had a problem like this?



Thanks 

Gustavo








___
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] Install Finance::Quotes

[Jim DeLaHunt]

Hello, Gustavo, and welcome to Gnucash!

On 2024-01-14 11:58, Gustavo Taouil wrote:

...I have MacBook Pro m3 with macOS Sonome. I followed the instructions in wiki 
page of Gnucash to install the Finance::Quote. I use this command in terminal :

sudo ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64' 
/Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-update

The command installs several packages in pearl 5.3 folder but didn’t install 
Finance::Quote. Debugging the code I found that I can’t install the package 
LWP::Protocol::https.


Has anyone had a problem like this?


Having problems with Finance::Quote, including on macOS, is a regular 
feature of the questions on this list. So, yes.


Have you read the page of the GnuCash wiki about Online Quotes, 
especially 
?


Are you using Perl for anything apart from GnuCash's use for quotes? If 
so, then those uses may clash with GnuCash's uses.


Are you using Homebrew or MacPorts to install software onto your Mac?  
If so, they may have installed a separate copy of Perl which conflicts 
with the one GnuCash uses.


In the Terminal, please run these three commands, and let us know what 
output you get. (The '%' marks the command prompt in Terminal; you don't 
type in that part.)


% whence perl

% perl --version

% /usr/bin/perl --version

I hope we will be able to help you over this hump.

Best regards,
 —Jim DeLaHunt


___
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] Deferred Income

[R Losey]

Last year, there was a discussion here about tracking taxable distributions
from IRAs which included a deferred income account. I had not been tracking
taxable income, and thought that this would be good, so I tried to do this
last year, but I think I did it incorrectly. I wanted to avail myself of
the knowledge and wisdom here.

I have "Deferred Income" as an "Income" account. When I take out, say,
$1000.00, I made the following split:

Assets: Investments: IRA credit $1000.00
Assets: Current Assets: Checking:   debit $1000.00
Income: Taxable: IRA Distribution debit $1000.00
Income: Deferred Income credit $1000.00

I suspect that I have the last two entries reversed because the IRA
Distribution balance is negative, and all other income accounts are
positive.

I don't remember if I created the "Deferred Income" account; perhaps it
should not be under "Income"?

Many thanks!

-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
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] How do you record the rounding of your netpay?

[R Losey]

On Mon, Jan 15, 2024 at 3:07 AM Oleander via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Hello everyone,
>
> my netpay each month is rounded up to the next integer. This
> rounding in my paycheck is indicated under the voice "Actual rounding"
> then it is
> charged in the paycheck of the following month under the voice "Previous
> rounding" and the netpay, in turn, rounded up to the next integer again.
>
> Thus my net pay is gross pay minus deductions minus the amount of the
> "Previous rounding".
>
> How would you record "Previous Rounding" and "Actual Rounding"?
>
> I'd be inclined to use these accounts plus what is needed to calculate the
> rounding:
>
> Assets:Bank1:Checking €
> Income:Salary
>
> Expenses:Taxes:State €
> Expenses:Taxes:Regional €
> Expenses:Taxes:Municipal €
> Expenses:Taxes:Social Security €
> Assets:Bank1:Checking
>
> Thank you,
> ___
> 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.
>

Interesting question.

First, I am not an accountant.

I'd have an account for "Paycheck Rounding" (but what type to make it, I'm
not sure; possibly a Liability?), and treat it like a deduction (when they
take away from your pay-"Previous Rounding"), and an addition (when they
add it-"Actual Rounding").

If I understood what you wrote, as an example, if your gross pay is $1000
and your deductions are 15.00, 7.25, 1.25, and 7.12, your net pay would be
969.38 - if they always "round up", there would be .62 of Actual Rounding,
making the deposited amount 970.

For the next paycheck, there would be an "Previous Rounding" reversal of
0.62, leaving 968.76, with an "Actual Rounding" of 0.24, making the
deposited amount 969.

So, for the first one, you'd have a split of
   Assets: Bank1: Checking 970.00
   Income: Salary: 1000.00
   Expenses: Taxes: State 15.00
   Expenses: Taxes: City:7.25
   Expenses: Taxes: Municipal  1.25
   Expenses: Social Security:7.12
   Liabilities: Paycheck Rounding:  0.62 ("Actual Rounding")

If my understanding is correct, the Salary and the Paycheck Rounding would
be credits and everything else could be a debit.


The next paycheck would be
   Income: Salary: 1000.00
   Assets: Bank 1: Checking: 969.00
   Expenses: Taxes: State:  15.00
   Expenses: Taxes: City: 7.25
   Expenses: Taxes: Municipal: 1.25
   Expenses: Social Security: 7.12
   Liabilities: Paycheck Rounding: 0.62 (reversing last paycheck's rounding
["Previous Rounding"])
   Liabilities: Paycheck Rounding: 0.24 ("Actual Rounding")

As before, the Salary would be a credit and the Assets & Expense accounts
would be debits... the Paycheck Rounding for "Previous Rounding" would be a
debit of 0.62, and the entry for the Actual Rounding (0.24) would be a
credit.


--
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
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] Install Finance::Quotes

[Gustavo Taouil]

Hi Guys, please help me!

I have MacBook Pro m3 with macOS Sonome. I followed the instructions in wiki 
page of Gnucash to install the Finance::Quote. I use this command in terminal :

sudo ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64' 
/Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-update

The command installs several packages in pearl 5.3 folder but didn’t install 
Finance::Quote. Debugging the code I found that I can’t install the package 
LWP::Protocol::https.


Has anyone had a problem like this?



Thanks 

Gustavo






___
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] How do you record the rounding of your netpay?

[Oleander via gnucash-user]

Hello everyone,

my netpay each month is rounded up to the next integer. This
rounding in my paycheck is indicated under the voice "Actual rounding" then it 
is
charged in the paycheck of the following month under the voice "Previous
rounding" and the netpay, in turn, rounded up to the next integer again.

Thus my net pay is gross pay minus deductions minus the amount of the "Previous 
rounding".

How would you record "Previous Rounding" and "Actual Rounding"?

I'd be inclined to use these accounts plus what is needed to calculate the 
rounding:

Assets:Bank1:Checking €
Income:Salary

Expenses:Taxes:State €
Expenses:Taxes:Regional €
Expenses:Taxes:Municipal €
Expenses:Taxes:Social Security €
Assets:Bank1:Checking

Thank you,
___
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.