Re: [GNC] Recommended Method of Entry for IRA Distributions

[Stan Brown (using GC 2.6.19)]

On 2023-01-12 21:08, Stan Brown wrote:
> And speaking of distributions, did you miss the note I posted at 11:33
> this morning (Pacific time)? I really don't know why you have no choice
> about having withholding taken from an IRA distribution. You can
> _choose_ to do it, or you can file estimated taxes, or maybe your income
> is low enough that you don't even need to do that. But -- unless the
> money is going outside the United States -- you have a _choice_ about
> whether to have withholding. I gave citations and quotes from the IRS
> website.

Sorry -- I got confused about who said what, and this part should have
been directed to Milton Stern rather than R Losey. And Milton Stern
actually did acknowledge -- I saw the email come in after I had sent this.

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

Re: [GNC] Recommended Method of Entry for IRA Distributions

[Stan Brown]

On 2023-01-12 20:55, David T. via gnucash-user wrote:
> Two separate entries. In my mind, this would best be put in one transaction, 
> to make the association obvious. 
> 
> CR - Assets: IRA $1000
> DB - Assets: Checking $1000
> DB - Income: Deferred Income $1000
> CR - Income: IRA Distribution $1000 *
> 
> * Income: IRA Distribution is used to document the distribution for tax 
> purposes.

My only problem with that is that a distribution from an IRS is not
income, any more that the currency you receive when you cash a check is
income.

It's simply moving a portion of your assets from one bucket to another.
And it seems very strange to me that the one event should be recorded in
a four-split transaction.
 ​
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Recommended Method of Entry for IRA Distributions

[Stan Brown]

On 2023-01-12 20:19, R Losey wrote:
> Let me write through a couple of cases.  In the first one, I'm selling
> $1000 worth (10 shares) of security A and having it go directly to my
> checking account with no income tax withholding. (some of these may be
> USA-centric terms; I apologize for that).
> 
> If I can create a "Sell" transaction that sells 10 shares at $1000; the
> other entry would be to increase my taxable distribution category by $1000.
> But what next? My checking account doesn't have the $1000 increase, but
> then what is the "other" category to use for that transaction??

Please forget the notion of "category". Some accounting packages have
that, but it seems to be basically a confusing synonym for "expense-type
account" and maybe "income-type account).

GnuCash has _accounts_. You have an asset-type account for your checking
account, and another asset0type account for your security(ies).

When you sell shares for cash, you increase the balance in your checking
account and decrease the balance in your security account, like this:

Debit (left-hand number column) to Assets:Checking Account
Credit (right-hand column) to Assets:Security(ies).

Taxable distribution is not an account, and the distribution is _not_
_income_. Your net worth is the same after the sale and distribution as
it was before the sale.

Yes,I know that the amount of an IRA distribution must be reported as
taxable income on your form 1040, but in an accounting sense it is not
income.

And speaking of distributions, did you miss the note I posted at 11:33
this morning (Pacific time)? I really don't know why you have no choice
about having withholding taken from an IRA distribution. You can
_choose_ to do it, or you can file estimated taxes, or maybe your income
is low enough that you don't even need to do that. But -- unless the
money is going outside the United States -- you have a _choice_ about
whether to have withholding. I gave citations and quotes from the IRS
website.

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
-
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 4.900 Released

[Fred Tydeman]

I have installed Fedora 37 with Gnome to a different partition (so I can
run different versions).
When I try to follow the instructions in
https://wiki.gnucash.org/wiki/Flatpak,
to install the beta, I get:

[tydeman@x1car2 ~]$ flatpak remote-add --user --if-not-exists flathub
https://flathub.org/beta-repo/flathub-beta.flatpakrepo
[tydeman@x1car2 ~]$ flatpak install --user flathub-beta org.gnucash.GnuCash
Looking for matches…
error: No remote refs found for ‘flathub-beta’
[tydeman@x1car2 ~]$

Since I am doing cut and paste, there should not be any typos.
So, it seems like the Flatpak writeup on betas has something wrong.

On Mon, Jan 9, 2023 at 9:02 PM John Ralls  wrote:

> The GnuCash development team announces GnuCash 4.900, the first unstable
> release leading to GnuCash 5.0.
>
> This is an unstable release for testing purposes. Do not use it with
> production data! Make a copy of your book to test this release.
>
___
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] Recommended Method of Entry for IRA Distributions

[David T. via gnucash-user]

Two separate entries. In my mind, this would best be put in one transaction, to 
make the association obvious. 

CR - Assets: IRA $1000
DB - Assets: Checking $1000
DB - Income: Deferred Income $1000
CR - Income: IRA Distribution $1000 *

* Income: IRA Distribution is used to document the distribution for tax 
purposes.

⁣David T. ​

On Jan 13, 2023, 7:21 AM, at 7:21 AM, R Losey  wrote:
>Thanks for all of the information... however, getting back to the
>original
>question, I'm not sure how to record IRA taxable distributions. I
>thought I
>was doing it, but I am apparently not.
>
>Let me write through a couple of cases.  In the first one, I'm selling
>$1000 worth (10 shares) of security A and having it go directly to my
>checking account with no income tax withholding. (some of these may be
>USA-centric terms; I apologize for that).
>
>If I can create a "Sell" transaction that sells 10 shares at $1000; the
>other entry would be to increase my taxable distribution category by
>$1000.
>But what next? My checking account doesn't have the $1000 increase, but
>then what is the "other" category to use for that transaction??
>
>I looked at my data, and what I've been doing is that the other side of
>the
>Sell transaction is a deposit to my bank account, but this fails
>because
>there is no record of a taxable distribution.
>
>
>On Thu, Jan 12, 2023 at 2:42 PM Michael or Penny Novack <
>stepbystepf...@comcast.net> wrote:
>
>> On 1/12/2023 12:41 PM, R Losey wrote:
>> > Thanks; I know the information is out there, but intuitively, it
>doesn't
>> > make sense to me that depositing funds to my bank account is a
>"debit"
>> > transaction to the bank. It comes from the concept of credit being
>"added
>> > to" and debit being "substracted from", I suppose.
>> >
>> > Is the "Debit on the left" and "Credit on the right" true in
>general
>> > accounting, or just GnuCash?
>>
>> a) Double entry bookkeeping goes back a long way, long enough that
>Latin
>> still in use for communications among the educated in Europe. Think
>of
>> "debit" and "credit" not in terms of plus and minus (before European
>> math had negative numbers) but as "he owes"(me) and "he trusts" (me).
>In
>> other words  he owes me that amount and he trusts me for that amount
>(I
>> owe him)
>>
>> Now look again at the bank account.In YOUR books a debit (the
>bank
>> owes you this money) and in the bank's book a credit (the bank owes
>you
>> this money)
>>
>> b) Debit on the left and credit on the right. In the old days ledger
>> pages had two sides, one side for the debits and the other for the
>> credits (and no balance column). Perhaps within my lifetime it became
>> more common to use three column paper with debit and credit
>transactions
>> with one date, check number, description, and journal reference
>column
>> then a left for debit, a right (middle) for credit, and a balance. o
>a
>> running balance was kept << finding the balance was a process in the
>old
>> days before that >>
>>
>> NOTICE -- so far pen and ink on paper, and gnucash is simply
>modelling that
>>
>> 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.
>>
>
>
>-- 
>_
>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] exporting from gnucash to Excel

