Re: [GNC] Scheduled Transaction Calculations

[John Ralls]

> On Nov 2, 2019, at 7:08 AM, Fred Bone  wrote:
> 
> On 01 November 2019 at 12:34, John Ralls said:
> 
> [...]
>> You could try adding this to fin.scm:
>> 
>> (load-from-path "gnucash/app-utils")
>> (define (gnc:days-in-prev-month) (/ ( + 1 (- (gnc:get-end-prev-month)
>> (gnc:get-start-prev-month 86400))
> 
> This will produce a non-integer result if
> (a) prev month includes daylight-saving-time shift
> or
> (b) prev month includes a leap second.
> 
> (While I'm not familiar with Scheme, if the potential non-integer result 
> isn't an issue -- i.e. if it gets auto-rounded to nearest integer -- then 
> there was no point in adding the odd second).
> 

Time in GnuCash is UTC internally so there are no daylight-time changes. A leap 
second might be an issue, though a rather rare one.

See https://www.gnu.org/software/guile/manual/html_node/Exactness.html. Without 
adding the second back in the result of the division for October was 
2678399/86400. One could instead use 
  (round (/ (- (gnc:get-end-prev-month) (gnc:get-start-prev-month 86400))
which would resolve the leap-second problem.

Regards,
John Ralls
___
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] Scheduled Transaction Calculations

[Fred Bone]

On 01 November 2019 at 12:34, John Ralls said:

[...]
> You could try adding this to fin.scm:
> 
> (load-from-path "gnucash/app-utils")
> (define (gnc:days-in-prev-month) (/ ( + 1 (- (gnc:get-end-prev-month)
> (gnc:get-start-prev-month 86400))

This will produce a non-integer result if
(a) prev month includes daylight-saving-time shift
or
(b) prev month includes a leap second.

(While I'm not familiar with Scheme, if the potential non-integer result 
isn't an issue -- i.e. if it gets auto-rounded to nearest integer -- then 
there was no point in adding the odd second).


___
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 Report: 1)Print only totals 2)Add comment to print out ?

[Adrien Monteleone]

CoA: Chart of Accounts

It has the simple label ‘Accounts’ and is the default tab in GnuCash if you 
have none open. (I also don’t think you can close it)

Some Find operations only work properly when done if that tab has focus. Some 
of those cases should probably be filed as bugs, but sometimes the behavior 
might be intended.

Like any other tab, you can rename it if you like.

Regards,
Adrien

> On Nov 2, 2019 w44d306, at 7:29 AM, Fran_3  wrote:
> 
> Adrien, 
> 
> What is the CoA tab for all accounts? Where is it?
> 
> (This is what is so great about gnuCash, it is so rich in features that you 
> can almost learn something new abut it's capabilities every day :-)
> 
> Fran3


___
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 Report: 1)Print only totals 2)Add comment to print out ?

[Fran_3 via gnucash-user]

 Adrien, 

What is the CoA tab for all accounts? Where is it?
(This is what is so great about gnuCash, it is so rich in features that you can 
almost learn something new abut it's capabilities every day :-)
Fran3


On Friday, November 1, 2019, 10:01:07 PM EDT, Adrien Monteleone 
 wrote:  
 
 As Fran notes, the Transaction report has several filters and sorting means, 
but using an amount cut-off is not one of them.

But you can run a Find on a particular register (or from the CoA tab for all 
accounts) and then use multiple criteria to narrow down your search. (no need 
to run multiple searches) One of those can be ‘value’ is either debit/credit or 
both.

You can then run a ‘register report’ on the Find results tab.

Regards,
Adrien

> On Nov 1, 2019 w44d305, at 1:12 PM, Gareth Davies via gnucash-user 
>  wrote:
> 
> Hi all,
> 
> I have been reading these emails with interest, but I was wondering if I
> could apply a filter in the transactions to only show those people who have
> paid Membership Fees above a certain amount i.e £100
> 
> Cheers,
> Gareth

___
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] How should I enter values on a budget in gnucash ?

[Jim Passmore]

TL;DR--Summary lines are good, but poorly named.  keep them.

Regarding the summary lines, as already said Income and Expense totals are
self-explanatory.  I'll try to explain a use-case for the other lines.

First of all, let's ignore the "transfers" part for a bit.  When I do a
budget, I'm concerned about inflows and outflows, and I do it all with
respect to my operating account (a personal checking account).  In spite of
the double-entry approach to accounting, I don't fill in expected entries
to the operating account--just the budgeted income and expenses.  Then you
can look at the totals to determine if your expected income will cover your
expenses and make decisions to adjust the budget (or at least maybe you're
willing for the account balance to decrease by the expense overage for that
budget period).  Having a "Total" of Income-Expenses does the math for you,
and helps you determine how much more you can plan to spend, or how much
more income you need, etc.

So now let's consider the "Transfers" line.  If I want to budget some cash
to go into a savings account, I would enter the transfer amount into the
Asset account, and the end result to my operating account balance is
exactly the same as an expense--the balance goes down.  Same thing applies
to paying down a liability--it's not an Expense in the strict accounting
sense, but it's an outflow from the operating account.  After you collect
these, treating them the same as expenses in the "Total" line (i.e.,
subtracting them, currently) is appropriate.

I have no idea on a use-case for budgeting changes to equity.

As for the names "Total" and "Transfers":
As it operates currently, "Total" is a poor name; "Difference" would be
more accurate.  However, if you change the sign-reversal treatment you may
have positive income, negative expenses, and "Total" would be an accurate
choice.

Transfers--isn't everything in double-entry accounting a transfer?  :-)

Just totaling the Income/Expense/etc. would force the budgeter to do the
math for each period.  Having some sort of net at the bottom is very good.
Maybe call it "Net Budgeted Cash Flow"?  After all, I'm describing a
planned cash flow.

Hope this made sense.

-- 
*Jim Passmore*





On Tue, Oct 29, 2019 at 1:45 PM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

> On 10/29/2019 9:40 AM, Adrien Monteleone wrote:
> > No objection here —I always thought it odd that Liabilities didn’t have
> its own total line, and thought ’Transfers’ should only include Assets &
> Equity. (you are transferring one asset to another, with no effect on net
> position, but paying a liability would change your net position)
> >
> Assets and Equity are NOT "both assets"  << this is confusing a
> different meaning of equity>>
>
> A transfer between "assets" and "liabilities"does NOT change net
> position (ie: equity). A transfer from assets to liabilities that is
> "paying a liability" is a debit to a liability (reducing it) and a
> credit to an asset (reducing it) so no net change as the debit and
> credit will be equal. Taking on more debt, a debit to an asset and a
> credit to a liability also does not change net position (equity)
>
> What sort of transaction would be a transfer between an asset and
> equity?  Why do you think that this would not be a change to your net
> position?
>
> Michael D Novack
>
>
> ___
> 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 Report: 1)Print only totals 2)Add comment to print out ?

[Gareth Davies via gnucash-user]

Fran3,

 

Thanks Fran for the help, I will experiment with the various settings and see 
what happens.

 

Once again thanks for the help.

 

Gareth

 

 

From: Fran_3  
Sent: 01 November 2019 18:51
To: stepbystepf...@comcast.net; gnucash-user@gnucash.org; 
gareth.davie...@ntlworld.com
Subject: Re: [GNC] Transaction Report: 1)Print only totals 2)Add comment to 
print out ?

 

