Re: [GNC] Expense distribution main and sub accounts
Norman If I understand you correctly, the rent is an expense for the associated body but income for the Master body. Presumably each of these bodies has their own Assets and bank accounts. If there is only a single bank account for the master and associate bodies you could still create subaccounts of it for each associate if you need to track each associate's contributions to a joint bank account separately. A transaction with the following splits: Assets:Assoc:Bank Cr Expense:Assoc:Rent Dr would record the Assoc body paying rent and the following entry: Assets:Master:Bank Dr Income:Master:Rent Cr records the Master body receiving income for rent from the Associate body. This parallels the situation if their books were maintained separately. It would be possible to combine these as multiple splits in a single transaction. Disclaimer: The legality of the above approach will depend on your jurisdiction's laws and regulations and the extent to which the associates and master bodies act as separate legal entities and you should seek appropriate legal/accounting advice from local professionals. David Cousens David Cousens - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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.
[GNC] Transfer funds after reconcile, finish ???
Hi All, After a successful Reconcile, Finish, I sometimes get the following pop up: I changed the number to zero before pasting. What is this all about? Why would it want to transfer funds? I press cancel. Many thanks, -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 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] Expense distribution main and sub accounts
I’m not certain what you mean by ‘body’ but it seems to look like your dealing with 6 separate entities and a parent entity. If that is the case, while you might be able to accomplish this with some fancy and very duplicative account structures, and likely a few duplicate transactions, you might be better served keeping all of those books separate from each other. (some legal jurisdictions require the separation) But if you really need/want to stay in one book: Who is the expense for? the sub or the managing account? It only needs to be recorded once as an expense - where it actually belongs. This will balance with a credit to an asset used to pay the expense. But it also needs to be recorded as income for the managing account. There is no way around this. (you’d have a separate transaction anyway if you had separate books) This will balance with a debit to whatever asset account according to the actual payment method received. Regards, Adrien > On Jun 18, 2019, at 11:21 PM, NORMAN HOSKIN wrote: > > Hello, > I have set up gnu cash for an association. > The acc set up is a master account for the managing body and 6 sub accounts > for all the associate bodies. > All the income & expenses are entered in the sub associate account. > The all works well with each sub body balancing The difficulty I am having is > when I have and expense from a sub account payable to the managing body > account. > The expense is rent. > > If I expense against the sub body acc I require it to expense to be > subtracted from the sub body account and added to the main body account > without duplicating the expense. > Currently I can only show it in either the managing acc or associate account. > Can this issue be resolved. > > Thank you > Norm ___ 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.
[GNC] Expense distribution main and sub accounts
Hello, I have set up gnu cash for an association. The acc set up is a master account for the managing body and 6 sub accounts for all the associate bodies. All the income & expenses are entered in the sub associate account. The all works well with each sub body balancing The difficulty I am having is when I have and expense from a sub account payable to the managing body account. The expense is rent. If I expense against the sub body acc I require it to expense to be subtracted from the sub body account and added to the main body account without duplicating the expense. Currently I can only show it in either the managing acc or associate account. Can this issue be resolved. Thank you Norm ___ 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] Assistance on transition from one OS to another
> On Jun 18, 2019, at 8:05 PM, David T. via gnucash-user > wrote: > > Hello, > I am a long time user of gnucash on a Mac, and am now transitioning to either > windows or linux; I'm still sorting out which. > This message is decidedly NOT a request for anyone's input on that choice, > however. > What I am trying to figure out is how to get the many customized preferences > I have made over the years-- such as colors for specific accounts or the > screen layout-- migrated from my Mac to the new OS. > I see from the wiki that there are basically four classes of supporting files > location, although one (GTK_DATA_HOME) is blank in all OSes. > I believe that I must copy the files I find in my Mac at these four locations > into their correlating locations on the destination OS, (e.g., copy > ~/Library/Application Support/Gnucash/.local/share/gtk3.0/settings.ini to > c:\users\david\AppData\Local\gtk-3.0\settings.ini) to but I'd like > confirmation that I have this right. > TIA,David T. David, There are three pieces to that puzzle. The easier two are the application state and any Gtk styling that you've applied: Simply copy the files to the corresponding locations on the new system, according to the Configuration Locations wiki article. [1] The third, preferences, is hard because all three platforms store their preferences in different ways. MacOS uses a special XML file called a Property List (located in ~/Library/Preferences/org.gnucash.gnucash). MS Windows uses the registry, and Linux uses an ini-style file in $XDG_HOME/dconf that appears to contain all of the preferences for all applications on the system. The piece of Glib that we use for that, GSettings [2], exposes no API for converting one to another. Each is a well-defined structure and since MacOS property lists are XML the logical tool to use for transformation is XSLT, but no pre-written "stylesheets" showed up when I googled. Regards, John Ralls [1] https://wiki.gnucash.org/wiki/Configuration_Locations [2] https://developer.gnome.org/gio/stable/settings.html ___ 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.
[GNC] Assistance on transition from one OS to another
Hello, I am a long time user of gnucash on a Mac, and am now transitioning to either windows or linux; I'm still sorting out which. This message is decidedly NOT a request for anyone's input on that choice, however. What I am trying to figure out is how to get the many customized preferences I have made over the years-- such as colors for specific accounts or the screen layout-- migrated from my Mac to the new OS. I see from the wiki that there are basically four classes of supporting files location, although one (GTK_DATA_HOME) is blank in all OSes. I believe that I must copy the files I find in my Mac at these four locations into their correlating locations on the destination OS, (e.g., copy ~/Library/Application Support/Gnucash/.local/share/gtk3.0/settings.ini to c:\users\david\AppData\Local\gtk-3.0\settings.ini) to but I'd like confirmation that I have this right. TIA,David 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 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] I just don't understand reconciliation
On 6/18/19 5:23 PM, Adrien Monteleone wrote: If you ARE balanced (‘Difference’ = $0.00) then you don’t*need* to ‘balance’ anything, you need to `Finish` the reconciliation. I know you are averse to it, but reading the manual would have saved you and everyone else lots of time and confusion. I did read it. It bounced off me. Heck, just hovering over the button and waiting a second for the tool-tip would have explained it for you. Glad it is seeping in... Regards, Adrien I had to create a bogus account and try things out. Then ask a lot of questions ___ 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] New computer to set up gnucash and migrate from old.
"Please trim your replies when replying to a digest. The easiest way to do that for most mail clients is to first highlight the relevant part you are replying to, then hit the `Reply-all` or `Reply-list` buttons. The new mail will only quote what you have highlighted rather than 14 feet worth of messages. Regards, Adrien" Thanks, Adrien. Unfortunately, I have to copy & paste. I realized after my last reply that I should have trimmed the list. Bruce Preach the Gospel wherever you go. If necessary, use words. ___ 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] I just don't understand reconciliation
On 6/18/19 5:14 PM, Stephen M. Butler wrote: I think you are trying to overthink this and making it much more complicated on yourself. I am thinking you are 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 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] I just don't understand reconciliation
On 6/18/19 5:19 PM, Adrien Monteleone wrote: Do you not get your paper statements within 7-10 days of the end of the closing date? yes ___ 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] I just don't understand reconciliation
If you ARE balanced (‘Difference’ = $0.00) then you don’t *need* to ‘balance’ anything, you need to `Finish` the reconciliation. I know you are averse to it, but reading the manual would have saved you and everyone else lots of time and confusion. Heck, just hovering over the button and waiting a second for the tool-tip would have explained it for you. Glad it is seeping in... Regards, Adrien > On Jun 18, 2019, at 7:15 PM, ToddAndMargo via gnucash-user > wrote: > > On 6/18/19 5:05 PM, Adrien Monteleone wrote: >>> On Jun 18, 2019, at 6:58 PM, ToddAndMargo via gnucash-user >>> wrote: >>> >>> >>> >>> 2) use Balance with the starting date of my current >>> statement, so a month behind. >>> >> No, no, no, no. >> Do *NOT* use the balance button unless the ‘Difference’ is something OTHER >> THAN $0.00 after checking off all transactions that match the statement. >> That button is ONLY to be used as a ‘shortcut’ to create a transaction that >> balances you when you don’t balance. You could just as well create that >> transaction manually, and likely shouldn’t do either one. You should figure >> out WHY you don’t balance and FIX that. >> If you entered the correct opening balance, correct ending balance, and >> checked off all and ONLY those transactions that matched the statement >> (since the last reconciliation) then you should balance. >> If not, then either you or the bank has an error and that error needs to be >> found. The `Balance` button is for when you know the error is yours and you >> give up trying to find and correct it. >> Regards, >> Adrien > > Thank you Adrian. I FINALLY am getting it. > > Part of the problem is "balance" to me means something > else to GnuCash. I am looking for agreement of my > statements open and closing balance. Not what is missing. > > I wonder if Bozo is mad at me for letting everyone know > what he paid for his nose? Hmmm. > ___ 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] I just don't understand reconciliation
> On Jun 18, 2019, at 7:11 PM, ToddAndMargo via gnucash-user > wrote: > > >> Long delivery times make tracking charges/clearings more cumbersome, but not >> impossible. Reconciliation isn’t concerned with that though. >> The *purpose* of reconciliation is not to reconcile the transactions, it is >> to reconcile the ENDING BALANCE as of the statement date. > > I am going to ignore that as it throws me back into a state of confusion. It would help considerably if you understood what ‘reconciliation’ means with respect to bank/charge accounts. You’re going to be taking that rock and banging it into granite until you do. It is apparent you are seeing this as a transaction clearing process when it is not. > > I will just think I can't "Finish" the reconcile until > it appears on my statement, even if it is a month late > arriving. Nothing wrong with that. But what do you mean by ‘month late?’ Do you not get your paper statements within 7-10 days of the end of the closing date? > > Part of this is that I am involved in computer security. > I do not do any on line banking as I has seen the > result. (By the way, use a charge card, not a debit card. > You have no protection with a debit card and if it gets > hacked, they have your bank account too.) So you > are expecting me to know my statement in "real time", > not once a month. Not at all. This process was built on once-per month statements. The ‘clearing’ function is separate from reconciliation and *can* happen daily/weekly/whatever, or happen as *part of* the reconciliation process. > > Just out of curiosity, when you don't balance and > you know the bank is right and you are wrong, but > can find your mistake, can you use that spurious entry > as an "adjusting journal entry”? If you “can” find your mistake, you should fix it, then Finish the reconciliation. If you “can’t” find your mistake, then yes, you can use the `Balance` button as a shortcut to create a balancing transaction so that you can `Finish` the reconciliation. (recall my suggestion to use an Expenses:Miscellaneous:Balancing account for this if you like). That is the sole purpose of the `Balance` button. 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 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] I just don't understand reconciliation
On 6/18/19 5:05 PM, Adrien Monteleone wrote: On Jun 18, 2019, at 6:58 PM, ToddAndMargo via gnucash-user wrote: 2) use Balance with the starting date of my current statement, so a month behind. No, no, no, no. Do *NOT* use the balance button unless the ‘Difference’ is something OTHER THAN $0.00 after checking off all transactions that match the statement. That button is ONLY to be used as a ‘shortcut’ to create a transaction that balances you when you don’t balance. You could just as well create that transaction manually, and likely shouldn’t do either one. You should figure out WHY you don’t balance and FIX that. If you entered the correct opening balance, correct ending balance, and checked off all and ONLY those transactions that matched the statement (since the last reconciliation) then you should balance. If not, then either you or the bank has an error and that error needs to be found. The `Balance` button is for when you know the error is yours and you give up trying to find and correct it. Regards, Adrien Thank you Adrian. I FINALLY am getting it. Part of the problem is "balance" to me means something else to GnuCash. I am looking for agreement of my statements open and closing balance. Not what is missing. I wonder if Bozo is mad at me for letting everyone know what he paid for his nose? Hmmm. ___ 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] I just don't understand reconciliation
On 6/18/19 4:50 PM, ToddAndMargo via gnucash-user wrote: > On 6/18/19 4:43 PM, Ronal B Morse wrote: > > I can user the thing in the lower right corner. Other > wise I have to wait from the next statement to arrive to > reconcile those that did not make it to the current statement. And that is how reconciliation works. Just do it manually on the back of the bank statement they supply on which you list the outstanding deposits and checks (if you have any in your register after the statement date). Similar for the credit card statements. If the charges aren't on the statement then they are still outstanding and should not be reconciled for this statement. Once I get the outstanding balance to zero, then pressing the finish button doesn't generate any new transactions. It also makes all those items checked into 'reconciled' -- I believe that is a 'y'. I think you are trying to overthink this and making it much more complicated on yourself. --Steve -- 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 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] I just don't understand reconciliation
On 6/18/19 5:07 PM, Adrien Monteleone wrote: It isn’t adding it without you telling it to, which you are doing when you click the `Balance` button when you should not be, because you are already balanced. Oh It was a surprise the first time. Now I expect and avoid it. Bozo's account gets a lot of abuse. ___ 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] I just don't understand reconciliation
On 6/18/19 5:00 PM, Adrien Monteleone wrote: To add on one more tidbit for an anticipated question: What ??? Me??? I realize I can be thick as a rock at times. It isn’t very likely that a charge will take more than 24 hours to settle. (business sales charged on delivery with long lead times would be different of course) You might have a few that will be charged at the end of one period and not clear till the next. But those aren’t included on that statement, so they might be ‘cleared’ but not ‘reconciled’ till the next statement because they aren’t part of that ending balance calculation. That is perfectly normal. The Sun has continued to rise every day despite this fact. It just took a bit to sink in. Knowledge has a hard time passing through rock. Long delivery times make tracking charges/clearings more cumbersome, but not impossible. Reconciliation isn’t concerned with that though. The *purpose* of reconciliation is not to reconcile the transactions, it is to reconcile the ENDING BALANCE as of the statement date. I am going to ignore that as it throws me back into a state of confusion. I will just think I can't "Finish" the reconcile until it appears on my statement, even if it is a month late arriving. Part of this is that I am involved in computer security. I do not do any on line banking as I has seen the result. (By the way, use a charge card, not a debit card. You have no protection with a debit card and if it gets hacked, they have your bank account too.) So you are expecting me to know my statement in "real time", not once a month. Just out of curiosity, when you don't balance and you know the bank is right and you are wrong, but can find your mistake, can you use that spurious entry as an "adjusting journal entry"? ___ 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] I just don't understand reconciliation
> On Jun 18, 2019, at 7:02 PM, ToddAndMargo via gnucash-user > wrote: > > On 6/18/19 4:56 PM, Maf. King wrote: >> I'm slightly confused as to why dispatch dates matter in an accounting >> program. It almost sounds like you are trying to use the reconcile workflow >> for something that is not. > > Just trying to get everything inside the balance date. You check off everything on the statement. That means it is ‘inside the balance date’ - as it is part of the math that moves you from Opening Balance to Closing Balance. The actual dates in your register are generally, irrelevant. > > > > I used the "finish" button on one of my checking accounts, but > then again everything had passed on the statement. Got > lots of nice "y"’s. That’s how it is supposed to work. > > I think I should only do finish on the opening date of > my statements and use the box on the lower right to see > if I balance with the ending date of my statement. That > it does a nice job. > Backwards. `Finish` means you want to complete and finalize the reconciliation, otherwise, you didn’t actually reconcile the closing balance, you just ‘cleared’ a bunch of transactions. It occurs as of the end of a period, not the beginning of the next. 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 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] I just don't understand reconciliation
> On Jun 18, 2019, at 6:58 PM, ToddAndMargo via gnucash-user > wrote: > > > >> It is not adding spurious transactions. Certainly not on its own. > > It is adding what I did not check off as being on the statement. > GRRR It isn’t adding it without you telling it to, which you are doing when you click the `Balance` button when you should not be, because you are already balanced. 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 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] I just don't understand reconciliation
> On Jun 18, 2019, at 6:58 PM, ToddAndMargo via gnucash-user > wrote: > > > > 2) use Balance with the starting date of my current > statement, so a month behind. > No, no, no, no. Do *NOT* use the balance button unless the ‘Difference’ is something OTHER THAN $0.00 after checking off all transactions that match the statement. That button is ONLY to be used as a ‘shortcut’ to create a transaction that balances you when you don’t balance. You could just as well create that transaction manually, and likely shouldn’t do either one. You should figure out WHY you don’t balance and FIX that. If you entered the correct opening balance, correct ending balance, and checked off all and ONLY those transactions that matched the statement (since the last reconciliation) then you should balance. If not, then either you or the bank has an error and that error needs to be found. The `Balance` button is for when you know the error is yours and you give up trying to find and correct it. 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 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] I just don't understand reconciliation
On 6/18/19 4:56 PM, Maf. King wrote: I'm slightly confused as to why dispatch dates matter in an accounting program. It almost sounds like you are trying to use the reconcile workflow for something that is not. Just trying to get everything inside the balance date. I do not use the "balance" button for anything except Bozo's throw away account to see what happens. I used the "finish" button on one of my checking accounts, but then again everything had passed on the statement. Got lots of nice "y"'s. I think I should only do finish on the opening date of my statements and use the box on the lower right to see if I balance with the ending date of my statement. That it does a nice job. ___ 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] I just don't understand reconciliation
To add on one more tidbit for an anticipated question: It isn’t very likely that a charge will take more than 24 hours to settle. (business sales charged on delivery with long lead times would be different of course) You might have a few that will be charged at the end of one period and not clear till the next. But those aren’t included on that statement, so they might be ‘cleared’ but not ‘reconciled’ till the next statement because they aren’t part of that ending balance calculation. That is perfectly normal. The Sun has continued to rise every day despite this fact. Long delivery times make tracking charges/clearings more cumbersome, but not impossible. Reconciliation isn’t concerned with that though. The *purpose* of reconciliation is not to reconcile the transactions, it is to reconcile the ENDING BALANCE as of the statement date. Regards, Adrien > On Jun 18, 2019, at 6:54 PM, Adrien Monteleone > wrote: > > YES! That’s how it works. Unless you want to verify it online, then you can > ‘c’ them earlier and likely just enter an ending balance and then click > `Finish` when the statement comes in. (maybe check off a few cleared items in > the interim to make sure you balance) > > But that really isn’t a ‘month behind’. You’ll probably get the statement a > few days after the period close. If you get it electronically, maybe even > same day or next day. Reconcile is a PERIOD process. So you can’t do it till > the period ends. > > Regards, > Adrien > >> On Jun 18, 2019, at 6:47 PM, ToddAndMargo via gnucash-user >> wrote: >> >>> >> >> So basically, I need t wait for my next statement to come to "c" the >> charges that did not make it on the current statement. So reconcile will >> always be a month behind. >> > ___ 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] I just don't understand reconciliation
On 6/18/19 4:36 PM, Adrien Monteleone wrote: Adrian, If it add spurious entries for translations that have not passed during the date periods I am checking, it is useless. It would only work if I altered all my charge dates to their actual post date. That I DO NOT WANT. The box in the lower right corner of the reconcile field is very useful. The reconcile feature is not. I will just use that and press cancel when I am happy -T You didn’t even really read my reply did you? I did It is not adding spurious transactions. Certainly not on its own. It is adding what I did not check off as being on the statement. GRRR I noted in the other reply that you are probably clicking the `Balance` button when you should not be. THAT is the problem. Wait an extra month to get those charges that did not pass on the current month Your actual charge dates don’t need to match their cleared/posting dates to complete the reconciliation. Why do you think they need to? If I do that, then I could reconcile as the date would be inside the statement period. I do not what to do that. Maybe what I should do is what I have been doing, which is to 1) use the box on the lower right of the reconcile dialog to see if I balance with my ending date of my current statement and 2) use Balance with the starting date of my current statement, so a month behind. ___ 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] I just don't understand reconciliation
On Wednesday, 19 June 2019 00:47:26 BST ToddAndMargo via gnucash-user wrote: > On 6/18/19 4:27 PM, Adrien Monteleone wrote: > >> On Jun 18, 2019, at 6:11 PM, ToddAndMargo via gnucash-user > >> wrote:>> > >> On 6/18/19 3:41 AM, Maf. King wrote: > >>> Things these days are generally much more instant, although sometimes > >>> not as>>> > >>> instant as we might like. > >>> HTH, > >>> Maf > >> > >> Not really. > >> > >> By law, folks that take credit crds in the USA are not allowed > >> to charge you until the item ships or gets processed. Sometimes > >> that is the same day and sometimes that is weeks away, depending > >> on back orders. Parts I purchase through my distrubutors for > >> my business often get posted four or five days AFTER I receive > >> the parts. > > > > Understood. Thousands of businesses operate this way. I’m familiar with > > it. > > > >> So, I need to know when the charge was made and I need to "C" it > >> off when it posts. I need to only check that my beginning > >> balance and my ending balance on my statement agrees, meaning > >> I did not typo or forget to enter anything. > > > > You can do that. Some people are in the habit of checking their accounts > > daily. When doing so, you can ‘c’ those transactions that have settled > > and they will be automatically ‘checked’ for you when you reconcile.> > >> So far I think reconcile is useless, except for the box in > >> the lower right corner, which tells me I am balanced. That > >> is useful! > > > > Reconciliation is a final ‘verification’ *when you receive your > > monthly/period statement* that previously cleared transactions are WHY > > the balance changed from opening amount to closing amount.> > >> Adding a stupid entry for a charge that I can not "C" off > >> is really mind splitting. > > > > You shouldn’t need to enter a balancing transaction unless you aren’t > > balanced. And if you need to enter it, you *must* check it off (either > > via ‘c’ in the register or the checkbox in the reconciliation window) in > > order to Finish the Reconciliation. > > > > If you are ‘balanced’ after checking all ‘cleared/posted’ transactions, > > then DO NOT CLICK THE `Balance` BUTTON. (you didn’t read the manual did > > you? nor waited for the tool-tip when you hovered over the button) > > > > If you are ‘balanced’ then click the `Finish` button. > > > > But you can’t “Finish” if you are not balanced. (bottom right figure for > > ‘Difference’ is $0.00) > > > > Regards, > > Adrien > > So basically, I need t wait for my next statement to come to "c" the > charges that did not make it on the current statement. So reconcile > will always be a month behind. > You can "c" at any time by clicking in the register. (say, you've seen an online list of transactions and you see some have been processed) you need to wait for the statement to turn the n or c to a y. You can only agree with a statement when the bank have produced it... repeat - don't use the "balance" button - it isn't what you want in this case. I'm slightly confused as to why dispatch dates matter in an accounting program. It almost sounds like you are trying to use the reconcile workflow for something that is not. But I might be reading between the lines there. Maf. ___ 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] I just don't understand reconciliation
YES! That’s how it works. Unless you want to verify it online, then you can ‘c’ them earlier and likely just enter an ending balance and then click `Finish` when the statement comes in. (maybe check off a few cleared items in the interim to make sure you balance) But that really isn’t a ‘month behind’. You’ll probably get the statement a few days after the period close. If you get it electronically, maybe even same day or next day. Reconcile is a PERIOD process. So you can’t do it till the period ends. Regards, Adrien > On Jun 18, 2019, at 6:47 PM, ToddAndMargo via gnucash-user > wrote: > >> > > So basically, I need t wait for my next statement to come to "c" the > charges that did not make it on the current statement. So reconcile will > always be a month behind. > ___ 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] I just don't understand reconciliation
On 6/18/19 4:43 PM, Ronal B Morse wrote: What Adrian said. Once you understand this, then reconciliation will make perfect sense, and you will never, ever press the "balance" button (where that extra transaction you don't want came from) again. Ron Apologies, Adrien. You were the victim of an apparent auto- correct plot against everyone who spells your first name correctly. RBM I can user the thing in the lower right corner. Other wise I have to wait from the next statement to arrive to reconcile those that did not make it to the current statement. ___ 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] I just don't understand reconciliation
Thanks. I suspected as much, and it usually doesn’t bother me. But it has only happened on very rare occasion, except one particular user who just doesn’t bother to either notice, or fix it. Regards, Adrien > On Jun 18, 2019, at 6:43 PM, Ronal B Morse wrote: > >> What Adrian said. Once you understand this, then >> reconciliation will make perfect sense, and you will never, >> ever press the "balance" button (where that extra >> transaction >> you don't want came from) again. >> >> Ron >> > Apologies, Adrien. You were the victim of an apparent auto- > correct plot against everyone who spells your first name > correctly. > > RBM ___ 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] I just don't understand reconciliation
On 6/18/19 4:27 PM, Adrien Monteleone wrote: On Jun 18, 2019, at 6:11 PM, ToddAndMargo via gnucash-user wrote: On 6/18/19 3:41 AM, Maf. King wrote: Things these days are generally much more instant, although sometimes not as instant as we might like. HTH, Maf Not really. By law, folks that take credit crds in the USA are not allowed to charge you until the item ships or gets processed. Sometimes that is the same day and sometimes that is weeks away, depending on back orders. Parts I purchase through my distrubutors for my business often get posted four or five days AFTER I receive the parts. Understood. Thousands of businesses operate this way. I’m familiar with it. So, I need to know when the charge was made and I need to "C" it off when it posts. I need to only check that my beginning balance and my ending balance on my statement agrees, meaning I did not typo or forget to enter anything. You can do that. Some people are in the habit of checking their accounts daily. When doing so, you can ‘c’ those transactions that have settled and they will be automatically ‘checked’ for you when you reconcile. So far I think reconcile is useless, except for the box in the lower right corner, which tells me I am balanced. That is useful! Reconciliation is a final ‘verification’ *when you receive your monthly/period statement* that previously cleared transactions are WHY the balance changed from opening amount to closing amount. Adding a stupid entry for a charge that I can not "C" off is really mind splitting. You shouldn’t need to enter a balancing transaction unless you aren’t balanced. And if you need to enter it, you *must* check it off (either via ‘c’ in the register or the checkbox in the reconciliation window) in order to Finish the Reconciliation. If you are ‘balanced’ after checking all ‘cleared/posted’ transactions, then DO NOT CLICK THE `Balance` BUTTON. (you didn’t read the manual did you? nor waited for the tool-tip when you hovered over the button) If you are ‘balanced’ then click the `Finish` button. But you can’t “Finish” if you are not balanced. (bottom right figure for ‘Difference’ is $0.00) Regards, Adrien So basically, I need t wait for my next statement to come to "c" the charges that did not make it on the current statement. So reconcile will always be a month behind. ___ 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] I just don't understand reconciliation
> What Adrian said. Once you understand this, then > reconciliation will make perfect sense, and you will never, > ever press the "balance" button (where that extra > transaction > you don't want came from) again. > > Ron > Apologies, Adrien. You were the victim of an apparent auto- correct plot against everyone who spells your first name correctly. RBM ___ 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] I just don't understand reconciliation
On Tue, 2019-06-18 at 18:27 -0500, Adrien Monteleone wrote: > > > You shouldn’t need to enter a balancing transaction unless > you aren’t balanced. And if you need to enter it, you > *must* check it off (either via ‘c’ in the register or the > checkbox in the reconciliation window) in order to Finish > the Reconciliation. > > If you are ‘balanced’ after checking all ‘cleared/posted’ > transactions, then DO NOT CLICK THE `Balance` BUTTON. (you > didn’t read the manual did you? nor waited for the tool-tip > when you hovered over the button) > > If you are ‘balanced’ then click the `Finish` button. > > But you can’t “Finish” if you are not balanced. (bottom > right figure for ‘Difference’ is $0.00) > > Regards, > Adrien > ___ > What Adrian said. Once you understand this, then reconciliation will make perfect sense, and you will never, ever press the "balance" button (where that extra transaction you don't want came from) again. Ron ___ 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] I just don't understand reconciliation
> Adrian, > > If it add spurious entries for translations that have not passed > during the date periods I am checking, it is useless. It would > only work if I altered all my charge dates to their actual > post date. That I DO NOT WANT. > > The box in the lower right corner of the reconcile field is very > useful. The reconcile feature is not. I will just use that and > press cancel when I am happy > > -T You didn’t even really read my reply did you? It is not adding spurious transactions. Certainly not on its own. I noted in the other reply that you are probably clicking the `Balance` button when you should not be. THAT is the problem. Your actual charge dates don’t need to match their cleared/posting dates to complete the reconciliation. Why do you think they need to? Regards, Adrien p.s. -please bother to spell my name correctly if you’re going to include it. That is really annoying. It is right there in front of you at the bottom of each of my replies. ___ 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] I just don't understand reconciliation
> On Jun 18, 2019, at 6:11 PM, ToddAndMargo via gnucash-user > wrote: > > On 6/18/19 3:41 AM, Maf. King wrote: >> Things these days are generally much more instant, although sometimes not as >> instant as we might like. >> HTH, >> Maf > > Not really. > > By law, folks that take credit crds in the USA are not allowed > to charge you until the item ships or gets processed. Sometimes > that is the same day and sometimes that is weeks away, depending > on back orders. Parts I purchase through my distrubutors for > my business often get posted four or five days AFTER I receive > the parts. Understood. Thousands of businesses operate this way. I’m familiar with it. > > So, I need to know when the charge was made and I need to "C" it > off when it posts. I need to only check that my beginning > balance and my ending balance on my statement agrees, meaning > I did not typo or forget to enter anything. You can do that. Some people are in the habit of checking their accounts daily. When doing so, you can ‘c’ those transactions that have settled and they will be automatically ‘checked’ for you when you reconcile. > > So far I think reconcile is useless, except for the box in > the lower right corner, which tells me I am balanced. That > is useful! Reconciliation is a final ‘verification’ *when you receive your monthly/period statement* that previously cleared transactions are WHY the balance changed from opening amount to closing amount. > > Adding a stupid entry for a charge that I can not "C" off > is really mind splitting. You shouldn’t need to enter a balancing transaction unless you aren’t balanced. And if you need to enter it, you *must* check it off (either via ‘c’ in the register or the checkbox in the reconciliation window) in order to Finish the Reconciliation. If you are ‘balanced’ after checking all ‘cleared/posted’ transactions, then DO NOT CLICK THE `Balance` BUTTON. (you didn’t read the manual did you? nor waited for the tool-tip when you hovered over the button) If you are ‘balanced’ then click the `Finish` button. But you can’t “Finish” if you are not balanced. (bottom right figure for ‘Difference’ is $0.00) 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 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] I just don't understand reconciliation
On 6/18/19 4:20 PM, Adrien Monteleone wrote: On Jun 18, 2019, at 6:04 PM, ToddAndMargo via gnucash-user wrote: On 6/18/19 3:43 AM, Maf. King wrote: Yep, the Balance button will insert a transaction into your account to make it balance with the statement finishing total. It's effectively a short cut when you can't be bothered to keep careful track of all your txns. Maf. Here is the rub. The date I make the charge and date when the charge "Posts" are often two different dates. Irrelevant to the reconciliation process. (well, for most purposes, for most transactions, there are some corner cases where it might matter.) If I where to change all my charge dates to post dates, this would not be an issue, But that makes for a nightmare to keep up. I need to know what date I placed an order and I also need to not be spending hours changing dates. You shouldn’t be changing dates during or prior to reconciliation as part of the reconciliation. Enter the transactions on their actual dates. If before reconciliation, you want to mark them as ‘cleared’ that is, posted and recognized on your account (say, viewing it online) then click the ’n’ to make it a ‘c’. When you perform the reconciliation, these transactions will be checked off for you already. (you’ve already verified they are included in the ending balance calculation - that is what “cleared” means.) As noted in the other thread, you can use the Notes field to record the posting date if you feel you really need it. You could also use the Action field if you are not otherwise using it or put that info in one of the split memo fields, likely the one assigned to the credit card accoun. (you’ll need to view splits, or use Transaction Journal view) The transactions dates in your books and the posting dates on your credit card statement *do not* have to match and likely will not. But the statement *should* allow you to see the original ‘charge’ date even though it may have settled later. (or at least the info should be available online) Why is if not using my "c" and "n" fields? Why can it just reconcile the entries I have "c" checked? It does, and then some potentially. Reconciliation is *NOT* a transaction by transaction process. It is a period to period process. It is verifying WHY the account balance changed from the opening amount to the closing amount over a time period. The individual transactions are the “why”. If the cleared transactions don’t add up to the full difference between the open/close amounts, then either you need to check off additional transactions, uncheck one of the previous assumed cleared transactions (perhaps it wasn’t really cleared) or you are missing a transaction. In that last case, you either enter the missing transaction, or use the `Balance` button to create an adjusting transaction for you. I usually assign this balancing transaction to a Expenses:Miscellaneous:Balancing account so I can either figure it out later, or else have some idea more than just Imbalance-XXX or Orphan-XXX as to why it is in my books. Otherwise, unless I am missing something really big, "reconcile" is pretty much useless. I hope it is my problem, as I can fix that. No, it is useful because it verifies periodically that your records and the bank’s records —match. That is its purpose. Regards, Adrien Adrian, If it add spurious entries for translations that have not passed during the date periods I am checking, it is useless. It would only work if I altered all my charge dates to their actual post date. That I DO NOT WANT. The box in the lower right corner of the reconcile field is very useful. The reconcile feature is not. I will just use that and press cancel when I am happy -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 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] I just don't understand reconciliation
> On Jun 18, 2019, at 6:04 PM, ToddAndMargo via gnucash-user > wrote: > > On 6/18/19 3:43 AM, Maf. King wrote: >> Yep, the Balance button will insert a transaction into your account to make >> it >> balance with the statement finishing total. It's effectively a short cut >> when >> you can't be bothered to keep careful track of all your txns. >> Maf. > > Here is the rub. The date I make the charge and date when > the charge "Posts" are often two different dates. Irrelevant to the reconciliation process. (well, for most purposes, for most transactions, there are some corner cases where it might matter.) > > If I where to change all my charge dates to post dates, this > would not be an issue, But that makes for a nightmare to > keep up. I need to know what date I placed an order and I > also need to not be spending hours changing dates. You shouldn’t be changing dates during or prior to reconciliation as part of the reconciliation. Enter the transactions on their actual dates. If before reconciliation, you want to mark them as ‘cleared’ that is, posted and recognized on your account (say, viewing it online) then click the ’n’ to make it a ‘c’. When you perform the reconciliation, these transactions will be checked off for you already. (you’ve already verified they are included in the ending balance calculation - that is what “cleared” means.) As noted in the other thread, you can use the Notes field to record the posting date if you feel you really need it. You could also use the Action field if you are not otherwise using it or put that info in one of the split memo fields, likely the one assigned to the credit card accoun. (you’ll need to view splits, or use Transaction Journal view) The transactions dates in your books and the posting dates on your credit card statement *do not* have to match and likely will not. But the statement *should* allow you to see the original ‘charge’ date even though it may have settled later. (or at least the info should be available online) > > Why is if not using my "c" and "n" fields? Why can it just > reconcile the entries I have "c" checked? It does, and then some potentially. Reconciliation is *NOT* a transaction by transaction process. It is a period to period process. It is verifying WHY the account balance changed from the opening amount to the closing amount over a time period. The individual transactions are the “why”. If the cleared transactions don’t add up to the full difference between the open/close amounts, then either you need to check off additional transactions, uncheck one of the previous assumed cleared transactions (perhaps it wasn’t really cleared) or you are missing a transaction. In that last case, you either enter the missing transaction, or use the `Balance` button to create an adjusting transaction for you. I usually assign this balancing transaction to a Expenses:Miscellaneous:Balancing account so I can either figure it out later, or else have some idea more than just Imbalance-XXX or Orphan-XXX as to why it is in my books. > > Otherwise, unless I am missing something really big, > "reconcile" is pretty much useless. I hope it is > my problem, as I can fix that. No, it is useful because it verifies periodically that your records and the bank’s records —match. That is its purpose. 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 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] I just don't understand reconciliation
On 6/18/19 3:41 AM, Maf. King wrote: Things these days are generally much more instant, although sometimes not as instant as we might like. HTH, Maf Not really. By law, folks that take credit crds in the USA are not allowed to charge you until the item ships or gets processed. Sometimes that is the same day and sometimes that is weeks away, depending on back orders. Parts I purchase through my distrubutors for my business often get posted four or five days AFTER I receive the parts. So, I need to know when the charge was made and I need to "C" it off when it posts. I need to only check that my beginning balance and my ending balance on my statement agrees, meaning I did not typo or forget to enter anything. So far I think reconcile is useless, except for the box in the lower right corner, which tells me I am balanced. That is useful! Adding a stupid entry for a charge that I can not "C" off is really mind splitting. ___ 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] I just don't understand reconciliation
On 6/18/19 3:43 AM, Maf. King wrote: Yep, the Balance button will insert a transaction into your account to make it balance with the statement finishing total. It's effectively a short cut when you can't be bothered to keep careful track of all your txns. Maf. Here is the rub. The date I make the charge and date when the charge "Posts" are often two different dates. If I where to change all my charge dates to post dates, this would not be an issue, But that makes for a nightmare to keep up. I need to know what date I placed an order and I also need to not be spending hours changing dates. Why is if not using my "c" and "n" fields? Why can it just reconcile the entries I have "c" checked? Otherwise, unless I am missing something really big, "reconcile" is pretty much useless. I hope it is my problem, as I can fix that. ___ 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] extra column?
>> On Jun 18, 2019, at 4:19 AM, ToddAndMargo via gnucash-user wrote: >> >> Hi All, >> >> On my credit card registries, is it possible to add an extra >> date column where I can put Post Date? >> >> >> Many thanks, >> -T On 6/18/19 5:24 AM, Adrien Monteleone wrote: No, you can’t just add stuff to the UI, but you can turn on Double Line mode in the View menu which will reveal a transaction-wide ‘Notes’ field and put it there. Regards, Adrien Rats! I was hoping for an extra column. Thank you anyway! ___ 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] CSV to QIF for Citibank
On Mon, Jun 17, 2019 at 9:38 PM David Carlson wrote: > If you have been having issues with notes in OFX imports, there were a > couple of bugs in that area that were just fixed for release 3.6. They > should already be in the Windows nightly builds. Try OFX again when you > have the updates. > Thanks. I'll give it a shot. -- Home: http://nlphilia.com * Blog: http://nlphilia.net Registered Linux User #450983 * Ubuntu Counter Project #10548 ___ 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] New computer to set up gnucash and migrate from old.
Bruce, Please trim your replies when replying to a digest. The easiest way to do that for most mail clients is to first highlight the relevant part you are replying to, then hit the `Reply-all` or `Reply-list` buttons. The new mail will only quote what you have highlighted rather than 14 feet worth of messages. Regards, Adrien > On Jun 18, 2019, at 7:49 AM, Bruce Irving via gnucash-user > wrote: > > Randy:"You would thing gnucash would build in a > backup/export/import function."It does have a backup function: every time it > saves the data, it renames the old one with the date and time. They are still > in the data folder. If I remember correctly, GC saves these for 30 days, > unless you changed it Yes, I would like to see export/import functions that > don't rely on some special format. > > Bruce Preach the Gospel wherever you go. If necessary, use words. ___ 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] New computer to set up gnucash and migrate from old.
Thanks for additional insight. On Tue, Jun 18, 2019 at 9:15 AM Mike or Penny Novack < stepbystepf...@comcast.net> wrote: > On 6/17/2019 7:29 PM, Randy Rosebrock wrote: > > I'll check it out. You would thing gnucash would build in a > > backup/export/import function. > > You are slightly misunderstanding the problems because you are thinking > of gnucash as being used to keep only one set of books. Also, gnucash > keeps a list of the last four books open and if not otherwise instructed > will try to open the last that was open. > > Many of us who keep multiple sets of books turn that off. We are having > gnucash start without opening any set of books and then explicitly > telling it which to open. Particularly after migrating to a new computer > with different OS, even if you have only one set of books the "last > open" might not be found << path is different >> > > file => open will let you CHOOSE the file (set of books) that you want > gnucash to open. > > Michael D Novack > > PS: The issue of preferences/settings IF these are to be different for > the different sets of books is most easily solved by having them under > different users (different computer logins). Just because you are one > human being doesn't mean that your computer knows that. > ___ > 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. > -- Randy ___ 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] New computer to set up gnucash and migrate from old.
On Tuesday, 18 June 2019 00:29:24 BST Randy Rosebrock wrote: > I'll check it out. You would thing gnucash would build in a > backup/export/import function. > Why? Does MS Word or Keynote or any other application have an extensive backup function (beyond autosave, of course) How have you moved all the letters that you've written and photos that you have from old to new PC? GC is really a very similar process. GC is far better at backing up your data on each run than most other programs, it is *quite* good at import (given the closed nature of most of the candidate formats). granted, export is maybe more lacking, but I think you can get to CSV quite easily these days, and your datafile is stored as plain XML (nearly human- readable) text. 0.02 Maf. ___ 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] New computer to set up gnucash and migrate from old.
On 6/17/2019 7:29 PM, Randy Rosebrock wrote: I'll check it out. You would thing gnucash would build in a backup/export/import function. You are slightly misunderstanding the problems because you are thinking of gnucash as being used to keep only one set of books. Also, gnucash keeps a list of the last four books open and if not otherwise instructed will try to open the last that was open. Many of us who keep multiple sets of books turn that off. We are having gnucash start without opening any set of books and then explicitly telling it which to open. Particularly after migrating to a new computer with different OS, even if you have only one set of books the "last open" might not be found << path is different >> file => open will let you CHOOSE the file (set of books) that you want gnucash to open. Michael D Novack PS: The issue of preferences/settings IF these are to be different for the different sets of books is most easily solved by having them under different users (different computer logins). Just because you are one human being doesn't mean that your computer knows that. ___ 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] New computer to set up gnucash and migrate from old.
Randy:"You would thing gnucash would build in a backup/export/import function."It does have a backup function: every time it saves the data, it renames the old one with the date and time. They are still in the data folder. If I remember correctly, GC saves these for 30 days, unless you changed it Yes, I would like to see export/import functions that don't rely on some special format. Bruce Preach the Gospel wherever you go. If necessary, use words. On Monday, June 17, 2019, 11:47:34 PM MDT, gnucash-user-requ...@gnucash.org wrote: Send gnucash-user mailing list submissions to gnucash-user@gnucash.org To subscribe or unsubscribe via the World Wide Web, visit https://lists.gnucash.org/mailman/listinfo/gnucash-user or, via email, send a message with subject or body 'help' to gnucash-user-requ...@gnucash.org You can reach the person managing the list at gnucash-user-ow...@gnucash.org When replying, please edit your Subject line so it is more specific than "Re: Contents of gnucash-user digest..." Today's Topics: 1. Re: New computer to set up gnucash and migrate from old. (Randy Rosebrock) 2. Re: CSV to QIF for Citibank (David Carlson) 3. Re: Switch to Account that a Transfer is from by Keyboard (David Carlson) 4. Re: Switch to Account that a Transfer is from by Keyboard (Stan Brown) 5. Re: Switch to Account that a Transfer is from by Keyboard (Adrien Monteleone) 6. I just don't understand reconciliation (ToddAndMargo) -- Message: 1 Date: Mon, 17 Jun 2019 19:29:24 -0400 From: Randy Rosebrock To: Bruce Irving Cc: "stepbystepf...@comcast.net" , "gnucash-user@gnucash.org" Subject: Re: [GNC] New computer to set up gnucash and migrate from old. Message-ID: Content-Type: text/plain; charset="UTF-8" I'll check it out. You would thing gnucash would build in a backup/export/import function. On Mon, Jun 17, 2019 at 6:20 PM Bruce Irving wrote: > I was running GC 2.6.19 on to win10 PCs. The hard drive started to fail > and the shop was able to save the files before replacing the drive and > installing Win10 one the new one. Since I have two clubs plus my own > files, I've always started by double-clicking the data file which was > located in a folder called qnucash where my other files for this entity was > located. Then I installed GC (I believe 3.?) and copied the file that > ended with .gnucash to the appropriate folder and double clicked to start > it. Of course, I had to set GC up the way I wanted but it had all of my > transactions. > Unfortunately, it wasn't until later that I discovered that the > configuration files: > 09/30/2018 05:04 PM . > 09/30/2018 05:04 PM .. > 06/12/2019 05:43 AM 21,415 accelerator-map > 12/26/2018 01:13 PM books > 02/09/2018 06:59 PM checks > 06/12/2019 05:43 AM 0 expressions-2.0 > 05/20/2019 10:03 AM 13,241 saved-reports-2.4 > 05/20/2019 10:03 AM 13,225 saved-reports-2.4-backup > 06/12/2019 05:43 AM 1,345 stylesheets-2.0 > 02/09/2018 06:59 PM translog > 5 File(s) 49,226 bytes > located in C:\users/[user name]. > Hope this helps. > Oh! My compliments to the developers. The new version corrects a couple > of issues that the old one had. Thanks. > > Bruce > Preach the Gospel wherever you go. > If necessary, use words. > > > > From: Randy Rosebrock > > To: stepbystepf...@comcast.net > Cc: gnucash-user@gnucash.org > Subject: Re: [GNC] New computer to set up gnucash and migrate from > old. > Message-ID: > > Content-Type: text/plain; charset="UTF-8" > > Under normal default install where are these files location I need to copy > from? > > On Mon, Jun 17, 2019 at 8:49 AM Mike or Penny Novack < > stepbystepf...@comcast.net> wrote: > > > On 6/16/2019 5:41 PM, Adrien Monteleone wrote: > > > Randy, > > > > > > If the old computer still runs at all, you can network them together > and > > use the Windows User Migration feature. (not certain of the exact name, > but > > that term should get you close in a search engine) It will move all of > your > > data and settings as part of your user account. (you get to fine tune > what > > it migrates as well) > > > > > > Regards, > > > Adrien > > > > > << I often leave things out >> > > > > I did not describe this for the simple reason that even if you do not > > make regular backups THIS is a situation where you would want a full > > backup. In other words, when migrating to a new computer you would > > almost always want to copy ALL your user data to an external device > > (your external backup drive) and then you would copy from that to where > > user data goes on your new computer. > > > > Michael D Novack > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org >
Re: [GNC] Switch to Account that a Transfer is from by Keybo
Sorry, I posted too soon. Perhaps this would be two RFE bugs: 1. Document the context menu 2. Document the mnemonics and how to make them visible. (no need to even reference Gtk+ at all) Regards, Adrien > On Jun 18, 2019, at 7:29 AM, Adrien Monteleone > wrote: > > No, I mean that the context menu doesn’t appear to be documented at all. I > don’t see any reference to it in the Help manual. The mnemonics are there in > the UI, just not visible in 3.x until you press the activator key. (this fact > *is* documented on the Wiki, but the menu itself is still not, so far as I > can tell.) > >> On Jun 18, 2019, at 3:46 AM, David T. wrote: >> >> Adrien, >> >> Because this is specifically a situation that resulted from GTK, I would be >> reluctant to add language to the Gnucash documentation. >> >> David T. >> >> >> On Tue, Jun 18, 2019 at 8:29, Adrien Monteleone >> wrote: >> Yes, the Gtk+ version which changed this was implemented for 3.0. >> >> Regards, >> Adrien >> >>> On Jun 17, 2019, at 9:00 PM, Stan Brown wrote: >>> >>> The underlines are visible without my pressing any keys. (This is GC >>> 2.6.19 on Windows 7.) >>> >>> Alt+A, J works for me just as David says. >>> >>> >>> -- >>> Regards, >>> Stan Brown ___ 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] Switch to Account that a Transfer is from by Keybo
No, I mean that the context menu doesn’t appear to be documented at all. I don’t see any reference to it in the Help manual. The mnemonics are there in the UI, just not visible in 3.x until you press the activator key. (this fact *is* documented on the Wiki, but the menu itself is still not, so far as I can tell.) > On Jun 18, 2019, at 3:46 AM, David T. wrote: > > Adrien, > > Because this is specifically a situation that resulted from GTK, I would be > reluctant to add language to the Gnucash documentation. > > David T. > > > On Tue, Jun 18, 2019 at 8:29, Adrien Monteleone > wrote: > Yes, the Gtk+ version which changed this was implemented for 3.0. > > Regards, > Adrien > > > On Jun 17, 2019, at 9:00 PM, Stan Brown wrote: > > > > The underlines are visible without my pressing any keys. (This is GC > > 2.6.19 on Windows 7.) > > > > Alt+A, J works for me just as David says. > > > > > > -- > > Regards, > > Stan Brown ___ 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] extra column?
No, you can’t just add stuff to the UI, but you can turn on Double Line mode in the View menu which will reveal a transaction-wide ‘Notes’ field and put it there. Regards, Adrien > On Jun 18, 2019, at 4:19 AM, ToddAndMargo via gnucash-user > wrote: > > Hi All, > > On my credit card registries, is it possible to add an extra > date column where I can put Post Date? > > > Many thanks, > -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 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] Switch to Account that a Transfer is from by Keybo
David T, I disagree. If we did not mention how Windows or Mac affects the use of GnuCash, users would be completely lost. We can point out that GTK causes this or that artifact, so the user knows why he has to do something differently than in some other programs David Carlson. On Tue, Jun 18, 2019 at 3:48 AM David T. via gnucash-user < gnucash-user@gnucash.org> wrote: > Adrien, > Because this is specifically a situation that resulted from GTK, I would > be reluctant to add language to the Gnucash documentation. > David T. > > > > On Tue, Jun 18, 2019 at 8:29, Adrien Monteleone< > adrien.montele...@lusfiber.net> wrote: Yes, the Gtk+ version which > changed this was implemented for 3.0. > > Regards, > Adrien > > > On Jun 17, 2019, at 9:00 PM, Stan Brown > wrote: > > > > The underlines are visible without my pressing any keys. (This is GC > > 2.6.19 on Windows 7.) > > > > Alt+A, J works for me just as David says. > > > > > > -- > > Regards, > > Stan Brown > > > ___ > 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. > > ___ > 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. > -- 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 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] Switch to Account that a Transfer is from by Keyboard
I've mostly been lurking rather than posting, but I've lost count of the number of things that used to be better in 2.x.x and now don't work as well in 3.x.x because of GTK. It's proof that "latest and greatest" can be an oxymoron. -- Regards, Stan Brown Tompkins County, New York, USA http://BrownMath.com http://OakRoadSystems.com On 2019-06-17 22:56, Adrien Monteleone wrote: > Yes, the Gtk+ version which changed this was implemented for 3.0. > > Regards, > Adrien > >> On Jun 17, 2019, at 9:00 PM, Stan Brown wrote: >> >> The underlines are visible without my pressing any keys. (This is GC >> 2.6.19 on Windows 7.) >> >> Alt+A, J works for me just as David says. ___ 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] I just don't understand reconciliation
Yep, the Balance button will insert a transaction into your account to make it balance with the statement finishing total. It's effectively a short cut when you can't be bothered to keep careful track of all your txns. Maf. On Tuesday, 18 June 2019 10:43:19 BST ToddAndMargo via gnucash-user wrote: >On 6/18/19 1:53 AM, David T. wrote: > >Michael, > >I believe that ToddAndMargo clicked the "Reconcile" button in the >reconcile window, which is designed to create a balancing entry when >your reconciling doesn't work. > >ToddAndMargo, Michael's suggestion to click the "Finish" button might >be more successful for you. > >David T. > >I clicked this one first: >Then this one: -- Maf. King PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7 2B7C E591 E8E1 0DE7 C542 ___ 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] I just don't understand reconciliation
On Tuesday, 18 June 2019 10:45:17 BST ToddAndMargo wrote: > On 6/18/19 1:54 AM, Maf. King wrote: > > Finish will be greyed out until you get the "difference" to 0 > > > 7 is what it suppose to ber! > No it isn't. the £7 is either on you bank statement or is not (yet, because the bank haven't processed it (- perhaps they never will & you'll get lucky!)) You "reconcile" ie. "check that you agree with each transaction that appears on" your bank statement, and ensure that the bank haven't made a payment twice or got some digits wrong. that does not mean that the bank know all about every transaction you have made instantly that you make it you are checking the bank is right in what they have done, but not that they have done everything. Also, they are not checking that you are right. I suppose it is a bit of a hang-over from pre-electronic transaction days - where cheques could sit for days in the post or on someone's desk. You know that you've written that check (hence spent the money), but the bank may take days or weeks to catch up with your better knowledge of what transactions you have made. Things these days are generally much more instant, although sometimes not as instant as we might like. HTH, Maf ___ 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] I just don't understand reconciliation
On 6/18/19 1:54 AM, Maf. King wrote: Finish will be greyed out until you get the "difference" to 0 7 is what it suppose to ber! It is not checked off! ___ 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] I just don't understand reconciliation
On 6/18/19 1:53 AM, David T. wrote: Michael, I believe that ToddAndMargo clicked the "Reconcile" button in the reconcile window, which is designed to create a balancing entry when your reconciling doesn't work. ToddAndMargo, Michael's suggestion to click the "Finish" button might be more successful for you. David T. I clicked this one first: Then this one: ___ 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.
[GNC] extra column?
Hi All, On my credit card registries, is it possible to add an extra date column where I can put Post Date? Many thanks, -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 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] I just don't understand reconciliation
On Tuesday, 18 June 2019 08:11:45 BST ToddAndMargo via gnucash-user wrote: > On 6/17/19 11:47 PM, Michael Hendry wrote: > > When you have checked the relevant entries in the reconciliation window > > (as in your third screenshot), you’ll get a difference of $0.00. > > > > Now click on the “Finish” button, and the process will be complete, with > > the transactions you have checked now marked “r”. > Finish is grayed out. > > Tears :'( > Finish will be greyed out until you get the "difference" to 0 I will note that reconcile is used to compare 2 peoples' (or bank or whatever) versions of the state of an account. it is an accounting term - read it in the sense of "check my bank and I agree about what has happened to this account" I understand that you are using bogus data to learn from, but your comment about not having to work out the ending balance by hand is an artifact of not having a real statement sent to you... If this was a real CCard account, they would have sent you a statement saying "OK, we think you've made these transactions [list] and on [6-11] the account balance is [-135]" You put into the GC reconcile box 1. the date of statement (GC will try and guess this based on previous reconcile dates - it is usually pretty close.) 2. check the opening balance (you can't change this, but if GC and your statement don't agree here, you'll need to check the previous reconciles - perhaps you missed a statement or something) 3. based on the date entered at (1.) GC will attempt to guess the statement end balance. It is usually wrong on a busy account. Correct this to the actual number on the statement. so for your tests, your imaginary statement will have arrived, with an ending balance of £135, not £128so you need to enter that into GC as you start the reconcile. The rest should flow, and you will hopefully find the finish box enabled when you have selected the txns that your "bozo card" knows about. HTH, Maf. ___ 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] I just don't understand reconciliation
Michael, I believe that ToddAndMargo clicked the "Reconcile" button in the reconcile window, which is designed to create a balancing entry when your reconciling doesn't work. ToddAndMargo, Michael's suggestion to click the "Finish" button might be more successful for you. David T. On Tue, Jun 18, 2019 at 12:38, Michael Hendry wrote: > On 18 Jun 2019, at 06:37, ToddAndMargo via gnucash-user wrote: > > Hi All, > I am confused to the point of tears. > I created a dummy account: "bozo" and "Bozo Expense". > Initial balance was $100.00 (over payment). Then I added some charges > and another payment. > I "pretend" that the 7.00 and 150.00 do not show up on my statement, so > I leave > them at "n". The rest I put at "c". > Then I hit "reconcile" and tell it the ending "statement date" is > 06/12/2019. > It correctly fills in the ending balance sans the 150.00, which is > after the > statement date. > Everything good so far. The box in the lower right is correct. the 7 > and 150 > are not "R" checked off, which is the way I want it. This simulates > things not > on the statement yet. > -135 is what my pretend bank statement would show. And is the ending > balance > of -128 would be "IF" the 7 had passed. And the difference is indeed > the 7 that did > not pass. So far I understand. Gnucash is calculating the ending balance “believing" that the $7 charge would have hit your credit card, but your imaginary credit card statement would have omitted it, leaving an ending balance of $135. You need to enter $135 in the Reconcile Information box. > Now I press "reconcile" and it inserts a weird entry into the register: When you have checked the relevant entries in the reconciliation window (as in your third screenshot), you’ll get a difference of $0.00. Now click on the “Finish” button, and the process will be complete, with the transactions you have checked now marked “r”. > AND ROYALLY SCREWS UP MY real ending BALANCE! > 1) Why did it screw up my balance I’m puzzled by this - it looks as though Gnucash was being forced to complete the reconciliation and tried to compensate for the Difference: $7.00. > 2) Why in the reconcile windows does it not pick up my "n" and "c" > entries, They both indicate “not reconciled”. When the reconciliation is correctly “Finished” they will change to “r”. > 3) why after reconciling do my "n" and "c" entries not change? The reconciliation process hadn’t actually been completed correctly. > I am so freaking confused > Someone please rescue me! > Many thanks, > -T Hope this helps! Michael > ___ > 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. ___ 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. ___ 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] Switch to Account that a Transfer is from by Keybo
Adrien, Because this is specifically a situation that resulted from GTK, I would be reluctant to add language to the Gnucash documentation. David T. On Tue, Jun 18, 2019 at 8:29, Adrien Monteleone wrote: Yes, the Gtk+ version which changed this was implemented for 3.0. Regards, Adrien > On Jun 17, 2019, at 9:00 PM, Stan Brown wrote: > > The underlines are visible without my pressing any keys. (This is GC > 2.6.19 on Windows 7.) > > Alt+A, J works for me just as David says. > > > -- > Regards, > Stan Brown ___ 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. ___ 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] I just don't understand reconciliation
> On 18 Jun 2019, at 06:37, ToddAndMargo via gnucash-user > wrote: > > Hi All, > I am confused to the point of tears. > I created a dummy account: "bozo" and "Bozo Expense". > Initial balance was $100.00 (over payment). Then I added some charges > and another payment. > I "pretend" that the 7.00 and 150.00 do not show up on my statement, so > I leave > them at "n". The rest I put at "c". > Then I hit "reconcile" and tell it the ending "statement date" is > 06/12/2019. > It correctly fills in the ending balance sans the 150.00, which is > after the > statement date. > Everything good so far. The box in the lower right is correct. the 7 > and 150 > are not "R" checked off, which is the way I want it. This simulates > things not > on the statement yet. > -135 is what my pretend bank statement would show. And is the ending > balance > of -128 would be "IF" the 7 had passed. And the difference is indeed > the 7 that did > not pass. So far I understand. Gnucash is calculating the ending balance “believing" that the $7 charge would have hit your credit card, but your imaginary credit card statement would have omitted it, leaving an ending balance of $135. You need to enter $135 in the Reconcile Information box. > Now I press "reconcile" and it inserts a weird entry into the register: When you have checked the relevant entries in the reconciliation window (as in your third screenshot), you’ll get a difference of $0.00. Now click on the “Finish” button, and the process will be complete, with the transactions you have checked now marked “r”. > AND ROYALLY SCREWS UP MY real ending BALANCE! > 1) Why did it screw up my balance I’m puzzled by this - it looks as though Gnucash was being forced to complete the reconciliation and tried to compensate for the Difference: $7.00. > 2) Why in the reconcile windows does it not pick up my "n" and "c" > entries, They both indicate “not reconciled”. When the reconciliation is correctly “Finished” they will change to “r”. > 3) why after reconciling do my "n" and "c" entries not change? The reconciliation process hadn’t actually been completed correctly. > I am so freaking confused > Someone please rescue me! > Many thanks, > -T Hope this helps! Michael > ___ > 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. ___ 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] I just don't understand reconciliation
On 6/17/19 11:47 PM, Michael Hendry wrote: When you have checked the relevant entries in the reconciliation window (as in your third screenshot), you’ll get a difference of $0.00. Now click on the “Finish” button, and the process will be complete, with the transactions you have checked now marked “r”. Finish is grayed out. Tears :'( ___ 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] I just don't understand reconciliation
On 6/17/19 11:47 PM, Michael Hendry wrote: Gnucash is calculating the ending balance “believing" that the $7 charge would have hit your credit card, but your imaginary credit card statement would have omitted it, leaving an ending balance of $135. You need to enter $135 in the Reconcile Information box. If I hand figure it out and put -128 into the Reconcile Information box, the it won't let me reconcile at all (button is grayed out). And I really do not want to figure this out by hard. Tears. :'( ___ 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.