Re: [GNC] Next-level Budgeting

2023-04-15 Thread R Losey
I used to use Quicken's budgeting features, but found it buggy and it would
mislead me... so I moved the budget to a spreadsheet. I then run reports in
GnuCash to look at my expenditures and compare them to the spreadsheet.

I'm doing a fixed amount per month because it is easier... but a better
budget would be to also have seasonal changes - for example, if one has gas
heat one only has gas utility expenses in the cold months. Expenses
associated with lawn care don't occur (very much) in the winter.

It's just a little more trouble to set up a variable budget than what I
have now; so far, it is not worth the effort maybe someday.


On Sat, Apr 15, 2023 at 4:17 AM flywire  wrote:

> How do people do their budgeting? Budgets need planning, reporting, and
> revising based on actual transactions. GnuCash reports of past transactions
> can help budget and a cashbook is best positioned for reporting budget
> compared to year-to-date amounts.
>
> A monthly budget simply dividing annual income and expenses by 12  is
> normally convenient for a quick look but if cash flow is really tight you
> might want next-level budgeting. You can align budget periods with regular
> income periods, maybe fortnightly. If you plan to use a tax refund to pay
> for a holiday it is no good if the expense occurs at the start of the month
> and the income is received at the end.
>
> [snipped]

> ___
> 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] Deleting an account

2023-04-15 Thread R Losey
Excellent (thanks!) - I'm going to make use of hiding old accounts!

On Sat, Apr 15, 2023 at 10:24 PM Gyle McCollam  wrote:

> After it is hidden you can still get to it by going to the accounts page,
> "view/filter by", then select the "other" tab and click on "show hidden
> accounts"
>
> Thank You,
>
> *Gyle McCollam*
>
> Gyle McCollam
>
> gmccol...@live.comemail
> --
> *From:* gnucash-user 
> on behalf of R Losey 
> *Sent:* Saturday, April 15, 2023 11:14 PM
> *To:* G R Hewitt 
> *Cc:* gnucash-user@gnucash.org 
> *Subject:* Re: [GNC] Deleting an account
>
> For old, unused accounts, say closed credit cards, I created a placeholder
> in Credit Cards called "ZZZ_closed" and then edit the closed credit card to
> make it's parent directory ZZZ_closed. That way, I keep all of the
> transactions, but it isn't in the current list.
>
> Hiding sounds better, as long as there is some way to get at it after it is
> hidden.
>
>
> On Sat, Apr 15, 2023 at 2:27 AM G R Hewitt  wrote:
>
> > I agree with Michael on this, deleting accounts has a knock on effect
> that
> > isn't always apparent.
> > In one firm I worked for, the GM took it upon himself to delete a load of
> > customer accounts that were at zero when I was away.
> > This was Sage Line 50, it totally screwed the accounts but was not
> apparent
> > at the time.
> > Deleting the accounts is akin to tearing the pages out of a journal; best
> > to 'hide' them as suggested.
> >
> >
> > On Fri, 14 Apr 2023 at 23:32, Michael or Penny Novack <
> > stepbystepf...@comcast.net> wrote:
> >
> > > On 4/14/2023 4:51 PM, Gyle McCollam wrote:
> > > > I have a fixed asset account for an automobile with subaccounts for
> the
> > > purchase cost and depreciation.  I am selling this car and purchasing a
> > new
> > > car. How do I delete the old car from my COA without messing up the
> > > financials as there have been debits and credits to the 2 subaccounts.
> > The
> > > parent account at this point has a zero balance as the vehicle is fully
> > > depreciated.
> > > >
> > > You don't delete it (it would indeed mess up all those transactions)
> > >
> > > It's no longer needed, balance is zero, just HIDE it. Do note that if
> > > you dispose of this fully depreciated asset for a gain, you will have a
> > > capital gain to record that transaction << but that wouldn't involve
> > > this account >>
> > >
> > >
> > > 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
> > > -
> > > 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.
>


-- 
_
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] Deleting an account

2023-04-15 Thread Gyle McCollam
After it is hidden you can still get to it by going to the accounts page, 
"view/filter by", then select the "other" tab and click on "show hidden 
accounts"


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email


From: gnucash-user  on 
behalf of R Losey 
Sent: Saturday, April 15, 2023 11:14 PM
To: G R Hewitt 
Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] Deleting an account