Gareth,

 

I'm not sure you can use the Transaction Report to search an account... say the 
checking account... for a value greater than X.

 

I also don't see a way using the Customer Report.

 

But, you can just bring up the register... say the checking account register... 
and search (Ctl-F) the Description, Notes, and Memo fields for whatever... like 
find all transactions in checking to or from GoDaddy...

 

Then, press Ctl-F again but this time, instead of searching for something in 
the Description, Notes, or Memo fields search for Value... then you can set 
that search to return transactions greater than... your magic number.

 

So maybe if your Paid Members were in Sales... I guess there might be two 
cases...

 

Sales from Paid Members and Sales from whatever else.

 

If some keyword were in the Paid Member transaction... like "membership dues" 
than you could search the Sales Register for that then do your search of those 
results for the Value greater than X.

 

I'm sure there may be a better way but maybe this will give you an idea of 
something to try.

 

Good Luck,

 

Fran3

 

 

On Friday, November 1, 2019, 2:13:26 PM EDT, Gareth Davies via gnucash-user 
mailto:gnucash-user@gnucash.org> > wrote: 

 

 

Hi all,

I have been reading these emails with interest, but I was wondering if I
could apply a filter in the transactions to only show those people who have
paid Membership Fees above a certain amount i.e £100

Cheers,
Gareth


-Original Message-
From: gnucash-user
mailto:ntlworld@gnucash.org> > On Behalf Of
Michael or Penny Novack
Sent: 01 November 2019 13:28
To: gnucash-user@gnucash.org  
Subject: Re: [GNC] Transaction Report: 1)Print only totals 2)Add comment to
print out ?

On 11/1/2019 8:46 AM, Fran_3 via gnucash-user wrote:
> I think I know the answer to this but I wanted to double check.
> .
> 2 - Is there any way to add a comment to the report before you print it...
other than making the title long?
> 3 - Can you include HTML tags like  and  to have a report's
first line bold and 2nd line small for additional comments?
> Thanks,
> Fran3

This is a perfect example (even though minimal changes compared to what I am
usually doing)

Why ask for/expect this capability from WITHIN the accounting software? 
These are the sort of changes you might want/need for the finished product
(the report as will be presented) but have nothing to do with the accounting
data.

Export the report, bring it into a document under control of your favorite
editor, then add the details like notes, change font or size of certain
parts, selective bolding or italics, etc.

COULD the developers add (to within the accounting package) the capabilities
of an editor? Perhaps. But WHY do that when plenty of perfectly good editing
apps already exist.

Michael D Novack


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