Re: 2.6.19: Accounts reconciled; trial balance has imbalance

[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, otherwise to 31 March. If it's now (or still) in balance change
>> it again to halfway between the current date and the out-of-balance date.
>> Keep doing that until you find the first date where it's out of balance,
>> then use the General Ledger to look at all of the transactions on that
>> date. One of them is off. Fix it and repeat the process until it's in
>> balance for the year.
> 
> John,
> 
>  This is how we used to find bugs in programs before debuggers were
> available, but I didn't think of applying it to the bookkeeping application.
> 
>  Found some, perhaps a half-dozen, and fixed those. All is split
> transactions, as David Carlson suggested.
> 
>  What's strange is that now all split transactions have their imbalances
> removed, the total imbalance is greater than before. :-(
> 
>  There are no stock, bond, or foreign currency transations, all US$ in
> checks or cash. If you have further ideas where these discrepancies might be
> hiding please let me know and I'll check them. Otherwise, each non-split
> transaction is balanced between the asset account (checking or cash) and an
> expense or liability account.
 
Rich,

Is the trial balance report in balance on 1 Jan 2017?

Regards,
John Ralls

___
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: Creating Account for each Vendor to avoid Creating and Paying each Bill?

[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 and post your bills, then pay the bills using the 
Process Payment feature.

You can then run a Vendor Report for each vendor for any date range and see 
total spent and paid to each with full transaction history and clickable links 
to either the transaction itself or the particular bill.

You can also run Payable Aging report to show you any amounts in arrears with 
links to find the particular bills.

Since you have lots of historical data you want to import, and it seems you’ll 
be importing the vendor payments as part of your checking account import, I’d 
suggest the following workflow:

Create a CSV file with all of your bill data. (you’ll need to create or import 
your vendors first)
Import this CSV to bring your bills in properly.
Do a Find on a few bills and run a Vendor Report or two to make sure everything 
imported okay.
Once your checking account transactions are imported (if not already there) 
you’ll need to click each payment to a vendor and use the ‘assign as payment’ 
option. This will then give you the ‘process payment’ window where you can 
search for a vendor, see all of their unpaid bills, then assign the transaction 
as a payment. (be mindful the dates, amounts, and check# are correct and that 
it is taking the payment from the proper account)

Now, everything is imported and properly assigned just as if you had entered it 
in real time originally from scratch.

As an added tip, when assigning payment to a transaction, I’d recommend tagging 
that transaction with the bill number from the Vendor. (or something to ID the 
payment for if the vendor doesn’t use invoice #s) Gnucash doesn’t make it easy 
by default to see what bills a payment applies to. (possible, just not easy) 
You’ll probably want to know that info from time to time when looking at a 
register. You have two main options here. Either turn on View > Double-line 
mode and use the Notes line for this info, or place it in the Memo of the split 
for either the checking account credit or the AP debit, whichever makes the 
most sense to you. (putting it in notes, also puts it in the memo for the AP 
debit split) Now, when you run a vendor report, you’ll see that bill# note in 
the Description column for easy reference.

Here’s a link to documentation on the CSV for importing bills/invoices: 
https://lists.gnucash.org/docs/C/gnucash-guide/import-invoices.html

Here’s the link for customers/vendors (note the caveat about billing info): 
https://lists.gnucash.org/docs/C/gnucash-guide/import-customers-vendors.html

If you’re coming from some other software, you might even be able to get that 
data exported as a CSV and then do some minor surgery on the column order for 
Gnucash to be happy rather than typing it all from scratch.


Regards,
Adrien

> On Feb 14, 2018, at 5:59 PM, Fran_3 via gnucash-user 
>  wrote:
> 
> 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 say... Expenses > Office Supplies
> we create sub accounts for each Office supply vendor...
> Than from the check register just assign that payment to that account...
> Now we are tracking total office supply expenses and how much we spent with 
> each vendor.
> We are considering this for 2017 transactions as we are under a very short 
> deadline to come up with some numbers and every step we save helps.
> What do you think?
> Thanks,
> Fran3
> ___
> 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: How to export structure without transactions?

[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 balance 
entry for that particular account. So if you started with 2018 with an opening 
balance there and then started entering or importing prior transactions, you’ll 
need the real opening balance from 2017 to have everything still be the correct 
balance as of today.

While some may cringe at the suggestion, it’s quite easy to simply change the 
date on your opening balance entry to 1/1/17 and correct it. The other route 
would be to make a new opening balance entry as of that date, but this will 
look odd since it’s back-dated, and then you’ll need a correcting entry as of 
12/31/17 to keep the 1/1/18 entry from doubling your balance. There are times 
when I see the point of correcting entries. This is not one of them, you’re 
re-building your books in a different format. The entries really shouldn’t be 
corrected, just translated. It’s okay to directly edit errors produced by 
either the import process or by choice of order of import.


Regards,
Adrien

> On Feb 14, 2018, at 5:54 PM, Fran_3 via gnucash-user 
>  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 question sorta relative to this so stand by.
> Thanks,
> Fran3
> 
>On Wednesday, February 14, 2018, 6:48:54 PM EST, Rich Shepard 
>  wrote:  
> 
> 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 leaving the vendors, customers, and
>> customized chart of accounts in place so we can begin populating for 2017.
>> Thanks for any help.
> 
> Fran3,
> 
>   Were I you, I'd just start entering your 2017 data (in any order) and
> GnuCash will place it appropriately by date. That's what I did when I
> switched both business and personal books to gnucash in 2017, I entered all
> the 2016 data when I had the time.
> 
>   There's no particular advantage to keeping separate books when you have
> sufficient disk space available and can specify date ranges for all reports.
> 
> Happy bookkeeping,
> 
> Rich
> ___
> 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.

___
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: Creating Account for each Vendor to avoid Creating and Paying each Bill?

[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 your vendor data:
name, address, whatever. Do this for all your vendors. Also do it for any
customer/client who you bill for revenue.

  Once you have those set up you can enter a new bill or invoice, post them,
then pay the bill. Equivalent work flow for customers/clients. Look at the
Business -> Customer and -> Vendor menus.


In the chart of accounts under say... Expenses > Office Supplies
we create sub accounts for each Office supply vendor...


  Since you want to track each vendor, then yes. E.g., under Expenses:Office
Supplies:Staples or Expenses:Office Supplies:Office Depot. You'd do the same
thing for insurnace; e.g., Insurance:Employee Health, Insurance:Auto, etc.

  Under Business -> Vendor -> New Vendor enter all your office suppliers.

  When you receive a bill from each, enter it via Business -> Vendor -> new
bill. Then post it. It goes to Accounts Payable.

  When you want to pay the bill go to Business -> Vendor -> Process payment.


Than from the check register just assign that payment to that account...


  When you pay the bill

  Also, download and use the gnucash-help and gnucash-guide docs.

Regards,

Rich
___
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: How to export structure without transactions?

[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 question sorta relative to this so
stand by.


Fran3,

  I don't import, I enter. If you enter 2017 transactions correctly (with
offsetting accounts) your checking account balance will change until all the
2017 debits and credits are entered. Then it will be correct.

Regards,

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

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

[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 say... Expenses > Office Supplies
we create sub accounts for each Office supply vendor...
Than from the check register just assign that payment to that account...
Now we are tracking total office supply expenses and how much we spent with 
each vendor.
We are considering this for 2017 transactions as we are under a very short 
deadline to come up with some numbers and every step we save helps.
What do you think?
Thanks,
Fran3
___
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: Sharing GnuCash on Multiple Computers (was Re: gnucash-user Digest, Vol 179, Issue 32)

[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
> > 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?
>
> GnuCash is not a multi-user program, so you cannot have two people
> editing the same data file simultaneously.  Having said that, you COULD
> use a file sharing system to allow both computers to see the same data
> file, but you would need to ensure that only one user has the file open
> at a time.
>
> > Sent from cell phone
>
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> -derek
> -- 
>    Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>    Member, MIT Student Information Processing Board  (SIPB)
>    URL: http://web.mit.edu/warlord/    PP-ASEL-IA N1NWH
>    warl...@mit.edu    PGP key available
___
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: How to export structure without transactions?

[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 leaving the vendors, customers, and
customized chart of accounts in place so we can begin populating for 2017.
Thanks for any help.


Fran3,

  Were I you, I'd just start entering your 2017 data (in any order) and
GnuCash will place it appropriately by date. That's what I did when I
switched both business and personal books to gnucash in 2017, I entered all
the 2016 data when I had the time.

  There's no particular advantage to keeping separate books when you have
sufficient disk space available and can specify date ranges for all reports.

Happy bookkeeping,

Rich
___
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: How to export structure without transactions?

[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 file.


-derek
Sent using my mobile device. Please excuse any typos.



On February 14, 2018 6:31:47 PM 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 leaving the vendors, customers, and 
customized chart of accounts in place so we can begin populating for 2017.

Thanks for any help.
Fran3


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

How to export structure without transactions?

[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 accounts in place so we can begin populating for 2017.
Thanks for any help.
Fran3

  
___
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: Controlling Gnucash from 2 computers

[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
computers will be alerted.

Most of the time it works fine. I sometime keep a local copy of the file
just in case.

You do need to be a bit patient each time you want to use it by making sure
the dropbox app has completely synched the account before you start
editing. I usually make sure the other user is aware of the date/time last
saved of the main file - that way they can see if they are opening the most
recent one on their computer.

There have been a couple of times things have gotten out of synch - I put
it down to user error - loss of network connectivity, etc - causing the
dropbox account to be out of synch with the local instance. Fortunately
I've been able to re-build from one of the older stable archive versions
without too much drama.

Hope this helps...


Thanks & Regards,

Nelson Handcock
0409 149919

http://www.linkedin.com/in/nelsonhandcockaustralia

On Thu, Feb 15, 2018 at 3:22 AM, Adrien Monteleone <
adrien.montele...@gmail.com> wrote:

> 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 have the file open at a time.
>
> Also, please be sure to not click ‘reply’ when you want to start a new
> topic and be sure to create a meaningful subject line so your discussion
> will thread properly.
>
>
> Regards,
> Adrien
>
> > On Feb 9, 2018, at 4:38 PM, Martijn  wrote:
> >
> > 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, 2018 12:00 PM, gnucash-user-requ...@gnucash.org wrote:
> >>
> >> Send gnucash-user mailing list submissions to
> >> gnucash-user@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-requ...@gnucash.org
> >>
> >> You can reach the person managing the list at
> >> gnucash-user-ow...@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: p2x modelling in gnc, help me think, please (Wm)
> >>2. Re: How to Manually Track a Collection of Stocks & Stuff
> >>   Combined into a Single Share (Wm)
> >>3. Latest version for Windows? (cicko)
> >>4. Re: Price Retrieval Failure, Part 2 (John Ralls)
> >>5. Re: Latest version for Windows? (John Ralls)
> >>
> >>
> >> --
> >>
> >> Message: 1
> >> Date: Thu, 8 Feb 2018 20:50:40 +
> >> From: Wm 
> >> To: gnucash-u...@lists.gnucash.org
> >> Subject: Re: p2x modelling in gnc, help me think, please
> >> Message-ID: 
> >> Content-Type: text/plain; charset=utf-8; format=flowed
> >>
> >> On 07/02/2018 18:17, Adrien Monteleone wrote:
> >>
> >>> Go to Preferences > General > Numbers. You can increase your decimal
> precision. Did that solve the small fraction issue?
> >>
> >> That isn't a good way to go if your base currency is a 2 decimal one.
> >> Creating a commodity with the appropriate number of decimals and using
> >> that is better.
> >>
> >> By chance there is another more recent but simpler thread
> >>
> >> ===
> >> Subject: How to Manually Track a Collection of Stocks & Stuff Combined
> >> into a Single Share
> >> ===
> >>
> >> it is the same basic problem.  "put the other leg in equity" doesn't
> >> work for me and the variance is actually the value not the price which
> >> is what makes them different to traded investments which gnc deals with
> >> well as you can just put the the date and price in for market traded
> things.
> >>
> >>> As for modeling the investment, I?m not familiar with p2x. I?ll let
> someone else chime in who is.
> >>>
> >>> On that note, I tried looking it up but didn?t come up with anything
> useful explaining it. Do you have a few info links I could pour over? Once
> I understand what it is, I might be able to help modeling it in Gnucash.
> >>>
> >>> The only related thing I found was Peer-to-Peer lending but that
> didn?t involve negative interest rates as far as I could tell.
> >>
> >> peer to peer is now p2x in common terms because the second 

Re: single line register display

[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 register display. (no splits).
>
> Dennis
>
>
> On 2/12/2018 13:33, Derek Atkins wrote:
>> The memo of which split?  There are (at least) two.
>>
>> -derek
>>
>> On Mon, February 12, 2018 2:30 pm, Dennis West wrote:
>>> I wonder how difficult it would be to modify (or add an additional
>>> option) to the register display.  I much prefer the single line display
>>> because of the larger number of transactions it displays.  I do really
>>> miss the "memo" field however.  On a wide display, the "description"
>>> field is expanded way beyond the length of what is needed.  Since wide
>>> screen displays are in such wide use, would it be possible to add the
>>> memo field to the single line display?
>>>
>>> Thanks - Dennis
>>>
>>> ___
>>> 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.
>>
>
>
>

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
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: Controlling Gnucash from 2 computers

[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 have the file open at a time.

Also, please be sure to not click ‘reply’ when you want to start a new topic 
and be sure to create a meaningful subject line so your discussion will thread 
properly.


Regards,
Adrien

> On Feb 9, 2018, at 4:38 PM, Martijn  wrote:
> 
> 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, 2018 12:00 PM, gnucash-user-requ...@gnucash.org wrote:
>> 
>> Send gnucash-user mailing list submissions to
>> gnucash-user@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-requ...@gnucash.org
>> 
>> You can reach the person managing the list at
>> gnucash-user-ow...@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: p2x modelling in gnc, help me think, please (Wm)
>>2. Re: How to Manually Track a Collection of Stocks & Stuff
>>   Combined into a Single Share (Wm)
>>3. Latest version for Windows? (cicko)
>>4. Re: Price Retrieval Failure, Part 2 (John Ralls)
>>5. Re: Latest version for Windows? (John Ralls)
>> 
>> 
>> --
>> 
>> Message: 1
>> Date: Thu, 8 Feb 2018 20:50:40 +
>> From: Wm 
>> To: gnucash-u...@lists.gnucash.org
>> Subject: Re: p2x modelling in gnc, help me think, please
>> Message-ID: 
>> Content-Type: text/plain; charset=utf-8; format=flowed
>> 
>> On 07/02/2018 18:17, Adrien Monteleone wrote:
>> 
>>> Go to Preferences > General > Numbers. You can increase your decimal 
>>> precision. Did that solve the small fraction issue?
>> 
>> That isn't a good way to go if your base currency is a 2 decimal one. 
>> Creating a commodity with the appropriate number of decimals and using 
>> that is better.
>> 
>> By chance there is another more recent but simpler thread
>> 
>> ===
>> Subject: How to Manually Track a Collection of Stocks & Stuff Combined 
>> into a Single Share
>> ===
>> 
>> it is the same basic problem.  "put the other leg in equity" doesn't 
>> work for me and the variance is actually the value not the price which 
>> is what makes them different to traded investments which gnc deals with 
>> well as you can just put the the date and price in for market traded things.
>> 
>>> As for modeling the investment, I?m not familiar with p2x. I?ll let someone 
>>> else chime in who is.
>>> 
>>> On that note, I tried looking it up but didn?t come up with anything useful 
>>> explaining it. Do you have a few info links I could pour over? Once I 
>>> understand what it is, I might be able to help modeling it in Gnucash.
>>> 
>>> The only related thing I found was Peer-to-Peer lending but that didn?t 
>>> involve negative interest rates as far as I could tell.
>> 
>> peer to peer is now p2x in common terms because the second peer is no 
>> longer an individual in most cases and almost all lending goes through 
>> an intermediary.  very few actual p2p transactions happen.
>> 
>> the lending can now involve: personal loans (how it started), mortgages, 
>> agriculture loans, 3rd world specific investments, invoice factoring, 
>> business loans, pawnbroking, etc and possibly some other stuff you and I 
>> probably don't want to know about or get involved in :)  I stick to 
>> reliable exchanges.
>> 
>> Perhaps I should have left out the word "interest" if it is confusing. 
>> A non zero return occurs if you buy an interest bearing instrument at 
>> anything other than par.  You are buying someone else's interest (a 
>> premium) or getting some of their interest because they don't want the 
>> risk of the principle (a discount).  There are loads of other reasons 
>> for buying and selling, of course.
>> 
>> The point is interest and other returns are *traded* and I'm not finding 
>> it obvious how to do this in gnc as part of a composite tx.
>> 
>> gnc likes simple investment returns
>> 
>> one leg asset receiving
>> one leg income to balance
>> third leg asset to join them up
>> 
>> or similar.
>> 
>> Maybe I should change the way I work so that I produce 3 tx per month
>> 
>> asset change
>> income
>> and the one gnc wants
>> 
>> I'm certain my tx is right in accounting terms but 

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

[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 my former bookkeeping software to
gnucash.

  Thanks for pointing out the obvious.

Regards,

Rich
___
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: 2.6.19: Accounts reconciled; trial balance has imbalance

[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 current date and the out-of-balance date.
Keep doing that until you find the first date where it's out of balance,
then use the General Ledger to look at all of the transactions on that
date. One of them is off. Fix it and repeat the process until it's in
balance for the year.


John,

  This is how we used to find bugs in programs before debuggers were
available, but I didn't think of applying it to the bookkeeping application.

  Found some, perhaps a half-dozen, and fixed those. All is split
transactions, as David Carlson suggested.

  What's strange is that now all split transactions have their imbalances
removed, the total imbalance is greater than before. :-(

  There are no stock, bond, or foreign currency transations, all US$ in
checks or cash. If you have further ideas where these discrepancies might be
hiding please let me know and I'll check them. Otherwise, each non-split
transaction is balanced between the asset account (checking or cash) and an
expense or liability account.

Regards,

Rich
___
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: 2.6.19: find source of imbalance in reconciled accounts

[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 2017.

  Please provide a clue stick where I should start looking.

Regards,

Rich 
 What I don't understand is why you think the checking and savings 
accounts agreeing with the bank's records should have anything to do 
with it. Maybe consider going back over the "basics of double entry 
bookkeeping".


But I'll try to help. Go to the Imbalance account. For each transaction 
there, go to* the other account which is almost certainly the account 
from which you entered the transaction. From that view of things you 
should notice that you failed to specify the account that was the other 
side of this transaction. That every transaction in double entry 
bookkeeping has AT LEAST two accounts associated with it is basic.


I wish as easy as I made this sound. Back when you originally entered 
the transaction you probably knew what it was about. You might now be 
faced with the question "what was that check #1234 written back on June 
7th, 2017 for? I can see it was in the XYZ store, but they sell all 
sorts of things". You MAY end up having to create another expense 
account for "unknown".


Michael D Novack

*  You can see from the transaction in Imbalance a date and the name of 
the other account

___
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: Recording non-cash donations

[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 suggestions on how to track these transactions.

Regards,

Rich 

Clarify your question for us.

Are you asking "can I use gnucash to track this?" (yes) or "can I easily 
do this WITHIN my main gnucash books? (maybe not, and probably not 
simply, easily, etc.(


Remember, for reporting purposes, you still will be reporting these 
donations in terms of dollars. You will want to have some way of 
noting/marking which require the additional substantiating paperwork.


Since I do NOT use guncash for personal accounting (no personal "regular 
books") but do normally itemize and so need to track donations I do have 
a "virtual" Donations set of books. In my case, I also want to get a 
report that shows me not only total donations but which organizations on 
our "get an annual donation" have received theirs, for this I use a 
"funny" set of books that has ONLY accounts of type "income" and 
"expense". The income side has "by check", "by cash", and "in kind" and 
the expense side a tree of receiving entities. We wan to track 
non-deductible donations too, so those two categories are the main 
parents, deductible further broken into types of organizations, 
non-deductible into simple non 501(c) 3 ("informal entities", "beggars", 
"unknown status") and "PAC".


The only report I need to run against this is an "Income Statement"

As it happens, we make only trivial "in kind" donations", but if we were 
doing some substantial ones (that needed individual documentation) I 
would have split the "in kind" on the income side between those that did 
and those that didn't. Since these NOT by check, could always use the 
number field to mark when the documentation was in hand.


Michael D Novack

PS: I use guncash for other sorts of "virtual" entities. For example, 
one that treats our solar system AS IF it were an entity that had income 
and expenses, was operating on borrowed money on which it was paying 
interest as well as paying the loan back, and which later, perhaps, will 
be paying dividends after the loan is paid off. Additional expenses are 
things like its share of our property insurance, estimated affect on our 
taxes, etc. Income items are things like tax credits, credits to our 
electric bill, sale of SRECs (being taxable, would be an example of part 
of that going for an expense).


 MOST examples you see for solar systems discuss "payback" as if 
money were free of interest and/or there were no effects on other 
expenses. I wanted one which was realistic about a normal rate on a 20 
year fixed mortgage,other expenses, etc. I chose 4%, which at the time 
was GOOD for 20 year fixed, taxable interest, loan and this would 
actually be an internal (non-taxable) loan so really equivalent to AAA 
and ~5%


But looking at that set of books, not obvious "virtual" as 
otherwise appear more or less normal. Just that there ISN'T such an entity.

___
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: Recording non-cash donations [RESOLVED]

[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 hours later met with my accountant.
The instant solution on the mail list was due to the question being delayed
in appearance on the list and my resolution appearing quickly. :-)


I'm curious for a clarification.


  Sure.


Does your accountant mean to expense the non-cash goods and services
provided at once? Or to hold these as deferred and expense them as used?
Or even to accept them as ‘revenue’ and later deduct them against matching
expenses?

Just curious. Overall, I think I see where she's going, I just want to
understand the advice better.


  Good questions. My business has always been run on a cash basis, not
accrual. When I take a load to Goodwill, or a bunch of books to the library
for resale I now enter the values on the receipts in GnuCash.

  Where I am non-cash donations (goods and services, such as travel and
service time for pro bono assistance to a non-profit group) are deductible
from federal and state income taxes.

  Donating things and time so others can benefit from them can be considered
altruistic and represent good will for individuals and businesses. Last year
I changed my company's structure from Inc to LLC so the distiction between
personal and business is closer with the latter structure.

  To record these non-cash donations requires an expense account, and that
needs to be offset by an asset account. By using these new accounts when I
send her the annual P and balance sheet, along with PDF copies of each
month's bank statements for both business and personal accounts she has all
the information needed to prepare my tax returns. She's moving to do as much
paperless work as possible and it's easier for me to send PDF attachments to
an e-mail than drive two thick wads of paper to her office.

  Does this clarify things for you?

Regards,

Rich
___
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: 2.6.19: Accounts reconciled; trial balance has imbalance

[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 message size limit high
enough to get all attachments from clients and those on mail lists. My MUA
is alpine (text-based for reading/writing text) so all mail is local, not on
the 'Net where it's available to anyone and everyone.

  Monday and yesterday were extreme outliers. Message delays ranged from
8-14 hours, then they started to appear in a few minutes, the normal
behavior. I mentioned the delays to explain why my posts were duplicated or
seemed out of sequence.

Regards,

Rich
___
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: gnucash-user Digest, Vol 179, Issue 32

[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, 2018 12:00 PM, gnucash-user-requ...@gnucash.org wrote:
>
> Send gnucash-user mailing list submissions to
> gnucash-user@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-requ...@gnucash.org
>
> You can reach the person managing the list at
> gnucash-user-ow...@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: p2x modelling in gnc, help me think, please (Wm)
>    2. Re: How to Manually Track a Collection of Stocks & Stuff
>   Combined into a Single Share (Wm)
>    3. Latest version for Windows? (cicko)
>    4. Re: Price Retrieval Failure, Part 2 (John Ralls)
>    5. Re: Latest version for Windows? (John Ralls)
>
>
> --
>
> Message: 1
> Date: Thu, 8 Feb 2018 20:50:40 +
> From: Wm 
> To: gnucash-u...@lists.gnucash.org
> Subject: Re: p2x modelling in gnc, help me think, please
> Message-ID: 
> Content-Type: text/plain; charset=utf-8; format=flowed
>
> On 07/02/2018 18:17, Adrien Monteleone wrote:
>
> > Go to Preferences > General > Numbers. You can increase your decimal 
> > precision. Did that solve the small fraction issue?
>
> That isn't a good way to go if your base currency is a 2 decimal one. 
> Creating a commodity with the appropriate number of decimals and using 
> that is better.
>
> By chance there is another more recent but simpler thread
>
> ===
> Subject: How to Manually Track a Collection of Stocks & Stuff Combined 
> into a Single Share
> ===
>
> it is the same basic problem.  "put the other leg in equity" doesn't 
> work for me and the variance is actually the value not the price which 
> is what makes them different to traded investments which gnc deals with 
> well as you can just put the the date and price in for market traded things.
>
> > As for modeling the investment, I?m not familiar with p2x. I?ll let someone 
> > else chime in who is.
> > 
> > On that note, I tried looking it up but didn?t come up with anything useful 
> > explaining it. Do you have a few info links I could pour over? Once I 
> > understand what it is, I might be able to help modeling it in Gnucash.
> > 
> > The only related thing I found was Peer-to-Peer lending but that didn?t 
> > involve negative interest rates as far as I could tell.
>
> peer to peer is now p2x in common terms because the second peer is no 
> longer an individual in most cases and almost all lending goes through 
> an intermediary.  very few actual p2p transactions happen.
>
> the lending can now involve: personal loans (how it started), mortgages, 
> agriculture loans, 3rd world specific investments, invoice factoring, 
> business loans, pawnbroking, etc and possibly some other stuff you and I 
> probably don't want to know about or get involved in :)  I stick to 
> reliable exchanges.
>
> Perhaps I should have left out the word "interest" if it is confusing. 
> A non zero return occurs if you buy an interest bearing instrument at 
> anything other than par.  You are buying someone else's interest (a 
> premium) or getting some of their interest because they don't want the 
> risk of the principle (a discount).  There are loads of other reasons 
> for buying and selling, of course.
>
> The point is interest and other returns are *traded* and I'm not finding 
> it obvious how to do this in gnc as part of a composite tx.
>
> gnc likes simple investment returns
>
> one leg asset receiving
> one leg income to balance
> third leg asset to join them up
>
> or similar.
>
> Maybe I should change the way I work so that I produce 3 tx per month
>
> asset change
> income
> and the one gnc wants
>
> I'm certain my tx is right in accounting terms but somehow it isn't 
> being  "seen" by gnc for what it is.
>
> Anyway, it has been useful to me to explain so no harm done.  Who knows 
> I may wake up with the answer tomorrow, I am certainly closer in my own 
> mind.
>
> -- 
> Wm
>
>
>
> --
>
> Message: 2
> Date: Thu, 8 Feb 2018 21:17:49 +
> From: Wm 
> To: gnucash-u...@lists.gnucash.org
> Subject: Re: How to Manually Track a Collection of Stocks & Stuff
> Combined into a Single Share
> Message-ID: 
> Content-Type: text/plain; charset=utf-8; format=flowed
>
> On 08/02/2018 14:28, David Carlson wrote:
> > If you want to create a fictional stock and manually enter prices from time
> 

Re: Capital Gains posting in newly imported data from quicken

[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, when you scrub an account, it will create lot-based gains 
transactions, but these all link to IMBALANCE accounts, requiring you to modify 
them  (although I guess you could create them and then mass move them by 
deleting the imbalance account. ...).
Additionally, the results don't always match what gets reported to taxing 
authorities, due to differences in handling fees and commissions. 
If it were me, I'd use the lots, but double check the results closely. 
David

 
 
  On Wed, Feb 14, 2018 at 14:35, snrm wrote:   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 individually post the gains by selecting Lots for each and every
scrip, from day one, by comparing the lot selections with my quicken data? 
It seems very tedious and time consuming to do so.  Is there some faster but
foolproof way of doing this?

Thx and Regards

snrm



--
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: Trading Accounts

[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 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, 
at the bottom of my accounts list, there is a list of currencies and 
exchanges with totals for each. But, again, there isn't any 
difference in income and expenses.


Trading Accounts may well help you given the mix of currencies.



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

Capital Gains posting in newly imported data from quicken

[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 individually post the gains by selecting Lots for each and every
scrip, from day one, by comparing the lot selections with my quicken data? 
It seems very tedious and time consuming to do so.  Is there some faster but
foolproof way of doing this?

Thx and Regards

snrm



--
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: A predictive bar graph needed

[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 
leads to  misunderstanding.


cf
Would you like to vote for Donald Trump
and
Would you like to leave the EU

--
Wm

___
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: Trading Accounts

[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 IRS.


The joy being that gnc doesn't take a view :)

P.S. I sometimes forget I have to get through Liz first so you'll be 
reading this next week.


--
Wm

___
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: Trading Accounts

[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, at the bottom 
of my accounts list, there is a list of currencies and exchanges with 
totals for each. But, again, there isn't any difference in income and 
expenses.


Trading Accounts may well help you given the mix of currencies.

--
Wm

___
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: Trading Accounts

[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 and Expense report for 
year 2016 (which is the same as my production GC and compared the two. 
Again there was no difference in totals between the two GC files.


So, exactly what does Trading Accounts actually do? I noticed that when 
viewing a stock transaction using auto-split view, there are added lines 
showing trading: currencies and trading: exchange and stock symbol, that 
does not appear without trading accounts.


Don't use Trading Accounts unless you know what they are in gnc terms.

Follow the links ChristopherL has given first, you probably need to 
understand Selinger first, promise.


--
Wm


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