Re: [GNC] Adding ASSETS & LIABILITIES to sub accounts
Luis: Welcome to GnuCash! You ask a good question. On 2024-05-30 01:31, Luis Sini wrote: TL;DR + I would like to add "ASSETS" and "LIABILITIES" account types as sub-accounts but GnuCash only allows it if they are "Top Level Accounts" + Hello to everyone, I make money personally, I own a couple of properties, and I also design and manufacture audio devices. These are basically different entities, and I know that I can create a separate GnuCash file for each one of those ventures. But, I wanted to create 1 GnuCash file that will allow me to have a comprehensive view of all my financial activities while being able to track each venture separately. I've gone ahead and created the following structure: 1. PERSONAL WORK 1. INCOME 2. EXPENSES 2. PROPERTIES 1. PROPERTY A 1. INCOME 2. EXPENSES 2. PROPERTY B 1. INCOME 2. EXPENSES 3. AUDIO DEVICES 1. INCOME 2. EXPENSES What I would like to do is add "ASSETS" and "LIABILITIES" sub-accounts to "PERSONAL WORK" and each of the "PROPERTIES". Unfortunately, GnuCash only allows me to assign sub-accounts types as either "Income" or "Expense" unless the parent account is not set up as either Assets or Liability? I can make an account an "Asset" or "Liability" if the account is a "Top Level Account". Is there any way to get around this limitation? I do not know a way around the limitation that GnuCash places on the types of accounts which can be children of various types of accounts, e.g. that an Asset account may not be a child of an Income or Expense account. I face a similar situation with my own bookkeeping. I track assets, liabilities, income, and expenses, for my marriage's joint holdings, and my personal income, and my spouse's personal income, for my small business, and some real estate. I let GnuCash insist that Assets, Liabilities, Equity, Income, and Expenses be top-level accounts. I divide into my various joint and personal and business divisions at the next level down. Applying that to your example, your chart of accounts might be: 1. Assets 1.A. Personal Assets 1.B. Property Assets 1.B.a. Property A Assets 1.B.b. Property B Assets 1.C. Audio Devices Assets 2. Equity 2.A. Personal Equity 2.B. Property Equity 2.B.a. Property A Equity 2.B.b. Property B Equity 2.C. Audio Devices Equity 3. Expenses 3.A. Personal Expenses 3.B. Property Expenses 3.B.a. Property A Expenses 3.B.b. Property B Expenses 3.C. Audio Devices Expenses 4. Income 4.A. Personal Income 4.B. Property Income 4.B.a. Property A Income 4.B.b. Property B Income 4.C. Audio Devices Income 5. Liabilities 5.A. Personal Income 5.B. Property Income 5.B.a. Property A Income 5.B.b. Property B Income 5.C. Audio Devices Income I can imagine three objections you might have to this structure. 1. It is verbose. My structure has 30 lines, while yours has only 13 lines (or 21 after you add Assets and Liabilities as you propose). I do not find that to be a problem. The only time I see all the accounts is in the Accounts tab, and most of the time most of the hierarchy is collapsed and hidden from view. When I want to enter an account name into a transaction, I type portions of the path of account names, and GnuCash gives me a menu of the few accounts which match those portions. 2. It doesn't let you report on a single subtree of the account and capture all the income, expenses, assets, and liabilities. I also do not find that to be a problem. GnuCash custom reports allow you to select which accounts to include in the reports. If you want a report for Property A, you can define a GnuCash custom report which includes 1.B.a. Property A Assets, 2.B.a. Property A Equity, 3.B.a. Property A Expenses, 4.B.a. Property A Income, 5.B.a. Property A Income and all subaccounts of those five accounts. 3. You might not be sure which structure will work for you long-term. The good news is that GnuCash lets you move accounts from one parent to another within the Accounts tree (subject to its rules about which account types can be children of which account types), and all the transactions associated with that account follow the account to its new home. You can do even pretty major restructuring of accounts as you go, and your records stay intact. I hope this helps. Good luck with your bookkeeping! —Jim DeLaHunt ___ 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] Adding ASSETS & LIABILITIES to sub accounts
TL;DR + I would like to add "ASSETS" and "LIABILITIES" account types as sub-accounts but GnuCash only allows it if they are "Top Level Accounts" + Hello to everyone, I make money personally, I own a couple of properties, and I also design and manufacture audio devices. These are basically different entities, and I know that I can create a separate GnuCash file for each one of those ventures. But, I wanted to create 1 GnuCash file that will allow me to have a comprehensive view of all my financial activities while being able to track each venture separately. I've gone ahead and created the following structure: 1. PERSONAL WORK 1. INCOME 2. EXPENSES 2. PROPERTIES 1. PROPERTY A 1. INCOME 2. EXPENSES 2. PROPERTY B 1. INCOME 2. EXPENSES 3. AUDIO DEVICES 1. INCOME 2. EXPENSES What I would like to do is add "ASSETS" and "LIABILITIES" sub-accounts to "PERSONAL WORK" and each of the "PROPERTIES". Unfortunately, GnuCash only allows me to assign sub-accounts types as either "Income" or "Expense" unless the parent account is not set up as either Assets or Liability? I can make an account an "Asset" or "Liability" if the account is a "Top Level Account". Is there any way to get around this limitation? Thanks in advance. Luis S. ___ 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] Reconciliation Roll Back
I'll add a "me, too" - I had no idea that this was available until I saw it here. Very nice! On Wed, May 29, 2024 at 8:15 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > And I learn something new everyday. Thanks David! > > Regards, > Adrien > > On 5/28/24 9:17 AM, David Carlson wrote: > > A tidbit of information that you may find helpful: If you hover the > mouse > > over the "y" character in the reconcile box in an account split line, the > > date of the reconciliation for that account split in that transaction > > appears in a flyover. It may take a couple of seconds to appear. > > ___ > 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] Reconciliation Roll Back (Peter Cuthbert)
On Thu, 30 May 2024 12:14:08 +0300 sunfish62--- via gnucash-user wrote: > With all due respect, most of the issues raised by Peter are covered > in some way in section 2.9.4 of the Guide, especially in the notes > and warnings embedded there. > > A deeper exploration of the different methods a user can implement to > recover from some of these more challenging situations might > appropriately fit on the wiki. > > David T. I was thinking about recovery from the challenging situations, which might start with a quote from Douglas Adams "Don't Panic" Liz ___ 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] Reconciliation Roll Back (Peter Cuthbert)
With all due respect, most of the issues raised by Peter are covered in some way in section 2.9.4 of the Guide, especially in the notes and warnings embedded there. A deeper exploration of the different methods a user can implement to recover from some of these more challenging situations might appropriately fit on the wiki. David T. On May 30, 2024, 8:00 AM, at 8:00 AM, Liz wrote: >On Wed, 29 May 2024 22:54:26 -0400 >NoobAlice wrote: > >> On 2024-05-29 04:39 PM, Peter Cuthbert via gnucash-user wrote: >> >> > The dates associated with the reconciled/not reconciled flag struck >> > me as an easy way to do a roll back without using the backups. >> > Something along the lines of if date = [specified >> > reconciliation date] then flag = n (I have no idea what >> > language is used by the developers. ... >> > So where am I with my data? I have corrected the £10k which was >> > 'swopped' and then gone after the error schrapnel. Some of that I >> > have found and corrected but eventually I had to succumb to a >> > balancing 'fudge it' figure. With that in place the rest of the >> > reconciliation was correct to the penny. >> >> To you and anyone else facing this issue, you can run a transaction >> report that shows you a history of of the account with reconciled >> dates for every transaction. >> > >Thanks NoobAlice >that is a really useful tip > >Thanks to Peter Cuthbert we've got together some really good tips on >what happens when a reconciliation goes awry, and I hope that someone >puts a summary on the wiki. > >Liz >___ >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] Reconciliation Roll Back (Peter Cuthbert)
There is nothing worse than facing a pile of paperwork to input, at the end of the month - or whatever period of time chosen. As a sufferer of such I resolved to spend a few minutes entering whatever had accrued during the day at the end of it - or first thing the next. The good thing about this is that you can pick up any errors made whilst they are still fresh in your mind, and it is surprising how quickly this becomes part of your daily routine. I heartily recommend it. On Wed, 29 May 2024 at 21:40, Peter Cuthbert via gnucash-user < gnucash-user@gnucash.org> wrote: > > Hi David, Adam, Derek and everybody who has contributed. > > David, your solution is excellent and I suppose it never crossed my mind > as I had not wholly worked out what all the files GNUCash spews out > actually do. I am afraid that using the accounting software is a twice > monthly chore in which I log all the transaction slip and credit card > statement and then reconcile against the bank account. It is almost > always late in the evening after the day's chores are cleared up and I > am not really at my brightest. So I have not been a keen student and > learned how to make the software fly. > > The dates associated with the reconciled/not reconciled flag struck me > as an easy way to do a roll back without using the backups. Something > along the lines of if date = [specified reconciliation date] then > flag = n (I have no idea what language is used by the developers. > I suppose my gripe about the 'Opening Balance' auto figure is probably > based on many years of using Quicken. According to my memory one could > enter both an opening and closing balance, but more recent users can > tell me if that memoryis incorrect, Perhaps, for those of us who are > more in the 'dozy user'category the term Opening balance could perhaps > have Closing balance at last reconciliation added to it. > Have suffered all this messing about to find errors I will probably > remember that but it might help folk loke me who have yet to fall into > the trap of not checking that the opening balance was the last > reconciliation closing balance. After all, if the program will not let > you change it why worry about the figure? However it is really the key > figure on which the reconciliation is built so ought to be checked at > the start. > > So where am I with my data? I have corrected the £10k which was > 'swopped' and then gone after the error schrapnel. Some of that I have > found and corrected but eventually I had to succumb to a balancing > 'fudge it' figure. With that in place the rest of the reconciliation > was correct to the penny. > > Thanks for all the help. > > Best wishes > > Pete > > -- Original Message -- > From: hell...@gmail.com > To: p.f.cuthb...@btinternet.com Cc: gnucash-user@gnucash.org; > blake.hannaf...@gmail.com > Sent: Wednesday, May 29th 2024, 21:01 > Subject: Re: [GNC] Reconciliation Roll Back (Peter Cuthbert) > Peter, The roll back facility is already there and has been for years - > it's called going back to a backup of your accounts file :-) I'm > assuming you're just using the bog standard xml data file here and are > running on Windows. There is a preference under Preferences >> General > that allows you to specify how many days to retain log/backup files > which is defaulted to 30 days from memory, but you can set it to retain > backups permanently and delete on an adhoc basis if you wish. So if you > are using the xml backend Gnucash does this for you and on Windows at > least keeps them in the same folder as your actual data file. Gnucash > names them the same as your actual data file but includes a date and > timestamp embedded in the name and they also have the usual .gnucash > file suffix - e.g. if the actual data file was named > Gnucash_Data_From_2011_01_01.gnucash the backups are named > Gnucash_Data_From_2011_01_01.gnucash.20240429182558.gnucash. > You can open any of these backup files as a Gnucash data file. My > suggestion would be to take a copy of your actual data file and put it > somewhere safe before you do anything further and make a note of the > date and time you did the reconciliation that you think was bad. Then > open the backup file just prior to this date and time - hopefully > whatever happened, occurred within your backup files window if you do > have GnuCash setup to retain backups. If this backup file looks good to > you, you can then choose to save this backup file as your actual data > file name and start over - you need to do this last step of saving the > backup file without the date and timestamp in the name, otherwise going > forward you'll end up with some horrendous backup/log file names e.g. > Gnucash_Data_From_2011_01_01.gnucash.20240429182558.20240430054858.gnucash. > > This may mean re-entering/importing transactions from the date and time > of the backup file - you could always export transactions from your > actual data file to cover this period if that's an
