Re: [GNC] Importing csv files

[David Carlson]

Mark,

The Help manual chapter 6 gives a good starting point to configuring a
successful CSV transaction import.  However, it does not describe importing
accounts.

GnuCash is supposed to be able to import anything that it can export, so if
you try to find an existing account tree example in a test file, possibly
created by the Gnucash account setup wizard, you can try exporting it to
see what might work in the import direction.  If you have tried that and it
still fails, you should at least have a well detailed example to use when
you return to ask this group for additional help.



On Thu, Jan 19, 2023 at 8:43 PM Mark Bole  wrote:

> By coincidence, I too am trying to import my QuickBooks well-tuned COA
> into GnuCash via CSV files.  I already knew to try the things
> recommended in this thread but still have indeterminate results. I
> realize by now that with the time already invested (especially after I
> finish writing this), I could have manually altered the sub-account
> status and been done with it, but I want to understand what is going on
> at a lower level.
>
> I broke my QB accounts into smaller chunks for better testing and
> recovery if needed. _/My first batch import of type BANK accounts worked
> fine!/_  But now, with the same CSV format, I find I cannot successfully
> import further small groups of account rows from CSV files.  The
> Preview, even more frustrating, can show that the first four or five
> input rows don't parse correctly, but then suddenly  row six is fine for
> import in the preview.
>
> Is there documentation somewhere as to allowed characters, field
> lengths, etc for CSV import of accounts?
>
> Here is an example of an import file that fails for me.  The top level
> and sub-accounts exist.  Why won't it import successfully?
>
> Type,Full Account Name,Account Name,Description,Account
> Color,Notes,Symbol,Namespace,Hidden,Tax Info,Placeholder
> ASSET,Current Assets:Other Current Assets:Ibond,Ibond,Treasury
> Direct,,,USD,CURRENCY,F,F,F
>
> -Mark B.
>
> On 2023-01-19 11:58, R Losey wrote:
> > Also, do you really need to import data from Quickbooks? I used Quicken,
> > not Quickbooks, but (by and large), I just started up GnuCash afresh and
> > went back to Quicken only when I needed to look things up.  Now that I'm
> > years into GnuCash, I have had no need to go back to Quicken.
> >
> >
> >
> > On Wed, Jan 18, 2023 at 7:30 PM rudy beuc  wrote:
> >
> >> Hello,
> >>
> >> I'm trying to migrate from Quickbooks to GnuCash.
> >>
> >> I'd like to keep as much information as I can for record keeping. To
> >> that end I've first been trying to import my accounts structure in via a
> >> csv file and failing badly.
> >>
> >> Pre Christmas holidays I was getting an error message I could not
> >> interpret. Now I've installed the latest stable version 4.13 and it just
> >> dies mid process.
> >>
> >> I'm running on Windows 11 and using open office to manipulate the csv
> >> files before trying to import.
> >>
> >> Where can I find a good discussion or indepth material on importing csv
> >> files, the expected format for them, ect...?
> >>
> ___
> 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.
>


-- 
David Carlson
___
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] Importing csv files

[flywire]

There is no panacea for replacing QuickBooks with GnuCash but I'm starting
to warm to the workarounds:
* https://lists.gnucash.org/pipermail/gnucash-user/2022-February/099811.html
- use tags instead of classes, the transaction report is the only one that
supports filtering so other reports would need to be modified, also no
grouping by tag (ie every transaction shown) in any report
*
https://lists.gnucash.org/pipermail/gnucash-user/2021-September/097666.html
- Cash Accounting with Automated GST which requires data to be prepared
offline and imported instead of using the Gnucash gui

I'll test these workarounds soon because I'm keen to give Quickbooks the
flick.

Mark Bole wrote:

> Here is an example of an import file...

Open the file in a spreadsheet and simplify it. There is a linked an
example in my previous post. Also,
https://bugs.gnucash.org/show_bug.cgi?id=797711

rudy beuc wrote:

> The best way I found to give up QB classes is to simply add an additional
> subaccount. Then when needed do transaction report looking for that
> "class". Works great for rental properties.

... said the one-legged person walking down the track. "Works great"
implies the workaround is as good as Quickbooks classes, which it isn't for
either data entry or reporting.

Steve Brown wrote

> I've had very good results with this
> https://github.com/erikmack/qb-escape.git

This would be great if the python bindings ( https://lwn.net/Articles/729087
) were part of the GnuCash executables. GnuCash can be recompiled but
forget it for Windows.

R Losey wrote:

> Also, do you really need to import data from Quickbooks?

It is normally useful to convert any data you can. There are plenty in this
community with decades of data, especially for investments. You need
history for tax records, time series analysis, eg rental payments,
insurance bills, water usage, etc., and preparing budgets.

Michael or Penny Novack wrote:

> Sure you weren't meaning Quicken

Your commentary is normally fairly enlightening but I meant what I wrote
there.
___
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] Importing csv files

[Mark Bole]

By coincidence, I too am trying to import my QuickBooks well-tuned COA 
into GnuCash via CSV files.  I already knew to try the things 
recommended in this thread but still have indeterminate results. I 
realize by now that with the time already invested (especially after I 
finish writing this), I could have manually altered the sub-account 
status and been done with it, but I want to understand what is going on 
at a lower level.


I broke my QB accounts into smaller chunks for better testing and 
recovery if needed. _/My first batch import of type BANK accounts worked 
fine!/_  But now, with the same CSV format, I find I cannot successfully 
import further small groups of account rows from CSV files.  The 
Preview, even more frustrating, can show that the first four or five 
input rows don't parse correctly, but then suddenly  row six is fine for 
import in the preview.


Is there documentation somewhere as to allowed characters, field 
lengths, etc for CSV import of accounts?


Here is an example of an import file that fails for me.  The top level 
and sub-accounts exist.  Why won't it import successfully?


Type,Full Account Name,Account Name,Description,Account 
Color,Notes,Symbol,Namespace,Hidden,Tax Info,Placeholder
ASSET,Current Assets:Other Current Assets:Ibond,Ibond,Treasury 
Direct,,,USD,CURRENCY,F,F,F


-Mark B.

On 2023-01-19 11:58, R Losey wrote:

Also, do you really need to import data from Quickbooks? I used Quicken,
not Quickbooks, but (by and large), I just started up GnuCash afresh and
went back to Quicken only when I needed to look things up.  Now that I'm
years into GnuCash, I have had no need to go back to Quicken.



On Wed, Jan 18, 2023 at 7:30 PM rudy beuc  wrote:


Hello,

I'm trying to migrate from Quickbooks to GnuCash.

I'd like to keep as much information as I can for record keeping. To
that end I've first been trying to import my accounts structure in via a
csv file and failing badly.

Pre Christmas holidays I was getting an error message I could not
interpret. Now I've installed the latest stable version 4.13 and it just
dies mid process.

I'm running on Windows 11 and using open office to manipulate the csv
files before trying to import.

Where can I find a good discussion or indepth material on importing csv
files, the expected format for them, ect...?


___
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] Weird MacOS UI issue with windows cutoff on bottom and right

[John Ralls]

