[GNC] Transfer Dates

Sun Jun 5 20:31:11 EDT 2022

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, viking2ev at 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:hellvee at gmail.com] 
> Sent: 05 June, 2022 16:58
> To: viking2ev at 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, <viking2ev at san.rr.com> 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:hellvee at gmail.com] 
> Sent: 05 June, 2022 14:15
> To: viking2ev at 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, <viking2ev at san.rr.com> 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 at 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 at 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.