Re: [GNC] Reconciling subaccounts
Yes, so do I. But, the essence of reconciling with financial institutions is to use an account structure that can be aligned with the statements the institution provides. And reconciliation is a top consideration since your financial books are not the actual thing. As for roll-up: You simply cannot reconcile a brokerage account (for example) except by reconciling each individual holding and core account. It’s inherently a bottom-up process. And the same is true of bank books. Given multiple checking accounts at a particular bank, they must be individually reconciled. There is no rolling them up for purposes of reconciliation. And superimposing an envelope budgeting scheme on multiple institutions with multiple accounts would require, not just flattening, but an alternate structure. The GnuCash documentation on budgeting is pretty clear on what the software provides in that regard. Whether or not a feature that allows flattening a hierarchy of accounts for reconciliation purposes would be useful, it doesn’t currently exist. And it’s not particularly difficult to establish that fact. RTFM. You can try using a paint scraper as a chisel, but don’t expect a sympathetic ear at the hardware store. From: R Losey Sent: Saturday, October 8, 2022 2:56 PM To: David T. Cc: John Layman ; David T. via gnucash-user Subject: Re: [GNC] Reconciling subaccounts Well said! I actually have both kinds of parent accounts, as you described. On Sat, Oct 8, 2022 at 7:39 AM David T. via gnucash-user mailto:gnucash-user@gnucash.org> > wrote: John, I don't know about "typically." There are any of a number of ways that someone might use placeholder accounts. In my own books, I have placeholder accounts for brokerage holdings, where the placeholder represents an institution's account and the leaf accounts represent individual securities. I also have placeholder accounts that represent a class of account types-- for example, a placeholder for savings accounts at different institutions. The OP appears to be using the structure to implement an envelope allocation system, in which case the subaccounts are virtual. They want both the real and the virtual accounts to show that reconciliation. GnuCash doesn't currently do that. Whether that's a bug or a feature (and whether a sensible implementation can be devised to address it) is perhaps a different matter. David T. On Oct 8, 2022, 9:17 AM, at 9:17 AM, John Layman mailto:john.lay...@laymanandlayman.com> > wrote: >Typically, the place holder account represents an institution, not an >account. I have never seen a bank statement that presents rolled up >account totals at the institution level. Each checking account, >savings account, money market account, CD holdings, installment loan >accounts, etc. are presented separately (even if within the same >document) with beginning and ending balances shown separately for each >such account. Balancing could be an absolute nightmare if you had to >track down a discrepancy in conglomerated the numbers. -- _ Richard Losey rlo...@gmail.com <mailto: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] Reconciling subaccounts
Well said! I actually have both kinds of parent accounts, as you described. On Sat, Oct 8, 2022 at 7:39 AM David T. via gnucash-user < gnucash-user@gnucash.org> wrote: > John, > > I don't know about "typically." There are any of a number of ways that > someone might use placeholder accounts. In my own books, I have placeholder > accounts for brokerage holdings, where the placeholder represents an > institution's account and the leaf accounts represent individual > securities. I also have placeholder accounts that represent a class of > account types-- for example, a placeholder for savings accounts at > different institutions. > > The OP appears to be using the structure to implement an envelope > allocation system, in which case the subaccounts are virtual. They want > both the real and the virtual accounts to show that reconciliation. GnuCash > doesn't currently do that. > > Whether that's a bug or a feature (and whether a sensible implementation > can be devised to address it) is perhaps a different matter. > > David T. > > On Oct 8, 2022, 9:17 AM, at 9:17 AM, John Layman < > john.lay...@laymanandlayman.com> wrote: > >Typically, the place holder account represents an institution, not an > >account. I have never seen a bank statement that presents rolled up > >account totals at the institution level. Each checking account, > >savings account, money market account, CD holdings, installment loan > >accounts, etc. are presented separately (even if within the same > >document) with beginning and ending balances shown separately for each > >such account. Balancing could be an absolute nightmare if you had to > >track down a discrepancy in conglomerated the numbers. > -- _ 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] Reconciling subaccounts
John, I don't know about "typically." There are any of a number of ways that someone might use placeholder accounts. In my own books, I have placeholder accounts for brokerage holdings, where the placeholder represents an institution's account and the leaf accounts represent individual securities. I also have placeholder accounts that represent a class of account types-- for example, a placeholder for savings accounts at different institutions. The OP appears to be using the structure to implement an envelope allocation system, in which case the subaccounts are virtual. They want both the real and the virtual accounts to show that reconciliation. GnuCash doesn't currently do that. Whether that's a bug or a feature (and whether a sensible implementation can be devised to address it) is perhaps a different matter. David T. On Oct 8, 2022, 9:17 AM, at 9:17 AM, John Layman wrote: >Typically, the place holder account represents an institution, not an >account. I have never seen a bank statement that presents rolled up >account totals at the institution level. Each checking account, >savings account, money market account, CD holdings, installment loan >accounts, etc. are presented separately (even if within the same >document) with beginning and ending balances shown separately for each >such account. Balancing could be an absolute nightmare if you had to >track down a discrepancy in conglomerated the numbers. > >-Original Message- >From: gnucash-user > On Behalf Of >Stephen M. Butler >Sent: Friday, October 7, 2022 2:09 PM >To: gnucash-user@gnucash.org >Subject: Re: [GNC] Reconciling subaccounts > >For me the parent placeholder account in GnC is the bank account that >is being reconciled. The sub-accounts in GnC are just my way of >delegating the funds within that account for certain purposes. > >I'm not sure about the use case of using the placeholder as a grand >total for all accounts held at the bank and then reconciling all of >them in one step (checking, saving, CD, money market). I suppose if >they were all reported on a single statement > > >On 10/7/22 10:41, R Losey wrote: >> I kind of like it the way it is currently, for what it's worth. >> >> On Thu, Oct 6, 2022 at 1:20 PM Adrien Monteleone < >> adrien.montele...@lusfiber.net> wrote: >> >>> Thanks for the details. >>> >>> I'd say this is a bug, as the expected result would be to have the >>> reconcile status of sub-accounts updated. >>> >>> You should file that on bugs.gnucash.org >>> >>> It *might* be designed that way however. I could be wrong, but I >>> think the idea for this feature is to be used for 'virtual' >>> sub-accounts that are used for segregating funds in your own books, >>> but not actual multiple real-world accounts with an institution. >>> >>> The parent is the real account in such a case, so that might be why >>> it is the only one marked reconciled with a date. (it is the only >one >>> with a statement to reconcile against) >>> >>> In your case, you seem to be trying to reconcile multiple real >>> accounts through a placeholder parent. But GnuCash doesn't know >that. >>> (or 'reconciling' non-institution accounts, such as Expenses.) >>> >>> Until it is 'fixed' or changed, I guess your option is to continue >to >>> reconcile-finish the sub-accounts to update them, or else just >>> reconcile them all individually rather than together as >sub-accounts. >>> >>> Regards, >>> Adrien >>> >>> On 10/3/22 4:56 PM, Uttam Chakravorty wrote: >>>> My apologies Adrien, I will be more specific. Line 2 - >Sales -> >>>> A/c No >>> 01: all the subsequent lines starting '01-' are the subaccounts. >>> Reconciling 01 with subaccounts ticked will reconcile all of them, >>> but only update 01's date field. I then step through the >subaccounts >>> and as they are all already reconciled I just press 'Finish' to >update their date. >>>> >>>> Line 11 is a single entry with no subaccounts. >>>> >>>> >>>> Line 12 is similar to Line 2, a Placeholder with three subaccounts. >>>> >>>> >>>> I have tried to indicate the above in Column E, however I have made > >>>> a >>> mistake with Lines 64, 71 and 77. They have no subaccounts, I >>> annotated them in error as all the top level accounts are >reconciled. >>> In terms of consistency I failed to annotate Lines 12, 17 and 59. >>> Looking back this i
Re: [GNC] Reconciling subaccounts
Typically, the place holder account represents an institution, not an account. I have never seen a bank statement that presents rolled up account totals at the institution level. Each checking account, savings account, money market account, CD holdings, installment loan accounts, etc. are presented separately (even if within the same document) with beginning and ending balances shown separately for each such account. Balancing could be an absolute nightmare if you had to track down a discrepancy in conglomerated the numbers. -Original Message- From: gnucash-user On Behalf Of Stephen M. Butler Sent: Friday, October 7, 2022 2:09 PM To: gnucash-user@gnucash.org Subject: Re: [GNC] Reconciling subaccounts For me the parent placeholder account in GnC is the bank account that is being reconciled. The sub-accounts in GnC are just my way of delegating the funds within that account for certain purposes. I'm not sure about the use case of using the placeholder as a grand total for all accounts held at the bank and then reconciling all of them in one step (checking, saving, CD, money market). I suppose if they were all reported on a single statement On 10/7/22 10:41, R Losey wrote: > I kind of like it the way it is currently, for what it's worth. > > On Thu, Oct 6, 2022 at 1:20 PM Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > >> Thanks for the details. >> >> I'd say this is a bug, as the expected result would be to have the >> reconcile status of sub-accounts updated. >> >> You should file that on bugs.gnucash.org >> >> It *might* be designed that way however. I could be wrong, but I >> think the idea for this feature is to be used for 'virtual' >> sub-accounts that are used for segregating funds in your own books, >> but not actual multiple real-world accounts with an institution. >> >> The parent is the real account in such a case, so that might be why >> it is the only one marked reconciled with a date. (it is the only one >> with a statement to reconcile against) >> >> In your case, you seem to be trying to reconcile multiple real >> accounts through a placeholder parent. But GnuCash doesn't know that. >> (or 'reconciling' non-institution accounts, such as Expenses.) >> >> Until it is 'fixed' or changed, I guess your option is to continue to >> reconcile-finish the sub-accounts to update them, or else just >> reconcile them all individually rather than together as sub-accounts. >> >> Regards, >> Adrien >> >> On 10/3/22 4:56 PM, Uttam Chakravorty wrote: >>> My apologies Adrien, I will be more specific. Line 2 - >Sales -> >>> A/c No >> 01: all the subsequent lines starting '01-' are the subaccounts. >> Reconciling 01 with subaccounts ticked will reconcile all of them, >> but only update 01's date field. I then step through the subaccounts >> and as they are all already reconciled I just press 'Finish' to update their >> date. >>> >>> Line 11 is a single entry with no subaccounts. >>> >>> >>> Line 12 is similar to Line 2, a Placeholder with three subaccounts. >>> >>> >>> I have tried to indicate the above in Column E, however I have made >>> a >> mistake with Lines 64, 71 and 77. They have no subaccounts, I >> annotated them in error as all the top level accounts are reconciled. >> In terms of consistency I failed to annotate Lines 12, 17 and 59. >> Looking back this is a scrappy piece of work put together in haste. >> I hope you will be able to extract something useful, or I will happily do it >> again. Please advise. >>> >>> >>> Line 18 (A/c code 5 (should be 05)) is particularly interesting. >>> This >> has subaccounts and they have Placeholders which have subaccounts i.e. >> three levels deep. Reconciling the top level reconciles all the >> other levels, however once more it only updates the date at the top level. >>> >>> I do not find it too onerous to live with this little extra keyboard >> activity. I just wondered if I was doing something wrong again. >> >> >> ___ >> 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. >> > -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 -
Re: [GNC] Reconciling subaccounts
For me the parent placeholder account in GnC is the bank account that is being reconciled. The sub-accounts in GnC are just my way of delegating the funds within that account for certain purposes. I'm not sure about the use case of using the placeholder as a grand total for all accounts held at the bank and then reconciling all of them in one step (checking, saving, CD, money market). I suppose if they were all reported on a single statement On 10/7/22 10:41, R Losey wrote: I kind of like it the way it is currently, for what it's worth. On Thu, Oct 6, 2022 at 1:20 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: Thanks for the details. I'd say this is a bug, as the expected result would be to have the reconcile status of sub-accounts updated. You should file that on bugs.gnucash.org It *might* be designed that way however. I could be wrong, but I think the idea for this feature is to be used for 'virtual' sub-accounts that are used for segregating funds in your own books, but not actual multiple real-world accounts with an institution. The parent is the real account in such a case, so that might be why it is the only one marked reconciled with a date. (it is the only one with a statement to reconcile against) In your case, you seem to be trying to reconcile multiple real accounts through a placeholder parent. But GnuCash doesn't know that. (or 'reconciling' non-institution accounts, such as Expenses.) Until it is 'fixed' or changed, I guess your option is to continue to reconcile-finish the sub-accounts to update them, or else just reconcile them all individually rather than together as sub-accounts. Regards, Adrien On 10/3/22 4:56 PM, Uttam Chakravorty wrote: My apologies Adrien, I will be more specific. Line 2 - >Sales -> A/c No 01: all the subsequent lines starting '01-' are the subaccounts. Reconciling 01 with subaccounts ticked will reconcile all of them, but only update 01's date field. I then step through the subaccounts and as they are all already reconciled I just press 'Finish' to update their date. Line 11 is a single entry with no subaccounts. Line 12 is similar to Line 2, a Placeholder with three subaccounts. I have tried to indicate the above in Column E, however I have made a mistake with Lines 64, 71 and 77. They have no subaccounts, I annotated them in error as all the top level accounts are reconciled. In terms of consistency I failed to annotate Lines 12, 17 and 59. Looking back this is a scrappy piece of work put together in haste. I hope you will be able to extract something useful, or I will happily do it again. Please advise. Line 18 (A/c code 5 (should be 05)) is particularly interesting. This has subaccounts and they have Placeholders which have subaccounts i.e. three levels deep. Reconciling the top level reconciles all the other levels, however once more it only updates the date at the top level. I do not find it too onerous to live with this little extra keyboard activity. I just wondered if I was doing something wrong again. ___ 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. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Reconciling subaccounts
I kind of like it the way it is currently, for what it's worth. On Thu, Oct 6, 2022 at 1:20 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Thanks for the details. > > I'd say this is a bug, as the expected result would be to have the > reconcile status of sub-accounts updated. > > You should file that on bugs.gnucash.org > > It *might* be designed that way however. I could be wrong, but I think > the idea for this feature is to be used for 'virtual' sub-accounts that > are used for segregating funds in your own books, but not actual > multiple real-world accounts with an institution. > > The parent is the real account in such a case, so that might be why it > is the only one marked reconciled with a date. (it is the only one with > a statement to reconcile against) > > In your case, you seem to be trying to reconcile multiple real accounts > through a placeholder parent. But GnuCash doesn't know that. (or > 'reconciling' non-institution accounts, such as Expenses.) > > Until it is 'fixed' or changed, I guess your option is to continue to > reconcile-finish the sub-accounts to update them, or else just reconcile > them all individually rather than together as sub-accounts. > > Regards, > Adrien > > On 10/3/22 4:56 PM, Uttam Chakravorty wrote: > > > > My apologies Adrien, I will be more specific. Line 2 - >Sales -> A/c No > 01: all the subsequent lines starting '01-' are the subaccounts. > Reconciling 01 with subaccounts ticked will reconcile all of them, but only > update 01's date field. I then step through the subaccounts and as they > are all already reconciled I just press 'Finish' to update their date. > > > > > > Line 11 is a single entry with no subaccounts. > > > > > > Line 12 is similar to Line 2, a Placeholder with three subaccounts. > > > > > > I have tried to indicate the above in Column E, however I have made a > mistake with Lines 64, 71 and 77. They have no subaccounts, I annotated > them in error as all the top level accounts are reconciled. In terms of > consistency I failed to annotate Lines 12, 17 and 59. Looking back this is > a scrappy piece of work put together in haste. I hope you will be able to > extract something useful, or I will happily do it again. Please advise. > > > > > > > > Line 18 (A/c code 5 (should be 05)) is particularly interesting. This > has subaccounts and they have Placeholders which have subaccounts i.e. > three levels deep. Reconciling the top level reconciles all the other > levels, however once more it only updates the date at the top level. > > > > > > I do not find it too onerous to live with this little extra keyboard > activity. I just wondered if I was doing something wrong again. > > > ___ > 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] Reconciling subaccounts
Many thanks Adrien. I will go to bugs.gnucash.org and take a look at how to submit my experience. From: Adrien Monteleone To: Sent: 06/10/2022 7:17 PM Subject: Re: [GNC] Reconciling subaccounts Thanks for the details. I'd say this is a bug, as the expected result would be to have the reconcile status of sub-accounts updated. You should file that on bugs.gnucash.org It *might* be designed that way however. I could be wrong, but I think the idea for this feature is to be used for 'virtual' sub-accounts that are used for segregating funds in your own books, but not actual multiple real-world accounts with an institution. The parent is the real account in such a case, so that might be why it is the only one marked reconciled with a date. (it is the only one with a statement to reconcile against) In your case, you seem to be trying to reconcile multiple real accounts through a placeholder parent. But GnuCash doesn't know that. (or 'reconciling' non-institution accounts, such as Expenses.) Until it is 'fixed' or changed, I guess your option is to continue to reconcile-finish the sub-accounts to update them, or else just reconcile them all individually rather than together as sub-accounts. Regards, Adrien On 10/3/22 4:56 PM, Uttam Chakravorty wrote: > > My apologies Adrien, I will be more specific. Line 2 - >Sales -> A/c No 01: > all the subsequent lines starting '01-' are the subaccounts. Reconciling 01 > with subaccounts ticked will reconcile all of them, but only update 01's date > field. I then step through the subaccounts and as they are all already > reconciled I just press 'Finish' to update their date. > > > Line 11 is a single entry with no subaccounts. > > > Line 12 is similar to Line 2, a Placeholder with three subaccounts. > > > I have tried to indicate the above in Column E, however I have made a mistake > with Lines 64, 71 and 77. They have no subaccounts, I annotated them in > error as all the top level accounts are reconciled. In terms of consistency > I failed to annotate Lines 12, 17 and 59. Looking back this is a scrappy > piece of work put together in haste. I hope you will be able to extract > something useful, or I will happily do it again. Please advise. > > > > Line 18 (A/c code 5 (should be 05)) is particularly interesting. This has > subaccounts and they have Placeholders which have subaccounts i.e. three > levels deep. Reconciling the top level reconciles all the other levels, > however once more it only updates the date at the top level. > > > I do not find it too onerous to live with this little extra keyboard > activity. I just wondered if I was doing something wrong again. If this email has been sent to you in error please delete it and accept my apologies Company number: 4324700 ___ 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] Reconciling subaccounts
Thanks for the details. I'd say this is a bug, as the expected result would be to have the reconcile status of sub-accounts updated. You should file that on bugs.gnucash.org It *might* be designed that way however. I could be wrong, but I think the idea for this feature is to be used for 'virtual' sub-accounts that are used for segregating funds in your own books, but not actual multiple real-world accounts with an institution. The parent is the real account in such a case, so that might be why it is the only one marked reconciled with a date. (it is the only one with a statement to reconcile against) In your case, you seem to be trying to reconcile multiple real accounts through a placeholder parent. But GnuCash doesn't know that. (or 'reconciling' non-institution accounts, such as Expenses.) Until it is 'fixed' or changed, I guess your option is to continue to reconcile-finish the sub-accounts to update them, or else just reconcile them all individually rather than together as sub-accounts. Regards, Adrien On 10/3/22 4:56 PM, Uttam Chakravorty wrote: My apologies Adrien, I will be more specific. Line 2 - >Sales -> A/c No 01: all the subsequent lines starting '01-' are the subaccounts. Reconciling 01 with subaccounts ticked will reconcile all of them, but only update 01's date field. I then step through the subaccounts and as they are all already reconciled I just press 'Finish' to update their date. Line 11 is a single entry with no subaccounts. Line 12 is similar to Line 2, a Placeholder with three subaccounts. I have tried to indicate the above in Column E, however I have made a mistake with Lines 64, 71 and 77. They have no subaccounts, I annotated them in error as all the top level accounts are reconciled. In terms of consistency I failed to annotate Lines 12, 17 and 59. Looking back this is a scrappy piece of work put together in haste. I hope you will be able to extract something useful, or I will happily do it again. Please advise. Line 18 (A/c code 5 (should be 05)) is particularly interesting. This has subaccounts and they have Placeholders which have subaccounts i.e. three levels deep. Reconciling the top level reconciles all the other levels, however once more it only updates the date at the top level. I do not find it too onerous to live with this little extra keyboard activity. I just wondered if I was doing something wrong again. ___ 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] Reconciling subaccounts
My apologies Adrien, I will be more specific. Line 2 - >Sales -> A/c No 01: all the subsequent lines starting '01-' are the subaccounts. Reconciling 01 with subaccounts ticked will reconcile all of them, but only update 01's date field. I then step through the subaccounts and as they are all already reconciled I just press 'Finish' to update their date. Line 11 is a single entry with no subaccounts. Line 12 is similar to Line 2, a Placeholder with three subaccounts. I have tried to indicate the above in Column E, however I have made a mistake with Lines 64, 71 and 77. They have no subaccounts, I annotated them in error as all the top level accounts are reconciled. In terms of consistency I failed to annotate Lines 12, 17 and 59. Looking back this is a scrappy piece of work put together in haste. I hope you will be able to extract something useful, or I will happily do it again. Please advise. Line 18 (A/c code 5 (should be 05)) is particularly interesting. This has subaccounts and they have Placeholders which have subaccounts i.e. three levels deep. Reconciling the top level reconciles all the other levels, however once more it only updates the date at the top level. I do not find it too onerous to live with this little extra keyboard activity. I just wondered if I was doing something wrong again. Many thank again, Uttam From: Adrien Monteleone To: Sent: 03/10/2022 3:19 PM Subject: Re: [GNC] Reconciling subaccounts Okay, so now we see the account structure, but now, can you give an example of which parent account you were trying to reconcile with sub-accounts that did not update their last-reconciled dates? Regards, Adrien On 10/3/22 8:41 AM, Uttam Chakravorty wrote: > > Dear Adrien, > > > This is what I use for a small VAT Registered UK limited company as per what > my son and wife's business requires. I have a very different one based on > income and expenditure as in UK they have to file a personal annual > Self-Assessment Return. I hope this gives you the information that you > require and should it help any others with their Gnucash Odyssey I will be > delighted. > > > > I have attached it as accounts_tree.csv. I hope this works. If this email has been sent to you in error please delete it and accept my apologies Company number: 4324700 ___ 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] Reconciling subaccounts
Ah, scratch that last question. I see you've put in the chart which accounts show a reconciled date and it appears sub-accounts never do when using that option. In that case, yes, I think you found a bug. Please file it. The instructions are here on the wiki if you aren't familiar with the process: https://wiki.gnucash.org/wiki/Bugzilla *note, the usual process of reconciliation is to match up records from an outside institution, such as a bank or credit card company, with your own records. It would be highly unusual for accounts *other* than those to be reconciled, though of course, you are free to do so. (because the question is, "reconciled against what, if there is no other party document?") Regards, Adrien On 10/3/22 8:41 AM, Uttam Chakravorty wrote: Dear Adrien, This is what I use for a small VAT Registered UK limited company as per what my son and wife's business requires. I have a very different one based on income and expenditure as in UK they have to file a personal annual Self-Assessment Return. I hope this gives you the information that you require and should it help any others with their Gnucash Odyssey I will be delighted. I have attached it as accounts_tree.csv. I hope this works. ___ 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] Reconciling subaccounts
Okay, so now we see the account structure, but now, can you give an example of which parent account you were trying to reconcile with sub-accounts that did not update their last-reconciled dates? Regards, Adrien On 10/3/22 8:41 AM, Uttam Chakravorty wrote: Dear Adrien, This is what I use for a small VAT Registered UK limited company as per what my son and wife's business requires. I have a very different one based on income and expenditure as in UK they have to file a personal annual Self-Assessment Return. I hope this gives you the information that you require and should it help any others with their Gnucash Odyssey I will be delighted. I have attached it as accounts_tree.csv. I hope this works. ___ 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] Reconciling subaccounts
Dear Adrien, This is what I use for a small VAT Registered UK limited company as per what my son and wife's business requires. I have a very different one based on income and expenditure as in UK they have to file a personal annual Self-Assessment Return. I hope this gives you the information that you require and should it help any others with their Gnucash Odyssey I will be delighted. I have attached it as accounts_tree.csv. I hope this works. Best Regards, Uttam From: Adrien Monteleone To: Sent: 02/10/2022 3:49 AM Subject: Re: [GNC] Reconciling subaccounts What account *exactly* are you selecting that is a placeholder? It sounds like you're trying to reconcile a very top-level account and then including sub-accounts. If so, I don't think that is how the feature was intended to work. (though maybe it *could* regardless, I honestly never thought to try that approach) If not, then perhaps you found a bug. Can you provide a screenshot or typed version of the part of the account tree in question? That is, what is the 'placeholder' account you are referring to? (where does it lie in the tree, Assets, Liabilities, Expenses, Income, Equity? Then what is the next level? and the next level if any? et cetera...) Then, what are the sub-accounts? And importantly, can you verify that those sub-accounts are all of the same *type* as their parent? (you can see the type in the bottom left of the window that displays when you highlight an account in the Accounts tab and click the 'Edit' button or right-click the account and choose 'edit') Regards, Adrien On 10/1/22 7:58 PM, Uttam Chakravorty wrote: > Dear All, > > From 'Accounts' I highlight one that is a Placeholder -> > right click on 'Reconcile...' -> > select the 'include subaccounts' checkbox. > > This works perfectly and the Placeholder accounts 'Last Reconcile Date' is > updated accordingly. However the 'subaccounts' last reconciled dates are not > updated. > > Any suggestions? > > Background: I like to reconcile the bank account, the input/output ledgers > and the trade creditors/debtors every month. As a small business there are > only a few dozen entries. If this email has been sent to you in error please delete it and accept my apologies Company number: 4324700 "Type","Full Account Name","Placeholder","Account Code", "INCOME","Sales","T","01","Reconcile" "INCOME","Sales:01",,"01-05", "INCOME","Sales:02",,"01-10", "INCOME","Sales:03",,"01-15", "INCOME","Sales:04",,"01-20", "INCOME","Sales:05",,"01-25", "INCOME","Sales:06",,"01-30", "INCOME","Sales:07",,"01-35", "INCOME","Sales:08",,"01-40", "INCOME","Sales:Disbursements",,"01-45", "INCOME","Bank Interest Earned",,"02", "EXPENSE","Purchases","T","03-15","Reconcile" "EXPENSE","Purchases:01",,"03-05", "EXPENSE","Purchases:02",,"03-10", "EXPENSE","Purchases:Subcontract",,"03-15", "EXPENSE","Staff Wages",,"4", "EXPENSE","Overheads","T","5","Reconcile" "EXPENSE","Overheads:Rent",,"05-05", "EXPENSE","Overheads:Insurance",,"05-10", "EXPENSE","Overheads:Telephone and Internet",,"05-15", "EXPENSE","Overheads:Post and Stationery",,"05-20", "EXPENSE","Overheads:Advertising & Marketing",,"05-25", "EXPENSE","Overheads:Motor Expenses","T","05-30", "EXPENSE","Overheads:Motor Expenses:EV Charging",,"05-30-05", "EXPENSE","Overheads:Motor Expenses:Fuel and Oil",,"05-30-10", "EXPENSE","Overheads:Motor Expenses:Motor Ins & Tax",,"05-30-15", "EXPENSE","Overheads:Motor Expenses:Repairs and Servicing",,"05-30-20", "EXPENSE","Overheads:Motor Expenses:Tolls and Parking",,"05-30-25", "EXPENSE","Overheads:Motor Expenses:Staff Mileage",,"05-30-30", "EXPENSE","Overheads:Travel","T","05-35", "EXPENSE","Overheads:Travel:Travel - UK",,"05-35-05", "EXPENSE","Overheads:
Re: [GNC] Reconciling subaccounts
What account *exactly* are you selecting that is a placeholder? It sounds like you're trying to reconcile a very top-level account and then including sub-accounts. If so, I don't think that is how the feature was intended to work. (though maybe it *could* regardless, I honestly never thought to try that approach) If not, then perhaps you found a bug. Can you provide a screenshot or typed version of the part of the account tree in question? That is, what is the 'placeholder' account you are referring to? (where does it lie in the tree, Assets, Liabilities, Expenses, Income, Equity? Then what is the next level? and the next level if any? et cetera...) Then, what are the sub-accounts? And importantly, can you verify that those sub-accounts are all of the same *type* as their parent? (you can see the type in the bottom left of the window that displays when you highlight an account in the Accounts tab and click the 'Edit' button or right-click the account and choose 'edit') Regards, Adrien On 10/1/22 7:58 PM, Uttam Chakravorty wrote: Dear All, From 'Accounts' I highlight one that is a Placeholder -> right click on 'Reconcile...' -> select the 'include subaccounts' checkbox. This works perfectly and the Placeholder accounts 'Last Reconcile Date' is updated accordingly. However the 'subaccounts' last reconciled dates are not updated. Any suggestions? Background: I like to reconcile the bank account, the input/output ledgers and the trade creditors/debtors every month. As a small business there are only a few dozen entries. ___ 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.