This problem was subsequently documented in 
https://bugs.gnucash.org/show_bug.cgi?id=798728 and 
https://gitlab.gnome.org/GNOME/gtk/-/issues/5535. I've fixed the problem and 
uploaded a new dmg to SourceForge and Github:

https://sourceforge.net/projects/gnucash/files/gnucash%20%28stable%29/4.13/Gnucash-Intel-4.13-2.dmg/download
https://github.com/Gnucash/gnucash/releases/download/4.13/Gnucash-Intel-4.13-2.dmg

The website's update scripts are broken so I can't update the download links or 
sha: The new one is 
5aad49b682d38de25a192d8e77245654e044102adc3c228de0431b75f87a4a05. I've made a 
symlink on Sourceforge so that the old download link on the website will 
download the new dmg.

Regards,
John Ralls

> On Jan 9, 2023, at 4:06 PM, prl  wrote:
> 
> Intel MacBook Pro, MacOS Ventura 13.1, GnuCash 4.13
> 
> I don't use the business features of GnuCash, but I have noticed that the 
> Since Last Run popup window is slightly shorter that it should be, with a 
> little bit of the buttons at the bottom cut off, but less than what Adrian is 
> showing for the Edit Bill popup. The Interest Payment popup in Reconcile is 
> cut off in a similar way.
> 
> I haven't noticed any other popups that are too short in my use of GnuCash 
> 4.13.
> 
> Peter
> 
> On 9/1/2023 18:23, Adrien Monteleone wrote:
>> Monterey, GnuCash 4.13
>> 
>> I noticed right away when 4.13 was released that there were some weird 
>> issues with all GnuCash windows. I haven't managed to narrow down the main 
>> window as it seems to be transient as the window is resized.
>> 
>> Some child windows though seem to be pretty consistent, at least on first 
>> creation.
>> 
>> Attached is a screenshot of the Edit Bill dialog.
>> 
>> Notice the right side & bottom are cutoff.
>> 
>> In addition, the resize mouse pointer icon seems to become available as if 
>> the window manager thinks the edges of the dialog are where they should be, 
>> rather than where they are visible. (so 'out in space' on the desktop)
>> 
>> Enlarging the window in either the right, bottom, or both directions can be 
>> finessed to make the window appear not-cutoff, but this 'jumps' back to 
>> cutoff if not exact. (If needed I can try to do a screen recording showing 
>> this effect)
>> 
>> This is likely a GTK issue rather than GnuCash, but I'm curious if anyone 
>> else has noticed this and if a dev can chime in on where I should file this 
>> bug.
>> 
>> (there are other issues in this version with resizing windows and placing 
>> them adjacent to each other, but I'll post about that separately when I can 
>> reliably describe and screenshot/screencast the problem)
>> 
>> 
>> 
>> ___
>> 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.

___
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] How to move a transaction with splits from one top-level account to another - take 2

[Michael or Penny Novack]

On 1/19/2023 12:44 PM, Kalpesh Patel wrote:

Just to add a bit of clarification to this, if you do decide to go with the
delete route, transactions that are in the former account are merged into
latter one.

Uh  if your intent is to MOVE an account to a  different place in 
the CoA, simply change its parent. Same if you want a different name for 
the account, just rename it. In either of those situations you are not 
intending to alter any transactions, so why touch them.


Yes, delete will work IF the destination account is empty. But moving by 
delete is a MERGE operation (merge the transactions in the account being 
deleted wit the transactions already in the destination account. 
However, how would you demonstrate afterwords that it had been empty?


Michael D Novack



___
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] How to move a transaction with splits from one top-level account to another - take 2

[Phyllis Bruce]

Sorry, trying again (and I have NOT been drinking...)

Highlight your top level Credit Card.  Now, go to the top of the screen and
choose "Edit".  You will get a pop up where you can enter Liabilities as
the Parent account for Credit Card.  Done.

On Thu, Jan 19, 2023 at 2:38 PM Phyllis Bruce  wrote:

> It should be easy enough to make Liabilities the .  Make Credit Cards by
> highlighting you top level account of Credit Cards.  Go to the bottom of
> the pop up screen and make Liabilities the Parent Account of Credit Card.
> Done.
>
>
>
> On Thu, Jan 19, 2023 at 9:41 AM Xe Roy  wrote:
>
>> David T.
>>
>> Thanks.
>> Your advice makes sense.
>> Since I have already created my credit card accounts as top-level
>> accounts and they have about a month's worth of data, is it possible to
>> move them to another account?
>> Example: move VISA to LIABILITIES > CREDIT CARDS > VISA
>>
>>
>> Sent from Outlook 
>> --
>> *From:* David T. 
>> *Sent:* Thursday, January 19, 2023 6:02 AM
>> *To:* Xe Roy 
>> *Cc:* Phyllis Bruce ; Fross, Michael <
>> mich...@fross.org>; gnucash-user@gnucash.org 
>> *Subject:* Re: [GNC] How to move a transaction with splits from one
>> top-level account to another - take 2
>>
>> Xe Roy,
>>
>> Just a note that it's more common to structure your GnuCash accounts with
>> just five top level accounts:
>>
>> Assets
>> Liabilities
>> Equity
>> Income
>> Expenses
>>
>> You'd put the "Credit Cards" account under Liabilities, with each credit
>> card in its own account within Credit Cards,  like so:
>>
>> Liabilities
>> - Credit Cards
>> - - Visa
>> - - Mastercard
>>
>> This groups the accounts in ways that make reporting clearer and easier.
>>
>> David T.
>> On Jan 19, 2023, at 2:07 AM, Xe Roy  wrote:
>>
>> Thanks everyone for your patience.
>> I finally got it.
>> I had to click on the transaction > click SPLITS > then find the line in the 
>> splits that says MASTER CARD > change that to VISA > ENTER
>>
>>
>>
>>
>> Sent from Outlook
>>
>> --
>>
>> From: Phyllis Bruce 
>> Sent: Wednesday, January 18, 2023 1:00 PM
>> To: Fross, Michael 
>> Cc: Xe Roy ; gnucash-user@gnucash.org 
>> 
>> Subject: Re: [GNC] How to move a transaction with splits from one top-level 
>> account to another - take 2
>>
>> Xe Roy,
>>
>> You will find if you just change your top level account in the transaction, 
>> the splits will follow it.  Just as Michael described above.  I've used jump 
>> but I find it just as easy to make that one correction.
>> Additionally, if you found you chose the wrong account for one of your 
>> splits, just change it to the correct account and only that split gets 
>> changed.
>>
>> Hth - po
>>
>> On Wed, Jan 18, 2023 at 3:40 PM Fross, Michael 
>> mailto:mich...@fross.org>> wrote:
>> When I notice I've placed a transaction in the wrong spot, I "jump" to the
>> matching transaction and correct the credit card.  For example:
>>
>> I put my Walmart grocery into the CreditCard1 account instead of the
>> CreditCard2 account.  I noticed this in the CreditCard1 account.
>>
>> 1. "Jump" to the matching transaction.  So now I am in the Grocery account.
>> 2. Change that transaction to be CreditCard2 instead of the incorrect
>> CreditCard1 account.
>> 3. Press enter.
>>
>> The transaction in Grocery is fine, but you'll find it's gone from
>> CreditCard1 and now resides in CreditCard2.  The "Jump" command is your
>> friend.
>>
>> Michael
>>
>> On Wed, Jan 18, 2023 at 3:31 PM Xe Roy 
>> mailto:xe...@hotmail.com>> wrote:
>>
>>  I asked this question earlier but initial responses made me realize more
>>  detail was necessary.
>>
>>  I am a newby to gnucash ... trying to switch from Quicken to gnucash.
>>  A mistake I regularly make is to enter a transaction into the wrong
>>  account.
>>  I'll have several accounts open and I just forget to switch.
>>  In Quicken, I just move the transaction (splits and all) to the new
>>  account.
>>  The Internet chatter I've found so far lead me to believe this feature is
>>  missing from gnucash.
>>  I hope that's not true because it would really cause me excessive hassle.
>>  I hope there is a way to move a transaction (including any splits) to
>>  another account.
>>
>>  Here is an example which illustrates a typical situation:
>>  Let's say I have two credit cards, VISA and MASTER CARD.
>>  Each has their own top-level CREDIT CARD account in gnucash, and each has
>>  its own tab in gnucash.
>>  I meant to enter a transaction in VISA but accidently entered it in MASTER
>>  CARD.
>>  The transaction is for $10 with WALMART in the description.
>>  So, the main entry shows $10 and the splits show $5 to the clothing
>>  account and $5 to the food account.
>>  I want to move the entire WALMART transaction, including the splits, from
>>  the MASTER CARD top-level account to the VISA top-level account in one easy
>>  step.
>>  This is easily doable in Quicken by 

