Re: [GNC] Unusual book need
On 4/16/2022 1:32 AM, Jeff wrote: David, I like your approach the best. Even though the transactions are in a joint account between my son and father, I am legally responsible for my sons activities. And all of the transactions apply to my farm, not Dads. Again, I am asking you to be specific/confirm so that we can give you best advice. "And all of the transactions apply to my farm, not Dads" - are you saying that all transactions to THIS bank account are fro your farm (the only exceptions being perhaps your father putting money into it)? The "ownership" of the account (being joint) is NOT necessarily part of the problem). And in your father's gnucash books, this is a separate account (for THIS bank account). Because in that case there is no separation problem, no identifying of the individual transaction. Your request would then be "how do I get an account and all its associated transactions transactions from one set of books to another"? In this case like an export/import with delete behind. But SOME of the transactions would have to change. Namely, the debits << because they were probably transfers between one of your father's bank accounts and this one but now the debit will be an income account "gifts from Dad" << and whether reportable will depend on the annual total >> Michael D Novack NOTE: You would NOT have to edit the export/import file to make the debit change. Use the trick of temporarily "lying" to the computer by temporarily creating an account under assets for you Dad's other bank << just like it is in his books >> and then afterwards you will rename it and reparent it. PS -- Know how you feel -- back in younger days, one of Penny's does decided to give birth outside of the goat house when it was below zero and we had three frostbitten kids to deal with in a playpen set up in the kitchen. Luckily no problem getting the to take the bottle. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Unusual book need
Jeff Someonelse suggested using the find transaction search if there is some common string you can search for. David On Sat, 2022-04-16 at 00:32 -0500, Jeff wrote: > David, I like your approach the best. Even though the transactions are > in a joint account between my son and father, I am legally responsible > for my sons activities. And all of the transactions apply to my farm, > not Dads. > > Now for the fun part, I have to find all of them and get them moved. > The IRS waits for no one and I am in a serious time crunch. 3 > abandoned/orphaned bottle calves and trying to save an abandoned newborn > that refuses both bottle and standing up (I definitely do not need a > quadriplegic calf right now. I don't even know where to purchase a > wheel chair for a calf). Oh, the joys of being a farmer! > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Unusual book need
David, I like your approach the best. Even though the transactions are in a joint account between my son and father, I am legally responsible for my sons activities. And all of the transactions apply to my farm, not Dads. Now for the fun part, I have to find all of them and get them moved. The IRS waits for no one and I am in a serious time crunch. 3 abandoned/orphaned bottle calves and trying to save an abandoned newborn that refuses both bottle and standing up (I definitely do not need a quadriplegic calf right now. I don't even know where to purchase a wheel chair for a calf). Oh, the joys of being a farmer! -- --JEffrey Black M.B.A. On 4/15/22 4:10 PM, davidcousen...@gmail.com wrote: Jeff Another approach you could try would be to create a temporary account in your dad's books and move the transactions that should have gone into your account into it. Should work if all of the transactions have at least one account in common , e.g. an Asset; bank account or similar. if not you may need to create more than one temp account. You could then export the transactions in that temp accountas an OFX or CSV file which you could then import into your own books. If the target accounts are the same in yours and your dad's books they should import but if not edit those that aren't. CSV may be more appropriate if you need to edit the transactions before importing If you then delete the temporary account in your dad's books and choose to discard the transactions in it you should be good. David Cousens On Fri, 2022-04-15 at 04:00 -0500, Jeff wrote: I need to move transactions from from one set of books to another one. I didn't realize while entering transactions in my dads books that they should have gone into mine. My dad opened a bank account that I did not know about until I started entering charges that my son made with feed stores (debit card). I had not been informed about the bank account that grandpa opened in my sons name, and I am responsible for all of his income/debits until he is 21. And many of these transactions affect my income/loss. Is there an easy way to move those entries from one journal to the other or will I have to find all of them and manually delete them from one journal and reenter them in mine? These are separate journal files. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. . ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Unusual book need
Jeff Another approach you could try would be to create a temporary account in your dad's books and move the transactions that should have gone into your account into it. Should work if all of the transactions have at least one account in common , e.g. an Asset; bank account or similar. if not you may need to create more than one temp account. You could then export the transactions in that temp accountas an OFX or CSV file which you could then import into your own books. If the target accounts are the same in yours and your dad's books they should import but if not edit those that aren't. CSV may be more appropriate if you need to edit the transactions before importing If you then delete the temporary account in your dad's books and choose to discard the transactions in it you should be good. David Cousens On Fri, 2022-04-15 at 04:00 -0500, Jeff wrote: > I need to move transactions from from one set of books to another one. > > I didn't realize while entering transactions in my dads books that they > should have gone into mine. My dad opened a bank account that I did not > know about until I started entering charges that my son made with feed > stores (debit card). I had not been informed about the bank account > that grandpa opened in my sons name, and I am responsible for all of his > income/debits until he is 21. And many of these transactions affect my > income/loss. > > Is there an easy way to move those entries from one journal to the other > or will I have to find all of them and manually delete them from one > journal and reenter them in mine? These are separate journal files. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Unusual book need
There's an easier way: First use the Find dialog to select all of the transactions in question into a journal. Create a temporary account for them, then change the account for all of them to the temporary account. That's the only step that requires one-by-one editing, but if you're clever with the account name so that it's adjacent to the original one in the list then it's only 3 clicks per transaction. Next select File>Export>Export Transactions as CSV. If these are two-split transactions with no notes or memos then you can select "simple format" on the first page. Also select "Use quotes" there to protect any oddities in descriptions. Proceed with the export. Open the resulting CSV in a spreadsheet program and use Find-Replace to adjust the account names to match the other book. In GnuCash save the file and open the other one. You might want to disable auto-save (save to XML first if you're on a SQL backend) so that you can easily discard the import if it needs tweaking. Import the transactions from CSV and check the results to make sure you got what you want. Once you're happy save the results and switch back to Grandpa's book. Make sure the Find register and if you opened one the temporary account register from the first step are closed. Select the temporary account in the Accounts page and click the Delete button on the toolbar. In the middle of the dialog select "Delete all Transactions" and click "Delete". Regards, John Ralls > On Apr 15, 2022, at 8:43 AM, David T. via gnucash-user > wrote: > > Jean, > > Your assessment is about right, although I wouldn't characterize it as a > shortcoming, just an area that requires manual intervention. > > Jeff, > > While it may seem onerous to consider, it turns out that creating and > deleting transactions is not that great an effort, given auto completion. If > you open both sets of books and display them side by side, you can quickly > work through your dad's file and add the transactions to your books. > > Once you are satisfied with the accuracy of the new transactions, you can > delete them from your dad's books. Turning off the delete transaction > confirmation for the session can speed that up significantly. > > It's possible to make, move, and delete hundreds of transactions in a short > period of time. (This fact, coupled with the relative infrequency of needing > to do this and the programming overhead involved is the reason why nobody has > developed a tool for this.) > > David T. > > On April 15, 2022 3:20:27 AM PDT, Jean Laroche wrote: >> As far as I know, there's no easy way to delete a group of transactions, >> I think that's one of the shortcomings of GC? >> You can do a search to find all of them using the right criterion but >> I'm pretty sure after that you can't really do much with that (except >> create a report which isn't useful for you). >> >> But maybe the experts know of a way. >> >> One useful feature would be the ability to delete/move transactions in a >> search result, since GC does not allow selecting multiple transactions >> and acting on them (to move them to a new account / delete them etc) >> doing it on the result of a search could be a useful workaround. >> >> J >> >> >> On 4/15/22 11:00 AM, Jeff wrote: >>> I need to move transactions from from one set of books to another one. >>> >>> I didn't realize while entering transactions in my dads books that >>> they should have gone into mine. My dad opened a bank account that I >>> did not know about until I started entering charges that my son made >>> with feed stores (debit card). I had not been informed about the bank >>> account that grandpa opened in my sons name, and I am responsible for >>> all of his income/debits until he is 21. And many of these >>> transactions affect my income/loss. >>> >>> Is there an easy way to move those entries from one journal to the >>> other or will I have to find all of them and manually delete them from >>> one journal and reenter them in mine? These are separate journal files. >>> >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using
Re: [GNC] Unusual book need
To add, you can do bulk delete as described here, which works great and is really fast: https://lists.gnucash.org/pipermail/gnucash-user/2021-December/098934.html On Fri, Apr 15, 2022 at 11:43 AM David T. via gnucash-user < gnucash-user@gnucash.org> wrote: > Jean, > > Your assessment is about right, although I wouldn't characterize it as a > shortcoming, just an area that requires manual intervention. > > Jeff, > > While it may seem onerous to consider, it turns out that creating and > deleting transactions is not that great an effort, given auto completion. > If you open both sets of books and display them side by side, you can > quickly work through your dad's file and add the transactions to your > books. > > Once you are satisfied with the accuracy of the new transactions, you can > delete them from your dad's books. Turning off the delete transaction > confirmation for the session can speed that up significantly. > > It's possible to make, move, and delete hundreds of transactions in a > short period of time. (This fact, coupled with the relative infrequency of > needing to do this and the programming overhead involved is the reason why > nobody has developed a tool for this.) > > David T. > > On April 15, 2022 3:20:27 AM PDT, Jean Laroche wrote: > >As far as I know, there's no easy way to delete a group of transactions, > >I think that's one of the shortcomings of GC? > >You can do a search to find all of them using the right criterion but > >I'm pretty sure after that you can't really do much with that (except > >create a report which isn't useful for you). > > > >But maybe the experts know of a way. > > > >One useful feature would be the ability to delete/move transactions in a > >search result, since GC does not allow selecting multiple transactions > >and acting on them (to move them to a new account / delete them etc) > >doing it on the result of a search could be a useful workaround. > > > >J > > > > > >On 4/15/22 11:00 AM, Jeff wrote: > >> I need to move transactions from from one set of books to another one. > >> > >> I didn't realize while entering transactions in my dads books that > >> they should have gone into mine. My dad opened a bank account that I > >> did not know about until I started entering charges that my son made > >> with feed stores (debit card). I had not been informed about the bank > >> account that grandpa opened in my sons name, and I am responsible for > >> all of his income/debits until he is 21. And many of these > >> transactions affect my income/loss. > >> > >> Is there an easy way to move those entries from one journal to the > >> other or will I have to find all of them and manually delete them from > >> one journal and reenter them in mine? These are separate journal files. > >> > >___ > >gnucash-user mailing list > >gnucash-user@gnucash.org > >To update your subscription preferences or to unsubscribe: > >https://lists.gnucash.org/mailman/listinfo/gnucash-user > >If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > >- > >Please remember to CC this list on all your replies. > >You can do this by using Reply-To-List or Reply-All. > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Unusual book need
On 4/15/2022 5:00 AM, Jeff wrote: I need to move transactions from from one set of books to another one. I didn't realize while entering transactions in my dads books that they should have gone into mine. My dad opened a bank account that I did not know about until I started entering charges that my son made with feed stores (debit card). I had not been informed about the bank account that grandpa opened in my sons name, and I am responsible for all of his income/debits until he is 21. And many of these transactions affect my income/loss. Is there an easy way to move those entries from one journal to the other or will I have to find all of them and manually delete them from one journal and reenter them in mine? These are separate journal files. Let's first get greater clarity (a more precise definition) of WHAT you need to do. THEN we'll worry about how. I am going to take a crack by stating what I think the situation is and you correct if wrong. In your father's books is a bank account that should instead be in your books. You want ALL the transactions that appear in that bank account to instead be in your books (including, of course, the bank account itself). Is THAT a correct description of the problem? If so, you had best do this NOT by having both sets of books open at the same time. You can get a report of all the transactions involving this bank account from your father's set of books and export that so you will have hard copy in front of you. Then open your books, create the account for this bank account, and enter the transactions. For the money coming IN to this account you will perhaps need to add an income account "gifts from grandpa" (if those were not loans) and whether this ends up under taxable income or non-taxable will depend on the annual total amount. BUT you left out details about for whom the feed was bought. Just because grandpa opened a bank account for your son (and has he been transferring more money into it) does NOT mean the feed purchased has anything to do with you. For example, if your son took the truck to the feed store and bought feed for his grandpa paying for it with his debit card and grandpa later reimbursed him for it that has nothing to do with your books. You would need to report interest income (if any) if taxes are filed with your son as a dependent << even if "under age" a child with significant income MIGHT be filed separately. >> On the other hand, if your son is feeding beasts of his own, even if reported on your income, you MIGHT want to consider having a set of books for him even though that complicates matters. The purpose of accounting in information and how well this junior farmer is doing with his little venture is part of the learning << I am just guessing, of course, that this is "farming" >> Michael D Novack PS: In spite of the email address I'm not. This land was last commercially farmed circa 1930 and is now forest and wildlife habitat (though in our younger days did have a large garden and some livestock -- There is no possibility of social justice on a dead planet except the equality of the grave. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Unusual book need
Jean, Your assessment is about right, although I wouldn't characterize it as a shortcoming, just an area that requires manual intervention. Jeff, While it may seem onerous to consider, it turns out that creating and deleting transactions is not that great an effort, given auto completion. If you open both sets of books and display them side by side, you can quickly work through your dad's file and add the transactions to your books. Once you are satisfied with the accuracy of the new transactions, you can delete them from your dad's books. Turning off the delete transaction confirmation for the session can speed that up significantly. It's possible to make, move, and delete hundreds of transactions in a short period of time. (This fact, coupled with the relative infrequency of needing to do this and the programming overhead involved is the reason why nobody has developed a tool for this.) David T. On April 15, 2022 3:20:27 AM PDT, Jean Laroche wrote: >As far as I know, there's no easy way to delete a group of transactions, >I think that's one of the shortcomings of GC? >You can do a search to find all of them using the right criterion but >I'm pretty sure after that you can't really do much with that (except >create a report which isn't useful for you). > >But maybe the experts know of a way. > >One useful feature would be the ability to delete/move transactions in a >search result, since GC does not allow selecting multiple transactions >and acting on them (to move them to a new account / delete them etc) >doing it on the result of a search could be a useful workaround. > >J > > >On 4/15/22 11:00 AM, Jeff wrote: >> I need to move transactions from from one set of books to another one. >> >> I didn't realize while entering transactions in my dads books that >> they should have gone into mine. My dad opened a bank account that I >> did not know about until I started entering charges that my son made >> with feed stores (debit card). I had not been informed about the bank >> account that grandpa opened in my sons name, and I am responsible for >> all of his income/debits until he is 21. And many of these >> transactions affect my income/loss. >> >> Is there an easy way to move those entries from one journal to the >> other or will I have to find all of them and manually delete them from >> one journal and reenter them in mine? These are separate journal files. >> >___ >gnucash-user mailing list >gnucash-user@gnucash.org >To update your subscription preferences or to unsubscribe: >https://lists.gnucash.org/mailman/listinfo/gnucash-user >If you are using Nabble or Gmane, please see >https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >- >Please remember to CC this list on all your replies. >You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Unusual book need
As far as I know, there's no easy way to delete a group of transactions, I think that's one of the shortcomings of GC? You can do a search to find all of them using the right criterion but I'm pretty sure after that you can't really do much with that (except create a report which isn't useful for you). But maybe the experts know of a way. One useful feature would be the ability to delete/move transactions in a search result, since GC does not allow selecting multiple transactions and acting on them (to move them to a new account / delete them etc) doing it on the result of a search could be a useful workaround. J On 4/15/22 11:00 AM, Jeff wrote: I need to move transactions from from one set of books to another one. I didn't realize while entering transactions in my dads books that they should have gone into mine. My dad opened a bank account that I did not know about until I started entering charges that my son made with feed stores (debit card). I had not been informed about the bank account that grandpa opened in my sons name, and I am responsible for all of his income/debits until he is 21. And many of these transactions affect my income/loss. Is there an easy way to move those entries from one journal to the other or will I have to find all of them and manually delete them from one journal and reenter them in mine? These are separate journal files. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.