[GNC] Transfer Dates

[David Carlson]

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 <viking2ev at 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.
>
>
>
> 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.
>
> _______________________________________________
> 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.
>


-- 
David Carlson