Re: Dealing with a large QIF file

2017-12-24 Thread David Carlson
I believe that the GnuCash QIF importer allows nearly arbitrary mapping from the incoming account tree to the resulting account tree during the import. Thus I would suggest taking the time to diagram (in a spreadsheet, perhaps) a desired path from the old tree to the new tree, defining certain

Re: Dealing with a large QIF file

2017-12-24 Thread D via gnucash-user
Gnucash creates the accounts because you and the transactions used those accounts. Personally, I prefer having all that "clutter," since it represents what happened. Accounting is supposed to track what happened, after all. Two points: first, you can hide accounts in the Chart of Accounts,

Re: Dealing with a large QIF file

2017-12-24 Thread Lincoln A Baxter
On Mon, 2017-12-25 at 00:46 +, cliffhan...@gardener.com wrote: >    Thanks. Yes one can import one at a time but this cheque ac from >    Quicken is huge and has references to other card accounts as > categories >    within it. These accounts don't exist anymore and gnucash is > trying to >    

Dealing with a large QIF file

2017-12-24 Thread cliffhan...@gardener.com
Thanks . Yes one can import one at a time but this cheque ac from Quicken is huge and has references to other card accounts as categories within it. These accounts don't exist anymore and gnucash is trying to create them as part of the import. This is something I'd like to avoid. Hope this

Re: Dealing with a large QIF file

2017-12-24 Thread cliffhan...@gardener.com
Thanks. Yes one can import one at a time but this cheque ac from Quicken is huge and has references to other card accounts as categories within it. These accounts don't exist anymore and gnucash is trying to create them as part of the import. This is something I'd like to avoid.

Re: Dealing with a large QIF file

2017-12-24 Thread Colin Law
You should be able to export one account at a time from Quicken, I think. Then import them one at a time. Colin On 24 December 2017 at 19:02, Cliff McDiarmid wrote: >Hi > >I'm importing a large QIF file(a current a/c)about 6000 entries. >There are about a

Re: Unrealized Gains and Closing Books

2017-12-24 Thread DaveC49
The short answer is yes. but the following articles may give you some insights into how unrealized gains and losses are usually recorded and reported. These article provides some info about treatment of unrealized gains and losses on trading securities under the GAAP in the US

Dealing with a large QIF file

2017-12-24 Thread Cliff McDiarmid
Hi I'm importing a large QIF file(a current a/c)about 6000 entries. There are about a dozen other a/c's from Quicken, now closed, associated with this large file. When importing, Gnucash seems to want to create these defunct a/c's to 'balance the books'. I assume there isn't

Re: gnucash-user Digest, Vol 177, Issue 52

2017-12-24 Thread Fred Bone
On 24 December 2017 at 12:12, Colin Whyles said: > Ticotexas, > > Under Tools there is a tool for closing books. I would advise making a > copy of your accounts in case anything doesn’t balance properly. I’ve > been caught out due to my own incompetence. It isn’t easy to undo closed > books. On

Re: Receipt scanners, recommendations?

2017-12-24 Thread Lincoln A Baxter
Canon Canoscan 8800f works fine with xsane. When I was shopping for a scanner, I used the SANE list to find a compatible scanner: http://www.sane-project.org/sane-mfgs.html Lincoln On Thu, 2017-12-21 at 19:42 +, jeffrey black wrote: > I am using GnuCash (Windoze version) to track multiple

Re: gnucash-user Digest, Vol 177, Issue 52

2017-12-24 Thread Colin Whyles
Ticotexas, Under Tools there is a tool for closing books. I would advise making a copy of your accounts in case anything doesn’t balance properly. I’ve been caught out due to my own incompetence. It isn’t easy to undo closed books. — Colin Whyles > On 24 Dec 2017, at 10:40,

Sorting options for Credit Card account

2017-12-24 Thread John Rogers
I have a rather active credit card account (approximately 6 charges per day) that I'm trying to keep in sync with my bank. I enter the transactions as I see the receipts. I also mark the transaction in the Reconcile column from n to c when I see it has cleared my bank's website. I have the