[GNC] General Journal Report
John Ralls
jralls at ceridwen.us
Sat Jul 6 21:01:10 EDT 2019
No, but you can use Edit>Find to select transactions and then run an Account Report.
Regards,
John Ralls
> On Jul 6, 2019, at 5:44 PM, Su Fan <hifredo at gmail.com> wrote:
>
> 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
>> *********************************************
>>
> _______________________________________________
> 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.
More information about the gnucash-user
mailing list