[GNC] Transfer Dates

[viking2ev at san.rr.com]

@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:gmccollam at live.com] 
Sent: 05 June, 2022 17:32
To: viking2ev at san.rr.com; gnucash-user at 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:gmccollam at gyleshomes.com> gmccollam at live.com           email

  _____  

From: gnucash-user <gnucash-user-bounces+gylemc=gmail.com at gnucash.org> on
behalf of viking2ev at san.rr.com <viking2ev at san.rr.com>
Sent: Sunday, June 5, 2022 8:11 PM
To: 'Gnucash Users' <gnucash-user at gnucash.org>
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: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.