[David T. via gnucash-user]

Indeed. 

I don't have to comply with this either, but it seems to me that "pressing a 
button" to export to Excel provides exactly the same automated reliability as 
CTRL-C/CTRL-V (two buttons, if you will) into Excel. The data in both cases 
will have the same reliability. 

⁣David T. ​

On Jan 13, 2023, 5:11 AM, at 5:11 AM, Adrien Monteleone 
 wrote:
>Do a list search on this topic. I'm pretty certain someone has a 
>solution already worked out. I recall several threads over the last 2 
>years or so about this.
>
>Apologies, but I don't use this myself, so I can't comment further.
>
>Regards,
>Adrien
>
>On 1/12/23 8:05 AM, Paul W via gnucash-user wrote:
>> To submit VAT data to HMRC here in the UK I am obliged to use a
>method which is automatic. So I need to find a way to trasnfer the
>balances from a couple of accounts to an Excel spreadsheet
>automatically ie not by copying and pasting. I need to press a button
>and it is done without the opportunity for errors to be introduced to
>the figures.Then I use some pre-approved software which reads the
>spreadsheet and uploads the data to HMRC. Is there some way to transfer
>a balance from an account to an Excel spreadsheet?
>
>___
>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] Recommended Method of Entry for IRA Distributions

[Milton Stern]

Hi Everybody,

I must thank you (David T., Michael D Novack, Stan Brown, Richard Losey, if
I missed someone it was unintentional)  for your excellent insights!

I believe that I have my answer of how to enter the transaction and what
account structure I require if I want the transactions to show up in my
income reports.

Concerning the mention of the required withholding. My statement was nor
entirely accurate (complete) for the sake of brevity.

I am under the impression that you now have to submit form W-4R to lower
(or raise) the withholding tax, instead of just stating whatever
withholding that you wish (0%-100%) at the time of distribution request.

Prior to 2023, you could just state, when you make the distribution request
from the financial institution, that you did not want withholding taken.
Now, I believe you have to submit a form (W-4R), based on your income
(estimated tax bracket).
Without this form submission, the default would be 10% for IRAs (I think
20% for 401K / 403b).
With the submission, the withholding would be based on your expected income
/ tax bracket, so that the appropriate withholding will be taken per
distribution, instead requesting whatever withholding you want, and making
up the difference in quarterly estimates.

I hope I am interpreting the info from my brokerage email incorrectly?

Thanks again everyone,

Moshe


On Thu, Jan 12, 2023 at 12:46 PM R Losey  wrote:

> I'll try interspersing... using RL>>>
>
>
>
> On Wed, Jan 11, 2023 at 9:52 PM Milton Stern  wrote:
>
>> Hi,
>>
>> Please see below 
>>
>> Moshe
>>
>> On Wed, Jan 11, 2023 at 7:06 PM R Losey  wrote:
>>
>>> Hello.
>>>
>>> Assuming you take out $5,000 and they withhold 10% ($500), I would use a
>>> split transaction... sell $5000 worth of the mutual fund, add $4500 to your
>>> bank account, and $500 to federal income tax paid.
>>>
>>
>>> I apologize for not using "debit" and "credit" terms, but I'm not sure
>>> I'd get them right.
>>>
>>
>>  Agreed. The component that I am having trouble with is the
>> Pre-Tax IRA Distribution component. Because it is a Pre-Tax IRA, the
>> distribution is taxable as income.
>> The direct "sell $5000 worth of the mutual fund, add $4500 to
>> your bank account" direct transaction will not show up in Income Reports.
>>
>
> RL>>> In my brokerage account, I actually "sell" the stock and put it in
> the parent account, using the "IRA income category", and then I do a second
> transfer from the brokerage account to my bank.  Example:
>
> Brokerage account (the parent holding account)
>   Sweep Fund
>   Holding 1
>   Holding 2
>
>
>
>
>>
>>
>>>
>>> You can track them however you wish, but the above is how I would do
>>> them... well, except, I never have the mutual fund withhold taxes; I pay my
>>> own taxes quarterly.
>>>
>>
>> ** New for 2023. IRS requires the brokerage to withhold taxes from
>> IRA Distributions. Last year you could specify 0% withholding.
>> ** They don't make it so easy this year. It is sort of a double hit.
>> Even if you get it back as a tax refund, you can't put it back (Rollover)
>> into the IRA to earn tax free.
>>
> RL>>> That's TERRIBLE!  Gr. I wonder what the minimum one can withhold
> is?
>
>
>
>>
>>
>>>
>>>
>>> On Wed, Jan 11, 2023 at 4:35 PM Milton Stern  wrote:
>>>
 Hi,

 What would be the recommended method of Entry for an IRA Distribution?

 The Distribution is for a personal IRA (not Roth).
 The IRA is of Mutual Funds.

 The Mutual Fund is in Assets > Investments - Retirement > Brokerage >
 etc.
 > etc.

 Since this is taxable income, I need to track withholding (Federal) +
 Net
 Distribution to a Checking Account (Assets > Current Assets).
 No Commission fees are applicable, but it would be nice to know
 where/how
 they would be tracked.

 Thank you in advance,

 Moshe
 ___
 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
>>>
>>
>
> --
> _
> 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] Recommended Method of Entry for IRA Distributions

[R Losey]

Thanks for all of the information... however, getting back to the original
question, I'm not sure how to record IRA taxable distributions. I thought I
was doing it, but I am apparently not.

