Re: [GNC] Transfer Dates
Then edit the CSV for the proper Descriptions & Accounts before importing. More than likely, that can be scripted or at least accomplished with some creative copy/paste (or spreadsheet formulas/macros) to speed things up if the file is really large. *Note! - it is always advised to import smaller batches repeatedly to train the importer. Trying to import say, 10 years worth of data, is going to be a pain. The time savings of the importer learning your transactions comes from repeated importing. (teaching it what it guesses wrong as you go) The usual advice is one month at a time, but I'd say that depends on account activity. Be your own judge of how many transactions you want to train the importer with at a time. Probably something like 100 transactions would be a reasonable 'top-limit' though that may be a bit high depending on your stamina and pain threshold for repetitive work. Regards, Adrien On 6/5/22 7:40 PM, viking...@san.rr.com wrote: @Gyle, The suggested approach may work well when entering the transactions manually and then reconciling. However, I am not entering the transactions manually. I am importing all the bank transactions, including the transfers, from several CSV files to an empty GnuCash file. ___ 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] Transfer Dates
That's what the Description line is for. I suppose you can use it for all sorts of things, but personally I only use it as a 'payee' line, that is, whomever is receiving my funds. If I'm the one receiving, then it is a 'payor' line, the one giving me money. Sticking to that, you should easily be able to see where in-transit funds are coming from and going to. If that still isn't good enough, create sub-accounts for either sources or destinations. Regards, Adrien On Mon, 6 Jun 2022 at 07:55, wrote: A disadvantage of using a “Funds in Transit account” is that I wouldn’t easily see where the money was going (I am transferring between more than two banks). ___ 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] Transfer Dates
Viking2ev, There is no way to automate the creation of perfect data from imperfect sources. Whatever method you choose, you will need to do some massaging manually. Sometimes it may make sense to edit a CSV file, sometimes it may make more sense to use the import matching function, or even to use a hybrid approach. Since the desired result is to please yourself, you can be as creative as you want to be. On Sun, Jun 5, 2022 at 7:41 PM wrote: > @Gyle, > The suggested approach may work well when entering the transactions > manually > and then reconciling. > > > However, I am not entering the transactions manually. I am importing all > the > bank transactions, including the transfers, from several CSV files to an > empty GnuCash file. > > > > From: Gyle McCollam [mailto:gmccol...@live.com] > Sent: 05 June, 2022 17:32 > To: viking...@san.rr.com; gnucash-user@gnucash.org > Subject: Re: [GNC] Transfer Dates > > > > When you enter the transfer, it should be something like this in the > description: > > > > In Bank 1 you would enter a credit "Transfer to Bank 2" or Bank 3, etc. > with > the date of the transfer and the debit account being the "in transit > account". > > > > Then in Bank 2 you would enter "Transfer from Bank 1" as a debit and the > credit would be the "in transit account" and the date here would be the > date > received by Bank 2. > > > > This way the "in transit" account would be zero, but each Bank would have > the correct date. > > Then when you import to reconcile Bank 1 you would only have the Bank 1 > transactions and when you import Bank 2 to reconcile that account you only > have Bank 2 transactions. By using the description Transfer to Bank X or > Transfer from bank Y, you would clearly be able to tell which bank the > money > came from and which bank the money was transferred to. > > > > Thank You, > Gyle McCollam > > Gyle McCollam > > 609.680.2326 Mobile > > <mailto:gmccol...@gyleshomes.com> gmccol...@live.com email > > _ > > From: gnucash-user on > behalf of viking...@san.rr.com > Sent: Sunday, June 5, 2022 8:11 PM > To: 'Gnucash Users' > Subject: Re: [GNC] Transfer Dates > > > > @David, > > If I use an intermediary "Funds in Transit account", wouldn't I run into > the > same issue when importing bank1? It would match the original transfer date > of bank2 in the "Funds in Transit account". I would need to force it to not > match. > > A disadvantage of using a "Funds in Transit account" is that I wouldn't > easily see where the money was going (I am transferring between more than > two banks). > > > I was hoping that there was maybe some way of using another date column in > GnuCash (like having a transaction and a post date). > > If I recall correctly, Quicken actually modified the dates when importing > so > that each bank showed the correct dates. > > I guess that I could modify the CSV file of bank1 to include the bank1 > dates > in the description.. > > > > From: David H [mailto:hell...@gmail.com] > Sent: 05 June, 2022 14:15 > To: viking...@san.rr.com > Cc: Gnucash Users > Subject: Re: [GNC] Transfer Dates > > > > If you want to be exact you probably need to use something like a "Funds in > Transit" account - transfer from bank2 to funds in transit on date 1 and > then transfer from funds in transit to bank1 3-5 days later. Effectively > you'd be splitting each transaction into 2 transactions. > > > > Cheers David H. > > > > On Mon, 6 Jun 2022 at 07:03, wrote: > > I have transferred money back and forth between bank1 and bank2. > 1. I first imported my transactions from bank2. > > 2. I then imported my transactions from bank1. > > The transfers between the accounts are matched and are therefore not > imported to bank1 (as expected). > > However, the dates of the transfers are correct in bank2 but incorrect in > bank1 because there is a 3-5 days delay for the transfers (and bank2 was > imported before bank1). > > > Is there any way to log the correct dates in bank1 (while also retaining > the > correct date in bank2)? > > > > ___ > 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 re
Re: [GNC] Transfer Dates
Ah my bad, I thought you'd just replied to me and wouldn't get more advice from the list especially from the user's that do use the importers :-) Cheers David H. On Mon, 6 Jun 2022 at 10:10 am, wrote: > I am sorry David. I hit “reply” when I should have hit “reply all”, right? > I sent the previous mail to the group as well. > > I am importing because I am trying to create a new GnuCash file with a lot > of transactions from different financial institutions; all of them are in > CSV (xls). When done, I don’t intend to import anymore. > > I am typically only going between two different banks. Most of the > transactions are between Bank1 and another bank, e.g. Bank2, Bank3, Bank4 > etc. In that sense a “Funds in Transit account” may work because most > (but not all) transfers are from/to Bank1. In any case, I would still need > to force it to not match when importing Bank1. > > > > > > *From:* David H [mailto:hell...@gmail.com] > *Sent:* 05 June, 2022 16:58 > *To:* viking...@san.rr.com; Gnucash Users > *Subject:* Re: [GNC] Transfer Dates > > > > Mate, keep it on-list so others can offer suggestions/chip in where > relevant. Case in point I NEVER import anything so I can't comment on how > the matching works, others that do obviously can. I ALWAYS manually enter > txns that way when I reconcile I'm not reconciling the bank's txns against > the bank's statement :-) > > > > You have other options - as you say add something to the description > column to say where the funds are going to in the long run - you didn't say > you were transferring between more than 2 banks, so you're going from bank1 > to bank2 to bank3 sort of ? > > > > Forget Quicken, you left it for a reason :-) > > > > Cheers David H. > > > > > > > > > > On Mon, 6 Jun 2022 at 07:55, wrote: > > If I use an intermediary “Funds in Transit account”, wouldn’t I run into > the same issue when importing bank1? It would match the original transfer > date of bank2 in the “Funds in Transit account”. I would need to force it > to not match. > > A disadvantage of using a “Funds in Transit account” is that I wouldn’t > easily see where the money was going (I am transferring between more than > two banks). > > > I was hoping that there was maybe some way of using another date column in > GnuCash (like having a transaction and a post date). > > If I recall correctly, Quicken actually modified the dates when importing > so that each bank showed the correct dates. > > I guess that I could modify the CSV file of bank1 to include the bank1 > dates in the description…. > > > > *From:* David H [mailto:hell...@gmail.com] > *Sent:* 05 June, 2022 14:15 > *To:* viking...@san.rr.com > *Cc:* Gnucash Users > *Subject:* Re: [GNC] Transfer Dates > > > > If you want to be exact you probably need to use something like a "Funds > in Transit" account - transfer from bank2 to funds in transit on date 1 and > then transfer from funds in transit to bank1 3-5 days later. Effectively > you'd be splitting each transaction into 2 transactions. > > > > Cheers David H. > > > > On Mon, 6 Jun 2022 at 07:03, wrote: > > I have transferred money back and forth between bank1 and bank2. > 1. I first imported my transactions from bank2. > > 2. I then imported my transactions from bank1. > > The transfers between the accounts are matched and are therefore not > imported to bank1 (as expected). > > However, the dates of the transfers are correct in bank2 but incorrect in > bank1 because there is a 3-5 days delay for the transfers (and bank2 was > imported before bank1). > > > Is there any way to log the correct dates in bank1 (while also retaining > the > correct date in bank2)? > > > > ___ > 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] Transfer Dates
@Gyle, The suggested approach may work well when entering the transactions manually and then reconciling. However, I am not entering the transactions manually. I am importing all the bank transactions, including the transfers, from several CSV files to an empty GnuCash file. From: Gyle McCollam [mailto:gmccol...@live.com] Sent: 05 June, 2022 17:32 To: viking...@san.rr.com; gnucash-user@gnucash.org Subject: Re: [GNC] Transfer Dates When you enter the transfer, it should be something like this in the description: In Bank 1 you would enter a credit "Transfer to Bank 2" or Bank 3, etc. with the date of the transfer and the debit account being the "in transit account". Then in Bank 2 you would enter "Transfer from Bank 1" as a debit and the credit would be the "in transit account" and the date here would be the date received by Bank 2. This way the "in transit" account would be zero, but each Bank would have the correct date. Then when you import to reconcile Bank 1 you would only have the Bank 1 transactions and when you import Bank 2 to reconcile that account you only have Bank 2 transactions. By using the description Transfer to Bank X or Transfer from bank Y, you would clearly be able to tell which bank the money came from and which bank the money was transferred to. Thank You, Gyle McCollam Gyle McCollam 609.680.2326 Mobile <mailto:gmccol...@gyleshomes.com> gmccol...@live.com email _ From: gnucash-user on behalf of viking...@san.rr.com Sent: Sunday, June 5, 2022 8:11 PM To: 'Gnucash Users' Subject: Re: [GNC] Transfer Dates @David, If I use an intermediary "Funds in Transit account", wouldn't I run into the same issue when importing bank1? It would match the original transfer date of bank2 in the "Funds in Transit account". I would need to force it to not match. A disadvantage of using a "Funds in Transit account" is that I wouldn't easily see where the money was going (I am transferring between more than two banks). I was hoping that there was maybe some way of using another date column in GnuCash (like having a transaction and a post date). If I recall correctly, Quicken actually modified the dates when importing so that each bank showed the correct dates. I guess that I could modify the CSV file of bank1 to include the bank1 dates in the description.. From: David H [mailto:hell...@gmail.com] Sent: 05 June, 2022 14:15 To: viking...@san.rr.com Cc: Gnucash Users Subject: Re: [GNC] Transfer Dates If you want to be exact you probably need to use something like a "Funds in Transit" account - transfer from bank2 to funds in transit on date 1 and then transfer from funds in transit to bank1 3-5 days later. Effectively you'd be splitting each transaction into 2 transactions. Cheers David H. On Mon, 6 Jun 2022 at 07:03, wrote: I have transferred money back and forth between bank1 and bank2. 1. I first imported my transactions from bank2. 2. I then imported my transactions from bank1. The transfers between the accounts are matched and are therefore not imported to bank1 (as expected). However, the dates of the transfers are correct in bank2 but incorrect in bank1 because there is a 3-5 days delay for the transfers (and bank2 was imported before bank1). Is there any way to log the correct dates in bank1 (while also retaining the correct date in bank2)? ___ 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] Transfer Dates
When you enter the transfer, it should be something like this in the description: In Bank 1 you would enter a credit "Transfer to Bank 2" or Bank 3, etc. with the date of the transfer and the debit account being the "in transit account". Then in Bank 2 you would enter "Transfer from Bank 1" as a debit and the credit would be the "in transit account" and the date here would be the date received by Bank 2. This way the "in transit" account would be zero, but each Bank would have the correct date. Then when you import to reconcile Bank 1 you would only have the Bank 1 transactions and when you import Bank 2 to reconcile that account you only have Bank 2 transactions. By using the description Transfer to Bank X or Transfer from bank Y, you would clearly be able to tell which bank the money came from and which bank the money was transferred to. Thank You, Gyle McCollam Gyle McCollam 609.680.2326 Mobile gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email From: gnucash-user on behalf of viking...@san.rr.com Sent: Sunday, June 5, 2022 8:11 PM To: 'Gnucash Users' Subject: Re: [GNC] Transfer Dates @David, If I use an intermediary “Funds in Transit account”, wouldn’t I run into the same issue when importing bank1? It would match the original transfer date of bank2 in the “Funds in Transit account”. I would need to force it to not match. A disadvantage of using a “Funds in Transit account” is that I wouldn’t easily see where the money was going (I am transferring between more than two banks). I was hoping that there was maybe some way of using another date column in GnuCash (like having a transaction and a post date). If I recall correctly, Quicken actually modified the dates when importing so that each bank showed the correct dates. I guess that I could modify the CSV file of bank1 to include the bank1 dates in the description…. From: David H [mailto:hell...@gmail.com] Sent: 05 June, 2022 14:15 To: viking...@san.rr.com Cc: Gnucash Users Subject: Re: [GNC] Transfer Dates If you want to be exact you probably need to use something like a "Funds in Transit" account - transfer from bank2 to funds in transit on date 1 and then transfer from funds in transit to bank1 3-5 days later. Effectively you'd be splitting each transaction into 2 transactions. Cheers David H. On Mon, 6 Jun 2022 at 07:03, wrote: I have transferred money back and forth between bank1 and bank2. 1. I first imported my transactions from bank2. 2. I then imported my transactions from bank1. The transfers between the accounts are matched and are therefore not imported to bank1 (as expected). However, the dates of the transfers are correct in bank2 but incorrect in bank1 because there is a 3-5 days delay for the transfers (and bank2 was imported before bank1). Is there any way to log the correct dates in bank1 (while also retaining the correct date in bank2)? ___ 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] Transfer Dates
If you import from bank 1 with the transfers to a Funds in transit account as the transfer account rather than bank 2 and then import the records from bank 2 with the transfer account as funds in transit, the dates will be correct in each of the bank accounts. The funds in transit account will end up with a zero balance provided all the imports match up and you should be good to go. The Import matcher window only matches to transactions that exist in the account you are importing to and as long as you don't import to the funds in transit account, there should be no problem. The matching in the funds in transit account should be automatic ( unless there are transfer fees involved). Any non- zero balance in it after you have imported all transactions will indicate unmatched transactions. You can also use the multiple selection features in the import matcher window to select all transactions which have the Funds in transit account as the transfer account and assign that account in a single step. David Cousens On Sun, 2022-06-05 at 17:10 -0700, viking...@san.rr.com wrote: > I am sorry David. I hit “reply” when I should have hit “reply all”, right? I > sent the previous mail to the group as well. > > I am importing because I am trying to create a new GnuCash file with a lot of > transactions from different financial institutions; all of them are in CSV > (xls). When done, I don’t intend to import anymore. > > I am typically only going between two different banks. Most of the > transactions are between Bank1 and another bank, e.g. Bank2, Bank3, Bank4 etc. > In that sense a “Funds in Transit account” may work because most (but not all) > transfers are from/to Bank1. In any case, I would still need to force it to > not match when importing Bank1. > > > > > > > > From: David H [mailto:hell...@gmail.com] > Sent: 05 June, 2022 16:58 > To: viking...@san.rr.com; Gnucash Users > Subject: Re: [GNC] Transfer Dates > > > > Mate, keep it on-list so others can offer suggestions/chip in where relevant. > Case in point I NEVER import anything so I can't comment on how the matching > works, others that do obviously can. I ALWAYS manually enter txns that way > when I reconcile I'm not reconciling the bank's txns against the bank's > statement :-) > > > > You have other options - as you say add something to the description column to > say where the funds are going to in the long run - you didn't say you were > transferring between more than 2 banks, so you're going from bank1 to bank2 to > bank3 sort of ? > > > > Forget Quicken, you left it for a reason :-) > > > > Cheers David H. > > > > > > > > > > On Mon, 6 Jun 2022 at 07:55, wrote: > > If I use an intermediary “Funds in Transit account”, wouldn’t I run into the > same issue when importing bank1? It would match the original transfer date of > bank2 in the “Funds in Transit account”. I would need to force it to not > match. > > A disadvantage of using a “Funds in Transit account” is that I wouldn’t easily > see where the money was going (I am transferring between more than two banks). > > > I was hoping that there was maybe some way of using another date column in > GnuCash (like having a transaction and a post date). > > If I recall correctly, Quicken actually modified the dates when importing so > that each bank showed the correct dates. > > I guess that I could modify the CSV file of bank1 to include the bank1 dates > in the description…. > > > > From: David H [mailto:hell...@gmail.com] > Sent: 05 June, 2022 14:15 > To: viking...@san.rr.com > Cc: Gnucash Users > Subject: Re: [GNC] Transfer Dates > > > > If you want to be exact you probably need to use something like a "Funds in > Transit" account - transfer from bank2 to funds in transit on date 1 and then > transfer from funds in transit to bank1 3-5 days later. Effectively you'd be > splitting each transaction into 2 transactions. > > > > Cheers David H. > > > > On Mon, 6 Jun 2022 at 07:03, wrote: > > I have transferred money back and forth between bank1 and bank2. > 1. I first imported my transactions from bank2. > > 2. I then imported my transactions from bank1. > > The transfers between the accounts are matched and are therefore not > imported to bank1 (as expected). > > However, the dates of the transfers are correct in bank2 but incorrect in > bank1 because there is a 3-5 days delay for the transfers (and bank2 was > imported before bank1). > > > Is there any way to log the correct dates in bank1 (while also retaining the > correct date in bank2)? &
Re: [GNC] Transfer Dates
@David, If I use an intermediary “Funds in Transit account”, wouldn’t I run into the same issue when importing bank1? It would match the original transfer date of bank2 in the “Funds in Transit account”. I would need to force it to not match. A disadvantage of using a “Funds in Transit account” is that I wouldn’t easily see where the money was going (I am transferring between more than two banks). I was hoping that there was maybe some way of using another date column in GnuCash (like having a transaction and a post date). If I recall correctly, Quicken actually modified the dates when importing so that each bank showed the correct dates. I guess that I could modify the CSV file of bank1 to include the bank1 dates in the description…. From: David H [mailto:hell...@gmail.com] Sent: 05 June, 2022 14:15 To: viking...@san.rr.com Cc: Gnucash Users Subject: Re: [GNC] Transfer Dates If you want to be exact you probably need to use something like a "Funds in Transit" account - transfer from bank2 to funds in transit on date 1 and then transfer from funds in transit to bank1 3-5 days later. Effectively you'd be splitting each transaction into 2 transactions. Cheers David H. On Mon, 6 Jun 2022 at 07:03, wrote: I have transferred money back and forth between bank1 and bank2. 1. I first imported my transactions from bank2. 2. I then imported my transactions from bank1. The transfers between the accounts are matched and are therefore not imported to bank1 (as expected). However, the dates of the transfers are correct in bank2 but incorrect in bank1 because there is a 3-5 days delay for the transfers (and bank2 was imported before bank1). Is there any way to log the correct dates in bank1 (while also retaining the correct date in bank2)? ___ 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] Transfer Dates
I am sorry David. I hit “reply” when I should have hit “reply all”, right? I sent the previous mail to the group as well. I am importing because I am trying to create a new GnuCash file with a lot of transactions from different financial institutions; all of them are in CSV (xls). When done, I don’t intend to import anymore. I am typically only going between two different banks. Most of the transactions are between Bank1 and another bank, e.g. Bank2, Bank3, Bank4 etc. In that sense a “Funds in Transit account” may work because most (but not all) transfers are from/to Bank1. In any case, I would still need to force it to not match when importing Bank1. From: David H [mailto:hell...@gmail.com] Sent: 05 June, 2022 16:58 To: viking...@san.rr.com; Gnucash Users Subject: Re: [GNC] Transfer Dates Mate, keep it on-list so others can offer suggestions/chip in where relevant. Case in point I NEVER import anything so I can't comment on how the matching works, others that do obviously can. I ALWAYS manually enter txns that way when I reconcile I'm not reconciling the bank's txns against the bank's statement :-) You have other options - as you say add something to the description column to say where the funds are going to in the long run - you didn't say you were transferring between more than 2 banks, so you're going from bank1 to bank2 to bank3 sort of ? Forget Quicken, you left it for a reason :-) Cheers David H. On Mon, 6 Jun 2022 at 07:55, wrote: If I use an intermediary “Funds in Transit account”, wouldn’t I run into the same issue when importing bank1? It would match the original transfer date of bank2 in the “Funds in Transit account”. I would need to force it to not match. A disadvantage of using a “Funds in Transit account” is that I wouldn’t easily see where the money was going (I am transferring between more than two banks). I was hoping that there was maybe some way of using another date column in GnuCash (like having a transaction and a post date). If I recall correctly, Quicken actually modified the dates when importing so that each bank showed the correct dates. I guess that I could modify the CSV file of bank1 to include the bank1 dates in the description…. From: David H [mailto:hell...@gmail.com] Sent: 05 June, 2022 14:15 To: viking...@san.rr.com Cc: Gnucash Users Subject: Re: [GNC] Transfer Dates If you want to be exact you probably need to use something like a "Funds in Transit" account - transfer from bank2 to funds in transit on date 1 and then transfer from funds in transit to bank1 3-5 days later. Effectively you'd be splitting each transaction into 2 transactions. Cheers David H. On Mon, 6 Jun 2022 at 07:03, wrote: I have transferred money back and forth between bank1 and bank2. 1. I first imported my transactions from bank2. 2. I then imported my transactions from bank1. The transfers between the accounts are matched and are therefore not imported to bank1 (as expected). However, the dates of the transfers are correct in bank2 but incorrect in bank1 because there is a 3-5 days delay for the transfers (and bank2 was imported before bank1). Is there any way to log the correct dates in bank1 (while also retaining the correct date in bank2)? ___ 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] Transfer Dates
Mate, keep it on-list so others can offer suggestions/chip in where relevant. Case in point I NEVER import anything so I can't comment on how the matching works, others that do obviously can. I ALWAYS manually enter txns that way when I reconcile I'm not reconciling the bank's txns against the bank's statement :-) You have other options - as you say add something to the description column to say where the funds are going to in the long run - you didn't say you were transferring between more than 2 banks, so you're going from bank1 to bank2 to bank3 sort of ? Forget Quicken, you left it for a reason :-) Cheers David H. On Mon, 6 Jun 2022 at 07:55, wrote: > If I use an intermediary “Funds in Transit account”, wouldn’t I run into > the same issue when importing bank1? It would match the original transfer > date of bank2 in the “Funds in Transit account”. I would need to force it > to not match. > > A disadvantage of using a “Funds in Transit account” is that I wouldn’t > easily see where the money was going (I am transferring between more than > two banks). > > > I was hoping that there was maybe some way of using another date column in > GnuCash (like having a transaction and a post date). > > If I recall correctly, Quicken actually modified the dates when importing > so that each bank showed the correct dates. > > I guess that I could modify the CSV file of bank1 to include the bank1 > dates in the description…. > > > > *From:* David H [mailto:hell...@gmail.com] > *Sent:* 05 June, 2022 14:15 > *To:* viking...@san.rr.com > *Cc:* Gnucash Users > *Subject:* Re: [GNC] Transfer Dates > > > > If you want to be exact you probably need to use something like a "Funds > in Transit" account - transfer from bank2 to funds in transit on date 1 and > then transfer from funds in transit to bank1 3-5 days later. Effectively > you'd be splitting each transaction into 2 transactions. > > > > Cheers David H. > > > > On Mon, 6 Jun 2022 at 07:03, wrote: > > I have transferred money back and forth between bank1 and bank2. > 1. I first imported my transactions from bank2. > > 2. I then imported my transactions from bank1. > > The transfers between the accounts are matched and are therefore not > imported to bank1 (as expected). > > However, the dates of the transfers are correct in bank2 but incorrect in > bank1 because there is a 3-5 days delay for the transfers (and bank2 was > imported before bank1). > > > Is there any way to log the correct dates in bank1 (while also retaining > the > correct date in bank2)? > > > > ___ > 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] Transfer Dates
If you want to be exact you probably need to use something like a "Funds in Transit" account - transfer from bank2 to funds in transit on date 1 and then transfer from funds in transit to bank1 3-5 days later. Effectively you'd be splitting each transaction into 2 transactions. Cheers David H. On Mon, 6 Jun 2022 at 07:03, wrote: > I have transferred money back and forth between bank1 and bank2. > 1. I first imported my transactions from bank2. > > 2. I then imported my transactions from bank1. > > The transfers between the accounts are matched and are therefore not > imported to bank1 (as expected). > > However, the dates of the transfers are correct in bank2 but incorrect in > bank1 because there is a 3-5 days delay for the transfers (and bank2 was > imported before bank1). > > > Is there any way to log the correct dates in bank1 (while also retaining > the > correct date in bank2)? > > > > ___ > 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.