Re: [GNC] How to move a transaction with splits from one top-level account to another - take 2

[Phyllis Bruce]

It should be easy enough to make Liabilities the .  Make Credit Cards by
highlighting you top level account of Credit Cards.  Go to the bottom of
the pop up screen and make Liabilities the Parent Account of Credit Card.
Done.



On Thu, Jan 19, 2023 at 9:41 AM Xe Roy  wrote:

> David T.
>
> Thanks.
> Your advice makes sense.
> Since I have already created my credit card accounts as top-level accounts
> and they have about a month's worth of data, is it possible to move them to
> another account?
> Example: move VISA to LIABILITIES > CREDIT CARDS > VISA
>
>
> Sent from Outlook 
> --
> *From:* David T. 
> *Sent:* Thursday, January 19, 2023 6:02 AM
> *To:* Xe Roy 
> *Cc:* Phyllis Bruce ; Fross, Michael <
> mich...@fross.org>; gnucash-user@gnucash.org 
> *Subject:* Re: [GNC] How to move a transaction with splits from one
> top-level account to another - take 2
>
> Xe Roy,
>
> Just a note that it's more common to structure your GnuCash accounts with
> just five top level accounts:
>
> Assets
> Liabilities
> Equity
> Income
> Expenses
>
> You'd put the "Credit Cards" account under Liabilities, with each credit
> card in its own account within Credit Cards,  like so:
>
> Liabilities
> - Credit Cards
> - - Visa
> - - Mastercard
>
> This groups the accounts in ways that make reporting clearer and easier.
>
> David T.
> On Jan 19, 2023, at 2:07 AM, Xe Roy  wrote:
>
> Thanks everyone for your patience.
> I finally got it.
> I had to click on the transaction > click SPLITS > then find the line in the 
> splits that says MASTER CARD > change that to VISA > ENTER
>
>
>
>
> Sent from Outlook
>
> --
>
> From: Phyllis Bruce 
> Sent: Wednesday, January 18, 2023 1:00 PM
> To: Fross, Michael 
> Cc: Xe Roy ; gnucash-user@gnucash.org 
> 
> Subject: Re: [GNC] How to move a transaction with splits from one top-level 
> account to another - take 2
>
> Xe Roy,
>
> You will find if you just change your top level account in the transaction, 
> the splits will follow it.  Just as Michael described above.  I've used jump 
> but I find it just as easy to make that one correction.
> Additionally, if you found you chose the wrong account for one of your 
> splits, just change it to the correct account and only that split gets 
> changed.
>
> Hth - po
>
> On Wed, Jan 18, 2023 at 3:40 PM Fross, Michael 
> mailto:mich...@fross.org>> wrote:
> When I notice I've placed a transaction in the wrong spot, I "jump" to the
> matching transaction and correct the credit card.  For example:
>
> I put my Walmart grocery into the CreditCard1 account instead of the
> CreditCard2 account.  I noticed this in the CreditCard1 account.
>
> 1. "Jump" to the matching transaction.  So now I am in the Grocery account.
> 2. Change that transaction to be CreditCard2 instead of the incorrect
> CreditCard1 account.
> 3. Press enter.
>
> The transaction in Grocery is fine, but you'll find it's gone from
> CreditCard1 and now resides in CreditCard2.  The "Jump" command is your
> friend.
>
> Michael
>
> On Wed, Jan 18, 2023 at 3:31 PM Xe Roy 
> mailto:xe...@hotmail.com>> wrote:
>
>  I asked this question earlier but initial responses made me realize more
>  detail was necessary.
>
>  I am a newby to gnucash ... trying to switch from Quicken to gnucash.
>  A mistake I regularly make is to enter a transaction into the wrong
>  account.
>  I'll have several accounts open and I just forget to switch.
>  In Quicken, I just move the transaction (splits and all) to the new
>  account.
>  The Internet chatter I've found so far lead me to believe this feature is
>  missing from gnucash.
>  I hope that's not true because it would really cause me excessive hassle.
>  I hope there is a way to move a transaction (including any splits) to
>  another account.
>
>  Here is an example which illustrates a typical situation:
>  Let's say I have two credit cards, VISA and MASTER CARD.
>  Each has their own top-level CREDIT CARD account in gnucash, and each has
>  its own tab in gnucash.
>  I meant to enter a transaction in VISA but accidently entered it in MASTER
>  CARD.
>  The transaction is for $10 with WALMART in the description.
>  So, the main entry shows $10 and the splits show $5 to the clothing
>  account and $5 to the food account.
>  I want to move the entire WALMART transaction, including the splits, from
>  the MASTER CARD top-level account to the VISA top-level account in one easy
>  step.
>  This is easily doable in Quicken by right-clicking anywhere in the
>  transaction, clicking MOVE, and selecting the new account VISA.
>  How is this done in gnucash?
>
>
>
>  Sent from Outlook
> --
>
>  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 

Re: [GNC] 4.13 Version not in downloads

[John Ralls]

It seems to have been a SourceForge glitch. I was able to reproduce it earlier 
this morning but in preparing to fix the URI on the website I tried again just 
now and it worked correctly.

Regards,
John Ralls


