[GNC] Roundoff issues in amortized payments?

[Hong Xu]

Say I prepaid some expenses for $100 for 1 year. I can do $100/12=$8.33 
for monthly expenses, but 8.33 * 12 = 99.96 < 100. Instead, I would hope 
gnucash can schedule transactions that automatically round these to $8.34, 
$8.33, $8.33, $8.34, $8.33... Is this currently possible?

I was looking into pmt function and hope it can solve my problem, but the 
doc  
currently says pmt doesn't support zero interest loans:


    It does not support zero-interest loans, but one doesn't really need an 
assistant for that: Just create a scheduled transaction 
for the principal divided by the number of payments that lasts for the number 
of payments. For example, if one has borrowed $1200 for a year at no 
interest and promised to pay it back in monthly installments, the repayment 
schedule is $100 monthly for twelve months.


Thanks!

Hong


___
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] Roundoff issues in amortized payments?

[Stan Brown]

On 2021-06-09 00:20, Hong Xu wrote:
> Say I prepaid some expenses for $100 for 1 year. I can do
> $100/12=$8.33 for monthly expenses, but 8.33 * 12 = 99.96 < 100.
> Instead, I would hope gnucash can schedule transactions that
> automatically round these to $8.34, $8.33, $8.33, $8.34, $8.33...
> Is this currently possible?

Automatically? I'm pretty sure it's not possible.

But you can schedule them yourself. What I do in a similar situation is
make one regular transaction for $8.37, then create a scheduled
transaction of $8.33 a month for 11 months. That way I don't have to
remember to do $8.34 in some months and $8.33 in other months.

-- 
Stan Brown
Tehachapi, CA, USA
https://BrownMath.com
https://OakRoadSystems.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] Roundoff issues in amortized payments?

[David Cousens]

Hong,
GnuCash currently does not adjust the scheduled payments. It could, but there is
no way for GnuCash to know in what order your bank may choose to do these
adjustments to the payments so you would have to adjust them manually in any
case. The idea is AFAIK to act as a reminder to record repeated payments and to
act as a predictor of future cash requirements rather than to record the
payments per se.

David

On Wed, 2021-06-09 at 00:20 -0700, Hong Xu wrote:
> Say I prepaid some expenses for $100 for 1 year. I can do $100/12=$8.33 
> for monthly expenses, but 8.33 * 12 = 99.96 < 100. Instead, I would hope
> gnucash can schedule transactions that automatically round these to $8.34,
> $8.33, $8.33, $8.34, $8.33... Is this currently possible?
> 
> I was looking into pmt function and hope it can solve my problem, but the 
> doc 
> currently says pmt doesn't support zero interest loans:
> 
> 
> It does not support zero-interest loans, but one doesn't really need an
> assistant for that: Just create a scheduled transaction 
> for the principal divided by the number of payments that lasts for the number
> of payments. For example, if one has borrowed $1200 for a year at no 
> interest and promised to pay it back in monthly installments, the repayment
> schedule is $100 monthly for twelve months.
> 
> 
> Thanks!
> 
> Hong
> 
> 
> ___
> 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] Transaction ordering on num field

[flywire]

How can special customisation to sort a GnuCash field be justified when it
makes future transitions even more difficult? This field should be sorted in
a standard way. It's clearly the old *numeric* field for sorting cheques,
and the banks tell us cheques are as good as dead. When it was changed to
alphanumeric the sort order should have changed too, ie 10 before 2.

I note David's comment on current functionality. Significant changes should
occur at major versions.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.