Re: [GNC] Bank account reconciled, will this change screw things up?

On 12/31/22 1:18 AM, Dr. David Kirkby wrote: On Sat, 31 Dec 2022 at 00:13, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: I would only use them for cases where you are billed (incurred the expense) before you pay, not at the same time. Why is that? Because that is the purpose

Re: [GNC] Bank account reconciled, will this change screw things up?

On Sat, 31 Dec 2022 at 00:13, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > I would only use them for cases where you are billed (incurred the > expense) before you pay, not at the same time. > Why is that? > Using your postage example: > > If you pay a company periodically for

Re: [GNC] Scary moment

Good question Adrien, there have been issues previously when using the likes of OneDrive / Google Drive etc to share files between machine. Cheers David H. On Sat, 31 Dec 2022 at 3:31 pm, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Where is your data file? > > Are you using 3

Re: [GNC] Scary moment

How are you accessing your file from the two different operating systems? Are you running a Linux VM on your Windows system? If so, are you accessing a common disc from both systems, or are you using a network file system to access the GnuCash data file? — Peter West p...@pbw.id.au And the

Re: [GNC] Config files?

On 12/30/22 8:02 PM, Simon Roberts wrote: Thanks Murugan, that's really useful. First it tells me that I'm using a significantly old release (3.8, from the Ubuntu "built in" stuff). Better fix that, methinks. Are the data files I'm working on in 3.8 going to read directly into version 4, or

Re: [GNC] Scary moment

Where is your data file? Are you using 3 separate physical machines, or are some of these VMs? If you've done various finds, reports, and other searches to eliminate data-entry error possibilities, and since this has happened more than once to the same data, I'm inclined to hazard one more

Re: [GNC] Matching error in OFX import

Don't forget to reply to the list. Bear in mind: if you import an OFX file, match its transactions to some of your register transactions, the matched transactions will be silently ignored when you re-import the same OFX. That's by design. So if you match everything then re-import the same

Re: [GNC] Config files?

Thanks Murugan, that's really useful. First it tells me that I'm using a significantly old release (3.8, from the Ubuntu "built in" stuff). Better fix that, methinks. Are the data files I'm working on in 3.8 going to read directly into version 4, or does that need some more deliberate action?

Re: [GNC] Matching error in OFX import

We might need a bit more info to give a useful answer. But just to be sure: - The FITID of the transactions in the OFX file are all different, right? That's an absolute requirement, not just within a single OFX file, but from ofx to ofx, the FITID is supposed to identify one and only 1

Re: [GNC] Config files?

You can click on Help->About where you can see the basic file paths for more detailed you can refer to https://wiki.gnucash.org/wiki/Configuration_Locations Configuration Locations - GnuCash GnuCash stores several categories of information

[GNC] Config files?

I've realized that GnuCash stores configuration information somewhere other than just the "account" file. Can anyone tell me where that is? (or where those places are?) Thanks! -- Simon Roberts (303) 249 3613 ___ gnucash-user mailing list

[GNC] Matching error in OFX import

With the same caveat about my being new to this... My transaction records show regular, very similar, transactions. The same institution, identical amounts, usually close but not identical dates. The importer's matcher is confused by these similar transactions. It marks them in red and refuses

Re: [GNC] Scary moment

Versions are a little confusing Mac was running 4.12 until today; I am now on the current version. I updated the Windows version earlier this week. Linux GnuCash is older (4.), but I don't run the GUI there - usually just the gnucash-cli stock updates, which I updated on Thursday from

Re: [GNC] Scary moment

Are you using the current version? If so, it might be appropriate to enter a bug report, mentioning each of the things you have checked for. Stan Brown Tehachapi, CA, USA https://BrownMath.com On 2022-12-30 17:23, R Losey wrote: > Thanks, but I am aware of this. On Wed, after I entered the data,

Re: [GNC] OFX import date questions

Thank you for the help to this point. I think I've worked out the date issue (very embarrassing, nothing to do with GC). Now I have a bunch more questions, but I'll ask them in dedicated threads to minimize confusion. I did notice that the CSV version of the transaction information contains two

Re: [GNC] Scary moment

Thanks, but I am aware of this. On Wed, after I entered the data, I re-ran the report, and verified that the checks now showed up. On Friday, the checks were missing again. The only thing I can think of that was different is that I was running price updates on Tue, Wed, and Thu via gnucash-cli.

Re: [GNC] Scary moment

