Re: [GNC] Report - Income Statement - Layout problem
I stand corrected, this can happen regardless of the depth preference. The issue is entirely caused (best I can tell) by using separate tables for the Income & Expense sections. Since the browser will adjust the label column to fit the content, if those content widths differ, you'll see misalignment. In my case, due to some long account names, my Income section was slightly wider than the Expense section despite being depth limited to 4. (the reverse of the OP's image and what I found at depth > 4) The quickest solution is simply to put the Income & Expense sections in one HTML table element. This will cause the browser to size all 1st elements on each row to the same maximum to fit the widest content. (effectively sizing the first column all the same) There might be a complication with the ordering since there is a report option to turn off 'default Income section first' in the report. One small additional issue, is that this approach provides no spacing between sections. This can be solved by adding: after the first section's total row. (this generates a blank table row with content height as a visual spacer, which can be adjusted with a font-size declaration if desired.) I don't like that approach, but it is quick and easy. (the report HTML is full of presentation hacks, and one such hack, possibly causing this problem, is the use of being inserted as an account label indention mechanism rather than generating additional columns.) I'm not sure of the table semantics with this approach either. Technically, the report is a single entity, so perhaps a single table is better in that regard even though each section has its own subtotal. I did play with adding cell padding-right to the first label-cell and it worked, but that requires some calculation based on which column will end up wider, and very likely a magic number or two for refinement, so that's likely out as a solution. It might also be possible to calculate and add em-based padding-left to the account label cells, (rather than multiple entities) but that doesn't really solve the variable overall column-width problem. (it just changes how the indention is accomplished) Fixed-width would very likely be a mess too. (and still have to be calculated, and that might break on a per-browser basis) There might still be an out playing with box-sizing and/or display properties but I don't really see any magic happening since the widths are calculated independently. One final stretch might be to play with the size of the containers of the two tables, but I seriously doubt it as that affects overflow usually, not expanding something smaller. Regards, Adrien On 3/21/22 9:47 PM, Adrien Monteleone wrote: For me, this only happens at depths 5,6, & 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] Have you abandoned gnuCash email list? U were so helpful!
It can, you just have to be mindful to make your posting dates (AR and AP) match your payment dates. This requires either delayed posting, (and losing the Due Reminders feature) or un-posting and re-posting as payments are made and received. Regards, Adrien On 3/21/22 4:00 PM, Michael or Penny Novack wrote: What it can't do is support the "business features" like invoicing except accrual basis. That's awkward for those organizations that would like to send members/donors "statements". Also awkward for those rare businesses that cannot/should not consider product shipments as sales (yet) because are on an "approval" 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 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] Have you abandoned gnuCash email list? U were so helpful!
Yeah, I got one too. I'm still here of course. I took a break last fall, but have been fairly active since returning. Regards, Adrien On 3/21/22 3:17 PM, David Carlson wrote: Fran_3, I did not see your original message. Did you send it directly to Christopher instead of the list? That is seriously discouraged, and the primary reason that I thought that was phishing. ___ 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] Report Help
Another option would be to create a multicolumn report with two Account Summary reports side by side-- one set to the start date, the second to the end date. On March 21, 2022 9:24:14 PM EDT, Adrien Monteleone wrote: >The Account Summary is a snapshot, that's why it doesn't let you select >a range. (similar to a Balance Sheet) > >Your other options are an Income Statement/P (which won't show >anything but Expense & Income accounts) or perhaps an Equity Statement >or the Balance Sheet which includes Equity, Assets & Liabilities. (which >again, are snapshots and rolls Income/Expense into Equity) > >The closest to the Account Summary with a date range is the Trial >Balance Report. (be sure to set Account Depth to 'All' on the Accounts >tab in Options) > >You can get sort of close with a Transaction Report if you select all >accounts on the Accounts tab, clear everything *but* Account Name & >Totals on the Display tab, set your desired date range on the General >tab, and then select "Show subtotals only (hide transactional data)" on >the Sorting tab. > >Regards, >Adrien > >On 3/19/22 10:39 AM, Brock Rycenga wrote: >> Hello, >> >> Looking for help with [custom] reports. I like the look of the Account >> Summary report, but there is no way to fully customize the date range (only >> a starting date, or ending date - not both). I like that report format the >> best because it shows the account hierarchy with a total for the top level >> of any account with sub-accounts. Anyone know how to do this with a >> transactional report? Is there another report I should start with to get >> the look/feel of the Account Summary report, but with a fully custom date >> range? > >___ >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] Report - Income Statement - Layout problem
I can reproduce with 4.9 on BigSur. Investigating using Firefox Inspector to view the HTML, I see that there is padding being added to the Expenses section. For me, this only happens at depths 5,6, & ALL. It seems the left hand column where the labels are, is expanding to fit the depth of accounts requested *and* the text of those account names. In my case, my Expense depth is greater than my Income depth. (which is capped at 4, and thus why I see the bug appear at 5 or higher) I also happen to have a few accounts with long names, so the effect is not as great for me as for the OP, but it seems this string length will influence the calculated width. The effect shows up because the Expense section and the Income section are two separate HTML tables, and thus their columns are sizing independent of each other to contain their respective content. One possible fix (while still using tables) is to make the entire report a single table though that would of course require a bit of visual tweaking to get back to what it looks like now. In the meantime, I'm investigating replacing the inserted '' as an account label indention mechanism, with something else. (either another empty and thus another column, or a means to pad the cells via CSS) There might be a 'non-table' solution, but that too would take quite a bit of investigation and a complete re-write of the report(s) affected. Regards, Adrien On 3/20/22 5:02 PM, John Ralls wrote: I can't reproduce that here. Does that happen with all of the stylesheets? Have you perhaps modified the Technicolor stylesheet so that the Revenue block is smaller than the Expenses 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 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] Report Help
I have some custom reports (not my own, from other users posted on this list) that have worked in 3.x. But they did need some tweaks to get them working in 4.x. This is due to changes in the report system. Also try to reach out on IRC. The devs hang out there (as well as here) and can assist more with tracking down the failure and maybe point you to where to research for a solution. Before going any further, make sure you know how to run GnuCash from the command line and obtain a Tracefile so you can see any errors reported. Regards, Adrien On 3/20/22 4:28 PM, David T. via gnucash-user wrote: Well, I see that you put a note in that section saying it didn't work in 4.6 last September, so you are already aware of this fact. Since in my 17 years (!) of using gnucash I have never succeeded in creating or even loading a custom report-- and believe me, there were times when I really tried--I will not attempt to offer you advice with your custom report problem, whatever it may turn out to be. I *will* say that you'll have better success if you tell people what you're trying to accomplish, and what specifically the problem is that you've encountered. Telling us the page is broken is just noise and serves no purpose. It's clear from the page history that you know how that content came into being (i.e., Gnucash users), and also how it can be changed. So once you figure out what does work, you can update the wiki for everyone else. ___ 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] Report Help
The Account Summary is a snapshot, that's why it doesn't let you select a range. (similar to a Balance Sheet) Your other options are an Income Statement/P (which won't show anything but Expense & Income accounts) or perhaps an Equity Statement or the Balance Sheet which includes Equity, Assets & Liabilities. (which again, are snapshots and rolls Income/Expense into Equity) The closest to the Account Summary with a date range is the Trial Balance Report. (be sure to set Account Depth to 'All' on the Accounts tab in Options) You can get sort of close with a Transaction Report if you select all accounts on the Accounts tab, clear everything *but* Account Name & Totals on the Display tab, set your desired date range on the General tab, and then select "Show subtotals only (hide transactional data)" on the Sorting tab. Regards, Adrien On 3/19/22 10:39 AM, Brock Rycenga wrote: Hello, Looking for help with [custom] reports. I like the look of the Account Summary report, but there is no way to fully customize the date range (only a starting date, or ending date - not both). I like that report format the best because it shows the account hierarchy with a total for the top level of any account with sub-accounts. Anyone know how to do this with a transactional report? Is there another report I should start with to get the look/feel of the Account Summary report, but with a fully custom date range? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to create Transaction Report Filter on Checking to only show Accounts Payable Transactions?
Fran On the Accounts tab in Options for the report, choose "Filter Type: Include Transactions to/from Filter Accounts" and then in Filter By... choose the Accounts Payable account. You can further refine the results using the Filter tab, to specific Description/Notes/Memo as you are already familiar doing so. Another option is from the Accounts tab of the main GnuCash window, do a Find where your accounts match the bank account *and* Accounts Payable and then any other criteria. Then run an Account Report on the search results. Regards, Adrien On 3/18/22 9:58 AM, Fran_3 via gnucash-user wrote: I struggle with the Transaction Report Filter. The Situation:If I create a Transaction Report on Checking for last year...- I can enter key words from the Description field or from the Memo/Notes field...- into Transaction Filter field...- and it works fine...ButIf I enter "Accounts Payable" into the Transaction Filter field... it does not work.Ditto if I enter "Transfer from/to = Accounts Payable" The Question:How do I filter a Transaction Report on Checking to only show Accounts Payable transactions? ___ 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 Re: Transaction Report on Expenses, All Children, for 2021
Fran, Do a bit of reading on 'Accrual' vs. 'Cash' accounting. The Business Features of GnuCash are designed for the Accrual method. With a bit of small fuss, they can be used for the Cash method too. Expenses in the Accrual method are 'recognized' when 'incurred'. That is, when you 'owe' the money to whomever you purchased something (good or service) that is when you incurred the expense, not when you happen to get around to physically paying their invoice. The idea here is that you are recording expenses in the same period that you use those expenses (good or services) to generate revenue. A similar process takes place with Sales. You 'earn' Revenue when the sale is made (usually upon 'good delivery') and the actual timing of the receipt of payment is not part of when you made the sale. (your vendors 'earn' their revenue when they deliver a good or service to you, not when you pay them, which is why you incur the expense at their point of 'good delivery' as that is when you legally 'owe' them.) Accounts Receivable and Accounts Payable are used to track actual payments made and received, while still recording the expenses and revenue when they are incurred and earned. Now, read up on the 'Matching Principle' of accounting. It will explain why it is done this way. With the Cash method, you aren't concerned with when you incur expenses or when you earn revenue, but when you make payment or receive payment. For businesses that pay for inventory up front, and receive payment at the exchange of goods, this makes sense. For businesses that purchase on credit and sell on credit, it is a mess and makes little sense. (it also makes it difficult to analyze your historical sales activity and expenses, because they don't match each other.) For this reason and for these cases, Accrual accounting is employed rather than the Cash method. - What it appears you are describing is that you are using the Business Features as normal, and thus using the Accrual Method, but for some reason (not yet explained) you want an Expense Report on a Cash Basis. That's fine, but beware, if your accounting is supposed to be on a Cash Basis, you should probably alter your GnuCash workflow to assist with this and make reporting easier and more accurate. And if not, then sure, you can still generate Cash Basis reports as you found out. Regards, Adrien On 3/18/22 9:50 AM, Fran_3 via gnucash-user wrote: My Bad. Expenses are created when the bill is posted... not when it is paid.Here is how it works...1 - Get Bill from Vendor X2 - Post bill from Vendor X to AP3 - Charge bill to Expense Acct Whatever4 - Pay Bill and Charge Checking Account and relive AP So to get all expenses paid in 2021 you would create a Transaction Report on the Checking Account for the time period you desire...And set the Sorting Option Primary Key to "Other Account"And then lookup Accounts Payable Total in the results. And if you know how you could set the Transaction Report Filter to only show Checking Transactions charged to Accounts Payable...I'm posting another thread on that... more properly titled... to help other poor souls... like me :-) On Thursday, March 17, 2022, 07:58:14 PM EDT, Fran_3 via gnucash-user wrote: Situation: We posted a bill in 2020 but paid it in 2021. I need to create an Expense report for all expenses paid in 2021... regardless of when the bill was posted... My attempted solution:I created a Transaction Report on "Expenses" with "All Children" selected...And with a date range of 1/1/2021 to 12/31/2021 The Problem:The payment for the 2020 bill does not show in the report...Even though the expense was paid in paid in 2021. How can I create a report that will show all expenses paid in 2021 regardless of when the bill was posted? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] gnucash-user Digest, Vol 228, Issue 33
As I noted in another reply today, if this is just a handful of products, you can likely set up a simple spreadsheet to do the assembly math for you, and then import the result to GnuCash. While spreadsheets aren't part of GnuCash, we can help with how to set that math up, and in a form ready for export/import if you want to go that route. Otherwise, there are other inventory management apps out that that can generate the resulting accounting transactions ready for import. Some of them are not terribly expensive, and some are OpenSource and also Free. (as in beer) Though the Free apps may come with features you don't need, and will be a bit of a learning curve to set up for your business. Regards, Adrien On 3/17/22 4:42 PM, Frederick wrote: Thanks for the information and suggestion David. Not on any kind of a significant scale, just a one person operation making a modest living. I own and am using an old version of Sage 50 currently (and happy with it!), but they want $600 annually for the “subscription” service now offered. My version is having problems getting “authorized” by Sage when i open the program and it will not work when i switch to Windows 11. I do not make enough to justify $600 for accounting software, but i may be my only option. I am looking for a free or at least reasonably priced alternative. ___ 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] Printing checks
Someone more familiar with printing checks will hopefully chime in, but I seem to recall a recent thread where it was noted that if your Vendor/Employee/Customer 'payee' is already set up with name and address, *and* you try to 'Print Checks' with the existing transaction selected, GnuCash *should* auto-populate that info for you. As to why you can't edit it otherwise, I'm not certain. Regards, Adrien On 3/17/22 12:24 PM, ja...@ljmiller.com wrote: Just set up GNUcash. Print Check window shows a list of options, but only the default, Quicken/QuickBooks(tm) US-Letter is available. I need to use Quicken(tm) Wallet Checks w/side stub, as that is the paper I have on hand, having migrated from QuickBooks. When I choose this option, I am unable to type in a name or address-box is gray. I welcome any suggestions as to how to access the needed 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 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 Assemblies
Fred, please be sure to always copy the list address on all replies so the discussion stays on the list. That way, others can benefit from the discussion, as well as chime in and help out. Also keep in mind, we don't give accounting advice here. If you need such advice, you need the services of an accountant. But once you know 'what' to do, we can help you with the 'how to do it in GnuCash.' - I am not familiar with Sage so I can't explain how GnuCash works in reference to what you were doing before. There is no inventory management in GnuCash. You can set up accounts to track the *value* of your inventory, but not the quantity. (at least not out of the box, and without lots of work) You should make entries when you purchase ingredients/materials. Then you should make entries when you assemble or make something from those. Then you make more entries when you sell the assembled products. Basic Accounting Generic Examples - When you purchase ingredients for soap: Dr. Assets:Inventory:Raw Materials Cr. Assets:Bank This 'moves' money from your bank account to 'Raw Materials'. (which is now in the form of Inventory, so this records the value of that inventory) When you make the soap: Dr. Assets:Inventory:Work In Progress Cr. Assets:Inventory:Raw Materials This moves that value from Raw Materials to inventory 'in production' but not yet finished. (this step may be optional for you if the time involved in production is rather short, like one day or less and you package as part of the basic production process.) When you package the final product ready for sale: Dr. Assets:Inventory:Finished Goods Cr. Assets:Inventory:Work In Progress This moves the value from 'in production' to its final state as a Saleable Good or Finished Product. When you sell a finished product: Dr. Assets:Cash Cr. Revenue:Sales Dr. Expenses:Costs of Goods Sold Cr. Assets:Inventory:Finished Goods For this last one, the value of the first two splits should be equal, and the value of the last two splits should be equal. (but they will of course be less than the first two, or else you aren't making a profit!) The first two splits record the receipt of payment (could be 'Undeposited Funds' if by Credit Card or Paper Check instead of 'Cash') and 'recognizes' the revenue earned. (by type, in this case 'Sales Revenue') The second two splits move the value of the inventory sold out of inventory entirely, and records it as an expense of doing business. (which will eventually be subtracted from revenue to obtain 'income', Revenue - Expenses = Income) The Profit & Loss Report or Income Statement Report (same report - different names) will handle that math for you. Your actual transactions may differ, but this is a 'big picture' overview of the generic inventory-to-sales process. -- The math for figuring out the value of raw materials that go into a product that you'll need for making those 'in progress'/'finished goods' entries in GnuCash is something you're going to have to setup outside of GnuCash in a spreadsheet or other inventory management software. If you like, it is possible to export the result from the spreadsheet or other software into GnuCash so you don't have to manually cross-enter anything. If you only have one or a small handful of products you only need do the math by hand once, and then you can just duplicate those transactions changing the dates. You can also put in the Memo fields the proportions of each ingredient as a reminder, then enter that as a math equation in the transaction instead of just a final number. GnuCash can do the calculations for you. -- There are no shortcuts if you're going to do your own accounting. You just have to learn it. It really isn't difficult, and you don't have to learn 'all' of accounting, just what you need for your business. (and you won't learn it all at once, most likely, as you find out you need to know it) Accounting is not about difficult or fancy math. The hard part is learning 'how to account' properly for your activity. That's it. Regards, Adrien On Mar 17, 2022 w12d76, at 10:20 AM, Frederick wrote: Hi Adrian, thanks for your response. Unfortunately i am a bit confused by it, however. I am sure this comes from being as guy who makes soap and the accounting is done, only as a necessity and not by way of my profession. I am definitely trying to avoid taking an accounting course (-: I am a maker of stuff that wants to track assembly-build (Sage 50 terms) as i do now with my Sage 50 software. I set up my system to purchase ingredients and then Assemble-Build these ingredients into finished goods that i sell. I track quantities and value of ingredients and finished goods. I am looking for a different platform to do this tracking, both monetary and quantity. It sounds like you are saying the monetary tracking is possible but the quantity/item
Re: [GNC] Have you abandoned gnuCash email list? U were so helpful!
On 3/21/2022 2:58 PM, Fran_3 via gnucash-user wrote: even though I wish it could also generate reports on a cash basis... as opposed to an accrual basis... but I can get there by exporting select gnuCash accounts and Transaction Reports to cvs files and then loading them into Google Sheets or Excel. Thanks.Fran LeeFlorida Gnucash certainly can keep books on the cash basis << all the orgs I kept books for were cash basis >> What it can't do is support the "business features" like invoicing except accrual basis. That's awkward for those organizations that would like to send members/donors "statements". Also awkward for those rare businesses that cannot/should not consider product shipments as sales (yet) because are on an "approval" basis. 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] Have you abandoned gnuCash email list? U were so helpful!
Fran_3, I did not see your original message. Did you send it directly to Christopher instead of the list? That is seriously discouraged, and the primary reason that I thought that was phishing. On Mon, Mar 21, 2022 at 1:58 PM Fran_3 wrote: > Not phishing. I use gnuCash each year for a 2 or 3 weeks to help 3 very > small entities here in Florida. > They make the data inputs during the year and I try and help them organize > their annual financials for their tax guy to do their taxes. > > That said, I am not an accountant but I know enough to get by with a > little help from the great gnuCash forum members. > > And, I will say that I am a big fan of the program... even though I wish > it could also generate reports on a cash basis... as opposed to an accrual > basis... but I can get there by exporting select gnuCash accounts and > Transaction Reports to cvs files and then loading them into Google Sheets > or Excel. > > Thanks. > Fran Lee > Florida > > > > On Monday, March 21, 2022, 10:45:36 AM EDT, David Carlson < > david.carlson@gmail.com> wrote: > > > That looks to me like it was an exceptionally well crafted phishing email > > On Sun, Mar 20, 2022 at 8:20 PM Christopher Lam > wrote: > > On Sun, 20 Mar 2022 at 14:34, Fran_3 wrote: > > > (snip). > > > Now I don't see you participating and it seems traffic on the list is way > > down. > > Have the developers abandoned the project? > > > > Thank you Fran; no, the project is alive as long as there is interest in > it. The number of live bugs seems to be decreasing, hence the slow decline > in traffic. It seems the community is being very helpful, thus there's > little need to intervene. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > > > > -- > David Carlson > > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Have you abandoned gnuCash email list? U were so helpful!
Not phishing. I use gnuCash each year for a 2 or 3 weeks to help 3 very small entities here in Florida.They make the data inputs during the year and I try and help them organize their annual financials for their tax guy to do their taxes. That said, I am not an accountant but I know enough to get by with a little help from the great gnuCash forum members. And, I will say that I am a big fan of the program... even though I wish it could also generate reports on a cash basis... as opposed to an accrual basis... but I can get there by exporting select gnuCash accounts and Transaction Reports to cvs files and then loading them into Google Sheets or Excel. Thanks.Fran LeeFlorida On Monday, March 21, 2022, 10:45:36 AM EDT, David Carlson wrote: That looks to me like it was an exceptionally well crafted phishing email On Sun, Mar 20, 2022 at 8:20 PM Christopher Lam wrote: On Sun, 20 Mar 2022 at 14:34, Fran_3 wrote: > (snip). > Now I don't see you participating and it seems traffic on the list is way > down. > Have the developers abandoned the project? > Thank you Fran; no, the project is alive as long as there is interest in it. The number of live bugs seems to be decreasing, hence the slow decline in traffic. It seems the community is being very helpful, thus there's little need to intervene. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Report - Income Statement - Layout problem
Hello, Yes, it happens with all the stylesheets. No, I haven't modified any of the stylesheets. Thank you for your help Best regards Carl-Kensaku HERBORT DIGIENE Case postale CH-1002 Lausanne Suisse +41 (0) 21 320 22 66 Le 20.03.22 à 23:02, John Ralls a écrit : I can't reproduce that here. Does that happen with all of the stylesheets? Have you perhaps modified the Technicolor stylesheet so that the Revenue block is smaller than the Expenses one? Regards, John Ralls On Mar 20, 2022, at 9:51 AM, Carl-Kensaku HERBORT wrote: Hello, The effective nesting level is the same. No, I don't need an option to justify columns. I just need the income statement report to look as normal as the balance sheet report (see screen capture). I really don't need anything more. Have a nice week-end Best regards -- Carl-Kensaku HERBORT DIGIENE Case postale CH-1002 Lausanne Suisse +41 (0) 21 320 22 66 Le 20.03.22 à 16:27, Michael or Penny Novack a écrit : On 3/20/2022 5:21 AM, Carl-Kensaku HERBORT wrote: Hello again, I have tried a more recent version on MacOS (Version 4.9 / build ID 4.9+(2021-12-18) / Finance::Quote:-). It solves the first problem of string translation. But the second problem is still there: the width and column alignment of the revenue part is not synchronized with those of the expense part. Do you have any ideas ? You did not say is the effective nesting level of income and expense the same? Even if so, the resulting report would not be what I wanted in a report in the final form I would be presenting to the board at meetings or having published in an annual report << I used to be treasurer of some 501(c)3 organizations and used gnucash to keep the books >> I suspect that what you want (from the developers) is an option to "justify columns from the right". That's what I would have in the "finished product" reports. In the case of the Income Statement (Statement of Revenues and Expenses --- what a non-profit calls this report) but also with Balance Sheet reports. Instead of writing custom reports* I export and then edit with full control over the level of detail in different parts, column alignment, etc. and can add annotation as needed. There is a lot of detail work** in producing a "pretty print" report. Michael D Novack * I am a retired pro. While not fluent in the language used to create the reports, I can at least read LISP and so soon could be << when you have written in half a dozen languages, what's one more >> But the first time this came up, I was advised not to bother, just export raw reports and edit to the finished product. Great editors already exist so why try to reinvent the wheel. ** For example, page breaks. You don't want them at an awkward place in the report so might want to insert some blank lines to prevent that. You might want top levels or total lines a different font size or bold, et. ___ 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. <2022-03-18-11h36-gnucash-balance-sheet-report.png><2022-03-18-11h37-gnucash-income-statement-report.png>___ 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] Have you abandoned gnuCash email list? U were so helpful!
That looks to me like it was an exceptionally well crafted phishing email On Sun, Mar 20, 2022 at 8:20 PM Christopher Lam wrote: > On Sun, 20 Mar 2022 at 14:34, Fran_3 wrote: > > > (snip). > > > Now I don't see you participating and it seems traffic on the list is way > > down. > > Have the developers abandoned the project? > > > > Thank you Fran; no, the project is alive as long as there is interest in > it. The number of live bugs seems to be decreasing, hence the slow decline > in traffic. It seems the community is being very helpful, thus there's > little need to intervene. > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
