Re: [GNC] Merger
Thanks John, That makes very good sense. I really appreciate you assistance. Les On 7/30/19 4:05 PM, John Ralls wrote: On Jul 30, 2019, at 12:03 PM, Les wrote: Hi John, thanks for the reply. I guess I omitted the fact that the existing stock had a different name (symbol) that the new stock. So is this more of a transfer? Thanks, On 7/30/19 1:41 PM, John Ralls wrote: On Jul 30, 2019, at 11:05 AM, Les wrote: Hi all: I had a merger transaction on one of my Canadian stocks where my existing holding was acquired on a 33 for 20 basis (new for old). From 500 of the existing shares for 825 shares of the new. I also had a net gain in cash of C$16.75. I am uncertain on how to handle this transaction in GC. I would greatly appreciate any suggestions. Actions>Stock Split Add 325 shares and book a "cash in lieu" for the C$16.75. Les, What I do in that case is modify the transaction after running the Stock Split Assistant to credit the old stock account 500 shares and change the 325 debit to 825 in the new stock account. You could of course create the same transaction manually: Old Stock -500 New Stock 825 Cash Account 16.75 Cap Gains Income 16.75 Start it in the Old Stock account and be sure that the price column is blank in all 4 splits. Note that this treatment depends on the merger not being taxable to the shareholders. That's true in nearly all cases, but a prominent one in the works now that isn't is United Technology's merger with Raytheon. If it's a taxable merger you need to record a regular sell of the 500 shares of "old stock" and a buy of the 800 shares of "new stock". The C$16.75 gets tacked on to the sell transaction. You should have gotten a letter from the company indicating the price to use for each transaction. If you didn't you can use the closing price of each on the last trading day before the merger consummated. (Note that I'm not a licensed accountant, financial advisor, or tax advisor and that you should consult with licensed professionals to be sure that what I've suggested complies with tax law in your jurisdiction.) 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: [GNC] Fwd: how to copy "Customers Overview" table for spreadsheet.
I'm a few pages into a book about xslt so I thought I'd give this a go. I'm sure it's not the best xslt and anyone who knows how to use xslt properly will probably feel unwell after looking at this, but it does seem to work, i.e. produce a summary html table with the customers overview info (and a few extra fields for extra points). To use it gunzip your gnucash file or save it in uncompressed format (Edit -> Preferences -> General) then you can run it using xsltproc like this (assuming the name of your file is accounts.gnucash): xsltproc customers.xslt accounts.gnucash > customers.html (there's a version for windows called xsltproc.exe if you are using windows and there are other ways of running xslt stylesheets) Then you can view customers.html and copy and paste the info into a spreadsheet or whatever. David On Tue, 30 Jul 2019 at 17:52, Geert Janssens wrote: > Op maandag 8 juli 2019 21:46:23 CEST schreef Adrien Monteleone: > > David, > > > > The OP was asking about the Customer Overview, not Customer Summary > Report. > > > > The Customer Summary Report doesn’t show the same info as the Customer > > Overview. Notably, customer ID, address, and phone#. The overview is > > essentially a table of *some* of the data for each customer like what > might > > be found if there were a way to export customers. (the same problem > exists > > for vendors) > > > Hmm, I made the same mixup. Please ignore my reply (still catching up on a > backlog of several weeks...). > > Regards, > > Geert > > > GnuCash can import this data, but can’t export it. > > > > Regards, > > Adrien > > > > > From: > > > Date: Mon, Jul 8, 2019, 11:07 > > > > > > > > > > > > Have you tried highlighting the report contents and pasting into a > > > spreadsheet? In Windows, I can run the Customer Summary report, press > > > CTRL-A, CTRL-C , open a spreadsheet, and press CTRL-V. The results are > > > reasonably sane. I haven't tried on a Mac recently, but ISTR that it > > > worked > > > in a similar fashion there. > > > > ___ > > 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. > -- David Whiting customers.xslt Description: application/xslt ___ 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] Merger
> On Jul 30, 2019, at 12:03 PM, Les wrote: > > Hi John, thanks for the reply. I guess I omitted the fact that the existing > stock had a different name (symbol) that the new stock. So is this more of a > transfer? > > Thanks, > > On 7/30/19 1:41 PM, John Ralls wrote: >> >>> On Jul 30, 2019, at 11:05 AM, Les wrote: >>> >>> Hi all: >>> >>> I had a merger transaction on one of my Canadian stocks where my existing >>> holding was acquired on a 33 for 20 basis (new for old). From 500 of the >>> existing shares for 825 shares of the new. I also had a net gain in cash >>> of C$16.75. >>> >>> I am uncertain on how to handle this transaction in GC. >>> >>> I would greatly appreciate any suggestions. >> Actions>Stock Split Add 325 shares and book a "cash in lieu" for the >> C$16.75. Les, What I do in that case is modify the transaction after running the Stock Split Assistant to credit the old stock account 500 shares and change the 325 debit to 825 in the new stock account. You could of course create the same transaction manually: Old Stock -500 New Stock 825 Cash Account 16.75 Cap Gains Income 16.75 Start it in the Old Stock account and be sure that the price column is blank in all 4 splits. Note that this treatment depends on the merger not being taxable to the shareholders. That's true in nearly all cases, but a prominent one in the works now that isn't is United Technology's merger with Raytheon. If it's a taxable merger you need to record a regular sell of the 500 shares of "old stock" and a buy of the 800 shares of "new stock". The C$16.75 gets tacked on to the sell transaction. You should have gotten a letter from the company indicating the price to use for each transaction. If you didn't you can use the closing price of each on the last trading day before the merger consummated. (Note that I'm not a licensed accountant, financial advisor, or tax advisor and that you should consult with licensed professionals to be sure that what I've suggested complies with tax law in your jurisdiction.) 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: [GNC] Merger
> On Jul 30, 2019, at 11:05 AM, Les wrote: > > Hi all: > > I had a merger transaction on one of my Canadian stocks where my existing > holding was acquired on a 33 for 20 basis (new for old). From 500 of the > existing shares for 825 shares of the new. I also had a net gain in cash of > C$16.75. > > I am uncertain on how to handle this transaction in GC. > > I would greatly appreciate any suggestions. Actions>Stock Split Add 325 shares and book a "cash in lieu" for the C$16.75. 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: [GNC] Saving UI settings
Op dinsdag 30 juli 2019 08:00:58 CEST schreef David Carlson: > Should I take the deafening silence to indicate that there is no > accelerator or shortcut to save the window arrangement and report settings > without closing and re-opening the entire program? > > David Carlson We're in the summer holiday period, which may partially be the reason of the lack of responses. However I unfortunately don't know of such a shortcut nor a workaround. I seem to remember you or someone else opened an enhancement request to make gnucash save the window positions and such when hitting save and not only on quit. I believe that's the best future fix for this issue. Regards, Geert ___ 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] Merger
Hi all: I had a merger transaction on one of my Canadian stocks where my existing holding was acquired on a 33 for 20 basis (new for old). From 500 of the existing shares for 825 shares of the new. I also had a net gain in cash of C$16.75. I am uncertain on how to handle this transaction in GC. I would greatly appreciate any suggestions. Thanks Les ___ 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] RE Merger
Sorry, I should have stated that I am using LInux Mint 19.0 and GC 2.6.19. Les ___ 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] Concern with the lengthy list of "Known Issues"
Op maandag 22 juli 2019 00:09:02 CEST schreef David Cousens via gnucash-user: > Scott, > > I have been using GnuCash 3.6 on Linux Mint 19.1 since it was released (and > most of the V3 releases usually within a few days of their release) without > any significant issues at all. My usage is mainly for personal accounting > but I do use a subset of the business features as well for a couple of > small ventures. The early V3.x versions certainly had a few more serious > issues but nearly all could be worked around fairly easily. Those have > largely been eliminated over the first 3-4 releases in the series. The vast > majority of the list of remaining issues largely qualify as minor > inconveniences and do not affect the core functionality of GnuCash. Others > with more demanding use of GnuCash than mine may disagree however. > > The major issue with the shift from the 2.6 series to the v3 series is the > change in location of the configurations and the need to copy any stored > reports etc from the old location to the new location. These changes are > described in the wiki and there are posts in the GnuCash User archive > around the issues with stored reports. > (https://wiki.gnucash.org/wiki/Configuration_Locations) Allow me to stress this particular issue should be fixed for most users. Gnucash is supposed to do this migration for you, but due to a few bugs in the early 3.x releases this failed in several cases. The migration should be much improved in more recent releases. If you still encounter this particular issue, please do report it and please do follow up on future fixes by emulating a migration to verify if these fixes would have solved your migration. So how can you emulate a migration ? 1. You need your original DOT_GNUCASH_DIR [1] (.gnucash) still present on your computer 2. Rename your GNC_DATA_DIR [1] and GNC_CONFIG_DIR [1] to something like GnuCash-good (Note that on Macos and Windows GNC_DATA_DIR [1] and GNC_CONFIG_DIR [1] are one and the same directory so there's only one directory to rename on those platforms). Note this serves both as a backup of your known good data and to reset the migration. If these directories exist, the migration won't run. 3. Start gnucash 3.x 4. Verify - it pops up a metadata migration notice. - gnucash opens with the same tabs open as when you last closed your book in gnucash 2.6 (ypu may have opened and closed tabs in the 3.x series but we're migrating from the 2.6 situation!) - your saved report configurations are there (again as they were in gnucash 2.6 - you may have made changes meanwhile by running gnucash 3.x on your book for some time). 6. If they are, migration works for you. If not, there is still a bug in the migration that needs fixing. Please file a bug report [2] and attach the most recent tracefile [3] (the one that was generated while testing the migration). Last but not least: 7. quit GnuCash 8. Remove the newly created GNC_DATA_DIR [1] and GNC_CONFIG_DIR [1] 8. Rename GNC_DATA_DIR [1] and GNC_CONFIG_DIR [1] from GnuCash-good back to their original names on your platform Regards, Geert [1] I'm using symbolic names for these directories as their exact names are platform dependent. You can find the exact names for your platform here: https://wiki.gnucash.org/wiki/Configuration_Locations [2] Refer to http://wiki.gnucash.org/wiki/Bugzilla on how to use our bug tracker [3] http://wiki.gnucash.org/wiki/Tracefile ___ 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] Help with Export
As others have said, Windows 7 and 10 do not allow users to save files to the root of the C: drive nor in any system folder. It is best to save in C:\Users\YourName or sub-folder under there. Jack -Original Message- From: gnucash-user On Behalf Of David Carlson Sent: Monday, July 29, 2019 1:16 AM To: Greg Feneis Cc: gnucash Subject: Re: [GNC] Help with Export Microsoft Windows likes users to save all their stuff in a sub directory of My Documents. That is actually the same as C:\users\[username]\My Documents\ . GnuCash suggests creating a subdirectory with a familiar name because it will fill up with backups as time passes. Often users have a different preference, possibly on a different hard drive, as long as it is not in any of the Windows system directories. David Carlson On Sun, Jul 28, 2019 at 10:21 PM Greg Feneis wrote: > It could be a permissions issue like Christopher Lam wrote. I just > played around with the Export dialog on GnuCash 2.6.21 on Win 7 64. > > It appears GnuCash knows what extension to give the file based on the > Data Format selection at the top of the dialog box. Mine was at .xml > by default. > > I just tried to do a test save of my accounts' exports to C:\ (which > win 7 doesn't allow), and it failed silently. Tried it again and same result. > > James Fuller, if you're using Win 10, it's possible that if you're > attempting to save to C:\ Windows 10 isn't allowing it, and if you're > using GnuCash 3.x, it's based on GTK3 (sp?) so it's not failing > silently like my older version did, but it's not really giving you an > appropriate error message either. It should be something like "saving > in reserved location is forbidden" > > If so, you're going to want to select a place to store the accounts > export file that's not at the very root of the hard drive. That is, not C:\. > However, some folder on C:\ is OK. There's usually a folder where > Windows computers encourage users to store their files, like > C:\Users\James (replace James with whatever the user's name is.) Try > saving there. Or, C:\Users\James\Desktop > > > > > Kind regards, > > Greg Feneis > > > > > On Sun, Jul 28, 2019 at 5:06 PM Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > > > I’m on a Mac, which doesn’t care about file extensions, but perhaps > > that is what Windows was complaining about. Despite the fact that > > the export > is > > CSV (with custom delimiter) it saved it without an extension. If the > > Windows build does the same, this might be the cause of the error. > > > > Try giving your file a “.csv” extension. > > > > Regards, > > Adrien > > > > > On Jul 28, 2019, at 6:43 PM, James Fuller > wrote: > > > > > > Hi, > > > > > > I'm trying to export my chart of accounts so that I can start a > > > new set > > of books. After opening Gnucash I move to the File drop down menu. > > then choosing Export I get a screen that offers options. I choose > > export accounts. A screen pops up that wants ( i think ) the name > > of the file > to > > be saved. In this case I'm using the name ' CruzersGnu19 '. I then > select > > C: for the drive. when I accept Save As, I get an error message that > > says > > > > > > " there was an error saving the file" "invalid argument" Obviously > > > I'm > > doing something wrong, but I can't see what. Any help would be > > appreciated. > > > > > > James Fuller > > > > > > ps. I'm accustomed to using apple Ipads. I do a much better job > > > of > > communicating on them. Grrr. Microsoft. > > > > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fli > > sts.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-userdata=02%7C01 > > %7C%7C535683bec90e4d6c072108d713e3ef8f%7C84df9e7fe9f640afb435aaa > > a%7C1%7C0%7C636999742007617259sdata=D8azWy3gtyn8X%2F11sOAfC > > T36z128OgKIA2q1yTzNa90%3Dreserved=0 > > If you are using Nabble or Gmane, please see > > https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Listsdata=02%7C01%7C%7C535683bec90e4d6c072108d713e3ef8f%7C84df9e7fe9f640afb435%7C1%7C0%7C636999742007617259sdata=c2ap6oAxFvVeuMIe78Dc%2BdwVVbeBAPU9FDx3rTRV9zg%3Dreserved=0 > > 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://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flist > s.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-userdata=02%7C01%7C% > 7C535683bec90e4d6c072108d713e3ef8f%7C84df9e7fe9f640afb435% >
Re: [GNC] Miscalculation in cashflow reports
Hi, Am 30.07.19 um 16:13 schrieb Geert Janssens: > Does it even make sense to try to determine the "cash flow" on a single > account ? I can imagine one would see the cash flow for a business and the > details of how that cash flow was generated. Trying to to so on a single > account may yield results that don't make sense. The current report is for me an important tool for cost analyse. Select a cost center and you see on one side the cost elements and on the other the related cost objects. The only issue: It is in no way related to "cash". So we should probably rename it. Suggestions? >> Or does it even matter? > What does matter to me is an accounting package shouldn't make assumptions. If > multiple valid distributions are possible it's the user that should be able to > mark those somehow. Right, https://de.wikipedia.org/wiki/Kapitalflussrechnung lists 3 different structures and more in the discussion. If we want to create this, we should group them by default according IFRS https://en.wikipedia.org/wiki/IAS_7 with options to adjust the structure. > I really would like to have input from users with actual accounting > backgrounds on > 1. what a cash flow report really should display > 2. whether our current cash flow report actually does that or is in effect a > totally different kind of report with a misleading name. > > Geert Frank ___ 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] best accounting practice for refund
It took me a while to respond as I was on holidays :) First off, I can't read the second screenshot, so I don't know what's in there. In your first screenshot I see three transactions: 1. An "Invoice type" (I) transaction, named Credit Note 2019 (don't worry about it being called "Invoice type", that's the proper type for credit note transactions) 2. A "Lot Link type" (L) transaction, that handles the offsetting of Invoice 368 and 374 with credit note 377. 3. A "Payment type" (P) transaction for a payment against supposedly the same customer. Is this one related to the payment you are having issues with ? In any case, looking better at this it will be slightly more complicate to fix. The easiest way out is probably to restart this payment after cleaning up the unwanted parts. That would mean: 1. find the unwanted payment transaction to the liabilities account and delete it. 2. find the transaction that represents the offset between your invoice and credit note we're trying to correct here and delete it as well. 3. Create a new payment via Process Payment and this time set the payment and refund boxes to 0 after selecting the invoice and credit note to keep the remaining credit note balance open. Regards, Geert Op zondag 14 juli 2019 01:17:36 CEST schreef Eric Rathhaus (general): > Hi Geert - You’re correct about what happened. However, I can’t see how to > change the offset. The transactions appear as follows in my AR account > > > > The only place I can see to reduce theis the payment transaction before gnu > automatically sends the amount from AR to liabilities. But I can’t edit > that transaction. Would I just delete it? > > On Jul 3, 2019, at 10:50 PM, Eric Rathhaus (general) > > wrote: > > > > Thanks, Adrien for your assistance and patience. > > > >> On Jul 3, 2019, at 10:35 PM, Adrien Monteleone > >> wrote: > >> > >> Short answer — yes. > >> > >> Slightly longer answer — figure out what caused that to happen, undo it, > >> and then redo the payment properly. > >> > >> The reason for doing so rather than just creating a correcting entry is > >> so that you learn what went wrong and don’t repeat the same situation in > >> the future. (you’d also need to make good notations in the correcting > >> entry so that far in the future, you don’t question why it is there) > >> > >> I’d suspect that you chose the liability account as a source account like > >> you’d choose some asset account. You don’t need to select an account > >> when doing an offset. > >> > >> Regards, > >> Adrien > >> > >>> On Jul 4, 2019, at 12:04 AM, Eric Rathhaus (general) > >>> wrote: > >>> > >>> So I did assign the credit note to the AR account and then processed two > >>> payments by selecting the posted invoices and the credit note all in > >>> the AR account. I didn’t do anything else but somehow the remaining > >>> balance of the credit note ended up in a liability account. Should I > >>> just move it back to the AR account to keep it simple?>> > >> ___ > >> 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] How to update Description info in Payment Field of Customer Report?
Thanks Geert, that’s probably the safest and certainly most consistent option. Regards, Adrien > On Jul 30, 2019, at 12:03 PM, Geert Janssens > wrote: > > The other (more conservative) option is to right-click on the payment > transaction in the AR account and then select "Edit Payment...". That way > you're consistently using the same window to set all your payment memos. > > Regards, > > Geert > > Op vrijdag 12 juli 2019 16:45:46 CEST schreef Adrien Monteleone: >> I just edited one of my memos for a customer’s payment noting it applied to >> a certain invoice and then refreshed the Customer Report. It updated the >> description field for me as expected. >> >> Be sure you are entering info in the `memo` and not the `notes` field of the >> transaction. >> >> `memo` is the text area for each split. >> `notes` is the text area just below `description` and is only visible if you >> have Double Line Mode turned on in the View Menu. >> >> There is a bug report filed already that the `notes` text is not used for >> this report as expected. >> >> If you intend to use this description column for the purpose I just >> mentioned, indicating what invoice(s) it applies to, you may want to take a >> look at the revised report here linked in this thread on the -devel list: >> https://lists.gnucash.org/pipermail/gnucash-devel/2019-July/044002.html >> >> This newer version (work in progress) has the ability to show you that info >> as its own column. (see the screen shots on the linked github page) >> >> Regards, >> Adrien ___ 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] Miscalculation in cashflow reports
> On Jul 30, 2019, at 10:57 AM, Adrien Monteleone > wrote: > > The basic form is something like this: > > -- > Cash & Cash Equivalents, beginning of period: > > Cash Flow from Operations: > Cash Flow from Financing: > Cash Flow from Investing: > > Net Increase in Cash & Cash Equivalents: > > Cash & Cash Equivalents, end of period: > -- For simplicity, the Beginning & End of Period lines might have to be left off and just report the Net Increase (Decrease) line. This is because the Beginning of Period figure comes from the End Of Prior Period Balance Sheet. Since that will vary, and may not have even been run, there is no way to know what that would be. The only way around that would be to run the Balance Sheet code for a period *from the start of the book* to the day before the opening day of the CashFlow report, take that Cash figure, then run the rest of the code for the Cash Flow report, then add the Net change to that Cash amount to get the End of Period amount. (which is supposed to match the End of Period Balance Sheet cash amount as well) !! I’m copying -devel on this to move the discussion there. Regards, Adrien ___ 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] How to update Description info in Payment Field of Customer Report?
The other (more conservative) option is to right-click on the payment transaction in the AR account and then select "Edit Payment...". That way you're consistently using the same window to set all your payment memos. Regards, Geert Op vrijdag 12 juli 2019 16:45:46 CEST schreef Adrien Monteleone: > I just edited one of my memos for a customer’s payment noting it applied to > a certain invoice and then refreshed the Customer Report. It updated the > description field for me as expected. > > Be sure you are entering info in the `memo` and not the `notes` field of the > transaction. > > `memo` is the text area for each split. > `notes` is the text area just below `description` and is only visible if you > have Double Line Mode turned on in the View Menu. > > There is a bug report filed already that the `notes` text is not used for > this report as expected. > > If you intend to use this description column for the purpose I just > mentioned, indicating what invoice(s) it applies to, you may want to take a > look at the revised report here linked in this thread on the -devel list: > https://lists.gnucash.org/pipermail/gnucash-devel/2019-July/044002.html > > This newer version (work in progress) has the ability to show you that info > as its own column. (see the screen shots on the linked github page) > > Regards, > Adrien > > > On Jul 12, 2019, at 4:13 AM, L. D. James wrote: > > > > On many of my Payments entries, I inadvertently don't write a Memo or > > mistype the correct note when processing the payment. I can correct this > > by editing the Memo field in the Accounts Receivable page. > > > > It's great having the correct information recorded and available, however, > > it doesn't show up on the Customer Report page, whereas the counterpart > > on that page has a "Description" field. > > > > Initially, they are the same. Is there a way to have the updated Memo > > field in the Account Receivable chart match the Payment Description field > > of the Customer Report page? > > > > Thanks in advance for any input/suggestions. > > > > -- L. James > > ___ > 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] Miscalculation in cashflow reports
> On Jul 30, 2019, at 10:57 AM, Adrien Monteleone > wrote: > > > What I have found so far, is that certainly the Operations section will > contain several adjustments to account for anything accrued or transacted in > credit as opposed to cash. (i.e., changes to AR/AP, Inventory, Depreciation, > Unearned Revenue, Accrued Expenses, Deferred Taxes, Stock Disbursement > Compensation, etc.) This is only for the ‘indirect method’ of calculating the Operations section. There is also a ‘direct method’ which is allowed by GAAP(though GAAP requires the indirect schedule also) and strongly recommended by IAS. (though IAS allows either method) I’ll detail both methods when I add more. I suspect the Direct Method will be easier to accomplish with GnuCash and more likely to be more useful to an individual or cash -basis SMB. The Indirect Method will require calculation code from the Income Statement and Balance Sheet since the workflow pulls figures from those reports. Regards, Adrien ___ 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] Fwd: how to copy "Customers Overview" table for spreadsheet.
Op maandag 8 juli 2019 21:46:23 CEST schreef Adrien Monteleone: > David, > > The OP was asking about the Customer Overview, not Customer Summary Report. > > The Customer Summary Report doesn’t show the same info as the Customer > Overview. Notably, customer ID, address, and phone#. The overview is > essentially a table of *some* of the data for each customer like what might > be found if there were a way to export customers. (the same problem exists > for vendors) > Hmm, I made the same mixup. Please ignore my reply (still catching up on a backlog of several weeks...). Regards, Geert > GnuCash can import this data, but can’t export it. > > Regards, > Adrien > > > From: > > Date: Mon, Jul 8, 2019, 11:07 > > > > > > > > Have you tried highlighting the report contents and pasting into a > > spreadsheet? In Windows, I can run the Customer Summary report, press > > CTRL-A, CTRL-C , open a spreadsheet, and press CTRL-V. The results are > > reasonably sane. I haven't tried on a Mac recently, but ISTR that it > > worked > > in a similar fashion there. > > ___ > 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] how to copy "Customers Overview" table for spreadsheet.
Op maandag 8 juli 2019 19:15:43 CEST schreef Jonathan Francoeur via gnucash- user: > I'd like to copy and paste the data from the "Customers Overview" table > into a spreadsheet. Any ideas how? Sure: * Select the table by dragging your mouse cursor over it (I only selected the table) * Hit ctrl-C (or cmd-C on Macos) * Open your spreadsheet and paste. At this point you may have to enter a few conversion parameters such as language, or number format. I have just tested this with libreoffice on Fedora 29. Works like a charm though your mileage may vary with other spreadsheets. Regards, Geert ___ 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] Miscalculation in cashflow reports
I’ll provide something more detailed later, but the current report seems either way off, or just a first attempt that didn’t get fully fleshed out. A Statement of Cashflows has 3 main parts: Operating Activities Financing Activities Investing Activities There are rule differences between GAAP and IAS (and I’m sure others) that will require the user to select the desired accounts for each of these three parts of the report. That is, there will need to be THREE ‘accounts’ selection sections. (some reports already have a second ‘filter by’ section, so I would think this should be possible) The basic form is something like this: -- Cash & Cash Equivalents, beginning of period: Cash Flow from Operations: Cash Flow from Financing: Cash Flow from Investing: Net Increase in Cash & Cash Equivalents: Cash & Cash Equivalents, end of period: -- Of course, the main three sections can get more detailed and complicated, I’ll research what I can find on the full gamut of what can be included therein and report back. What I have found so far, is that certainly the Operations section will contain several adjustments to account for anything accrued or transacted in credit as opposed to cash. (i.e., changes to AR/AP, Inventory, Depreciation, Unearned Revenue, Accrued Expenses, Deferred Taxes, Stock Disbursement Compensation, etc.) I don’t see anything concerning a ‘personal’ CashFlow Statement, but I don’t see why it be possible based on account selection. Such a report simply wouldn’t have as much detail and the user would have less accounts to include than a business and the idea of ‘Operations’ would be different, though the accounts be the same. Regards, Adrien > On Jul 30, 2019, at 10:19 AM, Adrien Monteleone > wrote: > > > >> On Jul 30, 2019, at 9:13 AM, Geert Janssens >> wrote: >> >> >> >> I really would like to have input from users with actual accounting >> backgrounds on >> 1. what a cash flow report really should display >> 2. whether our current cash flow report actually does that or is in effect a >> totally different kind of report with a misleading name. > > I’m inclined to go with the latter on #2. It doesn’t look like what I > remember from my accounting studies. While I’m not an accountant, I’ll check > my references for their corresponding reports and post some samples here. > > Regards, > Adrien ___ 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] Miscalculation in cashflow reports
> On Jul 30, 2019, at 9:13 AM, Geert Janssens > wrote: > > > > I really would like to have input from users with actual accounting > backgrounds on > 1. what a cash flow report really should display > 2. whether our current cash flow report actually does that or is in effect a > totally different kind of report with a misleading name. I’m inclined to go with the latter on #2. It doesn’t look like what I remember from my accounting studies. While I’m not an accountant, I’ll check my references for their corresponding reports and post some samples here. Regards, Adrien ___ 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] Miscalculation in cashflow reports
Op zaterdag 13 juli 2019 17:20:41 CEST schreef John Ralls: > There hasn't been much of a response, perhaps because the presentation here > isn't clear. > > The bug, https://bugs.gnucash.org/show_bug.cgi?id=797093, complains that the > Cash Flow report on a single bank account reports the following > transaction: > > Assets:Bank Cr 500 > Assets:Other Cr 500 > Expenses:Payroll Dr 1000 > > as > Money in: >Assets: Other 500 > Money Out: >Expenses: Payroll1000 > Difference: -500 > > Which isn't right: Although the net at the bottom is correct, the report > implies that 500 flowed through the Bank and it didn't. > > Where it gets more interesting is when there are multiple in and out splits > in a single transaction, e.g. > > Assets:Bank Cr 500 > Assets:Other Cr 200 > Expenses:PayrollDr 600 > Expenses:ElseDr 200 > > In that case, the Cash Flow report on Assets:Bank should show an outflow of > 500, but how should it be apportioned between Expenses:Payroll and > Expenses:Else? 500 to Payroll, 300 to Payroll and 200 to Else, 375 to > Payroll and 125 to Else, or something else? > Does it even make sense to try to determine the "cash flow" on a single account ? I can imagine one would see the cash flow for a business and the details of how that cash flow was generated. Trying to to so on a single account may yield results that don't make sense. > Or does it even matter? What does matter to me is an accounting package shouldn't make assumptions. If multiple valid distributions are possible it's the user that should be able to mark those somehow. I really would like to have input from users with actual accounting backgrounds on 1. what a cash flow report really should display 2. whether our current cash flow report actually does that or is in effect a totally different kind of report with a misleading name. Geert ___ 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] Gnucash bug
On 7/30/2019 3:52 AM, Wm via gnucash-user wrote: On 09/07/2019 03:45, John Ralls wrote: On 8 juil. 2019, at 08:55, R. Victor Klassen wrote: Perhaps this has been fixed. I’m using 2.6.21 for production. Using SQLite I am expecting every transaction to hit disk immediately. Saturday we had a power failure and lost about five days’ worth of transactions including at least 10 invoices and three new customers. I think I can reconstruct. But I wouldn’t expect this to have happened. It is also a "work flow" issue. You SHOULD want "clean" recovery points. So what you should ask yourself is whether you should make sure of an EXPLICIT save: 1) After entering transactions for a day 2) After entering data like "customers" Do you understand what I am saying? Even if SQLite were saving data after each entry (I am used to SQL systems that would need a "commit") you would not know WHERE you were at. Michael D Novack ___ 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] Gnucash bug
On 09/07/2019 03:45, John Ralls wrote: On 8 juil. 2019, at 08:55, R. Victor Klassen wrote: Perhaps this has been fixed. I’m using 2.6.21 for production. Using SQLite I am expecting every transaction to hit disk immediately. Saturday we had a power failure and lost about five days’ worth of transactions including at least 10 invoices and three new customers. I think I can reconstruct. But I wouldn’t expect this to have happened. Were those 5 days worth of transactions all entered together or over the 5 days? Do the transaction logs reflect the "lost" transactions? If so you can at least recover them by playing the transactions back https://www.sqlite.org/howtocorrupt.html might shed some insight on what happened. I think === I’m using 2.6.21 for production. === is more likely to be the problem. -- 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: [GNC] How can I make GnuCash store all dates in only 1 format?
Sorry, that should have read: When I look at the transactions table I have dates in the following formats: 1: mmddHHMMSS 2: -mm-dd HH:MM:SS Unfortunately, the sqlite date, datetime, strftime functions will not recognise the first format as a date. ___ 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] Saving UI settings
Should I take the deafening silence to indicate that there is no accelerator or shortcut to save the window arrangement and report settings without closing and re-opening the entire program? David Carlson On Thu, Jul 18, 2019 at 11:05 AM David Carlson wrote: > I noticed recently that if GnuCash is open and the computer crashes the > settings for reports currently open and open window arrangements are lost, > reverting back, I believe, to the settings as of the last time the program > was shut down normally. > > Since it is very tedious to perform a full shutdown in the middle of a > lengthy session just to save a window arrangement/report settings, is there > a magic accelerator or shortcut to append the UI settings to the > auto-magical backup File > Save? > > If it matters, I observed this in GnuCash 2.6.19 running in Ubuntu 18.04, > which somehow crashed in a VirtualBox VM. > > -- > David Carlson > -- David Carlson ___ 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.
