[GNC] General Journal Report

Su Fan hifredo at gmail.com
Sat Jul 6 20:44:19 EDT 2019


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-request at gnucash.org> wrote:

> Send gnucash-user mailing list submissions to
>         gnucash-user at 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-request at gnucash.org
>
> You can reach the person managing the list at
>         gnucash-user-owner at 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? (sunfish62 at 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 <plafratt at gmail.com>
> To: Gnucash Users <gnucash-user at gnucash.org>
> Subject: Re: [GNC] Reconcile Flag when Importing Transactions from CSV
> Message-ID:
>         <
> CAJOcKQ6CkkfSLxi9e2uvxzK_UpztC3gXQ0p-7P-CDO0EJSX9+g at 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 <plafratt at 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 <plafratt at 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" <eric at ehbowen.net>
> To: gnucash-user at gnucash.org
> Subject: [GNC] Bulk export/import of transactions?
> Message-ID: <58d6fb9a-d79c-ac50-8551-2524b07d0b24 at 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
> eric at ehbowen.net <mailto:eric at 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 <sunfish62 at yahoo.com>
> To: "Eric H. Bowen" <eric at ehbowen.net>, Gnucash Users
>         <gnucash-user at gnucash.org>
> Subject: Re: [GNC] Bulk export/import of transactions?
> Message-ID: <vg8gfnx0xulay2bick3y9ct0.1562382833072 at 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 at 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
> eric at ehbowen.net <mailto:eric at ehbowen.net>
>
> ------------------------------
>
> Message: 4
> Date: Fri, 05 Jul 2019 22:50:29 -0500
> From: "Eric H. Bowen" <eric at ehbowen.net>
> To: D <sunfish62 at yahoo.com>, Gnucash Users <gnucash-user at gnucash.org>
> Subject: Re: [GNC] Bulk export/import of transactions?
> Message-ID: <fqn6q64hc6amrlr55oosghmo.1562385029557 at 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: sunfish62 at yahoo.com
> Sent: July 5, 2019 10:14 PM
> To: eric at ehbowen.net; gnucash-user at 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 at 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
> eric at ehbowen.net <mailto:eric at ehbowen.net>
>
> ------------------------------
>
> Message: 5
> Date: Sat, 6 Jul 2019 03:59:14 +0000
> From: Christopher Lam <christopher.lck at gmail.com>
> To: Stephen Camidge <scamidge at fastmail.fm>
> Cc: GnuCash users group <gnucash-user at gnucash.org>
> Subject: Re: [GNC] Multi column Income Statement
> Message-ID:
>         <CAKVAZZJ2+kyx0SckH8EgzOVT0y3L=
> gZz+Wj2KYQJdkpL-M9jJw at 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 <scamidge at fastmail.fm> wrote:
>
> > Most welcome report!
> >
> > Flaw - subaccount totals are double size & black
> >
> >
> > --
> >
> > Stephen C. Camidgescamidge at fastmail.fm(519) 363-3912
> >
> >
> >
> >
> > <https://www.postbox-inc.com>
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at 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: <sunfish62 at yahoo.com>
> To: "'Eric H. Bowen'" <eric at ehbowen.net>, "'Gnucash Users'"
>         <gnucash-user at 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 <eric at ehbowen.net>
> Sent: Saturday, July 6, 2019 9:20 AM
> To: D <sunfish62 at yahoo.com>; Gnucash Users <gnucash-user at 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: sunfish62 at yahoo.com
> Sent: July 5, 2019 10:14 PM
> To: eric at ehbowen.net; gnucash-user at 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 at 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
> eric at ehbowen.net <mailto:eric at ehbowen.net>
>
>
>
> ------------------------------
>
> Message: 7
> Date: Sat, 06 Jul 2019 11:03:57 +0200
> From: Geert Janssens <geert.gnucash at kobaltwit.be>
> To: gnucash-user at gnucash.org, sunfish62 at yahoo.com
> Cc: "'Eric H. Bowen'" <eric at ehbowen.net>
> Subject: Re: [GNC] Bulk export/import of transactions?
> Message-ID: <1733190.StqLpBhxFd at 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" <scamidge at fastmail.fm>
> To: "Christopher Lam" <christopher.lck at gmail.com>
> Cc: "GnuCash users group" <gnucash-user at gnucash.org>
> Subject: Re: [GNC] Multi column Income Statement
> Message-ID: <45fa2852-8891-4d6c-a2c5-11696d0e4c0b at 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 <scamidge at fastmail.fm>
> wrote:
> >> Most welcome report!
> >>
> >>  Flaw - subaccount totals are double size & black
> >>
> >>
> >>  --
> >>
> >>  Stephen C. Camidgescamidge at fastmail.fm(519) 363-3912
> >>
> >>
> >>
> >>
> >>  <https://www.postbox-inc.com>
> >>  _______________________________________________
> >>  gnucash-user mailing list
> >> gnucash-user at 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 at 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
> *********************************************
>


More information about the gnucash-user mailing list