For old, unused accounts, say closed credit cards, I created a placeholder
in Credit Cards called "ZZZ_closed" and then edit the closed credit card to
make it's parent directory ZZZ_closed. That way, I keep all of the
transactions, but it isn't in the current list.

Hiding sounds better, as long as there is some way to get at it after it is
hidden.


On Sat, Apr 15, 2023 at 2:27 AM G R Hewitt  wrote:

> I agree with Michael on this, deleting accounts has a knock on effect that
> isn't always apparent.
> In one firm I worked for, the GM took it upon himself to delete a load of
> customer accounts that were at zero when I was away.
> This was Sage Line 50, it totally screwed the accounts but was not apparent
> at the time.
> Deleting the accounts is akin to tearing the pages out of a journal; best
> to 'hide' them as suggested.
>
>
> On Fri, 14 Apr 2023 at 23:32, Michael or Penny Novack <
> stepbystepf...@comcast.net> wrote:
>
> > On 4/14/2023 4:51 PM, Gyle McCollam wrote:
> > > I have a fixed asset account for an automobile with subaccounts for the
> > purchase cost and depreciation.  I am selling this car and purchasing a
> new
> > car. How do I delete the old car from my COA without messing up the
> > financials as there have been debits and credits to the 2 subaccounts.
> The
> > parent account at this point has a zero balance as the vehicle is fully
> > depreciated.
> > >
> > You don't delete it (it would indeed mess up all those transactions)
> >
> > It's no longer needed, balance is zero, just HIDE it. Do note that if
> > you dispose of this fully depreciated asset for a gain, you will have a
> > capital gain to record that transaction << but that wouldn't involve
> > this account >>
> >
> >
> > 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
> > -
> > 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.
___
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] Deleting an account

2023-04-15 Thread R Losey
For old, unused accounts, say closed credit cards, I created a placeholder
in Credit Cards called "ZZZ_closed" and then edit the closed credit card to
make it's parent directory ZZZ_closed. That way, I keep all of the
transactions, but it isn't in the current list.

Hiding sounds better, as long as there is some way to get at it after it is
hidden.


On Sat, Apr 15, 2023 at 2:27 AM G R Hewitt  wrote:

> I agree with Michael on this, deleting accounts has a knock on effect that
> isn't always apparent.
> In one firm I worked for, the GM took it upon himself to delete a load of
> customer accounts that were at zero when I was away.
> This was Sage Line 50, it totally screwed the accounts but was not apparent
> at the time.
> Deleting the accounts is akin to tearing the pages out of a journal; best
> to 'hide' them as suggested.
>
>
> On Fri, 14 Apr 2023 at 23:32, Michael or Penny Novack <
> stepbystepf...@comcast.net> wrote:
>
> > On 4/14/2023 4:51 PM, Gyle McCollam wrote:
> > > I have a fixed asset account for an automobile with subaccounts for the
> > purchase cost and depreciation.  I am selling this car and purchasing a
> new
> > car. How do I delete the old car from my COA without messing up the
> > financials as there have been debits and credits to the 2 subaccounts.
> The
> > parent account at this point has a zero balance as the vehicle is fully
> > depreciated.
> > >
> > You don't delete it (it would indeed mess up all those transactions)
> >
> > It's no longer needed, balance is zero, just HIDE it. Do note that if
> > you dispose of this fully depreciated asset for a gain, you will have a
> > capital gain to record that transaction << but that wouldn't involve
> > this account >>
> >
> >
> > 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
> > -
> > 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] Deleting an account

2023-04-15 Thread R Losey
This was helpful; I didn't even know that there was an option to hide an
account

But how does one un-hide an account? (say a question arises about something
in that account from the past?)

On Fri, Apr 14, 2023 at 6:17 PM Gyle McCollam  wrote:

> Michael,
> Thank you, I forgot about hiding accounts.  I'm aware there will be a
> capital gain, but since it is personal finance, it is not taxable, just as
> the depreciation was not deductible.  I just like to write off assets that
> go down in value over time.
>
>
> Thank You,
>
> Gyle McCollam
>
> Gyle McCollam
>
> gmccol...@live.com   email
>
> 
> From: gnucash-user  on
> behalf of Michael or Penny Novack 
> Sent: Friday, April 14, 2023 6:31 PM
> To: gnucash-user@gnucash.org 
> Subject: Re: [GNC] Deleting an account
>
> On 4/14/2023 4:51 PM, Gyle McCollam wrote:
> > I have a fixed asset account for an automobile with subaccounts for the
> purchase cost and depreciation.  I am selling this car and purchasing a new
> car. How do I delete the old car from my COA without messing up the
> financials as there have been debits and credits to the 2 subaccounts.  The
> parent account at this point has a zero balance as the vehicle is fully
> depreciated.
> >
> You don't delete it (it would indeed mess up all those transactions)
>
> It's no longer needed, balance is zero, just HIDE it. Do note that if
> you dispose of this fully depreciated asset for a gain, you will have a
> capital gain to record that transaction << but that wouldn't involve
> this account >>
>
>
> 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
> -
> 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] Retained Losses on Balance Sheet

2023-04-15 Thread Murugan Muruganandam
The balance sheet report will change the title to Retained Earnings if it is 
profit and Retained Losses if it is loss

Trading gains will be reflected as negative in COA.




Saludos Cordiales


Murugan


From: Fred Tydeman 
Sent: Saturday, April 15, 2023 3:50 PM
To: Murugan Muruganandam 
Cc: Gnucash Users 
Subject: Re: [GNC] Retained Losses on Balance Sheet

Thank you.

If the Balance Sheet said:  Retained Earnings/Losses
then it would make sense for my report to have a red negative number.

The Trading Gains number is positive on my report,
but is negative in the COA.  Is that to be expected?

On Sat, Apr 15, 2023 at 10:17 PM Murugan Muruganandam 
mailto:m.muruganan...@hotmail.com>> wrote:
this thread gives you a complete run down on the concept.

https://lists.gnucash.org/pipermail/gnucash-user/2016-December/067980.html


to cross verify your retained losses, run a Profit and Loss report from the 
starting of  your book date and you should see the number.

also, you will not see this as negative as the title itself states  you have a 
loss.


Saludos Cordiales


Murugan


From: gnucash-user 
mailto:hotmail@gnucash.org>>
 on behalf of Fred Tydeman 
mailto:tydeman.f...@gmail.com>>
Sent: Saturday, April 15, 2023 1:29 PM
To: Gnucash Users mailto:gnucash-user@gnucash.org>>
Subject: [GNC] Retained Losses on Balance Sheet

OS: Linux Fedora 37
GnuCash  4.14

I am running a Balance Sheet report
In the Equity section, I have four subtotals, all in black.
  Total equity (of my accounts)
  Retained Losses
  Trading Gains
  Total Equity (report)

For bottom Total Equity to be the sum of the other three,
Retained Losses should be negative and in Red,
instead of positive and in Black.

Am what I am getting the expected result,
or is this a bug in the report?

Also, where does Retained Losses come from?
There is no entry in the Tutorial and Concepts Guide.
___
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] Retained Losses on Balance Sheet

2023-04-15 Thread Michael or Penny Novack

On 4/15/2023 3:17 PM, Murugan Muruganandam wrote:

this thread gives you a complete run down on the concept.

https://lists.gnucash.org/pipermail/gnucash-user/2016-December/067980.html


to cross verify your retained losses, run a Profit and Loss report from the 
starting of  your book date and you should see the number.


More precisely, from the date you last did a "close the books" operation 
(that closes the net of the income and expense accounts to equity). What 
is "retained" is the net of income and expenses (either retained gains 
or retained losses)


The "start of books" works for the majority of us since few of us do a 
"close the books" so the date would be the same.



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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Retained Losses on Balance Sheet

2023-04-15 Thread Fred Tydeman
Thank you.

If the Balance Sheet said:  Retained Earnings/Losses
then it would make sense for my report to have a red negative number.

The Trading Gains number is positive on my report,
but is negative in the COA.  Is that to be expected?

On Sat, Apr 15, 2023 at 10:17 PM Murugan Muruganandam <
m.muruganan...@hotmail.com> wrote:

> this thread gives you a complete run down on the concept.
>
> https://lists.gnucash.org/pipermail/gnucash-user/2016-December/067980.html
>
> to cross verify your retained losses, run a Profit and Loss report from
> the starting of  your book date and you should see the number.
>
> also, you will not see this as negative as the title itself states  you
> have a loss.
>
>
> Saludos Cordiales
>
>
> Murugan
> --
> *From:* gnucash-user  hotmail@gnucash.org> on behalf of Fred Tydeman  >
> *Sent:* Saturday, April 15, 2023 1:29 PM
> *To:* Gnucash Users 
> *Subject:* [GNC] Retained Losses on Balance Sheet
>
> OS: Linux Fedora 37
> GnuCash  4.14
>
> I am running a Balance Sheet report
> In the Equity section, I have four subtotals, all in black.
>   Total equity (of my accounts)
>   Retained Losses
>   Trading Gains
>   Total Equity (report)
>
> For bottom Total Equity to be the sum of the other three,
> Retained Losses should be negative and in Red,
> instead of positive and in Black.
>
> Am what I am getting the expected result,
> or is this a bug in the report?
>
> Also, where does Retained Losses come from?
> There is no entry in the Tutorial and Concepts Guide.
> ___
> 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] Retained Losses on Balance Sheet

2023-04-15 Thread Murugan Muruganandam
this thread gives you a complete run down on the concept.

https://lists.gnucash.org/pipermail/gnucash-user/2016-December/067980.html


to cross verify your retained losses, run a Profit and Loss report from the 
starting of  your book date and you should see the number.

also, you will not see this as negative as the title itself states  you have a 
loss.


Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of Fred 
Tydeman 
Sent: Saturday, April 15, 2023 1:29 PM
To: Gnucash Users 
Subject: [GNC] Retained Losses on Balance Sheet

OS: Linux Fedora 37
GnuCash  4.14

I am running a Balance Sheet report
In the Equity section, I have four subtotals, all in black.
  Total equity (of my accounts)
  Retained Losses
  Trading Gains
  Total Equity (report)

For bottom Total Equity to be the sum of the other three,
Retained Losses should be negative and in Red,
instead of positive and in Black.

Am what I am getting the expected result,
or is this a bug in the report?

Also, where does Retained Losses come from?
There is no entry in the Tutorial and Concepts Guide.
___
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.


[GNC] Retained Losses on Balance Sheet

2023-04-15 Thread Fred Tydeman
OS: Linux Fedora 37
GnuCash  4.14

I am running a Balance Sheet report
In the Equity section, I have four subtotals, all in black.
  Total equity (of my accounts)
  Retained Losses
  Trading Gains
  Total Equity (report)

For bottom Total Equity to be the sum of the other three,
Retained Losses should be negative and in Red,
instead of positive and in Black.

Am what I am getting the expected result,
or is this a bug in the report?

Also, where does Retained Losses come from?
There is no entry in the Tutorial and Concepts Guide.
___
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] GnuCash 5.0 Budget Reporting on select reports are wrong

2023-04-15 Thread Christopher Lam
https://bugs.gnucash.org/

On Sat, 15 Apr 2023, 5:49 pm Richard Lindgren, 
wrote:

> How do I file a Bugzilla report?
>
>
>
> Richard
>
>
>
> *From:* Christopher Lam 
> *Sent:* Saturday, April 15, 2023 5:37 AM
> *To:* Richard Lindgren 
> *Cc:* GnuCash users group 
> *Subject:* Re: [GNC] GnuCash 5.0 Budget Reporting on select reports are
> wrong
>
>
>
> It's true that only the "Budget report" has been scrutinized for bugs.
> Please file in Bugzilla.
>
>
>
> On Sat, 15 Apr 2023, 4:38 pm Richard Lindgren, 
> wrote:
>
> I have upgraded my GnuCash program 4.13 to 5.0 (Build ID:
> 5.0+(2023-03-25)) after realizing that the budget expense calculations were
> not correct. Not all the budget reports are wrong, but of the reports that
> I choose to use that are wrong are:
>
>   1.  Budget Income Statement
>   2.  Budget Profit & Loss Statement.
>
> It appears that both the income and expense values(Data) for the above
> listed reports show the values in black (signifying that they are positive
> numbers for each income and expenses?). The other reports that I use (not
> listed) have their values for the income and expenses in black(income) and
> red(expenses). Those calculations appear to be working fine. The reports
> listed above show the calculations incorrect. In my preferences, I have
> checked the box to have all negative amounts to be in "Red".
>
> In addition to accessing the reports menu for my saved reports, the
> program often crashes. I then am required to reopen the program and are
> given five (5) options before being allowed to continue. They are:
>
>   1.  Open Read Only
>   2.  Create a new file
>   3.  Open anyway
>   4.  Open Folder
>   5.  Quit
>
> I choose option # 3 "Open anyway". After doing that, I save the file and
> then I continue with my reports.
>
> If I am doing something wrong, please forgive me and show me the error of
> my ways.
>
> Thank you in advance for your help. I look forward to hearing from you.
>
> Richard Lindgren
> rlindgr...@outlook.com
> 269-876-9100
> ___
> 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] GnuCash 5.0 Budget Reporting on select reports are wrong

