Re: [GNC] Equity Account "problem"
The calculation of Equity is automatic and built into double entry accounting system. This is the purpose to a large extent of the two or more entries (referred to as splits in GnuCash documentation) associated with a single transaction. Income and Expenses are Equity accounts that are split off from equity with the primary purpose of measuring the short term loss or gain over a specific period and you will notice if you look through the examples in the GnuCash Help Manual and Tutorial Guide that most transactions involve one split to an asset or liability account and another to either an Income or Expense account except where the transaction is regarded as a capital purchase which will produce income over more than a single accounting period (usually annually but can be semi annually or monthly). It can be circumvented by not following the recommended procedures. First you need to understand the double entry accounting system basics and then GnuCash's implementation of it.There are on line resources on double entry if the introduction in the gude and help manual is too brief for your needs. David Cousens On Tue, 2023-07-11 at 18:48 -0400, Default User wrote: > Hi! > > Is there a way to have Gnucash 4.13 (Debian GNU/Linux 12 Bookworm) > automatically calculate, and update "Equity" in the main accounts tab, > to show the "real" value of total Equity, after any action (or at least > transaction) that would affect "real" equity? > > Example: > Start with the GnuCash "Common Accounts", as in gcashdata_1.gnucash > from the Tutorial and Concepts Guide, with all accounts set to $0.00. > > Now make a transaction so that Equity:Opening Balances starts with > $10.00, and Assets:Current Assets:Cash in Wallet starts with $10.00. > At this point, Equity = $10.00. All good so far. > > But now, enter a transaction such as Expenses:Auto:Fuel (increase by > $5.00), paid by transfer from Assets:Cash in Wallet (decrease by > $5.00). > > So now: > Assets = $5.00 > Liabilities = $0.00 > Equity = $10.00 > > So . . . if Assets - Liabilities = Equity, then > $5.00 - $0.00 = $10.00? > > Thus, Equity does not seem to include the $5.00 Expense transaction. > [Note: of course, the Balance Sheet in Reports does correctly show > Equity as $5.00.] > > I assume that GnuCash has always been this way, from the beginning, and > is not likely to change now! > > But is there a viable "workaround"? I am pretty sure I understand what > is going on, and maybe why it was done that way (so that the account > ledger tabs show legitimate transactions" only?) > > But it does bother my sense of "correctness". > > [Note: I did see somewhere online a link to a web page that may have at > one time shown the desired solution, but the web page has since been > 404'd.] > > : ( > > > > > ___ > 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] Equity Account "problem"
On Tue, 2023-07-11 at 16:00 -0700, Dean Gibson wrote: > There is no work-around because you do not understand the *BASICS *of > accounting. I would suggest a good book (there are many). > > On 2023-07-11 15:48, Default User wrote: > > Hi! > > > > Is there a way to have Gnucash 4.13 (Debian GNU/Linux 12 Bookworm) > > automatically calculate, and update "Equity" in the main accounts > > tab, > > to show the "real" value of total Equity, after any action (or at > > least > > transaction) that would affect "real" equity? > > > > Example: > > Start with the GnuCash "Common Accounts", as in gcashdata_1.gnucash > > from the Tutorial and Concepts Guide, with all accounts set to > > $0.00. > > > > Now make a transaction so that Equity:Opening Balances starts with > > $10.00, and Assets:Current Assets:Cash in Wallet starts with > > $10.00. > > At this point, Equity = $10.00. All good so far. > > > > But now, enter a transaction such as Expenses:Auto:Fuel (increase > > by > > $5.00), paid by transfer from Assets:Cash in Wallet (decrease by > > $5.00). > > > > So now: > > Assets = $5.00 > > Liabilities = $0.00 > > Equity = $10.00 > > > > So . . . if Assets - Liabilities = Equity, then > > $5.00 - $0.00 = $10.00? > > > > Thus, Equity does not seem to include the $5.00 Expense > > transaction. > > [Note: of course, the Balance Sheet in Reports does correctly show > > Equity as $5.00.] > > > > I assume that GnuCash has always been this way, from the beginning, > > and > > is not likely to change now! > > > > But is there a viable "workaround"? I am pretty sure I understand > > what > > is going on, and maybe why it was done that way (so that the > > account > > ledger tabs show legitimate transactions" only?) > > > > But it does bother my sense of "correctness". > > > > [Note: I did see somewhere online a link to a web page that may > > have at > > one time shown the desired solution, but the web page has since > > been > > 404'd.] > > > > : ( > > > > > > > > > > ___ > > 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. Ouch! Sorry . . . : ) ___ 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] Equity Account "problem"
Stan Brown Tehachapi, CA, USA https://BrownMath.com On 2023-07-11 15:48, Default User wrote: > Is there a way to have Gnucash 4.13 (Debian GNU/Linux 12 Bookworm) > automatically calculate, and update "Equity" in the main accounts tab, > to show the "real" value of total Equity, after any action (or at least > transaction) that would affect "real" equity? Not in Accounts -- Equity accounts get updated only if you enter transactions to do that, or if you close the books. But see below for a different approach that will give you what you want. > But now, enter a transaction such as Expenses:Auto:Fuel (increase by > $5.00), paid by transfer from Assets:Cash in Wallet (decrease by > $5.00). > > So now: > Assets = $5.00 > Liabilities = $0.00 > Equity = $10.00 > > So . . . if Assets - Liabilities = Equity, then Not quite. Assets - Liabilities = Equity + (Income - Expenses) In your example, $5 - $0 = $10 + ($0 - $5) It's not instantaneous, but an easy way to get very close to what you want is to run a balance sheet report. That shows assets, liabilities, and equity, but a generated item "Retained Earnings" under equity that equals total income minus total expenses. This gives you the sort of balance you're looking for. ___ 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] Equity Account "problem"
There is no work-around because you do not understand the *BASICS *of accounting. I would suggest a good book (there are many). On 2023-07-11 15:48, Default User wrote: Hi! Is there a way to have Gnucash 4.13 (Debian GNU/Linux 12 Bookworm) automatically calculate, and update "Equity" in the main accounts tab, to show the "real" value of total Equity, after any action (or at least transaction) that would affect "real" equity? Example: Start with the GnuCash "Common Accounts", as in gcashdata_1.gnucash from the Tutorial and Concepts Guide, with all accounts set to $0.00. Now make a transaction so that Equity:Opening Balances starts with $10.00, and Assets:Current Assets:Cash in Wallet starts with $10.00. At this point, Equity = $10.00. All good so far. But now, enter a transaction such as Expenses:Auto:Fuel (increase by $5.00), paid by transfer from Assets:Cash in Wallet (decrease by $5.00). So now: Assets = $5.00 Liabilities = $0.00 Equity = $10.00 So . . . if Assets - Liabilities = Equity, then $5.00 - $0.00 = $10.00? Thus, Equity does not seem to include the $5.00 Expense transaction. [Note: of course, the Balance Sheet in Reports does correctly show Equity as $5.00.] I assume that GnuCash has always been this way, from the beginning, and is not likely to change now! But is there a viable "workaround"? I am pretty sure I understand what is going on, and maybe why it was done that way (so that the account ledger tabs show legitimate transactions" only?) But it does bother my sense of "correctness". [Note: I did see somewhere online a link to a web page that may have at one time shown the desired solution, but the web page has since been 404'd.] : ( ___ 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] Equity Account "problem"
Hi! Is there a way to have Gnucash 4.13 (Debian GNU/Linux 12 Bookworm) automatically calculate, and update "Equity" in the main accounts tab, to show the "real" value of total Equity, after any action (or at least transaction) that would affect "real" equity? Example: Start with the GnuCash "Common Accounts", as in gcashdata_1.gnucash from the Tutorial and Concepts Guide, with all accounts set to $0.00. Now make a transaction so that Equity:Opening Balances starts with $10.00, and Assets:Current Assets:Cash in Wallet starts with $10.00. At this point, Equity = $10.00. All good so far. But now, enter a transaction such as Expenses:Auto:Fuel (increase by $5.00), paid by transfer from Assets:Cash in Wallet (decrease by $5.00). So now: Assets = $5.00 Liabilities = $0.00 Equity = $10.00 So . . . if Assets - Liabilities = Equity, then $5.00 - $0.00 = $10.00? Thus, Equity does not seem to include the $5.00 Expense transaction. [Note: of course, the Balance Sheet in Reports does correctly show Equity as $5.00.] I assume that GnuCash has always been this way, from the beginning, and is not likely to change now! But is there a viable "workaround"? I am pretty sure I understand what is going on, and maybe why it was done that way (so that the account ledger tabs show legitimate transactions" only?) But it does bother my sense of "correctness". [Note: I did see somewhere online a link to a web page that may have at one time shown the desired solution, but the web page has since been 404'd.] : ( ___ 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] Finance::Quote terminal commands not working with Flatpack v:5.3 install
Hi Doug, For the flatpak edition of gnucash the command to fetch quotes is slightly more complex: flatpak run --command=gnucash-cli org.gnucash.GnuCash -quotes dump This boils down to the following components: - flatpak run org.gnucash.GnuCash => indicate you want to execute a command in the org.gnucash.GnuCash sandbox without any further options, this will run the default command in that sandbox, which is "gnucash" - --command=gnucash-cli => indicate you don't want to run the default command, but gnucash-cli instead - -quotes dump => the arguments to pass to the command to run Regards, Geert Op dinsdag 11 juli 2023 16:13:37 CEST schreef doug brown via gnucash-user: > I installed via flatpack Gnucash v. 5.3 on Linux Mint v. 20 OS and the > terminal commands that I previously used to find sources for quotes on > longer work. Here is the output: doug@sager:~$ gnucash-cli --quotes dump > yahoo_json QCBMPXgnucash-cli: command not found doug@sager:~$ gnc-fq-dump > -v yahoo_json QCBMPXCommand 'gnc-fq-dump' not found, but can be installed > with:sudo apt install gnucash Any thoughts? > > > > ___ > 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] Finance::Quote terminal commands not working with Flatpack v:5.3 install
Here's one thought; https://www.redhat.com/sysadmin/launch-flatpaks-terminal-fuzzpak I just googled that. I've got the same question/issue... but hadn't looked up for it yet. ___ 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] Finance::Quote terminal commands not working with Flatpack v:5.3 install
I installed via flatpack Gnucash v. 5.3 on Linux Mint v. 20 OS and the terminal commands that I previously used to find sources for quotes on longer work. Here is the output: doug@sager:~$ gnucash-cli --quotes dump yahoo_json QCBMPXgnucash-cli: command not found doug@sager:~$ gnc-fq-dump -v yahoo_json QCBMPXCommand 'gnc-fq-dump' not found, but can be installed with:sudo apt install gnucash Any thoughts? ___ 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 balance always zero in search results?
Hi, On Mon, July 10, 2023 4:51 am, Adam Mackler via gnucash-user wrote: > Hello: > > I am using GnuCash version 4.4. > > When I use the "Find" option under the "Edit" menu while viewing an > account register, the "Search Results" I get seem to be a filtered version > of the account register that I was looking at when applying the "Find". This is correct. If you want to find from everything, then initiate the find from the Chart of Accounts. > There are two differences between the account register and the Search > Results that I don't understand: > > 1. In the "Search Results" there are no amounts on each transaction line > in the "Tot Debit" or "Tot Credit" columns, as there are when viewing the > account register. There are amounts on the split lines, but not on the > first line for each transaction. > > 2. The "Balance" column on each transaction line shows "0.00" for each > transaction, whereas in the account register that column shows the balance > of the account after each transaction. > > Why is value in the "Balance" column zero on every transaction line when > viewing Search Results, or put another way, what is the point of that > column if it shows no useful information? Is there a setting I can change > so that the values shown in the "Balance" column are a running total of > debits and credits on the account to which I applied the Edit → Find tool? > > I’m guessing it has something to do with the Find tool forgetting what > account I’m interested in, and so not knowing which account’s running > total it should be showing. What I’m trying to do is to limit the date > range for the account register so I can generate an Account Report limited > to that date range. The problem is that an Account Report generated from > the Search Results shows a running total ("Balance" column) of zero after > every transaction. It's also the fact that the running balance amounts are not computed on the fly, so it would be odd to display a balance. > Alternatively, is there a way to generate an Account Report directly from > an account register but for a limited date range? Yes! Filter by date under: View -> Filter Then from there, run the Account Report. > > -- > Adam Mackler > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 balance always zero in search results?
Hello: I am using GnuCash version 4.4. When I use the "Find" option under the "Edit" menu while viewing an account register, the "Search Results" I get seem to be a filtered version of the account register that I was looking at when applying the "Find". There are two differences between the account register and the Search Results that I don't understand: 1. In the "Search Results" there are no amounts on each transaction line in the "Tot Debit" or "Tot Credit" columns, as there are when viewing the account register. There are amounts on the split lines, but not on the first line for each transaction. 2. The "Balance" column on each transaction line shows "0.00" for each transaction, whereas in the account register that column shows the balance of the account after each transaction. Why is value in the "Balance" column zero on every transaction line when viewing Search Results, or put another way, what is the point of that column if it shows no useful information? Is there a setting I can change so that the values shown in the "Balance" column are a running total of debits and credits on the account to which I applied the Edit → Find tool? I’m guessing it has something to do with the Find tool forgetting what account I’m interested in, and so not knowing which account’s running total it should be showing. What I’m trying to do is to limit the date range for the account register so I can generate an Account Report limited to that date range. The problem is that an Account Report generated from the Search Results shows a running total ("Balance" column) of zero after every transaction. Alternatively, is there a way to generate an Account Report directly from an account register but for a limited date range? -- Adam Mackler ___ 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.