Hello,
Thank you both for your time answering my question.
At the moment my data being in GNC or not is not a big deal.
I have the CSV/XLS fiel extracts (sadly my banks do not connect with GNC
online systems).
It is of the following form :
Description Amount Date
DescA xx 2024/03/12
DescB yy ...
DescC zz
DescB ii
DescB aa
DescC rr
...
And I want DescA to go in one transfer, DescB to go in another one and C in
another one.
I have understood your method and remember it, but for the moment I cannot
use it as the "initial répartition" is not done.
And also it does not seem to solve the problem of future transaction witj
the same description.
Indeed I plan to regularly get the CSV from sll my accountd and import them
in GNC and I would have expected those new transaction to take the correct
transfer action.
The best guess I have now is to do it in Excel before importing and having
the mapping I am looking for, directly in Excel.
Thanks again
El lun., 15 abr. 2024 14:12, Kevin Buckley via gnucash-user <
gnucash-user@gnucash.org> escribió:
> On Monday, April 15th, 2024 at 04:40, Jim DeLaHunt <list+gnuc...@jdlh.com>
> wrote:
> >
> > Hello, Adrien, and welcome to MusicBrainz!
>
> Surely: "... welcome to GnuCash!" ?
>
> >
> > On 2024-04-14 13:03, Adrien Laveau wrote:
> >
> > > Hello community,
> > >
> > > I uploaded 5 years worth of bank account transaction to gnu-cash.
> > >
> > > I would like the apply the same transfer information to all the
> > > transactions having the same description and keep applying it
> > > automatically to all future transaction.
> >
> >
> > It sounds like you want to do two different things:
> >
> > 1. Change the details ("transfer column info") which you have already
> > imported into your book file to match your desired contents.
> > 2. Ensure that GnuCash uses your desired contents for future
> > transactions which you enter into GnuCash using the "same description".
> >
> > I don't have easy suggestions for #1, except to go through transactions
> > one by one and correct them. It may be tedious, but you only have to do
> > it once. (I have a difficult suggestion: to edit the GnuCash XML book
> > file. This is dangerous but sometimes effective. It requires skills in
> > working with XML and file formats.)
> >
>
> As someone who's not completely unfamiliar with editing GnuCash's
> XML, I would like to say that doing what you are suggesting you
> want to do here, by editing the XML, is going to be a large task,
> because you would have to identify the various GUIDs (32 character
> strings of text that give you no clue as to what each one is) that,
> in the XML file, take the place of what you see, as the transfer
> account, in the Register.
>
> As Jim implies, it could be done, but I'm not sure you would want
> to.
>
> There may, depending on how cleanly your old data was imported,
> be a bit of a "saving grace", as to what you are trying to do,
> via an approach that doesn't mean you need to go through ALL
> your TXNs one by one. You might still need to address a small
> number of outliers.
>
> It does, however, mean "Deleting" some things, but don't stop
> reading yet, as it's not as bad as it sounds.
>
> As I understand things, you have ended up with a lot of TXNs that
> look like, where Desc1 is the same string every time
>
> Description: Desc1, Transfer account: XFR1
> Description: Desc1, Transfer account: XFR2
> Description: Desc1, Transfer account: XFR1
> Description: Desc1, Transfer account: XFR3
> Description: Desc1, Transfer account: XFR3
> Description: Desc1, Transfer account: XFR2
> Description: Desc1, Transfer account: XFR1
>
> scattered across any number of accounts, whereas you want all
> those TXNs to be going into a single Transfer account: let's
> say, XFR1.
>
> So, I need to assume that, after you imported them, you have a
> chart of accounts (and let's assume the transfer accounts are
> all Expenses, so as to have a top-level account to work with)
> something akin to the following, where all of your imported
> TXNs are in one of three NEW transfer accounts, so
>
> Expenses
> +- XFR1
> +- XFR2
> +- XFR3
>
> and that there's nothing but your imported TXNs that have those
> new transfer accounts associated with them.
>
> If you ended up importing your old data so that your old TXNs
> ended up associated with existing transfer accounts, then stop
> reading, as you are going to have to do them, one-by-one.
>
> Still with me?
>
> OK, if you go to Delete account XFR2, you will be asked if you
> want to delete all of its TXNs, OR have them "Moved to" another
> account, which, for your needs, would be "Expenses:XFR1".
>
> Similary, when you come to delete XFR3, all its TXNs could
> placed into XFR1 as well.
>
> I hope that makes sense, and that your data allows you to try
> that approach.
>
> This should go without saying, but, please make a back-up before
> you start attempting to edit your data in these "slightly less
> than typical" ways.
>
>
>
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> 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
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