> On Jan 19, 2023, at 6:17 AM, Glenn Fowler  wrote:
> 
> Until that's fixed you can d/l from GitHub:
> 
> https://github.com/Gnucash/gnucash/releases/download/4.13/gnucash-4.13.setup.exe
> 
> On Thu, Jan 19, 2023 at 9:03 AM Jan via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> 
>> Resending with .googlemail instead of .gmail.
>> 
>> 
>> 
>> From: jhoe...@googlemail.com 
>> Sent: Thursday, January 19, 2023 8:55 AM
>> To: gnucash-user@gnucash.org
>> Subject: 4.13 Version not in downloads
>> 
>> 
>> 
>> Hi guys - After decades of using Quicken 2002, it's no longer running on my
>> newer laptops and I need to find a good long-term alternative. GnuCash
>> seems
>> like the right thing, but I'm already struggling with the setup download:
>> It
>> says on Download | GnuCash   that
>> 4.13 is the latest stable version, but once I click on the Windows version,
>> GnuCash - Browse Files at SourceForge.net
>>   tells me that ".
>> 4.13.setup.exe file could not be found". The latest stable downloadable
>> version I can see is 4.6. Was 4.13 removed for a good reason or just a
>> mistake? Which version should I download (and do I need only the setup file
>> or also the others in the same folder)? Thanks for your help, Jan
>> 
>> ___
>> 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.

___
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] Importing csv files

[R Losey]

Also, do you really need to import data from Quickbooks? I used Quicken,
not Quickbooks, but (by and large), I just started up GnuCash afresh and
went back to Quicken only when I needed to look things up.  Now that I'm
years into GnuCash, I have had no need to go back to Quicken.



On Wed, Jan 18, 2023 at 7:30 PM rudy beuc  wrote:

> Hello,
>
> I'm trying to migrate from Quickbooks to GnuCash.
>
> I'd like to keep as much information as I can for record keeping. To
> that end I've first been trying to import my accounts structure in via a
> csv file and failing badly.
>
> Pre Christmas holidays I was getting an error message I could not
> interpret. Now I've installed the latest stable version 4.13 and it just
> dies mid process.
>
> I'm running on Windows 11 and using open office to manipulate the csv
> files before trying to import.
>
> Where can I find a good discussion or indepth material on importing csv
> files, the expected format for them, ect...?
>
>
> Thanks,
>
> Rudy Beuc
>
>
>
>
>
> ___
> 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.
>


-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
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] How to move a transaction with splits from one top-level account to another - take 2

[Kalpesh Patel]

Just to add a bit of clarification to this, if you do decide to go with the
delete route, transactions that are in the former account are merged into
latter one. 

 
> --
> 
> Message: 1
> Date: Thu, 19 Jan 2023 16:19:09 +
> From: Gyle McCollam 
> To: Xe Roy , David T. 
> Cc: "gnucash-user@gnucash.org" 
> Subject: Re: [GNC] How to move a transaction with splits from one
>   top-level account to another - take 2
> Message-ID:
> 

>   
> Content-Type: text/plain; charset="utf-8"
> 
> Xe Roy,
> David T. method is correct and best, but if you have already crested
Liabilities:Credit Cards:Visa, you can also find the account in the Chart of
Accounts page and select delete.  Gnucash will ask what account you want to
move the transactions to and you can select the new account.  However, this is
best used to move transactions to an account with a different name.  To move
from Visa to Liab:CredCd:Visa, David T.s suggestion is the better method.
> 
> 
> Thank You,
> 
> Gyle McCollam
> 
> Gyle McCollam
> 
> gmccol...@live.com   email
> 
> 
> From: gnucash-user  on
behalf of David T. via gnucash-user 
> Sent: Thursday, January 19, 2023 10:57 AM
> To: Xe Roy 
> Cc: gnucash-user@gnucash.org 
> Subject: Re: [GNC] How to move a transaction with splits from one top-level
account to another - take 2
> 
> Assuming you have the Liabilities and Credit Cards accounts created, it's
simple.  From the Chart of Accounts page, select the account you want to move
(e.g., Visa) click the edit button, locate the Parent Account, change it to
Liabilities:Credit Cards, and click Save.
> 
> Done.
> 
> ?David T. ?
> 
> On Jan 19, 2023, 6:41 PM, at 6:41 PM, Xe Roy  wrote:
> >David T.
> >
> >Thanks.
> >Your advice makes sense.
> >Since I have already created my credit card accounts as top-level
> >accounts and they have about a month's worth of data, is it possible to
> >move them to another account?
> >Example: move VISA to LIABILITIES > CREDIT CARDS > VISA
> >
> >
> >
> >Sent from Outlook
> >
> >
> >From: David T. 
> >Sent: Thursday, January 19, 2023 6:02 AM
> >To: Xe Roy 
> >Cc: Phyllis Bruce ; Fross, Michael
> >; gnucash-user@gnucash.org
> >
> >Subject: Re: [GNC] How to move a transaction with splits from one
> >top-level account to another - take 2
> >
> >Xe Roy,
> >
> >Just a note that it's more common to structure your GnuCash accounts
> >with just five top level accounts:
> >
> >Assets
> >Liabilities
> >Equity
> >Income
> >Expenses
> >
> >You'd put the "Credit Cards" account under Liabilities, with each
> >credit card in its own account within Credit Cards,  like so:
> >
> >Liabilities
> >- Credit Cards
> >- - Visa
> >- - Mastercard
> >
> >This groups the accounts in ways that make reporting clearer and
> >easier.
> >
> >David T.
> >On Jan 19, 2023, at 2:07 AM, Xe Roy
> >mailto:xe...@hotmail.com>> wrote:
> >
> >Thanks everyone for your patience.
> >I finally got it.
> >I had to click on the transaction > click SPLITS > then find the line
> >in the splits that says MASTER CARD > change that to VISA > ENTER
> >
> >
> >
> >
> >Sent from Outlook
> >
> >
> >
> >From: Phyllis Bruce 
> >Sent: Wednesday, January 18, 2023 1:00 PM
> >To: Fross, Michael 
> >Cc: Xe Roy ; gnucash-user@gnucash.org
> >
> >Subject: Re: [GNC] How to move a transaction with splits from one
> >top-level account to another - take 2
> >
> >Xe Roy,
> >
> >You will find if you just change your top level account in the
> >transaction, the splits will follow it.  Just as Michael described
> >above.  I've used jump but I find it just as easy to make that one
> >correction.
> >Additionally, if you found you chose the wrong account for one of your
> >splits, just change it to the correct account and only that split gets
> >changed.
> >
> >Hth - po
> >
> >On Wed, Jan 18, 2023 at 3:40 PM Fross, Michael
> >mailto:mich...@fross.org>> wrote:
> >When I notice I've placed a transaction in the wrong spot, I "jump" to
> >the
> >matching transaction and correct the credit card.  For example:
> >
> >I put my Walmart grocery into the CreditCard1 account instead of the
> >CreditCard2 account.  I noticed this in the CreditCard1 account.
> >
> >1. "Jump" to the matching transaction.  So now I am in the Grocery
> >account.
> >2. Change that transaction to be CreditCard2 instead of the incorrect
> >CreditCard1 account.
> >3. Press enter.
> >
> >The transaction in Grocery is fine, but you'll find it's gone from
> >CreditCard1 and now resides in CreditCard2.  The "Jump" command is your
> >friend.
> >
> >Michael
> >
> >On Wed, Jan 18, 2023 at 3:31 PM Xe Roy
> >mailto:xe...@hotmail.com>> wrote:
> >
> >I asked this question earlier but initial responses made me realize
> >more
> > detail was necessary.
> >
> > I am a newby to gnucash ... 

Re: [GNC] Importing CSV files

[rick1 via gnucash-user]

The best way I found to give up QB classes is to simply add an additional 
subaccount. Then when needed do transaction report looking for that "class". 
Works great for rental properties.

