Re: [GNC] OFX import date questions
Hi Simon, the import had the proper transactions but was not matching a couple I had manually entered that were outside the default parameters. I thing I’ve got that sorted now. I’m running ver 4.13 of GC in Windows 11. I upgrade as soon as I know one has been distributed. On Dec 31, 2022, at 11:54 AM, Simon Roberts wrote: A side thought Phylls, I think your first observation was about some transactions that you had imported not showing up? If that's the case, what version of GnuCash are you running? I was running 3.8, which was the default from the Ubuntu Linux repositories. It was indeed failing to import some transactions (because it deemed them duplicates, even though they most definitely were not). However, after building version 4.13, I no longer see that problem. On Sat, Dec 31, 2022 at 6:53 AM Phyllis Bruce <[1]pobruc...@gmail.com> wrote: Thanks Jean and David, My thresholds are prolly set to the defaults. Another thing I will do is filter for "Unreconciled" before I start my reconciliation. I often have some withdrawals that don't occur within two months. If I know they're there, I can change the threshold to look for them. Second thought, clearly a preference because we are looking at "statements" from the bank. How might I keep the date issued as part of my record? Where should I enter that since, in the reconciliation the date is always changed to date cleared? Just finished reconciling for the month so it will be a while before I can test this. New year - new start On Fri, Dec 30, 2022 at 7:25 PM Simon Roberts <[2]si...@dancingcloudservices.com> wrote: 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 different date columns one called "Posting" and the other "Effective", but in all my samples so far, they're the same. That had nothing to do with my stupi^H^H^H^H^H ... er, "problem", but I mention it in case it has any relevance to anyone looking at this thread years from now. The OFX file only seems to contain a single date field ("DTPOSTED"). But yeah, overwhelm induced stupidity on my part, sorry. Next question will be a bit more real, but many thanks to everyone who was kind enough to pitch in their ideas. On Fri, Dec 30, 2022 at 3:19 PM David Cousens <[3]davidcousen...@gmail.com> wrote: > 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 by the bank. > Clearnce times are generally a lot shorter with electronic clearances than > they > used to be can sometimes be delayed. SInce this is a disagreement between > OFX > records and statement both produced by the bank, they are best placed to > explain > what such discrepancies are and why they occur. > > David Cousens > > > On Fri, 2022-12-30 at 14:35 -0700, Simon Roberts wrote: > > 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 willing to use that if it > > solves my problem). > > > > I imported some transactions using OFX. Several things surprised me, but > > the one that I think needs resolving first is that the transaction dates > do > > not match the bank statement. > > > > Earlier I tried the CSV import and saw there were *two* date fields > > (presumably difference between being received and being acted on? > > > > Can someone tell me what I should do to fix this? Is there a way to > "tweek" > > the OFX import, or do I need to use CSV? Or is this something else > entirely > > that's gone amiss? > > > > Thanks for any hints, > > Cheers, > > Simon > > > > Background in case it's relevant: > > > > I'm a refugee from Intuit, and very early in my learning process. > > > > I"m not a bookkeeper, I'm a programmer. Conversely, my bookkeeper isn't a > > software person--she would have continued paying the annual ransom t
Re: [GNC] OFX import date questions
Yes, David C- to me, date issued is the date I wrote the check. By date cleared, I meant the date on the statement which I assume is the date the bank cleared the transaction. I'm also going to take a leap and assume the OFX and QFX operate the same since the two are on the same line as OFX/QFX in the import selection panel. As for keeping the date written, I'll start using the notes field for that when it's important to me. I do have a play file but didn't think to use it. Thanks for the reminder. On Sat, Dec 31, 2022 at 11:24 AM David Carlson wrote: > Phyllis, > > Reconciliation does* not* always change the date to date cleared. In > fact, the only date messed with during reconciliation is the reconciliation > date. That date is always automatically set to the date used by the > reconciliation process. In fact, that date has been the topic of other > threads in recent months. The OFX import may or may not change the > transaction date when the imported transaction date differs from the > existing matched transaction date depending on whether you choose to use > the Update feature for that particular transaction. You may wish to > re-read the Tutorial regarding how the matching process works. I am not > sure even what you mean by 'date issued' Is that the the date you wrote > the check? If I want to keep that date in the record I manually write it > in the Notes field. > > By the way, if you want to test anything in GnuCash, just make a > disposable and renamed copy of your data file or backup from earlier and > put it in a folder labelled Test. > > On Sat, Dec 31, 2022 at 7:54 AM Phyllis Bruce wrote: > >> Thanks Jean and David, >> My thresholds are prolly set to the defaults. Another thing I will do is >> filter for "Unreconciled" before I start my reconciliation. I often have >> some withdrawals that don't occur within two months. If I know they're >> there, I can change the threshold to look for them. >> >> Second thought, clearly a preference because we are looking at >> "statements" >> from the bank. How might I keep the date issued as part of my record? >> Where should I enter that since, in the reconciliation the date is always >> changed to date cleared? Just finished reconciling for the month so it >> will be a while before I can test this. New year - new start >> >> On Fri, Dec 30, 2022 at 7:25 PM Simon Roberts < >> si...@dancingcloudservices.com> wrote: >> >> > 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 different date columns one called "Posting" and the other >> "Effective", >> > but in all my samples so far, they're the same. That had nothing to do >> with >> > my stupi^H^H^H^H^H ... er, "problem", but I mention it in case it has >> any >> > relevance to anyone looking at this thread years from now. The OFX file >> > only seems to contain a single date field ("DTPOSTED"). >> > >> > But yeah, overwhelm induced stupidity on my part, sorry. Next question >> will >> > be a bit more real, but many thanks to everyone who was kind enough to >> > pitch in their ideas. >> > >> > >> > On Fri, Dec 30, 2022 at 3:19 PM David Cousens > > >> > wrote: >> > >> > > 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 by the >> bank. >> > > Clearnce times are generally a lot shorter with electronic clearances >> > than >> > > they >> > > used to be can sometimes be delayed. SInce this is a disagreement >> between >> > > OFX >> > > records and statement both produced by the bank, they are best placed >> to >> > > explain >> > > what such discrepancies are and why they occur. >> > > >> > > David Cousens >> > > >> > > >> > > On Fri, 2022-12-30 at 14:35 -0700, Simon Roberts wrote: >> > > > 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 willing to use that if it >> > > > solves my problem). >> > > > >> > > > I imported some transactions using OFX. Several things surprised me, >> > but >> > > > the one that I think needs resolving first is that the transaction >> > dates >> > > do >> > > > not match the bank statement. >> > > > >> > > > Earlier I tried the CSV import and saw there were *two* date fields >> > > > (presumably differen
Re: [GNC] OFX import date questions
A side thought Phylls, I think your first observation was about some transactions that you had imported not showing up? If that's the case, what version of GnuCash are you running? I was running 3.8, which was the default from the Ubuntu Linux repositories. It was indeed failing to import some transactions (because it deemed them duplicates, even though they most definitely were not). However, after building version 4.13, I no longer see that problem. On Sat, Dec 31, 2022 at 6:53 AM Phyllis Bruce wrote: > Thanks Jean and David, > My thresholds are prolly set to the defaults. Another thing I will do is > filter for "Unreconciled" before I start my reconciliation. I often have > some withdrawals that don't occur within two months. If I know they're > there, I can change the threshold to look for them. > > Second thought, clearly a preference because we are looking at > "statements" from the bank. How might I keep the date issued as part of my > record? Where should I enter that since, in the reconciliation the date is > always changed to date cleared? Just finished reconciling for the month so > it will be a while before I can test this. New year - new start > > On Fri, Dec 30, 2022 at 7:25 PM Simon Roberts < > si...@dancingcloudservices.com> wrote: > >> 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 different date columns one called "Posting" and the other "Effective", >> but in all my samples so far, they're the same. That had nothing to do >> with >> my stupi^H^H^H^H^H ... er, "problem", but I mention it in case it has any >> relevance to anyone looking at this thread years from now. The OFX file >> only seems to contain a single date field ("DTPOSTED"). >> >> But yeah, overwhelm induced stupidity on my part, sorry. Next question >> will >> be a bit more real, but many thanks to everyone who was kind enough to >> pitch in their ideas. >> >> >> On Fri, Dec 30, 2022 at 3:19 PM David Cousens >> wrote: >> >> > 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 by the >> bank. >> > Clearnce times are generally a lot shorter with electronic clearances >> than >> > they >> > used to be can sometimes be delayed. SInce this is a disagreement >> between >> > OFX >> > records and statement both produced by the bank, they are best placed to >> > explain >> > what such discrepancies are and why they occur. >> > >> > David Cousens >> > >> > >> > On Fri, 2022-12-30 at 14:35 -0700, Simon Roberts wrote: >> > > 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 willing to use that if it >> > > solves my problem). >> > > >> > > I imported some transactions using OFX. Several things surprised me, >> but >> > > the one that I think needs resolving first is that the transaction >> dates >> > do >> > > not match the bank statement. >> > > >> > > Earlier I tried the CSV import and saw there were *two* date fields >> > > (presumably difference between being received and being acted on? >> > > >> > > Can someone tell me what I should do to fix this? Is there a way to >> > "tweek" >> > > the OFX import, or do I need to use CSV? Or is this something else >> > entirely >> > > that's gone amiss? >> > > >> > > Thanks for any hints, >> > > Cheers, >> > > Simon >> > > >> > > Background in case it's relevant: >> > > >> > > I'm a refugee from Intuit, and very early in my learning process. >> > > >> > > I"m not a bookkeeper, I'm a programmer. Conversely, my bookkeeper >> isn't a >> > > software person--she would have continued paying the annual ransom to >> > > Intuit but I'm sick of their hostage taking. Of course this means I >> need >> > to >> > > do a decent part of the legwork for this transition. >> > > >> > > Of course because I'm not a bookkeeper, I don't understand the >> accounting >> > > side of this stuff, and likely won't know how to ask/phrase the >> > questions. >> > > >> > > Neither of us are going to be great at searching the documentation >> since >> > it >> > > seems like the terminology is different between GC and QB (and I don't >> > > really know the terminology anyway) >> > > >> > > So, please forgive the idiot question, and if the simple answer to a >> > > question is RTFM, we're very happy to do
Re: [GNC] OFX import date questions
Phyllis, Reconciliation does* not* always change the date to date cleared. In fact, the only date messed with during reconciliation is the reconciliation date. That date is always automatically set to the date used by the reconciliation process. In fact, that date has been the topic of other threads in recent months. The OFX import may or may not change the transaction date when the imported transaction date differs from the existing matched transaction date depending on whether you choose to use the Update feature for that particular transaction. You may wish to re-read the Tutorial regarding how the matching process works. I am not sure even what you mean by 'date issued' Is that the the date you wrote the check? If I want to keep that date in the record I manually write it in the Notes field. By the way, if you want to test anything in GnuCash, just make a disposable and renamed copy of your data file or backup from earlier and put it in a folder labelled Test. On Sat, Dec 31, 2022 at 7:54 AM Phyllis Bruce wrote: > Thanks Jean and David, > My thresholds are prolly set to the defaults. Another thing I will do is > filter for "Unreconciled" before I start my reconciliation. I often have > some withdrawals that don't occur within two months. If I know they're > there, I can change the threshold to look for them. > > Second thought, clearly a preference because we are looking at "statements" > from the bank. How might I keep the date issued as part of my record? > Where should I enter that since, in the reconciliation the date is always > changed to date cleared? Just finished reconciling for the month so it > will be a while before I can test this. New year - new start > > On Fri, Dec 30, 2022 at 7:25 PM Simon Roberts < > si...@dancingcloudservices.com> wrote: > > > 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 different date columns one called "Posting" and the other > "Effective", > > but in all my samples so far, they're the same. That had nothing to do > with > > my stupi^H^H^H^H^H ... er, "problem", but I mention it in case it has any > > relevance to anyone looking at this thread years from now. The OFX file > > only seems to contain a single date field ("DTPOSTED"). > > > > But yeah, overwhelm induced stupidity on my part, sorry. Next question > will > > be a bit more real, but many thanks to everyone who was kind enough to > > pitch in their ideas. > > > > > > On Fri, Dec 30, 2022 at 3:19 PM David Cousens > > wrote: > > > > > 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 by the > bank. > > > Clearnce times are generally a lot shorter with electronic clearances > > than > > > they > > > used to be can sometimes be delayed. SInce this is a disagreement > between > > > OFX > > > records and statement both produced by the bank, they are best placed > to > > > explain > > > what such discrepancies are and why they occur. > > > > > > David Cousens > > > > > > > > > On Fri, 2022-12-30 at 14:35 -0700, Simon Roberts wrote: > > > > 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 willing to use that if it > > > > solves my problem). > > > > > > > > I imported some transactions using OFX. Several things surprised me, > > but > > > > the one that I think needs resolving first is that the transaction > > dates > > > do > > > > not match the bank statement. > > > > > > > > Earlier I tried the CSV import and saw there were *two* date fields > > > > (presumably difference between being received and being acted on? > > > > > > > > Can someone tell me what I should do to fix this? Is there a way to > > > "tweek" > > > > the OFX import, or do I need to use CSV? Or is this something else > > > entirely > > > > that's gone amiss? > > > > > > > > Thanks for any hints, > > > > Cheers, > > > > Simon > > > > > > > > Background in case it's relevant: > > > > > > > > I'm a refugee from Intuit, and very early in my learning process. > > > > > > > > I"m not a bookkeeper, I'm a programmer. Conversely, my bookkeeper > > isn't a > > > > software person--she would have continued paying the annual ransom to > > > > Intuit but I'm sick of their hostage taking. Of course this me
Re: [GNC] OFX import date questions
Thanks Jean and David, My thresholds are prolly set to the defaults. Another thing I will do is filter for "Unreconciled" before I start my reconciliation. I often have some withdrawals that don't occur within two months. If I know they're there, I can change the threshold to look for them. Second thought, clearly a preference because we are looking at "statements" from the bank. How might I keep the date issued as part of my record? Where should I enter that since, in the reconciliation the date is always changed to date cleared? Just finished reconciling for the month so it will be a while before I can test this. New year - new start On Fri, Dec 30, 2022 at 7:25 PM Simon Roberts < si...@dancingcloudservices.com> wrote: > 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 different date columns one called "Posting" and the other "Effective", > but in all my samples so far, they're the same. That had nothing to do with > my stupi^H^H^H^H^H ... er, "problem", but I mention it in case it has any > relevance to anyone looking at this thread years from now. The OFX file > only seems to contain a single date field ("DTPOSTED"). > > But yeah, overwhelm induced stupidity on my part, sorry. Next question will > be a bit more real, but many thanks to everyone who was kind enough to > pitch in their ideas. > > > On Fri, Dec 30, 2022 at 3:19 PM David Cousens > wrote: > > > 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 by the bank. > > Clearnce times are generally a lot shorter with electronic clearances > than > > they > > used to be can sometimes be delayed. SInce this is a disagreement between > > OFX > > records and statement both produced by the bank, they are best placed to > > explain > > what such discrepancies are and why they occur. > > > > David Cousens > > > > > > On Fri, 2022-12-30 at 14:35 -0700, Simon Roberts wrote: > > > 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 willing to use that if it > > > solves my problem). > > > > > > I imported some transactions using OFX. Several things surprised me, > but > > > the one that I think needs resolving first is that the transaction > dates > > do > > > not match the bank statement. > > > > > > Earlier I tried the CSV import and saw there were *two* date fields > > > (presumably difference between being received and being acted on? > > > > > > Can someone tell me what I should do to fix this? Is there a way to > > "tweek" > > > the OFX import, or do I need to use CSV? Or is this something else > > entirely > > > that's gone amiss? > > > > > > Thanks for any hints, > > > Cheers, > > > Simon > > > > > > Background in case it's relevant: > > > > > > I'm a refugee from Intuit, and very early in my learning process. > > > > > > I"m not a bookkeeper, I'm a programmer. Conversely, my bookkeeper > isn't a > > > software person--she would have continued paying the annual ransom to > > > Intuit but I'm sick of their hostage taking. Of course this means I > need > > to > > > do a decent part of the legwork for this transition. > > > > > > Of course because I'm not a bookkeeper, I don't understand the > accounting > > > side of this stuff, and likely won't know how to ask/phrase the > > questions. > > > > > > Neither of us are going to be great at searching the documentation > since > > it > > > seems like the terminology is different between GC and QB (and I don't > > > really know the terminology anyway) > > > > > > So, please forgive the idiot question, and if the simple answer to a > > > question is RTFM, we're very happy to do so, but likely are asking as > > we've > > > failed to find the relevant part of said references. > > > > > > Anyway, thanks for your indulgence :) > > > ___ > > > 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 updat
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 different date columns one called "Posting" and the other "Effective", but in all my samples so far, they're the same. That had nothing to do with my stupi^H^H^H^H^H ... er, "problem", but I mention it in case it has any relevance to anyone looking at this thread years from now. The OFX file only seems to contain a single date field ("DTPOSTED"). But yeah, overwhelm induced stupidity on my part, sorry. Next question will be a bit more real, but many thanks to everyone who was kind enough to pitch in their ideas. On Fri, Dec 30, 2022 at 3:19 PM David Cousens wrote: > 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 by the bank. > Clearnce times are generally a lot shorter with electronic clearances than > they > used to be can sometimes be delayed. SInce this is a disagreement between > OFX > records and statement both produced by the bank, they are best placed to > explain > what such discrepancies are and why they occur. > > David Cousens > > > On Fri, 2022-12-30 at 14:35 -0700, Simon Roberts wrote: > > 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 willing to use that if it > > solves my problem). > > > > I imported some transactions using OFX. Several things surprised me, but > > the one that I think needs resolving first is that the transaction dates > do > > not match the bank statement. > > > > Earlier I tried the CSV import and saw there were *two* date fields > > (presumably difference between being received and being acted on? > > > > Can someone tell me what I should do to fix this? Is there a way to > "tweek" > > the OFX import, or do I need to use CSV? Or is this something else > entirely > > that's gone amiss? > > > > Thanks for any hints, > > Cheers, > > Simon > > > > Background in case it's relevant: > > > > I'm a refugee from Intuit, and very early in my learning process. > > > > I"m not a bookkeeper, I'm a programmer. Conversely, my bookkeeper isn't a > > software person--she would have continued paying the annual ransom to > > Intuit but I'm sick of their hostage taking. Of course this means I need > to > > do a decent part of the legwork for this transition. > > > > Of course because I'm not a bookkeeper, I don't understand the accounting > > side of this stuff, and likely won't know how to ask/phrase the > questions. > > > > Neither of us are going to be great at searching the documentation since > it > > seems like the terminology is different between GC and QB (and I don't > > really know the terminology anyway) > > > > So, please forgive the idiot question, and if the simple answer to a > > question is RTFM, we're very happy to do so, but likely are asking as > we've > > failed to find the relevant part of said references. > > > > Anyway, thanks for your indulgence :) > > ___ > > 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. > -- Simon Roberts (303) 249 3613 ___ 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] 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 existing transactions very well but occasionally something throws a spanner in the works and you get a mismatch so I check the settings and checkbox settings carefully before importing. I quite often find one or two of the matchers suggestions which I have to override or soem that it can't match. Fortunately they seem to be the same transactions month to month. If the date you entered a transaction in GnuCash is significantly different from the date the bank records it at then the probability that it will be matched is lowered. David Cousens On Fri, 2022-12-30 at 16:20 -0600, Phyllis Bruce wrote: > 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 "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 created by your bank. If you're a > > programmer, you might want to write a small program to edit the OFX file > > before importing (I have to do that for citibank because of unique ID > > issues). > > > > J > > > > On 12/30/2022 1:35 PM, Simon Roberts wrote: > > > 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 willing to use that if it > > > solves my problem). > > > > > > I imported some transactions using OFX. Several things surprised me, but > > > the one that I think needs resolving first is that the transaction dates > > do > > > not match the bank statement. > > > > > > Earlier I tried the CSV import and saw there were *two* date fields > > > (presumably difference between being received and being acted on? > > > > > > Can someone tell me what I should do to fix this? Is there a way to > > "tweek" > > > the OFX import, or do I need to use CSV? Or is this something else > > entirely > > > that's gone amiss? > > > > > > Thanks for any hints, > > > Cheers, > > > Simon > > > > > > Background in case it's relevant: > > > > > > I'm a refugee from Intuit, and very early in my learning process. > > > > > > I"m not a bookkeeper, I'm a programmer. Conversely, my bookkeeper isn't a > > > software person--she would have continued paying the annual ransom to > > > Intuit but I'm sick of their hostage taking. Of course this means I need > > to > > > do a decent part of the legwork for this transition. > > > > > > Of course because I'm not a bookkeeper, I don't understand the accounting > > > side of this stuff, and likely won't know how to ask/phrase the > > questions. > > > > > > Neither of us are going to be great at searching the documentation since > > it > > > seems like the terminology is different between GC and QB (and I don't > > > really know the terminology anyway) > > > > > > So, please forgive the idiot question, and if the simple answer to a > > > question is RTFM, we're very happy to do so, but likely are asking as > > we've > > > failed to find the relevant part of said references. > > > > > > Anyway, thanks for your indulgence :) > > > ___ > > > 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. ___ gnu
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 that they will let you withdraw the funds in their OFX export s. There can be many variations on this theme. He could ask someone at the bank to explain why if there is a discrepancy of this type. On Fri, Dec 30, 2022, 4:48 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > 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' flag for them. > > Regards, > Adrien > > On 12/30/22 4:20 PM, Phyllis Bruce wrote: > > 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. > > ___ > 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] 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, which I believe means that two dates less than 4 days apart are considered a good match, while dates more then 14 days apart are a "no match" and there's a continuous in between. Hover over the + sign to get a help balloon. If that's not the issue, there has to be a reason why GC does not consider the transactions you've entered for a match. The issue is either a date mismatch or an amount mismatch. If you let GC enter the transaction for you (instead of matching the existing one) can you see a mismatch between the dates and amounts of each transaction? On 12/30/2022 2:20 PM, Phyllis Bruce wrote: 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 "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 created by your bank. If you're a programmer, you might want to write a small program to edit the OFX file before importing (I have to do that for citibank because of unique ID issues). J On 12/30/2022 1:35 PM, Simon Roberts wrote: > 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 willing to use that if it > solves my problem). > > I imported some transactions using OFX. Several things surprised me, but > the one that I think needs resolving first is that the transaction dates do > not match the bank statement. > > Earlier I tried the CSV import and saw there were *two* date fields > (presumably difference between being received and being acted on? > > Can someone tell me what I should do to fix this? Is there a way to "tweek" > the OFX import, or do I need to use CSV? Or is this something else entirely > that's gone amiss? > > Thanks for any hints, > Cheers, > Simon > > Background in case it's relevant: > > I'm a refugee from Intuit, and very early in my learning process. > > I"m not a bookkeeper, I'm a programmer. Conversely, my bookkeeper isn't a > software person--she would have continued paying the annual ransom to > Intuit but I'm sick of their hostage taking. Of course this means I need to > do a decent part of the legwork for this transition. > > Of course because I'm not a bookkeeper, I don't understand the accounting > side of this stuff, and likely won't know how to ask/phrase the questions. > > Neither of us are going to be great at searching the documentation since it > seems like the terminology is different between GC and QB (and I don't > really know the terminology anyway) > > So, please forgive the idiot question, and if the simple answer to a > question is RTFM, we're very happy to do so, but likely are asking as we've > failed to find the relevant part of said references. > > Anyway, thanks for your indulgence :) > ___ > 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] 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' flag for them. Regards, Adrien On 12/30/22 4:20 PM, Phyllis Bruce wrote: 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. ___ 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] 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 "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 created by your bank. If you're a > programmer, you might want to write a small program to edit the OFX file > before importing (I have to do that for citibank because of unique ID > issues). > > J > > On 12/30/2022 1:35 PM, Simon Roberts wrote: > > 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 willing to use that if it > > solves my problem). > > > > I imported some transactions using OFX. Several things surprised me, but > > the one that I think needs resolving first is that the transaction dates > do > > not match the bank statement. > > > > Earlier I tried the CSV import and saw there were *two* date fields > > (presumably difference between being received and being acted on? > > > > Can someone tell me what I should do to fix this? Is there a way to > "tweek" > > the OFX import, or do I need to use CSV? Or is this something else > entirely > > that's gone amiss? > > > > Thanks for any hints, > > Cheers, > > Simon > > > > Background in case it's relevant: > > > > I'm a refugee from Intuit, and very early in my learning process. > > > > I"m not a bookkeeper, I'm a programmer. Conversely, my bookkeeper isn't a > > software person--she would have continued paying the annual ransom to > > Intuit but I'm sick of their hostage taking. Of course this means I need > to > > do a decent part of the legwork for this transition. > > > > Of course because I'm not a bookkeeper, I don't understand the accounting > > side of this stuff, and likely won't know how to ask/phrase the > questions. > > > > Neither of us are going to be great at searching the documentation since > it > > seems like the terminology is different between GC and QB (and I don't > > really know the terminology anyway) > > > > So, please forgive the idiot question, and if the simple answer to a > > question is RTFM, we're very happy to do so, but likely are asking as > we've > > failed to find the relevant part of said references. > > > > Anyway, thanks for your indulgence :) > > ___ > > 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] 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 by the bank. Clearnce times are generally a lot shorter with electronic clearances than they used to be can sometimes be delayed. SInce this is a disagreement between OFX records and statement both produced by the bank, they are best placed to explain what such discrepancies are and why they occur. David Cousens On Fri, 2022-12-30 at 14:35 -0700, Simon Roberts wrote: > 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 willing to use that if it > solves my problem). > > I imported some transactions using OFX. Several things surprised me, but > the one that I think needs resolving first is that the transaction dates do > not match the bank statement. > > Earlier I tried the CSV import and saw there were *two* date fields > (presumably difference between being received and being acted on? > > Can someone tell me what I should do to fix this? Is there a way to "tweek" > the OFX import, or do I need to use CSV? Or is this something else entirely > that's gone amiss? > > Thanks for any hints, > Cheers, > Simon > > Background in case it's relevant: > > I'm a refugee from Intuit, and very early in my learning process. > > I"m not a bookkeeper, I'm a programmer. Conversely, my bookkeeper isn't a > software person--she would have continued paying the annual ransom to > Intuit but I'm sick of their hostage taking. Of course this means I need to > do a decent part of the legwork for this transition. > > Of course because I'm not a bookkeeper, I don't understand the accounting > side of this stuff, and likely won't know how to ask/phrase the questions. > > Neither of us are going to be great at searching the documentation since it > seems like the terminology is different between GC and QB (and I don't > really know the terminology anyway) > > So, please forgive the idiot question, and if the simple answer to a > question is RTFM, we're very happy to do so, but likely are asking as we've > failed to find the relevant part of said references. > > Anyway, thanks for your indulgence :) > ___ > 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] 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 created by your bank. If you're a programmer, you might want to write a small program to edit the OFX file before importing (I have to do that for citibank because of unique ID issues). J On 12/30/2022 1:35 PM, Simon Roberts wrote: 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 willing to use that if it solves my problem). I imported some transactions using OFX. Several things surprised me, but the one that I think needs resolving first is that the transaction dates do not match the bank statement. Earlier I tried the CSV import and saw there were *two* date fields (presumably difference between being received and being acted on? Can someone tell me what I should do to fix this? Is there a way to "tweek" the OFX import, or do I need to use CSV? Or is this something else entirely that's gone amiss? Thanks for any hints, Cheers, Simon Background in case it's relevant: I'm a refugee from Intuit, and very early in my learning process. I"m not a bookkeeper, I'm a programmer. Conversely, my bookkeeper isn't a software person--she would have continued paying the annual ransom to Intuit but I'm sick of their hostage taking. Of course this means I need to do a decent part of the legwork for this transition. Of course because I'm not a bookkeeper, I don't understand the accounting side of this stuff, and likely won't know how to ask/phrase the questions. Neither of us are going to be great at searching the documentation since it seems like the terminology is different between GC and QB (and I don't really know the terminology anyway) So, please forgive the idiot question, and if the simple answer to a question is RTFM, we're very happy to do so, but likely are asking as we've failed to find the relevant part of said references. Anyway, thanks for your indulgence :) ___ 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] 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, which is rarely the same as the real event. The 'Art of Reconciliation' is teasing out from the limited bank info that I started a month with a certain balance, and that a particular list of transactions results in a certain ending balance. I should have all of those transactions in my books. Their dates are not critical, though usually are *near* the period I'm reconciling. I may have others not yet cleared as well. Hope that helps a bit. Regards, Adrien On 12/30/22 3:35 PM, Simon Roberts wrote: I imported some transactions using OFX. Several things surprised me, but the one that I think needs resolving first is that the transaction dates do not match the bank 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.