Re: 2.6.19: Accounts reconciled; trial balance has imbalance
> 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?
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?
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?
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?
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?
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)
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?
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.
Re: How to export structure without transactions?
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?
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?
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
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 peer is no > >> longer an individual in most cases and almost all lending goes thro
single line register display
Sounds like too much work. Thanks for your response. Dennis On 2/14/2018 11:24, Derek Atkins wrote: 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. ___ 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.
Sharing GnuCash on Multiple Computers (was Re: gnucash-user Digest, Vol 179, Issue 32)
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.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: single line register display
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
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 somehow it isn't >> being "seen" by gnc for what it is. >> >> Anyway, it has been u
Re: 2.6.19: find source of imbalance in reconciled accounts [RESOLVED]
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
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
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
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]
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&L 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
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
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 > > to time that is easy. > > > > Just use the security editor and invent a name and symbol, possibly under > > th
Re: Capital Gains posting in newly imported data from quicken
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
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
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
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
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
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
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.