Re: [GNC] reports
I think pretty much most if not all reports have the 'Accounts' tab in 'Options' where you select which accounts you want to report on. (the 'Account Report' being the one exception I can think of, since the account is already specified) You need to click the Options button on the toolbar, then choose the Accounts tab, then select your desired accounts. Reading the Help Manual and the Tutorial & Concepts Guide will aid you considerably. Regards, Adrien On 3/5/22 9:36 PM, Chuck wrote: I am sorry but I do not understand how to select multiple accounts & some of tier daughters & leave out everything else in the report ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] reports
On Sat, 5 Mar 2022 20:36:24 -0700 Chuck wrote: > I am sorry but I do not understand how to select multiple accounts & > some of tier daughters & leave out everything else in the report > Chuck And we are short of information, too. Can you write out what you are trying to do first? Then someone can help you chose an appropriate report. Then we can progress to the next stage. Liz ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] reports
I am sorry but I do not understand how to select multiple accounts & some of tier daughters & leave out everything else in the report Chuck On Sat, Mar 5, 2022 at 8:09 PM wrote: > On Sat, 2022-03-05 at 19:29 -0700, Charles Simcox wrote: > > What report & how do I use reports o generate a report by selecting > > specific accounts & some of their daughters not necessarily he whole > > account? > > By first opening the report by selecting the required report from the > Reports > menu then selecting the menu Item Edit-> Report Options once it is open and > selecting the desired options to display what you want. > > David Cousens > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > If you are using Nabble or Gmane, please see > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > - > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- *Tuesday**, February 22, 2022* *Isaiah 40:30-31* *Even the youths shall faint and be weary, and the young men shall utterly fall: But they that wait upon the LORD shall renew their strength; they shall mount up with wings as eagles; they shall run, and not be weary; and they shall walk, and not faint. * *Peace I leave with you, my peace I give unto you: not as the world giveth, give I unto you. Let not your heart be troubled, neither let it be afraid.* *John 14:27* *I restore the crushed spirit of the humble and revive the courage of those with repentant hearts.* *Isaiah 57:15 * Father, forgive our sins and selfish mistakes. We cast all our hopes for our marriage on Your truths, and together we wholeheartedly seek to obey Your will for us. Thank You for Your mercies, which are new every morning. Amen. *"Be Kind to our email friends"* Forwarding this? PLEASE REMOVE all email addresses before you send it on using the BCC area When forwarding to several people at once. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] reports
On Sat, 2022-03-05 at 19:29 -0700, Charles Simcox wrote: > What report & how do I use reports o generate a report by selecting > specific accounts & some of their daughters not necessarily he whole > account? By first opening the report by selecting the required report from the Reports menu then selecting the menu Item Edit-> Report Options once it is open and selecting the desired options to display what you want. David Cousens > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] reports
What report & how do I use reports o generate a report by selecting specific accounts & some of their daughters not necessarily he whole account? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] "There was a system error while retrieving the price quotes." with no more information
Hello, I have spent a few days on this so I'm hoping someone here can point me in the right direction. When I first met this error, I didn't know what to do. I ran gnucash (GUI) with logging but it didn't show anything useful. I didn't use gnc.scm=debug at that time because there were too many messages and gnucash slowed down too much to be usable. After opening a bug report, I was directed to a wiki troubleshooting page. I thought it would be nice if users could be directed without needing to involve a developer, so I opened a feature request for the application to direct users, which was promptly closed.[1] In my original bug report, I was told "perl didn't pass in enough information to figure out what went wrong" but during troubleshooting, I could see perl passed some information, added it to the bug report, and it was enough for a GnuCash developer to point me to the fix in F::Q. Not sure why this information isn't presented to the user in the first instance. Regardless, GnuCash knows what operation it was trying when it got an error. i.e. which price quote was being retrieved. I thought it would be nice if users could be told without needing to troubleshoot, so I opened a feature request, which was also promptly closed.[2] Now I've patched F::Q and gnc-fq-helper is working fine, but gnucash-cli --quotes is still giving the same error. I've been told multiple times it's not in GnuCash, but I can't get enough information to confirm or deny that. Full details are in the original bug report (which I was asked not to reopen).[3] Thank you for any assistance you may be able to provide, Jay OS: Debian GNU/Linux 11 (bullseye) GnuCash 4.9 compiled from source [1] https://bugs.gnucash.org/show_bug.cgi?id=798468 [2] https://bugs.gnucash.org/show_bug.cgi?id=798467 [3] https://bugs.gnucash.org/show_bug.cgi?id=798449 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] mac fails to open gnucash file
Hmm is right. I just tried to duplicate the issue and couldn't. It must be something a little more subtle, or GC got into some bad state. On 3/5/22 12:53, john wrote: Hmm. I have for many years kept my books in an encrypted disk image (dmg) that I back up on Google Drive. After a restart I have to remount the dmg, something I occasionally forget to do before starting GnuCash and when I do GnuCash pops up that dialog. I've always told it no. I usually quit GnuCash, mount the dmg, and restart GnuCash, and GnuCash though I sometimes just mount the dmg and then use the saved entry at the bottom of the File menu to open the book. Both have always worked without a problem. ISTR this has come up before. Are you not answering the dialog box at all, leaving it displayed, when you try to open the book after mounting the share? Regards, John Ralls On Mar 5, 2022, at 9:50 AM, brad wrote: I think I have this sorted out. I did try File->Open, but it didn't work. I did know about the 'Known Mac Thing', so annoying. Something not obvious, probably a bug. When GC fails to open the last file, because it isn't there or the Sambashare hasn't been mounted yet, a GUI pops up saying it could not be found, it's in the history list, do you want to remove it? You must say yes. You must say yes even if you're going to open another file with File->Open. The steps to recreate: Start GC by clicking the app, before mounting the sambashare. It fails. Don't click yes on the history list removal (because why would you, you're going to mount the sambashare and use it). Mount the sambashare & attempt to file->open the file. Fail. Subsequent attempts to mount the sambashare before starting GC, or copying the GC file to local hard drive will fail also, until saying 'Yes' remove the file from the history list. This probably doesn't have anything to do with the MAC OS update, that was a distraction. Thanks On 3/4/22 20:25, D. wrote: I'm not using a Mac anymore, but you should know that double clicking a file in Finder will not open that file in GnuCash but will open the last opened file instead. It is a Known Mac Thing. You might want to try using File -> Open to see whether your File really won't open... On 3/4/22 22:03, Adrien Monteleone wrote: If you are getting a crash, you should file it on bugs.gnucash.org and attach your crash report there. Also, check the wiki about obtaining a TraceFile. That might be helpful as well. But first... I'm guessing you can start GnuCash since it crashes on exit. Can you navigate to File > Open and look for your file that way to reset the last-known location? Regards, Adrien On 3/4/22 8:07 PM, brad wrote: Upgraded to 4.9. It still fails to open. Also when closing GC it crashes. I don't know if the list will allow it, but I'll attach the crash report. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] don't know..
On 3/5/22 2:26 PM, arthur brogard via gnucash-user wrote: Not sure if I'm doing this right. Hitting 'reply' on the email address of a poster that I want to respond to and putting a 'cc' in for gnucash-user@gnucash.org I see some people's posts seem to have been made to 'list gnucash' or something. And that advice to 'reply to list' etc. - what's that? I see no such options on my yahoo email. It's referring to choosing for yourself which email address to send to or its an actual menu choice somewhere? As David noted, you only *need* to reply to gnucash-user@gnucash.org. The individual's email address is not needed. They'll get the message because they are members of the list. It is imperative to *at least* reply to gnucash-user@gnucash.org so everyone on the list will see it. (otherwise, only the individual you replied to will see your message) You can either do this manually, or use the Reply-All button/option in your mail program (delete the individual addresses if you like, leaving the list address), or If your mail service has a 'Reply to List' or 'Reply to Group' or something similar, use that instead. (better option) You may have to investigate Yahoo! settings concerning 'newsgroup' or 'newsletter' or 'mailing lists' options to enable this button if Yahoo! is not automatically offering it to you. (or it may not even be an option as not all e-mail applications offer it.) And when I do 'reply' yahoo want me to give a subject. Well what? Anything I 'should' put there to suit the list? Hitting any Reply, Reply-All or Reply-List button should auto-populate the same subject for you. I'd consider it quite odd if it did not. If this is the case, simply copy and paste the subject line from the message you are replying to. Regards, Adrien ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] accounts receivable for rent..
On 3/5/22 10:32 AM, Michael or Penny Novack wrote: On 3/5/2022 4:03 AM, Adrien Monteleone wrote: On 3/5/22 12:50 AM, arthur brogard via gnucash-user wrote: We have only one property. Only one tenant. Simplest possible case I guess. I'm thinking I must: . Create an 'accounts receivable' account.That would be an income account I guess. 'Other income' ? Accounts Receivable is an Asset account. As David noted, if you go through the setup wizard and choose 'Business Accounts' you'll get it created automatically for you. Wait a moment folks. "Accounts Receivable" is an accounting CONCEPT. You can have such an account even if NOT keeping books on the accrual basis (required for using the built in gnucash "business features". Certainly. But the OP needs practical help. I gave them a resource for the conceptual help as well. We are being asked "what should I do" by a person who has only one rental property, one tenant, etc. And who might want to have books on the cash basis rather than accrual. Precisely because their payment and rental due activity is *not* at the same time, more than likely, a cash basis will be an absolute "mess" to maintain compared to using the Business Features. (as you proceed to describe below) And that method you describe requires unnecessarily employing 'ghost' accounts just for tracking purposes to duplicate the functionality *already built in*. The OP is brand new to accounting, and you're offering the path of greatest resistance. I think you got lost from the 'concept' point forward. But if the OP wants to traverse that road, of course, that's their call. We have been told that rental PAYMENTS are often/usually not the "right amount" and that the tenant might be in arrears of ahead. In other words, not going to be enough to simply enter transactions when something is paid debiting cash and crediting rental income. There is more to track: Can have an asset account "rent owed" (that's the equivalent A/R) and an income account "rent not received" (that would NOT be included in the P report). The transaction between these two could be scheduled as automatic. But then when the tenant DOES make a payment, the transaction is much more complicated. It has to BOTH debit cash and credit "rent owed" AND transfer that same amount between rent not received and rent income. Yes more work because you are tracking two different things. Two way split transactions can be hard to enter (especially for a beginner) but this is a special case where there is a trick that can be used. Essentially going to first enter a one sided split and then "correct" it. When the tenant makes a payment begin a transaction debiting cash for TWICE the amount and hit "split" entering "journal mode". Change the Imbalance amount (it will be a credit) to the correct amount (HALF) and specify the account as "rent owed" and then for the new Imbalance "rental income". But do NOT finish the transaction yet. Go up to the line where the account is cash and change to the correct amount (Half) and now the Imbalance will be debit. Specify that account to be "rent not received". See, in addition to recording the receipt of rental income also recorded the reduction of what the tenant owes. A printout of the account "rent owed" can be showed to the tenant << it will have all the "rent due" transactions, all the "rent payment" transactions, and the balance owed. Of course if not up to "splits" can simply enter two simple transactions. But like I said, this is a special case. The general case of two way split doesn't have the same number of debit and credit accounts and the amounts can all be different as long as total credits equals total debits. Unless you have first computed that that total amount (outside of gnucash) you don't know with what amount to start. Here there are the same number of debits and credits, two of each, all for the same amount, so the right amount to start with is TWICE that amount. Michael D Novack Regards, Adrien ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] don't know..
On Sat, 2022-03-05 at 20:26 +, arthur brogard via gnucash-user wrote: > Not sure if I'm doing this right. Hitting 'reply' on the email address of a > poster that I want to respond to and putting a 'cc' in for > gnucash-user@gnucash.org Arthur If you put gnucash-user@gnucash.org in the To: field, there is no need to include the specific person you are replying to in the addressing of the message, Just use their name within your message. > I see some people's posts seem to have been made to 'list gnucash' or > something. > And that advice to 'reply to list' etc. - what's that? I see no such options > on my yahoo email. It's referring to choosing for yourself which email > address to send to or its an actual menu choice somewhere? > And when I do 'reply' yahoo want me to give a subject. Well what? Anything I > 'should' put there to suit the list? > Okay. That's that. > Back to the question. > Thanks to everyone for their input. It's got me pretty well fazed. Look like > I'm going to have to do a bit of reading and learning on gnucash and > accounting/book keeping on the one hand and on the other: it looks like > gnucash might not be what I want for this little problem. > Overkill or something. If you need to prepare standard business type reports it won't be. Most other accounting programs tend to hide the accounting in the bookkeeping from the user, particularly some of the fundamental relationships. In GnuCash it is up front and very close to the basics of standard accounting. I started using GnuCash to prepare assignments, when I was doing a master's degree in accounting many years ago now. David > But I might as well do the reading etc. and get into gnucash anyway so I'll > have a stab. > I feel that advice to use the business features might be the way to go so I'll > stumble along that road if I can find it, for a while. > And I'll haphazardly throw in some posts of our normal household expenses as > they come to mind and see how it all works out. > You won't believe this but I'm supposed to know book-keeping. I once worked > as a book-keeper. Used a couple of proprietary packages. Don't even remember > their names now. Was so capable back then I converted the shambolic original > system for the community onto the new package. > Hard to believe now, eh? Perhaps it'll start coming back to me if I do as I > say and start making postings... > :) > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] don't know..
Not sure if I'm doing this right. Hitting 'reply' on the email address of a poster that I want to respond to and putting a 'cc' in for gnucash-user@gnucash.org I see some people's posts seem to have been made to 'list gnucash' or something. And that advice to 'reply to list' etc. - what's that? I see no such options on my yahoo email. It's referring to choosing for yourself which email address to send to or its an actual menu choice somewhere? And when I do 'reply' yahoo want me to give a subject. Well what? Anything I 'should' put there to suit the list? Okay. That's that. Back to the question. Thanks to everyone for their input. It's got me pretty well fazed. Look like I'm going to have to do a bit of reading and learning on gnucash and accounting/book keeping on the one hand and on the other: it looks like gnucash might not be what I want for this little problem. Overkill or something. But I might as well do the reading etc. and get into gnucash anyway so I'll have a stab. I feel that advice to use the business features might be the way to go so I'll stumble along that road if I can find it, for a while. And I'll haphazardly throw in some posts of our normal household expenses as they come to mind and see how it all works out. You won't believe this but I'm supposed to know book-keeping. I once worked as a book-keeper. Used a couple of proprietary packages. Don't even remember their names now. Was so capable back then I converted the shambolic original system for the community onto the new package. Hard to believe now, eh? Perhaps it'll start coming back to me if I do as I say and start making postings... :) ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] mac fails to open gnucash file
Hmm. I have for many years kept my books in an encrypted disk image (dmg) that I back up on Google Drive. After a restart I have to remount the dmg, something I occasionally forget to do before starting GnuCash and when I do GnuCash pops up that dialog. I've always told it no. I usually quit GnuCash, mount the dmg, and restart GnuCash, and GnuCash though I sometimes just mount the dmg and then use the saved entry at the bottom of the File menu to open the book. Both have always worked without a problem. ISTR this has come up before. Are you not answering the dialog box at all, leaving it displayed, when you try to open the book after mounting the share? Regards, John Ralls > On Mar 5, 2022, at 9:50 AM, brad wrote: > > I think I have this sorted out. I did try File->Open, but it didn't work. > I did know about the 'Known Mac Thing', so annoying. > > Something not obvious, probably a bug. When GC fails to open the last file, > because it isn't there or the Sambashare hasn't been mounted yet, a GUI pops > up saying it could not be found, it's in the history list, do you want to > remove it?You must say yes. You must say yes even if you're going to > open another file with File->Open. > > The steps to recreate: Start GC by clicking the app, before mounting the > sambashare. It fails. Don't click yes on the history list removal (because > why would you, you're going to mount the sambashare and use it). Mount the > sambashare & attempt to file->open the file. Fail. > Subsequent attempts to mount the sambashare before starting GC, or copying > the GC file to local hard drive will fail also, until saying 'Yes' remove the > file from the history list. > > This probably doesn't have anything to do with the MAC OS update, that was a > distraction. > > Thanks > > On 3/4/22 20:25, D. wrote: >> I'm not using a Mac anymore, but you should know that double clicking a file >> in Finder will not open that file in GnuCash but will open the last opened >> file instead. It is a Known Mac Thing. >> >> You might want to try using File -> Open to see whether your File really >> won't open... > On 3/4/22 22:03, Adrien Monteleone wrote: >> If you are getting a crash, you should file it on bugs.gnucash.org and >> attach your crash report there. >> >> Also, check the wiki about obtaining a TraceFile. That might be helpful as >> well. >> >> But first... >> >> I'm guessing you can start GnuCash since it crashes on exit. >> >> Can you navigate to File > Open and look for your file that way to reset the >> last-known location? >> >> Regards, >> Adrien >> >> On 3/4/22 8:07 PM, brad wrote: >>> Upgraded to 4.9. It still fails to open. Also when closing GC it >>> crashes. I don't know if the list will allow it, but I'll attach the crash >>> report. >> >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] mac fails to open gnucash file
I think I have this sorted out. I did try File->Open, but it didn't work. I did know about the 'Known Mac Thing', so annoying. Something not obvious, probably a bug. When GC fails to open the last file, because it isn't there or the Sambashare hasn't been mounted yet, a GUI pops up saying it could not be found, it's in the history list, do you want to remove it? You must say yes. You must say yes even if you're going to open another file with File->Open. The steps to recreate: Start GC by clicking the app, before mounting the sambashare. It fails. Don't click yes on the history list removal (because why would you, you're going to mount the sambashare and use it). Mount the sambashare & attempt to file->open the file. Fail. Subsequent attempts to mount the sambashare before starting GC, or copying the GC file to local hard drive will fail also, until saying 'Yes' remove the file from the history list. This probably doesn't have anything to do with the MAC OS update, that was a distraction. Thanks On 3/4/22 20:25, D. wrote: I'm not using a Mac anymore, but you should know that double clicking a file in Finder will not open that file in GnuCash but will open the last opened file instead. It is a Known Mac Thing. You might want to try using File -> Open to see whether your File really won't open... On 3/4/22 22:03, Adrien Monteleone wrote: If you are getting a crash, you should file it on bugs.gnucash.org and attach your crash report there. Also, check the wiki about obtaining a TraceFile. That might be helpful as well. But first... I'm guessing you can start GnuCash since it crashes on exit. Can you navigate to File > Open and look for your file that way to reset the last-known location? Regards, Adrien On 3/4/22 8:07 PM, brad wrote: Upgraded to 4.9. It still fails to open. Also when closing GC it crashes. I don't know if the list will allow it, but I'll attach the crash report. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] accounts receivable for rent..
On 3/5/2022 4:03 AM, Adrien Monteleone wrote: On 3/5/22 12:50 AM, arthur brogard via gnucash-user wrote: We have only one property. Only one tenant. Simplest possible case I guess. I'm thinking I must: . Create an 'accounts receivable' account.That would be an income account I guess. 'Other income' ? Accounts Receivable is an Asset account. As David noted, if you go through the setup wizard and choose 'Business Accounts' you'll get it created automatically for you. Wait a moment folks. "Accounts Receivable" is an accounting CONCEPT. You can have such an account even if NOT keeping books on the accrual basis (required for using the built in gnucash "business features". We are being asked "what should I do" by a person who has only one rental property, one tenant, etc. And who might want to have books on the cash basis rather than accrual. We have been told that rental PAYMENTS are often/usually not the "right amount" and that the tenant might be in arrears of ahead. In other words, not going to be enough to simply enter transactions when something is paid debiting cash and crediting rental income. There is more to track: Can have an asset account "rent owed" (that's the equivalent A/R) and an income account "rent not received" (that would NOT be included in the P report). The transaction between these two could be scheduled as automatic. But then when the tenant DOES make a payment, the transaction is much more complicated. It has to BOTH debit cash and credit "rent owed" AND transfer that same amount between rent not received and rent income. Yes more work because you are tracking two different things. Two way split transactions can be hard to enter (especially for a beginner) but this is a special case where there is a trick that can be used. Essentially going to first enter a one sided split and then "correct" it. When the tenant makes a payment begin a transaction debiting cash for TWICE the amount and hit "split" entering "journal mode". Change the Imbalance amount (it will be a credit) to the correct amount (HALF) and specify the account as "rent owed" and then for the new Imbalance "rental income". But do NOT finish the transaction yet. Go up to the line where the account is cash and change to the correct amount (Half) and now the Imbalance will be debit. Specify that account to be "rent not received". See, in addition to recording the receipt of rental income also recorded the reduction of what the tenant owes. A printout of the account "rent owed" can be showed to the tenant << it will have all the "rent due" transactions, all the "rent payment" transactions, and the balance owed. Of course if not up to "splits" can simply enter two simple transactions. But like I said, this is a special case. The general case of two way split doesn't have the same number of debit and credit accounts and the amounts can all be different as long as total credits equals total debits. Unless you have first computed that that total amount (outside of gnucash) you don't know with what amount to start. Here there are the same number of debits and credits, two of each, all for the same amount, so the right amount to start with is TWICE that amount. Michael D Novack ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Keeping tenant accounts on Gnucash - periodic 'rent owing' ?
And on that note, I highly stress to anyone getting started (or even old hands) to not try to artificially combine receipts for convenience. You could if you wanted to, but I guarantee, you'll want to 'refactor' some of those line items one day, or wish you could. Just enter receipts as multi-split transactions, line by line, with detailed info in the Memo fields. That way, if you ever want to move something to a different account in the future, it is possible. The added bonus is you don't have to do math. GnuCash adds up the receipt for you. If you combine fish with tires today, because you bought them on the same visit to Costco, you won't be able to split them up into Groceries & Auto 6 months from now. If you insist on not doing separate line items, recording at least a small description for each and their respective amounts in the memo will help, but this gets cumbersome any but the simplest of purchases. While this may sound nuts to some, you'd be surprised how 'auto-fill' on a new transaction to any particular store, magically needs little editing from visit to visit. It isn't like you're doing lots of data entry after a month or so of receipts. And when you realize tracking Auto vs. Groceries is more important than where you bought them, you'll thank me later... Regards, Adrien On 3/5/22 3:13 AM, Liz wrote: If you are not sure about the expenses, make lots of expense subaccounts to keep them in general categories, and rationalise them when you have had a chat with your accountant. In GnuCash its easy to join subaccounts and tedious to split 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Keeping tenant accounts on Gnucash - periodic 'rent owing' ?
On 3/5/22 2:20 AM, flywire wrote: My concern is A/R is a lot of work just to get tenant statements if it's not used elsewhere. It is similar to the issue raised last month regarding tracking vehicles except for the regular rent due: https://lists.gnucash.org/pipermail/gnucash-user/2022-February/099785.html As described GnuCash has filtering on tags (eg report a single tenant) but no grouping (eg reports for every tenant and everything else). This is important to ensure all transactions are accounted for with tags. As long as you aren't trying to track multiple 'properties' and generate separate P for each from a single book, there is little work involved. (the 'GnuCash' way here would be to use separate books for each property, then have a consolidated book for the few remaining entries, otherwise, yes, a tag system or other means would have to be employed) I use the Business Features for AR with 3 clients, and AP with 7 vendors that issue recurring bills. (3 of which are monthly, 1 semi-annual, 3 annual) One could certainly handle many more, but high-volume auto-recurrence isn't yet built in without a bit of creative thinking. (that's another bug & thread concerning Scheduled Invoices) However, there's nothing 'elsewhere' you need to do things for AR to work. Assuming you've got your accounts created: 1. Set up Customer (Tenant) 2. Create and post Invoice for 'rent' 3. Send 'Customer Report' statement of account 4. Process Payment, applying it to the invoice 5. repeat steps 2-4 as needed (#3 can be done at any time) Alternative Process: 1. Upload bank transactions to GnuCash 2. In GnuCash terms, run a transaction report sorted by say date and split notes (assuming it contains a tag) with payments 3. Open report in a spreadsheet with sheets for each tenant having: Date, Due, Payments, Balance Owing 4. Append date and payments to each tenants sheet 5. Append date and amount due for each period 6. Sort by date and payments then copy balance owing formula down for running total 7. Check header and footer then print rental statement The spreadsheet ends up as a template that is updated. It's a simple process but it's manual so it carries a risk of mistakes. While GnuCash doesn't support grouping in reports the advantage of open source is the whole thing could easily be automated under piecash to generate reports. If the P/Income Statement had the filter options of the Transaction Report, life would be much easier. Then you could just filter for your tag, and get a custom statement for just those transactions. I filed an enhancement request specifically for this: https://bugs.gnucash.org/show_bug.cgi?id=798469 There is also the more generic RFE here: https://bugs.gnucash.org/show_bug.cgi?id=113772 I'm not sure how difficult sorting (grouping) a Transaction Report by a tags would be, since tags aren't officially implemented, and can appear in a number of fields. Otherwise, I'd file an RFE on that too, which would likely satisfy many uses cases. Regards, Adrien ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Keeping tenant accounts on Gnucash - periodic 'rent owing' ?
On Fri, 4 Mar 2022 19:26:04 -0500 Glenn Fowler wrote: > Hi, > > I use GnuCash for rental properties as well. Setup your accounts under > expenses for repairs, insurance, utilities, etc. In my case, I setup a > recurring transaction for rental income. Then, you only need to make > changes as needed instead of doing it manually every month. You need to have some idea on the tax implications of your expenses. In AU, this is where we start to rival North American sales tax ;) So some expenses are recurring - like rates and insurance and are tax deductible Some expenses are general maintenance - the bills from the plumber and electrician for callouts and are tax deductible Some expenses are capital - when you decide to replace the kitchen because it is wear and tear and scruffy, but not if it is seriously damaged by floods (topical here), that would be maintenance or on the insurance. Some expenses can be sent back to the tenant to pay (here we charge water usage to the tenant, but not if you didn't fix the leaky taps or cistern) Whether interest charges on the mortgage you have over the property are expenses which are tax deductible or capital expenses depends on the flavour of government - it seems to oscillate slowly here. If you are not sure about the expenses, make lots of expense subaccounts to keep them in general categories, and rationalise them when you have had a chat with your accountant. In GnuCash its easy to join subaccounts and tedious to split them. Liz ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] accounts receivable for rent..
On 3/5/22 12:50 AM, arthur brogard via gnucash-user wrote: We have only one property. Only one tenant. Simplest possible case I guess. I'm thinking I must: . Create an 'accounts receivable' account.That would be an income account I guess. 'Other income' ? Accounts Receivable is an Asset account. As David noted, if you go through the setup wizard and choose 'Business Accounts' you'll get it created automatically for you. Though you only have one tenant, I'd still recommend to go the route of using the 'Business Features' because it is the only of the 3 I mentioned that has the reports you need already created and ready to use. Doing this manually or with Scheduled Transactions (SX) will also require manually crafting 'statement of account' type reports. The little time spent setting up your Tenant as a Customer, and creating (and then duplicating) periodic 'Invoices' for rent will more than be outweighed by the time saved generating the desired reports and tracking the Tenant's payments. Every week I put the rent amount in there. (that's what I"d like to have happen automatically) Then I can print out that balance and show it to him: that's what you owe today. Somehow what he pays has to go into that account to reflect that he's paid. The only downside is you can't auto-post when rent is due. You'll need to find a way to remind yourself to duplicate and post those invoices each period. (month/week, etc.) It is possible to future-post invoices, but that can introduce additional 'complications' you may not be prepared for at first while getting your feet wet. I'd recommend just posting them as needed for now. After you post new invoices, you can give the tenant a 'Customer Report' (which you can rename of course) showing the amount due. (which can reflect past due amounts, with aging, as well as previous payments, and what periods those payments applied to. They pay by direct deposit to my bank account. So what do I do? Credit his AR account and debit cash at bank? When I become aware he's paid into my bank account. Correct. You would do that by using the Process Payment function in GnuCash to apply his payment to the rent 'Invoice' you already posted. When you enter the payment, you get the option to choose the account the money went into. Then print out a statement showing his balance. That's how it goes? Essentially, yes. Once you've got everything set up, you can give him a 'Customer Report' which is otherwise known as 'Statement of Account'. I'd also highly recommend that you find either an online or textbook resource for basic Accounting. We can help here with some things, but this is not really an Accounting list. We can't give formal advice. We can only help with generalities and 'how to do it in GnuCash' after you already know how to do it 'on paper.' https://www.principlesofaccounting.com/ Might be a good place to start. (But first, read the Help Manual and the Tutorial & Concepts Guide for GnuCash) Regards, Adrien ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Keeping tenant accounts on Gnucash - periodic 'rent owing' ?
Excellent question Arthur. This isn't a budget issue and you have no idea if tenants are in front or behind unless you compare it to payments due. Adrien seems to have presented the GnuCash features the best using a scheduled A/R. I've used a different approach with quickbooks for this purpose because it has classes allowing one set of accounts to be tagged to different tenants but it should be equivalent with GnuCash. Accounts include: Income/rent, bond (contra), Expense/water (partially reimbursable), various misc income and expenditure relating to tenants. It's easy to miss seldom used accounts. My concern is A/R is a lot of work just to get tenant statements if it's not used elsewhere. It is similar to the issue raised last month regarding tracking vehicles except for the regular rent due: https://lists.gnucash.org/pipermail/gnucash-user/2022-February/099785.html As described GnuCash has filtering on tags (eg report a single tenant) but no grouping (eg reports for every tenant and everything else). This is important to ensure all transactions are accounted for with tags. Alternative Process: 1. Upload bank transactions to GnuCash 2. In GnuCash terms, run a transaction report sorted by say date and split notes (assuming it contains a tag) with payments 3. Open report in a spreadsheet with sheets for each tenant having: Date, Due, Payments, Balance Owing 4. Append date and payments to each tenants sheet 5. Append date and amount due for each period 6. Sort by date and payments then copy balance owing formula down for running total 7. Check header and footer then print rental statement The spreadsheet ends up as a template that is updated. It's a simple process but it's manual so it carries a risk of mistakes. While GnuCash doesn't support grouping in reports the advantage of open source is the whole thing could easily be automated under piecash to generate reports. A dozen transactions would make a handy demo dataset. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