-Original Message-
From: gnucash-user  On 
Behalf Of gnucash-user-requ...@gnucash.org
Sent: Thursday, January 19, 2023 11:00 AM
To: gnucash-user@gnucash.org
Subject: gnucash-user Digest, Vol 238, Issue 70

Send gnucash-user mailing list submissions to
gnucash-user@gnucash.org

To subscribe or unsubscribe via the World Wide Web, visit
https://lists.gnucash.org/mailman/listinfo/gnucash-user
or, via email, send a message with subject or body 'help' to
gnucash-user-requ...@gnucash.org

You can reach the person managing the list at
gnucash-user-ow...@gnucash.org

When replying, please edit your Subject line so it is more specific than "Re: 
Contents of gnucash-user digest..."


Today's Topics:

   1.  Importing csv files (flywire)
   2. Re:  Importing csv files (Steve Brown)
   3. Re:  Importing csv files (Michael or Penny Novack)
   4. Re:  4.13 Version not in downloads (jhoe...@googlemail.com)
   5. Re:  4.13 Version not in downloads (Glenn Fowler)
   6. Re:  How to move a transaction with splits from one top-level
  account to another - take 2 (David T.)
   7. Re:  How to move a transaction with splits from one top-level
  account to another - take 2 (Xe Roy)
   8. Re:  How to move a transaction with splits from one top-level
  account to another - take 2 (David T.)


--

Message: 1
Date: Thu, 19 Jan 2023 22:27:20 +1100
From: flywire 
To: rudy beuc 
Cc: Gnucash Users 
Subject: [GNC] Importing csv files
Message-ID:

Content-Type: text/plain; charset="UTF-8"

Make sure you understand what Gnucash offers as it could be a massive downgrade 
from Quickbooks. I use Quickbooks and GnuCash, each for different books because 
neither has all the features I need. Specifically, GnuCash does not support 
classes or automated GST (tax) for cash accounting (so I've never exported data 
from Quickbooks to GnuCash) but GnuCash does a fair job at importing csv files, 
which I do regularly.

Have a read through this before doing it. See:
* Prior thread:
https://lists.gnucash.org/pipermail/gnucash-user/2022-July/101901.html
* GnuCash Manual Import csv:
https://www.gnucash.org/viewdoc.phtml?rev=4=C=help
 * Tutorial data for testing:
https://lists.gnucash.org/pipermail/gnucash-user/attachments/20210718/2f60caee/attachment.obj

Importing accounts into GnuCash with csv is really nice csv but transaction 
data is really primitive. Still, despite how frustrating it is for new users in 
particular, it will work. File, Import, Import transaction from csv, Next, 
Select file...

Import Preview, normally you would select Account, say bank account, but that 
is not the case for a Quickbooks import. The File Format is likely Separators, 
Comma, but again, you likely need to *SELECT Multi-split* for the import which 
I'll explain soon.

Miscellaneous is really frustrating because of poor defaults. GnuCash has been 
around for 25 years but it doesn't recognise Locale date or support alphabetic 
month codes, so if you are not in the US, fix Date and check the month format. 
How many csv files have you seen without headers? Likely none. Set Leading 
Lines to skip, 1?? Currency format is likely correct.

In the link to the manual, navigate down to Example 6.1. Sample Multi-split.csv 
to see the layout of the csv file. See the tip? It is likely easier to prepare 
that file without the blank fields.

Back to the Import Preview form. Despite your csv file having the *exact* field 
names it needs there is no way for it to know that. You'll have to click each 
of the field dropdowns and match the field name to the data. The first line 
will be crossed out after you set it t skip 1 line but you can still read the 
field name.

All your records are red with a '-' in a circle on the right side? Chances are 
you need to reformat the date month data. Be careful, your spreadsheet might be 
outputting it in a different format to what is shown on the screen.

GnuCash does not recognise all the account codes in your data. You will have to 
create them, and even after you've done that you'll have to match them to the 
*same account*. Seriously! Now, stop banging your head. See above, " Importing 
accounts into GnuCash with csv is really nice", so do it to save yourself a 
little grief.

You haven't finished yet but I'll leave you with the manual. Check out Tools, 
Import Map Editor, Non-Bayesian.


--

Message: 2
Date: Thu, 19 Jan 2023 07:16:36 -0500
From: Steve Brown 
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Importing csv files
Message-ID:
<10ccd4f6605e121f47ff38a5502d563d8cabbccc.ca...@opensat.com>
Content-Type: text/plain; charset="UTF-8"

I've had very good results with this

Re: [GNC] How to move a transaction with splits from one top-level account to another - take 2

[Gyle McCollam]

Xe Roy,
David T. method is correct and best, but if you have already crested 
Liabilities:Credit Cards:Visa, you can also find the account in the Chart of 
Accounts page and select delete.  Gnucash will ask what account you want to 
move the transactions to and you can select the new account.  However, this is 
best used to move transactions to an account with a different name.  To move 
from Visa to Liab:CredCd:Visa, David T.s suggestion is the better method.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email


From: gnucash-user  on 
behalf of David T. via gnucash-user 
Sent: Thursday, January 19, 2023 10:57 AM
To: Xe Roy 
Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] How to move a transaction with splits from one top-level 
account to another - take 2

Assuming you have the Liabilities and Credit Cards accounts created, it's 
simple.  From the Chart of Accounts page, select the account you want to move 
(e.g., Visa) click the edit button, locate the Parent Account, change it to 
Liabilities:Credit Cards, and click Save.

Done.

⁣David T. ​