Let me write through a couple of cases.  In the first one, I'm selling
$1000 worth (10 shares) of security A and having it go directly to my
checking account with no income tax withholding. (some of these may be
USA-centric terms; I apologize for that).

If I can create a "Sell" transaction that sells 10 shares at $1000; the
other entry would be to increase my taxable distribution category by $1000.
But what next? My checking account doesn't have the $1000 increase, but
then what is the "other" category to use for that transaction??

I looked at my data, and what I've been doing is that the other side of the
Sell transaction is a deposit to my bank account, but this fails because
there is no record of a taxable distribution.


On Thu, Jan 12, 2023 at 2:42 PM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

> On 1/12/2023 12:41 PM, R Losey wrote:
> > Thanks; I know the information is out there, but intuitively, it doesn't
> > make sense to me that depositing funds to my bank account is a "debit"
> > transaction to the bank. It comes from the concept of credit being "added
> > to" and debit being "substracted from", I suppose.
> >
> > Is the "Debit on the left" and "Credit on the right" true in general
> > accounting, or just GnuCash?
>
> a) Double entry bookkeeping goes back a long way, long enough that Latin
> still in use for communications among the educated in Europe. Think of
> "debit" and "credit" not in terms of plus and minus (before European
> math had negative numbers) but as "he owes"(me) and "he trusts" (me). In
> other words  he owes me that amount and he trusts me for that amount (I
> owe him)
>
> Now look again at the bank account.In YOUR books a debit (the bank
> owes you this money) and in the bank's book a credit (the bank owes you
> this money)
>
> b) Debit on the left and credit on the right. In the old days ledger
> pages had two sides, one side for the debits and the other for the
> credits (and no balance column). Perhaps within my lifetime it became
> more common to use three column paper with debit and credit transactions
> with one date, check number, description, and journal reference column
> then a left for debit, a right (middle) for credit, and a balance. o a
> running balance was kept << finding the balance was a process in the old
> days before that >>
>
> NOTICE -- so far pen and ink on paper, and gnucash is simply modelling that
>
> 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.
>


-- 
_
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] exporting from gnucash to Excel

[Adrien Monteleone]

Do a list search on this topic. I'm pretty certain someone has a 
solution already worked out. I recall several threads over the last 2 
years or so about this.


Apologies, but I don't use this myself, so I can't comment further.

Regards,
Adrien

On 1/12/23 8:05 AM, Paul W via gnucash-user wrote:

To submit VAT data to HMRC here in the UK I am obliged to use a method which is 
automatic. So I need to find a way to trasnfer the balances from a couple of 
accounts to an Excel spreadsheet automatically ie not by copying and pasting. I 
need to press a button and it is done without the opportunity for errors to be 
introduced to the figures.Then I use some pre-approved software which reads the 
spreadsheet and uploads the data to HMRC. Is there some way to transfer a 
balance from an account to an Excel spreadsheet?


___
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] Recommended Method of Entry for IRA Distributions

[Adrien Monteleone]

Careful folks.

This is now way beyond 'how to do this in GnuCash' and very much knee 
deep in realms that require (several) special pieces of framed paper 
hanging on walls.


Regards,
Adrien

___
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] Recommended Method of Entry for IRA Distributions

[Adrien Monteleone]

Thanks for the trip down Memory Lane, Michael. I had long forgotten the 
'Owes/Trusts' origin of the system. I think many things are much easier 
to understand when you find out 'why they are'. Learning the basics of 
the 'old days' helped me to grok Debits & Credits many moons ago.


Regards,
Adrien

On 1/12/23 2:42 PM, Michael or Penny Novack wrote:
a) Double entry bookkeeping goes back a long way, long enough that Latin 
still in use for communications among the educated in Europe. Think of 
"debit" and "credit" not in terms of plus and minus (before European 
math had negative numbers) but as "he owes"(me) and "he trusts" (me). In 
other words  he owes me that amount and he trusts me for that amount (I 
owe him)


___
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] Request for Comments: A simple, mobile-friendly webinterface for GnuCash

[Joshua]

> Great work, this is amazing!

Thanks!

> This would solve the mobile access people have been asking about and
> eliminate apps by going with the responsive web design.

My thoughts exactly!

> Question - if you have more than one book, how do you switch between them?

Sadly, this is currently not possible. The name of the database (and
therefore the book) is statically set in the configuration file. As of
now, the only option would be to have multiple instances running
seperately.

But just from thinking about it for a few minutes, I don't think making
this dynamically selectable would be too much effort. I will certainly
keep that in mind.

--
J.
___
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] Request for Comments: A simple, mobile-friendly webinterface for GnuCash

[Glenn Fowler]

Joshua,

Great work, this is amazing!

This would solve the mobile access people have been asking about and
eliminate apps by going with the responsive web design.

Question - if you have more than one book, how do you switch between them?

On Thu, Jan 12, 2023 at 7:47 PM Joshua  wrote:

>
> Good evening everybody,
>
> I recently built a simple web interface for GnuCash and wish to share
> it with you, in the hopes of receiving feedback and thougths and that it
> might be useful to others:
>
> GitHub: https://github.com/joshuabach/gnucash-web
>
> Demo: https://gnucash-web-demo.bachmeier.cc
>
> I have managed all my personal finances in GnuCash for several years,
> including the cash I carry with me. Being able to record expenses or
> other transactions from my phone is therefore a major usecase to me and
> I imagine to many others as well.
>
> Most existing solutions are based around exporting on mobile & importing
> in the desktop app, which doesn't really satisfy me. There has been some
> activity on this topic here before, e.g. in 2012 James posted about his
> project "gnucash-django" [1], but I don't think much came of it (I found a
> few other things, check out the "Related Work" section in my README on
> GitHub if you are interested).
>
> Anyway, back to my project: I got the Idea to do this when I discoverd
> piecash [2] and quickly hacked together an MVP. After some month of
> using, patching and extending it I must say I am quiet happy with the
> result. One can browse accounts, view, add and edit transactions, and
> the like (see the README for a better feature list with screenshots).
>
> The setup is to use one of the database backends instead of the XML
> backend and hook the app up to that. I have the app running on a server
> (with MariaDB) and use an SSH tunnel to access the database directly with
> the
> desktop app.
>
> Whats important to me is that this stays absolutely simple. I don't want
> to replace the desktop app in any way (not that I could). GnuCash Web is
> intended as a "companion" app to record (and mayby fix) simple
> transactions [3] on the go, because I usually forget them until I get home.
>
> Another neat feature is a simple CLI that can be used to get new price
> quotes for all custom securities and currencies in the database. Using
> e.g. a cronjob, the price history for my commodities always stays up to
> date even if I don't open GnuCash for a while.
>
> Ì've been using my app personally for just over a year now and find it
> great. I can no longer imagine using GnuCash for my day-to-day finances
> without it and will probably be using (and therefore maintain it) for
> many years to come.
>
> Alright, thanks for reading to this point. Please do try out the demo,
> look at the repo or even set it up yourself. If you have any thougths,
> suggestions or feedback, please tell me. I'm thankful for any
> response. I'd be happy to engage in a discussion about this.
>
> Best regards,
> Joshua
>
> [1]: https://github.com/sdementen/piecash
> [2]:
> https://lists.gnucash.org/pipermail/gnucash-user/2012-March/043762.html
> [3]: With "simple" transaction I mean only two splits
>
> --
> J.
> ___
> 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] exporting from gnucash to Excel

