Re: [GNC] Bulk export/import of transactions?

[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. 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  
Sent: Saturday, July 6, 2019 9:20 AM
To: D ; Gnucash Users 
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" 
 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 

___
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] Multi column Income Statement

[Christopher Lam]

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  wrote:

> Most welcome report!
>
> Flaw - subaccount totals are double size & black
>
>
> --
>
> Stephen C. camidgescami...@fastmail.fm(519) 363-3912
>
>
>
>
> 
> ___
> 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] Bulk export/import of transactions?

[Eric H. Bowen via gnucash-user]

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" 
 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 
___
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] Bulk export/import of transactions?

[D via gnucash-user]

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" 
 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 
___
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.

[GNC] Bulk export/import of transactions?

[Eric H. Bowen via gnucash-user]

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 


smime.p7s
Description: S/MIME Cryptographic Signature
___
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] Reconcile Flag when Importing Transactions from CSV

[Patrick]

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  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  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
>>
>
___
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.

[GNC] Multi column Income Statement

[Stephen Camidge]

Most welcome report!

Flaw - subaccount totals are double size & black


--

Stephen C. camidgescami...@fastmail.fm(519) 363-3912





___
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.

[GNC] Balance Sheet-PNL

[Stephen Camidge]

New report "Balance Sheet-PNL" combines a Balance Sheet and an Income 
Statement in a single report.



Where is it?





___
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] Change a batch of transactions from income to Expe

[David T. via gnucash-user]

I guess I don't know what part of it you're referring to. In 2.4 I see notes 
about the meaning of debit and credit, as well as general discussion about 
double entry accounting. It seemed to me that would have addressed OP's needs, 
but I defer to your perspective.  
 
  On Fri, Jul 5, 2019 at 16:19, David Cousens wrote:  
 David 

It hasn't been in the documentation in that form since 2.4 as it was only
inserted in commit 007ab9 on the 30th May and Frank merged into maint a
couple of weeks ago then when John did the V3.6 release it was included in
that.

This is par tof  the ToC from the pdf version of the 2.4 docs
2. The Basics
.
8
        Accounting Concepts
...
8
                The 5 Basic Accounts
..
8
                The Accounting Equation
.
8
                Double Entry
..
9
      Data Entry Concepts

9

Cheers

David



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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] Change a batch of transactions from income to Expe

[David Cousens]

David 

It hasn't been in the documentation in that form since 2.4 as it was only
inserted in commit 007ab9 on the 30th May and Frank merged into maint a
couple of weeks ago then when John did the V3.6 release it was included in
that.

This is par tof  the ToC from the pdf version of the 2.4 docs
2. The Basics
.
8
Accounting Concepts
...
8
 The 5 Basic Accounts
..
8
 The Accounting Equation
.
8
Double Entry
..
9
   Data Entry Concepts

9

Cheers

David



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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] Change a batch of transactions from income to Expe

[David T. via gnucash-user]

That information has been in the documentation since 2.4. Not sure what edits 
you are referring to...
 
 
  On Fri, Jul 5, 2019 at 13:11, David Cousens wrote:  
 David,

Sorry I hadn't realized the section i put in on that had made it into the
current version of the docs. Thanks for pointing that out.

David 



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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] Change a batch of transactions from income to Expense

[David Cousens]

David,

Sorry I hadn't realized the section i put in on that had made it into the
current version of the docs. Thanks for pointing that out.

David 



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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] Change a batch of transactions from income to Expense

[David T. via gnucash-user]

David, 

I am not sure why you say that the documentation lacks a description of debits 
and credits; I am sure you are aware of section 2.1 of the Guide, which goes 
into some detail about this precise issue. 

David T. 

 
 
  On Fri, Jul 5, 2019 at 3:32, David Cousens wrote:   
Alan,
The guide has an introductory session. The present version doesn't have a
full explanation of the way 
accountants use debits and credits but the next version will. You will find
a pretty good explanantion on Wikipedia and a few other sites. Look up
Double Entry, Debits and Credits with Google. In short form

Debits  increase the balance of Asset and Expense accounts
Credits decrease the balance of Asset and Expense accounts
Credits increase the balance of Liability, Equity and Income accounts
Debits decrease the balance of Liability, Equity and Income accounts

For an individual transaction  the sum of debits = sum of credits

Davdi



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.