Hi, Is there any way to select specific transactions to be printed on the General Journal Report?
Fred On Sun, Jul 7, 2019 at 12:01 AM <gnucash-user-requ...@gnucash.org> wrote: > 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. Re: Reconcile Flag when Importing Transactions from CSV (Patrick) > 2. Bulk export/import of transactions? (Eric H. Bowen) > 3. Re: Bulk export/import of transactions? (D) > 4. Re: Bulk export/import of transactions? (Eric H. Bowen) > 5. Re: Multi column Income Statement (Christopher Lam) > 6. Re: Bulk export/import of transactions? (sunfis...@yahoo.com) > 7. Re: Bulk export/import of transactions? (Geert Janssens) > 8. Re: Multi column Income Statement (Stephen C. Camidge) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Fri, 5 Jul 2019 14:52:05 -0500 > From: Patrick <plafr...@gmail.com> > To: Gnucash Users <gnucash-user@gnucash.org> > Subject: Re: [GNC] Reconcile Flag when Importing Transactions from CSV > Message-ID: > < > cajockq6ckkfslxi9e2uvxzk_upztc3gxq0p-7p-cdo0ejsx...@mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > > In case someone else comes across this and is looking for a temporary > workaround, this is what I did. > > In my local copy, I changed this line > > > https://github.com/Gnucash/gnucash/blob/maint/gnucash/import-export/import-backend.c#L924 > > to use "NREC" instead of "CREC". > > File: gnucash/import-export/import-backend.c > Function: gnc_import_process_trans_item() > case GNCImport_ADD > > Old line > xaccSplitSetReconcile(gnc_import_TransInfo_get_fsplit (trans_info), CREC); > > New line > xaccSplitSetReconcile(gnc_import_TransInfo_get_fsplit (trans_info), NREC); > > On Tue, Jul 2, 2019 at 6:58 AM Patrick <plafr...@gmail.com> wrote: > > > I was looking through the bug reports on Bugzilla, and I think there > might > > already be an outstanding request (#796890) to adjust this behavior. > > > > I think that means my best options are to be patient or to stare > > at gnc-imp-props-tx.cpp for a while. > > > > https://bugs.gnucash.org/show_bug.cgi?id=796890 > > > > On Mon, Jul 1, 2019 at 7:33 AM Patrick <plafr...@gmail.com> wrote: > > > >> When I am importing transactions from a CSV, I have a "Reconcile" column > >> that I select as the "Transfer Reconciled" column in the import wizard. > I > >> have all of the entries marked as "n" in this column, but after > importing > >> them, some of them seem to still show up as "c". Am I misunderstanding > the > >> "Transfer Reconciled" option, or am I likely doing something else wrong? > >> > >> I'm not sure if it is relevant, but I am importing in multi-split mode. > >> > >> Regards, > >> Patrick > >> > > > > > ------------------------------ > > Message: 2 > Date: Fri, 5 Jul 2019 20:34:04 -0500 > From: "Eric H. Bowen" <e...@ehbowen.net> > To: gnucash-user@gnucash.org > Subject: [GNC] Bulk export/import of transactions? > Message-ID: <58d6fb9a-d79c-ac50-8551-2524b07d0...@ehbowen.net> > Content-Type: text/plain; charset="utf-8" > > I'm a fairly new GnuCash user, and last year I set up an account for a > part-time business which i have doing video work. Unfortunately, being > unfamiliar with GnuCash, I made some mistakes while reconciling accounts > in the early months which I now cannot change or correct. I'd like to > basically start over with a new worksheet, but I spent a lot of time > entering split transactions and such in the old one to account for > equipment costs and depreciation. I'd rather not re-invent the wheel. Is > there a way to bulk export transactions from the old worksheet and then > re-import them into the new worksheet which preserves split information > and other notes? > > -- > > --------Eric H. Bowen > e...@ehbowen.net <mailto:e...@ehbowen.net> > -------------- next part -------------- > A non-text attachment was scrubbed... > Name: smime.p7s > Type: application/pkcs7-signature > Size: 3993 bytes > Desc: S/MIME Cryptographic Signature > URL: < > http://lists.gnucash.org/pipermail/gnucash-user/attachments/20190705/8c54f4af/attachment-0001.p7s > > > > ------------------------------ > > Message: 3 > Date: Sat, 06 Jul 2019 08:43:53 +0530 > From: D <sunfis...@yahoo.com> > To: "Eric H. Bowen" <e...@ehbowen.net>, Gnucash Users > <gnucash-user@gnucash.org> > Subject: Re: [GNC] Bulk export/import of transactions? > Message-ID: <vg8gfnx0xulay2bick3y9ct0.1562382833...@email.android.com> > Content-Type: text/plain; charset=utf-8 > > Eric, > > In version 3, there is an export to csv that can be used, I believe. > > Before you do that however, perhaps you could explain why you say you > cannot change or correct the problems? Maybe those problems aren't as > intractable as you think. It's been my experience that most any problem can > be fixed in Gnucash. > > David T. > > On July 6, 2019, at 7:05 AM, "Eric H. Bowen via gnucash-user" < > gnucash-user@gnucash.org> wrote: > > I'm a fairly new GnuCash user, and last year I set up an account for a > part-time business which i have doing video work. Unfortunately, being > unfamiliar with GnuCash, I made some mistakes while reconciling accounts > in the early months which I now cannot change or correct. I'd like to > basically start over with a new worksheet, but I spent a lot of time > entering split transactions and such in the old one to account for > equipment costs and depreciation. I'd rather not re-invent the wheel. Is > there a way to bulk export transactions from the old worksheet and then > re-import them into the new worksheet which preserves split information > and other notes? > > -- > > --------Eric H. Bowen > e...@ehbowen.net <mailto:e...@ehbowen.net> > > ------------------------------ > > Message: 4 > Date: Fri, 05 Jul 2019 22:50:29 -0500 > From: "Eric H. Bowen" <e...@ehbowen.net> > To: D <sunfis...@yahoo.com>, Gnucash Users <gnucash-user@gnucash.org> > Subject: Re: [GNC] Bulk export/import of transactions? > Message-ID: <fqn6q64hc6amrlr55oosghmo.1562385029...@ehbowen.net> > Content-Type: text/plain; charset=utf-8 > > My problem stems from the fact that I started the business in April, but > was purchasing equipment for it from the beginning of the year. After I had > the first few months (April to July) in and reconciled, I belatedly > realized that I needed to go back and include my purchase transactions from > the first of the year. But since I already had several months reconciled, > when I added the earlier transactions I ended up with a mess. If there's > any way to reverse the reconciliations as they stand now, I'm not aware of > it. That would be preferable to starting over. > > > > Sent from my BlackBerry - the most secure mobile device > > > ? Original Message ? > > > > From: sunfis...@yahoo.com > Sent: July 5, 2019 10:14 PM > To: e...@ehbowen.net; gnucash-user@gnucash.org > Subject: Re: [GNC] Bulk export/import of transactions? > > > Eric, > > In version 3, there is an export to csv that can be used, I believe. > > Before you do that however, perhaps you could explain why you say you > cannot change or correct the problems? Maybe those problems aren't as > intractable as you think. It's been my experience that most any problem can > be fixed in Gnucash. > > David T. > > On July 6, 2019, at 7:05 AM, "Eric H. Bowen via gnucash-user" < > gnucash-user@gnucash.org> wrote: > > I'm a fairly new GnuCash user, and last year I set up an account for a > part-time business which i have doing video work. Unfortunately, being > unfamiliar with GnuCash, I made some mistakes while reconciling accounts > in the early months which I now cannot change or correct. I'd like to > basically start over with a new worksheet, but I spent a lot of time > entering split transactions and such in the old one to account for > equipment costs and depreciation. I'd rather not re-invent the wheel. Is > there a way to bulk export transactions from the old worksheet and then > re-import them into the new worksheet which preserves split information > and other notes? > > -- > > --------Eric H. Bowen > e...@ehbowen.net <mailto:e...@ehbowen.net> > > ------------------------------ > > Message: 5 > Date: Sat, 6 Jul 2019 03:59:14 +0000 > From: Christopher Lam <christopher....@gmail.com> > To: Stephen Camidge <scami...@fastmail.fm> > Cc: GnuCash users group <gnucash-user@gnucash.org> > Subject: Re: [GNC] Multi column Income Statement > Message-ID: > <CAKVAZZJ2+kyx0SckH8EgzOVT0y3L= > gzz+wj2kyqjdkpl-m9...@mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > > Glad you like it. The subtotals are styled as such to highlight they > include >1 account totals. > Try Display/Parent account amounts include children option. > > On Fri, 5 Jul 2019 at 12:54, Stephen Camidge <scami...@fastmail.fm> wrote: > > > Most welcome report! > > > > Flaw - subaccount totals are double size & black > > > > > > -- > > > > Stephen C. camidgescami...@fastmail.fm(519) 363-3912 > > > > > > > > > > <https://www.postbox-inc.com> > > _______________________________________________ > > 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. > > > > > ------------------------------ > > Message: 6 > Date: Sat, 6 Jul 2019 11:31:30 +0530 > From: <sunfis...@yahoo.com> > To: "'Eric H. Bowen'" <e...@ehbowen.net>, "'Gnucash Users'" > <gnucash-user@gnucash.org> > Subject: Re: [GNC] Bulk export/import of transactions? > Message-ID: <008601d533c0$427e0470$c77a0d50$@yahoo.com> > Content-Type: text/plain; charset="utf-8" > > Ok. This comes up from time to time. Others may chime in with additional > pointers, but here's how I'd go about it. > > 1) I would change the date of the Opening Balance transaction to the day > before your starting date (December 31, 2017 for example), and change the > amounts of both lines in this transaction (i.e., both the debit and the > credit) to reflect the amount on that date. So, if your checking account > April 1 opening balance entry is $500, but your December 31 balance was > $350, change the debit and credit amount in the Opening Balance transaction > from $500 to $350 and set the date to December 31. > 2) I would then enter every transaction in the gap period. > 3) I would then take the hopeful step of pulling my *most recent* > reconciled statement and trying to re-reconcile. Presumably, the only > differences between the previous reconciliation and this pass will be the > transactions you entered from the previous gap period, and when you select > all these earlier transactions, it should balance out, and you can finish > the reconciliation. If this works, then you are done with the process. > > If for some reason this doesn't work, you'd most likely have to > de-reconcile everything then and work through month by month from bank > statements, which would pinpoint the discrepancies and allow you to work > them out. This, admittedly, is much more painful, and off the top of my > head, I cannot think of a simple way to reset the reconcile tag. This is > not to say it can't be done; just that I haven't really given it thought. > If it were me, I'd probably take the data into an SQL backend, and figure > out how to use SQL to change the reconcile flag for that account. Of > course, that's a quick way to screw up you data permanently, so if you need > to go that route, the usual warnings apply (Work on a backup, damages > cannot be fixed by others, etc.) > > HTH, > David T. > > > -----Original Message----- > From: Eric H. Bowen <e...@ehbowen.net> > Sent: Saturday, July 6, 2019 9:20 AM > To: D <sunfis...@yahoo.com>; Gnucash Users <gnucash-user@gnucash.org> > Subject: Re: [GNC] Bulk export/import of transactions? > > My problem stems from the fact that I started the business in April, but > was purchasing equipment for it from the beginning of the year. After I had > the first few months (April to July) in and reconciled, I belatedly > realized that I needed to go back and include my purchase transactions from > the first of the year. But since I already had several months reconciled, > when I added the earlier transactions I ended up with a mess. If there's > any way to reverse the reconciliations as they stand now, I'm not aware of > it. That would be preferable to starting over. > > > > Sent from my BlackBerry - the most secure mobile device > > > Original Message > > > > From: sunfis...@yahoo.com > Sent: July 5, 2019 10:14 PM > To: e...@ehbowen.net; gnucash-user@gnucash.org > Subject: Re: [GNC] Bulk export/import of transactions? > > > Eric, > > In version 3, there is an export to csv that can be used, I believe. > > Before you do that however, perhaps you could explain why you say you > cannot change or correct the problems? Maybe those problems aren't as > intractable as you think. It's been my experience that most any problem can > be fixed in Gnucash. > > David T. > > On July 6, 2019, at 7:05 AM, "Eric H. Bowen via gnucash-user" < > gnucash-user@gnucash.org> wrote: > > I'm a fairly new GnuCash user, and last year I set up an account for a > part-time business which i have doing video work. Unfortunately, being > unfamiliar with GnuCash, I made some mistakes while reconciling accounts in > the early months which I now cannot change or correct. I'd like to > basically start over with a new worksheet, but I spent a lot of time > entering split transactions and such in the old one to account for > equipment costs and depreciation. I'd rather not re-invent the wheel. Is > there a way to bulk export transactions from the old worksheet and then > re-import them into the new worksheet which preserves split information and > other notes? > > -- > > --------Eric H. Bowen > e...@ehbowen.net <mailto:e...@ehbowen.net> > > > > ------------------------------ > > Message: 7 > Date: Sat, 06 Jul 2019 11:03:57 +0200 > From: Geert Janssens <geert.gnuc...@kobaltwit.be> > To: gnucash-user@gnucash.org, sunfis...@yahoo.com > Cc: "'Eric H. Bowen'" <e...@ehbowen.net> > Subject: Re: [GNC] Bulk export/import of transactions? > Message-ID: <1733190.stqlpbh...@legolas.kobaltwit.lan> > Content-Type: text/plain; charset="us-ascii" > > Op zaterdag 6 juli 2019 08:01:30 CEST schreef sunfish62--- via > gnucash-user: > > Ok. This comes up from time to time. Others may chime in with additional > > pointers, but here's how I'd go about it. > > > > 1) I would change the date of the Opening Balance transaction to the day > > before your starting date (December 31, 2017 for example), and change the > > amounts of both lines in this transaction (i.e., both the debit and the > > credit) to reflect the amount on that date. So, if your checking account > > April 1 opening balance entry is $500, but your December 31 balance was > > $350, change the debit and credit amount in the Opening Balance > transaction > > from $500 to $350 and set the date to December 31. 2) I would then enter > > every transaction in the gap period. > > 3) I would then take the hopeful step of pulling my *most recent* > reconciled > > statement and trying to re-reconcile. Presumably, the only differences > > between the previous reconciliation and this pass will be the > transactions > > you entered from the previous gap period, and when you select all these > > earlier transactions, it should balance out, and you can finish the > > reconciliation. If this works, then you are done with the process. > > > > If for some reason this doesn't work, you'd most likely have to > de-reconcile > > everything then and work through month by month from bank statements, > which > > would pinpoint the discrepancies and allow you to work them out. This, > > admittedly, is much more painful, and off the top of my head, I cannot > > think of a simple way to reset the reconcile tag. > > That's actually really simple: you click on each "Y" in the reconcile > column > to unreconcile a transaction. You will get a warning for what you are > about to > undo. If you have many to unreconcile, save your choice for the current > session so the warning will not continue to pop up while you're resetting. > > If you don't get this warning and instead can't unreconcile, that probably > means you have in the past told gnucash to not carry on with the action > and > remember that decision for the future. That warning can then be reset via > Actions->Reset warnings. > > Do note that this may give unexpected starting balances on the next > reconciliation action. Normally whatever gnucash proposes a starting > balance > should be kept. Only the ending balance on the reconcile date should be > set to > what is on the bank statements. > > Regards, > > Geert > > > > > ------------------------------ > > Message: 8 > Date: Sat, 06 Jul 2019 07:19:27 -0400 > From: "Stephen C. Camidge" <scami...@fastmail.fm> > To: "Christopher Lam" <christopher....@gmail.com> > Cc: "GnuCash users group" <gnucash-user@gnucash.org> > Subject: Re: [GNC] Multi column Income Statement > Message-ID: <45fa2852-8891-4d6c-a2c5-11696d0e4...@www.fastmail.com> > Content-Type: text/plain > > No change, subaccounts still double size & black. > > > On Fri, Jul 5, 2019, at 11:59 PM, Christopher Lam wrote: > > Glad you like it. The subtotals are styled as such to highlight they > include >1 account totals. > > Try Display/Parent account amounts include children option. > > > > On Fri, 5 Jul 2019 at 12:54, Stephen Camidge <scami...@fastmail.fm> > wrote: > >> Most welcome report! > >> > >> Flaw - subaccount totals are double size & black > >> > >> > >> -- > >> > >> Stephen C. camidgescami...@fastmail.fm(519) 363-3912 > >> > >> > >> > >> > >> <https://www.postbox-inc.com> > >> _______________________________________________ > >> 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. > > ------------------------------ > > Subject: Digest Footer > > _______________________________________________ > > 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. > > > ------------------------------ > > End of gnucash-user Digest, Vol 196, Issue 17 > ********************************************* > _______________________________________________ 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.