Re: [GNC] New user: how to migrate Quicken checking account as a single, flat, checking account
Scott You can edit the accounts and in the dialoguechange the account type to Expense and the parent to the top level expenses account.Unfortunately its a one at a time operation David Cousens On Sun, 2022-12-04 at 13:39 -0500, Scott Traurig wrote: > So I did the import wrong. Crap. Too late, I already gutted it out and > manually rearranged it all! > > Thanks, > > Scott > > > > > > ___ > 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] New user: how to migrate Quicken checking account as a single, flat, checking account
So I did the import wrong. Crap. Too late, I already gutted it out and manually rearranged it all! Thanks, Scott >> ___ 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] New user: how to migrate Quicken checking account as a single, flat, checking account
What you need to do is start a new file and position those expenses correctly under the the top expense level during the import process. That is not really very hard with a couple of expendable tries to see how it works. On Sun, Dec 4, 2022, 12:17 PM Scott Traurig wrote: > Nope, sorry, you gents did not understand my question. > > I don't have any unwanted accounts. Indeed, all of my categories in Quicken > were well thought out and organized, and well replicated as separate > expense accounts in GnuCash via the import process. > > But with some 100 different, well organized and well thought out expense > accounts, I don't want them all at the top level, which is where GnuCash > puts them upon import. > > In the GnuCash paradigm, I now have top level placeholder accounts for > assets, liabilities, income and expenses. For income, assets and > liabilities it was not much of a chore to move those few accounts that were > imported to be under their proper, respective placeholders in > the hierarchy. But now I need to move all 100 or so expense accounts, > intact, from the top level to underneath the top level, placeholder expense > account. That's a huge PITA if I have to edit the properties of each one > individually. Drag and drop would be a modern UI method for this, alas it > does not exist in GnuCash. > > Is there an easy way to do this, or just grunt it out? > > Thanks, > > Scott > ___ > 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] New user: how to migrate Quicken checking account as a single, flat, checking account
Let's get this cleared up: You're telling us that *all* of your expense accounts are *not* under the top-level 'Expenses' account but exist as each their own top-level account? (but maybe of 'type' Expense) If so, that sounds like an error (I'll hazard, user) in the import. The easiest thing would be to ditch that book and do it again, being certain this time to indicate that the categories are expense accounts and belong under the top-level Expense account as a parent. I'm not certain of the UI mechanics there as I've never done this transition myself. Others can likely help. (or maybe you missed something in the Wiki?) If they are already under Expenses, such as: Expenses:Telephone Then if you simply want to create intermediate hierarchy levels like: Expenses:Utilities:Telephone Create the intermediary accounts, mark them as Placeholders, then re-parent the relevant accounts under them. Regards, Adrien On 12/4/22 12:15 PM, Scott Traurig wrote: Nope, sorry, you gents did not understand my question. I don't have any unwanted accounts. Indeed, all of my categories in Quicken were well thought out and organized, and well replicated as separate expense accounts in GnuCash via the import process. But with some 100 different, well organized and well thought out expense accounts, I don't want them all at the top level, which is where GnuCash puts them upon import. In the GnuCash paradigm, I now have top level placeholder accounts for assets, liabilities, income and expenses. For income, assets and liabilities it was not much of a chore to move those few accounts that were imported to be under their proper, respective placeholders in the hierarchy. But now I need to move all 100 or so expense accounts, intact, from the top level to underneath the top level, placeholder expense account. That's a huge PITA if I have to edit the properties of each one individually. Drag and drop would be a modern UI method for this, alas it does not exist in GnuCash. Is there an easy way to do this, or just grunt it out? ___ 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] New user: how to migrate Quicken checking account as a single, flat, checking account
That was the politest "No, you are stuck doing it manually" response I've ever seen ;-) Thanks, Scott On Sun, Dec 4, 2022 at 1:25 PM David Carlson wrote: > Scott, > > If I understand correctly, what you expected was a chart of accounts with > one asset account for checking and all other accounts lumped under > expenses. Maybe one account for income. > > You should be able to get to that result with an import from Quicken but > it may take some or perhaps a lot of manipulation depending on the > condition of your source. You don't really need to reduce all the expense > accounts into one because they are already collected under the single top > account called Expense. > > Good luck > > On Sun, Dec 4, 2022, 11:57 AM Fred Bone wrote: > >> On 04 December 2022 at 11:54, Scott Traurig said: >> >> > I do understand double-entry accounting and that it is the GnuCash >> > paradigm. >> > >> > What I didn't understand is that on the import GnuCash did create the >> > requisite checking account, plus all the expense accounts. I did not see >> > the checking account as it was lost in a sea of expense accounts. >> > >> > Now that I've gotten that far, is there any way to move accounts en >> masse >> > into a top level "Expenses" account? Or do I have to laboriously edit >> each >> > and every one? >> >> What *might* work is to delete the unwanted accounts. >> >> When you delete an account, Gnucash will ask what you want to do with the >> transactions in it. You can move them to another (already existing) >> account. This will let you (for example) consolidate the grocery >> transactions, with 17 different vendors, into one "Expenses:Grocery" >> account. >> >> If you really want all the expenses in a single account then I suggest >> you don't want an accounting system and Gnucash is not the solution you >> are looking for. >> >> >> ___ >> 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] New user: how to migrate Quicken checking account as a single, flat, checking account
Scott, If I understand correctly, what you expected was a chart of accounts with one asset account for checking and all other accounts lumped under expenses. Maybe one account for income. You should be able to get to that result with an import from Quicken but it may take some or perhaps a lot of manipulation depending on the condition of your source. You don't really need to reduce all the expense accounts into one because they are already collected under the single top account called Expense. Good luck On Sun, Dec 4, 2022, 11:57 AM Fred Bone wrote: > On 04 December 2022 at 11:54, Scott Traurig said: > > > I do understand double-entry accounting and that it is the GnuCash > > paradigm. > > > > What I didn't understand is that on the import GnuCash did create the > > requisite checking account, plus all the expense accounts. I did not see > > the checking account as it was lost in a sea of expense accounts. > > > > Now that I've gotten that far, is there any way to move accounts en masse > > into a top level "Expenses" account? Or do I have to laboriously edit > each > > and every one? > > What *might* work is to delete the unwanted accounts. > > When you delete an account, Gnucash will ask what you want to do with the > transactions in it. You can move them to another (already existing) > account. This will let you (for example) consolidate the grocery > transactions, with 17 different vendors, into one "Expenses:Grocery" > account. > > If you really want all the expenses in a single account then I suggest > you don't want an accounting system and Gnucash is not the solution you > are looking for. > > > ___ > 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] New user: how to migrate Quicken checking account as a single, flat, checking account
Nope, sorry, you gents did not understand my question. I don't have any unwanted accounts. Indeed, all of my categories in Quicken were well thought out and organized, and well replicated as separate expense accounts in GnuCash via the import process. But with some 100 different, well organized and well thought out expense accounts, I don't want them all at the top level, which is where GnuCash puts them upon import. In the GnuCash paradigm, I now have top level placeholder accounts for assets, liabilities, income and expenses. For income, assets and liabilities it was not much of a chore to move those few accounts that were imported to be under their proper, respective placeholders in the hierarchy. But now I need to move all 100 or so expense accounts, intact, from the top level to underneath the top level, placeholder expense account. That's a huge PITA if I have to edit the properties of each one individually. Drag and drop would be a modern UI method for this, alas it does not exist in GnuCash. Is there an easy way to do this, or just grunt it out? Thanks, Scott ___ 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] New user: how to migrate Quicken checking account as a single, flat, checking account
On 04 December 2022 at 11:54, Scott Traurig said: > I do understand double-entry accounting and that it is the GnuCash > paradigm. > > What I didn't understand is that on the import GnuCash did create the > requisite checking account, plus all the expense accounts. I did not see > the checking account as it was lost in a sea of expense accounts. > > Now that I've gotten that far, is there any way to move accounts en masse > into a top level "Expenses" account? Or do I have to laboriously edit each > and every one? What *might* work is to delete the unwanted accounts. When you delete an account, Gnucash will ask what you want to do with the transactions in it. You can move them to another (already existing) account. This will let you (for example) consolidate the grocery transactions, with 17 different vendors, into one "Expenses:Grocery" account. If you really want all the expenses in a single account then I suggest you don't want an accounting system and Gnucash is not the solution you are looking for. ___ 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] New user: how to migrate Quicken checking account as a single, flat, checking account
An easy way to "move" many entries is to *delete* the offending account and let GnuCash move it to another account. Say you have utilities:water as an account but also utilities:Watercompany. Then you simply delete one and ask GnuCash to move all transactions to the other. All in one fell swoop. Moving from Quicken (single entry) to GnuCash (Double entry) is at times a good deal of work before you have it the way you like it. It may even be of value to you to redo the import as you better understand GnuCash. On Sun, Dec 4, 2022 at 9:55 AM Scott Traurig wrote: > I do understand double-entry accounting and that it is the GnuCash > paradigm. > > What I didn't understand is that on the import GnuCash did create the > requisite checking account, plus all the expense accounts. I did not see > the checking account as it was lost in a sea of expense accounts. > > Now that I've gotten that far, is there any way to move accounts en masse > into a top level "Expenses" account? Or do I have to laboriously edit each > and every one? > > Thanks, > > Scott > ___ > 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] New user: how to migrate Quicken checking account as a single, flat, checking account
I do understand double-entry accounting and that it is the GnuCash paradigm. What I didn't understand is that on the import GnuCash did create the requisite checking account, plus all the expense accounts. I did not see the checking account as it was lost in a sea of expense accounts. Now that I've gotten that far, is there any way to move accounts en masse into a top level "Expenses" account? Or do I have to laboriously edit each and every one? Thanks, Scott ___ 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] New user: how to migrate Quicken checking account as a single, flat, checking account
This is a common concern whenever someone (including me) is migrating to Gnucash. As is noted elsewhere, it's a conceptual change based on Quicken Category => Gnucash Account. What I realized when I converted years and years of data over is just how terrible I was at maintaining some sort of consistency in Categories. I'd have dozens of accounts, each with maybe one or two transactions, that all were basically the same thing. They were likely the result of typing errors or "eh, I'll fix it later" transaction entries. Once I had converted all my data, I found that it was much easier to organize the accounts that were categories into a reasonable structure. It takes a bit of work, but it is nice to have "clean" accounts without the weird random categories I had in Quicken. ___ 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] New user: how to migrate Quicken checking account as a single, flat, checking account
Scott -- Forgive me if I misinterpreted your request -- but if I am reading it correctly, what you describing is not in line with the way GNU-Cash works. You see GNU-cash works as a double-entry (two-sided) accounting system. What that means is that for every transaction - there must be an opposite and equal counter-transaction. Let me give you an example: If I purchase groceries with a check, in the GNU-Cash world, there will exist at least two transactions. One (a debit to my checking account - which decreases the balance); and a second counter-transaction which will post the credit. In many cases, you might have an expense account called - Expenses: Groceries. That accounts balance will increase by the amount you just purchased. To make this more concrete, let's use an example: Balance in Checking Account: $220 Balance in Expense Groceries Account: $0 You go to the store - purchase $50 in groceries - and write check 1001 for $50, reducing your checking account balance to $170. Transaction in the Checking register: Date| NUM| Description | Transfer |Deposit |Withdrawal| Balance | 12/4/2022 | 1001| Local Grocery Store |Expenses:Groceries | | 50.00|170.00| Meanwhile, this transaction has also generated a separate equal and corresponding transaction in the Expenses"Groceries account that looks like this: Date| NUM| Description | Transfer |Expense |Rebate| Balance | 12/4/2022 | 1001| Local Grocery Store |Expenses:Groceries | 50.00| |50.00| So every transaction has a separate and equal "counter-transaction". In this way, everything remains in balance. So you see, the reason you are seeing so many accounts is because each category that you spend on will have a separate account. The nice thing about this, is that if you want to know how much you spent on any separate area (groceries, utilities, etc.) you will always have a separate account which shows how much you have spent. As I said, I hope this helps explain why you are seeing what you are seeing. You should just have one account (register) for your checking account. The other accounts are all the counter expense (or deposit) accounts. Ken -Original Message- From: gnucash-user On Behalf Of Scott Traurig Sent: Sunday, December 4, 2022 7:45 AM To: gnucash-user@gnucash.org Subject: [GNC] New user: how to migrate Quicken checking account as a single, flat, checking account Hi all: New user questions follow, I'm afraid... I have no trouble following the directions in the wiki for migrating from Quicken. I made the QIF file, imported it into GnuCash, and watched it very unhelpfully create 100 different accounts. The instructions do mentions this, and it's ability to match against Quicken categories is impressive, but it's not what I desire. In Quicken this account is a simple, flat, checking account. How can I take the 100 separate accounts and represent them in a simple, flat, single checking account register? Is there no way to do this? Thanks, Scott ___ 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] New user: how to migrate Quicken checking account as a single, flat, checking account
Hi Scott, This took some getting used to when I moved from Quicken 7 years or so ago. The categories become accounts. This is required for double entry accounting and makes sense. When you pay your electric bill, money moves from checking to the electric company. GNUCash has to show money moving between accounts. Once I got my head around it it was pretty simple. Michael On Sun, Dec 4, 2022 at 9:46 AM Scott Traurig wrote: > Hi all: > > New user questions follow, I'm afraid... > > I have no trouble following the directions in the wiki for migrating from > Quicken. I made the QIF file, imported it into GnuCash, and watched it very > unhelpfully create 100 different accounts. The instructions do mentions > this, and it's ability to match against Quicken categories is impressive, > but it's not what I desire. > > In Quicken this account is a simple, flat, checking account. How can I take > the 100 separate accounts and represent them in a simple, flat, single > checking account register? Is there no way to do this? > > Thanks, > > Scott > ___ > 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] New user: how to migrate Quicken checking account as a single, flat, checking account
Hi all: New user questions follow, I'm afraid... I have no trouble following the directions in the wiki for migrating from Quicken. I made the QIF file, imported it into GnuCash, and watched it very unhelpfully create 100 different accounts. The instructions do mentions this, and it's ability to match against Quicken categories is impressive, but it's not what I desire. In Quicken this account is a simple, flat, checking account. How can I take the 100 separate accounts and represent them in a simple, flat, single checking account register? Is there no way to do this? Thanks, Scott ___ 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.