[Paul W via gnucash-user]

To submit VAT data to HMRC here in the UK I am obliged to use a method which is 
automatic. So I need to find a way to trasnfer the balances from a couple of 
accounts to an Excel spreadsheet automatically ie not by copying and pasting. I 
need to press a button and it is done without the opportunity for errors to be 
introduced to the figures.Then I use some pre-approved software which reads the 
spreadsheet and uploads the data to HMRC. Is there some way to transfer a 
balance from an account to an Excel spreadsheet?
___
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] Request for Comments: A simple, mobile-friendly webinterface for GnuCash

[Joshua]

Good evening everybody,

I recently built a simple web interface for GnuCash and wish to share
it with you, in the hopes of receiving feedback and thougths and that it
might be useful to others:

GitHub: https://github.com/joshuabach/gnucash-web

Demo: https://gnucash-web-demo.bachmeier.cc

I have managed all my personal finances in GnuCash for several years,
including the cash I carry with me. Being able to record expenses or
other transactions from my phone is therefore a major usecase to me and
I imagine to many others as well.

Most existing solutions are based around exporting on mobile & importing
in the desktop app, which doesn't really satisfy me. There has been some
activity on this topic here before, e.g. in 2012 James posted about his
project "gnucash-django" [1], but I don't think much came of it (I found a
few other things, check out the "Related Work" section in my README on
GitHub if you are interested).

Anyway, back to my project: I got the Idea to do this when I discoverd
piecash [2] and quickly hacked together an MVP. After some month of
using, patching and extending it I must say I am quiet happy with the
result. One can browse accounts, view, add and edit transactions, and
the like (see the README for a better feature list with screenshots).

The setup is to use one of the database backends instead of the XML
backend and hook the app up to that. I have the app running on a server
(with MariaDB) and use an SSH tunnel to access the database directly with the
desktop app.

Whats important to me is that this stays absolutely simple. I don't want
to replace the desktop app in any way (not that I could). GnuCash Web is
intended as a "companion" app to record (and mayby fix) simple
transactions [3] on the go, because I usually forget them until I get home.

Another neat feature is a simple CLI that can be used to get new price
quotes for all custom securities and currencies in the database. Using
e.g. a cronjob, the price history for my commodities always stays up to
date even if I don't open GnuCash for a while.

Ì've been using my app personally for just over a year now and find it
great. I can no longer imagine using GnuCash for my day-to-day finances
without it and will probably be using (and therefore maintain it) for
many years to come.

Alright, thanks for reading to this point. Please do try out the demo,
look at the repo or even set it up yourself. If you have any thougths,
suggestions or feedback, please tell me. I'm thankful for any
response. I'd be happy to engage in a discussion about this.

Best regards,
Joshua

[1]: https://github.com/sdementen/piecash
[2]: https://lists.gnucash.org/pipermail/gnucash-user/2012-March/043762.html
[3]: With "simple" transaction I mean only two splits

--
J.
___
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] [GNC-dev] GnuCash 4.900 Released

[David H]

Hi Bob,

Yes, I've just done that with the same result.  Reverted to 4.13 and a
saved version of my Reports - that was all good with Report configs and
Finance Quote all looking good.  Reinstalled the nightly version as you
suggested but the results are just the same - doesn't seem to find my last
file opened, still displays the function name only. Reports have lost their
saved configs and some have reverted to selecting every account.  Checked
"File About" and the file locations are identical between both versions. It
almost sounds like a permissions error - i.e. can't read configs but that's
a bit strange as when I updated one of my saved report configs it created
a saved-reports-2.8-Backup in C:\Users\halvey\AppData\Roaming\GnuCash.

Will wait for an updated version :-)

Thanks David H.


On Thu, 12 Jan 2023 at 21:10, Robert Fewell <14ubo...@gmail.com> wrote:

> I am not sure but it looks like the gnucash-4.900.setup.exe is not
> complete, the file size is 137M compared to the latest master at 157M and
> 4.13 is 146M.
>
> I downloaded and installed the gnucash-4.900.setup.exe from code and got
> the same startup error that David reported.
> Will need to look at the file list error and check what it does when the
> list is empty.
>
> Reinstalled 4.13 and all seemed OK again.
> Downloaded the latest master gnucash-4.900-2023-01-12-git. and
> installed that and Gnucash opened successfully.
>
> David, if you have time try downloading the one I used from the nightlies
> at https://code.gnucash.org/builds/win32/master
>
> Regards,
> Bob
>
> On Thu, 12 Jan 2023 at 07:50, Frank H. Ellenberger <
> frank.h.ellenber...@gmail.com> wrote:
>
> > Hi Fred,
> >
> > Am 12.01.23 um 07:16 schrieb Fred Tydeman:
> > > Since I do not know where it will put that data, nor how to override, I
> > > declined.
> >
> > with the option --user it seems to install in my case below
> > /home/frank/.local/share/flatpak/runtime/
> >
> > HTH
> > Frank
> > ___
> > gnucash-devel mailing list
> > gnucash-de...@gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-devel
> >
> ___
> gnucash-devel mailing list
> gnucash-de...@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>
___
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] Recommended Method of Entry for IRA Distributions

[Michael or Penny Novack]

On 1/12/2023 12:41 PM, R Losey wrote:

Thanks; I know the information is out there, but intuitively, it doesn't
make sense to me that depositing funds to my bank account is a "debit"
transaction to the bank. It comes from the concept of credit being "added
to" and debit being "substracted from", I suppose.

