Re: [GNC] Stock Merger

2022-02-18 Thread Christopher Lam
Although the UI allows 1 transaction with splits in >1 stock, I believe
that there's zero likelihood that portfolio reports are written to handle
them. Therefore I would recommend that a stock merger is recorded as two
separate transactions -- (1) original stock sale as cash into the broker
account, recording capital gains in the process. (2) using the cash to
purchase new stock. This is very likely the cleanest record of a stock
merger. There's an upcoming stock-transaction assistant being worked on
which will assist creating stock transactions, and will *not* be able to
handle a stock merge in 1 step.

On Sat, 19 Feb 2022 at 04:16, Al  wrote:

> Geoff wrote:
> > Hi Al
> >
> > We need to tweak your transactions to fix the cost basis on the Advanced
> > Portfolio Report.
> >
> > Also from a tax accounting perspective, there are two ways to treat this
> > merger, depending whether it realised a capital gains event or not. I'll
> > cover both scenarios from a GnuCash perspective, but please note that I
> > am not an accountant.
>
> Many thanks Geoff, the information that you provided will be quite helpful.
>
> I'm waiting a bit on tweaking the transaction until I find out the
> capitol gain status, although I am fairly sure that there is no capitol
> gain other than the .72 fractional share amount. I'd just like to see
> that in writing before committing the transaction.
>
> Al
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Stock Merger

2022-02-18 Thread Al

Geoff wrote:

Hi Al

We need to tweak your transactions to fix the cost basis on the Advanced 
Portfolio Report.


Also from a tax accounting perspective, there are two ways to treat this 
merger, depending whether it realised a capital gains event or not. I'll 
cover both scenarios from a GnuCash perspective, but please note that I 
am not an accountant.


Many thanks Geoff, the information that you provided will be quite helpful.

I'm waiting a bit on tweaking the transaction until I find out the 
capitol gain status, although I am fairly sure that there is no capitol 
gain other than the .72 fractional share amount. I'd just like to see 
that in writing before committing the transaction.


Al
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Potential Computational Errors

2022-02-18 Thread Gao Bite

GnuCash Developers & Maintainers:

  Hello! When I tried the problem, I found that the problem has been 
solved. Despite this, I still thank you for your kindness.  


 Yours,
   Bite Gao
Feb 17th, 2022

On 2022/2/18 21:16, Derek Atkins Wrote:

HI,

Thank you for sending this, however I still cannot understand what the
proposed computation error is.  First, I don't read the language(s) in the
image.  Second, you're not showing a picture of a GnuCash register, and
due to the language issue I cannot tell *WHAT* it is a picture of.  Based
on that, I have no way to divine what the computation is supposed to be,
in order to even verify that the computation is wrong.

I *WILL* say that it looks like you are using two currencies.

It looks like you have three entries in ¥ but then the last entry appears
to be in a different currency (Yuan?  I'm not sure what that character
means).

Assuming I am correct, then the "computation" is going to be based on the
exchange rate you entered.  But I cannot tell if this is a single
transaction or what.

Can you show this in the GnuCash Register UI (with colored lines)?

Thanks,

-derek

On Thu, February 17, 2022 6:58 pm, Gao Bite wrote:

GnuCash Developers & Maintainers:

       Hello! This is the attachment which I originally planned
to send.

  Yours,
Bite Gao
Feb 17th, 2022

On Thu, February 17, 2022 9:08 am, Derek Atkins wrote:


HI,

On Thu, February 17, 2022 9:08 am, Gao Bite wrote:

GnuCash Developers & Maintainers:

       Hello! I have recently found a mismatch computation result from
your software.

It may be a computational mistake, or a special accounting standard. I
would like to know

whether it is.


       Yours,

       Bite Gao

Feb 17th, 2021

Attachment:

Image which describes potential error:


This list scraps all HTML and embedded images.  You need to attach them
to
get them through the list.  As a result, we cannot see what potential
computation error you seem to be seeing.


Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

-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
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] mortgage calculator

2022-02-18 Thread Stephen M. Butler
By  fussing with the ipmt formula I was able to accommodate a regular 
extra payment.  I went into Libre Office to recalculate the number of 
months using the larger monthly payment.  Then adjusted the number of 
payments to an integer and recalculated the required monthly payment.


The wizard will setup the scheduled transactions and will use the ipmt 
function to generate the interest amount.


ipmt( .04490 / 12.00 : i : 240.00 : 51,630.34 : 0 : 0 )

