Re: [GNC] Why is Licenses and Permits Charges, not Expenses?
Spectacular, thank you Jim. Your suggestion was the solution. I would never have found it on my own. Cheers, Howard On 4/24/22 11:28 AM, gnucash-user-requ...@gnucash.org wrote: Message: 1 Date: Sat, 23 Apr 2022 13:29:16 -0700 From: Jim DeLaHunt To: gnucash-user@gnucash.org Subject: Re: [GNC] Why is ?Licenses and Permits? Charges, not Expenses? Message-ID: <02f21ef7-13d7-e4b9-e99b-988213004...@jdlh.com> Content-Type: text/plain; charset=UTF-8; format=flowed On 2022-04-23 09:13, Howard M. Fried wrote: In my (business) account hierarchy, all Expenses are listed as positive numbers (in black).? However, the Expense category Licenses and Permits is displayed as a negative number (in red).? In the list of transactions, the amount column is labeled Expenses for all (in-use) expense categories, except Licenses and Permits, for which the amount column is labeled Charges. I suggest you double-check the Account Type for the "Licenses and Permits" account. You can do this from the Accounts tab, by clicking on the account and pressing the Edit button. An Edit Account dialogue appears. In the bottom left corner of this dialogue, there is a list, "Account Type". In an expense hierarchy, only the types Income and Expense will be listed. If Income is highlighted, change it to Expense. The clue is that use of the term "Charges". In an Income account, the left amount column is titled "Charge", and the right is titled "Income". In an Expense account, the left amount column is titled "Expense", and the right is titled "Rebate". Does this help? Best regards, ?? ?Jim DeLaHunt ___ 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] Why is “Licenses and Permits” Charges, not Expenses?
Mac OS 10.15, Gnucash ver 4.4 In my (business) account hierarchy, all Expenses are listed as positive numbers (in black). However, the Expense category Licenses and Permits is displayed as a negative number (in red). In the list of transactions, the amount column is labeled Expenses for all (in-use) expense categories, except Licenses and Permits, for which the amount column is labeled Charges. Nevertheless, the total of Expenses includes the amount for Licenses and Permits. Why the difference (it doesn't seem to matter)? Have I set up my account incorrectly? Many thanks, Howard ___ 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] Minor: Can Gnucash save sort order?
Thanks Gyle. Yes, correct, Sales has a Save Sort Order option. As my scientific mentor used to say, "You can learn a lot by looking"! Many thanks to the incredible GC Team and this list. Cheers. On 11/29/21 12:25 PM, Gyle McCollam wrote: Howard, In the register, when you right click on a column heading and select "sort order" there are many choices for the order, including "Number", which I'm sure you are familiar with as you are able to sort them in that order. At the bottom above the "OK" there is an option to "Save Sort Order". Hopefully, it is the same in "Sales". Thank You, Gyle McCollam Gyle McCollam 609.680.2326 Mobile gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email ________ From: gnucash-user on behalf of Howard M. Fried Sent: Monday, November 29, 2021 10:43 AM To: gnucash-user@gnucash.org Subject: [GNC] Minor: Can Gnucash save sort order? GC ver 4.4, Mac OS 10.15.7. By default, the items in Sales are sorted by date (old to new). I realize that's sensible, but it's easier for me to find something when I change the sort order to Number. However, GC does not save the NUM sort after closing the application. Could it be otherwise? Many thanks, Howard ___ 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] Minor: Can Gnucash save sort order?
GC ver 4.4, Mac OS 10.15.7. By default, the items in Sales are sorted by date (old to new). I realize that's sensible, but it's easier for me to find something when I change the sort order to Number. However, GC does not save the NUM sort after closing the application. Could it be otherwise? Many thanks, Howard ___ 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] Question about Profit-Loss Report
On 5/31/21 9:08 PM, Alan Hopkins wrote: Hello Howard I agree with both Michaels - you need to understand the difference between accounting records & reports prepared on an accruals basis vs a cash basis. You should do some reading on basic accounting. GNUCash used for business uses the accrual basis - (invoices are registered in accounts receivable, bills are registered in accounts payable). Depending on the number of invoices & bills involved, you may find that you need to develop your own cash report on a spreadsheet. Some of these links may be of help to you: https://www.accountingtools.com/articles/how-to-convert-accrual-basis-to-cash-basis-accounting.html <https://www.accountingtools.com/articles/how-to-convert-accrual-basis-to-cash-basis-accounting.html> https://www.bookstime.com/articles/accrual-to-cash-conversion <https://www.bookstime.com/articles/accrual-to-cash-conversion> https://www.double-entry-bookkeeping.com/bookkeeping-basics/accrual-to-cash-conversion-excel-worksheet/ <https://www.double-entry-bookkeeping.com/bookkeeping-basics/accrual-to-cash-conversion-excel-worksheet/> GNUCash is excellent software (a big thank you to the developers!) and you can get more understanding of basic accounting and using the business features by referring to the Tutorial & Concepts guide: https://www.gnucash.org/viewdoc.phtml?rev=4=C=guide <https://www.gnucash.org/viewdoc.phtml?rev=4=C=guide> I hope that is of some help to you Cheers Alan Thank you Alan, and both Michaels. I was an educator for 34 years before launching a second career as an Editor. Clearly, I need to take up the role of student and learn some basic accounting methods. I will certainly examine the materials that you have so kindly provided. Regards, Howard On 1/6/21 12:42 am, Michael Hendry wrote: On 31 May 2021, at 15:10, Howard M. Fried wrote: I have several invoices that were issued in 2020 but paid in 2021. These funds are not included in a P report for 2021, apparently because the report is based on date of invoice issue, or have I missed something. Is it possible to get the 2020 Sales that were paid in 2021 into the report for 2021? Simply extending the Report date range backward is not a solution because many invoices that were issued and paid in 2020 will be included. Or am I to include unrealized assets for 2020 as profit, like the P report does (I have no accounting, financial, or legal experience in such matters). Thank you for considering, Howard Fried Not an accountant either, Howard, but I believe the approach varies according to whether your books are kept on a cash or an accrual basis. If cash, then reports are based on the date when you received income, or the date you made a payment for expenses. I don’t use the business features, but I think that you will be working on an accrual basis, and have reports on Accounts Receivable and Accounts Payable which carry over the end of the financial year. Michael ___ 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 seehttps://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] Question about Profit-Loss Report
On 5/31/21 10:42 AM, Michael Hendry wrote: On 31 May 2021, at 15:10, Howard M. Fried wrote: I have several invoices that were issued in 2020 but paid in 2021. These funds are not included in a P report for 2021, apparently because the report is based on date of invoice issue, or have I missed something. Is it possible to get the 2020 Sales that were paid in 2021 into the report for 2021? Simply extending the Report date range backward is not a solution because many invoices that were issued and paid in 2020 will be included. Or am I to include unrealized assets for 2020 as profit, like the P report does (I have no accounting, financial, or legal experience in such matters). Thank you for considering, Howard Fried Not an accountant either, Howard, but I believe the approach varies according to whether your books are kept on a cash or an accrual basis. If cash, then reports are based on the date when you received income, or the date you made a payment for expenses. I don’t use the business features, but I think that you will be working on an accrual basis, and have reports on Accounts Receivable and Accounts Payable which carry over the end of the financial year. Michael Thank you Michael. I'm a one-person business with one service (manuscript editing). It never occurred to me that any method other than cash would be the way to go, and I just blindly set up my GnuCash account without thinking about it. This year is the first in which the issuance and payment of invoices spanned two years. I'll have to remember to add those funds come tax time. Will have to check expenses as well. Cheers, Howard ___ 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] Question about Profit-Loss Report
I have several invoices that were issued in 2020 but paid in 2021. These funds are not included in a P report for 2021, apparently because the report is based on date of invoice issue, or have I missed something. Is it possible to get the 2020 Sales that were paid in 2021 into the report for 2021? Simply extending the Report date range backward is not a solution because many invoices that were issued and paid in 2020 will be included. Or am I to include unrealized assets for 2020 as profit, like the P report does (I have no accounting, financial, or legal experience in such matters). Thank you for considering, Howard Fried ___ 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] Cash Flow Report has incorrect values
I can't say that I understand the circle thing, but the P Report looks correct. I also keep an Excel spread sheet just for Sales by year, and it's total for this year is slightly different from the P Report. I've probably made an error somewhere. Many thanks, Howard On 5/17/21 12:49 PM, Derek Atkins wrote: The "Cash Flow" report probably is not what you really want. What that report does is allows you to draw a circle around a set of accounts and it will summarize all the transactions that cross that boundary. Any transaction fully inside the circle or fully outside the circle is ignored. Most likely, *THAT* is why it's giving you 10X, because -9X probably is fully inside the circle and not being included in the counting. Have you tried a P report? -derek On Mon, May 17, 2021 12:39 pm, Howard M. Fried wrote: Hello, My Cash Flow Report for 01/01/2021-12/31/2012 (or 01/01/2021-Today) shows wildly incorrect values, specifically the "Money In" and "Accounts Receivable" amounts. For example, in the complete Account display, Accounts Receivable shows X (which is correct). But in the Report, it shows a value larger than 10X. I've been using the same Account for several years and never noticed such a problem. I played with the Options, to no avail. Any feedback greatly appreciated. ___ 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] Cash Flow Report has incorrect values
Hello, My Cash Flow Report for 01/01/2021-12/31/2012 (or 01/01/2021-Today) shows wildly incorrect values, specifically the "Money In" and "Accounts Receivable" amounts. For example, in the complete Account display, Accounts Receivable shows X (which is correct). But in the Report, it shows a value larger than 10X. I've been using the same Account for several years and never noticed such a problem. I played with the Options, to no avail. Any feedback greatly appreciated. ___ 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] Minor issue with invoice layout
Message: 1 > Date: Fri, 26 Feb 2021 12:02:06 -0600 (CST) From: Ajnkns To: gnucash-user@gnucash.org Subject: Re: [GNC] Minor issue with invoice layout Message-ID: <1614362526691-0.p...@n4.nabble.com> Content-Type: text/plain; charset=us-ascii "I upgraded Gnucash from ver 3.2 to 4.4 (Mac OS 10.15). My custom invoice layout changed. Particularly, the Client information, which was flush with the left margin, is now moved much toward the center." I am having the same problem. I've tried editing the CSS and can move the client table back to the left with a margin left negative number value, but that moves it to a set position which may end up misaligned from the grid below when it is printed. By exporting the report and opening it in a web browser I was able to figure out what needs to be changed to make it auto align to the left, but it isn't something that can be changed from the CSS style editor section under the Layout tab. Have you had any luck figuring this out? I also used to be able to have the invoice # set to be large bold text but I can't figure out how to change that in this new version either. The main thing I use Gnucash for is invoicing...it's pretty frustrating that I can't get it looking as good as I had it before. It really looks very weird having the customers information indented 1/4 of the way toward center while the invoice # above it is aligned all the way to the left. To move the various components of the invoice, you have to play with the Row 1 Left, Row 1 Right, etc drop down selections in the Option->Layout section. For example, "Their details" corresponds to the Client information. Eventually, I got all the various bits on the desired sides and in the desired top-to-bottom order, including my logo, and everything was flush with both margins. Even though everything looked OK on the screen, when I printed the invoice (or saved to PDF), the margins were extremely small in width, and the document looked terrible. The solution for setting the margins is as follows: In the Layout section, add this code to the CSS body {margin-top: 1cm; margin-left: 1.5cm; margin-right: 2cm margin-bottom: 1cm} I tried other CSS code snippets that accept margin information, but only "body" worked. I think one can use px and even inch in place of cm. I wasn't worried about a bottom margin; thus, I omitted that line. Note that, for an unknown reason, to get the invoice centered on the page, I had to use different values for the left and right margins. Cheers, Howard ___ 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] Minor issue with invoice layout
On 2/15/21 7:09 PM, gnucash-user-requ...@gnucash.org wrote: Thank you Adrien. Yes, I obtained something acceptable after figuring out the Layout tab. I am illiterate regarding CSS. I need code to make the margins larger (the Scale function in the Print dialog does not give the desired result). I've found code online for web pages, but simply inserting that code into the Gnucash CSS box did not do anything. Probably the code format was incorrect. Regards, Howard Message: 5 Date: Mon, 15 Feb 2021 16:29:17 -0600 From: Adrien Monteleone To:gnucash-u...@lists.gnucash.org Subject: Re: [GNC] Minor issue with invoice layout Message-ID: Content-Type: text/plain; charset=utf-8; format=flowed Play with the Layout tab in Options for the Invoice Report. There is also a custom CSS box available if you want to dig that far. Regards, Adrien On 2/14/21 11:47 AM, Howard M. Fried wrote: Hello, I upgraded Gnucash from ver 3.2 to 4.4 (Mac OS 10.15).? My custom invoice layout changed.? Particularly, the Client information, which was flush with the left margin, is now moved much toward the center. Business information is OK. It is a trivial issue, but can the Client information be moved back to the left margin?? Edit--Style Sheets does not appear to be the answer. I created a new custom invoice (based on Easy), but it had the same issue. ___ 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] Minor issue with invoice layout
Hello, I upgraded Gnucash from ver 3.2 to 4.4 (Mac OS 10.15). My custom invoice layout changed. Particularly, the Client information, which was flush with the left margin, is now moved much toward the center. Business information is OK. It is a trivial issue, but can the Client information be moved back to the left margin? Edit--Style Sheets does not appear to be the answer. I created a new custom invoice (based on Easy), but it had the same issue. I haven't followed this forum for quite a while; thus, I apologize if invoice layout has been discussed (please point me to the information). 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 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] GnuCash 3.3 invoice layout questions
Mac OS 10.9 1. I use a custom style sheet. With GnuCash 3.2, everything, by default, appeared OK (e.g., table padding). With ver 3.3, I had to increase the table cell padding (from 1 to 5) in Edit-Style Sheet-Tables. OK, but now there is a large amount of space between the image at the top and the customer and business addresses. 2. Ver 3.3, shows the invoice number twice, in the upper left; it appears only once with ver 3.2. I found many entries for "invoice title" in "invoice.scm", but I'm not clear what, if anything, to change. 3. Ver 3.3 shows the date twice, above and below the business address on the right. Possible to remove the one below? 4. Is it possible to change the positions of the Date, Due, and Terms? Ver 3.2, they were on left below customer address; ver 3.3, they are above business address. Note that item #1 is related to the style sheet. The other three items behave as described prior to applying the style sheet (i.e., they occur in the default Easy Invoice). Sorry for the many questions. 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 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] Minor: Why does Cmd-H open Guide?
Minor, yet issue: Gnucash 3.2 (and earlier), Mac OS 10.9 and 10.12. The keyboard shortcut Command-H is assigned to "Hide Gnucash," the same shortcut for hiding all Mac applications. Cmd-H does hide Gnucash, but it also simultaneously opens my default web browser, which comes frontward to display the HTML version of the Tutorial and Concepts Guide. I'd very much like for Cmd-H to not open the Guide. I contemplated removing the Guide folder from /Applications/Gnucash 3.2/Gnucash.app/Contents/Resources/en.lproj, but I feared a serious crash or freeze when later invoking Cmd-H. Thank you, Howard Fried ___ 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.