[GNC] [gnc] Forecasting savings
Hello community, I would like to know what is the best way (if there is) to project savings evolution in gnc based or scheduled transaction (income, tax, average spending, loan etc...). The goal is ti properly budget and know if at some time a more important transaction is reasonable or not (install A/C, buy a car etc...) Thank you ___ 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.
Re: [GNC] Use same transfer column info for identical description
Hello!
I went deeper into the importer yesterday night. I sorted 1400 transaction
in 2h. It could be of course improved but honestly the experience was
great.
I have done the hard work and quicker than expected.
Let's see for future updates how the automatic detection works.
Thanks everyone
El mar., 16 abr. 2024 5:19, Christopher Lam
escribió:
> The importer has had some upgrades in the past couple years. You can sort
> by description in the importer, select multiple transactions with similar
> descriptions, mass assign to a particular account, mass rename the
> description too, via the right click menu.
>
> On Tue, 16 Apr 2024, 4:14 am Adrien Laveau,
> wrote:
>
>> 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&quo
Re: [GNC] Use same transfer column info for identical description
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
> 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
[GNC] Use same transfer column info for identical description
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. I found old topics about that saying it had to be done manually. Has it changed? Thank you Adrien ___ 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.