2023-04-15 Thread Christopher Lam
It's true that only the "Budget report" has been scrutinized for bugs.
Please file in Bugzilla.

On Sat, 15 Apr 2023, 4:38 pm Richard Lindgren, 
wrote:

> I have upgraded my GnuCash program 4.13 to 5.0 (Build ID:
> 5.0+(2023-03-25)) after realizing that the budget expense calculations were
> not correct. Not all the budget reports are wrong, but of the reports that
> I choose to use that are wrong are:
>
>   1.  Budget Income Statement
>   2.  Budget Profit & Loss Statement.
>
> It appears that both the income and expense values(Data) for the above
> listed reports show the values in black (signifying that they are positive
> numbers for each income and expenses?). The other reports that I use (not
> listed) have their values for the income and expenses in black(income) and
> red(expenses). Those calculations appear to be working fine. The reports
> listed above show the calculations incorrect. In my preferences, I have
> checked the box to have all negative amounts to be in "Red".
>
> In addition to accessing the reports menu for my saved reports, the
> program often crashes. I then am required to reopen the program and are
> given five (5) options before being allowed to continue. They are:
>
>   1.  Open Read Only
>   2.  Create a new file
>   3.  Open anyway
>   4.  Open Folder
>   5.  Quit
>
> I choose option # 3 "Open anyway". After doing that, I save the file and
> then I continue with my reports.
>
> If I am doing something wrong, please forgive me and show me the error of
> my ways.
>
> Thank you in advance for your help. I look forward to hearing from you.
>
> Richard Lindgren
> rlindgr...@outlook.com
> 269-876-9100
> ___
> 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.


[GNC] Next-level Budgeting

2023-04-15 Thread flywire
How do people do their budgeting? Budgets need planning, reporting, and
revising based on actual transactions. GnuCash reports of past transactions
can help budget and a cashbook is best positioned for reporting budget
compared to year-to-date amounts.

A monthly budget simply dividing annual income and expenses by 12  is
normally convenient for a quick look but if cash flow is really tight you
might want next-level budgeting. You can align budget periods with regular
income periods, maybe fortnightly. If you plan to use a tax refund to pay
for a holiday it is no good if the expense occurs at the start of the month
and the income is received at the end.

demo-budget.csv

Account,Bgt,Frequency,Periods,Annual
Asset,.,,,
Income
Salary,-$670.00,f,26,-17420
Expense
Electricity,$78.00,q,4,312
Groceries,$120.00,w,52,6240
Miscellaneous,$100.00,m,12,1200
Internet,$20.00,m,12,240
Phone,$45.00,m,12,540
Rent,$700.00,m,12,8400

Based on the Concepts Guide

Ideally, amounts can be budgeted for when they occur. You know exactly when
salary and rent are due and probably have a regular groceries budget. Other
things like say insurance are annual amounts. You should be able to enter
the planned date for these amounts. Provisional amounts like miscellaneous
costs or new projects can be entered for the budget periods.

A spreadsheet is really handy for this interactive process. Past
transactions can be factored up for inflation, and new transactions added.
Annual amounts can spread though the year by entering a couple of dates for
the period and dragging the amounts down, then adjusting say winter
electricity to be higher than summer.

A good budgeting program should allow the spreadsheet to be uploaded and
allocate each transaction to the budget periods. You need the ability to
zoom in on the transactions for a given period, change date and amount
details possibly in a spreadsheet, and run the budget report again using
actual year-to-date amounts or different budget periods for what has
happened and is still planned. Maybe notional transaction dates and amounts
can be adjusted to better reflect the expected amount, some of the grocery
costs held over to the next period, insurance paid monthly so the
annual premium falls due at a different time of year, or sell the
firstborn. That's the power of a cash flow budget.