It ***MIGHT*** be some kind of user error... I may have neglected to enter the checks last weekend, but I know for certain that they were entered on Wednesday, and had the date right, because they should up in the this year's report in right place. It **MIGHT** be that I didn't save the data, but

Re: [GNC] Scary moment

Good ideas... my responses: The transactions were not in the wrong accounts; they just went missing. I **THINK** I entered them last weekend; when I was doing tax work on Wednesday, they weren't there, and I re-entered them, re-running the report and verifying that the data now showed up. I

Re: [GNC] Scary moment

Good suggestions, Adrien. I have a fourth thought: We don't know how Losey was doing the "workup", but if it involved a report, and some of the relevant transactions were in accounts created after the last time the report was saved, then transactions in those accounts would not be picked up

Re: [GNC] Bank account reconciled, will this change screw things up?

Glad to know that worked! (and that there isn't another bug to squash) Regards, Adrien On 12/30/22 5:47 PM, Dr. David Kirkby wrote: Thank you. I think that you solved my problem. ___ gnucash-user mailing list gnucash-user@gnucash.org To update

Re: [GNC] Bank account reconciled, will this change screw things up?

I would only use them for cases where you are billed (incurred the expense) before you pay, not at the same time. Using your postage example: If you pay a company periodically for postage, quite possibly for more than one shipment, or have to take explicit action to pay a bill, use the

Re: [GNC] Bank account reconciled, will this change screw things up?

On Fri, 30 Dec 2022 at 22:56, Stephen M. Butler < stephen.m.butle...@gmail.com> wrote: > > OK. Mine are not tied to the business features. I think that I am in a minority here using them. They seem to make things more complicated. I just hope that the benefits outweigh the complications.

Re: [GNC] Bank account reconciled, will this change screw things up?

On Fri, 30 Dec 2022 at 22:55, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > > > Once you post, and then re-view the bill, it should show as paid. It doesn’t. I am using version 4.12. Tonight I was using Windows, but I think I noticed the same behaviour before under Linux. > To

Re: [GNC] OFX import date questions

Phyllis, That is what the Import Matcher window immediately before import is about. There are some preferences you can alter (cautiously) the likely and unlikely match day thresholds in particular. The matcher choices should not always be regarded as the last word. I generally find it matches

Re: [GNC] OFX import date questions

I interpret the OP's question as that the date imported from the OFX file doesn't match the date printed on the statement. Some banks try to get fancy and print the date that you deposited a check on your statement but then use the date that the funds arrived from the clearing house or the date

Re: [GNC] OFX import date questions

This is not expected behavior. I never happens to me, in fact ofx import usually works just fine. There might be something off in your preferences. You could try to go into "import" and adjust the "likely match day" threshold and the "Unlikely match day threshold". Mine are set to 4 and 14,

Re: [GNC] Bank account reconciled, will this change screw things up?

On 12/30/22 14:48, Adrien Monteleone wrote: How do you do that for a posted bill/invoice? Mine is immutable. (and should be) Regards, Adrien On 12/30/22 4:32 PM, Stephen M. Butler wrote: I just modify the account on that one line to point to Postage.  It doesn't seem to hurt any and is a

Re: [GNC] Bank account reconciled, will this change screw things up?

On 12/30/22 4:29 PM, Dr. David Kirkby wrote: It's actually a bill, not an invoice, but I think they are pretty similar. When I unpost and edit, then look at the register, everything looks okay. Yes, similar code too. Just different terms based on perspective of Vendor vs. Customer. CR:

Re: [GNC] Deleting Transaction from Reconcile Deletes Wrong Transaction

Thomas Unless you take the time to try to replicate the problem and create a bug report, the rest of us will quickly forget about it. If we don't see it happening with our data sets we will conclude that yours was a case of operator error. On Fri, Dec 30, 2022, 3:17 PM Thomas Forrester wrote:

Re: [GNC] Bank account reconciled, will this change screw things up?

How do you do that for a posted bill/invoice? Mine is immutable. (and should be) Regards, Adrien On 12/30/22 4:32 PM, Stephen M. Butler wrote: I just modify the account on that one line to point to Postage.  It doesn't seem to hurt any and is a whole lot simpler than trying to enter the

Re: [GNC] OFX import date questions

That's a matching problem on the import if I recall correctly. You have to fix it there. I've seen threads on the topic, but since I don't use it, the details are not sticky in my brain. If I understand properly, GnuCash *should* be able to match existing transactions and simply set the 'c'

Re: [GNC] Bank account reconciled, will this change screw things up?

On 12/30/22 12:43, Dr. David Kirkby wrote: I paid for some postage for £12.54, but instead of sticking the expense account as Postage, I put Payroll - well, then do both begin with P. Given I have reconciled the bank account, is it dangerous to change the account this transaction is debited to,

Re: [GNC] OFX import date questions

Jean and Adrien, I use QFX and reconciling is a pain! When I import and data from my bank and begin reconciliation I often find the GNC has ignored the existing unreconciled transactions and created new cleared ones. On Fri, Dec 30, 2022 at 3:51 PM Jean L wrote: > I don't think you can

Re: [GNC] OFX import date questions

Simon, The OFX file will be the immediate position in the banks records at the time of download. What appears in a statement may be after completion of interbank clearances of funds and the dates in the statement may reflect when this occurred rather than when the transaction was first received

Re: [GNC] Scary moment

Great thoughts, Adrien. I have made every one of those mistakes in 45 years of entering data. On Fri, Dec 30, 2022 at 3:56 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Another possibility: > > The transactions ended up in a different account. > > Do a Find from the Accounts

Re: [GNC] Scary moment

Another possibility: The transactions ended up in a different account. Do a Find from the Accounts tab from all sides of the transaction and see if they pop up when you think they are missing. Also, check the Orphan and Imbalance accounts. And another possibility: You have a View Filter on

Re: [GNC] OFX import date questions

I don't think you can "tweak" the OFX import. OFX import relies on an external library (ofxlib I think?). Are the dates way off? I've never noticed anything weird like that in my own OFX imports (which I do a lot of) the dates seem to always coincide. This *could* be a problem with the OFX

Re: [GNC] OFX import date questions

I'll let others who use this feature provide more specific advice, but as to the general question of dates matching: I wouldn't expect my dates to match the bank's records. My dates would always be the date of the real-world transaction. The Bank's dates would be when the bank cleared it,

Re: [GNC] Bank account reconciled, will this change screw things up?

Since this is an invoice, you can't just edit from a register. 1. Unpost 2. Edit 3. Repost 4. Then check that the payment is still applied. (it should be and GnuCash tries to keep things tidy for you, but check just in case) *you do not need to delete the payment or pay the invoice again.

[GNC] OFX import date questions

Beginner/refugee from QuickBooks here (more context below if you care). I'm working in a scratch file, so I can do stupid things while learning without damaging anything "important". I'm working with importing my bank transactions using OFX format (though I've also tinkered with CSV, and am

Re: [GNC] Deleting Transaction from Reconcile Deletes Wrong Transaction

I won't actually be experimenting on copies of databases, not because I don't want to be helpful or contribute to the community, but because I simply don't have that kind of free time. I've noted a problem, and can agree that I was doing something rather mindless - i.e., right-clicking and

Re: [GNC] Bank account reconciled, will this change screw things up?

Since you are changing the expense account and not the reconciled bank account it will not mess up the reconciliation. Sent from Samsung Galaxy smartphone. Original message From: David H Date: 12/30/22 4:01 PM (GMT-05:00) To: "Dr. David Kirkby" Cc: GNU Cash User

Re: [GNC] Bank account reconciled, will this change screw things up?

Hi Dave, My limited world view (I don't use the business features, trading accounts, imports, etc) tells me that I would update the transaction expense account in a Split view from Payroll to Postage noting what the reconciliation column values were prior to the change and also the Reconciled

Re: [GNC] Deleting Transaction from Reconcile Deletes Wrong Transaction

Thanks for your opinions and experiences on the method of storage employed. My perceptions on the pros/coms of either storage method notwithstanding, it is not the topic of this discussion. Rather it was just a side note on the complexities or applicability of restoring to get around the fact

[GNC] Bank account reconciled, will this change screw things up?

I paid for some postage for £12.54, but instead of sticking the expense account as Postage, I put Payroll - well, then do both begin with P. Given I have reconciled the bank account, is it dangerous to change the account this transaction is debited to, from Payroll to Postage? I was thinking of

Re: [GNC] Deleting Transaction from Reconcile Deletes Wrong Transaction

My experience is the same as Geert's. I've seen no performance advantage when testing XML vs MySQL with my 12 years of data. The initial load from db is slower than with XML, and flushing and zipping the data at termination is reasonably fast. As for immediate commit to the db, I find that

Re: [GNC] Scary moment

Simon, I stick with the default compressed xml file data storage (the default) with Gnucash and I NEVER autosave, that way if I stuff something up during the session I just exit and tell Gnucash to NOT save the changes and then re-open Gnucash with the previous version of the data file and start

Re: [GNC] Scary moment

I've been using it for 10+ years. My file is just over 1 MegaByte. It looks like it autosaves every 5 minutes and keeps the backups for one month. These are probably the default values. I don't remember ever changing them. My current Gnucash folder has 177 MB in it and 135 of that is an old

Re: [GNC] Scary moment

Simon, I have been using Gnucash for 7 years now, but only for my personal finance needs. I have my auto save set for 5 minutes and I never even notice when it happens. I enter hundreds of transactions a month and my file is still measured in kbs. So it depends on the size of the file.

Re: [GNC] Scary moment

The UI locks up while the Save happens, so saving every minute might be... annoying.. Even on a fast SSD. I would recommend you don't go below 5. -derek On Fri, December 30, 2022 1:50 pm, Simon Roberts wrote: > New user (refugee from Intuit, finally) question on this topic: > > Given that

Re: [GNC] Scary moment

New user (refugee from Intuit, finally) question on this topic: Given that these days we tend to have vast disks, and they're often very fast SSDs, I'm inclined to enable auto-save and set a relatively short interval (perhaps as little as a minute?) Are there issues with doing this that I've not

Re: [GNC] Scary moment

On 12/30/2022 1:02 PM, Derek Atkins wrote: I suppose there could have been a bug.. GnuCash is supposed to prevent you from exiting if there is unsaved data. However, I suppose there COULD be a way for you to shut down / close GnuCash in a way that prevents it from popping up that dialog box.

Re: [GNC] Scary moment

I suppose there could have been a bug.. GnuCash is supposed to prevent you from exiting if there is unsaved data. However, I suppose there COULD be a way for you to shut down / close GnuCash in a way that prevents it from popping up that dialog box. -derek On Fri, December 30, 2022 12:46 pm, R

Re: [GNC] Scary moment

Yes, I'm well aware of that... I NEVER double-click on the GnuCash files; I just bring up GnuCash itself and it uses (I presume) the last file I used, which is the only one I have. So, it wasn't that. On Wed, I did the open on the Mac and they were missing (I thought that I may have forgotten to

Re: [GNC] Scary moment

Unlikely.. HOWEVER, one IMPORTANT thing to keep in mind on the Mac is that GnuCash does not honor double-clicking on a data file to open /that/ file. When you double-click on ANY data file, GnuCash will start and ALWAYS open the last file you had used.. It doesn't matter WHAT file you clicked

Re: [GNC] Deleting Transaction from Reconcile Deletes Wrong Transaction

The "wonkiness on the Mac" was indeed limited to Macs. That doesn't mean that Windows can't also develop wonkiness, but I don't maintain Gtk's Windows backend nor do I know much about how it works so unlike the Mac backend I can't fix it. Your description of the problem doesn't match the macOS

Re: [GNC] Scary moment

I just had a thought about what may be the cause... I was fooling around with the financial quote program on Ubuntu and had run it multiple times. Maybe that somehow erased the changes. On Fri, Dec 30, 2022 at 10:43 AM R Losey wrote: > I was doing preliminary tax workup earlier this week, and

[GNC] Scary moment

I was doing preliminary tax workup earlier this week, and (to my surprise), there were some transactions mentioned that I thought I'd entered last Friday... (I only noticed because they weren't there in the report I was using). Anyway, I entered them, verified that they showed up on the report,

Re: [GNC] Deleting Transaction from Reconcile Deletes Wrong Transaction

Op vrijdag 30 december 2022 15:47:35 CET schreef Thomas Forrester: (snip) > I use database storage over the XML storage method because it does afford > me opportunities that the XML plain text file does not. I now have data > going back seven years in GnuCash and I think that's too much to push

Re: [GNC] Deleting Transaction from Reconcile Deletes Wrong Transaction

Ah. I reported the version [GnuCash 4.11 Build ID: 4.11+(2022-06-25) using a MariaDB backend], but totally forgot to mention I'm running on Windows 11. Hopefully the "wonkiness" seen on the Mac isn't present in Windows? Or hopefully it's gone on all platforms in 4.13, as you've suggested, which

Re: [GNC] Deleting Transaction from Reconcile Deletes Wrong Transaction

It is possible that a specific set of prerequisite conditions need to exist for the bug to manifest, but I don't know exactly what I might have been doing immediately before getting the notion that I should just delete the transactions right from the Reconciliation dialog. Normally, I would