The only thing you can't mess with in the function is the 'i' which is 
the month number for which this entry is being calculate.  The fields 
are separated by colon (:).  Here are the entries as I understand them:


Field 1:  in my case .04490 / 12.00.  This is the interest rate per 
period.  In my case I have an annual 4.49%.


Field 2:  The 'i' that I don't know how GnC calculates it.  In some 
cases I have thought it was a month or so off but haven't tried to add 
or subtract an offset value to see if that is possible.


Field 3:  The number of payments to be made.  If you divide the annual 
interest by 12 then you are doing this monthly and this would be the 
number of months.  If you want bi-weekly or semi-monthly you will need 
to adjust both the first field and the count in this field.


Field 4:  The loan amount.  In this case I threw away the old loan 
schedule in GnC and created a new one to shorten my loan down to 20 
years remaining (I think it was at 25 or 27 years).  So this would be 
the loan balance at the time you started making extra payments.


Field 5:  The ending value of the loan.  Most of the time this is zero 
as you plan to pay everything off.  If you have a balloon payment at the 
end, then enter the balloon amount here.


Field 6:  It is called 'type'.  I think this is whether the interest is 
pre-paid or post-paid.  The standard appears to be '0'.   I suspect the 
other type is '1' but could not determine based on a quick inspection of 
fin.scm


Note that certain payment values will result in a fractional number of 
payments.  I haven't tried to see if the function will work with a 
non-integer value for the total number of payments. So if you insist on 
paying an even (full) amount (non-fractional), you may not be able to 
generate the exact interest according to your bank.  I've been lucky 
with the above as I accepted a monthly payment that included pennies.


Setting up the scheduled transaction -- in my case I copied the old loan 
scheduled entries.  Then modified them to fit the new circumstances.


On the split for the bank payout amount, I hard carded the actual 
payment to be made: (326.97 in my case).


On the split for the interest amount I entered the function: ipmt( 
.04490 / 12.00 : i : 240.00 : 51,630.34 : 0 : 0 )


On the split for the principal amount I entered the payment minus 
interest:  326.97 - ipmt( .04490 / 12.00 : i : 240.00 : 51,630.34 : 0 : 0 )


If I rounded my payment up to $327.00 then the interest amount would 
slowly diverge from what the bank generates.  But, as it now is, the 
bank will occasionally post the payment a day or so later than I 
predicted and the interest amount will be off.


Now, this is all predicated on the fact that you will be making the same 
payment each time and not varying it each month.  It also based on 
getting the number of payments to be non-fractional.


Note that the loan wizard doesn't record your monthly payment. Instead 
it used the ppmt function (with same fields as the ipmt function).


Hope this helps.  Go Forth and experiment.  [although fin.scm is written 
in Scheme and not Forth]




On 2/18/22 12:13, D. via gnucash-user wrote:

I manually edit each mortgage entry as well. I use the mortgage statements to 
reconcile the final amounts.

I mean, there aren't that many transactions to consider. I don't see this as 
much of a burden.

David


 Original Message 
From: Derek Atkins 
Sent: Fri Feb 18 14:50:22 EST 2022
To: Alan Schold 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] mortgage calculator

HI,

On Fri, February 18, 2022 2:42 pm, Alan Schold via gnucash-user wrote:

Is there a way to get the mortgage repayment module to account for
regular extra monthly payments? Now the calculations proceed as if I'm
just paying the basic mortgage amount, and I have to recalculate the
principal balance each month. The calculator is only right once!

Sorry, no.

This is a long-standing limitation of the calculator (and trust me, it's
been hitting me forever!!).

The MAIN issue is the lack of a "GetBalanceAsOfDate()" function usable
within the scheduled transaction (SX) functions, and tied into the SX
system where it can supply the date as part of the SX firing methods.
Adding it is, unfortunately, not as straightforward as you would think,
which is why nobody has done it, yet.

Me, I just periodically go through and update the P/I splits from my
mortgage and loan statements.

Sorry,


Please remember to CC this list on all your replies.
You can do 

Re: [GNC] mortgage calculator

2022-02-18 Thread Alan Schold via gnucash-user
Thanks to you all especially Derek's nice explanation. What I have been 
doing is no real burden, and I suppose I'll just press on until someone 
solves the problem.


On 2/18/2022 12:42 PM, Alan Schold via gnucash-user wrote:
Is there a way to get the mortgage repayment module to account for 
regular extra monthly payments? Now the calculations proceed as if I'm 
just paying the basic mortgage amount, and I have to recalculate the 
principal balance each month. The calculator is only right once!


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] mortgage calculator