It's been a while since I tried out GnuCash budgeting but it fell short of
next-level budgeting. That's when it makes a difference. What do you think?

Regards
___
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] GnuCash 5.0 Budget Reporting on select reports are wrong

2023-04-15 Thread Richard Lindgren
I have upgraded my GnuCash program 4.13 to 5.0 (Build ID: 5.0+(2023-03-25)) 
after realizing that the budget expense calculations were not correct. Not all 
the budget reports are wrong, but of the reports that I choose to use that are 
wrong are:

  1.  Budget Income Statement
  2.  Budget Profit & Loss Statement.

It appears that both the income and expense values(Data) for the above listed 
reports show the values in black (signifying that they are positive numbers for 
each income and expenses?). The other reports that I use (not listed) have 
their values for the income and expenses in black(income) and red(expenses). 
Those calculations appear to be working fine. The reports listed above show the 
calculations incorrect. In my preferences, I have checked the box to have all 
negative amounts to be in "Red".

In addition to accessing the reports menu for my saved reports, the program 
often crashes. I then am required to reopen the program and are given five (5) 
options before being allowed to continue. They are:

  1.  Open Read Only
  2.  Create a new file
  3.  Open anyway
  4.  Open Folder
  5.  Quit

I choose option # 3 "Open anyway". After doing that, I save the file and then I 
continue with my reports.

If I am doing something wrong, please forgive me and show me the error of my 
ways.

Thank you in advance for your help. I look forward to hearing from you.

Richard Lindgren
rlindgr...@outlook.com
269-876-9100
___
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] Deleting an account

2023-04-15 Thread G R Hewitt
I agree with Michael on this, deleting accounts has a knock on effect that
isn't always apparent.
In one firm I worked for, the GM took it upon himself to delete a load of
customer accounts that were at zero when I was away.
This was Sage Line 50, it totally screwed the accounts but was not apparent
at the time.
Deleting the accounts is akin to tearing the pages out of a journal; best
to 'hide' them as suggested.


On Fri, 14 Apr 2023 at 23:32, Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

> On 4/14/2023 4:51 PM, Gyle McCollam wrote:
> > I have a fixed asset account for an automobile with subaccounts for the
> purchase cost and depreciation.  I am selling this car and purchasing a new
> car. How do I delete the old car from my COA without messing up the
> financials as there have been debits and credits to the 2 subaccounts.  The
> parent account at this point has a zero balance as the vehicle is fully
> depreciated.
> >
> You don't delete it (it would indeed mess up all those transactions)
>
> It's no longer needed, balance is zero, just HIDE it. Do note that if
> you dispose of this fully depreciated asset for a gain, you will have a
> capital gain to record that transaction << but that wouldn't involve
> this account >>
>
>
> 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
> -
> 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] Hidden Accounts

2023-04-15 Thread David T. via gnucash-user
For what it's worth: https://bugs.gnucash.org/show_bug.cgi?id=397135

⁣David T. ​

On Apr 15, 2023, 8:19 AM, at 8:19 AM, "David T. via gnucash-user" 
 wrote:
>That's the behavior since 2006. I never paid attention to the dialog,
>which is incorrect. To hide the account in the transfer drop down, you
>do have to set it as a Placeholder as well. There's a bug about this
>that has a long discussion about it. I can't find it right now. 
>
>⁣David T. ​
>
>On Apr 15, 2023, 3:29 AM, at 3:29 AM, Gyle McCollam
> wrote:
>>when you edit an account and select hidden the pop up tip/dialogue
>says
>>"This account (and any sub-accounts) will be hidden in the account
>tree
>>and will not appear in the popup account list in the register." (see
>>photo), but they do appear in the register when selecting an account
>in
>>the transfer column of the register.  Am I wrong in thinking this
>>should not be happening?  The only way I can have them not show up is
>>to make it a placeholder account.  If these should not be showing up,
>I
>>will file a bug report.
>>
>>PS I tried to snip this, but the dialog/tip would disappear so I had
>to
>>take a picture with my phone.
>>
>>
>>Thank You,
>>
>>Gyle McCollam
>>
>>Gyle McCollam
>>
>>gmccol...@live.com   email
>>
>>
>>
>>
>>___
>>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.