Re: [GNC] How2find 1) Duplicate items imported 2)Un-Posted Bills?
On Wed, 19 Feb 2020 at 01:49, Greg Feneis wrote: > I typically import qif and ofx files into checking or credit card accounts. > GC does a pretty good job of matching pending import transactions with > transactions that are already present. Also, I have tried to import a file > that I previously tried to import, and nothing shows up in the matcher > dialog. I don't know how it knows but I'm glad it does > because, I think: OFX imports match via complex heuristics(*) OFX imports have a FITID field which is stored in a transaction split's invisible "online_id" property. QIF imports don't have a similar field, so, the matching is actually done manually during every import, and is imperfect(**) (*) matching tests: amounts match, make some allowances for ATM fee threshold, dates differ by ideally 4 days but consider up to 2 weeks. (**) matching is successful when: amounts matched, dates differ by 1 week or less. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How2find 1) Duplicate items imported 2)Un-Posted Bills?
I typically import qif and ofx files into checking or credit card accounts. GC does a pretty good job of matching pending import transactions with transactions that are already present. Also, I have tried to import a file that I previously tried to import, and nothing shows up in the matcher dialog. I don't know how it knows but I'm glad it does Kind regards, Greg Feneis (Pixel 3) On Tue, Feb 18, 2020, 16:07 Fran_3 via gnucash-user < gnucash-user@gnucash.org> wrote: > Thanks Adrian. > I'll try and run a test on importing a duplicate checking transaction.In > this case the transactions description may not match exactly and I assume > that is one of the fields tested by GC to discover that the transaction is > already in the system.The fields being imported are Date, Num, Description, > Deposit, and Withdrawal > Good answer on finding unposted Bills.Thanks again > > On Tuesday, February 18, 2020, 6:45:53 PM EST, Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > > I’m not sure about flagging, but it shouldn’t create a duplicate. > > As for the finding unposted bills, do a Business > Vendors > Find Bill and > set criteria of “Is Posted?” to unchecked. > > Regards, > Adrien > > > > On Feb 18, 2020 w8d49, at 4:05 PM, Fran_3 via gnucash-user < > gnucash-user@gnucash.org> wrote: > > > > 1) When importing or entering checking transactions does gnuCash flag > importing a transaction that is already in the system? > > 2) How do you find Un-Posted bills. > > Thanks for any help. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How2find 1) Duplicate items imported 2)Un-Posted Bills?
Thanks Adrian. I'll try and run a test on importing a duplicate checking transaction.In this case the transactions description may not match exactly and I assume that is one of the fields tested by GC to discover that the transaction is already in the system.The fields being imported are Date, Num, Description, Deposit, and Withdrawal Good answer on finding unposted Bills.Thanks again On Tuesday, February 18, 2020, 6:45:53 PM EST, Adrien Monteleone wrote: I’m not sure about flagging, but it shouldn’t create a duplicate. As for the finding unposted bills, do a Business > Vendors > Find Bill and set criteria of “Is Posted?” to unchecked. Regards, Adrien > On Feb 18, 2020 w8d49, at 4:05 PM, Fran_3 via gnucash-user > wrote: > > 1) When importing or entering checking transactions does gnuCash flag > importing a transaction that is already in the system? > 2) How do you find Un-Posted bills. > Thanks for any help. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How2find 1) Duplicate items imported 2)Un-Posted Bills?
I’m not sure about flagging, but it shouldn’t create a duplicate. As for the finding unposted bills, do a Business > Vendors > Find Bill and set criteria of “Is Posted?” to unchecked. Regards, Adrien > On Feb 18, 2020 w8d49, at 4:05 PM, Fran_3 via gnucash-user > wrote: > > 1) When importing or entering checking transactions does gnuCash flag > importing a transaction that is already in the system? > 2) How do you find Un-Posted bills. > Thanks for any help. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.