Is the "Debit on the left" and "Credit on the right" true in general
accounting, or just GnuCash?


a) Double entry bookkeeping goes back a long way, long enough that Latin 
still in use for communications among the educated in Europe. Think of 
"debit" and "credit" not in terms of plus and minus (before European 
math had negative numbers) but as "he owes"(me) and "he trusts" (me). In 
other words  he owes me that amount and he trusts me for that amount (I 
owe him)


   Now look again at the bank account.In YOUR books a debit (the bank 
owes you this money) and in the bank's book a credit (the bank owes you 
this money)


b) Debit on the left and credit on the right. In the old days ledger 
pages had two sides, one side for the debits and the other for the 
credits (and no balance column). Perhaps within my lifetime it became 
more common to use three column paper with debit and credit transactions 
with one date, check number, description, and journal reference column 
then a left for debit, a right (middle) for credit, and a balance. o a 
running balance was kept << finding the balance was a process in the old 
days before that >>


NOTICE -- so far pen and ink on paper, and gnucash is simply modelling that

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] Recommended Method of Entry for IRA Distributions

[Stan Brown]

On 2023-01-11 19:52, Milton Stern wrote:

> ** New for 2023. IRS requires the brokerage to withhold taxes from IRA
> Distributions. Last year you could specify 0% withholding.
> ** They don't make it so easy this year. It is sort of a double hit.
> Even if you get it back as a tax refund, you can't put it back (Rollover)
> into the IRA to earn tax free.

Are you having this distribution delivered outside the US? If not, where
did you get your information?

In these matters it's usually best to go back to the source. First, see

Quoting from the second paragraph,
"Generally, payees ... can choose not to have withholding apply to their
pensions or annuities (however, refer to Mandatory Withholding on
Payments to be Delivered Outside the United States below). The election
remains in effect until the payee revokes it. The payer must notify the
payee that this election is available."

If your broker is telling you that withholding is mandatory, they are
telling you an untruth--again, assuming you are a citizen or a resident
alien, and the money is not being delivered to a foreign country.

The first sentence of the fourth paragraph: "Payees of periodic payments
can give payers a Form W-4P in order to make or change a withholding
election, or elect not to have withholding apply, for their periodic
payments."

Form W-4P for 2023 is at 
A quote from the instructions on page 2:

"Choosing not to have income tax withheld. You can choose
not to have federal income tax withheld from your payments by
writing “No Withholding” on Form W-4P in the space below
Step 4(c). ... Generally, if you are a U.S. citizen or a resident alien,
you are not permitted to elect not to have federal income tax withheld
on payments to be delivered outside the United States and its territories."

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

Re: [GNC] Recommended Method of Entry for IRA Distributions

[Stan Brown]

On 2023-01-12 09:41, R Losey wrote:
> Thanks; I know the information is out there, but intuitively, it doesn't
> make sense to me that depositing funds to my bank account is a "debit"
> transaction to the bank. It comes from the concept of credit being "added
> to" and debit being "substracted from", I suppose.

That principle is correct as far as it goes, but you are trying to
stretch it too far.

For liabilities, equity, and income, credits do indeed increase the
balance and and debits decrease it.

But it is exactly the opposite for assets and expenses: credits _reduce_
them and debits increase them.

Here's how to remember it: if somebody gives you $50, you have income,
which we all agree is a credit to your income account. But you have also
increased your cash account by $50. But ... debits and credits in a
transaction must balance, so that increase to cash must be a debit to
balance the credit to your income account.

> Is the "Debit on the left" and "Credit on the right" true in general
> accounting, or just GnuCash?

That's general. When Ernst & Ernst (as it then was) gave me a crash
course in accounting, the instructor said that "debit" and "credit" are
best thought of as meaning, respectively, simply "left" and "right".

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

Re: [GNC] Recommended Method of Entry for IRA Distributions

[Adrien Monteleone]

It is intuitive, but your issue is one of perspective:

From *your* perspective, your bank account is your asset.

You increase it *in your books* by a Debit.

But from the *bank's* perspective, your account with them is their 
liability, and is increased by a Credit.


That is why when you put money in your account, or they refund or 
correct in your favor, they Credit your account. Because their liability 
to YOU is increasing.


But YOU would enter a Debit in your books.

Perfectly intuitive, just opposite sides of the equation.

The left-right/debit-credit is for all of accounting, not just GnuCash.

Regards,
Adrien

On 1/12/23 11:41 AM, R Losey wrote:

Thanks; I know the information is out there, but intuitively, it doesn't
make sense to me that depositing funds to my bank account is a "debit"
transaction to the bank. It comes from the concept of credit being "added
to" and debit being "substracted from", I suppose.

Is the "Debit on the left" and "Credit on the right" true in general
accounting, or just GnuCash?

I've played with the toggling, but I like the informal names; it is much
more intuitive, and I don't see a need to potentially confuse myself.


___
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] Sort order not being maintained

[Adrien Monteleone]

Please don't forget to 'reply-all' or 'reply-list' to keep the 
discussion on the list.


--

By *per account* I don't mean per book, I mean *per account*.

That is, if you sort your checking account register one way, you can 
sort your credit card another. The sort order can be customized for each 
and every account in your book.


If you sorted one register as Reversed, then opened a different 
register, it wouldn't necessarily be Reversed unless you had already set 
and saved it that way.


-

Anyway, if you notice it change back, try to see if you can remember 
what you did differently.


If there really is a bug, being able to reliably reproduce will help 
tremendously.


Regards,
Adrien

On 1/12/23 11:16 AM, Dr. David Kirkby wrote:
I've only got one sets of company accounts I am dealing with - not personal accounts, or some other set of accounts. I would like a pound (or better still pint of beer) for every time I have sorted the bank account as given in my original post.  (Date, Reversed Save). The software seems to randomly change the sort order to "Standard Order", whatever that might be. I just opened GnuCash for the first time today, and the order was right, but I doubt it will remain that way for long. Sooner or later I expect it will change the order. 


Dave



___
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] Recommended Method of Entry for IRA Distributions

[R Losey]

I'll try interspersing... using RL>>>



On Wed, Jan 11, 2023 at 9:52 PM Milton Stern  wrote:

> Hi,
>
> Please see below 
>
> Moshe
>
> On Wed, Jan 11, 2023 at 7:06 PM R Losey  wrote:
>
>> Hello.
>>
>> Assuming you take out $5,000 and they withhold 10% ($500), I would use a
>> split transaction... sell $5000 worth of the mutual fund, add $4500 to your
>> bank account, and $500 to federal income tax paid.
>>
>
>> I apologize for not using "debit" and "credit" terms, but I'm not sure
>> I'd get them right.
>>
>
>  Agreed. The component that I am having trouble with is the
> Pre-Tax IRA Distribution component. Because it is a Pre-Tax IRA, the
> distribution is taxable as income.
> The direct "sell $5000 worth of the mutual fund, add $4500 to your
> bank account" direct transaction will not show up in Income Reports.
>

RL>>> In my brokerage account, I actually "sell" the stock and put it in
the parent account, using the "IRA income category", and then I do a second
transfer from the brokerage account to my bank.  Example:

Brokerage account (the parent holding account)
  Sweep Fund
  Holding 1
  Holding 2




>
>
>>
>> You can track them however you wish, but the above is how I would do
>> them... well, except, I never have the mutual fund withhold taxes; I pay my
>> own taxes quarterly.
>>
>
> ** New for 2023. IRS requires the brokerage to withhold taxes from IRA
> Distributions. Last year you could specify 0% withholding.
> ** They don't make it so easy this year. It is sort of a double hit.
> Even if you get it back as a tax refund, you can't put it back (Rollover)
> into the IRA to earn tax free.
>
RL>>> That's TERRIBLE!  Gr. I wonder what the minimum one can withhold
is?



>
>
>>
>>
>> On Wed, Jan 11, 2023 at 4:35 PM Milton Stern  wrote:
>>
>>> Hi,
>>>
>>> What would be the recommended method of Entry for an IRA Distribution?
>>>
>>> The Distribution is for a personal IRA (not Roth).
>>> The IRA is of Mutual Funds.
>>>
>>> The Mutual Fund is in Assets > Investments - Retirement > Brokerage >
>>> etc.
>>> > etc.
>>>
>>> Since this is taxable income, I need to track withholding (Federal) + Net
>>> Distribution to a Checking Account (Assets > Current Assets).
>>> No Commission fees are applicable, but it would be nice to know where/how
>>> they would be tracked.
>>>
>>> Thank you in advance,
>>>
>>> Moshe
>>> ___
>>> 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
>>
>

-- 
_
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] Recommended Method of Entry for IRA Distributions

[R Losey]

Thanks; I know the information is out there, but intuitively, it doesn't
make sense to me that depositing funds to my bank account is a "debit"
transaction to the bank. It comes from the concept of credit being "added
to" and debit being "substracted from", I suppose.

Is the "Debit on the left" and "Credit on the right" true in general
accounting, or just GnuCash?

I've played with the toggling, but I like the informal names; it is much
more intuitive, and I don't see a need to potentially confuse myself.


On Wed, Jan 11, 2023 at 6:34 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> For completeness and posterity, that would be:
>
> Dr. Assets:Bank
> Dr. Expenses:Tax
>Cr. Assets:Fund
>
> If you're ever unsure as to what the 'formal' column labels would be,
> you can always toggle Preferences > Accounts > Labels > Use formal
> accounting labels while viewing a register in question. They toggle in
> the view as you toggle the preference. (you don't need to commit the
> preference first.)
>
> Another easy to remember tip:
>
> Debit is ALWAYS on the left
> Credit is ALWAYS on the right
>
> This coincides with the Accounting Equation:
>
> Assets = Liabilities + Equity
>
> and the expanded version:
>
> Assets + Expenses = Liabilities + Retained Earnings + Income
>
> Assets & Expenses (on the left of the '=') are increased via Debits
> (left column)
>
> Liabilities, Retained Earnings (Equity), & Income (on the right of the
> '=') are increased via Credits (right column)
>
> Because:
>
> Debits = Credits
>
> Hope that helps!
>
> Regards,
> Adrien
>
> On 1/11/23 6:05 PM, R Losey wrote:
> > I apologize for not using "debit" and "credit" terms, but I'm not sure
> I'd
> > get them right.
>
> ___
> 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] Why is this entry "in and out"

[Murugan Muruganandam]

Mahon

i have attached a typical interest entry transaction for savings account as an 
image.




Saludos Cordiales


Murugan


From: David Carlson 
Sent: Thursday, January 12, 2023 1:36 PM
To: Joseph St. Denis 
Cc: Murugan Muruganandam ; Mahon Finbar 
; Gnucash Users 
Subject: Re: [GNC] Why is this entry "in and out"

If you change your register view to two lines, it is easier to see what's going 
on.

On Thu, Jan 12, 2023, 9:02 AM Joseph St. Denis via gnucash-user 
mailto:gnucash-user@gnucash.org>> wrote:
Hello Murugan

On the ribbon locate the spilt icon and press it you should be able to see if 
the spilt is to different locations one should be the account name and the 
other should be interest. If they are the same you get two entries a add and 
subtraction to the same account.

I hope this helps you.

Joseph St Denis

Get Outlook for Android

From: gnucash-user 
mailto:yahoo@gnucash.org>>
 on behalf of Murugan Muruganandam 
mailto:m.muruganan...@hotmail.com>>
Sent: Thursday, January 12, 2023 9:49:03 AM
To: Mahon Finbar mailto:mahon.fin...@neuf.fr>>
Cc: Gnucash Users mailto:gnucash-user@gnucash.org>>
Subject: Re: [GNC] Why is this entry "in and out"

Hi Mahon

You need to give more details of the entry, possibly a screen shot as it is not 
clear

When entering interest in the account create a new transaction with transfer 
account as income:interest


Regard

Murugan


> On 12-01-2023, at 11:28, Mahon Finbar 
> mailto:mahon.fin...@neuf.fr>> wrote:
>
> Hi,
>
> I have an account for a savings a/c and I want to add the latest interest 
> entry. However, when I click the entry title it open with the balance, but 
> when I add the interest it fills in the amount as an addition and then a 
> subtraction and the balance doesn't change
>
> Have a the wrong a/c type?In the transfer column it is headed Equity:Opening 
> Balances
>
> Thanks, Finbar
>
> ___
> 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] Why is this entry "in and out"

[David Carlson]

If you change your register view to two lines, it is easier to see what's
going on.