2022-02-18 Thread Stan Brown
> On Fri, February 18, 2022 2:42 pm, Alan Schold via gnucash-user wrote:
>> Is there a way to get the mortgage repayment module to account for
>> regular extra monthly payments? Now the calculations proceed as if I'm
>> just paying the basic mortgage amount, and I have to recalculate the
>> principal balance each month. The calculator is only right once!

On 2022-02-18 11:50, Derek Atkins wrote:
> Sorry, no.
> ...
> Me, I just periodically go through and update the P/I splits from my
> mortgage and loan statements.

I just have a regular scheduled transaction with the credit amount for
Cash and Banks filled in, and the debit amounts for Mortgage and
Interest blank. Since I always review scheduled transactions when they
pop up, I add the amounts at that time.

-- 
Stan Brown
Tehachapi, CA, USA
https://BrownMath.com
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] mortgage calculator

2022-02-18 Thread D. via gnucash-user
I manually edit each mortgage entry as well. I use the mortgage statements to 
reconcile the final amounts. 

I mean, there aren't that many transactions to consider. I don't see this as 
much of a burden. 

David


 Original Message 
From: Derek Atkins 
Sent: Fri Feb 18 14:50:22 EST 2022
To: Alan Schold 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] mortgage calculator

HI,

On Fri, February 18, 2022 2:42 pm, Alan Schold via gnucash-user wrote:
> Is there a way to get the mortgage repayment module to account for
> regular extra monthly payments? Now the calculations proceed as if I'm
> just paying the basic mortgage amount, and I have to recalculate the
> principal balance each month. The calculator is only right once!

Sorry, no.

This is a long-standing limitation of the calculator (and trust me, it's
been hitting me forever!!).

The MAIN issue is the lack of a "GetBalanceAsOfDate()" function usable
within the scheduled transaction (SX) functions, and tied into the SX
system where it can supply the date as part of the SX firing methods. 
Adding it is, unfortunately, not as straightforward as you would think,
which is why nobody has done it, yet.

Me, I just periodically go through and update the P/I splits from my
mortgage and loan statements.

Sorry,

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

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

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] mortgage calculator

2022-02-18 Thread Derek Atkins
HI,

On Fri, February 18, 2022 2:42 pm, Alan Schold via gnucash-user wrote:
> Is there a way to get the mortgage repayment module to account for
> regular extra monthly payments? Now the calculations proceed as if I'm
> just paying the basic mortgage amount, and I have to recalculate the
> principal balance each month. The calculator is only right once!

Sorry, no.

This is a long-standing limitation of the calculator (and trust me, it's
been hitting me forever!!).

The MAIN issue is the lack of a "GetBalanceAsOfDate()" function usable
within the scheduled transaction (SX) functions, and tied into the SX
system where it can supply the date as part of the SX firing methods. 
Adding it is, unfortunately, not as straightforward as you would think,
which is why nobody has done it, yet.

Me, I just periodically go through and update the P/I splits from my
mortgage and loan statements.

Sorry,

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

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

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] mortgage calculator

2022-02-18 Thread Alan Schold via gnucash-user
Is there a way to get the mortgage repayment module to account for 
regular extra monthly payments? Now the calculations proceed as if I'm 
just paying the basic mortgage amount, and I have to recalculate the 
principal balance each month. The calculator is only right once!


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] reconciling specific credit cards in an account

2022-02-18 Thread David Carlson
I bet it is one of those banks that begins with the letter 'C'.  I have
that problem too.  I have to rely on timing and amount to differentiate,
and GnuCash is not good with using amounts to differentiate.

On Fri, Feb 18, 2022 at 9:30 AM scum buster  wrote:

> Hi
>
> Thanks for the reply.
>
> No, I don't use debit cards.
>
> The issue is that one bank services a few of my credit cards.   And the
> downloads show them all the same ---  "bankname online payment" with no
> differentiation of what specific credit card account that line item is for.
>
> Gnucash doesn't show any other info than that upon reconciling, probably
> because the bank doesn't provide it.
>
> My only other solution would be to have only one credit card per bank
> name...then it's a no brainer which credit card account goes with what.
>
> But that's not practical for me.
>
>
> -Original Message-
> From: John Layman [mailto:john.lay...@laymanandlayman.com]
> Sent: Thursday, February 17, 2022 12:56 PM
> To: 'scum buster'; gnucash-user@gnucash.org
> Subject: RE: [GNC] reconciling specific credit cards in an account
>
> Sounds like you are confusing your bank account debit card with a credit
> card.  They may look the same, but the debit card will directly draw funds
> from the checking account.  If you are having to enter a PIN number when
> you
> use that card, it's almost certainly a debit card.
>
> -Original Message-
> From: gnucash-user 
> On Behalf Of scum buster
> Sent: Wednesday, February 16, 2022 8:03 PM
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] reconciling specific credit cards in an account
>
> I have been using Gnucash for years..currently version 3.7.  I very
> much
> appreciate the program.I used quicken for years til I started using
> Gnucash.
>
> Have never used this forum before, so I hope I don't screw this up. LOL
>
> I am not a Gnucash expertI know I do some things wrong but I get by
>
> One thing I always seem to have issues with (I am sure it is user
> error).is with my checking account and credit card charges that come
> through that account
>
> I download my checking account data as a quicken file and "import" that.
>
> I have a few credit cards with one company.  The charges come through as "
> bankname online payment" when they hit my checking account.
>
> That would be fine if I had only one credit card with that bank.
>
> But with a few different cards, I have issues trying to get them to
> auto-reconcile correctly and end up having to manually add the items and
> manually pick the right account..and that ends up making duplicate
> charges somehow.
>
> What is the right way to set things up so that Gnucash knows what credit
> card account is being referenced when the charges hit my checking account?
>
> Thanks for your help!
>
>
> -Original Message-
> From: gnucash-user
> [mailto:gnucash-user-bounces+scumbuster=comcast@gnucash.org] On Behalf
> Of gnucash-user-requ...@gnucash.org
> Sent: Wednesday, February 16, 2022 12:00 PM
> To: gnucash-user@gnucash.org
> Subject: gnucash-user Digest, Vol 227, Issue 32
>
> Send gnucash-user mailing list submissions to
> gnucash-user@gnucash.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to
> gnucash-user-requ...@gnucash.org
>
> You can reach the person managing the list at
> gnucash-user-ow...@gnucash.org
>
> When replying, please edit your Subject line so it is more specific than
> "Re: Contents of gnucash-user digest..."
>
>
> --
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
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
If you are using Nabble or Gmane, please see 

Re: [GNC] Selecting older transactions to unreconcile

2022-02-18 Thread Mahon Finbar
Thank you both, I should have realised that, but that is what 
gnucash-user is for is it not 


Finbar

On 17/02/2022 16:27, David Carlson wrote:
It is very easy to adjust the register display settings to show only 
reconciled or unreconciled transactions dated  within a certain 
range.  That should help.


On Thu, Feb 17, 2022, 9:02 AM Mahon Finbar  wrote:

True, but since I don't know where the error is, I thought of
doing it
per month, and that way finding it.

That is why I need to find a way to display the reconciled
transactions
on a month by month basis.


It is usually a transaction in the wrong column.


Thanks Barry


On 16/02/2022 17:54, Gyle McCollam wrote:
> If you only have a few errors, it would be easier to just Click
on the
> "y" in the reconciled column of the transaction in the appropriate
> account and select unreconcile.
>
> Thank You,
> *Gyle McCollam*
>
> Gyle McCollam
>
> 609.680.2326Mobile
>
> gmccol...@live.com email
>
>

> *From:* gnucash-user
>  on behalf of
Mahon
> Finbar 
> *Sent:* Wednesday, February 16, 2022 9:05 AM
> *To:* Gnucash Users 
> *Subject:* [GNC] Selecting older transactions to unreconcile
> End of year issue.
>
> I have reconciled most of 2021 but inevitably I have
subsequently found
> a few errors.
>
> So, I want to select a reconcile date and then "unreconcile" some
> transactions.
>
> I assumed using the suggested ctrl-A and spacebar technique
would enable
> me to do it using a date I specified for the reconciliation, but the
> reconcile window only shows the latest unreconiled data.
>
> Is there a technique for arriving at the data set for a specific
> reconcile date?
>
> Tnks
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] reconciling specific credit cards in an account

2022-02-18 Thread scum buster
Hi

Thanks for the reply.

No, I don't use debit cards.

The issue is that one bank services a few of my credit cards.   And the
downloads show them all the same ---  "bankname online payment" with no
differentiation of what specific credit card account that line item is for.

Gnucash doesn't show any other info than that upon reconciling, probably
because the bank doesn't provide it.

