Re: [GNC] Question about sub accounts
Ken Schneider > On Oct 31, 2018, at 1:01 PM, Wm via gnucash-user > wrote: > >> On 29/10/2018 16:49, Adrien Monteleone wrote: >> >> We’ve discussed envelope budgeting quite a bit here on the list. Do a list >> restricted search to find the threads. I’ve tried it myself in the past, and >> currently have the account tree set up to use, but honestly, it is probably >> better to use an outside piece of software to manage the budgeting and just >> use GnuCash for the actual real accounting. (GnuCash has a budget module, >> but it is not envelope based) There are several methods and lots of >> pitfalls. The least of which is nearly double the work in entering >> transaction splits. > > I think it is a envelope budget hangover. > >> Finally, there are plenty of good standard accounting textbooks online for >> free. Here’s one I’ve found pretty useful as a quick reference: >> https://www.principlesofaccounting.com/ (I have a college textbook I kept >> that is probably better, but that copy is on paper and this is at my >> fingertips) >> All of your questions though were not accounting questions, but GnuCash >> mechanics questions. We don’t give accounting advice here, but can offer >> some basic generic example help and can point you in the right direction, >> but if the question is “how do I do ‘x’ with GnuCash” like you’ve asked, >> that’s what we’re here for. > > You are sort of right and sort of wrong, the OP wants something that gnc can > do with effort but if you have brains you don't bother with. > > Envelope budgeting is, oddly, something Trump voters pay for. Weird. PLEASE keep your snide childish remarks to yourself. They’re not appreciated on this list. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Question about sub accounts
On 29/10/2018 16:49, Adrien Monteleone wrote: We’ve discussed envelope budgeting quite a bit here on the list. Do a list restricted search to find the threads. I’ve tried it myself in the past, and currently have the account tree set up to use, but honestly, it is probably better to use an outside piece of software to manage the budgeting and just use GnuCash for the actual real accounting. (GnuCash has a budget module, but it is not envelope based) There are several methods and lots of pitfalls. The least of which is nearly double the work in entering transaction splits. I think it is a envelope budget hangover. Finally, there are plenty of good standard accounting textbooks online for free. Here’s one I’ve found pretty useful as a quick reference: https://www.principlesofaccounting.com/ (I have a college textbook I kept that is probably better, but that copy is on paper and this is at my fingertips) All of your questions though were not accounting questions, but GnuCash mechanics questions. We don’t give accounting advice here, but can offer some basic generic example help and can point you in the right direction, but if the question is “how do I do ‘x’ with GnuCash” like you’ve asked, that’s what we’re here for. You are sort of right and sort of wrong, the OP wants something that gnc can do with effort but if you have brains you don't bother with. Envelope budgeting is, oddly, something Trump voters pay for. Weird. -- Wm ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Question about sub accounts
On 29/10/2018 14:55, Eric Gwin wrote: Hi, I'm pretty new to to application, and have basically 0 accounting background. I've setup my books and all is working pretty well, but I am running into an issue with subaccounts I hope I'm doing something wrong, but if not I'd also like to know so I can post a suggestion. Scenario: I have a checking account I am using as an accumulator for multiple other purposes (it is a "sinking" fund account I use to "save" for expected/budgeted non-monthly expenses) I have set it up like this: *assets:current assets:sinking checking* is then has sub accounts to track deposits to and deductions from various categories *assets:current assets:sinking checking:AutoMaint* *assets:current assets:sinking checking:Clothing* *assets:current assets:sinking checking:HairCare* *assets:current assets:sinking checking:HomeMaint* *assets:current assets:sinking checking:KidActivity* On a bi-monthly basis, I deposit a fixed amount to the "sinking checking" and a split transaction allocates it to the various sub-accounts. Then as payments need to be made I use that checking for the payment and track it using an entry against the sub-account. This works pretty well as it solves the major problem of maintaining each sub-accounts spending and balances. However, in order to reconcile the checking account I need to see all the transactions to each sub account listed in the register for the "sinking checking" along with the running balance for the account. I'm missing the point a bit, you have really specific accounts. I've been able to limp by so far by specifying every transaction as a split with no amount to *assets:current assets:sinking checking * and the actual transaction amount to the sub-account: *assets:current assets:sinking checking:AutoMaint* -135.45 *Expenses:Sinking:AutoMaint * 135.45 That at least creates an entry in the "singing checking" register and the "Accounts" tab does show the current balance for "sinking checking", but there is no running total, nor does the transaction amount show in that account's register. Setting "Sinking checking" as a placeholder seems to simply mean GNUCash won't allow you to view the register or enter a transaction against the account. We are aware of envelope accounting as a theory and don't really think of it as accounting, it is a budgeting method and hope you realise that. Your budget is your business, gnc can help you but it isn't going to do it for you. gnc is for grown ups not the average Trump voter. Is there a way to set up an account of this type where the account maintains the transactions (as it should for reconciliation) and each sub-account also "inherits" transactions for their type: or the sub accounts get the transaction entries as I'm doing, but the parent account register lists (but doesn't total) the sub account transactions? Yes, spend at the lowest level and report at the highest level and drill down until you see what you do (or don't) want to see. BTW, this sort of Budgeting won't work in gnc so don't even try. Micro management of personal finance is best done in another way, I'd go so far as to suggest not doing it on social media. -- Wm ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Question about sub accounts
Eric, Read the end of my reply first... Now, I was following you up until this point: > On Oct 29, 2018, at 9:55 AM, Eric Gwin wrote: > ... > I've been able to limp by so far by specifying every transaction as a split > with no amount to *assets:current assets:sinking checking * > and the actual transaction amount to the sub-account: > *assets:current assets:sinking checking:AutoMaint* -135.45 > *Expenses:Sinking:AutoMaint * 135.45 What you showed here *was* an amount to the sinking checking *and* an amount to the related expense account. Yet you said you “_no_ amount to the ...:sinking checking”. > That at least creates an entry in the "singing checking" register and the > "Accounts" tab does show the current balance for "sinking checking", but > there is no running total, nor does the transaction amount show in that > account's register. > What do you mean by ‘running total’ and how could you not see the transaction amount in that account’s register if you in fact created a transaction with a split to that account? Your description here is very confusing. > Setting "Sinking checking" as a placeholder seems to simply mean GNUCash > won't allow you to view the register or enter a transaction against the > account. Correct. And as a good rule of thumb to not tear your hair out later, it is good practice to make all parent accounts placeholders except for very special situations. (This is one of them, but see below) > > Is there a way to set up an account of this type where the account > maintains the transactions (as it should for reconciliation) If you enter a transaction with splits to a certain account, that account’s register will contain a copy of the transaction and its running balance will reflect the result of the cumulative effect of those splits. > and each > sub-account also "inherits" transactions for their type: Not sure what you mean by this. By ’type’ do you mean ‘expense, asset, etc.?' > or the sub > accounts get the transaction entries as I'm doing, but the parent account > register lists (but doesn't total) the sub account transactions? Now we’re back to the first part of your post, the problem you are initially having an issue with is reconciling. There is a solution: When you click the Reconcile button while viewing the *parent* account, check the “Include Subaccounts” box. But keep reading first... Note, if this is a real checking account that you are simply segregating funds in *artificially* (that is, not actually with separate accounts at the bank) then make all of these subs as children of the actual checking account - not Current Assets. But do not make the parent real checking account a placeholder as it might contain real transactions unrelated to the children. Then the reconcile process will make sense using the ‘Include Subaccounts’ option. So you can see here, it would be odd to reconcile ‘Current Assets’ especially since that account can have other children like “Cash” or “Pre-paid Expenses” and other actual checking and savings accounts among others. If these are simply your own mechanism for savings, like a virtual envelope method, and the funds might be physically represented in the real world in various or multiple places, then create a parent for them, say “Current Assets:Budget Envelopes” and include in each transaction a set of transfer splits from the envelope back to the physical account where the funds reside, then ’spend’ from the actual physical account, then reconcile the actual physical account. This means more splits for each transaction (at least 4 total) but you can maintain your budgeting method. We’ve discussed envelope budgeting quite a bit here on the list. Do a list restricted search to find the threads. I’ve tried it myself in the past, and currently have the account tree set up to use, but honestly, it is probably better to use an outside piece of software to manage the budgeting and just use GnuCash for the actual real accounting. (GnuCash has a budget module, but it is not envelope based) There are several methods and lots of pitfalls. The least of which is nearly double the work in entering transaction splits. Finally, there are plenty of good standard accounting textbooks online for free. Here’s one I’ve found pretty useful as a quick reference: https://www.principlesofaccounting.com/ (I have a college textbook I kept that is probably better, but that copy is on paper and this is at my fingertips) All of your questions though were not accounting questions, but GnuCash mechanics questions. We don’t give accounting advice here, but can offer some basic generic example help and can point you in the right direction, but if the question is “how do I do ‘x’ with GnuCash” like you’ve asked, that’s what we’re here for. Regards, Adrien ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription
[GNC] Question about sub accounts
Hi, I'm pretty new to to application, and have basically 0 accounting background. I've setup my books and all is working pretty well, but I am running into an issue with subaccounts I hope I'm doing something wrong, but if not I'd also like to know so I can post a suggestion. Scenario: I have a checking account I am using as an accumulator for multiple other purposes (it is a "sinking" fund account I use to "save" for expected/budgeted non-monthly expenses) I have set it up like this: *assets:current assets:sinking checking* is then has sub accounts to track deposits to and deductions from various categories *assets:current assets:sinking checking:AutoMaint* *assets:current assets:sinking checking:Clothing* *assets:current assets:sinking checking:HairCare* *assets:current assets:sinking checking:HomeMaint* *assets:current assets:sinking checking:KidActivity* On a bi-monthly basis, I deposit a fixed amount to the "sinking checking" and a split transaction allocates it to the various sub-accounts. Then as payments need to be made I use that checking for the payment and track it using an entry against the sub-account. This works pretty well as it solves the major problem of maintaining each sub-accounts spending and balances. However, in order to reconcile the checking account I need to see all the transactions to each sub account listed in the register for the "sinking checking" along with the running balance for the account. I've been able to limp by so far by specifying every transaction as a split with no amount to *assets:current assets:sinking checking * and the actual transaction amount to the sub-account: *assets:current assets:sinking checking:AutoMaint* -135.45 *Expenses:Sinking:AutoMaint * 135.45 That at least creates an entry in the "singing checking" register and the "Accounts" tab does show the current balance for "sinking checking", but there is no running total, nor does the transaction amount show in that account's register. Setting "Sinking checking" as a placeholder seems to simply mean GNUCash won't allow you to view the register or enter a transaction against the account. Is there a way to set up an account of this type where the account maintains the transactions (as it should for reconciliation) and each sub-account also "inherits" transactions for their type: or the sub accounts get the transaction entries as I'm doing, but the parent account register lists (but doesn't total) the sub account transactions? Thanks for your time. -Eric ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