On Thu, Jan 12, 2023, 9:02 AM Joseph St. Denis via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Hello Murugan
>
> On the ribbon locate the spilt icon and press it you should be able to see
> if the spilt is to different locations one should be the account name and
> the other should be interest. If they are the same you get two entries a
> add and subtraction to the same account.
>
> I hope this helps you.
>
> Joseph St Denis
>
> Get Outlook for Android
> 
> From: gnucash-user 
> on behalf of Murugan Muruganandam 
> Sent: Thursday, January 12, 2023 9:49:03 AM
> To: Mahon Finbar 
> Cc: Gnucash Users 
> Subject: Re: [GNC] Why is this entry "in and out"
>
> Hi Mahon
>
> You need to give more details of the entry, possibly a screen shot as it
> is not clear
>
> When entering interest in the account create a new transaction with
> transfer account as income:interest
>
>
> Regard
>
> Murugan
>
>
> > On 12-01-2023, at 11:28, Mahon Finbar  wrote:
> >
> > Hi,
> >
> > I have an account for a savings a/c and I want to add the latest
> interest entry. However, when I click the entry title it open with the
> balance, but when I add the interest it fills in the amount as an addition
> and then a subtraction and the balance doesn't change
> >
> > Have a the wrong a/c type?In the transfer column it is headed
> Equity:Opening Balances
> >
> > Thanks, Finbar
> >
> > ___
> > 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] Recommended Method of Entry for IRA Distributions

[Michael or Penny Novack]

Not being qualified as a CPA, I am loathe to advise on accounting 
matters (as opposed to how to do it using gnucash rather than pen and 
ink on paper)


But THIS previous response should go a long way toward setting you on 
the right track because it discusses the EXACT reverse problem (when the 
contribution was made) and once you consider that, how to handle the 
distribution should make sense. Personally I am not keeping our 401k ON 
the books, but if I had chosen that option (for 401k/IRA accounts) this 
is what I would have done.


I would remember that accounts of type income are really temporary 
accounts of type equity. I would use that, putting an account for 
"deferred income" under equity. It would be this I would use as the 
credit side when making a contribution. I will ignore the added 
complexity of payroll deduction and assume you are putting money in form 
the bank account. So the obvious part is debit IRA and credit bank 
account but ALSO debit income and credit "deferred income". And if I am 
marking a 401k/IRA account to market each year, debit IRA and credit 
"deferred income" << note that such increase is not an unrealized 
capital gain when in an income deferral account >>


Then later when taking a distribution, debit cash and credit the IRA for 
that amount but ALSO debit deferred income and credit income (you have 
undeferred that much)


But that's just how I would do it, not advice.

Michael D Novack

PS --- If you had an existing IRA account when you started with gnucash 
and used the wizard to enter with a balance (the credit going to the 
opening balance in equity) and yo decide to use a "deferred income" 
account as described above, you can fix that by creating the account and 
transferring from starting balance.




On 1/12/2023 1:25 AM, David T. via gnucash-user wrote:

Moshe,

This issue has come up many times over the years, for the very reason you 
raised: a direct transfer from the IRA asset account to your Checking at 
account won't show as income in reports.

The best way I've seen for how to handle this requires that your initial pay records 
isolate the income you diverted to the IRA account. Technically, the income you sent to 
the IRA is separate, and should be categorized as "deferred income."

In my books, that's meant that my paycheck entries have separate lines for the 
income that was sent to the IRA. So if I have a paycheck for $1,000, and send 
$50 to the IRA, the entry was:

Income:W2 $950 -> Checking
Income:IRA   $50 -> IRA Asset

(Note that this will match your W-2 at the time)

When you take the distribution, you create one transaction for the transfer 
from the IRA to Checking, but then you create an extra transaction (or extra 
splits, if you prefer), which transfers the distribution amount from Income:IRA 
to Income:Retirement Distributions. This second account should be assigned as a 
taxable account. Then it will appear on the TXf report. You can also select 
just that account on income statements.

⁣David T. ​

On Jan 12, 2023, 6:53 AM, at 6:53 AM, Milton Stern  wrote:

Hi,

Please see below 

Moshe

On Wed, Jan 11, 2023 at 7:06 PM R Losey  wrote:


Hello.

Assuming you take out $5,000 and they withhold 10% ($500), I would

use a

split transaction... sell $5000 worth of the mutual fund, add $4500

to your

bank account, and $500 to federal income tax paid.

I apologize for not using "debit" and "credit" terms, but I'm not

sure I'd

get them right.


 Agreed. The component that I am having trouble with is the
Pre-Tax
IRA Distribution component. Because it is a Pre-Tax IRA, the
distribution
is taxable as income.
The direct "sell $5000 worth of the mutual fund, add $4500 to
your
bank account" direct transaction will not show up in Income Reports.



You can track them however you wish, but the above is how I would do
them... well, except, I never have the mutual fund withhold taxes; I

pay my

own taxes quarterly.


** New for 2023. IRS requires the brokerage to withhold taxes from
IRA
Distributions. Last year you could specify 0% withholding.
** They don't make it so easy this year. It is sort of a double
hit.
Even if you get it back as a tax refund, you can't put it back
(Rollover)
into the IRA to earn tax free.




On Wed, Jan 11, 2023 at 4:35 PM Milton Stern 

wrote:

Hi,

What would be the recommended method of Entry for an IRA

Distribution?

The Distribution is for a personal IRA (not Roth).
The IRA is of Mutual Funds.

The Mutual Fund is in Assets > Investments - Retirement > Brokerage

etc.

etc.

Since this is taxable income, I need to track withholding (Federal)

+ Net

Distribution to a Checking Account (Assets > Current Assets).
No Commission fees are applicable, but it would be nice to know

where/how

they would be tracked.

Thank you in advance,

Moshe
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to 

Re: [GNC] GnuCash 4.900 Released

[Joseph Vernice]

Thank you for the clarification.

On Wed, Jan 11, 2023 at 4:14 PM Steve Butler  wrote:

> This is an experimental pre-5.0 release.  4.13 is for everyday use until
> 5.0 comes out.
>
> On Wed, Jan 11, 2023, 13:11  wrote:
>
>> I see many references to GnuCash 4.900, but the website only has version
>> 4.13 (Windows).  Am I missing something here?
>>
>> Thank you 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] Why is this entry "in and out"

[Joseph St. Denis via gnucash-user]

Hello Murugan

On the ribbon locate the spilt icon and press it you should be able to see if 
the spilt is to different locations one should be the account name and the 
other should be interest. If they are the same you get two entries a add and 
subtraction to the same account.

I hope this helps you.

Joseph St Denis

Get Outlook for Android