On Jan 19, 2023, 6:41 PM, at 6:41 PM, Xe Roy  wrote:
>David T.
>
>Thanks.
>Your advice makes sense.
>Since I have already created my credit card accounts as top-level
>accounts and they have about a month's worth of data, is it possible to
>move them to another account?
>Example: move VISA to LIABILITIES > CREDIT CARDS > VISA
>
>
>
>Sent from Outlook
>
>
>From: David T. 
>Sent: Thursday, January 19, 2023 6:02 AM
>To: Xe Roy 
>Cc: Phyllis Bruce ; Fross, Michael
>; gnucash-user@gnucash.org
>
>Subject: Re: [GNC] How to move a transaction with splits from one
>top-level account to another - take 2
>
>Xe Roy,
>
>Just a note that it's more common to structure your GnuCash accounts
>with just five top level accounts:
>
>Assets
>Liabilities
>Equity
>Income
>Expenses
>
>You'd put the "Credit Cards" account under Liabilities, with each
>credit card in its own account within Credit Cards,  like so:
>
>Liabilities
>- Credit Cards
>- - Visa
>- - Mastercard
>
>This groups the accounts in ways that make reporting clearer and
>easier.
>
>David T.
>On Jan 19, 2023, at 2:07 AM, Xe Roy
>mailto:xe...@hotmail.com>> wrote:
>
>Thanks everyone for your patience.
>I finally got it.
>I had to click on the transaction > click SPLITS > then find the line
>in the splits that says MASTER CARD > change that to VISA > ENTER
>
>
>
>
>Sent from Outlook
>
>
>
>From: Phyllis Bruce 
>Sent: Wednesday, January 18, 2023 1:00 PM
>To: Fross, Michael 
>Cc: Xe Roy ; gnucash-user@gnucash.org
>
>Subject: Re: [GNC] How to move a transaction with splits from one
>top-level account to another - take 2
>
>Xe Roy,
>
>You will find if you just change your top level account in the
>transaction, the splits will follow it.  Just as Michael described
>above.  I've used jump but I find it just as easy to make that one
>correction.
>Additionally, if you found you chose the wrong account for one of your
>splits, just change it to the correct account and only that split gets
>changed.
>
>Hth - po
>
>On Wed, Jan 18, 2023 at 3:40 PM Fross, Michael
>mailto:mich...@fross.org>> wrote:
>When I notice I've placed a transaction in the wrong spot, I "jump" to
>the
>matching transaction and correct the credit card.  For example:
>
>I put my Walmart grocery into the CreditCard1 account instead of the
>CreditCard2 account.  I noticed this in the CreditCard1 account.
>
>1. "Jump" to the matching transaction.  So now I am in the Grocery
>account.
>2. Change that transaction to be CreditCard2 instead of the incorrect
>CreditCard1 account.
>3. Press enter.
>
>The transaction in Grocery is fine, but you'll find it's gone from
>CreditCard1 and now resides in CreditCard2.  The "Jump" command is your
>friend.
>
>Michael
>
>On Wed, Jan 18, 2023 at 3:31 PM Xe Roy
>mailto:xe...@hotmail.com>> wrote:
>
>I asked this question earlier but initial responses made me realize
>more
> detail was necessary.
>
> I am a newby to gnucash ... trying to switch from Quicken to gnucash.
> A mistake I regularly make is to enter a transaction into the wrong
> account.
> I'll have several accounts open and I just forget to switch.
> In Quicken, I just move the transaction (splits and all) to the new
> account.
>The Internet chatter I've found so far lead me to believe this feature
>is
> missing from gnucash.
>I hope that's not true because it would really cause me excessive
>hassle.
> I hope there is a way to move a transaction (including any splits) to
> another account.
>
> Here is an example which illustrates a typical situation:
> Let's say I have two credit cards, VISA and MASTER CARD.
>Each has their own top-level CREDIT CARD account in gnucash, and each
>has
> its own tab in gnucash.
>I meant to enter a transaction in VISA but accidently entered it in

Re: [GNC] How to move a transaction with splits from one top-level account to another - take 2

[David T. via gnucash-user]

Assuming you have the Liabilities and Credit Cards accounts created, it's 
simple.  From the Chart of Accounts page, select the account you want to move 
(e.g., Visa) click the edit button, locate the Parent Account, change it to 
Liabilities:Credit Cards, and click Save. 

Done. 

⁣David T. ​

On Jan 19, 2023, 6:41 PM, at 6:41 PM, Xe Roy  wrote:
>David T.
>
>Thanks.
>Your advice makes sense.
>Since I have already created my credit card accounts as top-level
>accounts and they have about a month's worth of data, is it possible to
>move them to another account?
>Example: move VISA to LIABILITIES > CREDIT CARDS > VISA
>
>
>
>Sent from Outlook
>
>
>From: David T. 
>Sent: Thursday, January 19, 2023 6:02 AM
>To: Xe Roy 
>Cc: Phyllis Bruce ; Fross, Michael
>; gnucash-user@gnucash.org
>
>Subject: Re: [GNC] How to move a transaction with splits from one
>top-level account to another - take 2
>
>Xe Roy,
>
>Just a note that it's more common to structure your GnuCash accounts
>with just five top level accounts:
>
>Assets
>Liabilities
>Equity
>Income
>Expenses
>
>You'd put the "Credit Cards" account under Liabilities, with each
>credit card in its own account within Credit Cards,  like so:
>
>Liabilities
>- Credit Cards
>- - Visa
>- - Mastercard
>
>This groups the accounts in ways that make reporting clearer and
>easier.
>
>David T.
>On Jan 19, 2023, at 2:07 AM, Xe Roy
>mailto:xe...@hotmail.com>> wrote:
>
>Thanks everyone for your patience.
>I finally got it.
>I had to click on the transaction > click SPLITS > then find the line
>in the splits that says MASTER CARD > change that to VISA > ENTER
>
>
>
>
>Sent from Outlook
>
>
>
>From: Phyllis Bruce 
>Sent: Wednesday, January 18, 2023 1:00 PM
>To: Fross, Michael 
>Cc: Xe Roy ; gnucash-user@gnucash.org
>
>Subject: Re: [GNC] How to move a transaction with splits from one
>top-level account to another - take 2
>
>Xe Roy,
>
>You will find if you just change your top level account in the
>transaction, the splits will follow it.  Just as Michael described
>above.  I've used jump but I find it just as easy to make that one
>correction.
>Additionally, if you found you chose the wrong account for one of your
>splits, just change it to the correct account and only that split gets
>changed.
>
>Hth - po
>
>On Wed, Jan 18, 2023 at 3:40 PM Fross, Michael
>mailto:mich...@fross.org>> wrote:
>When I notice I've placed a transaction in the wrong spot, I "jump" to
>the
>matching transaction and correct the credit card.  For example:
>
>I put my Walmart grocery into the CreditCard1 account instead of the
>CreditCard2 account.  I noticed this in the CreditCard1 account.
>
>1. "Jump" to the matching transaction.  So now I am in the Grocery
>account.
>2. Change that transaction to be CreditCard2 instead of the incorrect
>CreditCard1 account.
>3. Press enter.
>
>The transaction in Grocery is fine, but you'll find it's gone from
>CreditCard1 and now resides in CreditCard2.  The "Jump" command is your
>friend.
>
>Michael
>
>On Wed, Jan 18, 2023 at 3:31 PM Xe Roy
>mailto:xe...@hotmail.com>> wrote:
>
>I asked this question earlier but initial responses made me realize
>more
> detail was necessary.
>
> I am a newby to gnucash ... trying to switch from Quicken to gnucash.
> A mistake I regularly make is to enter a transaction into the wrong
> account.
> I'll have several accounts open and I just forget to switch.
> In Quicken, I just move the transaction (splits and all) to the new
> account.
>The Internet chatter I've found so far lead me to believe this feature
>is
> missing from gnucash.
>I hope that's not true because it would really cause me excessive
>hassle.
> I hope there is a way to move a transaction (including any splits) to
> another account.
>
> Here is an example which illustrates a typical situation:
> Let's say I have two credit cards, VISA and MASTER CARD.
>Each has their own top-level CREDIT CARD account in gnucash, and each
>has
> its own tab in gnucash.
>I meant to enter a transaction in VISA but accidently entered it in
>MASTER
> CARD.
> The transaction is for $10 with WALMART in the description.
> So, the main entry shows $10 and the splits show $5 to the clothing
> account and $5 to the food account.
>I want to move the entire WALMART transaction, including the splits,
>from
>the MASTER CARD top-level account to the VISA top-level account in one
>easy
> step.
> This is easily doable in Quicken by right-clicking anywhere in the
> transaction, clicking MOVE, and selecting the new account VISA.
> How is this done in gnucash?
>
>
>
> Sent from Outlook
>
>
> 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 

Re: [GNC] How to move a transaction with splits from one top-level account to another - take 2