My only other solution would be to have only one credit card per bank
name...then it's a no brainer which credit card account goes with what.

But that's not practical for me.


-Original Message-
From: John Layman [mailto:john.lay...@laymanandlayman.com] 
Sent: Thursday, February 17, 2022 12:56 PM
To: 'scum buster'; gnucash-user@gnucash.org
Subject: RE: [GNC] reconciling specific credit cards in an account

Sounds like you are confusing your bank account debit card with a credit
card.  They may look the same, but the debit card will directly draw funds
from the checking account.  If you are having to enter a PIN number when you
use that card, it's almost certainly a debit card.

-Original Message-
From: gnucash-user 
On Behalf Of scum buster
Sent: Wednesday, February 16, 2022 8:03 PM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] reconciling specific credit cards in an account

I have been using Gnucash for years..currently version 3.7.  I very much
appreciate the program.I used quicken for years til I started using
Gnucash.

Have never used this forum before, so I hope I don't screw this up. LOL

I am not a Gnucash expertI know I do some things wrong but I get by

One thing I always seem to have issues with (I am sure it is user
error).is with my checking account and credit card charges that come
through that account

I download my checking account data as a quicken file and "import" that.

I have a few credit cards with one company.  The charges come through as "
bankname online payment" when they hit my checking account.

That would be fine if I had only one credit card with that bank.

But with a few different cards, I have issues trying to get them to
auto-reconcile correctly and end up having to manually add the items and
manually pick the right account..and that ends up making duplicate
charges somehow.

What is the right way to set things up so that Gnucash knows what credit
card account is being referenced when the charges hit my checking account?

Thanks for your help!


-Original Message-
From: gnucash-user
[mailto:gnucash-user-bounces+scumbuster=comcast@gnucash.org] On Behalf
Of gnucash-user-requ...@gnucash.org
Sent: Wednesday, February 16, 2022 12:00 PM
To: gnucash-user@gnucash.org
Subject: gnucash-user Digest, Vol 227, Issue 32

Send gnucash-user mailing list submissions to
gnucash-user@gnucash.org

To subscribe or unsubscribe via the World Wide Web, visit
https://lists.gnucash.org/mailman/listinfo/gnucash-user
or, via email, send a message with subject or body 'help' to
gnucash-user-requ...@gnucash.org

You can reach the person managing the list at
gnucash-user-ow...@gnucash.org

When replying, please edit your Subject line so it is more specific than
"Re: Contents of gnucash-user digest..."


--
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Potential Computational Errors

2022-02-18 Thread Derek Atkins
HI,

Thank you for sending this, however I still cannot understand what the
proposed computation error is.  First, I don't read the language(s) in the
image.  Second, you're not showing a picture of a GnuCash register, and
due to the language issue I cannot tell *WHAT* it is a picture of.  Based
on that, I have no way to divine what the computation is supposed to be,
in order to even verify that the computation is wrong.

I *WILL* say that it looks like you are using two currencies.

It looks like you have three entries in ¥ but then the last entry appears
to be in a different currency (Yuan?  I'm not sure what that character
means).

Assuming I am correct, then the "computation" is going to be based on the
exchange rate you entered.  But I cannot tell if this is a single
transaction or what.

Can you show this in the GnuCash Register UI (with colored lines)?

Thanks,

-derek

On Thu, February 17, 2022 6:58 pm, Gao Bite wrote:
> GnuCash Developers & Maintainers:
>
>       Hello! This is the attachment which I originally planned
> to send.
>
>  Yours,
>Bite Gao
> Feb 17th, 2022
>
> On Thu, February 17, 2022 9:08 am, Derek Atkins wrote:
>
>> HI,
>>
>> On Thu, February 17, 2022 9:08 am, Gao Bite wrote:
>>> GnuCash Developers & Maintainers:
>>>
>>>       Hello! I have recently found a mismatch computation result from
>>> your software.
>>>
>>> It may be a computational mistake, or a special accounting standard. I
>>> would like to know
>>>
>>> whether it is.
>>>
>>>
>>>       Yours,
>>>
>>>       Bite Gao
>>>
>>> Feb 17th, 2021
>>>
>>> Attachment:
>>>
>>> Image which describes potential error:
>>>
>> This list scraps all HTML and embedded images.  You need to attach them
>> to
>> get them through the list.  As a result, we cannot see what potential
>> computation error you seem to be seeing.
>>
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>> -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
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


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

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.