From: gnucash-user  on 
behalf of Murugan Muruganandam 
Sent: Thursday, January 12, 2023 9:49:03 AM
To: Mahon Finbar 
Cc: Gnucash Users 
Subject: Re: [GNC] Why is this entry "in and out"

Hi Mahon

You need to give more details of the entry, possibly a screen shot as it is not 
clear

When entering interest in the account create a new transaction with transfer 
account as income:interest


Regard

Murugan


> On 12-01-2023, at 11:28, Mahon Finbar  wrote:
>
> Hi,
>
> I have an account for a savings a/c and I want to add the latest interest 
> entry. However, when I click the entry title it open with the balance, but 
> when I add the interest it fills in the amount as an addition and then a 
> subtraction and the balance doesn't change
>
> Have a the wrong a/c type?In the transfer column it is headed Equity:Opening 
> Balances
>
> Thanks, Finbar
>
> ___
> 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] Why is this entry "in and out"

[Murugan Muruganandam]

Hi Mahon

You need to give more details of the entry, possibly a screen shot as it is not 
clear 

When entering interest in the account create a new transaction with transfer 
account as income:interest


Regard

Murugan


> On 12-01-2023, at 11:28, Mahon Finbar  wrote:
> 
> Hi,
> 
> I have an account for a savings a/c and I want to add the latest interest 
> entry. However, when I click the entry title it open with the balance, but 
> when I add the interest it fills in the amount as an addition and then a 
> subtraction and the balance doesn't change
> 
> Have a the wrong a/c type?In the transfer column it is headed Equity:Opening 
> Balances
> 
> Thanks, Finbar
> 
> ___
> 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] Why is this entry "in and out"

[Adrien Monteleone]

I'm not following exactly, but I'm guessing this is Interest paid to you?

If so, the entry should be:

Dr. Savings
  Cr. Income

Just change the Opening Balances account to a relevant Income account.

Regards,
Adrien

On 1/12/23 8:27 AM, Mahon Finbar wrote:

Hi,

I have an account for a savings a/c and I want to add the latest 
interest entry. However, when I click the entry title it open with the 
balance, but when I add the interest it fills in the amount as an 
addition and then a subtraction and the balance doesn't change


Have a the wrong a/c type?In the transfer column it is headed 
Equity:Opening Balances


___
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] Why is this entry "in and out"

[Mahon Finbar]

Hi,

I have an account for a savings a/c and I want to add the latest 
interest entry. However, when I click the entry title it open with the 
balance, but when I add the interest it fills in the amount as an 
addition and then a subtraction and the balance doesn't change


Have a the wrong a/c type?In the transfer column it is headed 
Equity:Opening Balances


Thanks, Finbar

___
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] Sort order not being maintained

[Adrien Monteleone]

On a whim I just exited and restarted GnuCash and it did retain the 
'standard' sort order I last set. (just as it did the first time I 
tested it)


I'll chalk up the reversion to the crash.

Note, that sort order is *per account*.

Regards,
Adrien

On 1/12/23 2:37 AM, Dr. David Kirkby wrote:

Il am losing the sort order even if the program doesn’t crash. I should
have replied earlier to state I was still getting the problem in 4.13.

I did look at the release notes in 4.13 and didn’t see any significant
differences to 4.12, so that’s why I didn’t bother upgrading until you
suggested that I did so. Initially I thought the upgrade had solved the
problem, but it hasn’t.


___
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] Sort order not being maintained

[Adrien Monteleone]

Reasonable enough. It was a crash after all.

Regards,
Adrien

On 1/11/23 11:13 PM, David Carlson wrote:

I think that register sort order, register window size/column widths,
memorized reports, open report window details and memorized CSV import
settings all only get saved when doing a manual program Quit, but not when
dining a File Save or when the program crashes.


___
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] Sort order not being maintained

[David Carlson]

Be very careful with sort order in release 4.13.  I have a problem with a
nightly build made on Jan 7 where it is not possible to correctly restore
the sort back to the standard order after making a change.  I am not sure
if that issue started after 4.13 was released.  Luckily  it was on a test
file so I didn't need to go to a backup to recover.

On Thu, Jan 12, 2023 at 2:38 AM Dr. David Kirkby <
drkir...@kirkbymicrowave.co.uk> wrote:

> On Thu, 12 Jan 2023 at 04:27, Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
>
> > Oddly, after an unrelated crash, upon restarting GnuCash, the sort order
> > was back to what I had tested, rather than what I had last used. I had
> > to change the order again with the 'save'  .
>
>
> (so far)
> >
> > I suppose I shouldn't expect such prefs to persist after a crash...
> >
> > Regards,
> > Adrien
>
>
>
> Il am losing the sort order even if the program doesn’t crash. I should
> have replied earlier to state I was still getting the problem in 4.13.
>
> I did look at the release notes in 4.13 and didn’t see any significant
> differences to 4.12, so that’s why I didn’t bother upgrading until you
> suggested that I did so. Initially I thought the upgrade had solved the
> problem, but it hasn’t.
>
> Dave
> --
> Dr. David Kirkby,
> Kirkby Microwave Ltd,
> drkir...@kirkbymicrowave.co.uk
> https://www.kirkbymicrowave.co.uk/
> Telephone 01621-680100./ +44 1621 680100
>
> Registered in England & Wales, company number 08914892.
> Registered office:
> Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United
> Kingdom
> ___
> 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] Sort order not being maintained

[Dr. David Kirkby]

On Thu, 12 Jan 2023 at 04:27, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Oddly, after an unrelated crash, upon restarting GnuCash, the sort order
> was back to what I had tested, rather than what I had last used. I had
> to change the order again with the 'save'  .


(so far)
>
> I suppose I shouldn't expect such prefs to persist after a crash...
>
> Regards,
> Adrien



Il am losing the sort order even if the program doesn’t crash. I should
have replied earlier to state I was still getting the problem in 4.13.

I did look at the release notes in 4.13 and didn’t see any significant
differences to 4.12, so that’s why I didn’t bother upgrading until you
suggested that I did so. Initially I thought the upgrade had solved the
problem, but it hasn’t.

Dave
-- 
Dr. David Kirkby,
Kirkby Microwave Ltd,
drkir...@kirkbymicrowave.co.uk
https://www.kirkbymicrowave.co.uk/
Telephone 01621-680100./ +44 1621 680100

Registered in England & Wales, company number 08914892.
Registered office:
Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United
Kingdom
___
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.