Capital Gains posting in newly imported data from quicken

2018-02-14 Thread snrm
I have just imported last 8 years data from my quicken into gnucash successfully and seem to have gotten my Accounts hierarchy proper. I notice that most of my balances are tallying, but not the capital gains. How do I populate the LTCG and STCG's account heads for each year? Do I have to

Re: Capital Gains posting in newly imported data from quicken

2018-02-14 Thread David T. via gnucash-user
snrm, It has been a long time since I migrated from Quicken, but I know that my biggest headaches came from how Quicken did (or didn't) handle gains.  That said, gnucash includes a lot management tool that you can use to generate gains transactions. It is far from perfect, however. For example,

Re: 2.6.19: Accounts reconciled; trial balance has imbalance

2018-02-14 Thread Rich Shepard
On Tue, 13 Feb 2018, Adrien Monteleone wrote: If you’re using digest mode, I’d recommend turning it off. Adrian, I've never used digest mode for any mailing list. That makes it difficult to find a message of interest and to respond to it. I run my own MTA here (postfix) and have set

Re: Recording non-cash donations [RESOLVED]

2018-02-14 Thread Rich Shepard
On Tue, 13 Feb 2018, Adrien Monteleone wrote: That was quick, you answered your own question with a recommendation from an accountant in 3 minutes. (at least by my clock) Adrian, Well, it was actually longer than that when I came up with the solution (and implemented it), and a couple of

Re: Trading Accounts

2018-02-14 Thread Wm
On 12/02/2018 12:41, Les wrote: I have a "test" laptop with GC 2.6.17 running the latest Linux Mint.  I opened GC and tried using Trading Accounts, did check and repair, noted the totals of assets, liabilities, income and expense before and after. There was no difference.  I then ran a Income

Re: Trading Accounts

2018-02-14 Thread Les
Thanks, that is what my test file indicates.  I am adding Trading Accounts to my production GC file. Les On 02/13/2018 02:59 AM, Wm via gnucash-user wrote: On 12/02/2018 17:12, Les wrote: I use, in addition to USD. AUD, HKD, CAD, CNY and SGD.  I buy in tranches for average cost.  So, not

Re: Trading Accounts

2018-02-14 Thread Wm via gnucash-user
On 12/02/2018 17:12, Les wrote: I use, in addition to USD. AUD, HKD, CAD, CNY and SGD.  I buy in tranches for average cost.  So, not sure that means I have complicated trades but I make sure I never have any orphan accounts. I checked my test file for capital and it did not list any. Although,

Re: Trading Accounts

2018-02-14 Thread Wm
On 13/02/2018 02:27, David Carlson wrote: Be sure to compare what Gnucash generates to what your broker reports to the government. Gnucash has trouble calculating the net gain that the IRS wants to see. Many of us still use spreadsheet s to compare to the brokerage reports that are sent to the

Re: A predictive bar graph needed

2018-02-14 Thread Wm via gnucash-user
On 12/02/2018 19:11, Cliff McDiarmid wrote: Thanks Adrien I thought as much. That's a shame everything else is what I need. I don't know what a predictive bar graph is so, unsurprisingly, I'm not missing one. Hint: using terms you are familiar with and other people aren't usually

Re: Recording non-cash donations

2018-02-14 Thread Mike or Penny Novack
On 2/13/2018 10:56 AM, Rich Shepard wrote: Hi all, For tax purposes non-cash donations of goods and services are deductible. I would like to track those as an account (or off-setting accounts) in gnucash and do not find how best to do this in the guide or help docs. I'm open to

Re: 2.6.19: find source of imbalance in reconciled accounts

2018-02-14 Thread Mike or Penny Novack
On 2/13/2018 12:43 PM, Rich Shepard wrote: I'm puzzled how I can find the source of the imbalance at the bottom of the 2017 trial balance report when both the checking and saving accounts reconcile with the bank's records (as of today). The trial balance period is 1 Jan 2017 through 31 Dec

Re: 2.6.19: find source of imbalance in reconciled accounts [RESOLVED]

2018-02-14 Thread Rich Shepard
On Wed, 14 Feb 2018, Mike or Penny Novack wrote: But I'll try to help. Go to the Imbalance account. Mike, Aha! I had not noticed the Imbalance account in the CoA. This makes life much easier, especially since I found the major amount was mis-recorded for a credit card when I switched from

Re: Controlling Gnucash from 2 computers

2018-02-14 Thread Adrien Monteleone
Martijn, It is not a good idea to have two people editing the data file at the same time. At some point in the future, this will be possible, but it is not safe right now. Two people can use the software from two different machines (with the file access over a network) but only one should

Re: 2.6.19: Accounts reconciled; trial balance has imbalance

2018-02-14 Thread Rich Shepard
On Tue, 13 Feb 2018, John Ralls wrote: Try this: Set the Start of Adjusting/Closing on 1 Jan 2017 and the Date of Report on 30 June 2017. If it's in balance, change the report date to 30 September, otherwise to 31 March. If it's now (or still) in balance change it again to halfway between the

Re: single line register display

2018-02-14 Thread Derek Atkins
AH. Yes, the Notes field. You could add it, but you'd need to edit the source and rebuild GnuCash. The register structure is hard-coded. -derek Dennis West writes: > Maybe "memo" is the run term.  I meant "notes", the field appearing > below "description" in the two line

Re: gnucash-user Digest, Vol 179, Issue 32

2018-02-14 Thread Martijn
Hello, Can GNU Cash be controlled by 2 computers? I have an XP computer and a Windows 10 computer and it would be great if somehow I can make the XP computer see the Windows 10 computer GNU file. This way 2 people could create invoices at the same time, maybe? Sent from cell phone On Feb 9,

Re: Controlling Gnucash from 2 computers

2018-02-14 Thread Nelson Handcock
I have been using Gnucash by putting the file on a dropbox folder, and then using the dropbox app for Windows 10 on each of the computers to access and synch the dropbox folder and its contents. The LCK file that Gnucash creates is saved to the dropbox account, and so other users on other

How to export structure without transactions?

2018-02-14 Thread Fran_3 via gnucash-user
We have setup a gnucash file for 2018 and created all our customer and vendor accounts... plus customized the chart of accounts... and entered all the transactions to date. Now we want to do 2017. Is there a way to export the structure leaving the vendors, customers, and customized chart of

Re: How to export structure without transactions?

2018-02-14 Thread Derek Atkins
You can export the chart of accounts via File - > Export Accounts. But it will not include your customers, vendors, etc. It only saves your account tree. Note that there is no real need to start over. Gnucash is quite happy to just continue, and the reports handle multiple years in one data

Re: How to export structure without transactions?

2018-02-14 Thread Rich Shepard
On Wed, 14 Feb 2018, Fran_3 via gnucash-user wrote: We have setup a gnucash file for 2018 and created all our customer and vendor accounts... plus customized the chart of accounts... and entered all the transactions to date. Now we want to do 2017. Is there a way to export the structure

Re: Sharing GnuCash on Multiple Computers (was Re: gnucash-user Digest, Vol 179, Issue 32)

2018-02-14 Thread Martijn
Thanks so much! Sent from cell phone On Feb 14, 2018 12:27 PM, Derek Atkins wrote: > > Hi, > > Martijn writes: > > > Hello, > > > > Can GNU Cash be controlled by 2 computers? > > I have an XP computer and a Windows 10 computer and it would be great >

Creating Account for each Vendor to avoid Creating and Paying each Bill?

2018-02-14 Thread Fran_3 via gnucash-user
OK, as I understand it after we import checking transactions for a small business... For each Vendor Payment we must first create a Bill and then Pay that bill so that it remains associated with the vendor. That's a lot of clicking and typing. So would this work? In the chart of accounts under

Re: How to export structure without transactions?

2018-02-14 Thread Rich Shepard
On Wed, 14 Feb 2018, Fran_3 wrote: My concern was if we 'import' all the 2017 transactions it will mess up the balances... but I guess they will all just sit in checking assigned to no account. We just thought it would be cleaner to have a separate 2017 file...  I'm going to post another

Re: Creating Account for each Vendor to avoid Creating and Paying each Bill?

2018-02-14 Thread Rich Shepard
On Wed, 14 Feb 2018, Fran_3 via gnucash-user wrote: For each Vendor Payment we must first create a Bill and then Pay that bill so that it remains associated with the vendor. That's a lot of clicking and typing. Fran3, Er, ... no. Before you create any bill (duck or no duck) enter all

Re: How to export structure without transactions?

2018-02-14 Thread Adrien Monteleone
The import should assign them to whatever accounts you map. (the ‘other side’ of each being the account you are importing) If any do not, they’ll be assigned to the imbalance account so they’ll be easy to find and fix. The only issue with balances is that you’ll have to adjust your opening

Re: Creating Account for each Vendor to avoid Creating and Paying each Bill?

2018-02-14 Thread Adrien Monteleone
There should be no need to create expense sub-accounts for vendors if all you want is a way to see how much you spent with them. (or still owe them at any point) That would also get quite messy if a vendor might sell items that fit in more than one expense account. Create your vendors, create

Re: 2.6.19: Accounts reconciled; trial balance has imbalance

2018-02-14 Thread John Ralls
> On Feb 14, 2018, at 8:23 AM, Rich Shepard wrote: > > On Tue, 13 Feb 2018, John Ralls wrote: > >> Try this: Set the Start of Adjusting/Closing on 1 Jan 2017 and the Date of >> Report on 30 June 2017. If it's in balance, change the report date to 30 >> September,