Re: [GNC] End of Year?
Sorry, I would not like to see an FAQ pop up in this list on any periodic basis. What you are describing there is akin to a 'sticky' or 'pinned' post in a web forum. This is not a web forum. We have the Wiki, which has the FAQ section. We also have the Help Manual, and the Tutorial & Concepts Guide. Those are better places for standard, regular advice on how to use the software. This list serves a different purpose — to offer assistance that those sources don't (maybe yet) cover. Some redesign of the website pointing to the FAQ might be in order, but that would take some careful analysis, and of course, someone to code the changes. Regards, Adrien On 1/13/24 11:19 AM, R Losey wrote: But the larger issue is that I believe this email list could benefit from a FAQ that is posted monthly or every other month to this group. The wiki has some neat ideas about tracking year to year equity growth. ___ 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.
Re: [GNC] End of Year?
That would be the case at first glance, but see my reply up the chain concerning correcting entries and usual procedures when starting with fresh books each year. I'd hazard that with Pen & Paper, Reconciliation is *not* necessarily a function of the T-Accounts or General Journal. That is something done independently that happens to now be rolled into GnuCash along with everything else. Thus, it likely wouldn't even be a consideration. Folks trying to imitate Pen & Paper using a computer are always going to have to adjust their workflow or make concessions for the difference in formats. This is true no matter the task at hand, or the software used, and is true of things not even accounting related at all. I'm glad GnuCash gives the choice. Some software forces you to do what *it* wants. Regards, Adrien On 1/13/24 4:29 PM, David Carlson wrote: Dumb question. The original topic was about unreconncciled transactions from the pervious year. If they are not copied over to the new file wouldn't that mess up the next reconciliation? ___ 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.
Re: [GNC] Budget car payment
You can indeed save as CSV after opening in LibreOffice or Excel. Once it is opened, the spreadsheet app now controls what you do with it. Regards, Adrien On 1/13/24 5:27 PM, David Carlson wrote: I just tried opening a GnuCash report saved in Html format with Libre Office writer and found that it would offer to save in ODT format as soon as I tried to save anything. I am sure that it would also save in csv or other common formats. ___ 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.
Re: [GNC] End of Year?
*ALL accounts are 'credit and debit' accounts. But perhaps you mean Checking & Credit Card accounts? (i.e., those held at a 3rd party financial institution, since you are referencing 'reconciliation'.) Reconciliation is usually done prior to a Trial Balance as part of the End of Year process and that not infrequently is done up to a month (sometimes more) after the calendar date of the end of the period. It is not uncommon to see P&L and Balance Sheet reports published in February for periods ending December 31. Otherwise, correcting entries are employed. This is usually the case with Accruals that cross period boundaries. You reverse the portion of an amount that doesn't apply to the period being closed, and add it back in the following period. (this also occurs for interim periods such as months or quarters) Exactly what you do, depends on the requirements of your local jurisdiction. Regards, Adrien On 1/13/24 8:03 AM, Phyllis Bruce wrote: H, would you not also need to re-enter any unreconciled transactions in your credit and debit accounts? ___ 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.
Re: [GNC] End of Year?
You could add A2b: Export your Chart of Accounts and write down the ending balances as needed. Start a new file, import your exported chart of accounts and set opening balances to the old ending balances. This method is more like Pen & Paper days in that each file only contains one period (year in this case) of data. - As for A2(a), there's not really a solid way to 'mark' a file as read-only if you have access to the file. (anyone determined enough can edit it) Some folks write it to a CD-ROM, but that's about as good as you could expect. In addition, some folks also archive PDF copies of their year-end reports with the file. While the file could always be changed after the fact, the reports reflect the state of the accounts as of when they were generated. (which of course are no more immutable than the file, but at least offer a reference point) Regards, Adrien On 1/13/24 12:16 AM, R Losey wrote: I suspect that this topic comes up about every New Year - perhaps it is worth putting in a FAQ (if it's not in one), and perhaps posting the FAQ monthly to this list. In the relatively short time I've been on this list, I definitely see some repeated questions, including this end-of-year question that I created, and therefore may have errors in it. --- Question: "How do I start a new year in GnuCash?" Alternatively, "How do I close out the old year in GnuCash?" Answers as far as I can remember them: General Answer: You need to determine precisely what you are trying to accomplish in GnuCash. You may not need to do anything (see A1). If you want to keep a backup-copy of the previous year, see A2. If you want to close the books in the accounting sense (reset the balances of the income and expense accounts), see A3. A1: There is no necessity to take any action at the start of a New Year. GnuCash can keep several years of data in its compressed XML file without it growing too large. A2: The best thing to do here is to be sure that there is no additional transactions for end-of-year, run whatever end-of-year reports you need, then shut down GnuCash and copy your main data file to some safe place. If that area supports it, consider marking the file as read-only. You should probably note the year in the name: "SmithFamilyFY2022.gnucash" or something like that. There is no need to delete old data (see A1). A3: See the GnuCash Manual, section 8.9 for a discussion about how to do this task, along with the caveats. ___ 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.
Re: [GNC] Template Transactions Behavior in Scheduled Transaction Editor
Not general templates, no. It only has scheduled transactions. There is a request for templates. Regards, Adrien On 1/12/24 11:56 PM, R Losey wrote: I'm sensing a learning opportunity here... GnuCash has templates? I never noticed that; I only use the templates in the Scheduled Transaction Editor. ___ 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.
Re: [GNC] Template Transactions Behavior in Scheduled Transaction Editor
That's moving beyond Scheduled Transactions and into a more general case of Templates. I'm pretty sure I've already filed an RFE for that long ago. I see Scheduled Transactions as a special use case of Templates, though Scheduled was implemented first. The more general Template case is when you definitely want to re-enter the format of a transaction (which may or may not be complicated) but you don't want to do so on a set periodic basis. I know we have Duplicate in the interim, but that means you have to go looking for the transaction you want to duplicate first. (and likely have to do a Find for it) Regards, Adrien On 1/12/24 9:26 PM, David Carlson wrote: Liz, Since you asked, I think that is a good idea. We could have both a test run while editing that did not crash anything if it failed and when looking at the SX but not editing it, have a button that triggers the creation of the next instance. That would probably work regardless of the SLR settings such as ignore, postpone, etc. ___ 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.
Re: [GNC] Template Transactions Behavior in Scheduled Transaction Editor
What I meant was it would indeed be nice that the SX Template entry allowed you to do math like a register does. I never meant to imply that one could edit the code from within the app! Regards, Adrien On 1/12/24 11:27 AM, David Carlson wrote: I beg to differ. Executing code while editing it would be an invitation to disaster. On Fri, Jan 12, 2024 at 10:25 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: Indeed, I should have tested it prior to commenting. Apologies for the noise. At the very least, being able to do math here with a result would be a good RFE. I would only expect formulas to remain as formulas if they contain variables which require a prompt for value. ___ 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.
Re: [GNC] Template Transactions Behavior in Scheduled Transaction Editor
Indeed, I should have tested it prior to commenting. Apologies for the noise. At the very least, being able to do math here with a result would be a good RFE. I would only expect formulas to remain as formulas if they contain variables which require a prompt for value. Regards, Adrien On 1/12/24 12:18 AM, David T. via gnucash-user wrote: I am pretty sure I tried that, but it didn't actually do the calculation in the SX window. Which makes sense, I think, because that window allows formulas that get processed at runtime. ___ 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.
Re: [GNC] Template Transactions Behavior in Scheduled Transaction Editor
I am not unsympathetic to that conundrum! Regards, Adrien On 1/12/24 12:23 AM, David T. via gnucash-user wrote: if I have to remember to run the SLR in order to have them created, then I've just changed the work, not reduced it. ___ 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.
Re: [GNC] Maddening!!!!!!!!
David, see that bug report John linked. Something is amiss. Where, remains to be found. Regards, Adrien On 1/11/24 9:57 PM, David Cousens wrote: Jack, What do you mean by a rogue transaction? Is this by any chance a transaction which has one split to an IMbalance" account? If this is the case then it may be that you are not assigning the transfer account befor committing the transaction with the return key. If no account has been assigned to th seoncd line of the transaction it will be automatically assigned to the Imbalance account, the purpose of which is to alert you that nyou need to assign an appropriate account to that second split. ___ 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.
Re: [GNC] Maddening!!!!!!!!
Wow. Interesting. Thanks for the link. Regards, Adrien On 1/11/24 9:53 PM, john wrote: Have a look at https://bugs.gnucash.org/show_bug.cgi?id=799093 ___ 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.
Re: [GNC] Maddening!!!!!!!!
In 10+ years of GnuCash, I've never once seen a transaction appear that I didn't put there myself. - Someone else reported an error with an XML lib not long ago. It might be the same one. If I recall correctly, this would have been after the 5.5 release. As far as I remember, it generated a crash, but not 'rogue' transactions. Regards, Adrien On 1/11/24 4:27 PM, Jack Slater wrote: My last post wrote how I had in fact done a hard save after each entry down to the point where I had to delete the "rogue" system generated transaction and it crashed again. So reboot again. Start GnC. Reconcile the last account I was doing. Scanned for the "rogue" transaction and it was in fact gone. Went through the reconcile transactions and completed successfully. Closed GnC. I'll be curious next Thursday to see what happens again. The last error message is attached. Any suggestions on what happened or what to check that I (none coder tech guy) please feel free to post back. ___ 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.
Re: [GNC] Maddening!!!!!!!!
Unrelated to the topic, but this is at least the second recent time I see someone's reply eating random space characters between words. That is very odd, and of course, makes the reply difficult to read. (and that is very important when offering commands!) I can make heads and tails of it, but someone not familiar with the command line is going to be in a bind. Regards, Adrien On 1/11/24 6:26 PM, david amaral via gnucash-user wrote: Verify your windows OSopen cmd window as adminTypedism /Online /Cleanup-Image /RestoreHealthFollowed bysfc /scannow check for bugs with free Norton NPEDownload and run Norton Power Eraser - Free virus and malware removal tool for Windows ___ 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.
Re: [GNC] Template Transactions Behavior in Scheduled Transaction Editor
What do you mean by "manually enter a SX?" Regards, Adrien On 1/11/24 4:19 PM, David Carlson wrote: I think that we need to see how SX's will work after the Since Last Run druid is fixed before proposing more improvements. If I understand correctly, there is an unresolved issue preventing nightly builds, so it will be difficult to test anything right now anyway. As for balancing SX's, I often resort to entering each value on both sides, using plus [or minus] signs instead of summing multiple values. A long time ago I submitted a feature request to provide the ability to manually enter a SX. I think that would help in some cases. ___ 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.
Re: [GNC] Template Transactions Behavior in Scheduled Transaction Editor
That sounds like you have an SX to autocreate. Perhaps turn that off and it won't fire. Otherwise, perhaps turn off the preference to execute the Since Last Run dialog on startup. You can still run it manually to fire any pending SXs, but otherwise, not have it bother you if you just want to pop in and out to check a balance. Another option (which I use for other reasons) is to simply leave GnuCash open 24/7. That lets me see and do whatever I want, and I just run the SLR periodically to fire my SXs. (Oddly, there is no 'watcher' that fires them when the system date should otherwise trigger them) Regards, Adrien On 1/11/24 3:36 PM, David T. via gnucash-user wrote: I've found the "Prompt for value" option with SXes to be downright annoying. I go to Gnucash to check the balances in a savings account, and the SX dialog pops up asking me for a dollar amount for my electric bill (and won't seem to let me just click past). Inevitably, I just put in any old number-- defeating the whole purpose of that feature. So, I've opted to have balanced transactions that may be off, which I correct when I reconcile the account. But then, I had to change some figures in one complex SX, and it didn't supply the balancing split. ___ 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.
Re: [GNC] Template Transactions Behavior in Scheduled Transaction Editor
You don't have to do it in your head. While an extra step compared to normal registers, you can still do math on a split. When entering that balancing split, enter the amount as a sum formula. (split one amount + split two amount, etc.) GnuCash will give you the overall sum. Regards, Adrien On 1/11/24 2:55 PM, David T. via gnucash-user wrote: I understand that there might be use cases in scheduled transactions where one might not want an automatic calculation, but is there a way to invoke it without manually adding up all the amounts in my head? ___ 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.
Re: [GNC] Template Transactions Behavior in Scheduled Transaction Editor
I would guess that the code for calculating the balancing amount as the sum of the other splits is part of the code that forces the transaction to be balanced before committing. Since SXs don't have this rule, that code to sum the other splits never gets executed. Regards, Adrien On 1/11/24 1:17 PM, Stan Brown (using GC 4.14) wrote: I've noticed that too. I'm not aware of any workaround. (Another difference is that if you enter an amount with fewer decimal places that appropriate for your currency, the SX editor does not fill in zeroes. They _are_ filled in when the transaction fires.) The SX editor doesn't force you to balance the transaction. I haven't tried this, but why not just leave it unbalanced, and when the transaction fires you'll have a split for Imbalance. You can then change that to the desired 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Idiot 101 question
If their drives with OS installations are intact, perhaps converting them to VM images might suffice for now. As for Windows software, have you given the latest Wine a spin with it? It may not work 100% out of the box, but you might get close enough with some fiddling. Regards, Adrien On 1/11/24 2:15 AM, Jeff wrote: I'm just trying to get back to gnc and unfortunately a windows program, H@r Block. Without at least 2 computers this almost difficult task unless you have a way to run H@r Block windows version 2023 under ubuntu? And right now I have only one computer. A surge supseror exploded and fried all of my computers. I have a temporary replacement for the network server but not any workstations. ___ 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.
Re: [GNC] Idiot 101 question
That's a bummer. Now imagine you're dealing with Google and since you changed ISPs and your IP address is different, they don't think it is 'you' any more, despite knowing relevant passwords and having 2FA set up! (and not having anyone to contact about it) Regards, Adrien On 1/11/24 1:53 AM, Jeff wrote: This f'ing 3 layer security is ridiculous and unnecessary. I keep getting locked out of one of my banks every time I to login. Changing passwords every time I log in is ridiculous. ___ 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.
Re: [GNC] Gnucash crashing when creating expense reports
Please remember to copy the list on all replies. That way others can benefit from the discussion. Glad to hear 5.4 is working fine for you. Regards, Adrien On 1/11/24 5:40 AM, Maria Inmaculada de la Torre wrote: Thanks, I have installed the previous version and the reports seem to be working now. I will keep the old version for the time being while this is being worked on. ___ 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.
Re: [GNC] Intermittent Crash when using recent File dropdown list. Filed as bug # 799215
Have you tried opening the (other) desired book directly via command line? It may be the book you are attempting to switch to has an issue, and not saving the current one. Also, since it is prompting you to save, that tells me something was edited without a save. Perhaps manually save, then attempt to switch. At least that should determine if the crash is happening on save, or upon opening the other book. Regards, Adrien On 1/10/24 6:05 PM, Stephen M. Butler wrote: Ubuntu 23.10 GnC Build ID: git 5.4-117-gabb4a01ac8+(2023-12-01) Intermittent when changing books using the recent file dropdown list. I pick the book I want next from the File recent dropdown list. GnC asks if I want to save the existing opened book. I say yes. Soon thereafter the program goes away. No stacktrace that I can find. Start GnC again and it opens the book I was in. Again I pick from the recent file dropdown. I don't think it asks if I want to save. But I do get the Lock File dialogue. I tell it to open anyway. It opens. This happens infrequent and I can't predict when it will happen. Apparently happens after the lock file is created for the new book but before it is read into memory. What steps do I need to take to get additional information the next time this (apparently random) happens? ___ 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.
Re: [GNC] Gnucash crashing when creating expense reports
If this is on Windows, it is a known bug that is being worked on. (the bug isn't in GnuCash, but software that GnuCash uses to display reports) Other reports may fail and crash as well. For now, the recommendation is to revert back to 5.4 Regards, Adrien On 1/10/24 4:29 PM, Maria Inmaculada de la Torre wrote: Hello All, Since the most recent update to the program I am having an issue with the Expense reports. It doesn't really matter how I try to generate my expense: both from the Main Menu > Reports > Income & Expense > and my Saved Configuration Reports lead to the program immediately crashing without a warning. Profit and Loss report seems to be working but the majority of reports under the Income & Expense category lead to crashing. Any idea of what might be the cause? And any idea of how to deal with it? ___ 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.
Re: [GNC] Budget car payment
Signs in Budgets need more testing. (I had plans to do so long ago, perhaps I might get to it now as I'm way behind in my own budgeting!) You might have to play around a bit to see if it is possible to come up with a sane entry method that produces a sane bottom line result. Or you may have discovered a bug that needs fixing. I'll endeavor to work on my budget this week and see if I can duplicate your issue. And no, I don't think the Budget Module docs have been updated in many moons and suns. Regards, Adrien On 1/10/24 12:12 PM, Dennis Powless wrote: I'm trying to create a budget and am having some issues with setting it up. I have a liability for car loan and expense for interest for that loan. I pay out of the checking account, say 500. I split to the Liability loan 200 and expense interest 300. In a spreadsheet I would budget out 500 for the car payment. However, Gnucash is not set up this way (or I have it wrong). The liability payment is a negative entry in the budget and the expense is a positive value. The same in the "budget report" created. The help docs are not very helpful, nor are internet searches. Most in the end, state to use a separate spreadsheet for budgeting. Which I have been doing for many years, but figured I'd give it another try as it's been about 9 years. ___ 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.
Re: [GNC] new accounts are omitted from reports
I'm pretty sure this is already filed as a bug or RFE. GnuCash doesn't auto-add new accounts when you have generic top-level accounts selected for a report when using saved configurations. You have to edit the account selection to include the new accounts then update your saved configuration. However, if just running a fresh report that auto-selects accounts (such as the Income Statement) it should include them. (as long as they are not marked 'hidden') Note, if you had a report already in a tab and then added the accounts, that isn't a fresh report, you'd need to manually add the accounts and refresh it. Or just run a new fresh report. Regards, Adrien On 1/10/24 1:17 PM, Scott Ellsworth wrote: Hi all, I have a strange problem now: When I create new income accounts, they are omitted in income statement reports, and the numbers in them are omitted from the totals. The situation is that I need to record US and foreign income separately now for tax purposes. So I created a new account, Income > Business > Tutoring > foreign revenue, and moved a few transactions over to that account. Then I renamed my "revenue" account to "US revenue." Then I created a new placeholder account called Income > Business > Tutoring > foreign revenue, and put my two revenue categories under that. This kind of change has always worked in the past. But all my new accounts are ignored in income statements now. I thought maybe I had too many levels of accounts, so I tried moving the new revenue accounts under the Tutoring category instead. But that still didn't help. ___ 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.
Re: [GNC] 2 questions
I recall that file fiasco. I'm glad you finally got it sorted! Any time you are starting over completely, you will not get auto-fill suggestions until you have transactions that match in the register already. Note, this is true between accounts even without starting over. If you use one Description in say, Checking, and then switch to a Savings account and try to use the same description, unless it was used already in the Savings register it will not be suggested by auto-fill. This is a per-register (account) suggestion only. It only reads and suggests text *in that register*. If the balance 'got messed up' the best (and more proper 'accounting') solution is to find the error and fix it, or else, enter a correcting entry with good notes in it to explain its existence, and then later when you find the error - delete the correcting transaction after you fix the errors. Starting fresh just for a balance error is the path to madness eventually. (will you do this each and every time you notice the balance is off?!) I use the Imbalance account to post correcting entries. That way, I can find them easily for later research and deletion by simply viewing the Imbalance account register. Regards, Adrien On 1/10/24 5:41 AM, Mahon Finbar via gnucash-user wrote: OK, thanks. You may remember (with a wince?) a long series of messages a while back that I had 'cos I had more than one location for the G files. It was sorted, by a kind person. However, somewhere along the line the balance got screwed up, so I created a subfile with the 2024 addition and the balance from the bank a/c. Maybe not be the best or officially approved solution, but it works, except for the lack of a popup, /boo hoo/. No possibility of a cut and paste of the 'other transactions' do all the other 'new year' methods suffer from the same irritant?? If not, the year is still young, I may relent. ___ 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.
Re: [GNC] Size of description column not shrinkable?
It is shrinkable, but not by itself. It fills the remaining space not taken up by the other columns. So if you want to shrink it, make other columns wider. Alternatively, make the window narrower, and then drag the right-handle of the Description column to the left and let it go. It will snap back to fill the remaining space. The register columns will always fill the width of the window. There won't be any unused extra space after re-sizing them. - The gcm file references the GUIDs of the accounts. Yes, you can find these in the data file mapped to account names. (XML is not required) But this isn't always necessary depending on what it is you want to accomplish. I'd hazard a guess that if you wanted all of your registers to have the same widths for all or any columns, you could craft a Find/Replace operation using a good text editor on the gcm file, or script the change(s) to it. Note, the file is normally compressed XML. (but still XML) You only need to uncompress it (either from within GnuCash or using some other utility) to read it using a plain text editor. -- Yes, a preference or menu action to reset one or all registers to defaults (or user set widths) would be nice. Regards, Adrien On 1/9/24 2:30 PM, Stephen wrote: In my limited experience it seems that the column widths are different for each account in the .gcm file. There does not seem to be a "uniform" account setting. Furthermore, the account names are not listed in the .gcm file but can be found by saving the .gnucash file in XML format and opening in a text editor (Notepad) and saving away from your data. BTW, my .gnucash file needed to be saved as non-compressed (General tab in Preferences) to then be savable as an XML. A good description of this process can be found in the Archives [GNC] GUID Register Codes at 12/29/2023 11:38 PM, by David Cousens. It would be nice if GnuCash would allow for a uniform account column width setting but IRL "things" aren't uniform. ___ 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.
Re: [GNC] Starting a new year
Gyle explained how to start fresh with a new file. Some folks also just archive a copy and keep going in the original file. Others just 'close the books' and keep going in the original file. Still others (I'm in this camp) just keep going in the original file. Another consideration is to run and archive (such as with physical paper, or PDF) copies of end of year reports. (Balance Sheet, Income Statement, etc.) If you keep working in the same file, you might edit a previous year transaction (which might be fine to do) and that would of course change those reports. If it is important to you to have 'official' End of Year reports, then archiving a copy is a good practice. Some folks do this and store them with an archived copy of the book too. Regards, Adrien On 1/9/24 1:14 PM, Grace wrote: I am just wondering how folks are dealing with starting a new year? Finishing 2023 I think is easy. You just stop using it. However, how do I start 2024 with the finishing balances of 2023? Do I have set up a brand new set of accounts, or is there a way of doing this that I have not found? ___ 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.
Re: [GNC] Upgrading or starting fresh?
On 1/9/24 12:31 PM, Dianna Broughton wrote: I previously asked about upgrading from 2.x to the current stable version, and may still do that. No matter what, I'd upgrade to the last of the 2.x series which would be 2.6.21. However, before I do, I have a couple questions. 1. Would it be easier to just download the current stable version and start fresh (with opening balances) for 2024, keeping the previous version/files backed-up and available for informational purposes, and in case of a future audit? Can I have two versions running on the same PC (Windows 10)? As far as I know, you cannot have two separate versions at once on the same Windows installation. Starting over is a personal preference. Some folks do it every year! 2. If yes to #1, what is the most stable version to download? That's oddly a personal question at the moment. The 4.x series is pretty good for most needs. 5.x introduced a new method for auto-filling text based on previous transactions. Some folks like this, some do not. There are still kinks to work out. If you are fine with this change, I'd recommend 5.4 as 5.5 (the current release) has some new bugs, and a big one has to do with report stability on Windows. (they are either blank in some cases, or outright crash the program) So the short answer is 4.14, or 5.4 depending on your preference for the auto-fill process. (you'll likely eventually need to move to or past the 5.x series anyway as 4.x won't be supported forever) 3. I use this software for two small businesses and personal finances, but I've never officially closed out my books at year-end. Should I have been doing that? Should I do it moving forward? Not necessarily. That too is a personal preference. The wiki should cover the major questions to ask yourself when deciding this. Even if you chose to close the books, the process is easily reversible, as it just adds two transactions each time closing all Expenses & Income to Equity. Simply deleting those transactions will 'un-close' the books. There is no other magic that happens with that procedure. You could do that manually if you wanted to. It is just a shortcut. 4. I really like the current 2.x version I'm using, but I'm concerned that it won't be compatible with future operating systems (currently Windows 10). That's why I need to upgrade and figure this out. Some older releases of 2.x were 32-bit. I'm pretty sure the last of the 2.6.x series were 64-bit. That would be the biggest concern with respect to future Windows versions as Windows may eventually drop support for 32-bit apps. (MacOS did several years ago) However, one solution here, as well as a solution for keeping multiple versions at the same time, is to investigate turning your current Windows installation into a Virtual Machine (VM) when it is time to either upgrade GnuCash or Windows. Personally, after having upgraded GnuCash all along the way, I'd say that is much easier than messing with a VM, and even if you have several versions you need to step through this time around, you'll only have to do that once. (as long as you keep up every other year or so from now on) 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] 2 questions
On 1/9/24 5:38 AM, Mahon Finbar via gnucash-user wrote:> 1.How to get the suggestions when creating an entry (e.g.. ) name of the client when entering a few characters? It sounds like you are looking for the pop-up auto-fill suggestion list. That is populated by the other transactions in the register. So if you are starting fresh, there won't be anything to suggest. 2. I subdivided an a/c to create a 2024 version, using the latest bank account balance as the opening balance. All Ok, but the entries are in red I cannot find in the help how to change that? If your other similar account of the same type is not in red, then that tells me your debits/credits are backwards in this one. Red indicates a negative condition. If this is not normally a credit balance account (Income, Equity, Liability) then your entries are reversed. If it is one of those three types, having negative balances are normal. How 'negative' numbers are displayed is controlled by Preferences > Numbers, Date & Time. - I'd ask why you created a special account to 'start over' for 2024? The more usual procedures would be to either: - 'close books' and proceed with the next year, - archive a copy of the file as of 12/31/23 and proceed with the next year, or - start an entirely new file for 2024 with carry-over balances, and possibly exporting/importing your Chart of Accounts. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Moving from Quicken
That is a question best answered to your satisfaction and understanding by using the software. Download the Manual and the Tutorial & Concepts guide, launch GnuCash and start playing around a bit. (enter manually at first and hold off on downloads and imports until you get familiar with the basics) You'll have more than just your source accounts, you'll also have accounts for expenses, other assets (house, car, investments), income, and other liabilities (loans). I highly recommend the following as you are just starting out: 1. Turn on Transaction Journal View. (per register in the View menu, or as a global default preference) This will help you visually learn double-entry accounting. 2. Turn on Double-Line mode. (same) This will give you a transaction-level notes field. 3. Do not combine *anything* from bills or receipts. Enter each line item separately assigned to their respective accounts, even if each line in the transaction goes to the same account. 4. #3 includes tax. Unless you are in a tax inclusive jurisdiction and *do not* need to track it, it is much easier to enter tax as its own line item assigned to a tax expense account than to try to distribute that tax amongst the various other line items. 5. Enter as much descriptive info for each line item as you can stand in the Memo for each 'split'. While #3–5 sound like a lot of effort, you'll find the auto-complete feature will start to do most of the work for you. And invariably, at some point in the future, you will want to 're-categorize' spending to different accounts at some point as you get more familiar with the software. If line items are combined, you won't be able to do so unless you retained the original receipt/bill or a copy of it with that level of detail. No.4 will save you lots of time and needless math. This will be readily apparent for receipts that cover multiple expense accounts. (BigBox retailers especially) No.5 will come in handy in the future when analyzing spending, but also for when you invariably decide you want to re-categorize it. That level of detail will assist you greatly. - Most folks here are happy to assist and answer any questions you have, but at some point, you're just going to have to make the effort to use the software and see for yourself. Your understanding of the answer will also be much better than just reading it. Regards, Adrien On 1/8/24 11:33 AM, barry milliken wrote: How does Gnucash allow me display my source accounts separately? ___ 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.
Re: [GNC] When closing books, equity statement report is incorrect
I agree. Regards, Adrien On 1/4/24 9:18 AM, Michael or Penny Novack wrote: Users should keep in mind that when we say things like "you don't have to close the books; gnucash can produce the necessary reports without doing that" we are talking about PERSONAL books and sole proprietorships. Equity in these cases is simply the equity of the "sole". Businesses with more complex ownership will need a complex structure under equity because the ownership is not sole. That structure is keeping track of how equity is divided up among the "owners" -- plural. In that case probably will have to close the books to get the net income/loss properly distributed among these interests. And the "close the books" tool provided by gnucash might or might not be of use (it won't do the distribution part of it). Sorry, but I think "how to keep books for a partnership" and "how to keep books for a corporation" is not what we should be giving advice about beyond "when using gnucash as the accounting software" (any peculiarities vs other software or pen and ink on paper). Both of these organizational forms will require equity to be structured. Not the same structure and the activities to be tracked will be different. ___ 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.
Re: [GNC] When closing books, equity statement report is incorrect
On 1/3/24 12:19 PM, Quinn Wood wrote: You already give advice on how to keep books on the wiki. There is an entire page telling people you don't need to close your books in GnuCash that proceeds to give people workarounds for how to do some of the things closing your books accomplishes. Adding this workflow isn't accounting advice, and frankly people are way beyond that. Even if this was accounting advice, at least it would be correct under GAAP and IFRS unlike the explicit advice that retained earnings are the same as net income or the implied advice that retained earnings belong on a sole proprietor's or partnership's balance sheet. Be careful with the use of 'you'. With a handful of exceptions, everyone on this list is just another user like yourself, not developers. A few have contributed to the wiki, but short of specifically speaking to the page author of wiki article, using a collective 'you' is quite out of place. For the record, GnuCash is designed for Personal & Small Business accounting. How 'small' is intended here, I'm not sure. I recall some brief discussion on this list a few years ago. But it doesn't stop you from following standards if you need to. What it likely will never do is offer special features or reports that are more geared toward special business forms like formal corporations. It won't stop you from doing old-fashioned accounting for them, however. On the flip side, the workflow people keep recommending on the wiki and mailing list does conflict. You have to keep a paid dividend on your books as a payable liability forever, put it on your books as an expense (to fraudulently reduce equity and reducing net income), or just never declare one. Do that and see how quick taxing authorities, lenders, or investors call foul. It seems your use case is one that benefits from more formal processes. Then use them. The usage advice on the wiki and here on the list is for Personal, less formal needs. It has been some time since I looked at this topic, but if I recall correctly, Dividends Payable go on your books at recognition, and while they remain forever (like every other liability), they are zeroed out at disbursement. (upon payment) And Paid Dividends *are* supposed to reduce Equity as they are disbursements of that Equity to Owners and no longer retained by the Corporation. That isn't fraud. That is how you account for Dividends. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] When closing books, equity statement report is incorrect
GnuCash is not getting in your way here. You are free to do what you would do if you were keeping books using Pen & Ink. That process would require the same accounts. What GnuCash is not doing here, that you are asking for, is providing a report so you don't have to mimic the formal methods of Pen & Ink. And I'd say that GnuCash is correct in this approach. Recognizing Dividends and disbursing them is, at least in the U.S., supposed to be explicit in the books - thus requiring specific accounts. It can't be done with just a report as a 'scenario' or thought exercise. Your mileage may vary in other jurisdictions. And yes, this is one of those few cases where contra-accounts come into play. That has to do with accounting, and nothing to do with the design of GnuCash. Regards, Adrien On 1/3/24 7:35 PM, Quinn Wood wrote: When doing your books you don't technically need a contra account for every little thing. GnuCash just gets in the way of your work if you don't have one, in this particular scenario. So, problem solved. Use a contra 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] When closing books, equity statement report is incorrect
Isn't that how it would be done using Pen & Ink anyway? GnuCash has some features to make a few routine tasks easier, but it should not get in your way from doing something via normal processes. Regards, Adrien On 1/2/24 11:49 AM, Quinn Wood wrote: I've identified a solution for this issue that does not require a custom report. Sweep revenues and expenses into a Retained Earnings account and do not include it in the equity report. Take dividends / distributions out of a subaccount called Dividends / Distributions declared and do include it in the equity report. Put investments into an account (e.g. Common Stock) that is included in the report as usual. ___ 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.
Re: [GNC] Manage Document Link
You can set a document link as an individual file, or as a location. I don't think though you can use a relative path. If you move the files, GnuCash will lose the link. Regards, Adrien On 1/3/24 8:10 AM, Tom Balazs wrote: I want to attach an image of a bill to a transaction. I click Manage Document Link. I get "Path head not set, using "/home/tom/" for relative paths. Is that the best Path to use? Where does GnuCash begin navigating from? I would like the path to be relative so that if I move all my GnuCash files to another folder the document links will still work. ___ 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.
Re: [GNC] Discount / Coupon question - How to apply?
Thanks for reporting back, but for posterity, which method worked?
(assigning as payment, or using an intermediary account)
Regards,
Adrien
On 1/2/24 11:31 AM, Alan Johnson via gnucash-user wrote:
Thanks, that worked.
On Sun, 2023-12-31 at 14:36 -0600, Adrien Monteleone wrote:
Is this screenshot taken while viewing the AR account? That error
message usually means you don't have a split in the transaction that
is
AR/AP.
>> Be sure to commit the transaction first, then try right-clicking to
assign the payment.
If it still won't work, you might have to employ some intermediary
accounts.
One option is to create a contra-income (sales) account for something
like "Discounts & Allowances", and then issue a Credit Note for that
Customer with a line item posted to that account. (the Credit Note
itself will post to AR)
Then process a payment and select the Credit Note & Invoice to
offset.
('pay' the invoice with the Credit Note)
Then do a manual transaction between the Discounts & Allowances
account
and your desired expense account. (moving the amount from contra-
sales
to expense)
___
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.
Re: [GNC] Ver 5.5 for Windows import issue
Gyle, Your messages are not appearing twice for me. You may want to log in to your GnuCash Mailman account and adjust the preference for mailing yourself a copy of your own messages. Alternatively, turn off saving a copy of sent messages in your e-mail client, but you may not want that for all messages for that e-mail account, so doing so in your Mailman preferences is likely the best solution. Regards, Adrien On 12/31/23 10:20 AM, Gyle McCollam wrote: As an aside, I see that on my email, outlook.com, all my messages and replies appear twice. Is that happening when you see them and if so, do you know how to fix that? ___ 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.
Re: [GNC] Discount / Coupon question - How to apply?
Is this screenshot taken while viewing the AR account? That error
message usually means you don't have a split in the transaction that is
AR/AP.
Can you turn on View > Transaction Journal and send another screenshot?
Be sure to commit the transaction first, then try right-clicking to
assign the payment.
If it still won't work, you might have to employ some intermediary accounts.
One option is to create a contra-income (sales) account for something
like "Discounts & Allowances", and then issue a Credit Note for that
Customer with a line item posted to that account. (the Credit Note
itself will post to AR)
Then process a payment and select the Credit Note & Invoice to offset.
('pay' the invoice with the Credit Note)
Then do a manual transaction between the Discounts & Allowances account
and your desired expense account. (moving the amount from contra-sales
to expense)
Regards,
Adrien
On 12/31/23 1:38 PM, Alan Johnson via gnucash-user wrote:
Adrien,
I tried that and I get the below error message:
The selected transaction doesn't have splits that can be assigned as a
payment
___
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.
Re: [GNC] Discount / Coupon question - How to apply?
Alan, Create a manual transaction between the desired expense account and Accounts Receivable. (Debit the Expense, Credit AR) Then right click the transaction after committing it, and choose 'Assign as Payment'. In the Process Payment window, select the invoice you want to apply this to and any other relevant info, then commit the payment. Regards, Adrien On 12/30/23 6:16 PM, Alan Johnson via gnucash-user wrote: I have a customer that I have created an invoice for. How do I create a coupon/discount to pay for the invoice and charge it to a marketing expense? I tried to choose the expense account but it will only allow me to use income or liability accounts. ___ 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.
Re: [GNC] GUID Register Codes
That's how I would do it with the XML backend too. If you are crafty with scripts, you can likely create a table/file, mapping the account names to GUIDs for future reference. or, Switch to one of the SQL backends and write a query, or just examine the "accounts" table directly. Of course, in this case, you have the added complication that only the end leaf account names are saved in plain text. But the 'parent GUID' is also stored, so it is possible to sort out similarly named accounts. *note, while there are many ways to view the tables in one of the SQL backends, an easy one is to use the SQLite manager plugin for Firefox with the SQLite3 backend. (it is an older type plugin, so I keep a copy of Waterfox Classic around to use it.) Regards, Adrien On 12/29/23 6:56 PM, Jim DeLaHunt wrote: Stephen: I can't answer your question fully, but I can give you some insight. "GUID" stands for "Globally Unique Identifier". Each GUID is a large number, which is generated in such a way that it is highly likely to be different than any other GUID generated on any computer at any time according to the same rules. On the other hand, the same GUID value might show up in multiple places. Sometimes software developers generate a GUID and embed it their code, so that everyone gets a copy of the same GUID value. Another name for GUID is UUID, meaning "Universally" instead of "Globally". GUIDs are written to SQL databases, but they are not a creature of SQL. GnuCash also generates them when the book file is stored in XML form (as a ".gnucash" file). And, because they are globally unique, it is likely that your book contains different GUIDs than anybody else's book. Each account has a GUID associated, but there is no reason to believe that anyone else will have the same GUIDs for their accounts as you have for yours. I don't have an easy way to find out which GUID corresponds what account or other object. My way of doing that is to save my book as an XML file, open the file with a text editor, and search for the GUID value. Somewhere in the file will be data which defines the account, and it will include the GUID value and account name in close proximity. But that may or may not be the best way for you to proceed. ___ 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.
Re: [GNC] VENDOR REPORT
The LCK (lock) file is created when GnuCash opens to prevent, via warning, someone else (or you) attempting to open the file twice at the same time. (GnuCash does not support simultaneous file access) When GnuCash shuts down normally, the lock file is deleted. When GnuCash crashes, the lock file remains, and upon re-starting GnuCash, you get a warning that the file is 'already open'. If you know this is the case, you can choose to 'open anyway' and proceed as before. However, crashes should not happen and should be reported here and/or filed as bug reports. There is already another thread here posted about a crash related to 'searching' for a vendor, though there were no additional specifics offered. (it could have been in the context of trying to run a vendor report, but that is not confirmed at this time) If you can get the crash to happen repeatedly and reliably with the same steps (clicks), then please file a bug report if you don't find one already filed with that info. Also, check the Wiki on how to obtain a Tracefile on your system as that may be requested for the bug report. (you need to get this file *before* restarting GnuCash after a crash as it is overwritten each time.) Regards, Adrien On 12/28/23 8:18 PM, Panagiotis Klivokiotis wrote: When I try to open a vendor"s report the program closes, a file is created with extension LCK tha does not disappear. Can you help? ___ 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.
Re: [GNC] GnuCash getting worse?
3rd party as far as I am aware. Regards, Adrien On 12/28/23 6:12 PM, Stan Brown (using GC 4.14) wrote: Are the portable apps produced by the GnuCash team or by same third party? ___ 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.
Re: [GNC] GnuCash getting worse?
I'm fairly certain you can create a VM of a running instance of Win10 though I can't speak to how that works for licensing. MS does allow some testing VMs, so perhaps investigate that first and how to set it up to their liking. Another option might be a container like Docker, though I'm not personally familiar with it running GnuCash. Alternatively, though this won't allow testing on Windows, you could test releases either with a Linux VM or with WSL. (Windows Subsystem for Linux) Of course, such testing wouldn't expose a Windows specific bug. On that note, some folks have attempted WSL and GnuCash and the Wiki could use some sprucing up if anyone was interested in that avenue. Regards, Adrien On 12/28/23 12:29 PM, R Losey wrote: I used to run VirtualBox on my iMac (and ran Windows 7). I was just concerned about the running VirtualBox on Windows 10 and emulating Windows 10... I'm not sure I have another copy of Windows 10 to run, nor am I sure that I have enough memory (computer RAM or graphics card RAM) to properly support a Win10 VM. ___ 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.
Re: [GNC] GnuCash getting worse?
I'd offer as a comparison other projects and commercial products where the developers aren't nearly as 'Johnny on the Spot' or as helpful and responsive, or even accessible, but then, that wouldn't be any comparison at all. This dev team is hands down awesome and why I continue to use GnuCash and likely always will. I don't mind the bugs. I get that isn't for everyone, but then, simply don't be so quick to upgrade. That goes for any product, digital or physical. 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 - 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 is "auto asset transfer" used in an asset account?
Good to know, thanks Stan! Regards, Adrien On 12/28/23 6:31 PM, Stan Brown (using GC 4.14) wrote: Some of them, yes. The plus sign and the quote marks no longer work as advertised, for instance. But "site:" still works, at least for now. I use it all the time. ___ 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.
Re: [GNC] Strange bug in Reports after upgrading to 5.4
This sounds like a time zone issue. Long after 2.6.12, at least one bug was discovered where some transactions ended up with an 'internal' date different than the displayed date due to certain code with respect to time zone interpretation. You might have more transactions off than just those on the 1st of the month, but those are illustrating the issue. It will not hurt, if you have not done so, (which *should* have been part of your upgrade procedure) to run Actions > Check & Repair > Check & Repair all on your file. (make a backup first, just to be safe) If that doesn't work, or you have already done so, then maybe one of the devs with more intimate knowledge and better memory of this particular issue can offer advice. Regards, Adrien On 12/28/23 1:19 PM, Leo Braga via gnucash-user wrote: Hi, I'm a long time home user (for personal finances) and I was "stuck" in 2.6.12 for a long time, until deciding to upgrade to 5.4 last month. Everything was looking good, but now I found a very strange bug in my Reports (Expense or Income Charts to be precise). What happens is that some entries dated the 1st of the month are reported in the previous month! So an entry dated Nov 1st is computed in the Expense Over Time report for October, for instance. I don't think this is affecting all entries dated on the 1st of a month, but maybe yes? What I tested is that if I go to such an entry, change it to the 2nd day of the month for instance, *then change back to the 1st*, and then refresh the report, the reporting is now correct! Any help would be greatly appreciated, as it will be crazy to go through all entries for 2023 to fix this (for 2022 and earlier I have different back-ups and thus don't care so much). ___ 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.
Re: [GNC] gnucash crashes on vendor or customer searches
On 12/28/23 2:27 PM, Eric Hammond wrote: I would very much appreciate if you would show somehow how much of this email you would like included in my replies? Eric, Does my quotation amount illustrate the answer? (you can cut out all the fluff & boilerplate, just the part you are replying to is fine for context) Some mail clients have a feature where if you highlight what you want to quote and *then* hit reply-all/reply-list, only the highlighted part will be quoted. That way, you don't have to delete extraneous material before and after. When searching a specific Vendor, gnucash instantly shuts down. The lock is not cleared, but the file is re-openable. For completeness, the lock is never cleared on a crash. You will always get that warning message, but you should still be able to open the file. If not, then that is indeed a serious bug. (or maybe two bugs) Also, read up on the wiki about Tracefiles. You can only obtain one *before* you restart GnuCash after a crash. Thus, if you experience a crash, step 1 would be to get a Tracefile saved (as it gets overwritten every time GnuCash launches) and then document the immediate steps that led to the crash. (every recent click and dialog/tab if possible) And then upon re-launch, try to repeat the scenario/steps to make it crash again. (Repeatable crashes are oddly re-assuring in that it means an explicit set of steps produces the crash, thus the steps can offer a clue on where in the code lies the problem. Random and inconsistent crashes are not fun to track down.) It is also important on crashes (or any bug) to include your OS and version as some bugs only exist in some environments and not others. 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 - 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 is "auto asset transfer" used in an asset account?
Andrew, I could be mistaken, but I think Google dropped support for such advanced searches a few years ago. DuckDuckGo still supports it as far as I can tell. - As to your issue, I could also be mistaken or confused with another feature, but I think auto-interest (not "auto-asset"—that one I've never seen before) is only possible with certain types of accounts, and even then, you need to activate it with a checkbox either when creating the account or when editing it. Once active, it should prompt you for an interest amount, but I don't think it automatically just adds some determined percentage. If I'm correct, I think the time when it prompts is upon reconciliation. I don't recall if it was this interest feature or an auto-payment feature that was not too long ago up for discussion concerning removal. There is a thread (or bug) on it. (or rather on the -dev list than -user) But it may have been left alone as of now for backwards compatibility. - Thanks for putting the subject at the beginning of your post test, but please if it isn't too much trouble, just replace the default subject line instead as I did here. Regards, Adrien On 12/28/23 4:31 PM, Andrew Gross wrote: Hi David, Looked around, didn't see anything. I also tried a google search with the operand "site:gnucash.org" but that didn't reveal anything either. Appreciate your input though. Maybe this is just something new that hasn't been documented yet. ___ 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.
Re: [GNC] Accounts Payable Description Visibility in Transaction/Ledger
Yes, you can do this per bill when you post, or set a global default preference under Preferences > Business > General. Uncheck the option to "Accumulate Splits". This will show each line item on a bill/invoice in the respective transaction in the AP/AR register. When you post, you can also enter a custom description that will show up in the Notes field of the register transaction. (you have to turn on View > Double Line to see it) Regards, Adrien On 12/21/23 12:52 AM, Sean Chadwell wrote: I feel certain this question has been addressed elsewhere, but the closest thing I can find is a thread from 2017, "Transaction Journal View - blank "Memo" instead of Description." When we enter multiple bills from the same vendor, it's easy enough to input a description in the description field, but this only appears subsequently in the bill view. For example, we have a vendor, TES, who issued four different bills, each for airfare for a different person, identified in the description field, but the account ledger shows only 'TES' in the Memo. Is it possible to generate (at least) a report that shows the transaction detail, so that we might see what we paid TES for? ___ 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.
Re: [GNC] Hidden accounts selection is erased when modifying a saved report
In that case, I'd call it a bug. The option is saved in a configuration and yet is being reset. Regards, Adrien On 12/20/23 3:01 PM, Gal Bar Mashiah wrote: I mean that I create a saved report configuration. And it actually saves my options fine. And when I open it from the saved configuration list it loads fine with the correct options. But if now I want to make any kind of new modification on this saved report configuration, it is very cumbersome and confusing because the hidden accounts that I chose when I originally saved it, or no longer selected once I make the modification (which may have nothing to do with the selection at the accounts tab of the report option). ___ 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.
Re: [GNC] Balance column Lost
Each account is referenced by GnuCash, not by its label, but by its GUID. There are ways to find that number for a particular account in case you need to specifically target something in the .gcm file, but in this case it wasn't necessary. Regards, Adrien On 12/19/23 12:21 PM, Stephen Rudolph wrote: The suggestion about editing the .gcm files for column width is solid gold. I've no idea what all the register codes indicate but I'll leave that for another day. Meanwhile, Thanks! ___ 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.
Re: [GNC] Hidden accounts selection is erased when modifying a saved report
What do you mean by 'created and saved'? Saving a report does not save its options as new defaults, just the rendering of the report with those options. A Saved Report Configuration is what you are looking for. If *that* is not really saving your options, then you found a bug. Note, to run a report with the Saved Configuration, you can't just run a default report from the regular menu entries, you have to run the report from the Saved Configuration list. Saving a configuration does not change default options. Regards, Adrien On 12/20/23 9:57 AM, Gal Bar Mashiah wrote: When I create a report that includes hidden accounts, and later open it and modify something in the report options, the selection of the hidden accounts is erased. It may sound like an edge scenario but it happens a lot. For example I have a net worth report that shows the net worth from a time in the post until today, on a monthly basis. To create the report I had to choose hidden accounts of long past closed accounts. Back to the present, now I open the report but I want to change an option - it can be the date range, it can be a new account that didn't exist before, something it is even just displaying the result with a different currency. But when I do it, the accounts selection UI has the "Show Hidden Accounts" unchecked (even though it was checked when the report was created and saved) and as a result, all those hidden accounts get erased from the report after the modification is done. Is it intended? Is it a limitation? Should I create a bug in bugzilla? ___ 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.
Re: [GNC] Is there a way to view a list of unpaid invoices for a customer?
Thanks for the tip on editing the report directly. I prefer something other than 'none' so this will help greatly. Regards, Adrien On 12/19/23 4:37 PM, Glenn Fowler wrote: If anyone wants this to persist, of course you can save a custom report or leave tabs open all the time. What I did was just change the default. The Customer Report is "new-owner-report.scm". Change the line that reads "none" to either "simple" or "detailed" (currently line #923). ___ 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.
Re: [GNC] Is there a way to view a list of unpaid invoices for a customer?
With the Customer Report open, click the Options button. On the Display Columns tab, set Transaction Links to Simple or Detailed as desired. That will show which invoices are paid by which payments and which payments apply to which invoices. It isn't a list of *only* those unpaid, but it does give you the info. - Another option is to run a Find Invoice and set two criteria for matching the Customer Name and Is Paid? unchecked. (meaning show those not paid) That will get you a list of all invoices not paid in full. (partials will show as unpaid) Unfortunately, you can't copy/paste or print that list outside of the Find window. It is onscreen only. Regards, Adrien On 12/19/23 2:25 PM, Glenn Fowler wrote: I have searched but so far I have not been able to find a way to simply view a report of a listing of unpaid invoices for a customer. The receivables aging report just shows the total dollar aging amount. The customer report shows the total running debits and credits, but you would have to manually match up the credits with the invoices to simply figure out which invoices are open. How are others figuring out which invoices are open and unpaid? ___ 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.
Re: [GNC] Accounting Period Change issue
Instead of going the desert route, ever tried Cumin and Cayenne on them? That's great for sweet potato chips too. Regards, Adrien On 12/19/23 9:35 AM, Kalpesh Patel wrote: Honey Butter Cinnamon Sweet Potato Fries, please … two of them. ___ 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.
Re: [GNC] Upgrading from 2.x
First, what operating system and version are you using? Windows, MacOS, Linux? Newer versions of GnuCash will only work on newer versions of your operating system. From the main website: "Version 2.6.21 is the last version for Windows XP/Vista and MacOS X 10.8 and earlier, and so the last version that will run on PowerPC Macs." and "Version 3.11 is the last version for Windows 7 and MacOS 10.12 and earlier. " The code that determines the appearance of GnuCash changed significantly between 2.6.21 & 3.0. That introduced some appearance issues in some cases, but all are fixable. Since you were able to update to 3.11 and it runs, I'd say you could at least get that far if you want. We can help with the appearance issues. - The exact error message you are receiving would help us help you better. If it is too much to type or it won't let you copy and paste it here, try taking a screenshot of that window and attaching it to a reply. (do not paste it into the message. Use your e-mail application's attach function) There is such a thing as placeholder accounts, but those don't affect 'folders', or stop you from accessing the file itself, they just prevent you from entering transactions in those placeholder accounts. There is also something called a Lock File. That prevents you from accidentally opening the same GnuCash file using different computers or users at the same time. If GnuCash doesn't shut down cleanly, that lockfile can get 'stuck' and you will get that message next time you try to open it. (GnuCash normally deletes the lockfile when it cleanly closes) If you know the file isn't otherwise open, just click the option to Open Anyway and GnuCash will proceed as normal. - As for the *need* to upgrade, that is up to you. There have been hundreds if not a few thousand bugs fixed since 2.6.21 as well as many, many other various improvements. But if you are happy with how 2.6.21 works, I can't think of a compelling reason to upgrade otherwise. Though others here might have some good ideas to take into consideration. Regards, Adrien On 12/19/23 9:32 AM, Dianna Broughton wrote: I've been using version 2.6.xx (11, I think) for a long time, but read the recommendation for everyone to upgrade to a newer version. I also read the recommendation to upgrade in steps from the last stable release of each version to the next: 2.6.21, 3.11, 4.14. I was able to update to 2.6.21 without any issues. However, whenever I try to upgrade to 3.11 (I also tried 3.1), it doesn't work right. The font is very small, the appearance is wonky, and when I try to access some folders, it says it's not available and I need to take it out of placeholder mode (not exact wording) in order to access the file. Has anyone had problems like this? Any advice? I'm happy with the current version - do I really need to upgrade? ___ 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.
Re: [GNC] Gnucash 5.5 Windows - included Net Worth Linechart report now crashes the UI
This is the second thread about reports crashing on Windows. I'm not sure if that is relevant, but like the other thread, I just tested the Net Worth Linechart with a simple file using the flatpak in a Linux VM and it does not crash. It produces the Linechart as expected. So this is either something Windows specific, or specific to your book. Regards, Adrien On 12/19/23 2:04 AM, WR D wrote: Hi, Installed Gnucash 5.5 for Windows. I notice that running the included report Net Worth Linechart (under Assets & Liabilities) almost immediately crashes the UI - no message that I can see. The LCK file is left open as well. I found this out when I tried to run one of my saved report configurations which was based on this one. I deleted the custom configuration and just tried to run the default one but see same behaviour. This was not a problem under 5.4 ___ 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.
Re: [GNC] ANNOUNCE: GnuCash 5.5 Released
I just tested the flatpak in a Linux Mint Vanessa VM and it works fine with no crash. I am getting some console messages when it runs reports that seem to indicate some issues, but the report(s) otherwise show up just fine. Those could just be specific to flatpak. Your crash is either Windows specific, or specific to some data in your book. Regards, Adrien On 12/18/23 8:12 AM, Glenn Fowler wrote: Hi, I checked and it's the same - GnuCash crashes and I see the report in .\AppData\Local\Temp Are you able to access the customer report on v5.5? ___ 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.
Re: [GNC] Balance column Lost
Your welcome, and I'm glad you were able to recover the column. Your suggestion sounds like a good idea. But what would be even nicer would be a menu option to restore default widths for any register in one click. (this is currently possible with invoice/bill column widths, but not registers, though I think that was being worked on at some point) Regards, Adrien On 12/19/23 2:33 AM, Paras Desai wrote: Hello Adrien Thanks a lot for sparing your time to check on my problem. Really appreciate your support. I did what you have suggested and i could get back my balance column and along with the balance amount in my bank account ! 😁😁. This made me think, in order to prevent this from recurring by some careless guys like me, is it possible to restrict the width of each column to a minimum dimension of pixels? This way we can prevent it from accidentally disappearing. Some suggestions are easier said than implemented though ! And i do understand that. ___ 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.
Re: [GNC] Can I print an account?
In addition to the Transaction Report (and a ScreenCap by various methods), there are two other options: 1. Use View > Filter by... to set the range of transactions you want visible in the register, then run Reports > Account Report. 2. While the main Accounts tab is in focus, do a Find for the transactions you want, then from the search results, run an Account Report. Regards, Adrien On 12/18/23 5:58 PM, Simon Roberts wrote: Hi all, I'd like to be able to print a range of transactions in a single account. Essentially just a dump of what I see on the screen, though I suppose I would need to select a range of rows and the columns that should be in the output. Can this be done? Is it one of the business reports? My accounting background is essentially nothing, so it's entirely possible I don't know what one of them might do, though I believe I've tried all the options. ___ 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.
Re: [GNC] Accounting Period Change issue
If it is intended to redraw-refresh and is not, then certainly, I'd call that a bug, otherwise, a Request For Enhancement. Regards, Adrien On 12/18/23 2:11 PM, Kalpesh Patel wrote: Hmmm! For 1) see the attached jpg. It describes the situation that no one wants to be in (fyi - I am current practitioner in IT/Systems/Engineering/Software world) ... it's a defect; not a bug. For 2), if I am spending energy to change it deliberately then I want to see updated values; why else would I be making that change? Definitely not to have a self-exploding time bomb for the future. It is a refresh/redraw issue and is not an error in calculation issue, as it does eventually displays correct values. ___ 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.
Re: [GNC] Updating GnuCash
Yes. Regards, Adrien On 12/18/23 11:56 AM, Edwin Booth wrote: I just downloaded the GnuCash 5.5-1 onto my MacBook. This is the first update I’ve downloaded (currently running 5.4 but am still pretty new to it all—including the Mac). What do I do to update the program? Do I slide the icon over to Applications now and replace the current version with the new one? ___ 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.
Re: [GNC] ANNOUNCE: GnuCash 5.5 Released
Does it work on 5.5. if you run an Aging Report and then click the total amount for a customer to get a Customer Report? (just curious about different paths to the report) Regards, Adrien On 12/17/23 9:18 PM, Glenn Fowler wrote: Hi, I just installed 5.5 on Windows and I noticed when opening a Customer Report (from the customer overview screen of all customers, double-clicking any customer to bring up the customer report) crashes GnuCash. In ..\AppData\Local\Temp I do see the report there. gnucash.trace.##.log is empty. Rolling back to the last 5.4 stable build ( gnucash-5.4-2023-12-13-git-5.4-156-g273c961fc4+.setup ) works as expected and the customer report opens. ___ 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.
Re: [GNC] Size of description column not shrinkable?
Yes, the Description/Memo columns spring back. Always grab the right handle and drag left and they will snap to fill the remaining space. You *can* specify the widths numerically, but you have to edit your .gcm file by hand to do so. See the wiki for the file location on your OS: https://wiki.gnucash.org/wiki/Configuration_Locations Double-clicking will auto-size to fit. And yes, the tab bar is shrinkable using a CSS file. (basic info also in the wiki) Regards, Adrien On 12/17/23 4:07 PM, Elmar wrote: Tried that - and godlings, the tab bar is huge and not shrinkable at all. I'll try the font thing, because at the moment, it tries to crunch the last column often cutting off the "cents" of the totals, and there is no obvious way to specify the default widths of any column numerically or by double clicking on the column header to make it auto-magically adjust to fit all its entries. I gather that the description column has a "spring" width, then, i.e. it takes whatever it can get? ___ 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.
Re: [GNC] Balance column Lost
Paras, I just broke mine to learn how to fix it for you! 1. Close GnuCash 2. Go to this page on the wiki, and open the file location diagram for your OS: https://wiki.gnucash.org/wiki/Configuration_Locations 3. Look for the location of the .gcm files. 4. Navigate to that location in your file manager and open the .gcm file that corresponds to the name of your book. 5. Open it with your favorite text editor, preferably one with Find ability. (are there any text editors that can't 'find'?) 6. Search for "balance_width=1" or "balance_width=0" where that search text appears in one of the Register... sections. 7. Set it from 1 or 0 to something similar to what you see in another register section. For example, I seem to have lots of balance columns set to 83 or 94 px. 8. Save the file 9. Open GnuCash and you should see that register with a restored balance column. Regards, Adrien On 12/17/23 12:04 PM, Paras Desai wrote: Hello Gyle Thanks for your reply . I did try that too. The problem is, line parting balance column and credit column are so overlapped, i am unable to separate them. So when i adjust other columns, scroll bar does appear at the bottom, but still balance column is not visible. It appears that in my quest to adjust column width manually, i have lost balance column irreversibly, or that is what it appears to me. As i have tried every suggestions i could find. ___ 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.
Re: [GNC] Wrong Total(Period)
I'm not familiar with how it works with multiple currencies, but at first glance, that looks like the sub-accounts are rolling up to the parents, which is as expected. Regards, Adrien On 12/13/23 7:10 PM, Fred Tydeman wrote: OS: Fedora Linux 36 GnuCash: 4.14 Looking at the expanded Chart of Accounts, Total(Period) shows a non-zero amount for a specific Income account. Yet, all of the accounts and sub-accounts involved have 0 for Total(Period). There are no transactions for this year for any of these accounts. I have also run an Income Statement for just those accounts for this period, and it shows zero. Accounting period is Start of this year and End of this year. The accounts are a mixture of USD and COP. Assuming the screenshot makes it to the list, the columns are: AccountName Description Total Total(USD) Total(Period) Both of the accounts Colombia and Interest have zero transactions in them. ___ 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.
Re: [GNC] Nice to Have?
No Stan, they aren't talking about not showing them at all, but rather showing those not due to fire or due to be reminded, for that same day, in the Since Last Run (SLR) dialog. See the screenshot Grace posted. This isn't the editor, this is the SLR dialog. Also see my other post threaded under Derek's reply. I didn't see non-pertinent SXs until I played around with the checkbox to not remind me. (which initially worked) After resetting it, now I get all Enabled SXs showing up in the SLR and I can't make them go away. Regards, Adrien On 12/14/23 5:34 PM, Stan Brown (using GC 4.14) wrote: I've _never_ had that happen. When I fire up GC for the first time of the day, if there are any transactions firing that day, then a panel pops up showing those and only those. If none are firing that day, nothing pops up. When I open Actions > Scheduled Transactions, _then_ I see all the scheduled transactions. I think it would be very wrong to show only the ones scheduled to fire today, because then there would be no way to edit an existing scheduled transaction that is scheduled to fire in the future. Upon opening GC, if Grace is actually getting transactions popping up that are not supposed to fire today, I wonder if perhaps she has set them to repeat every day. ___ 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.
Re: [GNC] Monthly Expense summary Report
It works the same on MacOS (with CMD). If you only want Income & Expenses, click Clear All. Then collapse the tree completely so you can see the main accounts. Select Expenses and click Select Children Holding Ctrl/Cmd, Select Income and again (still holding Ctrl/Cmd) click Select Children. If you then release Ctrl/Cmd and click Apply, you should see your report update accordingly as desired. You can also control the depth of accounts shown. Regards, Adrien On 12/14/23 3:06 PM, Murugan Muruganandam wrote: You can select Expenses and Income with Child using Ctrl key i am in Windows 11, GNC 5.4 ___ 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.
Re: [GNC] Nice to Have?
Yes. Regards, Adrien On 12/14/23 2:47 PM, Mark at Lorimark wrote: Did you close the program and re-open it after resetting the option? ___ 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.
Re: [GNC] Nice to Have?
This is weird. I managed to trigger this complete listing, but now I can't fix it back. At first, my Since Last Run (SLR) showed only a list of reminders and created SX. After playing with the option to remind in advance, unticking it removed that SX as expected as it wasn't yet time to fire. But setting it back, and re-running the SLR, now all Enabled SX are listed (below the Reminders unlike Grace's screenshot) and I can't seem to make them go away and get back to the original behavior. Regards, Adrien On 12/14/23 2:35 PM, Adrien Monteleone wrote: It looks like that is what Grace is already referring to by the screenshot. I'm not even sure how to show all SX on that dialog, even those not set to remind or auto-create yet. If I set a window or untick the option entirely, they don't show up. If there are none for the day, I get that notice instead of a list. ___ 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.
Re: [GNC] Nice to Have?
It looks like that is what Grace is already referring to by the screenshot. I'm not even sure how to show all SX on that dialog, even those not set to remind or auto-create yet. If I set a window or untick the option entirely, they don't show up. If there are none for the day, I get that notice instead of a list. Regards, Adrien On 12/14/23 11:27 AM, Derek Atkins wrote: The "Since Last Run" dialog is what you want -- it will display all the SXes that are being processed "today". ___ 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.
Re: [GNC] Nice to Have?
I take it back. There are global preferences under Preferences > Scheduled Transactions but as far as I can tell, the auto-create and notify window periods are only for 'new' SX as defaults. You can still individually change these. Regards, Adrien On 12/14/23 10:49 AM, Adrien Monteleone wrote: I don't think this is configurable for all transactions together. It is a case-by-case basis. ___ 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.
Re: [GNC] Nice to Have?
Yes, that is called the Since Last Run dialog. You can also fire it manually under the Actions > Scheduled Transactions menu item. I just tested it on 5.4 and the behavior for me has not changed. If I untick the box to remind me, and there are no SX for today, instead of the list, I get a notice that there are none with an 'OK' button to dismiss the dialog. I never see a list with all of my SX shown. Only those that are set to remind and/or auto-create or due to be created show up. And as for the 'cancel' button creating them anyway, I do not observe that behavior *unless* that SX has been set to 'auto-create', and as you should observe, for those the Since Last Run shows 'created' for those SX. (and 'reminder' for those not yet fired) Regards, Adrien On 12/14/23 2:23 PM, Kalpesh Patel wrote: I think Grace means that when you fire up GNC, it displays scheduled transaction window which has all of the transactions configured in that book. She (and I) think just displaying what is being added at that firing up should display only for the ones that are applicable for that fire up and not any other ones that are scheduled further in the future from now. I even go one further and say that if there aren't any to be applied then it should not display the window at all (perhaps another configuration parameter to add). ___ 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.
Re: [GNC] Monthly Expense summary Report
Either of those reports (Transaction or Budget) should allow you to select any accounts you want. Regards, Adrien On 12/14/23 12:19 PM, Alan Johnson via gnucash-user wrote: Thanks, That will work. Only annoyance is that I can't seem to select both income and expense at the same time, requiring two reports. The default had the asset and liability accounts selected, which was not needed. ___ 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.
Re: [GNC] How to change date of balance on register?
A Filter on the view might get close to what you want. Regards, Adrien On 12/14/23 9:13 AM, Alan Johnson via gnucash-user wrote: It would be nice of one of those options was customizeable - say 30 or 60 days or a chosen date out. ___ 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.
Re: [GNC] Monthly Expense summary Report
The Transaction Report can group by period with subtotals and totals. That is a listing of each transaction though. You can likely reduce detail, but there should be a summary table you can turn on which might get you close. Also take a look at the Budget Report multi-period feature. If you don't want the actual budget features, you can still use the report to show actual expenses. This report presents a column for each period by account. You also get a YTD total column if you want it, and can collapse previous/future periods from the one you want to focus on. Regards, Adrien On 12/14/23 9:17 AM, Alan Johnson via gnucash-user wrote: Hello, Is there a way to have an expense report that breaks out the columns by week and/or month? Other software will allow me to display the expense category for each month/quarter/week/chosen grouping period and then sum them at the end. For example, In this report I could see how much I spent on Expenses:Auto:Fuel for Jan/Feb/Mar.../Dec and then the Year on one screen without having to run 12 different reports. I don't desire to have each transaction for those months, just the summary of the amount spent in each category for the month/week/quarter. ___ 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.
Re: [GNC] Nice to Have?
If I'm not mistaken, that is part of the setting for each Scheduled Transaction. You set how many days in advance you want it to remind you. If you would only want same-day, I'm hazarding a guess that "0" days would work. If that doesn't, try "1" day. I don't think this is configurable for all transactions together. It is a case-by-case basis. Regards, Adrien On 12/14/23 10:19 AM, Grace wrote: I don't know if this is the correct place to ask for a "Nice to Have". My request is that the window that displays scheduled transactions to be posted today, could only display those transactions being posted today. At the moment it displays all the scheduled transactions. For me it would be nice if it just showed those being processed today. ___ 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.
Re: [GNC] Linux Mint version of Gnucash 5.4 Stopped Generating Reports
Wait, I see now you say you are running 5.4, but the build ID is for 5.3. Definitely get that squared away first. Regards, Adrien On 12/14/23 12:12 AM, Larry Nagel wrote: My apologies in advance because I think this question has been asked and answered. I have been running gnucash on Linux Mint and Windows forever, and I am a fairly low impact user. I only run reports when it's time to see the tax man, so I don't know when simple stored reports like Profit and Loss and Balance Sheet stopped working. I presently have flathub 5.4.1 running on Linux Mint 21.2. These same reports work fine on the Windows version of gnucash [ Version 5.4 Build ID: 5.3-412-g53245caebf+(2023-09-23) ]. I'm obviously not copying something to the correct location on the flathub version. ___ 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.
Re: [GNC] Linux Mint version of Gnucash 5.4 Stopped Generating Reports
There was an issue with reports at one point, but I thought by that build it was fixed. There is another list thread if I'm not mistaken covering which build the fix first appeared in. Maybe see if you can find it and double check against your install. If you don't have the latest one, grab that one and try again. Regards, Adrien On 12/14/23 12:12 AM, Larry Nagel wrote: My apologies in advance because I think this question has been asked and answered. I have been running gnucash on Linux Mint and Windows forever, and I am a fairly low impact user. I only run reports when it's time to see the tax man, so I don't know when simple stored reports like Profit and Loss and Balance Sheet stopped working. I presently have flathub 5.4.1 running on Linux Mint 21.2. These same reports work fine on the Windows version of gnucash [ Version 5.4 Build ID: 5.3-412-g53245caebf+(2023-09-23) ]. I'm obviously not copying something to the correct location on the flathub version. ___ 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.
Re: [GNC] How to fix Accounts Rec'ble aging? (have a prepayment & an "unpaid" invoice that cancel each other)
You could have also simply clicked both the prepayment and the desired invoice and the payment would have been applied to it. This is the same way you'd otherwise handle pre/overpayments that need to be later applied to invoices. Regards, Adrien On 12/13/23 2:32 PM, Eric Chapman wrote: I've attached some screenshots. When I run a customer report, the aging at the bottom is messed up, apparently because a payment has somehow been recorded that was not associated with the invoice. When I launch GnuCash, a splash screen tells me there is an unpaid invoice. [Pause while getting screenshots …] Ohhh! I found it: Go to the Accounts Receivable ledger and find the "prepayment" - the payment there on the same day as the invoice. Delete it. Return to the Invoice and click "Pay" and record a payment as usual. Now all is well. Sorry to bother you with this question, but I think I'll post it just so it's there for future reference if I forget how to do this! :) And maybe it'll be useful to someone else, too. ___ 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.
Re: [GNC] Easier way to jump to specific tab/register in main window
On MacOS at least, this does not work once you hit the Accounts tab. At that point, the tab takes input as if you are doing a visible-text search. There is no way with the keyboard to navigate off that tab again. (so far as I can figure out) (v5.4 on Monterey) Regards, Adrien On 12/12/23 7:19 PM, Glenn Fowler wrote: Another keyboard shortcut you may find useful is CTRL + ALT + PAGE UP/DOWN will cycle through your tabs. ___ 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.
Re: [GNC] UI Problem with 4.14
The label is there, but only in Basic View. Split & Transaction Journal do not have it. I'd say that is a bug. Regards, Adrien On 12/11/23 4:21 PM, Manfred Usselmann wrote: Yes, but then much more screen space is used. The border is there even with single lines, just without a visible border line. When you move the cursor there it changes to the double arrow indicating the possibility to resize. I believe the border is missing because the header text for the accounts column is missing. Yesterday I saw the header text for some accounts but it went away after a while. Very strange. ___ 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.
Re: [GNC] Definition of document root
As Jim mentioned—good suggestion. I too think it would be more flexible as a book-preference. This does sound familiar, so it may be an existing bug/rfe, or maybe it simply has been brought up on the list before. Regards, Adrien On 12/10/23 9:17 PM, Brook Milligan wrote: The root path to the set of documents that can be linked to Gnucash transactions can be set via the “settings” menu. However, this seems to be a global value; i.e., it applies to all book files. That is fine if there is a single location in the file system for documents for all books, but it seems much more logical to store books and documents together in their own directories. This suggests that the root path for documents should be a book-specific, not a global, attribute. Ideally, it would be possible to have a global value that can be replaced by a book-specific value, as that would retain the current behavior yet accommodate the more natural (at least to me) organization of all book-specific things together. ___ 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.
Re: [GNC] iPhone or iPad app
There is no official app other than the main GnuCash app for desktop. Anything else you find is a 3rd Party project. Regards, Adrien On 12/10/23 12:36 PM, Edwin Booth wrote: Do either of these apps work at all? It just says “Import” when I open the app, but then doesn’t do anything. I’d like to be able to input a cash purchase to go into my laptop app at a later time. ___ 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.
Re: [GNC] overdue column in customer/vendor overview
Try the Receivables Aging Report. You can keep that tab open at all times and just refresh it occasionally. If you want to see individual invoice and payment info for a customer from there, click the total owed for that customer and a Customer Report will show up. Depending on the detail level you choose, you can see which payments were applied to which invoices, and can drill down to the invoices themselves from there if need be. Also consider creating a multi-column report with this as one of the displayed reports. See the 'Dashboard' example. I have one set up with both AR & AP always visible on the same tab. (among other reports) I personally don't find the Overview very useful in its current state. It is essentially just a list. (you can't even export it or copy & paste it anywhere) Regards, Adrien On 12/10/23 5:47 AM, Mattia Rizzolo wrote: Hello, I know that what I want is partially covered by the "Invoice due reminder" e "Bills due reminder", but I think I would like to have in the customer/vendors overview a dedicated column for this. One with the total current balance, and one with the currently overdue invoices/bills, especially as this would let me sort late customers by "how much they owe me". Is this something possible, or doable? ___ 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.
Re: [GNC] Business Income Statement: manipulating Cost of Goods sold
My first exposure to Income Statements (dubbed P&L in this case) was in the restaurant industry. Many of those businesses also put COGS as a 'top line' expense. But note, it was never part of the Income section. The organization was something like: Revenue Gross Sales Discounts & Allowances Net Revenue Cost of Goods Sold Labor & Salaries Gross Profit Other Expenses EBITDA Interest Income Tax Depreciation Net Profit The Income section ended at Net Revenue. COGS & Labor were top-line expenses for several reasons but the main two were to have them stand out since as the largest controllables, and to isolate the remaining expenses for the owner to focus on the rest as 'fixed costs'. (though many of them were of course somewhat controllable) EBITDA was what management focused on as their 4th target. (Gross Sales, COGS & Labor being the other 3) What you see above, and what you seem to be looking for is a P&L used in 'Managerial Accounting'. There are other forms of this same report used in other industries. For example, some are organized by Department or Cost Center. But in any case, the organization of the Chart of Accounts does not change to match presentation. Accounts don't magically switch from Expense to Income simply because you want to move them around on the report page. Accounts belong where they do because of the nature of what they are recording. Regards, Adrien On 12/9/23 5:40 AM, Eric Chapman wrote: Thank you, Adrien. I knew it was a presentation issue, and was trying to figure out how to present it correctly and yet be able to use GnuCash as I *wanted* to :) I also realize the importance of the inventory accounts and the theory behind this. I just know that the amounts and number of transactions are minuscule at this point, so I was trying to cut corners. Maybe not a good move. Second smiley :) I was surprised that GnuCash limits the user's ability to debit an income account from the Accounts Payable section, so I guess that was where I scratched my head and wondered… No biggie. I suppose that feature is intended to prevent inadvertent debits to income accounts, which I can understand. I can deal with that limitation (feature) in GnuCash. And I may just go back and re-do those few transactions with inventory accounts. I agree that COGS is an expense account. But as far as I know it is either usually or always presented in the income section of the Income Statement, not in the expense section. I would have thought, though, that the "Income" or "Expense" attribute would be irrelevant to *where* something is presented: *I expected the parent-child hierarchy of the Chart of Accounts would control presentation*. I only marked the COGS accounts as "Income" after finding out the parent-child hierarchy is *not* the deciding factor in presentation, since I perceived that the "Income" attribute would put them in the income section of the Income Statement. I'm sure it makes sense from a programming perspective since the storing of data under the hood should not be determined by possible reporting desires. I probably won't put in the effort to learn Scheme – as much as I'd like to. Not enough time available for the benefit. ___ 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.
Re: [GNC] Search not working
More specifically, not just 'within the register' but it will only search in splits tied to that register. So if you have the Bank Account register open and you do a find, but that info is not in a Bank Account split, but say an expense account split, GnuCash will not return it in the results. Regards, Adrien On 12/8/23 5:59 PM, Stan Brown (using GC 4.14) wrote: Also make sure you press Ctrl+F while you're in the Accounts register. If you're in any other register, GC will search only within that register. ___ 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.
Re: [GNC] Business Income Statement: manipulating Cost of Goods sold
Cost of Goods Sold (COGS) is an Expense account, not Income. What you are looking for is a different type of Income Statement that does not exist in GnuCash. (the basic math is the same, you just are looking for a 'Net Sales' figure by moving COGS to the upper part of the report. This is merely presentational and does not change the nature of COGS being an expense rather than an income account. Your options are: 1. Write your own report. (not easy, and you'd have to learn Scheme) 2. Manipulate the existing report in a spreadsheet app. (still work, but much easier and little-to-no learning curve) Also, generally, you *do* want inventory accounts because purchases are *not* the same as COGS. Here are some generic transactions: Acquisition of Inventory Dr. Assets:Inventory Cr. Assets:Cash (or Credit whatever account you used to pay for the inventory) Sale of Inventory - Dr. Assets:Cash Cr. Income:Sales Accounting for COGS --- Dr. Expenses:COGS Cr. Assets:Inventory (can be a separate transaction if using the Business Features, or all together in one with the sale if done manually) Buy or find a good Accounting 101 book, and be sure to get official professional advice. Regards, Adrien On 12/8/23 1:57 PM, Eric Chapman wrote: (Note 1: I hope the mailing list presents this with fixed-width characters. If it does not, but sample below of a tax form will not appear as I intended it to.) (Note 2: The three attached screenshots might help you understand my question. I hope they are small enough to come through.) In GnuCash 5.4 I have a Chart of Accounts / Account Tree that reflects Schedule F of Form 1040 for reporting of farm business. I use the business feature "Accounts Payable." Here is how part of it looks: 1a Sales of purchased livestock and other resale items $.xx <-- my sales of resale items account 1b Cost or other basis or purchased livestock or other items reported on line 1a xxx.xx <-- I have 3 Cost of Goods Sold (COGS) accounts that are to be here (should be income account with debit balance [negative]) 1c Subtract line 1b from line 1a $.xx My problem: In the Chart of Accounts / Account Tree I set up the COGS accounts as "income" accounts. As such, in v. 5.4 the COGS accounts were not on the drop down list of "expenses" to debit when recording purchases. So I changed the tick mark for them and called them expenses. They worked fine. But now when I print a report, the COGS accounts are listed down in the expense section of the Income Statement, not up under "1a" as they should be (and as they are "parented" an "begotten" in the Chart of Accounts / Account Tree). These are the workarounds I see: (1) Change the 3 COGS accounts back to having the "Expense" attribute before printing reports. (2) Debit all COGS items into inventory accounts and later make journal entries (transactions) from that inventory account to the COGS accounts. I realize this is normal (maybe desirable, but since I'm using all of those COGS items immediately, I thought I'd save time and not use inventory accounts. What I'd like: The ability for the accounts called "Expenses" but used for COGS to be debitable when entering "Bills" (invoices issued to me by vendors). Are there better ways to do what I want to do, or an option to tweak GnuCash so that I can debit those accounts as I want to? ___ 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.
Re: [GNC] UI Problem with 4.14
The border between the Account and Reconciliation column does exist, but you have to turn on View > Double Line to see it. And thanks for the tip about double-clicking. I forgot about that part. Regards, Adrien On 12/7/23 7:55 PM, Manfred Usselmann wrote: There is one additional difficulty which is that there is no border line between the heading of the account column and the reconsiliation column. So it is easy to resize the reconciliation column when in reality you want to change the width of the account column... There is also the possibility to double click on the right border of the column headings to adjust the column width in such a way that the content of the column becomes fully visible. ___ 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.
Re: [GNC] Business: return of goods to vendor with refund to credit card
You are welcome, and thank you for the kind sentiment. I try to help out when and where I can. Regards, Adrien On 12/7/23 2:06 PM, Eric Chapman wrote: Thanks, Adrian. You are a good and thorough teacher and a great asset to this list. Eric ___ 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.
Re: [GNC] UI Problem with 4.14
On 12/7/23 2:07 PM, Robert Heller wrote: At Thu, 7 Dec 2023 13:46:19 -0600 adrien.montele...@lusfiber.net wrote: The Description column always fills the remaining width of the window. You adjust the other columns to your liking, then reduce the window width to shrink the Description column. Otherwise, you can after setting the other columns, drag the right handle of the Description column to the left and let it bounce back to fill the remaining space. So how do a make the columns to the right of the Description column wider? Do I drag them off the window? This actually makes no sense. Yes, that's how you do it, sort of. And if you try, it does make sense as you see it happen. For example, to widen the Account column, drag its right border to the right. (up in the header) The column will widen accordingly, and you will get a left-right scroll bar at the bottom of the window. Resize all columns *other than* the description to your liking, *first*. Then, to remove the scroll bar and size the Description to take up the remaining space of the window, (Window Width - Sum of all *other* Column Widths) drag its right-border to the left and let it snap back into place. (hence it auto-sizes) OK, I am totally confused. How do I make a column to the right of the Description wider *without* draging the right handle of the Description column to the left? See above. I don't want to *shrink* the columns to the right of the Description, I want to make one of them wider. How does one do that without shrinking the Description column? Where does the space come from? How does one add space? You are 'adding width' as you resize the other columns which triggers a scroll bar. You then snap the Description column back and the scroll bar goes away. What is happening is that there is some total window width W, which is the sum of widths of all of the columns (plus the margin space). If one wants to make some column Cx wider, some other collumn Cy needs to shrink, but this is impossible if the only column that is "shrinkable" (Cy) is the Description column. I can make columns to the *left* of the Description wider or narrower, but not the columns to the right of the Description. Any attempt to make any of them wider ends up making them all narrower until eventually one (or more) of them end up with a width of 0. As far as I am concerned, this is a bug (and a serious one at that). This makes no sense. Yes it does - try it and stop thinking about it. I have the source code and will go hunting... No need for that rabbit hole. Just follow the above. Note, this behavior is described in the Help manual and as Stan noted, there is also an FAQ entry about it. If you really want to see the code, go right ahead, but you're just going to discover what I've described above and is already documented behavior. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Business: return of goods to vendor with refund to credit card
I can't speak to your chosen solution, but to do this with a Credit Note: 1. Raise the Credit Note, assigning the line items to their proper Expense accounts. This will result in Credit entries (right column) in those affected Expense accounts, where normally Expenses are Debits(left column) 2. Post it to A/P. This will result in a Debit entry (left column) in the A/P account, where normally, you see Credit entries (right column). e.g., a typical posted Credit Note from a Vendor will result in: Dr. Liabilities:Accounts Payable Cr. Expenses:stuff 3. 'Pay' the Credit Note with your Credit Card account. This is the transaction which is the actual refund to your card. If you have already entered this refund manually, simply right-click it and 'Assign as Payment' searching for the Vendor and selecting the Credit Note to clear it. This will result in a Credit entry (right column) in the A/P account, with a Debit entry (left column) in the Credit Card account. e.g., a typical refund on a Credit Card against a Vendor Credit Note will result in: Dr. Liabilities:Credit Card Cr. Liabilities:Accounts Payable I personally only use Debit/Credit labels because I find them consistent and easier to understand than the various 'slang' terminology of the informal labels. (which don't always make sense in every situation) Regardless of the terms used for the column headings, the left/right nature does not change. (hence why I specified which they should be) Regards, Adrien On 12/7/23 1:21 PM, Eric Chapman wrote: Story: I bought some items locally in September. I returned a portion of them in November and the vendor was willing to issue a refund for the items I decided I did not need. The refund was made to my credit card. I tried to use a "Credit Note", but could not figure out how to make it work. Is is just the same as an invoice, except that it automatically puts the amount in the "Refund" field? What other differences are there? When I checked my vendor report for that vendor, I had mismatches and amounts in the aging columns. Therefore I just deleted the "Credit Note" and input the return/refund as if it were a bill (invoice from vendor). I put in negative amounts. Worked fine. I clicked "Pay" and "paid" the negative amount to the credit card. Everything looks correct to me. Is there a reason why this methodology is not good? Any other advice? ___ 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.
Re: [GNC] UI Problem with 4.14
The Description column always fills the remaining width of the window. You adjust the other columns to your liking, then reduce the window width to shrink the Description column. Otherwise, you can after setting the other columns, drag the right handle of the Description column to the left and let it bounce back to fill the remaining space. If you still find Description longer than you want, and you don't want to narrow the width of the window, adjust the other columns accordingly. I usually adjust the Account column wider in such cases. This is nothing new in 4.14, GnuCash has worked this way for many many years. Regards, Adrien On 12/7/23 12:57 PM, Robert Heller wrote: I have a UI problem (failure?) running GNC 4.14 under Ubuntu 22.04. I tried to shrink the Description column (make it narrower) in the general ledger display of an account, but Description column only wants to get wider. Draging the right edge to the left just "bounces" further to the right, causing the columns to the right of the Description column to shrink. How do I fix this? I tried exiting and restarting, but the column widths seem to be "remembered" somewhere (where?). ___ 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.
Re: [GNC] Advise me please: go up to 5.4.2 or stay at 4.13?
Correct. The extra processes were on Windows only. The Mac version is fine otherwise. Regards, Adrien On 12/7/23 9:42 AM, Eric Chapman wrote: It does not: I'm running GnuCash on the Mac side! So I'm OK, I guess. ___ 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.
Re: [GNC] Selling an unpaid invoice to another business at face value?
The amount owed stays in AR. Who owes it is what changes. How you do that is not specific to GnuCash. You will likely have to employ intermediary accounts, but what those should be, are up to you and your needs/requirements. Perhaps ask a local CPA. Regards, Adrien On 12/6/23 7:01 PM, Morgan Read via gnucash-user wrote: Hi Andrew, Many thanks for coming back. I think perhaps that in an attempt at brevity, I assumed too much in my example and perhaps wasn't as clear as I might have been. There are three entities in my example, but in yours there are 5. Perhaps the confusion arises because the 'I' in my example is an active party, whereas the 'you' in yours seems to be a passive observer. I thought it might help to fill in some of the gaps in my example - there may be well be more:- 1/ Two shoe boxes - one marked 'invoices due' the other marked 'invoices not due'; 2/ Three entities - 'I', Entity-A for whom I do work and Entity-B to whom I sell the right to collect the debt for the work done for Entity-A; 3/ Two invoices - my (I's) invoice to Entity-A (Invoice-A) for the work done and my (I's) invoice to Entity-B for the sale of the right to collect the above debt; 4/ Invoice-A is generated on the completion of the work for Entity-A, and placed in the shoe box marked 'invoices due'; 5/ Invoice-B is generated on the sale of right to collect the debt to Entity-B; 6a/ On the generation of Invoice-B a copy is stapled to Invoice-A to represent the discharge of the right to collect the debt on Invoice-A and its transfer to Invoice-B - and placed in the shoe box marked 'invoices not due'; 6b/ Invoice-B is placed in the shoe box marked 'invoices due' In gnucash, I imagine that the transfer of Invoice-A from shoe box 'invoices due' to shoe box 'invoices not due' is represented by a transfer from Accounts Receivable to somewhere else - but, I'm not sure where. To keep it simple, the right to collect is not sold at a discount. So, the question is - how do I effect 1 to 6 above in gnucash, bearing in mind that some things may have been missed and I'm not sure where the transfer from Accounts Receivable might go? The right to collect on an invoice is sold to debt collectors all the time - I'm just a bit surprised there isn't a straight forward answer to representing that transaction in gnucash. ___ 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.
Re: [GNC] Reports for Personal Finance
You use Edit > Stylesheets. Alter the one you want. When you run the report, select that stylesheet in Options. There may not be a way to adjust that column easily. You'll have to poke around to find out or craft a careful CSS rule using the Experimental stylesheet. Regards, Adrien On 12/6/23 6:22 PM, Tom Balazs wrote: How do I navigate to the correct style sheet to edit it? On Wed, Dec 6, 2023, 7:06 PM R Losey wrote: I haven't tried to change column widths. I expect that you may need to edit the Style Sheets, but I have not attempted to do so. ___ 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.
Re: [GNC] Reports for Personal Finance
If you are that far along, the Budget module can 'auto-estimate' based on previous data. Investigate and play with that feature. Even if you don't use it as a basis of a new budget, it can at least provide you with some analysis that otherwise might be more difficult to craft in a report as it can grab data from multiple years. (and yes, once the budget is made, you can run a 'Budget Report' to get the figures) Regards, Adrien On 12/5/23 9:46 AM, Tom Balazs wrote: I finished importing and reconciling months of bank data. Now I want to put that to good use. For the case of an individual or a family, what are the most useful reports? Common advice is that your emergency savings account should hold enough to cover 6 months of expenses. In order to to do that, I need to know my average monthly expenses. I guess I can use the Cash Flow report, look at "Money Out" and divide that by how many months have gone by in the year. Is there a better way to get average monthly expenses? I like the Cash Flow report. But I wish I could sort it by amount, high to low. That would be good to see as a stacked bar chart or a regular bar chart. I would like to see a multiple-account balance as a line chart or a bar chart. In a way that shows me balances over time. I guess I'm mostly interested in the Income and Expense reports, but also in Assets and Liabilities. What reports do you find useful? ___ 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.
Re: [GNC] Selling an unpaid invoice to another business at face value?
Sorry Morgan, I didn't mean to exasperate you. What I meant by 'How would you do this on paper?', was, "Using Pen and Ink, How would you record this according to standard Accounting rules?" If you can do it with pen and ink, you can likely do it with GnuCash. So the question, for this list, is rarely, if *never*, "What should I do?" You should already know (or been otherwise professionally advised of) that answer, have already attempted to do so using GnuCash, have hit some sort of stumbling block, and then request assistance. We cannot provide accounting or legal advice here. Even if some of these users are officially qualified to do so, in their respective jurisdictions, and even if their jurisdiction matches yours, this is not the proper forum for such advice. But once you have that answer, we can help with the mechanics of the software if you can't figure it out on your own. Your attempted goal still isn't clear. As I noted, originally in your first post it appeared as if *you* were changing business entities and wanting to transfer debt owed by customers from one entity (which you were closing) to a succeeding entity. Now it appears that you want to 'sell' a debt of a customer to some outside entity. How you go about these two is quite likely very different, but in any case, no one here can offer you that advice. You *must* obtain that advice from professional sources and then if you can't figure out how to implement that advice, ask here. When you ask, you already need to have been advised of the accounts to be involved and how the money is to 'flow' with the respective transactions. Regards, Adrien On 12/5/23 10:19 AM, Morgan Read via gnucash-user wrote: Thanks Adrian, All I'm attempting to discover is how - in gnucash - can I use what is owned by somebodyA to pay off what is owed by somebodyB? What is the procedure for using what is owed by one person to relieve another of the debt they owe? On paper, I would take the invoice to somebodyB, copy it and staple the invoice to the invoice to somebodyA and then place the invoice to somebodyA in the paid invoices shoe box. I'm sorry if I'm sounding exasperated . The legal position in the UK is that if I sell the debt from companyA to companyB then companyA will be liable for income tax or company tax (depending on whether the entity is a natural person or legal person - not that a natural person isn't also a legal person, but a limited company is only a legal person) on the returns they receive for the sale. CompanyB will also be liable for any returns it receives on the debt purchased. So, legally, there is a double taxation issue. Please can we leave the legal stuff out of this - I am a lawyer. It's not a legal question. ___ 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.
Re: [GNC] Business use: Producing 1099s for vendors
The 'status' can change with the wind. GnuCash, so far, does offer you a wealth of information concerning your activity with each 'vendor' that is most likely useful for information you have *already determined* need a 1099. That is, your question is not a GnuCash question, but a legal one. Answer your legal question, then ask how or does GnuCash provide the info you need to meet that legal obligation. You need to seek the advice of a local competent professional—first. We can only answer the question, "Now that I know what I need to do, how do I do this with GnuCash?" Regards, Adrien On 12/5/23 1:46 PM, Eric Chapman wrote: My little business sometimes has to provide 1099s to vendors and the IRS. I was searching for how to best do that with GnuCash. I found a helpful tutorial here: https://www.reddit.com/r/GnuCash/comments/eqpkih/how_to_deal_with_usa_1099misc_in_gnucash/. It is 4 years old, but I read through it, and it looks as if it probably would still be useful. I also found this question and answer from 2016: https://lists.gnucash.org/pipermail/gnucash-user/2016-April/065105.html My questions: (1) Is the tutorial on reddit my best approach or is there a better one somewhere? How do others using GnuCash do it? (2) Is it true that GnuCash does not have a way to tag vendors as to their 1099 status, or did I just miss it? Seems to me each vendor could have a box ticked if it is not a corporation, and then if the annual payments to that vendor exceed $600, a report could be run. Thank you! ___ 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.
