[GNC] Transfer Dates

[viking2ev at san.rr.com]

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.