Re: [GNC] Unreconciling
Thank you both. It was exactly that easy and I found my errors quickly. All statements re-reconciled and up to date. Phyllis On Nov 14, 2023, at 4:41 PM, David Carlson wrote: 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 <[1]pobruc...@gmail.com> 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 [2]gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: [3]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 References 1. mailto:pobruc...@gmail.com 2. mailto:gnucash-user@gnucash.org 3. https://lists.gnucash.org/mailman/listinfo/gnucash-user ___ 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] Scroll progressively slower towards end of large table
My wife has been using GnuCash for years, and a couple years ago she tried to Open SubAccounts and a single scroll-wheel action would take a few seconds. Her computer info: CPU: I7 (pretty sure it's a 2nd Gen) RAM: Probably 8GB Hard Drive: OS (incl GnuCash install) - SSD; Data (where the GnuCash Datafile is) - 7200 RPM HDD OS: Windows 7 GnuCash: v3.11 She recently asked me to take a look at it, so I copied the data files to my computer and I noticed the same behavior albeit less intense on my beefier hardware. Instead of ~3 seconds mine responded after ~1 second. My computer info: CPU: I7-10700 (10th Gen) RAM: 32GB Hard Drive: OS (incl GnuCash install) - M.2 NVMe Data (GnuCash Datafile) - M.2 NVMe (separate from OS drive) OS: Windows 11 GnuCash: v5.4 I noticed also that if I scroll to the top of the table, scrolling is very responsive; as I scroll down the delay gets progressively worse. I also noticed that the general UI was also less responsive to the same degree scrolling was less responsive (so if I was at the top of the large table the UI was also very responsive, if I was at the bottom and would try to open a menu it would after a second flash a blue underline, but never actually display a menu). The original datafile she is using is in XML format. I saved a new file "as SQLite" but it didn't result in any noticeable improvement. I monitored performance, and noticed when I opened subaccounts the memory would jump from ~130MB to ~260MB. When I would scroll around the bottom the CPU would climb up to ~13%, and when I would scroll around the top the CPU would climb to ~7%, but Disk (and network) would remain at 0%. When scrolling around the bottom Memory would increase another ~16MB, when scrolling around the top Memory would increase ~16MB as well, but quickly drop back down between each scroll action. Thanks, Eric ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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
On Wed, 15 Nov 2023 15:39:19 +0100 Mahon Finbar via gnucash-user wrote: > Aha, as usual you are correct Maff. I'll just have to soldier on. I > already found two deposits entered as withdrawals. > > Barry At this stage, consider how you could use the search feature to find these sort of errors. If the deposits have a unique description, search for that description in the account and then check that all the entries are in the appropriate column. Sadly the autocomplete features autocomplete errors equally as well as good work, so think about how you can get the accounts sorted out other than through the reconcile feature. liz ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reconciliation with a strange opening balance
On Wed, Nov 15, 2023, 3:55 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Sorry David, I messed up the quotation when trimming. That was Chris' > explanation of how GnuCash stores reconciliation info. > > Regards, > Adrien > > On 11/15/23 3:50 PM, David Carlson wrote: > > I agree that the reconciliation date is assigned to each transaction > split > > as it is reconciled. > > > > In Gmail I am unable to see where you found that conflicting information > in > > this thread, as I am sure that I made no suggestion otherwise. > > ___ > 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] Change the default "Find" from "Description" to "Value"?
I agree that everyones' favorite search terms will be differrnt. However if there is a table of the terms previously used that might go a long way, especially if the terms used for the current search were displayed with the results so we could see where those search results are coming from. I think there is already a bug report about that. On Wed, Nov 15, 2023, 3:47 PM Derek Atkins wrote: > I think if you ask 100 people what their default "search" is, you'll get > 120 different answers. I don't think any solution is going to work for > everyone. > > IMHO, the most reasonable solution would be remembering the last used > search criteria and default to that next time. > > -derek > > On Wed, November 15, 2023 4:03 pm, Adrien Monteleone wrote: > > Probably 99.23% of my searches, 96.81% of the time, are the same. > > > > Regards, > > Adrien > > > > On 11/15/23 2:57 PM, David H wrote: > >> Good suggestion, I'd like that as well, every time I do a Find I always > >> change it to "Description, Notes or Memo" to cover all the bases :-) > > > > ___ > > 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. > > > > > -- >Derek Atkins 617-623-3745 >de...@ihtfp.com www.ihtfp.com >Computer and Internet Security Consultant > > ___ > 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] Change the default "Find" from "Description" to "Value"?
Yes, the last search sounds sensible, as it does not need any extra widgets to make a selection. On Wed, 15 Nov 2023 at 21:47, Derek Atkins wrote: > I think if you ask 100 people what their default "search" is, you'll get > 120 different answers. I don't think any solution is going to work for > everyone. > > IMHO, the most reasonable solution would be remembering the last used > search criteria and default to that next time. > > -derek > > On Wed, November 15, 2023 4:03 pm, Adrien Monteleone wrote: > > Probably 99.23% of my searches, 96.81% of the time, are the same. > > > > Regards, > > Adrien > > > > On 11/15/23 2:57 PM, David H wrote: > >> Good suggestion, I'd like that as well, every time I do a Find I always > >> change it to "Description, Notes or Memo" to cover all the bases :-) > > > > ___ > > 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. > > > > > -- >Derek Atkins 617-623-3745 >de...@ihtfp.com www.ihtfp.com >Computer and Internet Security Consultant > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reconciliation with a strange opening balance
Sorry David, I messed up the quotation when trimming. That was Chris' explanation of how GnuCash stores reconciliation info. Regards, Adrien On 11/15/23 3:50 PM, David Carlson wrote: I agree that the reconciliation date is assigned to each transaction split as it is reconciled. In Gmail I am unable to see where you found that conflicting information in this thread, as I am sure that I made no suggestion otherwise. ___ 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
Adrien, I agree that the reconciliation date is assigned to each transaction split as it is reconciled. In Gmail I am unable to see where you found that conflicting information in this thread, as I am sure that I made no suggestion otherwise. On Wed, Nov 15, 2023, 2:55 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > On 11/15/23 10:07 AM, David Carlson wrote: > >>> - each split's reconciliation date (which is the same as the last > >>> Reconciliation date). > > I could be reading your comment oddly, but I'm pretty sure that this > date sticks. That is, it doesn't change for *every* already reconciled > split in the account each reconciliation. Otherwise the Reconciliation > Report would show all the same date, (making that column useless) and it > does not. > > But if you re-reconcile a split, then that date will change to whatever > new date you reconciled to, but just for those re-reconciled splits. > > 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 > - > 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] Change the default "Find" from "Description" to "Value"?
I think if you ask 100 people what their default "search" is, you'll get 120 different answers. I don't think any solution is going to work for everyone. IMHO, the most reasonable solution would be remembering the last used search criteria and default to that next time. -derek On Wed, November 15, 2023 4:03 pm, Adrien Monteleone wrote: > Probably 99.23% of my searches, 96.81% of the time, are the same. > > Regards, > Adrien > > On 11/15/23 2:57 PM, David H wrote: >> Good suggestion, I'd like that as well, every time I do a Find I always >> change it to "Description, Notes or Memo" to cover all the bases :-) > > ___ > 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. > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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] Change the default "Find" from "Description" to "Value"?
Probably 99.23% of my searches, 96.81% of the time, are the same. Regards, Adrien On 11/15/23 2:57 PM, David H wrote: Good suggestion, I'd like that as well, every time I do a Find I always change it to "Description, Notes or Memo" to cover all the bases :-) ___ 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] Bill allocated to the wrong account
I've found GnuCash does try to re-link payments automatically, but this seems to be one case where it fails. Later reading shows the payment also is linked to other bills, so that is likely the reason. Regards, Adrien On 11/15/23 7:50 AM, Derek Atkins wrote: When you unpost, the payment gets detached. After you re-post it, you will need to re-attach the payment. ___ 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] Bill allocated to the wrong account
If the payment transaction is still partially assigned to other
documents, "Edit Payment" is what you want. ("Assign" only appears for
transactions 'not already assigned')
You need to select all of the documents like you did originally to link
it. (*all* bills being paid by this payment and if necessary, the Credit
Note unless you are holding that as a later offset)
As Maf noted, in a worst case, if this doesn't work (it should) then
nuke the payment and re-process it. (and then please file a bug)
Regards,
Adrien
On 11/15/23 10:49 AM, David Kirkby wrote:
Edit payment does not seem to get me anything I know how to use. I can't
seem to see this "Assign as Payment" option on any transaction in the bank
account - including those where a single payment was made for a single
bill.
___
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] Change the default "Find" from "Description" to "Value"?
Stan, Good suggestion, I'd like that as well, every time I do a Find I always change it to "Description, Notes or Memo" to cover all the bases :-) Cheers David H. On Thu, 16 Nov 2023 at 01:25, Stan Brown (using GC 4.14) < stan...@fastmail.fm> wrote: > On 2023-11-14 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? > > I've wondered about this too, with one change of detail: I'd like > to change the default for Find to "Description, Notes, or Memo". Is > there any way, or is one under development? If not, I think I know how > to enter a feature request. > > Stan Brown > Tehachapi, CA, USA > https://BrownMath.com/ > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reconciliation with a strange opening balance
On 11/15/23 10:07 AM, David Carlson wrote: - each split's reconciliation date (which is the same as the last Reconciliation date). I could be reading your comment oddly, but I'm pretty sure that this date sticks. That is, it doesn't change for *every* already reconciled split in the account each reconciliation. Otherwise the Reconciliation Report would show all the same date, (making that column useless) and it does not. But if you re-reconcile a split, then that date will change to whatever new date you reconciled to, but just for those re-reconciled splits. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Change the default "Find" from "Description" to "Value"?
I think there is one already for saving search patterns. That might be more versatile than changing the default. (and allow the default to remain as-is) Regards, Adrien On 11/15/23 9:25 AM, Stan Brown (using GC 4.14) wrote: I've wondered about this too, with one change of detail: I'd like to change the default for Find to "Description, Notes, or Memo". Is there any way, or is one under development? If not, I think I know how to enter a feature request. ___ 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] Bill allocated to the wrong account
OK, I'm at a loss, then. I get the attached right-click menu in my checking account. the only thing I can suggest (that I've done in the past) is to delete the payment txn in the bank account and redo the "process payment" workflow as normal from the from the bills due dialogues etc. You'll have to redo the reconcilliation, but that will only be a single txn to (re-)check off against the previous statement. Maf. On Wednesday, 15 November 2023 16:49:06 GMT David Kirkby wrote: > Edit payment does not seem to get me anything I know how to use. I can't > seem to see this "Assign as Payment" option on any transaction in the bank > account - including those where a single payment was made for a single > bill. > > On Wed, 15 Nov 2023 at 15:32, Maf. King wrote: > > On Wednesday, 15 November 2023 15:09:09 GMT David Kirkby wrote: > > > On Wed, 15 Nov 2023 at 13:55, Maf. King wrote: > > > > On Wednesday, 15 November 2023 13:36:20 GMT David Kirkby wrote: > > > > Hi David. > > > > > > Hi Maf > > > > > > > I presume these are vendor bills and were entered as such via A/P? > > > > > > Yes. > > > > > > IIRC, in the bank account right-click the transaction that paid the bill > > > > > > > and > > > > then choose "Assign as payment" > > > > > > Em, I can't see that option. Here's what I see in the bank account for > > > > the > > > > > one that has *not *be reconciled. The total amount for the bill is > > > > £52.76, > > > > > but was paid along with several others to the same vendor as I have a > > > credit account with them. I have unposted the billed, corrected the > > > > error, > > > > > and posted it again, but it shows as unpaid. This is what I see in the > > > > bank > > > > > account. I don't any "Assign as payment" when I right click. See > > > screenshots. I'm using GnuCash 5.4 on Windows. > > > > Aah, so the payment txn covered multiple bills. I see. Well, from the > > options in the screenshot, "Edit payment" seems the most appropriate. > > > > > > another choice you *may* have is to "process payment" like normal and > > select > > something like "auto balance forward" and the edited bill in the dialog > > box, > > but I'm relly not sure on that. > > > > The final option (a little more nuclear) is to delete the payment txn > > from the > > bank account and reprocess all the relevant bills. > > > > HTH, > > Maf. > > > > > (Note there was another error on this - when I paid the vendor I > > > actually > > > overpaid £10. So there's a £10 credit note, but that was used the next > > > month, so that's not a big deal.) > > > > > > [image: image.png][image: image.png] > > > > ___ > > 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. ___ 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] Bill allocated to the wrong account
Edit payment does not seem to get me anything I know how to use. I can't seem to see this "Assign as Payment" option on any transaction in the bank account - including those where a single payment was made for a single bill. On Wed, 15 Nov 2023 at 15:32, Maf. King wrote: > On Wednesday, 15 November 2023 15:09:09 GMT David Kirkby wrote: > > On Wed, 15 Nov 2023 at 13:55, Maf. King wrote: > > > On Wednesday, 15 November 2023 13:36:20 GMT David Kirkby wrote: > > > Hi David. > > > > Hi Maf > > > > > I presume these are vendor bills and were entered as such via A/P? > > > > Yes. > > > > IIRC, in the bank account right-click the transaction that paid the bill > > > > > and > > > then choose "Assign as payment" > > > > Em, I can't see that option. Here's what I see in the bank account for > the > > one that has *not *be reconciled. The total amount for the bill is > £52.76, > > but was paid along with several others to the same vendor as I have a > > credit account with them. I have unposted the billed, corrected the > error, > > and posted it again, but it shows as unpaid. This is what I see in the > bank > > account. I don't any "Assign as payment" when I right click. See > > screenshots. I'm using GnuCash 5.4 on Windows. > > Aah, so the payment txn covered multiple bills. I see. Well, from the > options in the screenshot, "Edit payment" seems the most appropriate. > > > another choice you *may* have is to "process payment" like normal and > select > something like "auto balance forward" and the edited bill in the dialog > box, > but I'm relly not sure on that. > > The final option (a little more nuclear) is to delete the payment txn > from the > bank account and reprocess all the relevant bills. > > HTH, > Maf. > > > > > (Note there was another error on this - when I paid the vendor I actually > > overpaid £10. So there's a £10 credit note, but that was used the next > > month, so that's not a big deal.) > > > > [image: image.png][image: image.png] > > > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reconciliation with a strange opening balance
My bank just this morning went through another iteration of fine tuning their procedures, which I have yet to process. However, I hope they still have monthly statements, whether mailed or only online to reconcile against. They may be identified only by account number and month, but so far they have been sufficiently immutable to be positively identified years later with an identifiable date interval for reconciliation .. On Wed, Nov 15, 2023 at 9:41 AM R Losey wrote: > I don't get statements with numbers to use - my checkbooks are reconciled > monthly to whatever the current online balance is, so what GnuCash does now > is just what I need. > > On Wed, Nov 15, 2023 at 8:27 AM Christopher Lam > > wrote: > > > A bit tangential to the issue of reconciliation is that fundamentally IMV > > reconciliation means to marry up (aka reconcile) the physical periodic > > (monthly/quarterly/annually) bank statements *against* your own books > which > > carry the canonical data which hopefully supports your financial > activity. > > > > Gnucash reconciliation only stores, for each reconciliation: > > > >- an account's last Reconciliation date > >- each split's reconciliation status n/c/y, > >- each split's reconciliation date (which is the same as the last > >Reconciliation date). > > > > It doesn't store other info such as: starting balance, statement number; > > and doesn't store the reconciled starting and ending balances. > > > > It *could* be transformed to store all these additional data: > > > >- statement ID number > >- statement's start and ending date > >- statement's start and ending balance > >- list of splits identified within the statement > > > > And would be somewhat more robust (ie you could ask gnucash to display > the > > contents of the feb2014 statement), and we would potentially be able to > > re-reconcile a previous statement (e.g. I deleted an old reconciled split > > in error and wish to re-reconcile its statement) but this would require a > > complete backward-incompatible upgrade in the internal data schema, there > > doesn't seem to be a demand of it, nor manpower to implement it, and I > > think it's simply overkill. > > > > Thus the reconciliation is currently limited to the state that exists > > currently. > > > > E > > > > On Mon, 13 Nov 2023, 11:21 pm Mahon Finbar via gnucash-user, < > > gnucash-user@gnucash.org> 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. > > > > > > Finbar > > > > > > ___ > > > 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. > > > > > -- > _ > Richard Losey > rlo...@gmail.com > Micah 6:8 > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- 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] Reconciliation with a strange opening balance
I don't get statements with numbers to use - my checkbooks are reconciled monthly to whatever the current online balance is, so what GnuCash does now is just what I need. On Wed, Nov 15, 2023 at 8:27 AM Christopher Lam wrote: > A bit tangential to the issue of reconciliation is that fundamentally IMV > reconciliation means to marry up (aka reconcile) the physical periodic > (monthly/quarterly/annually) bank statements *against* your own books which > carry the canonical data which hopefully supports your financial activity. > > Gnucash reconciliation only stores, for each reconciliation: > >- an account's last Reconciliation date >- each split's reconciliation status n/c/y, >- each split's reconciliation date (which is the same as the last >Reconciliation date). > > It doesn't store other info such as: starting balance, statement number; > and doesn't store the reconciled starting and ending balances. > > It *could* be transformed to store all these additional data: > >- statement ID number >- statement's start and ending date >- statement's start and ending balance >- list of splits identified within the statement > > And would be somewhat more robust (ie you could ask gnucash to display the > contents of the feb2014 statement), and we would potentially be able to > re-reconcile a previous statement (e.g. I deleted an old reconciled split > in error and wish to re-reconcile its statement) but this would require a > complete backward-incompatible upgrade in the internal data schema, there > doesn't seem to be a demand of it, nor manpower to implement it, and I > think it's simply overkill. > > Thus the reconciliation is currently limited to the state that exists > currently. > > E > > On Mon, 13 Nov 2023, 11:21 pm Mahon Finbar via gnucash-user, < > gnucash-user@gnucash.org> 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. > > > > Finbar > > > > ___ > > 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. > -- _ Richard Losey rlo...@gmail.com Micah 6:8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Bill allocated to the wrong account
On Wednesday, 15 November 2023 15:09:09 GMT David Kirkby wrote: > On Wed, 15 Nov 2023 at 13:55, Maf. King wrote: > > On Wednesday, 15 November 2023 13:36:20 GMT David Kirkby wrote: > > Hi David. > > Hi Maf > > > I presume these are vendor bills and were entered as such via A/P? > > Yes. > > IIRC, in the bank account right-click the transaction that paid the bill > > > and > > then choose "Assign as payment" > > Em, I can't see that option. Here's what I see in the bank account for the > one that has *not *be reconciled. The total amount for the bill is £52.76, > but was paid along with several others to the same vendor as I have a > credit account with them. I have unposted the billed, corrected the error, > and posted it again, but it shows as unpaid. This is what I see in the bank > account. I don't any "Assign as payment" when I right click. See > screenshots. I'm using GnuCash 5.4 on Windows. Aah, so the payment txn covered multiple bills. I see. Well, from the options in the screenshot, "Edit payment" seems the most appropriate. another choice you *may* have is to "process payment" like normal and select something like "auto balance forward" and the edited bill in the dialog box, but I'm relly not sure on that. The final option (a little more nuclear) is to delete the payment txn from the bank account and reprocess all the relevant bills. HTH, Maf. > > (Note there was another error on this - when I paid the vendor I actually > overpaid £10. So there's a £10 credit note, but that was used the next > month, so that's not a big deal.) > > [image: image.png][image: image.png] ___ 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] Change the default "Find" from "Description" to "Value"?
On 2023-11-14 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? I've wondered about this too, with one change of detail: I'd like to change the default for Find to "Description, Notes, or Memo". Is there any way, or is one under development? If not, I think I know how to enter a feature request. Stan Brown Tehachapi, CA, USA https://BrownMath.com/ ___ 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] Bill allocated to the wrong account
On Wed, 15 Nov 2023 at 13:55, Maf. King wrote: > On Wednesday, 15 November 2023 13:36:20 GMT David Kirkby wrote: > Hi David. > Hi Maf > > I presume these are vendor bills and were entered as such via A/P? > Yes. IIRC, in the bank account right-click the transaction that paid the bill > and > then choose "Assign as payment" > Em, I can't see that option. Here's what I see in the bank account for the one that has *not *be reconciled. The total amount for the bill is £52.76, but was paid along with several others to the same vendor as I have a credit account with them. I have unposted the billed, corrected the error, and posted it again, but it shows as unpaid. This is what I see in the bank account. I don't any "Assign as payment" when I right click. See screenshots. I'm using GnuCash 5.4 on Windows. (Note there was another error on this - when I paid the vendor I actually overpaid £10. So there's a £10 credit note, but that was used the next month, so that's not a big deal.) [image: image.png][image: image.png] ___ 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
Aha, as usual you are correct Maff. I'll just have to soldier on. I already found two deposits entered as withdrawals. Barry On 13/11/2023 16:40, Maf. King wrote: On Monday, 13 November 2023 15:20:28 GMT Mahon Finbar via gnucash-user wrote: 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?? or possibly ~5221.70 as a CR when it should be a DR (etc). or several smaller errors which total the ~10k discrepancy you are seeing 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 - 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
A bit tangential to the issue of reconciliation is that fundamentally IMV reconciliation means to marry up (aka reconcile) the physical periodic (monthly/quarterly/annually) bank statements *against* your own books which carry the canonical data which hopefully supports your financial activity. Gnucash reconciliation only stores, for each reconciliation: - an account's last Reconciliation date - each split's reconciliation status n/c/y, - each split's reconciliation date (which is the same as the last Reconciliation date). It doesn't store other info such as: starting balance, statement number; and doesn't store the reconciled starting and ending balances. It *could* be transformed to store all these additional data: - statement ID number - statement's start and ending date - statement's start and ending balance - list of splits identified within the statement And would be somewhat more robust (ie you could ask gnucash to display the contents of the feb2014 statement), and we would potentially be able to re-reconcile a previous statement (e.g. I deleted an old reconciled split in error and wish to re-reconcile its statement) but this would require a complete backward-incompatible upgrade in the internal data schema, there doesn't seem to be a demand of it, nor manpower to implement it, and I think it's simply overkill. Thus the reconciliation is currently limited to the state that exists currently. E On Mon, 13 Nov 2023, 11:21 pm Mahon Finbar via gnucash-user, < gnucash-user@gnucash.org> 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. > > Finbar > > ___ > 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] Bill allocated to the wrong account
On Wednesday, 15 November 2023 13:36:20 GMT David Kirkby wrote: > I have received a couple of bills from an electronics component supplier. > These should be allocated as "Stock" but I must have accidentally clicked > "Travel" instead.(I noticed this after doing a trial balance, and seeing > some travel there, when I knew there was no travel). > > One has been reconciled against the bank account, the other one has not. > > I thought the one that had not been reconciled would be easy to correct by > just unposting, changing the account from Travel to Stock. I did that, and > it was okay. However, at that point is was shown as unpaid. What's the best > way of paying it? Hi David. I presume these are vendor bills and were entered as such via A/P? IIRC, in the bank account right-click the transaction that paid the bill and then choose "Assign as payment" > > The more tricky one is the one that has been reconciled to the bank > account. Can that be corrected easily? If not, I could just leave it as > Travel and let my accountant know. The amount is quite small - under £10, > but I would like to get it right if possible. Do the same thing.edit the bill in the ususal way, then reassign the payment. Worst that happens (if the bank account txn unreconciles itself) is an extra transaction at the top of the next reconcilliation. Just include it and go to the correct ending balance and it should all work out. Or just re- do the last reconcile again. but I don't think it will get that far. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Bill allocated to the wrong account
When you unpost, the payment gets detached. After you re-post it, you will need to re-attach the payment. -derek On Wed, November 15, 2023 8:36 am, David Kirkby wrote: > I have received a couple of bills from an electronics component supplier. > These should be allocated as "Stock" but I must have accidentally clicked > "Travel" instead.(I noticed this after doing a trial balance, and seeing > some travel there, when I knew there was no travel). > > One has been reconciled against the bank account, the other one has not. > > I thought the one that had not been reconciled would be easy to correct by > just unposting, changing the account from Travel to Stock. I did that, and > it was okay. However, at that point is was shown as unpaid. What's the > best > way of paying it? > > The more tricky one is the one that has been reconciled to the bank > account. Can that be corrected easily? If not, I could just leave it as > Travel and let my accountant know. The amount is quite small - under £10, > but I would like to get it right if possible. > > > > > -- > 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. > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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] Bill allocated to the wrong account
I have received a couple of bills from an electronics component supplier. These should be allocated as "Stock" but I must have accidentally clicked "Travel" instead.(I noticed this after doing a trial balance, and seeing some travel there, when I knew there was no travel). One has been reconciled against the bank account, the other one has not. I thought the one that had not been reconciled would be easy to correct by just unposting, changing the account from Travel to Stock. I did that, and it was okay. However, at that point is was shown as unpaid. What's the best way of paying it? The more tricky one is the one that has been reconciled to the bank account. Can that be corrected easily? If not, I could just leave it as Travel and let my accountant know. The amount is quite small - under £10, but I would like to get it right if possible. -- 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.
