Re: [GNC] Unreconciling
Phyllis, It is almost that simple! If you click on any of the "y" letters, they will change to "n" after warning you. After that just start a new reconciliation for whichever month is next. You can mark them "c" or not nextt if it helps you match transactions to the bank statements. On Tue, Nov 14, 2023 at 3:46 PM Phyllis Bruce wrote: > David Carlson wrote: > > "If you remember that the reconciliation ending balance was correct in > GnuCash fairly recently a process that will actually work would be to > *unreconcile* all transaction splits after a given date, then > re-reconciling > each month after that date with your bank statements handy.." > > David, I was unaware I could safely unreconcile statements! Is it a simple > matter of changing the "y" to a "c" and does that take the > reconciliation screen back to a previous reconciliation? > > I have a $219 discrepancy on a bank record and of course there is no single > transaction that got me there. I don't mind doing one account. > > Thanks much! > > Phyllis Bruce > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Unreconciling
Yes, simply change the flag from 'y' to 'c' or 'n'. ('c' - cleared will be auto-checked for you in the reconciliation window, 'n' - no, will not) It isn't so much of 'going back to a previous screen' as no such thing exists, but rather you will be re-reconciling to whatever date (and balance) you desire. There is no requirement this be done monthly or on any other periodic basis. You can reconcile, realize you need to change a reconciled transaction that changes its flag, and re-reconcile. You can give up trying to find an error, enter a balancing transaction and reconcile, then later find the error, fix it or enter a correcting entry, then remove the balancing transaction or reverse it, and re-reconcile as if you had it all correct the first time. Other than the reconciliation function being the only way to change the flag to 'y' there is no other magic that happens. It is just a tool for you to compare your books for that account to an outside source. Regards, Adrien On 11/14/23 3:45 PM, Phyllis Bruce wrote: David Carlson wrote: "If you remember that the reconciliation ending balance was correct in GnuCash fairly recently a process that will actually work would be to *unreconcile* all transaction splits after a given date, then re-reconciling each month after that date with your bank statements handy.." David, I was unaware I could safely unreconcile statements! Is it a simple matter of changing the "y" to a "c" and does that take the reconciliation screen back to a previous reconciliation? I have a $219 discrepancy on a bank record and of course there is no single transaction that got me there. I don't mind doing one account. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Unreconciling
David Carlson wrote: "If you remember that the reconciliation ending balance was correct in GnuCash fairly recently a process that will actually work would be to *unreconcile* all transaction splits after a given date, then re-reconciling each month after that date with your bank statements handy.." David, I was unaware I could safely unreconcile statements! Is it a simple matter of changing the "y" to a "c" and does that take the reconciliation screen back to a previous reconciliation? I have a $219 discrepancy on a bank record and of course there is no single transaction that got me there. I don't mind doing one account. Thanks much! Phyllis Bruce ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reconciliation with a strange opening balance
While "Finding reconciliation discrepancies from previous statements can be extremely tedious and GnuCash doesn't have any tools to help. There's not even a way to display historical reconciled balances." is correct, the Banks (and by their proxy their Information Systems) have stepped up and have gotten to the point where their online portals (that is if you have signed up for it) have very good filtering capabilities when it comes to displaying transactions by date range. In the US the Banks are required to keep 7 years of statement available, and most banks now do very good job to getting them to you at a moment's notice. Here is what I do that has worked well for me: If there were any unintended entries gotten added after reconcile ('y' or 'c') then they normally appear as unreconciled ('n') which you can filter by that status in the register (assuming that you normally reconcile accounts like Bank, Credit Card and/or Investment accounts). This is likely to be able to flag it down very quickly. If your last reconciled register suddenly appears out-of-sync with respect to bank statement then review previous statement(s). Check the beginning and ending balance of previous statements and if they do not match then go back one more statement and compare. Rinse and repeat until you get to the statement that actually matches. Your culprit is likely to be somewhere in the statement following the one that matches. Use the previous step of transaction status to locate the errant entry and then correct as necessary. -Original Message- From: john Sent: Monday, November 13, 2023 3:55 PM To: Mahon Finbar Cc: Gnucash Users Subject: Re: [GNC] Reconciliation with a strange opening balance > On Nov 13, 2023, at 07:20, Mahon Finbar via gnucash-user wrote: > > Hello, > > The recent discussion on reconciliation was helpful in trying to sort out some anomalies I have. > > When I do the latest reconciliation of one of my accounts the opening balance is 10,448.43 and gives me an amount of inbalance which is way off. > > Following the advice in the recent posts I tried working backwards to see if I could find any errors. > > I got close to 0.00 from time to time and was satisfied enough to consider a balancing entry, but was intrigued on where the 'error' might have been. > > I set off to see where, but, in the course of my search, I tried to find the number 10,443.43 in the account, as a baseline, but didn't find one. > > If I understand the process of reconciliation the number should be somewhere in the account, should it not?? > > Just tell me I am barking up the wrong tree, if I am making an error. The reconcile info dialog that comes up when you click the reconcile button has two balances: Starting balance and Ending balance. The first is the reconciled balance for the account, that is the sum of all of the splits in the account marked as reconciled. That's different from the opening balance, which is the amount in the account when you created it in GnuCash. The starting balance should match the starting balance on your statement. If it doesn't then there's a mistake in reconciling a previous statement and you need to either make a correcting entry in your account to get it to match or dig through previous statements to try to find the discrepancy. The Ending balance is what you should enter from your account statement or your bank's website. It defaults to the balance of the last transaction on the date you entered in the Reconciliation date entry. When you finish that dialog the reconcile window opens and in the lower left it shows the balances from the info window followed by Reconciled balance and Difference, which update as you tick off transactions in the two panes of the window; you should tick off the transactions that match your statement, paying close attention to the amounts: Reconciliation is all about making sure that there aren't any differences. Fix any differences in the register and press enter to commit the change and it will be immediately reflected in the reconcile window. Once you have marked all of the transactions the Ending and Reconciled balances should match, Difference should be 0, and the Finish button in the toolbar should be enabled. You might not have a transaction balance matching the reconciled balance if you have unbalanced transactions previous to the last reconciled one. The "R" column between Transfer Account and Debit/Deposit shows each transaction's reconciled status: y for reconciled, n for unreconciled, c for cleared, and v for voided. You can use the the Status page of View>Filter By... to hide transactions by status. Finding reconciliation discrepancies from previous statements can be extremely tedious and GnuCash doesn't have any tools to help. There's not even a way to display historical reconciled balances. When it comes to fixing discrepancies remember that banks can make errors too, but you need documentation and time to get the bank
Re: [GNC] Change the default "Find" from "Description" to "Value"?
> On Nov 14, 2023, at 09:06, David Kirkby > wrote: > > If I want to find something, Edit -> Find will find it, but 99% of the time > I want to search by a value, not by description. Is it possible to change > the default, so I don't have to keep selecting "Value" each time? No. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Change the default "Find" from "Description" to "Value"?
If I want to find something, Edit -> Find will find it, but 99% of the time I want to search by a value, not by description. Is it possible to change the default, so I don't have to keep selecting "Value" each time? -- Dr David Kirkby Ph.D Kirkby Microwave Ltd Email: drkir...@kirkbymicrowave.co.uk Web: https://www.kirkbymicrowave.co.uk/ Telephone 07910 441670 (UK) or +44 7910 441670 (international) Registered in England and Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3 6DT ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Is it safe to change description of reconciled translation?
Changing the description won't change the reconciled status of a transaction in most versions of GnuCash. There was a period of time when any edits of a reconciled transaction would cause everything associated with the transaction to de-reconcile, but maybe you're not using one of those versions* (prior to 4.13, which is what I'm using on Windows). But, ultimately, the worst that could happen (aside from a cataclysmic crash and the end of the world as we know it) is that the transaction gets de-reconciled, and you have to reconcile it again. Not such a big deal. David T. * yet another reason to specify your GnuCash version and operating system, BTW. On Nov 14, 2023, 4:18 PM, at 4:18 PM, Mark at Lorimark wrote: >Make a back-up of your data and test it. > >You can edit notes and memos and it won't change the reconciliation >status (when I tested just now). > >~mark > >On 11/14/23 07:12, David Kirkby wrote: >> I have a reconciled transaction in my bank account, but the >description is >> vague as to what it is. Can I change that safely - I don't need to >change >> the amount. >> >___ >gnucash-user mailing list >gnucash-user@gnucash.org >To update your subscription preferences or to unsubscribe: >https://lists.gnucash.org/mailman/listinfo/gnucash-user >- >Please remember to CC this list on all your replies. >You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Is it safe to change description of reconciled translation?
Make a back-up of your data and test it. You can edit notes and memos and it won't change the reconciliation status (when I tested just now). ~mark On 11/14/23 07:12, David Kirkby wrote: I have a reconciled transaction in my bank account, but the description is vague as to what it is. Can I change that safely - I don't need to change the amount. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Is it safe to change description of reconciled translation?
I have a reconciled transaction in my bank account, but the description is vague as to what it is. Can I change that safely - I don't need to change the amount. -- Dr David Kirkby Ph.D Kirkby Microwave Ltd Email: drkir...@kirkbymicrowave.co.uk Web: https://www.kirkbymicrowave.co.uk/ Telephone 07910 441670 (UK) or +44 7910 441670 (international) Registered in England and Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3 6DT ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.