[Xe Roy]

David T.

Thanks.
Your advice makes sense.
Since I have already created my credit card accounts as top-level accounts and 
they have about a month's worth of data, is it possible to move them to another 
account?
Example: move VISA to LIABILITIES > CREDIT CARDS > VISA



Sent from Outlook


From: David T. 
Sent: Thursday, January 19, 2023 6:02 AM
To: Xe Roy 
Cc: Phyllis Bruce ; Fross, Michael ; 
gnucash-user@gnucash.org 
Subject: Re: [GNC] How to move a transaction with splits from one top-level 
account to another - take 2

Xe Roy,

Just a note that it's more common to structure your GnuCash accounts with just 
five top level accounts:

Assets
Liabilities
Equity
Income
Expenses

You'd put the "Credit Cards" account under Liabilities, with each credit card 
in its own account within Credit Cards,  like so:

Liabilities
- Credit Cards
- - Visa
- - Mastercard

This groups the accounts in ways that make reporting clearer and easier.

David T.
On Jan 19, 2023, at 2:07 AM, Xe Roy 
mailto:xe...@hotmail.com>> wrote:

Thanks everyone for your patience.
I finally got it.
I had to click on the transaction > click SPLITS > then find the line in the 
splits that says MASTER CARD > change that to VISA > ENTER




Sent from Outlook



From: Phyllis Bruce 
Sent: Wednesday, January 18, 2023 1:00 PM
To: Fross, Michael 
Cc: Xe Roy ; gnucash-user@gnucash.org 

Subject: Re: [GNC] How to move a transaction with splits from one top-level 
account to another - take 2

Xe Roy,

You will find if you just change your top level account in the transaction, the 
splits will follow it.  Just as Michael described above.  I've used jump but I 
find it just as easy to make that one correction.
Additionally, if you found you chose the wrong account for one of your splits, 
just change it to the correct account and only that split gets changed.

Hth - po

On Wed, Jan 18, 2023 at 3:40 PM Fross, Michael 
mailto:mich...@fross.org>> wrote:
When I notice I've placed a transaction in the wrong spot, I "jump" to the
matching transaction and correct the credit card.  For example:

I put my Walmart grocery into the CreditCard1 account instead of the
CreditCard2 account.  I noticed this in the CreditCard1 account.

1. "Jump" to the matching transaction.  So now I am in the Grocery account.
2. Change that transaction to be CreditCard2 instead of the incorrect
CreditCard1 account.
3. Press enter.

The transaction in Grocery is fine, but you'll find it's gone from
CreditCard1 and now resides in CreditCard2.  The "Jump" command is your
friend.

Michael

On Wed, Jan 18, 2023 at 3:31 PM Xe Roy 
mailto:xe...@hotmail.com>> wrote:

 I asked this question earlier but initial responses made me realize more
 detail was necessary.

 I am a newby to gnucash ... trying to switch from Quicken to gnucash.
 A mistake I regularly make is to enter a transaction into the wrong
 account.
 I'll have several accounts open and I just forget to switch.
 In Quicken, I just move the transaction (splits and all) to the new
 account.
 The Internet chatter I've found so far lead me to believe this feature is
 missing from gnucash.
 I hope that's not true because it would really cause me excessive hassle.
 I hope there is a way to move a transaction (including any splits) to
 another account.

 Here is an example which illustrates a typical situation:
 Let's say I have two credit cards, VISA and MASTER CARD.
 Each has their own top-level CREDIT CARD account in gnucash, and each has
 its own tab in gnucash.
 I meant to enter a transaction in VISA but accidently entered it in MASTER
 CARD.
 The transaction is for $10 with WALMART in the description.
 So, the main entry shows $10 and the splits show $5 to the clothing
 account and $5 to the food account.
 I want to move the entire WALMART transaction, including the splits, from
 the MASTER CARD top-level account to the VISA top-level account in one easy
 step.
 This is easily doable in Quicken by right-clicking anywhere in the
 transaction, clicking MOVE, and selecting the new account VISA.
 How is this done in gnucash?



 Sent from Outlook


 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.


gnucash-user mailing list

Re: [GNC] How to move a transaction with splits from one top-level account to another - take 2

[David T. via gnucash-user]

Xe Roy,

Just a note that it's more common to structure your GnuCash accounts with just 
five top level accounts:

Assets
Liabilities
Equity
Income
Expenses

You'd put the "Credit Cards" account under Liabilities, with each credit card 
in its own account within Credit Cards,  like so:

Liabilities
- Credit Cards
- - Visa 
- - Mastercard

This groups the accounts in ways that make reporting clearer and easier. 

⁣David T. ​

On Jan 19, 2023, 2:07 AM, at 2:07 AM, Xe Roy  wrote:
>Thanks everyone for your patience.
>I finally got it.
>I had to click on the transaction > click SPLITS > then find the line
>in the splits that says MASTER CARD > change that to VISA > ENTER
>
>
>
>
>Sent from Outlook
>
>
>From: Phyllis Bruce 
>Sent: Wednesday, January 18, 2023 1:00 PM
>To: Fross, Michael 
>Cc: Xe Roy ; gnucash-user@gnucash.org
>
>Subject: Re: [GNC] How to move a transaction with splits from one
>top-level account to another - take 2
>
>Xe Roy,
>
>You will find if you just change your top level account in the
>transaction, the splits will follow it.  Just as Michael described
>above.  I've used jump but I find it just as easy to make that one
>correction.
>Additionally, if you found you chose the wrong account for one of your
>splits, just change it to the correct account and only that split gets
>changed.
>
>Hth - po
>
>On Wed, Jan 18, 2023 at 3:40 PM Fross, Michael
>mailto:mich...@fross.org>> wrote:
>When I notice I've placed a transaction in the wrong spot, I "jump" to
>the
>matching transaction and correct the credit card.  For example:
>
>I put my Walmart grocery into the CreditCard1 account instead of the
>CreditCard2 account.  I noticed this in the CreditCard1 account.
>
>1. "Jump" to the matching transaction.  So now I am in the Grocery
>account.
>2. Change that transaction to be CreditCard2 instead of the incorrect
>CreditCard1 account.
>3. Press enter.
>
>The transaction in Grocery is fine, but you'll find it's gone from
>CreditCard1 and now resides in CreditCard2.  The "Jump" command is your
>friend.
>
>Michael
>
>On Wed, Jan 18, 2023 at 3:31 PM Xe Roy
>mailto:xe...@hotmail.com>> wrote:
>
>> I asked this question earlier but initial responses made me realize
>more
>> detail was necessary.
>>
>> I am a newby to gnucash ... trying to switch from Quicken to gnucash.
>> A mistake I regularly make is to enter a transaction into the wrong
>> account.
>> I'll have several accounts open and I just forget to switch.
>> In Quicken, I just move the transaction (splits and all) to the new
>> account.
>> The Internet chatter I've found so far lead me to believe this
>feature is
>> missing from gnucash.
>> I hope that's not true because it would really cause me excessive
>hassle.
>> I hope there is a way to move a transaction (including any splits) to
>> another account.
>>
>> Here is an example which illustrates a typical situation:
>> Let's say I have two credit cards, VISA and MASTER CARD.
>> Each has their own top-level CREDIT CARD account in gnucash, and each
>has
>> its own tab in gnucash.
>> I meant to enter a transaction in VISA but accidently entered it in
>MASTER
>> CARD.
>> The transaction is for $10 with WALMART in the description.
>> So, the main entry shows $10 and the splits show $5 to the clothing
>> account and $5 to the food account.
>> I want to move the entire WALMART transaction, including the splits,
>from
>> the MASTER CARD top-level account to the VISA top-level account in
>one easy
>> step.
>> This is easily doable in Quicken by right-clicking anywhere in the
>> transaction, clicking MOVE, and selecting the new account VISA.
>> How is this done in gnucash?
>>
>>
>>
>> Sent from Outlook
>> ___
>> 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.
>___
>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:

Re: [GNC] 4.13 Version not in downloads

[Glenn Fowler]

Until that's fixed you can d/l from GitHub:

https://github.com/Gnucash/gnucash/releases/download/4.13/gnucash-4.13.setup.exe

On Thu, Jan 19, 2023 at 9:03 AM Jan via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Resending with .googlemail instead of .gmail.
>
>
>
> From: jhoe...@googlemail.com 
> Sent: Thursday, January 19, 2023 8:55 AM
> To: gnucash-user@gnucash.org
> Subject: 4.13 Version not in downloads
>
>
>
> Hi guys - After decades of using Quicken 2002, it's no longer running on my
> newer laptops and I need to find a good long-term alternative. GnuCash
> seems
> like the right thing, but I'm already struggling with the setup download:
> It
> says on Download | GnuCash   that
> 4.13 is the latest stable version, but once I click on the Windows version,
> GnuCash - Browse Files at SourceForge.net
>   tells me that ".
> 4.13.setup.exe file could not be found". The latest stable downloadable
> version I can see is 4.6. Was 4.13 removed for a good reason or just a
> mistake? Which version should I download (and do I need only the setup file
> or also the others in the same folder)? Thanks for your help, Jan
>
> ___
> 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.

Re: [GNC] 4.13 Version not in downloads

[Jan via gnucash-user]

Resending with .googlemail instead of .gmail. 

 

From: jhoe...@googlemail.com  
Sent: Thursday, January 19, 2023 8:55 AM
To: gnucash-user@gnucash.org
Subject: 4.13 Version not in downloads

 

Hi guys - After decades of using Quicken 2002, it's no longer running on my
newer laptops and I need to find a good long-term alternative. GnuCash seems
like the right thing, but I'm already struggling with the setup download: It
says on Download | GnuCash   that
4.13 is the latest stable version, but once I click on the Windows version,
GnuCash - Browse Files at SourceForge.net
  tells me that ".
4.13.setup.exe file could not be found". The latest stable downloadable
version I can see is 4.6. Was 4.13 removed for a good reason or just a
mistake? Which version should I download (and do I need only the setup file
or also the others in the same folder)? Thanks for your help, Jan

___
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] Importing csv files

[Michael or Penny Novack]

On 1/19/2023 6:27 AM, flywire wrote:

Make sure you understand what Gnucash offers as it could be a
massive downgrade from Quickbooks. I use Quickbooks and GnuCash, each for
different books because neither has all the features I need. Specifically,
GnuCash does not support classes ...


I used to use Quickbooks. That was a while ago, before the 2006 house 
fire. Standard double entry bookkeeping. It didn't have "classes" then, 
although possible it now supports "alternate view of the CoA" (what 
"classes" would be in double entry) somehow I doubt it, as not 
traditional in double entry ledger to have more than one view of the 
ledger hierarchy.


Sure you weren't meaning Quicken (which is not double entry ad which 
does have "classes")


Michael



___
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] Importing csv files

[Steve Brown]

I've had very good results with this
https://github.com/erikmack/qb-escape.git

I had to back out the account code stuff in the most recent commit as
it didn't work for my use case.

The article referenced in the README was similarly helpful.

Steve

On Wed, 2023-01-18 at 19:29 -0600, rudy beuc wrote:
> Hello,
> 
> I'm trying to migrate from Quickbooks to GnuCash.
> 
> I'd like to keep as much information as I can for record keeping. To 
> that end I've first been trying to import my accounts structure in
> via a 
> csv file and failing badly.
> 
> Pre Christmas holidays I was getting an error message I could not 
> interpret. Now I've installed the latest stable version 4.13 and it
> just 
> dies mid process.
> 
> I'm running on Windows 11 and using open office to manipulate the csv
> files before trying to import.
> 
> Where can I find a good discussion or indepth material on importing
> csv 
> files, the expected format for them, ect...?
> 
> 
> Thanks,
> 
> Rudy Beuc
> 
> 
> 
> 
> 
> ___
> 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.

[GNC] Importing csv files

[flywire]

Make sure you understand what Gnucash offers as it could be a
massive downgrade from Quickbooks. I use Quickbooks and GnuCash, each for
different books because neither has all the features I need. Specifically,
GnuCash does not support classes or automated GST (tax) for cash accounting
(so I've never exported data from Quickbooks to GnuCash) but GnuCash does a
fair job at importing csv files, which I do regularly.

Have a read through this before doing it. See:
* Prior thread:
https://lists.gnucash.org/pipermail/gnucash-user/2022-July/101901.html
* GnuCash Manual Import csv:
https://www.gnucash.org/viewdoc.phtml?rev=4=C=help
 * Tutorial data for testing:
https://lists.gnucash.org/pipermail/gnucash-user/attachments/20210718/2f60caee/attachment.obj

Importing accounts into GnuCash with csv is really nice csv but transaction
data is really primitive. Still, despite how frustrating it is for new
users in particular, it will work. File, Import, Import transaction from
csv, Next, Select file...

Import Preview, normally you would select Account, say bank account, but
that is not the case for a Quickbooks import. The File Format is likely
Separators, Comma, but again, you likely need to *SELECT Multi-split* for
the import which I'll explain soon.

Miscellaneous is really frustrating because of poor defaults. GnuCash has
been around for 25 years but it doesn't recognise Locale date or support
alphabetic month codes, so if you are not in the US, fix Date and check the
month format. How many csv files have you seen without headers? Likely
none. Set Leading Lines to skip, 1?? Currency format is likely correct.

In the link to the manual, navigate down to Example 6.1. Sample
Multi-split.csv to see the layout of the csv file. See the tip? It is
likely easier to prepare that file without the blank fields.

Back to the Import Preview form. Despite your csv file having the *exact*
field names it needs there is no way for it to know that. You'll have to
click each of the field dropdowns and match the field name to the data. The
first line will be crossed out after you set it t skip 1 line but you can
still read the field name.

All your records are red with a '-' in a circle on the right side? Chances
are you need to reformat the date month data. Be careful, your spreadsheet
might be outputting it in a different format to what is shown on the screen.

GnuCash does not recognise all the account codes in your data. You will
have to create them, and even after you've done that you'll have to match
them to the *same account*. Seriously! Now, stop banging your head. See
above, " Importing accounts into GnuCash with csv is really nice", so do it
to save yourself a little grief.

You haven't finished yet but I'll leave you with the manual. Check out
Tools, Import Map Editor, Non-Bayesian.
___
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.