Re: [GNC] View New Accounts page
Try clicking on the leftmost "Accounts" tab and then select "View > Refresh" from the menu bar. If that doesn't work, select "View > Filter by > Other" and put a check mark in the boxes for "show hidden accounts" and "show zero total accounts". On 4/14/2019 4:16 PM, wendiallen via gnucash-user wrote: Hi. I'm in the process of getting GnuCash setup, after importing my data from Quicken. I've created a new account, but it doesn't show up in the leftmost tab titled "Accounts." If I click on View | New Accounts Page, a second "Accounts" tab opens, which does show the new account. So now I have two tabs named "Accounts", and they are not showing the same information. The leftmost tab does not have a "X" to close it, yet it is now inaccurate. I'm confused. What am I doing wrong? Thank you. -- 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: incorrect starting balance in reconcile
You can use the Edit->Find menu item to search for entries by their reconcile status. It might help you find an accidentally-inserted transaction. On 3/22/2018 8:43 AM, Colin Law wrote: On 21 March 2018 at 19:22, darrylctx wrote: I am trying to reconcile a Bank account. Everything has been working fine since I opened the account, but recently I tried to reconcile a statement, and the starting balance of the reconcile is incorrect. At the end of every statement, I put in a trxn with 0 value and the correct ending balance in the description so that I can quickly check the ledger. The starting balance had always matched the correct balance for the account on the next reconcile. This time it did not. Almost certainly you have (presumably accidentally) modified or deleted a reconciled transaction or manually marked a transaction as reonciled. After reading through a lot of posts concerning incorrect starting balances, I decided to unreconcile all the trxns in the account and re-reconcile. After un-reconciling back the account open, when I try to reconcile the first trxn (amount = 0), the starting balance in the reconcile is not zero. There are no trxns before this one trxn I am trying to reconcile. As Dave suggested view the filter options to make sure you can see all the transactions. HOW CAN THIS BE? It appears that GNU Cash is keeping a reconciled balance in the file that is no longer correct. I can fix this with an entry to balance the starting balance and make a note that it is because of a bug in GNUCash, but this is very bad, as if anyone ever looks at the books, they will ask the legitimate question: Can I trust a program that requires adjusting entries because of bugs? It is almost always a mistake to start by assuming that a problem is caused by a bug, particularly something as dramatic as this that would be most unlikely to have gone unnoticed by the many thousands of people who use Gnucash and have not seen the problem. Very occasionally it will be a bug but more often the error lies between the chair and the hands. Once all txns in an account are unreconciled, it should be possible to reset the starting balance for the account to the correct starting balance. Based on all the related posts I've seen, this appears to be an ongoing problem. I cannot remember a single instance where an error of this sort was not caused by mistakes such as those I mention above. Possibly the best solution is go back through your routine backups till you find one the last one that does show the correct reconciled balance and start again from there, or work forwards from there to find what caused the error. Colin ___ 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 show the accounts in alphabetic sequence on the eguile
If you're talking about the Advanced Portfolio report, try this: Select Reports->Assets & Liabilities->Advanced Portfolio from the menu bar, after the report appears, select Options from the menu icons, in the window that pops up, select the 'Accounts' tab, click the 'Reset Defaults' button, and click the 'Apply' button, wait for the report to be re-generated. I've found that this seems to re-order the account names for an unknown reason. On 3/27/2018 2:46 AM, Anita Graves wrote: No codes. Sent from my iPhone On 26 Mar 2018, at 22:24, Derek Atkins wrote: Hi, Anita Graves writes: Dear Gnucash folks, [snip] But in the eguile report they are listed out of alphabetical order: earmarked International Fund earmarket National Fund debit card earmarked Temples Fund etc. Is there any way to fix this or sort these sub-accounts so that they would be alphabetical under the parents? Thanks very much. Otherwise I am quite satisfied with everything. Do these accounts have account codes associated with them? If so, are they displaying in account-code-numeric-order? Anita 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. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Handling Return of Capital in Reinvested dividends
Gnucash v2.6.17 on Windows 10 doesn't handle Return-of-Capital transactions on a lot-by-lot basis. I'm not sure about v3.0. The total basis can be reduced in a transaction but the gains/losses won't be calculated correctly. On 4/14/2018 1:14 PM, Alton Brantley wrote: I am trying to deal with Return of Capital events happening over a series of dates, therefore a series of lots. For whatever reason, I am not able to adjust individual lot amounts. Example: Tx 0:January 1,2017 $1000 DR Stock:XYZ Corp 100 sh @ $10/shr $1000 CR Cash And in ACTION->View Lots make this Lot 0 Tx 1: March 1,2017 $10 DR Cash Dividend for Reinvestment $10 CR Income:Dividend:XYZ Corp $10 DR Stock:XYZ Corp 1 sh@ $10/shr $10 CR Cash And in ACTION->View Lots make this Lot 1 Next 3 transactions identical to Tx 1 Tx 2: June 1,2017 (Lot 2) Tx 3: Sep 1,2017 (Lot 3) Tx 4: Dec 1,2017 (Lot 4) Now, I have 104 shares of XYZ purchased over 12 months at $10/shr ($1040) in 5 Lots. Then, in Jan 2018, my brokerage statement shows that $20 of the $40 Dividend was Return of Capital. I then enter the transaction Tx 5: Jan 31, 2018 $20 DR Income:Dividend:XYZ Corp $20 CR Return of Capital:XYZ Corp So my total investment in XYZ Corp is now $1020 in 5 lots (100,1,1,1,1) and my $20 gets allocated pro rata (100/104*$20, 1/104*$20, etc) or ($19.23, 0.19,0.19,0.19,0.20). The last amount is adjusted up a penny because of small fractions to add up to $20. (In real life, the share price varied each quarter so fractional shares were purchased). The problem happens in the lots mechanism. I now want to enter the following Transaction: Tx 6: $20 DR Return of Capital:XYZ Corp $19.23 CR Stock:XYZ Corp Memo:this is ROC for Lot 0 $ 00.19 CR Stock:XYZ Corp Memo:this is ROC for Lot 1 $ 00.19 CR … $ 00.19 CR … $ 00.20 CR … When I open ACTION->View Lots, none of the CREDIT splits show up for me to put into their appropriate lots. I don’t want to do a buy/sell of each lot, because I lose date tracking. It would be nice if the Lots would show all Tx splits for Stock:XYZ Corp, even the ones with 0 shares at 0 cost per share. It appears my only option is to hold the ROC CR transactions until I sell XYZ Corp, and then incorporate them into the capital gain/loss reconciliation. Any other suggestions? ___ 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.
[GNC] using Guile
How can I use Guile in an interactive window outside of Gnucash? I'm using Windoze 10 and Gnucash 2.6.17 I want refresh my scheme programming knowledge with small experimental code. John C ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Entering preexisting shares
Assuming you're transferring shares from one brokerage account to another, I found it best to enter the shares and their original purchase dates in the destination stock account and the cash used for the purchase comes from Equity: Opening Balances. This way maintains the lot purchase dates and doesn't seem to conflict with the brokerage account opening date. You could also enter a negative number of shares and the base price in one stock account and the same (but positive) number of shares and base price in the destination account. You won't have much luck trying to credit the stock account directly from Equity:Opening Balances, because the currencies are different, "shares" vs. "dollars". On 6/6/2018 1:57 PM, Graham Balin wrote: Hi. My first post as a gnu-bie, so please bear with me. Trying to enter preexisting shares as split transaction, with commission and tax. [Have searched google /archives without success] I enter the splits, [as per 9.5.1 of gnucash guide] add a balancing amount from 'equity:opening balances' and yet I get 'imbalance' and 'orphan-gbp' generated. Hope the image comes out ok. Any ideas or places to look, gratefully received -- Cheerio, Graham --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] File Format Documentation, v. 2
Please tell the reader the default file format right after installation. regards, John On 8/16/2018 5:06 PM, Adrien Monteleone wrote: Looks good to me. Regards, Adrien On Aug 16, 2018, at 3:00 PM, David T. via gnucash-user wrote: I’ve attempted to incorporate the suggestions that others have made for the section on file storage formats, and I attach the resulting version 2 for further consideration. Keep in mind that this is not meant to be an encyclopedic coverage of the topic; it’s meant to outline the choices. I expect further detail to reside on the wiki, or be placed in other places in the documentation. Cheers, David P.S. The table layout doesn’t come through, but will be in the final version… 2.5 Storing your financial data 2.5.1 Overview GnuCash offers several formats for storing your financial data. The default file storage format is XML, while SQL storage is available in SQLite, MySQL, and PostgreSQL formats. Users can choose a file format from the File→Save and File→Save As dialogs. The XML storage format is a text file that is compressed with gzip, which is a preference that is set at Edit→Preferences→General→Use file compression. SQL storage is available via the DBI back end; use of MySQL and PostgreSQL requires installation of those DBMS packages as well as additional DBI drivers. Note: users can change the format at any time by using File→Save As. This will create a copy of the data file in the selected format. Storage Comparison Each storage format has benefits and shortcomings that the user should consider for their needs and abilities. See the Storage Comparison Table below for further details. The XML format is the most stable and established, and for this reason, it is recommended for most users. SQL storage was added for the 2.4 release and has become an increasingly popular choice for users, but can require experience with DBMS applications. Note: Use of a SQL back end for storage implies to many that GnuCash has fully implemented DBMS features, including multi-user and incremental data manipulation. However, GnuCash does not currently implement these features, although it is a long term goal of the development team. Storage Comparison Table XML SQLite MySQL PostgreSQL Installation Default libdbi - 1 libdbi libdbi File extension gnucash gnucash N/A - 2 N/A - 2 Additional software None None MySQL PostgreSQL Additional expertise None None DBMS DBMS Compression Y N N N Save on command Y N N N Save on commit N Y Y Y Uses log files Y N N N Multi-user N N N N 1 - SQLite relies on libdbi, but is available by default on Mac OS and Windows. Linux users may need to manually install libdbi drivers for SQLite. 2 - MySQL and PostgreSQL place data in their own storage. ___ 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.
[GNC] Order of accounts, auto numbering transactions.
I have just started trying to set up my new GnuCash accts file. I have been using MYOB for 20+ years so I will need help occasionally when I can’t find an answer in the manual. First two questions below. How do I set up my accounts in an order that I prefer rather than alphabetical? How do I turn on auto numbering of transactions? Regards John C Simpson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
